a) What is the retention ratio for 2012, 2013, and 2014?
b) What is the sustainable growth rate for 2012, 2013, and 2014?
c) what is the actual growth rate for 2013 and 2014?
d) what is the equity multiplier for 2012, 2013, and 2014?
Please show formulas.
2012 | 2013 | 2014 | |
EPS | 0.88 | -0.951 | 1.014 |
DPS | 0.22 | 0.11 | 0.22 |
Retention Ratio | 75.00% | 111.57% | 78.30% |
Net Income | 87,960 | -95,136 | 253,584 |
Equity | 663,768 | 557,632 | 1,977,152 |
ROE | 13.3% | -17.1% | 12.8% |
SGR | 9.94% | -19.03% | 10.04% |
Growth | 70.0% | 20.6% | |
Equity Multiplier | 2.21 | 5.18 | 1.78 |
Retention Ratio (RR) = 1 - Dividend Paid / Income = 1 - DPS / EPS
Sustainable growth rate (SGR) = ROE x RR, where ROE = Net Income / Equity
Actual Growth rate = Revenues (2013) / Revenues (2012) - 1
Equity Multiplier = Assets / Equity
a) What is the retention ratio for 2012, 2013, and 2014? b) What is the sustainable...
Find NOWC (Net Operating Profit After Taxes) for 2013 Asset Year 2014 2013 2012 Cash 14,000 7,282 9,000 Acct Receivable 878,000 632,160 351,200 Inventories 1,716,480 1,278,360 715,200 FA 817,040 939,790 344,800 Acct Payable 436,800 524,160 145,600 Accrual 408,000 489,600 136,000 Income Statement Year 2014 2013 2012 EBIT 510,640 -690,560 209,100 TAX 40% $ 2,580,720 $ 1,843,832 - $ 414,336 $ 306,384 Not enough information
Calculate the 2013 price/earnings ratio, and market/book ratio. Analysis of Financial Statements Balance Sheets EXHIBITS: INPUT DATA (XYZ) Table 1 Balance Sheets 2013E 2012 2011 Assets Cash Accounts receivable Inventories Total current assets Gross fixed assets Less: accumulated depreciation Net fixed assets Total assets $ 85,632 878,000 1,716,480 $2,680,112 1,197,160 380,120 $817,040 $3,497,152 $ 7,282 632,160 1,287,360 $1,926,802 1,202,950 263,160 939,790 $2,866,592 $ 57,600 351,200 715,200 $ 1,124,000 491,000 146,200 $ 344,800 $ 1,468,800 Liabilities and equity $ 436,800 300,000...
Calculate and compare the Pepsi and Coke based on the broader ratios. BALANCE SHEET Pepsi CokeAssets20192019Cash7,2829,000Short term investment048,600Acc. Receivable632,160351,200Inventories1,287,360715,200Total current assets1,926,8021,124,000Fixed AssetsPlant & Equipment1,202,950491,000Less: Acc dep263,160146,200939,790344,800Total assets2,866,5921,468,800 Liabilities & EquitiesCurrent liabilityA/c Payable524,160145,600Notes payable720,000200,000Accruals489,600136,000total Current liability1,733,760481,600Long-term debt1,000,000323,432Common Stock460,000460,000Retained Earning-327,168203,7681,132,832987,200Total equities2,866,5921,468,800Income StatementSales5,834,4003,432,000Cost of Goods Sold5,728,0002,864,000Other expense680,000340,000dep116,96018,900EBIT/ LOSS-690,560209,100Interest expense176,00062,500EBT/ LOSS-866,560146,600tax-34662458640net income/loss-519,93687,960 Required:Explain the broader concept of these ratio areas...
Calculate and compare the Pepsi and Coke based on the broader ratios. BALANCE SHEET Pepsi CokeAssets20192019Cash7,2829,000Short term investment048,600Acc. Receivable632,160351,200Inventories1,287,360715,200Total current assets1,926,8021,124,000Fixed AssetsPlant & Equipment1,202,950491,000Less: Acc dep263,160146,200939,790344,800Total assets2,866,5921,468,800 Liabilities & EquitiesCurrent liabilityA/c Payable524,160145,600Notes payable720,000200,000Accruals489,600136,000total Current liability1,733,760481,600Long-term debt1,000,000323,432Common Stock460,000460,000Retained Earning-327,168203,7681,132,832987,200Total equities2,866,5921,468,800Income StatementSales5,834,4003,432,000Cost of Goods Sold5,728,0002,864,000Other expense680,000340,000dep116,96018,900EBIT/ LOSS-690,560209,100Interest expense176,00062,500EBT/ LOSS-866,560146,600tax-34662458640net income/loss-519,93687,960 Required:Explain the broader concept of these ratio...
1. You are faced with the following probability distribution: Economy Recession Below Average Average Above Average Boom Probability 0.1 0.2 0.4 0.2 -30% -13% 8% 23% 45% B 15% -5% -10% 35% 18% 0.1 Assuming that you invest 40% of your money in A and 60% of your money in B, compute the followings (please show workings). a. Expected return for the portfolio b. Standard deviation for the portfolio c. Evaluate the risk reduction effect of the portfolio 2. The...
8) The latest balance sheet and income statement for Coleco Corporation are below: 2016 2017 Assets Cash and equivalents 57,600 7.282 Accounts receivable 351,200 632,160 Inventories 715,200 1.287,360 Total current assets 1,124,000 1,926,802 Net fixed assets 344.800 939,790 Total Assets 1,467.800 2.866.592 - Liabilities and Equity Accounts payable Accruals Notes Payable Total current liabilities Long-term bonds Common Equity: Common stock (100,000 shares) Retained earnings Total common equity Total liabilities & equity 145,600 136,000 200.000 481,600 323,432 524,160 489,600 636,808 1,650,568...
Holcomb and Cromworthy are forecasting a 10% increase in sales next year. Assume the company is operating at 90% capacity. The company has 100,000 shares of common stock outstanding and dividends are $0.22 per share. 1) At 90% capacity, what level will sales have to reach for the discretionary items to become spontaneous that is move-in direct proportion to sales? *4,277,777 *4,235,000 *3,975,000 2) Compute the new level of net income for the company *85,880 *80,220 *56,935 3) Compute the...
plz solve this question BALANCE SHEET Assets 2001 2000 Cash 7.282 9,000 Short term investment 0 48,600 Acc. Receivable 632,160 351,200 Inventories 1.297.380 715,200 Total current assets 1,926,802 1,124,000 Fixed Assets Plant & Equipment Less: Acc dep 1 202,950 263,160 939,790 491.000 146.200 344,800 Total assets 2,866,592 1,468,800 Liabilities & Equities Current liability Ale Payable 524 150 145,600 Notes payable 720.000 200.000 Accruals 489,600 1,733,760 136.000 461,600 total Current liability Long-term debt 1,000,000 323.432 Common Stock 460.000 460,000 Retained Earning...
Gardems was recently hired as a financial analyst by Taylor, Inc., which is a Pennsylvania based company. His first task is to conduct a financial statement analysis of firm covering the past 2 years. Assess the firm's liquidity position. Balance Sheets Cash Accounts receivable Inventory Total current assets 2012 $52,000 402,000 836,000 $1,290,000 2011 57,600 351,200 715,200 $1,124,000 Gross fixed assets Less: Accumulated depreciation Net fixed assets Total assets $527,000 166,200 $360,800 $1,650,800 $491,000 146,200 344,800 $1,468,800 Accounts payable Notes...
Q1. Calculate the 2011 current and quick ratio based on the projected balance sheet and income statement data. Q2. What can you say about the company's liquidity position in 2009, 2010, and projected in 2011? Q3: Calculate the 2011 inventory turnover, days sales outstanding, fixed assets turnover and total assets turnover. How does Computron's utilization of assets stack up against other firms? Q4: Calculate the 2011, debt, times interest earned and EBITDA coverage ratios. How does Computron compare with industry...