Based on the given income statement for 2021: 1. Based on recent fiscal year financials use
Fantastic news! We've Found the answer you've been seeking!
Question:
Based on the given income statement for 2021:
1. Based on recent fiscal year financials use a percentage of sales model to estimate your firm's sales, net income, debt and equity in the next fiscal year.
2. Calculate an internal growth rate for your firm.
3. Calculate a sustainable growth rate for your firm.
4. Based on your analysis recommend a short- and long-term financing plan for your firm in the next fiscal year.
Transcribed Image Text:
Inputs for years 2022 and beyond Growth rate, % Tax rate, % Interest rate on debt, % NWC/sales Fixed assets/sales COGS/sales Payout ratio Depreciation/Fixed assets Input values Income Statement Revenue Cost of goods sold 18.8% 25.0% 2.0% Depreciation 0.320 0.150 0.990 0.000 Taxes 0.054 EBIT Interest expense Earnings before taxes Net income Dividends Reinvested earnings Balance Sheet (year-end) Assets Net working capital Net fixed assets Total assets Liabilities and equity Long-term debt (note a) Shareholders' equity (note b) Total liab. & share. equity Sources and Uses of Funds Operating cash flow Increase in working capital Investments in fixed assets Dividends Total uses of cash Required external financing Financial ratios Debt ratio Interest coverage 2020 2020 1,194 1,064 2,258 Notes: (a): Long-term debt, the balancing item, increases by required external financing. (b): Shareholders' equity equals its value in the previous year plus retained earnings 1,870 388 2,258 2020 2021 2022 12,814 15,223 12,819 15,071 105 104 (110) 48 24 115 (134) (135) (135) 2021 4,151 1,929 6,080 5,774 306 6,080 2021 (30) 2,957 970 3,927 3,957 0.95 -4.6 A (67) (17) (51) (51) 2022 4,871 2,283 7,155 6,899 255 7,155 2022 54 720 459 1,179 1,125 0.96 0.4 2023 18,085 17,904 123 58 138 (80) (20) (60) (60) 2023 8,305 195 8,500 2023 63 916 553 1,468 5,787 6,875 2,713 3,223 8,500 10,098 1,405 4 0.98 0.4 2024 21,485 21,270 146 68 166 (98) (24) (73) (73) 2024 9,976 122 10,098 2024 73 1,088 656 1,744 1,671 0.99 0.4 NE 2025 F 25,524 25,269 174 81 200 (118) (30) (89) (89) 2025 8,168 3.829 11,996 11,963 33 11,996 2025 85 1,293 780 2,072 1,987 1.00 0.4 Inputs for years 2022 and beyond Growth rate, % Tax rate, % Interest rate on debt, % NWC/sales Fixed assets/sales COGS/sales Payout ratio Depreciation/Fixed assets Input values Income Statement Revenue Cost of goods sold 18.8% 25.0% 2.0% Depreciation 0.320 0.150 0.990 0.000 Taxes 0.054 EBIT Interest expense Earnings before taxes Net income Dividends Reinvested earnings Balance Sheet (year-end) Assets Net working capital Net fixed assets Total assets Liabilities and equity Long-term debt (note a) Shareholders' equity (note b) Total liab. & share. equity Sources and Uses of Funds Operating cash flow Increase in working capital Investments in fixed assets Dividends Total uses of cash Required external financing Financial ratios Debt ratio Interest coverage 2020 2020 1,194 1,064 2,258 Notes: (a): Long-term debt, the balancing item, increases by required external financing. (b): Shareholders' equity equals its value in the previous year plus retained earnings 1,870 388 2,258 2020 2021 2022 12,814 15,223 12,819 15,071 105 104 (110) 48 24 115 (134) (135) (135) 2021 4,151 1,929 6,080 5,774 306 6,080 2021 (30) 2,957 970 3,927 3,957 0.95 -4.6 A (67) (17) (51) (51) 2022 4,871 2,283 7,155 6,899 255 7,155 2022 54 720 459 1,179 1,125 0.96 0.4 2023 18,085 17,904 123 58 138 (80) (20) (60) (60) 2023 8,305 195 8,500 2023 63 916 553 1,468 5,787 6,875 2,713 3,223 8,500 10,098 1,405 4 0.98 0.4 2024 21,485 21,270 146 68 166 (98) (24) (73) (73) 2024 9,976 122 10,098 2024 73 1,088 656 1,744 1,671 0.99 0.4 NE 2025 F 25,524 25,269 174 81 200 (118) (30) (89) (89) 2025 8,168 3.829 11,996 11,963 33 11,996 2025 85 1,293 780 2,072 1,987 1.00 0.4
Expert Answer:
Answer rating: 100% (QA)
The image you provided contains financial information for a hypothetical company which includes an income statement and a balance sheet for the years 2020 through 2025 as well as certain assumptions f... View the full answer
Related Book For
Advanced Accounting
ISBN: 978-0538480284
11th edition
Authors: Paul M. Fischer, William J. Tayler, Rita H. Cheng
Posted Date:
Students also viewed these finance questions
-
Global Corporation had 58,000 shares of $20 par value common stock outstanding on July 1. Later that day the board of directors declared a 20% stock dividend when the market value of each share was...
-
KPMG, the audit, tax, and advisory firm, has enjoyed high employee morale for the last several years about 80% of its 29,000 professionals say it is a great place to work. But the firm wanted to...
-
A company has 2,000 shares of $1 par value common stock and 200 shares of 5%, $110 par, noncumulative preferred stock outstanding. The balance in Retained Earnings at the beginning of the year was...
-
Using atomic weight, crystal structure, and atomic radius data tabulated inside the front cover of the book, compute the theoretical densities of aluminum (Al), nickel (Ni), magnesium (Mg), and...
-
A friend produces a Geiger counter to check the local normal background radiation. It clicks randomly but repeatedly. Another friend, whose tendency is to fear most that which is least understood,...
-
Repeat Exercise 5.25 with the following order estimate (Kaiser, 1974): \[M \approx \frac{-20 \log _{10}\left(\sqrt{\delta_{\mathrm{p}} \delta_{\mathrm{r}}}...
-
XCBob, Inc. is an online motorcycle and ATV parts business from the owners home. XCBob entered into oral agreements with the defendant, Ed Tucker Distributers, for purchases of various materials to...
-
Kalogridis Corp. manufactures industrial dye. The company is preparing its 2011 master budget and has presented you with the following information: a. The projected December 31, 2010, balance sheet...
-
Please write the SQL query in Oracle as followed: The database can be downloaded via: https://www.oracletutorial.com/wp-content/uploads/2019/01/oracle-sample-database.zip For more information,...
-
Elwood is a pig farmer who is known to enjoy a drink or two. One day in July, after a weekend of particularly heavy drinking, he staggered into the office of Pork Bellies of America and offered to...
-
The Lister Clinic also needs to replace its radiology equipment and received the same offer from its vendor to purchase the needed equipment for $100,000 or lease it for five years for $24,000 per...
-
What is a Corporation? a. Unincorporated business with only one owner who pays personal income tax on profits earned. b. None of the choices is correct c. Legal entity organized and operated for a...
-
Johnson Controls, Automotive Systems Group: The Georgetown, Kentucky Plant 1. What are the core elements of TPS? Its philosophy, principles and tools? What is required for TPS to be effective? 2. How...
-
ABC Corp. expects that a significant portion of its deferred tax assets will not be realized. Which section of the Accounting Standard Codification should ABC consult to determine whether a valuation...
-
What kind of appraisal reports are typically used for income-generating properties?
-
A retail store purchases a specific model of Samsung cell phones from Samsung. A unit of these phones, on average, costs $800 dollars to manufacturer. It is known that the annual demand curve for...
-
Write an essay in which you Describe the theory of physician induced demand for medical services. Explain how the dual nature of the physicians role as both advisor and provider support the induced...
-
Rosalie owns 50% of the outstanding stock of Salmon Corporation. In a qualifying stock redemption, Salmon distributes $80,000 to Rosalie in exchange for one-half of her shares, which have a basis of...
-
Treetop Corporation is a manufacturer of specialty equipment used in the film editing industry. The company needs an income statement for the second quarter of its fiscal year and has requested that...
-
Explain why it is important to separately account for the principal and income of an estate and what happens if such assets are not adequate to satisfy demonstrative or general legacies.
-
On January 1, 2011, Silvio Corporation exchanged on a 1-for-3 basis common stock it held in its treasury for 80% of the outstanding stock of Jenko Company. Silvio Corporation common stock had a...
-
W hat is diauxic growth? Explain the roles of cAMP and CAP in this process.
-
What is antisense RNA? How does it affect the translation of a complementary mRNA?
-
List and describe three general ways that the functions of transcription factors can be modulated.
Study smarter with the SolutionInn App