time_value_of_money_spreadsheets(1)

time_value_of_money_spreadsheets(1) -...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
4e8e65d05aff0db6435b7ce0b90b3dafa51bac92.xlsx Future Value of a Single Sum Interest Rate per Period (i%) 5.00% Number of Periods (n) 8 Present Value (PV) $150,000.00 1.47746 Future Value (FVF) $221,618.32 Present Value of a Single Sum Interest Rate per Period (i %) 8.00% Number of Periods (n) 3 Future Value (FV) $2,000.00 Factor = (1+r)n 0.79383 Future Value (PVF) - (B7*B9) $1,587.66 Future Value of an Annuity (Ordinary) Interest Rate per Period (i %) 8.00% Number of Periods (n) 3 Future Value (FV) $2,000.00 Factor = (1+r)n 3.24640 Future Value (PVF-OA) - (B7*B9) $6,492.80 Present Value of an Annuity (Ordinary) Determining Loan Payments Interest Rate per Period (i %) 12.00% Interest Rate per Period (i %) 5.00% Number of Periods (n) 5 Number of Periods (n) 6 Payments (in the future) $6,000.00 Payments $1,970.17 Present Value Factor [(1- 1/(1+i)n) / I] 3.60478 Present Value Factor = (1- 1/(1+i)n) / i 5.07569 Present Value (PVF-OA) $21,628.66 Present Value - Amount owed today. $10,000.00 Present Value of an Annuity (Due)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online