Question: 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
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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock