Question: Hello, I’ve Been Working This Question On Life Cycle Analysis And Present Values In Engineering Economy. I Want To Figure Out How To Do This Question Via Excel Functions, I Presume It’s Using: ” = NPV ” Or ” = PV ” Perhaps I’m Wrong My Answers Is Slightly Off From The Responses Given On This Assignment, The Correct Answer Is Highlighted. Please Use …

Cash flows of two mutually exclusive projects are as follows. Project A costs $80,000 initially and will have a $15,000 salvage value after 3 years. The operating cost with this method will be $30,000 per year. Project B has initial cost of $120.000, an operating cost of $8,000 per year, and a $40,000 salvage value after its 3-year life. Assume the interest rate is 12% per year. Which of the following statements is true? The present worth of project B is -$110.743.44. The present worth of project A is -$141,252.17. Project A should be selected. Two projects have different life cycle. G13 =NPV(B13,67:910)+G6 A B C D E H 1 Life Cycle Analysis: PW 2 3 4 5 Project A $80,000 Project B $120,000 6 Initial Cost 7 Project A Project B ($80,000) ($120,000) ($30,000) ($8,000) ($30,000) ($8,000) ($30,000) ($8,000) $15,000 $40,000 8 Salvage Value $15,000 $40,000 9 10 Operating cost $30,000 $8,000 11 12 Int Rate 13 0.12 ($142,522.17) ($113,793.93) 14 15 Life Time (Years) 16 3 17