Time value of money Finding FV (5) ke (1) KAN yous po Y $1,000 55 Formas 0 Creating a table with FVs at various interest rates and time periods using Data Table Your they LOO 10 Chaling graph with your on the horizontal ass and on the vertical SH At a Formas H 1000 M. 111111 D 38 A 39 c. Finding PV 40 Future value (FV) 41 Discount rate (1) 42 Number of years (N) 43 Present value (PV) 44 45 d. Finding the rate of return provided by the security 46 Cost of security (PV) 47 Future value of security (FV) 48 Number of years (N) 49 Rate of return (1) 50 B 54 Doubled population in millions (FV) 55 Number of years required to double (N) $1,000 12% 6 57 f. Finding the PV and FV of an ordinary annuity 58 Annuity (PMT) 59 Interest rate (1) 60 Number of years (N) 61 Present value of ordinary annuity (PV) 62 Future value of ordinary annuity (FV) 63 $1,000 $4,000 51 e. Calculating the number of years required to double the population 52 Current population in millions (PV) 53 Growth rato (1) 6 ON/A 34.7 2% $1,000 16% Formulas #N/A 6 ONA N/A D NA UA 64 g. Recalculating the PV and FV for part f if the annuity is an annuity due 65 Present value of annuity due (PV) WNIA WN/A 66 Future value of annuity due (FV) Sheet1 G H 64 g. Recalculating the PV and FV for part f if the annuity is an annuity due 65 Present value of annuity due (PV) 66 Future value of annuity due (FV) ON/A ANIA 67 68 h. Recalculating the PV and the FV for parts a and c if the interest rate is semiannually compounded 69 Future value (FV) 70 Present value (PV) PN/A NA 71 72 1. Finding the annual payments for an ordinary annuity and an annuity due 73 Present value (PV) $1,000 74 Discount rate (1) 11% 75 Number of years (N) 12 76 Annual payment for ordinary annuity (PMT) 77 Annual payment for annuity due (PMT) 78 79. Finding the PV and the FV of an investment that makes the following end-of-year payments 80 Year Payment 81 $100 02 183 64 85 Interest rate (1) 86 Present value of investment (PV) 87 Future value of investment (FV) 1 2 3 AN/A #N/A $200 $500 ANJA ANA 88 89 k. Five banks offer the same nominal rate on deposits, but A pays interest annually, B pays semiannually, C pays quarterly, D pays monthly, and E pays daily 90 (1) Calculating the effective annual rate for each bank and the future values of the deposit at the end of 1 year and 2 years 91 Nominal rato (c) 9% 92 Depost (PV) $5,500 Five banks offer the same nominal rate on depoats, but A pays interest annualy, pays setannualy, C pays quarterty, D pays monthly, and pays daly 30 (1) Calculating the effective annual rate for each bank and the future values of the deposit at the end of 5 year and 2 year V 32 (P unter des pro CAR Vaher 1 year Fair 2 THE M 10) Catating the nominal rates that will cause all of the hes to provide the same effective annual A HOTE 102Nola ) MO 104 Calculating the amount of payment to be made my for A samemusly for quarterly for many for yo 430 de der of ye PM) TH 11 Setting up the amortization ch HE 0 sy 16 Apr MT Sheet $5,000 ( Th SHADE Formul EAR FVater 1 year FVy pantof Nel (9) MIL 19 Payment (PMT) 110 11 Setting up the amortization schede Ognal amount of more de(1) ru 114 Temmurly, yes() INAW 1 A (n THE ALL SAN 32 m MA 420 ON MA IW At the Creating graph that shows how the payments are divided between vierest and principal repayment over t UN IM 190 THE feve Sheet $14,000 SHED Payment Forms of Proceed Form (7) H