Please solve using excel!

Calculating initial investmentDuPree CoffeeRoasters, Inc., wishes to expand and modernize its facilities. The installed cost of a proposedcomputer-controlled automatic-feed roaster will be $123,000. The firm has a chance to sell its 4-year-old roaster for $35,100. The existing roaster originally cost $59,800 and was being depreciated using MACRS and a7-year recovery period(see the table LOADING...) DuPree is subject to a 40% tax rate.

Rounded Depreciation Percentages by Recovery Year Using MACRS for

First Four Property Classes

Percentage by recovery year*

Recovery year 3 years 5 years 7 years 10 years

1 33% 20% 14% 10%

2 45% 32% 25% 18%

3 15% 19% 18% 14%

4 7% 12% 12% 12%

5 12% 9% 9%

6 5% 9% 8%

7 9% 7%

8 4% 6%

9 6%

10 6%

11 4%

Totals 100% 100% 100% 100%

a. What is the book value of the existingroaster?

b. Calculate theafter-tax proceeds of the sale of the existing roaster.

c. Calculate the change in net working capital using the followingfigures:

Anticipated Changes in Current Assets and Current Liabilities