Please help me fill it out ! I dont mnow how to .
A M98 * D 6 K S Future value of an uneven Flow Stream 6 7 The Problem Your rich gut dhe lu petenised to pay you 5100 the and of this yox, 5200t the end of cvay you for the next these years, and one time payment of 5400 the end of the fifth you. You could invest all the cash flow 8% compounded wally, 8 What is this cash flow stream worth to you five years from today! 9 10 The bedded 11 12 13 14 15 Finano Cena: FV. - YCFAFVIF.. Future Value Summation of Cash Flow Future Value Inarest Factor Puture Value - CF,"+CF.COM+CF,"1+"+CF, C1+2+...+ CPM ltr 16 17 Nawani Selation: FV, -0+ 100 (FVIF.) +2006F VIFA.) + 400FVIF) 18 FV, - 100 (1.08 2009 (108) +200"(1.08 + 2009 (108) + 400 () 19 FV, = 136,05 +251.94 +233.28 +216 + 400 20 FV3 - 1237.27 21 In Words: The value of a cash flow of $100 in year 1, $200 in year 2. 3, and 4 and 5400 in year 5 23 will be worth $1,237.27 the end of the 6th year 24 25 Spreadsheet Solution: 26 27 Use formulas to find your answer by completing the FV Table 28 29 Today Year 1 Yar 2 Year Year 4 Year 5 Solution 30 Interest Rate 0.08 0.08 0.0 0.08 0.08 31 b Time 3 5 32 Cash Flow 100 200 200 200 33 DFV interest factor 34 Future Value 35 36 i First we must calculate the FV Interest Factor for ach cash flow in towd. FVIF 37 In cell 33 enter the formulx = (1+0) 4 and copy to cells 33 and H33 38 You must change the exponents in cells F33 through 133 39 40 2 Then we find the FV of each cash flow in rowe. In cell E34 enter the FV formula:CFFVIF-E32E33 and copy to cells F34 through 134 42 3 Lastly, we sum the FVs to get the FV of the annuity in cell 134. 44 In cell 34 etter the formula: sum E34:14) 45 46 4 Your answer should be: The FV of the cash flows is 51.237.27 47 48 Note: You can change my heapes and see will automatically compute. 51 Tot your skills 52 What is the Future Value if the islets 53 Copy and paste and that the table Interest PV PVCF FVCE MS + Ready 4 kaur CAD U Naur LAB_3_Kaur zip SON 3 al A B G M98 X fc C D 51 Tot your skills 52 What is the Future Value if the intarest rate is 5%? 53 Copy and paste (value) and then reset the table. Yars SS Spreadsheet Solution Solving for the Annuity Separately 56 57 58 Today Year 1 Your 2 Yarr3 Your Solution 59 Interest Rate 0.12 0.12 0.12 0.12 0.12 0.12 60 b Time 2 3 4 5 61 Cash Flow 100 200 200 200 400 62 dFV intarest factor 63 Future Value Annuity 64 Future Value 65 56 1. First we must calculate the FV Interest Factor for each cash flow in row d. FVIF(ltp 57 In cell E62 enter the formula - (1+E59)*4 and copy to cells F62 through 162 58 You must change the exponents in cells F62 through 162. 20 2. Then we find the FV of the embedded annuity by clicking on cell H63. 21 In cell H63 enter the FV annuity formula =FV/H59.3.-200) or use the wizard 2 3 3. Now we can find the Future Value of three cash flows in cells E64, H. and 164 -4 In cell E64 ster the formula E61E61 5 In cell H64 enter the formula 163162 6 In cell 164 cater the formula -167161 4. Lastly, we sum the FVs to get the FV of all the cash flows in od 364 In cell 164 cmier the formula sumE64:164) or sumE64 + H264 +164) 3. Your swer should be $1,313.22 is the FV of the cash flows. Test your skills: In this Table, you must fill in the inputs for the interest rate, time, cash flows Then you will write the tales for the FV incest actor, the formulas forach future value and then calculate the solution. Refer to the problems above for help. Today 0.05 Time 0.05 Your 0.05 Year 0.05 Years 0.05 Solution 3 100 EV is to Fure Value 0.05 4 500 1.08 325.00 1213 is. 1.10 11025 500 1.00 SOLO 1777.56 fepat tale HA EM Interest CEFVIF PV PVCI FUGE MS Ready BUT K TO G H WE GOUVEIKTIES DI LETO hell H63 astar the FV muity formula FVH593,200) or use the wiad 3. Now we find the Future Value of three cash flows in cells E64, H64, and 164 In cell E64 arter the formula -E61 362 hell H64 atar the formulk H63*762 In cell 164 antar the formule 162 161 4. Lastly, we sur the FVs to get the FV of all the cash flows in cell 164 In cell 164 enter the formula: sum E64:164) or UE64 + 164 +164) 5. Your answer should be: $1,313.22 is the FV of the cash flows. your skills In this Table, you must fill in the inputs for the interest rate, time, cash flows. Then you will write the formulas for the FV interest factor, the formulas for cach future value, and then calculate the solution. Refer to the problems above for help. Today 0.05 Interest Rate Time Cash Flow EV interest factor Future Value Year 1 0.05 1 100 1.22 121.55 Year 2 0.05 2 100 1.16 115.76 Year 3 0.05 3 100 1.10 Year 4 0.05 4 500 1.05 525.00 Year 5 Solution 0.05 5 500 1.00 500.00 1372.56 110.25 Formulas: Inputs: Tate: 0.05 cash flows years 1-3-100 years 45 - 500 FVIF = 1+1 FVCF. FVIF FV, PMTFVIFY Assume the interest rate is constant for all 5 years + A M98 * D 6 K S Future value of an uneven Flow Stream 6 7 The Problem Your rich gut dhe lu petenised to pay you 5100 the and of this yox, 5200t the end of cvay you for the next these years, and one time payment of 5400 the end of the fifth you. You could invest all the cash flow 8% compounded wally, 8 What is this cash flow stream worth to you five years from today! 9 10 The bedded 11 12 13 14 15 Finano Cena: FV. - YCFAFVIF.. Future Value Summation of Cash Flow Future Value Inarest Factor Puture Value - CF,"+CF.COM+CF,"1+"+CF, C1+2+...+ CPM ltr 16 17 Nawani Selation: FV, -0+ 100 (FVIF.) +2006F VIFA.) + 400FVIF) 18 FV, - 100 (1.08 2009 (108) +200"(1.08 + 2009 (108) + 400 () 19 FV, = 136,05 +251.94 +233.28 +216 + 400 20 FV3 - 1237.27 21 In Words: The value of a cash flow of $100 in year 1, $200 in year 2. 3, and 4 and 5400 in year 5 23 will be worth $1,237.27 the end of the 6th year 24 25 Spreadsheet Solution: 26 27 Use formulas to find your answer by completing the FV Table 28 29 Today Year 1 Yar 2 Year Year 4 Year 5 Solution 30 Interest Rate 0.08 0.08 0.0 0.08 0.08 31 b Time 3 5 32 Cash Flow 100 200 200 200 33 DFV interest factor 34 Future Value 35 36 i First we must calculate the FV Interest Factor for ach cash flow in towd. FVIF 37 In cell 33 enter the formulx = (1+0) 4 and copy to cells 33 and H33 38 You must change the exponents in cells F33 through 133 39 40 2 Then we find the FV of each cash flow in rowe. In cell E34 enter the FV formula:CFFVIF-E32E33 and copy to cells F34 through 134 42 3 Lastly, we sum the FVs to get the FV of the annuity in cell 134. 44 In cell 34 etter the formula: sum E34:14) 45 46 4 Your answer should be: The FV of the cash flows is 51.237.27 47 48 Note: You can change my heapes and see will automatically compute. 51 Tot your skills 52 What is the Future Value if the islets 53 Copy and paste and that the table Interest PV PVCF FVCE MS + Ready 4 kaur CAD U Naur LAB_3_Kaur zip SON 3 al A B G M98 X fc C D 51 Tot your skills 52 What is the Future Value if the intarest rate is 5%? 53 Copy and paste (value) and then reset the table. Yars SS Spreadsheet Solution Solving for the Annuity Separately 56 57 58 Today Year 1 Your 2 Yarr3 Your Solution 59 Interest Rate 0.12 0.12 0.12 0.12 0.12 0.12 60 b Time 2 3 4 5 61 Cash Flow 100 200 200 200 400 62 dFV intarest factor 63 Future Value Annuity 64 Future Value 65 56 1. First we must calculate the FV Interest Factor for each cash flow in row d. FVIF(ltp 57 In cell E62 enter the formula - (1+E59)*4 and copy to cells F62 through 162 58 You must change the exponents in cells F62 through 162. 20 2. Then we find the FV of the embedded annuity by clicking on cell H63. 21 In cell H63 enter the FV annuity formula =FV/H59.3.-200) or use the wizard 2 3 3. Now we can find the Future Value of three cash flows in cells E64, H. and 164 -4 In cell E64 ster the formula E61E61 5 In cell H64 enter the formula 163162 6 In cell 164 cater the formula -167161 4. Lastly, we sum the FVs to get the FV of all the cash flows in od 364 In cell 164 cmier the formula sumE64:164) or sumE64 + H264 +164) 3. Your swer should be $1,313.22 is the FV of the cash flows. Test your skills: In this Table, you must fill in the inputs for the interest rate, time, cash flows Then you will write the tales for the FV incest actor, the formulas forach future value and then calculate the solution. Refer to the problems above for help. Today 0.05 Time 0.05 Your 0.05 Year 0.05 Years 0.05 Solution 3 100 EV is to Fure Value 0.05 4 500 1.08 325.00 1213 is. 1.10 11025 500 1.00 SOLO 1777.56 fepat tale HA EM Interest CEFVIF PV PVCI FUGE MS Ready BUT K TO G H WE GOUVEIKTIES DI LETO hell H63 astar the FV muity formula FVH593,200) or use the wiad 3. Now we find the Future Value of three cash flows in cells E64, H64, and 164 In cell E64 arter the formula -E61 362 hell H64 atar the formulk H63*762 In cell 164 antar the formule 162 161 4. Lastly, we sur the FVs to get the FV of all the cash flows in cell 164 In cell 164 enter the formula: sum E64:164) or UE64 + 164 +164) 5. Your answer should be: $1,313.22 is the FV of the cash flows. your skills In this Table, you must fill in the inputs for the interest rate, time, cash flows. Then you will write the formulas for the FV interest factor, the formulas for cach future value, and then calculate the solution. Refer to the problems above for help. Today 0.05 Interest Rate Time Cash Flow EV interest factor Future Value Year 1 0.05 1 100 1.22 121.55 Year 2 0.05 2 100 1.16 115.76 Year 3 0.05 3 100 1.10 Year 4 0.05 4 500 1.05 525.00 Year 5 Solution 0.05 5 500 1.00 500.00 1372.56 110.25 Formulas: Inputs: Tate: 0.05 cash flows years 1-3-100 years 45 - 500 FVIF = 1+1 FVCF. FVIF FV, PMTFVIFY Assume the interest rate is constant for all 5 years +
