The worksheet MarketSize contains information on market size, market share, product price, profit margin, and market growth. Write formulas that compute each years profit and the total 10year profit.

I G Year 1 Market size Market share Price Profit margin Market size growth Years of growth 1000 0.4 100 0.2 0.08 H I J K L M N O P R S D2 gives year 1 market size D3 gives market share (same each year) D4 gives product price (same each year) D5 gives Profit margin (same each year). For example a 20% profit margin on a $100 product means unit cost is $80. D6 gives growth rate of market size D7 gives years of market growth. For example, the market grew at the rate of 0.08 in year 2-4, and remains the same thereafter Fill in the spreadsheet below to determine each year's profit and the total 10 year profit. Your results should change if any of the inputs in D2:07 change. 2 3 4 5 Year Size Share Units sold Revenue Cost Profit Total Profit