PLEASE SHOW HOW TO FIND CASH FLOW PER YEAR & USE EXCEL SPREADSHEET!!!!!! WILL UPVOTE

M\&P Electronics, Inc., projects unit sales for a new wearable Al training device for athletes. Production of the devices will require $4,500,000 in net working capital to start and additional net working capital investments each year equal to 12 percent of the projected sales increase for the following year. Total fixed costs are $4,900,000 per year, variable production costs are $385 per unit, and the units are priced at $550 each. The equipment needed to begin production has an installed cost of $17,000,000. Because the wearable Al technology are intended for professional athletes, this equipment is considered industrial machinery and thus qualifies as seven-year MACRS property. In five years, this equipment can be sold for about 20 percent of its acquisition cost. M\&P is in the 35 percent marginal tax bracket and has a required return on all its projects of 18 percent. MACRS DEPRECIATION BY CLASS OF PROPERTY MACR5 7-year property (ex: office fumiture and fixtures such as desks, fax machines, lamos, files, chairs). M\&P Electronics, Inc., projects unit sales for a new wearable Al training device for athletes. Production of the devices will require $4,500,000 in net working capital to start and additional net working capital investments each year equal to 12 percent of the projected sa increase for the following year. Total fixed costs are $4,900,000 per year, variable production costs are $385 per unit, and the units are priced at $550 each. The equipment needed to begin production has an installed cost of $17,000,000. Because the wearable Al technolog are intended for professional athletes, this equipment is considered industrial machinery and thus qualifies as seven-year MACRS propert In five years, this equipment can be sold for about 20 percent of its acquisition cost. M\&P is in the 35 percent marginal tax bracket and has a required return on all its projects of 18 percent. MACRS DEPRECIATION BY C\& ASS OF PROPERTY MACRS 7-year property (ex: office furniture and fixtures such as desks, fox marhinas lamat filse ofyirs)