Question: please show work on excel. will upvote Question 1 . Oliver's Bakery is considering purchasing a new oven that will allow it to increase sales.

please show work on excel. will upvote
please show work on excel. will upvote Question 1 . Oliver's Bakery

Question 1 . Oliver's Bakery is considering purchasing a new oven that will allow it to increase sales. The oven will cost $80,000 and will be depreciated according to the 3-year MARCS schedule. If the oven is installed, it will increase Oliver's revenues by 20% (the revenues increase by 20% once and stay at that level for the remaining years). If the new oven is not installed, the sales are expected to generate $300,000 this year and stay at this level for the next four years. Costs are expected to be $200,000 this year and stay at this level for the next four years. (with and without the purchase of the oven). The corporate tax rate is 35%. (a) What are the free cash flows of the firm in years 0,1,2,3,4 if a firm doesn't install this new oven? (b) What are the depreciation tax shields associated with a purchase of the oven? (c) What are the free cash flows of the firm in years 0,1,2,3,4 if a firm purchases this new oven? (d) If the discount rate is 20%, should the oven be purchased? (Hints: (i) use the NPV rule to make a decision whether to make a purchase; (ii) to calculate the oven's NPV use the incremental free cash flows.) (e) Now suppose that the oven will be sold for scrap metal in year 3 for $3,000. (i) What is the book value of oven in years 0,1,2,3,4 ? (ii) What is the capital gain tax (capital loss tax credit) that a firm incurs in year 3 when selling the oven? (iii) What is the oven's salvage value in year 3 ? (iv) How your answer to questions (a), (c), (d) would change

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!