Build a data table in G21:AB42 that shows what 2021 EPS would be based on the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Build a data table in G21:AB42 that shows what 2021 EPS would be based on the revenue growth rate and cost of goods sold / revenue assumptions listed in Table 1. Input the revenue growth rate assumptions horizontally in row 21 and the cost of goods sold / revenue assumptions vertically in column G When you're done, click the done button below. Income Statement for Lemonade Co. Proiections 2016 2017 2018 2019 2020 2021 Revenues 1,500.0 2,500.0 4,500.0 4,950.0 5,445.0 5,989.5 Cost of goods sold 1,200.0 3,400.0 4,000.0 3,960.0 4,356.0 4,791.6 Gross Profit 300.0 (900.0) 500.0 990.0 1,089.0 1,197.9 Operating costs 55.0 65.0 78.0 78.0 78.0 78.0 Non-operating costs 15.0 15.0 15.0 15.0 15.0 15.0 Pretax Profit 230.0 (980.0) 407.0 897.0 996.0 1,104.9 Taxes 100.0 (200.0) 150.0 314.0 348,6 386.7 Net Profit 130.0 (780.0) 257.0 583.1 647.4 718.2 Shares Outstanding 115.0 120.0 125.0 125.0 125.0 125.0 EPS $1.13 ($6.50) $2.06 $4.66 $5.18 $5.75 Revenue growth rate 67% 80% 10.0% 10.0% 10.0% Cost of goods sold / Revenue 80% 136% 89% 80.0% 80.0% 80.0% Tax rate 43% 20% 37% 35.0% 35.0% 35.0% Table 1. 2021 Assumptions Cost of goods Build data table here: Revenue sold growth rate: / Revenue 1.0% 70.0% 2.0% 71.0% 3.0% 72.0% 4.0% 73.0% 5.0% 74.0% 6.0% 75.0% 7.0% 76.0% 8.0% 77.0% 9.0% 78.0% 10.0% 79.0% 11.0% 80.0% 12.0% 81.0% 13.0% 82.0% 14.0% 83.0% 15.0% 84.0% 16.0% 85.0% 17.0% 86.0% 18.0% 87.0% 19.0% 88.0% 20.0% 89.0% 21.0% 90.0% Build a data table in G21:AB42 that shows what 2021 EPS would be based on the revenue growth rate and cost of goods sold / revenue assumptions listed in Table 1. Input the revenue growth rate assumptions horizontally in row 21 and the cost of goods sold / revenue assumptions vertically in column G When you're done, click the done button below. Income Statement for Lemonade Co. Proiections 2016 2017 2018 2019 2020 2021 Revenues 1,500.0 2,500.0 4,500.0 4,950.0 5,445.0 5,989.5 Cost of goods sold 1,200.0 3,400.0 4,000.0 3,960.0 4,356.0 4,791.6 Gross Profit 300.0 (900.0) 500.0 990.0 1,089.0 1,197.9 Operating costs 55.0 65.0 78.0 78.0 78.0 78.0 Non-operating costs 15.0 15.0 15.0 15.0 15.0 15.0 Pretax Profit 230.0 (980.0) 407.0 897.0 996.0 1,104.9 Taxes 100.0 (200.0) 150.0 314.0 348,6 386.7 Net Profit 130.0 (780.0) 257.0 583.1 647.4 718.2 Shares Outstanding 115.0 120.0 125.0 125.0 125.0 125.0 EPS $1.13 ($6.50) $2.06 $4.66 $5.18 $5.75 Revenue growth rate 67% 80% 10.0% 10.0% 10.0% Cost of goods sold / Revenue 80% 136% 89% 80.0% 80.0% 80.0% Tax rate 43% 20% 37% 35.0% 35.0% 35.0% Table 1. 2021 Assumptions Cost of goods Build data table here: Revenue sold growth rate: / Revenue 1.0% 70.0% 2.0% 71.0% 3.0% 72.0% 4.0% 73.0% 5.0% 74.0% 6.0% 75.0% 7.0% 76.0% 8.0% 77.0% 9.0% 78.0% 10.0% 79.0% 11.0% 80.0% 12.0% 81.0% 13.0% 82.0% 14.0% 83.0% 15.0% 84.0% 16.0% 85.0% 17.0% 86.0% 18.0% 87.0% 19.0% 88.0% 20.0% 89.0% 21.0% 90.0%
Expert Answer:
Answer rating: 100% (QA)
The data table is prepared using the Excel spreadsheet as follows Fo... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation
ISBN: 978-0324302950
6th edition
Authors: Clyde P. Stickney
Posted Date:
Students also viewed these accounting questions
-
What is underapplied overhead? When Cost of Goods Sold is adjusted for underapplied overhead, will the cost increase or decrease? Why?
-
What is overapplied overhead? When Cost of Goods Sold is adjusted for overapplied overhead, will the cost increase or decrease? Why?
-
What is underapplied overhead? When Cost of Goods Sold is adjusted for underapplied overhead, will the cost increase or decrease? Why?
-
When we create our own Market Limitations In the mid-1960s a new electronics company was founded with a unique high-tech product a new type of computer. Thanks to its engineering know-how LOCKDOWN...
-
Why might actual revenues and expenditures reported on the schedule of revenues, expenditures, and changes in fund balancesbudget and actual differ from those reported on the GAAP-basis statement of...
-
Salaries as a function of specific college majors. Now let's assume that the data were for those with only a bachelor's degree (Bach) in their field. Now the researcher wants to know if having a...
-
The CEO of Evans \& Sons, Inc., negotiated with its principal supplier of raw materials to purchase 10,000 units for a total price of \(\$ 100,000\). The units are to be delivered in 90 days. The CEO...
-
The Walt Disney Company has four profitable business segments, described as follows: Media Networks: The ABC television and radio network, Disney channel, ESPN, A& E, E!, and Disney.com. Parks and...
-
Describe the two basic tensions of organizational design: how to divide up the work ( differentiation ) and how to coordinate multiple efforts ( integration ) .
-
Ellery Products manufactures various components for the fashion industry. Ellery buys fabric from two vendors: Ewers Textiles and Bramford Materials. Ellery chooses the vendor based on price. Once...
-
A firm forecasts sales of 800,000 and Net Working Capital equal to 25% of sales. Property Plant and Equipment is 200,000. The company has long term debt of 120,000 and equity of 85,000. It is...
-
Sunland Corporation is involved in the business of injection molding of plastics. It is considering the purchase of a new computer-aided design and manufacturing machine for $442,000. The company...
-
The train shown is traveling at a speed of 140 mph km/h when the brakes are fully applied on the wheels of cars B and C in order to slow the train to 50 mph. The brakes are not applied on the wheels...
-
PART A:Banks and other mortgage originators often securitise long-term assets like mortgages, to ensure liquidity. Briefly outlinethe process of bank securitisation[2 marks] PART B:Sunshine Ltd plans...
-
Eagle Corporation Stockholders' Equity section includes the following information: Common Stock $ 10,000 Paid-in Capital in Excess of Par-Common 4,000 Retained Earnings 6,700 Preferred Stock 8,000...
-
Youbought 3 contracts of 6-month call options on stock XYZ @ $5.00 per call, with strike price of 49.00. Today the call contracts expired when the stock closed at 50.42. What's your percentage...
-
Unit system: IPS (inch, pound, second) Decimal places: 2 Part origin: Arbitrary Material: Copper Density = 0.32 lb/in A = 1.12 B = 1.50 C = 0.75 D = 0.75 Using the part information above and the...
-
KD Insurance Company specializes in term life insurance contracts. Cash collection experience shows that 20 percent of billed premiums are collected in the month before they are due, 60 percent are...
-
A firm's income tax return shows taxes currently payable for Year 4 of $50,000. It reports deferred tax assets of $42,900 at the beginning of Year 4 and $38,700 at the end of Year 4. It reports...
-
"With respect to asset valuation, reliability and relevance are often on opposite ends of the continuum." Explain.
-
Turner Construction Company agreed on January 1, Year 1, to construct an observatory for Dartmouth College for $120 million. Dartmouth College must pay $30 million on signing and $30 million at the...
-
Describe a conflict that may arise between the shareholders of a company and the debtholders of the company. Discuss what the debtholders might do to resolve that conflict and explain why you feel...
-
Describe a conflict that may arise between the shareholders of a company and the managers of the company. Discuss what the shareholders might do to overcome that conflict and explain why you feel...
-
Ernst & Young, LLP is the independent public accountant for AMR Corporation, the parent company of American Airlines and American Eagle. In February 2013 AMR and US Airways Group announced the two...
Study smarter with the SolutionInn App