Hello, I want to see if I'm doing this question correctly. Could you please solve and show formulas/solutions using excel. Thank you!

Assignment: Calculate the cash flow in each of the 5 years of this project for a new product given the following information $15/ unit sales price $/2unit cost of raw materials $8/unit cost of direct labor $1500/month rent $1000/year insurance $50,000 supervisor salary (cost to the company) 20,000 units/year sales volume increasing at 5%each year Initial cost for the machinery of $150,000, depreciated using MACRS 7-year recovery period The machinery is sold in the 5th year for $20,000. 28% tax rate . Assignment: Calculate the cash flow in each of the 5 years of this project for a new product given the following information $15/ unit sales price $/2unit cost of raw materials $8/unit cost of direct labor $1500/month rent $1000/year insurance $50,000 supervisor salary (cost to the company) 20,000 units/year sales volume increasing at 5%each year Initial cost for the machinery of $150,000, depreciated using MACRS 7-year recovery period The machinery is sold in the 5th year for $20,000. 28% tax rate