* The model needs to show forecast profit for the next 4 quarters (Q1, Q2, Q3, Q
ID: 3712645 • Letter: #
Question
* The model needs to show forecast profit for the next 4 quarters (Q1, Q2, Q3, Q4) 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 C19? INPUT 2 Revenue 3 Revenue Growth 4 COGS 5 Other Expenses 6 Expenses Growth 7 8 9 10 11 Revenue 12 Revenue Growth 13 COGS 14 Other Expenses 15 Expenses Growth 16 17 18 Revenue 19 less COGS 20 Gross Profit 21 Other Expenses 22 Proft 23 $50,000 8% per Quarter 20% per Quarter $20,000 6% per Quarter REPORT $50,000 8% 20% 20,000 6% TOTAL Q1 50,000 $54,000 $58,320 62,986$225,306 10,000 $10,800 $11,664 12,597$45,061 40,000 $43,200 $46,656 $50,389 $180,245 Q2 04 $20,000 $21,200 $22,472 $23,820 $87,492 26,569 $92,753 $20,000 $22,000 $24,184 $C$18*$B$4 C18 $B$4 C18*B4 $C$18*B4Explanation / Answer
Option 1 correct
Use $c$18*$B$4
$C$ and $B$ called as the absolute reference the column and the row donot change.
c19 is less COGS which is absolutely depend on the c18 and B4
Here COGS is depend revenue which is exist in c18 and B4
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.