SOLVE ALL IN EXCEL AND PROVIDE FORMULAS. Sales for the first year is estimated at $$200,000,$ of course, the sales in $.$ Solve subsequent years are uncertain. The forecast revenue will grow each year, but the actual growth rate is uncertain. Estimate the revenue to be distributed normally with a mean of $8\%$ and a standard deviation of $2\%.$ Costs of goods sold each year are uncertain as well but are forecasted as a percentage of sales. COGS as a percentage of sales is estimated to be distributed normally with a mean of $60\%$

and a standard deviation of $5\%.$ Fixed costs estimated at $$57,000$ per year. Current assets are

forecasted using $15\%$ of the annual firm revenue and current liabilities are forecasted using $10\%$

of the annual revenue. Estimate the private equity target will require an initial investment in net

working capital of $$6,000$ and initial investment for new equipment of $$120,000.$ Use the $5-$year

MACRS schedule to depreciate the equipment. The forecast the equipment will have no salvage

value of the $6$th year. The cost of capital for this deal is $7\%$