please show formulas

14. Darius thinks the Tampa and Orlando offices have a good chance of increasing income in the next year. In the range B21:E23, he wants to make three projections based on different assumptions. Project the quarterly income for Darius as follows: a. First, determine the income needed in Quarters 2 and 3 to achieve an income of $7,500 in Quarter 4. Project the income in the four quarters by filling the series for the first projection (range B21:E21) with a linear trend. b. Next, determine the income in Q2-Q4 if it increases by 2 percent each quarter, starting with an income of $6,300. Project the income in the four quarters by filling the series for the second projection (range B22:E22) based on a growth trend using 1.02 as the step value. C. Finally, extrapolate the income based on the income in Q4 of the current year and a growth rate of 3 percent. In cell B23, enter a formula without using a function to reference the total income in Q4 of the current year (cell E5). Project the income in the four quarters by filling the series for the third projection (range B23:E23) based on a growth trend using 1.03 as the step value. F G SmartEnergy Services Profit - Next Year Q1 Q2 Q3 Q4 Total (in $0000) $5,805 $20,724 B SmartEnergy Services 2 Profit - Current Year 3 $0000) Q1 Q2 Q3 4 Income 5 Total Income $4,562 $5,119 55,238 6 Operating Expenses 7 Salaries $757 $757 $780 8 Rent $568 $568 $568 9 Advertising $550 $550 $550 10 Transportation $100 $100 $100 11 Research & Development $1,077 $1,085 $1,107 12 Maintenance $700 $650 $695 13 Insurance $743 $743 $743 14 Supplies $320 $290 $300 15 Total Expenses $4,815 $4,743 $4,843 16 Wet Profit ($253) $376 $395 17 Profit Margin -696 796 896 18 19 Projections 20 Q2 Q3 21 Increase income to $7500 in 04 $ 6,300 $ 22 ncrease income by 2% $ 6,300 23 Start with last year 4 Income 24 25 26 27 28 29 30 31 32 33 34 35 36 37 $850 $572 $550 $100 $1,200 $690 $750 $550 $5,262 $543 996 $3,144 $2,276 $2,200 $400 $4,469 $2,735 $2,979 $1,460 $19,663 $1,061 59 Q1 Q4 7,500 Total 13,800 6,300 14. Darius thinks the Tampa and Orlando offices have a good chance of increasing income in the next year. In the range B21:E23, he wants to make three projections based on different assumptions. Project the quarterly income for Darius as follows: a. First, determine the income needed in Quarters 2 and 3 to achieve an income of $7,500 in Quarter 4. Project the income in the four quarters by filling the series for the first projection (range B21:E21) with a linear trend. b. Next, determine the income in Q2-Q4 if it increases by 2 percent each quarter, starting with an income of $6,300. Project the income in the four quarters by filling the series for the second projection (range B22:E22) based on a growth trend using 1.02 as the step value. C. Finally, extrapolate the income based on the income in Q4 of the current year and a growth rate of 3 percent. In cell B23, enter a formula without using a function to reference the total income in Q4 of the current year (cell E5). Project the income in the four quarters by filling the series for the third projection (range B23:E23) based on a growth trend using 1.03 as the step value. F G SmartEnergy Services Profit - Next Year Q1 Q2 Q3 Q4 Total (in $0000) $5,805 $20,724 B SmartEnergy Services 2 Profit - Current Year 3 $0000) Q1 Q2 Q3 4 Income 5 Total Income $4,562 $5,119 55,238 6 Operating Expenses 7 Salaries $757 $757 $780 8 Rent $568 $568 $568 9 Advertising $550 $550 $550 10 Transportation $100 $100 $100 11 Research & Development $1,077 $1,085 $1,107 12 Maintenance $700 $650 $695 13 Insurance $743 $743 $743 14 Supplies $320 $290 $300 15 Total Expenses $4,815 $4,743 $4,843 16 Wet Profit ($253) $376 $395 17 Profit Margin -696 796 896 18 19 Projections 20 Q2 Q3 21 Increase income to $7500 in 04 $ 6,300 $ 22 ncrease income by 2% $ 6,300 23 Start with last year 4 Income 24 25 26 27 28 29 30 31 32 33 34 35 36 37 $850 $572 $550 $100 $1,200 $690 $750 $550 $5,262 $543 996 $3,144 $2,276 $2,200 $400 $4,469 $2,735 $2,979 $1,460 $19,663 $1,061 59 Q1 Q4 7,500 Total 13,800 6,300