Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q3. Use the assumptions described in the table when modeling items that are not computed as totals or subtotals, or that are not computed
Q3. Use the assumptions described in the table when modeling items that are not computed as totals or subtotals, or that are not computed using information available from the model. Variable Modeling assumptions Revenue growth in the first forecast year equals revenue growth from the last year in historical period. After that, revenue growth rate is 0.63 percentage points less than the revenue growth rate from the previous year. Revenue Cost of sales SG&A and other indirect expenses Cost of sales to revenue in first year of forecast period equals ratio from last year of historical period. Subsequently, ratio worsens by 0.45 percentage points each year in forecast period. < SG&A and other indirect expenses to revenue in each year of forecast period equals average annual ratio from the historical period E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A Income Statement Revenue B Cost of Sales Gross Profit SG&A and other indirect expenses Operating Profit C D 2016A 698,000 -576,000 122,000 -92,000 30,000 E 2017A 707,000 -623,000 84,000 - 103,000 -19,000 F 2018A 723,000 -678,000 45,000 -134,000 -89,000 G 2019E H 2020E 2021E J 2022E K L
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The detailed ...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