Use the following income statement and balance sheets to answer the three questions below the...
80.2K
Verified Solution
Link Copied!
Question
Finance
Use the following income statement and balance sheets to answer the three questions below the financial information: Sales COGS Selling and Admin Depreciation EBIT Interest EBT 2021 450,437 258,493 99,406 35,400 57,138 22,000 35,138 8,785 26,354 Taxes Net income 2020 7633 11489 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets 2020 10,615 15,137 10,993 $36,745 274,471 $311,216 2021 11,402 16,815 18,134 $46,351 323,808 $370,159 Accounts payable Notes payable Current liabilities Long-term debt Owners' equity Total liabilities and owners' equity $19, 122 108,600 $183,494 $311,216 2021 8,455 13,123 $21,578 121,140 227,441 $370,159 1) Calculate the following ratios for 2021: Current ratio, quick ratio, asset turnover, inventory turnover, receivables turnover, return on assets, return on equity, profit margin, and equity multiplier. Additionally, use the Dupont identity to deconstruct ROE. 2) The Company expects sales to grow by 15% in 2022. Assets, costs, and current liabilities are proportional to sales. Depreciation, interest, long-term debt and notes payable will remain the same year over year and not increase at the 15% rate. The company maintains a constant 30 percent dividend payout ratio and pays taxes at a 25% rate. What is the external financing needed? Use the percentage of sales method. 3) Using the information from 2022, what is the Company's internal growth rate? Sustainable growth rate? If the Company wanted to grow faster than their internal growth rate but did not want to use external funding, what advice might you give them to increase their internal growth rate? Use the following income statement and balance sheets to answer the three questions below the financial information: Sales COGS Selling and Admin Depreciation EBIT Interest EBT 2021 450,437 258,493 99,406 35,400 57,138 22,000 35,138 8,785 26,354 Taxes Net income 2020 7633 11489 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets 2020 10,615 15,137 10,993 $36,745 274,471 $311,216 2021 11,402 16,815 18,134 $46,351 323,808 $370,159 Accounts payable Notes payable Current liabilities Long-term debt Owners' equity Total liabilities and owners' equity $19, 122 108,600 $183,494 $311,216 2021 8,455 13,123 $21,578 121,140 227,441 $370,159 1) Calculate the following ratios for 2021: Current ratio, quick ratio, asset turnover, inventory turnover, receivables turnover, return on assets, return on equity, profit margin, and equity multiplier. Additionally, use the Dupont identity to deconstruct ROE. 2) The Company expects sales to grow by 15% in 2022. Assets, costs, and current liabilities are proportional to sales. Depreciation, interest, long-term debt and notes payable will remain the same year over year and not increase at the 15% rate. The company maintains a constant 30 percent dividend payout ratio and pays taxes at a 25% rate. What is the external financing needed? Use the percentage of sales method. 3) Using the information from 2022, what is the Company's internal growth rate? Sustainable growth rate? If the Company wanted to grow faster than their internal growth rate but did not want to use external funding, what advice might you give them to increase their internal growth rate
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!