To determine: The sustainable growth rate of the given company, external funds needed for the given company, pro forma income statement, pro forma balance sheet at sustainable growth rate and the financial ratios.
Sustainable Growth Rate:
It refers to the maximum growth that a company can have without using external funds or increasing the financial leverage of the company.
External Funds:
It refers to the funds that have been provided to the business or company from outside. These funds could be for short term, that is, for a period of less than 1 year or long term, that is, for the period of more than 1 year, which is decided on the basis of need of the funds.
Financial Ratios:
It refers to the measure of comparing and investing the relationships between different aspects of financial information.
Explanation of Solution
Solution:
Given,
Company ECY has recently employed Person DE to provide assistance in the short-term financial planning and the financial performance of the company. Person LW, the founder of Company ECY has provided the below information to Person DE in order to start his analyses:
Inventory of the company is $6,627,300.
Current assets of the company are $15,823,700.
Current liabilities of the company care $21,320,300.
Sales of the company are $210,900,000.
Total assets of the company are $117,304,900.
Cost of goods sold is $148,600,000.
Accounts receivables of the company are $5,910,800.
Total debt of the company is
EBIT of the company is $30,229,000.
Interest of the company is $3,791,000.
Net income of the company is $15,862,800.
Total equity of the company is $59,584,600.
The formula to calculate sustainable growth rate is,
ROE refers to
Where d is the dividend payout ratio.
Substitute 26.62% for ROE and 30% for d in the above formula.
The sustainable growth of the company is 22.90 or 23%.
Pro forma income statement when growth rate is 23% is,
E.C Company Pro forma Income Statement | |
Particulars | Amount |
Sales
|
259,407,000 |
Cost of goods sold
|
(182,778,000) |
Other expenses
|
(30,986,160) |
Depreciation | (6,879,000) |
Earnings before interest and taxes (EBIT) | 38,763,840 |
Interest | (3,791,000) |
Taxable income | 34,972,840 |
Taxes (40%) | (13,989,136) |
Net Income | 20,983,704 |
Dividends
|
(6,295,111) |
Addition to |
14,688,593 |
Table (1)
Pro forma balance sheet is,
E.C Company Pro forma Balance Sheet ($ in millions) | |
Assets | Amount |
Current Assets | |
Cash
|
4,041,288 |
Accounts Receivable
|
7,270,284 |
Inventory
|
8,151,579 |
Total Current Assets | 19,463,151 |
Fixed Assets | |
Net plant and equipment
|
124,821,876 |
Total Assets | 144,285,027 |
Liabilities and Owners’ Equity | |
Current Liabilities | |
Accounts payable
|
8,582,571 |
Notes payable
|
17,641,398 |
Total Current Liabilities | 26,223,969 |
Long Term Debts | 36,400,000 |
Owner’s Equity | |
Common Stock | 5,580,000 |
Retained Earnings
|
66,427,872 |
Total liabilities and owners’ equity | 134,631,841 |
Table (2)
The formula to calculate additional funds needed is,
Substitute $144,285,027 for total assets and $134,631,841for total liabilities and equity in the above formula.
External funds needed are $9,653,186 million.
The formula to calculate current ratio is,
Substitute $19,463,151 for current assets and $22,925,171 for current liabilities in the above formula.
Current ratio of the company is 0.85.
The formula to calculate quick ratio is,
Substitute $19,463,151 for current assets, $8,151,579 for inventory and $22,925,171 for current liabilities.
Quick ratio of the company is 0.49.
The formula to calculate asset turnover ratio is,
Substitute $259,407,000 for sales and $120,944,351 for total assets in the above formula.
Asset turnover ratio is 2.14.
The formula to calculate inventory turnover ratio is,
Substitute $182,778,000 for cost of goods sold and $8,151,579 in the above formula.
Inventory turnover ratio is 22.42.
The formula to calculate receivable turnover ratio is,
Substitute $259,407,000 for sales and $7,270,284 for accounts receivable in the above formula.
Receivable turnover ratio is 35.68.
The formula to calculate debt ratio is,
Substitute
Debt ratio of the company is 0.49.
The formula to calculate debt equity ratio is,
Substitute $59,325,171 for total debt and $73,239,784.48
Debt equity ratio of the company is 0.81.
The formula to calculate equity multiplier is,
Substitute $120,944,351 for total asset and $73,239,748.48 for total equity in the above formula.
Equity multiplier is 1.65.
The formula to calculate interest coverage ratio is,
Substitute $37,181,670 for EBIT and $4,662,930 for interest in the above formula.
Interest coverage ratio of the company is 7.97.
The formula to calculate profit margin is,
Substitute $19,511,244 for net income and $259,407,000 in the above formula.
The formula to calculate
Substitute $19,511,244 for net income and $120,944,351 for total asset.
Return on asset is 16.13%.
The formula to calculate return on equity is,
Substitute $19,511,244 for net income and $73,239,748.48 for total equity in the above formula.
Return on equity of the company is 26.64%.
The formula to calculate dividend payout percentage is,
Substitute $4,759,301 for dividend and $15,862,800 for net income in the above formula.
Dividend payout ratio of the company is 30%.
The formula to calculate retention payout percentage is,
Substitute $4,759,301 for dividend and $15,862,800 for net income in the above formula.
Retention payout ratio of the company is 70%.
Thus, the ratios those are dependent on the fixed asset, long term liabilities or common stock are changed due to the growth level of the company and rest ratios are same.
Want to see more full solutions like this?
Chapter 3 Solutions
UPENN: LOOSE LEAF CORP.FIN W/CONNECT
- You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forwardYou have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forwardYou have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forward
- You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,020,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,940,000 2,040,000 Inventory 3,660,000 2,100,000 Prepaid expenses 270,000 210,000 Total current assets 7,890,000 5,910,000 Plant and equipment, net 9,640,000 9,110,000 Total assets $ 17,530,000 $ 15,020,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,070,000 $ 3,100,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,770,000 6,200,000…arrow_forwardYou have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forwardYou have received $1,000,000 from an insurance policy that matured. You would like to invest some of that money in either Sagicor investments or Accesss limited- two companies that you believe are doing well financially. You decided to analyze the financial statements of the companies to help you decide which one is performing better. You discovered the following Sagicor Access Current ratio 3:1 2:3:1 Quick ratio 1:5:1 1:1:2 Debtor collection period 35 days 30 days Creditors payment period 40 days 25 days Inventory turnover 8 times 9 times Net income percentage 15% 11% Prepare a report comparing the performance of the companies and determine which one is better to invest.arrow_forward
- You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,020,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,940,000 2,040,000 Inventory 3,660,000 2,100,000 Prepaid expenses 270,000 210,000 Total current assets 7,890,000 5,910,000 Plant and equipment, net 9,640,000 9,110,000 Total assets $ 17,530,000 $ 15,020,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,070,000 $ 3,100,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,770,000 6,200,000…arrow_forwardAssignment 1 : Select a company. It is advised to choose the organization ( if it is listed ) where you are employed for this assignment. If your organization is not listed you may choose any other listed company from your industry or related industry. · Download last 3 years annual report. · Compute the financial ratios for last 3 years and see the trend [ Profitability ratios, Liquidity ratios, Activity Ratios, Financing Ratios, and Market Ratios ] . You need to do this exercise on an excel file. · Provide explanation on the strategic implications of these ratios on your company ’ s financial standing and strategy. You may explain in 2 - 3 lines for each category of ratios. [ Profitability ratios, Liquidity ratios, Activity Ratios, Financing Ratios, and Market Ratios ] . Use the same company as the one mentioned in Assignment 1 . • Part A: Strategic Analysis • Conduct a strategic analysis using PESTLE and Porter ’ s 5 forces tools for understanding the…arrow_forwardPhilip Spencer, the owner of Wholesome Foods, has hired you to evaluate his firm's financial performance. The firm's financial data is provided below, along with an average for the financial ratios that Spencer collected on several competing peer firms. Assets 2016 2017 2018 $ 21,000 $ 20,200 $ 25,000 Cash Accounts receivable 42,000 33,000 46,000 51,000 1.200 $ 115,200 650,000 (364,000) $ 286,000 $ 401,200 84,000 1,100 $ 138,300 664,000 (394,000) $ 270,000 $ 408,300 Inventory Prepaid rent 96,000 2,000 $ 169,000 740,000 (434,000| $ 306,000 $ 475,000 Total current assets Gross property, plant, and equipment Accumulated depreciation Net property, plant, and equipment TOTAL ASSETS Debt (Liabilities) and Equity Accounts payable 2016 $ 48,000 9,500 2017 2018 $ 52,400 12,000 $ 57,000 Accrued expenses 9,000 11.500 S 69,000 $ 160,000 $ 22,200 Short-term notes 9,000 $ 75,000 $ 150,000 $ 22,200 20,000 $ 84,400 $ 185,000 $ 34,500 Total current liabilities Long-tem debt Common stock Retained…arrow_forward
- You have recently been employed as a young Finance Director of Cloud 9 Ltd which is in the production of farm equipment and as part of the company's annual exercise to review the growth of the company, you are expected to write a recommendation letter to advise Managing Director and entire management on the future of the business operations. The financials below are to assist you in the best possible way with critical analytical tools to make an informed suggestion to the team. CLOUD 9 LTD STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED DECEMBER 31 2020 2019 2018 Turnover 373,578 424,486 456,300 Cost of sales (253,604) (254,210) (198,900) Gross profit 119,974 170,276 257,400 Impairment of financial assets (2,477) (1,800) Distribution costs (87,036) (91,309) Administrative expenses (32,556) (50,656) Other operating income 2,369 10,039 Operating profit 274 36,550 Finance income 2,594 4,949 Finance costs (2,069) (2,765) Profit before income tax 799 38,734 Income tax expense (285)…arrow_forwardYou have been asked by your CEO to evaluate, analyze and calculate commonly used ratios relating to a company’s profitability, liquidity, solvency and management efficiency. Requirement: Complete the balance sheet and sales data (fill in the blanks), using the following financial data: Debt/net worth 60% x 37,000 = 22,200 (debt) = AP Acid test ratio 1.2 x 22,200 = 26,640 Asset turnover 1.5 times Day sales outstanding in accounts receivable 40 days Gross profit margin 30% Inventory turnover 6 times Balance sheet Cash…arrow_forward1. You are required to do a short financial analysis using excel (20%)a. Pick a publicly - traded US company (a lot of companies are publicly traded, examples include Walmart, Apple, Google, Amazon etc) b. Download the firms financial data from capital IQ; 2. Financial Analysis Excel Worksheet (80%)a. Using the balance sheet and income statement for analysisb. Calculate 8 ratios for the most recent 5 years (these 8 ratios are current ratio; inventory turnover; receivables turnover; total asset turnover; profit margin; equity multiplier; return on asset; return on equity), and think about the trends.c. Submit the excel worksheetGrading Criteria:This excel project is graded on completeness. You have to finish all the requirements. The data have to be from Capital IQarrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning