solving and help answering please

nsert Page Layout Formulas Data Review w Momingstar ACROBRAT Tell me vehuat you want to de Tmes New Roma-10AA a Copy Format Painter Formatting Table Styles 16 Nsmerical Selaniew: PV+100 VI)+2000FVIFA 400P VIF) FVs. 100 "(108). + 200"(108' + 200"(1.08)200"(1.06). 400"(1) FV, 136.05+ 251.94+233.28+ 216+400 FV, 123727 18 In Words: The valbe of a cash flow of $100 in year 1, $200 in year 2,3, and 4 and 3400 in year :5 will be worth $1,237 27 at the end of the fifth year 24 25 Spreadsheet Solution: 27 28 Use formulas to fied you answer by completing the FV Tabile Teday Year Yea2 Year3 Yea4 Year 5 Solutien a teest Rate 32 c Cash Flow FV sterest factor 30 1First we mast cakculate the FY Interest Facter for each cash Bler in rew d.FVI ( In cel E33 eno the formda-Es04 and copy to ceds G13 and H3 You ment change the exposents egh 133 2 Them we fnd the FV of each cash few in rew e Lasty, we sm the FV's to get the TV of the anmuiy in cel 134 4 You answer should be The FV of the cash ows is $1237 27 Nate Y'eu can change any of the inpts and Escel will atomaticaly recompune In cell E4 ter he FV fmaCFxFVF -E32 E33 and copy to cels F4 dhroagh 1 4 1 Test your sas. What is the Funire Value if the interest rate is 5%7 read ne Tutorial DKLL