Financial Functions
PMT(rate, nper, pv, [fv], [type]): Calculates the payment for a loan based on constant payments and a constant interest rate.
Example: =PMT(5%/12, 60, 15000) calculates the monthly payment for a $15,000 loan at 5% annual interest over 5 years.
FV(rate, nper, pmt, [pv], [type]): Returns the future value of an investment based on a constant interest rate.
Example: =FV(5%/12, 60, -100) calculates the future value of a 5-year $100 monthly investment at a 5% annual interest rate.
NPV(rate, value1, [value2], …): Returns the net present value of an investment by using a discount rate and a series of future payments.
Example: =NPV(5%, C1:C5) calculates the NPV for a series of cash flows in the range C1:C5 at a discount rate of 5%.
IRR(values, [guess]): Returns the internal rate of return for a series of cash flows.
Example: =IRR(C1:C5) calculates the IRR for a series of cash flows in the range C1:C5.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com