1)Build the excel solutionsforquestion 4.5

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

Example 4-5 A machine costs $30,000, 0&M = $2000/yr. Savings = $10,000/yr. Salvage @ 5 yrs = $7000. / = 10%. PW = ?? P=-30,000 + (10,000 - 2000)(P/A, 10%, 5) + 7000(P/F, 10%, 5) = -30,000 + (8,000)(3.791) + 7000(0.6209) = $4672 A B C D E F G H ID n PMT PV FV Answer Formula 2 4-5 10% 5 8000 7000 -$34,672.74 =PV(82,C2,D2,F2) $34.672.74 -G2 A -30,000 4,672.74 =+G3+E4