NEED EXCEL FORMULAS!

Your boss has asked you to analyze a potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate, and shows what the products net present value and internal rate of return are and what your recommendation is.

Marketing information

Your company already has spent $125,000 to conduct market research about the demand for the product, which indicates the optimal wholesale price for the product would be $14.00 per unit, based on the prices of similar products that competitors sell. The market research also indicates that demand for the product would last for five years. At a price of $14.00 per unit, the market research suggests that sales would be 300,000 units in the first year, and unit sales would increase 5% per year over the remaining four years of the products life.