Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help solving this in excel show work and explain how you got answers please. Intro The Weather Company manufactures and sells 100,000 umbrellas per
need help solving this in excel show work and explain how you got answers please.
Intro The Weather Company manufactures and sells 100,000 umbrellas per year at an average price of $20. It currently uses a machine that makes each umbrella at a variabe cost of $10. The machine has a book value of $100,000 and has 5 years left in its economic and accounting life. Its annual depreciation is $20,000. It could be sold now for $80,000, but won't have any value in 5 years. The company could replace the old machine with a new machine that costs $800,000. The new machine produces the same number of umbrellas at a variable cost of $9, has a life span of 5 years and is to be depreciated on a straight-line basis to a salvage value of $80,000. Since the machine can make higher-quality umbrellas, the average sale price would increase to $22 The project's discount rate is 9% and the company's marginal tax rate is 21% Attempt 130 for 10 pts. Part 1 What is the annual cash flow in years 1 to 5 with the new machine? 0+ decimals Submit Attempt 1/30 for 10 pts. Part 2 What is the cash flow from salvage value from selling the old machine now? 0+ decimals Submit Part 3 Attempt 1/30 for 10 pts. What is the NPV of selling the old machine and buying the new machine (ignore the old machine otherwise, i.e., don't calculate incremental cash flows)? 0+ decimals Submit Part 4 Attempt 1/30 for 10 pts. What is the NPV of replacing the machine instead of keeping the old one? 0+ decimals SubmitStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started