# OzGrid

Financial Formulae reference sheet

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

Free Training Course: Lesson 1 - Excel Fundamentals

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) 