Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the answer for the following excel question? * The model needs to show forecast profit for the next 4 quarters (Q1, Q2, Q3,
What is the answer for the following excel 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*B4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started