| Financial functions | Use | example | example formula | reference |
| rate() | calculate interest rate of an annuity | what is the interest rate for a loan of $100 if it can be paied off in 12 periods with payment of $10 at the end of each period | 3% | https://exceljet.net/excel-functions/excel-rate-function |
| fv() | find future value of fixed payments | what is the future value of 5 payments of $20 at the end of each period, assuming we have $0 in our pockets now and interest rate of 3%? | ¥106.18 | https://exceljet.net/excel-functions/excel-fv-function |
| pv() | find present value of fixed payments | what is the price of a bond that pays 5 $20 coupons and principal payment of $100, using an interest rate of 3%? | ¥177.86 | https://exceljet.net/excel-functions/excel-pv-function |
| npv() | find net present value of cash flows | what is the net present value of $10, $20, and $30 at today, tomorrow, and two days later using a discount rate of 5%? | ¥53.58 | https://exceljet.net/excel-functions/excel-npv-function |
| pmt() | find fixed payment | what is the amount of payment at the end of each period if we want to pay down $100 to $20 in 5 periods, assuming interest rate of 5%? | ¥26.72 | https://exceljet.net/excel-functions/excel-pmt-function |
| nper() | find number of periods | how many periods (of payments) do we need to make if we want to pay off $100 by $20 payment at the end of each period, assuming interest rate of 5%? | 5.8963128604 | https://exceljet.net/excel-functions/excel-pmt-function |
qwerty12345
HW1TVMfinancialfunctions.xlsx
