Financial Formulae reference sheet

< Back to Search results

 Category: [Excel]  Demo Available 

Financial formulae reference sheet


Calculates depreciation based on the fixed-declining balance method


Calculates depreciation based on the double-declining balance method


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


– the interest rate on a fully invested security


This formula returns the interest payments on a debt security


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


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





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


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


Calculates the present value of an investment


Calculates depreciation based on the straight-line method



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


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


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.




stars (0 Reviews)