Hi, can you please show me how this is done. How can i calculate this in excel using NPV ?

Thank you!

9 Connect 6 9 (3' 0 i eztomheducation.com/ext/map/index.htm|?,con=con&externaLbrowser=D&|aunchUrl:https%253A%252F36252Fnewoonnectmheduoation.com%252F#/activity/question-group/kEZASsBkE... fr 0 O *- x m MHEReader x | e Gammnllceijh'laJNALx x | Expensereponreuogleslleels x I oompmenetpresemvalueusing x l + O _ :9 X Chapter 13 Problems (45 marks) 0 Saved Help Save: Exit Submit 3 12.5 points eook Print Relerences Check my work Clean Duds Laundromat has an industrial water softener that enhances the water quality used in its washing machines. The water softener is approaching the end of its useful life and must be either overhauled or replaced. Details of the two alternatives are shown below. Ifthe company overhauls its current water softener. then it will be usable for eight more years. If, instead. a new water softener is purchased, it will be used for eight years. after which it will be replaced. The new water softener will be considerably more energy efficient, resulting in a substantial reduction in annual operating costs, as shown below: current New water water Softener Softener Purchase cost new $11,669 $14,505) Remaining book value $ 7,500 Overhaul needed now $ 5,589 Annual cash operating costs $ 7,509 $ 5,486) Salvage value now 3 2,665) Salvage value eight years From now 3 1,366) 3 3,606) Clean Duds computes depreciation on a straight-line basis. All equipment purchases are evaluated using a 16% discount rate. Required: (Ignore income taxes.) 1-a. Determine the present value of net cash flows using the total-cost approach. (Hint: Use Microsoft Excel to calculate the discount factor(s).l (Enterany cash outflows with a minus sign. Do not round intermediate calculations and round final answers to the nearest dollar amount.) Connect X M MHE Reader X Garrison11ce_SM_Ch13_FINAL.c x + Expense report - Google Sheets X Compute net present value using X + X C D A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group/kEZASsBKE.. Chapter 13 Problems (45 marks) i Saved Help Save & Exit Submit Check my work 3 Required: (Ignore income taxes.) 1-a. Determine the present value of net cash flows using the total-cost approach. (Hint. Use Microsoft Excel to calculate the discount factor(s).) (Enter any cash outflows with a minus sign. Do not round intermediate calculations and round final answers to the 12.5 nearest dollar amount.) points PV of Net Cash Flows eBook Purchase the new softener Print Upgrade and Keep the old softener References 1-b. Should Clean Duds Laundromat upgrade the old water softener or purchase the new one? O Purchase the new softener O Upgrade the old softener 2. Using the incremental-cost approach, determine the net present value in favor of (or against) purchasing the new water softener? (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Do not round intermediate calculations and round final answer to the nearest dollar amount.) Net present value Mc Graw Hill C O M 31 US 7 21:01