OzGrid

Financial Formulae reference sheet

< Back to Search results

 Category: [Excel]  Demo Available 

Financial formulae reference sheet

=DB 

Calculates depreciation based on the fixed-declining balance method

=DDB  

Calculates depreciation based on the double-declining balance method

=FV

Calculates the future value of an investment with constant periodic payments and a constant interest rate

=INTRATE

– the interest rate on a fully invested security

=IPMT

This formula returns the interest payments on a debt security

=IRR

This formula calculates the internal rate of return (discount rate that sets the NPV to zero)

=NPV

calculates the net present value of cash flows based on a discount rate

PV = Present Value

F = Future payment (cash flow)

i = Discount rate (or interest rate)

n = the number of periods in the future the cash flow is

 

 

 

=PMT

This function returns the total payment (debt and interest) on a debt security

=PRICE

Calculates the price per $100 face value of a periodic coupon bond

=PV

Calculates the present value of an investment

=SLN 

Calculates depreciation based on the straight-line method

=XIRR

 

Calculates the internal rate of return (discount rate that sets the NPV to zero) with specified dates

=XNPV

Calculates the NPV of cash flows based on a discount rate and specific dates

=YIELD

Returns the yield of a security based on maturity, face value, and interest rate

 

See also:

Dates and time Excel formulas reference sheet
Conditional Functions Reference Sheet
Excel different types of data reference sheet
Useful formulae reference sheet
Financial formulae reference sheet
Index and match reference sheet
Lookup formulae reference sheet
Maths functions excel formulae sheet

 

Free Training Course: Lesson 1 - Excel Fundamentals

 

See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

 

 


Gallery



stars (0 Reviews)