Question

Help with the 2020 forecast part! ThanksExclude (000,000) in millions Revenue Cost of Goods Sold Gross Profit Selling, Admin, Other Net Operating Income Three Most R

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A. My Forecast for 2020 year’s sales growth is 20.5% to 21% because

1. It is high growth company. Though, there has been absolute growth in the sales during the last 3 years period and a consistent absolute increase in the sales amount but in terms of % it is showing decrease effect and it has been assuming that growth rate (to moderate) due to base effect. Base in 2019 has increased vs low base in 2017-2018 vs 2017 growth rate moderation is 7.4% (35%-27.6%). We have assumed moderation at 7% around, the expected sales comes to 20.5% (27.6%-7% moderation) and thus sales growth assumed to range 20.5%-21%

2. Absolute sales number has increased by 4.1mn/4.4mn, We assume similar trajectory after 2019 ie 4.25 mn (average of two) giving sales growth of 20.5%.

B. My Forecast for 2020 year’s operating margins is 22.6% ie+2%                                      vs last year ( because last year operating margin calculation wrong 10.2% instead of 20.6%)

1.Gross margin has expanded by 1.4% (38.3%%-36.9%)/2.4% (36.9%-34.5%) in 2019/2018 YOY. This implies either the company is able   to price higher with better product demand or its getting vendor rebates/has bargaining power vs its suppliers leading to better gross margins. Expecting gross margins to expand by 0.7% (lower vs last two years) as the trend is already towards reducing expansion ie 1% (2.4%-1.4%)difference in expansion between 2017-19.

2. Selling & Admin expenses have been showing reducing as a % of sales from 19% to17.7% between 2018-19 reflecting operational leverage. We expect this to reduce to 16.4% in 2020 forecast sales. This implies we forecast sale, admin expenses 3999845. Thus gives us operating margin at 22.6%.

Note: Computed net operating margin in the problem is wrong or the question is wrong but my solution is above based on inputs.

Add a comment
Know the answer?
Add Answer to:
Help with the 2020 forecast part! Thanks Exclude (000,000) in millions Revenue Cost of Goods Sold...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • need help, thanks! A Number Styles fa b) Monroe Products plans to purchase $100,000 of fixed...

    need help, thanks! A Number Styles fa b) Monroe Products plans to purchase $100,000 of fixed assets in 2020, but will not dispose of any existing fixed assets. What should be its forecast for endi B D F G L M Assignment 4.4 Exercises Problem 1: Creating Proforma Financial Statements 5 Points A pro forma Income Statement for Monroe Products Co. is displayed below: Monroe Products Company Income Statements, 2019 and Pro Forma 2020 Years Ended December 31st 2020 2019...

  • Seved Help Week 3: Homework 7 2821 Income Statement Net sales $1e, Bee Cost of goods...

    Seved Help Week 3: Homework 7 2821 Income Statement Net sales $1e, Bee Cost of goods sold (6,55e) Gross profit 3,450 Operating expenses (2,350 Interest expense (389 Income tax expense (320 Net Income 480 10 points eBook Comparative Balance Sheets Dec 31 2021 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) $780 70e sie be Be 55,360 34, see $1,760 $1.450 Liabilities and Shareholders' Equity Current liabilities Bonds payable Cont stock Retard earnings 856 Required: Calculate the following...

  • How to get picture 1 "Cost of Sales" and picture 2 "Net Income or Net Earnings",...

    How to get picture 1 "Cost of Sales" and picture 2 "Net Income or Net Earnings", thank you. February 1, 2020 February 2 2019 Year Ended February 3, 2018 Jamiary 28, 2017 January 30, 2016 3. Total Assets S S Total Liabilities Total Equity or Total Shareholders Investments Financial Statement Name as stated in the 10-K Statement of Operations Data: Net sales Gross profit Selling, general and administrative expenses Operating income (loss) 23,610.8 S 7,040.7 5.778.5 1.262.2 22,823.3 $ 6.947.5...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT