Below is an Excel model which forecasts the quarterly and yearly profit for a retail

firm ABC Ltd$,$ based upon the following requirements:

The model needs to show forecast profit for the next $4$ quarters $,$

Q$4)$

The first quarter's revenue is $$50,000$ and the revenue is forecast to grow by

$8\%$ per quarter

The Cost of Goods Sold $($COGS$)$ is $20\%$ of revenue

Other expenses are $$20,000$ and are expected to grow at $6\%$ per quarter.

What is the best formula in C$19?$

$C18**$$$B$$$4$

$$C$$$18**B4$

$$C$$$18**$$$B$$$4$

C$18*$B$4$ Below is an Excel model which forecasts the quarterly and yearly profit for a retail firm ABCLtd, based upon the following requirements: The model needs to show forecast profit for the next $4$ quarters $($Q$1,$ Q$2,$ Q$3,$ Q$4)$ The first quarter's revenue is $$50,000$ and the revenue is forecast to grow by $8\%$ per quarter The Cost of Goods Sold $($COGS$)$ is $20\%$ of revenue Other expenses are $$20,000$ and are expected to grow at $6\%$ per quarter. What is the best formula in C$19?$ Delta A B C D E F $1$ INPUT $2$ Revenue $$50,0003$ Revenue Growth $8\%$ per Quarter $4$ COGS $20\%$ per Quarter $5$ Other Expenses $$20,0006$ Expenses Growth $6\%$ per Quarter $89$