3. Forecasting of Income Statement and Balance Sheet. Fill in the 2021E (stands for 2021 forecast)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. Forecasting of Income Statement and Balance Sheet. Fill in the 2021E (stands for 2021 forecast) numbers in Tables 1 and 2 below. Provide your detailed calculations. Use 2 decimal places for Smillion, for example $1.23million. (30 points) Table 1. FORECAST OF THE 2021 INCOME STATEMENT Forecastratios Income statement Percent 2021E $ Million 2020 2021E Revenue grow th 20.0 Revenue 240.0 Costs of goods sold/revenues 32.0 Cost of goods sold (90.0) Selling, general and 18.0 Selling, general and admin (45.0) admin/revenues Depreciation (19.0) Depreciation/revenue 10.0 EBIT 86.0 EBIT/revenue 40.0 Interest expense (23.0) Interest income 5.0 Nonoperating items Non operating income 4.0 Nonoperating income growth 10.0 Earnings before taxes (EBT) 72.0 Interest rates Taxes on EBT (24.0) (36.50) Interest expense 5.5 Net income 48.0 Interest income (fromexcess cash) 6.5 Taxes Operating tax rate Marginal tax rate Average tax rate 34.4 40.0 33.6 Table 2. FORECAST OF THE 2021 BALANCE SHEET Forecast worksheet Balance sheet Forecast ratio 2021E $ Million 2020 2021E Cash (in days) 8.6 Cash 5.0 Inventory (in days) 52.6 Excess cash 60.0 Accounts payable (in days) (28.2) Inventory 45.0 Net working capital (in days) 33.0 Current assets 110.0 Fixed assets (percent) Net PP&E 250.0 Net PP&E/revenues 102.0 Equity investments 100.0 Total assets 460.0 Nonoperating assets (percent) Growth in equity investments 3.0 Liabilities and equity Accounts payable 20.0 Dividend Payout Ratio 38.0% Short-term debt 213.0 213.0 Current liabilities 233.0 Long-term debt 80.0 80.0 Newly issued debt 0.0 Common stock 65.0 65.0 Retained earnings 82.0 Total liabilities and equity 460.0 3. Forecasting of Income Statement and Balance Sheet. Fill in the 2021E (stands for 2021 forecast) numbers in Tables 1 and 2 below. Provide your detailed calculations. Use 2 decimal places for Smillion, for example $1.23million. (30 points) Table 1. FORECAST OF THE 2021 INCOME STATEMENT Forecastratios Income statement Percent 2021E $ Million 2020 2021E Revenue grow th 20.0 Revenue 240.0 Costs of goods sold/revenues 32.0 Cost of goods sold (90.0) Selling, general and 18.0 Selling, general and admin (45.0) admin/revenues Depreciation (19.0) Depreciation/revenue 10.0 EBIT 86.0 EBIT/revenue 40.0 Interest expense (23.0) Interest income 5.0 Nonoperating items Non operating income 4.0 Nonoperating income growth 10.0 Earnings before taxes (EBT) 72.0 Interest rates Taxes on EBT (24.0) (36.50) Interest expense 5.5 Net income 48.0 Interest income (fromexcess cash) 6.5 Taxes Operating tax rate Marginal tax rate Average tax rate 34.4 40.0 33.6 Table 2. FORECAST OF THE 2021 BALANCE SHEET Forecast worksheet Balance sheet Forecast ratio 2021E $ Million 2020 2021E Cash (in days) 8.6 Cash 5.0 Inventory (in days) 52.6 Excess cash 60.0 Accounts payable (in days) (28.2) Inventory 45.0 Net working capital (in days) 33.0 Current assets 110.0 Fixed assets (percent) Net PP&E 250.0 Net PP&E/revenues 102.0 Equity investments 100.0 Total assets 460.0 Nonoperating assets (percent) Growth in equity investments 3.0 Liabilities and equity Accounts payable 20.0 Dividend Payout Ratio 38.0% Short-term debt 213.0 213.0 Current liabilities 233.0 Long-term debt 80.0 80.0 Newly issued debt 0.0 Common stock 65.0 65.0 Retained earnings 82.0 Total liabilities and equity 460.0
Expert Answer:
Answer rating: 100% (QA)
To fill in the 2021E 2021 forecast numbers in Tables 1 and 2 we need to calculate the values based on the given forecast ratios and 2020 data Here are ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
In Problem 10.16, we projected financial statements for Walmart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 12.17-12.19 (pages 948-950) include the actual amounts for 2012...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Suppose that two linear equations are graphed on the same set of coordinate axes. Sketch what the graph might look like if the system has the given description. (a) The system has a single solution....
-
Lyons Company manufactures and sells one product. The following information pertains to the company's first year of operations: Variable cost per unit: Direct materials...
-
Marketers are keenly interested in how social media (e.g., Facebook, Twitter) may influence consumers who buy their products. Researchers at HP Labs (Palo Alto, CA) investigated whether the volume of...
-
How does make determine whether a target needs to be rebuilt?
-
Stratton Testing is considering investing in a new testing device. It has two options: Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 5...
-
10. Label and explain in details the following diagram A 12. 1 Give three functions of E. Zinc E B + C D Copper 13. Give an ideal principle of predicting a performance of a fuel cell and give an...
-
Describe how each of the following supports the implementation of change when new safety control measures are introduced in the workplace 1. Risk register 2.Work procedures 3. Worker feedback 4....
-
How does a third-party complaint compare to a crossclaim? What is the key difference?
-
Let's say that you wanted to represent aspiring football players in Alabama, what type of educational requirements would you have to possess and in addition to educational requirements are there any...
-
What laws does military drones violate in war and law enforcement? List the laws and argue for and against each.
-
Judges at times are not given a lot of lee way in their decision making when it comes to sentencing. Do you think the judicial system needs to afford them more discretion?
-
Can attorneys bill the clients for whom they are traveling, and simultaneously bill the other clients for whom they are making phone calls and other communication? If not, whose bill should get cut?
-
In Chapter One Page 9, Read the Text Box entitled "Sports & Entertainment Law" You will read about player's and an owner's private conduct. You will see that the leagues took action, and in some...
-
Pearson Education, a publisher of college textbooks, would like to know if students prefer traditional textbooks or digital textbooks. A random sample of students was asked their preference and the...
-
The concept of accounting quality has several dimensions, but two characteristics often dominate: the accounting information should be a fair representation of performance for the reporting period,...
-
Molson Coors is the fifth-largest brewer in the world. It is one of the leading brewers in the United States and Canada; the company's brands include Coors, Molson Canadian, Carling, and Killian's...
-
A group of Holmes' top management is interested in acquiring Holmes in an LBO. a. Briefly describe the factors that make Holmes an attractive and, conversely, an unattractive LBO candidate. b. (This...
-
Refer to the information in problem 35. Determine Marlees income tax liability for 2017.
-
John has taxable income of $30,000. William has taxable income of $60,000. Determine their 2017 income taxes if they are both single individuals and claim the standard deduction. Compare their...
-
Lilikoi Corporation began business in 2015. Lilikoi earned taxable income of $40,000 in 2015 and $120,000 in 2016. For 2017, Lilikoi Corporation has a net operating loss of $50,000 and decides to...
Study smarter with the SolutionInn App