Use the folwing data to answer the requirements in the cells

Do not use PV tables or financial calculators. Make all your calculations on the Excel worksheet, including Excel functions.

Use cell references, Excel calculations, or Excel functions to show the results in the yellow-shaded cells.

After you complete your assignment, save your work.

Transcribed Image Text:

Excel Assignment Vacu-Tech Cost of equipment (including installation and training) 500,000 Assume the asset will be sold at the end of the 5th year. Salvage value at the end of 5 years 60,000 Increase in annual operating cash flow Useful life of equipment (in years) Applicable income tax rate MACRS tax class (in years); 1/2 year rule Desired rate of return 145,000 5 30% 5 13% MACRS 5 Year Asset Depreciation; 1/2 year rule MACRS Depreciation Schedule Year 1 20% Year 2 32% Year 3 19.20% Year 5 11.52% Year 4 11.52%