1)Build the excel solutionsforquestion 4.2

2)Also type the each formula usingExcel variables. Make sure i,P,F,A values are variables.

Example 4-2 Uniform Series; Multiple Cash Flows Initial deposit = $685; $375 deposited monthly. Interest rate = 6%, monthly compounding. How much is saved after 48 months? A B C D E F G H 1 ID i n PMT PV FV Answer Formula 2 4-2 0.5% 48 -375 -685 $21,156.97 =FV(B2,C2,D2.E2) F = 375(F/A, 0.5%, 48) + 685(F/P, 0.5%, 48) = $21,156.7