Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answers in an excel plz so that i can check it with mine. Case 3. Will the pizza taste better? Popa's Pizza is considering replacing
Answers in an excel plz so that i can check it with mine.
Case 3. Will the pizza taste better? Popa's Pizza is considering replacing an existing oven with a new, more sophisticated oven. The old oven was purchased three years ago at a cost of $40,000, and this amount was being depreciated using a five-year straight-line depreciation to zero. The oven has five years of usable life remaining. The new oven being considered costs $50,000, requires $2,000 in installation costs, and would be depreciated using 5-year MACRS depreciation. The new oven would also require an increase in net working capital of $700 when it is installed. The old oven can currently be sold for $16,000 with no removal or cleanup costs. The firm pays taxes at a rate of 40 percent. The revenues and expenses (excluding depreciation) associated with the new and old oven for the next 5 years are given in the following table. New Oven Old Oven Year Revenue Expenses Revenue Expenses (excluding (excluding depreciation) depreciation) 1 $250,000 $120,000 $220,000 $110,000 2 $260,000 $125,000 $230,000 $115,000 3 $270,000 $130,000 $240,000 $120,000 4 $280,000 $135,000 $250,000 $125,000 5 $290,000 $140,000 $260,000 $130,000 At the end of this 5-year useful life, the new oven can be sold for $20,000. If the old over were to be kept, it could be sold for $5,000 at end of this 5-year period. 1. Calculate the initial cash outflow associated with the replacement of the old oven with the new one. 2. Determine the incremental operating cash flows associated with this proposed replacement for years 1 through 5, assume any negative operating income from your analysis can be written off against other taxable income within the company. 3. Calculate the termination cash flow for this proposed replacement at the end of year 5. 4. Calculate the NPV of the proposed replacement at 12.5%, what should Popa's Pizza doStep 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