I need help solving this problem in excel my answer is not coming out the way, I expect it to come out. I am trying to figure it out. can you help please.
(10 points) Question 23 A firm is considering purchasing a machine to increase the firm's production capacity. The firm will invest $10,000 in the initial purchase of the machine and will spend $1,850 per year on maintenance. The machine will last 10 years and will have a salvage value of $1,250. The machine provides 4,456 of annual benefits. If the firm's MARR is 15%, what is the Equivalent Uniform Annual Worth (EUAW) of the machine? (Hint: Find the Uniform Series Cash Flow) $675 b. $551 $882 d. $1,850
53 question 23 Item 156 First Cost (invest) Uniform Annual 157 Benefit 158 Uniform Annual cost 159 Salvage Value 160 Useful Life in Years 161 162 PV of FC 163 PV of AB years 164 PV of AC years 165 PV of SV 166 NPV 167 Machine 1 $10,000 $4.456 ($1,850) $1,250 10 ($10,000) $22,363.63 (59,284.72) $308.98 $3,388 PV FV -ZAU N 15%
I need help solving this problem in excel my answer is not coming out the way, I expect it to come out. I am trying to f
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am