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...
-
Write a memo analyzing the financial strengths and weaknesses of Angelinas venture. Use the same size analysis shown below. Would you invest in her business? Why, or why not? Exhibit 13-13...
-
The May 2010 revenue and cost information for Boise Outfitters, Inc., follows: Requirement 1. Prepare a standard cost income statement for management through gross profit. Report all standard cost...
-
All transactions involving Notes Payab Determine the amounts of the transactions affecting financing activities and show how they are to appear on the statement of cash flows for 20x7. Preparing the...
-
In 2012, the total payroll for the New York Yankees was almost $ 200 million, while the total payroll for the Oakland Athletics (a team known for using base-ball analytics or sabermetrics) was about...
-
Information on four investment proposals is given below: Required: Compute the profitability index for each investment proposal. ( Round your answers to 2 decimal places. ) Rank the proposals in...
-
After Chris completed the ratio analysis for S&S Air (see Chapter 3), Mark and Todd approached him about planning for next years sales. The company had historically used little planning for...
-
You will file 2021 Federal income tax return (treat all info as for year 2021 not year 2020). file Form 1040 and Sch. 1 (do not need Schedule A because they use standard deduction) Check Figures:...
-
Part 1: Data Protection Policy - Data Loss Prevention With our experience, our education, or our position in the organization; we are often viewed as a contact to provide our information, knowledge,...
-
The domain and codomain of the following three functions (i.e., fi(), f2() and f3()) are A and B respectively, where A = R x R and B = R. Determine whether each of the following functions is...
-
PART V. Norton Company's manufacturing costs for 2009 were as follows: Direct materials, P300, 000; Direct labor - P400,000; Factory overhead variable - P80, 000 and fixed - P50,000. 18. Prime cost...
-
Journalize the following: Cheques issued: Cash register tapes from the box office for the week show transac- tions No. 3337 to 4049 for total sales of $7483. Weekly sales report for the confectionery...
-
What is the present value of $8,000 paid at the end of each of the next 34 years if the interest rate is 9% per year? (Round to the nearest dollar.)
-
Wiley WSM Forecast return 12%. 11% Standard deviation of returns 8%. 10% Beta 1.5. 1.0 T-bill rate is 4.00% The market risk premium is 6.00% Using the Capital asset pricing model, are Wiley's and WSM...
-
At the beginning of the year, Lam Ltd. had total assets of $800,000 and total liabilities of $500,000. Use this information to answer each of the following independent questions. (a) If Lam's total...
-
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...
-
The U. S. dollar. The primary reason for using the dollar was that it provided a relatively stable benchmark, and it was accepted universally for transaction purposes.
-
Compare investments with different cash flows and residual values (Learning Objectives 2, 4) Java Cafe is considering two possible expansion plans. Plan A is to open eight cafes at a cost of...
-
Evaluate an investment using all four methods (Learning Objectives 2, 4) Zippi manufactures motorized scooters in Oakland, California. The company is con sidering an expansion. The plan calls for a...
Study smarter with the SolutionInn App