In Excel (showing each cell's calculation), calculate the cashflow in each of the 5 years of this project for a new product given the following information. Be sure to include the cash from the sale of the asset in year 5. Review what to do if the MACRS schedule is not fully executed.

$24 / unit sales price

$3.50 / unit cost of raw materials

$15 / unit cost of direct labor to make the product

$2000 / month rent

$1600 / year insurance

$65,000 supervisor salary (already includes cost to the company)

23,000 units/year sales volume increasing at 5% each year

Initial cost for the machinery of $165,000, depreciated using MACRS 7-year recovery period

The machinery is sold in the 5th year for $45,000

28% tax rate