Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Thank you!

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Value

Authors: Stephen Penman, S Penman

1st Edition

0231151187, 9780231151184

More Books

Students also viewed these Accounting questions