FIN 300 Study Guide - Final Guide: Capital Asset Pricing Model, Preferred Stock, Capital Cost Allowance
Document Summary
Get access
Related Documents
Related Questions
I just need help with the chart at the bottom. Here is all the information for the company.
Accounts receivable for 2015__$300____
Total current assets= cash and marketable securities + account rec + inventory
1,542=347+a/r+895
Accounts rec = $300
Accounts payable for 2014__$319_____
Total Current Liabilities = Accrued Wages and taxes + Accounts Payable + Notes Payable
997 = 257 + Accounts Payable + 421
Accounts Payable = $319
c. Gross plant and equipment for 2015_$3,159______
Net Plant and Equipment = Gross Plant and Equipment – Depreciation
2,872 = Gross Plant and Equipment – 287
Gross Plant and Equipment = $3,159
d. Long-term debt for 2014__$132_____
Total Debt = Long-term Debt + Current Liabilities
1,129 = Long-term Debt + 997
Long-term Debt = $132
e. Common stock and paid-in surplus (250 million shares) for 2014 $300
Total Equity = Preferred Stock + Common Stock and paid surplus + Retained Earnings
1,472 = 30 + Common Stock and paid surplus + 1,142
Common Stock and paid surplus = $300
f. Total FA for 2015 $3,393
Total FA = Net Plant and Equipment + Other long-term assets
Total FA = $2,872 + 521
Total FA = $3,393
g. Net sales for 2015_______
Net Sales – Cost of Goods Sold = Gross Profit
Net Sales – 987 = 1,396
Net Sales = $2,383
h. Less: Cost of goods sold for 2014_______
Net Sales – Cost of Goods Sold = Gross Profit
2,018 - Cost of Goods Sold = 1,189
Cost of Goods Sold = $829
i. Less: Interest for 2015_______
EBIT- Interest = EBT
1,086 – Interest = 949
Interest = $137
j. Less: Taxes for 2015_______
Net Income = EBT – Taxes
644 = 949 – Taxes
Taxes = $305
k. Earnings per share (EPS) for 2015_______
Earning per share for 2015 = Net Income available to Common Stockholders / No of Common Stocks
Earning per share =566 / 250
Earning per share = $2.27 per share
l. Dividends per share (DPS) for 2014_______
Dividend per share = Common stock Dividend/ No of Common Stocks
Dividend per share = 219/250
Dividend per share = $0.88 per share
m. Book value per share (BVPS) for 2015_______
Book value per share= total common stockholder’s equity/No of Common Stocks
Book value per share= 1,789/250
Book value per share= 7.16
n. Net income $664
o. Increase in accrued wages and taxes $309-$257= $52
p. Increase in inventory –(895-797)= $ -98
q. Net cash flow from operating activities 664+287+52+62-41-98=$926
r. Increase in other long-term assets –(521-487)= $-34
s. Net cash flow from investing activities -343-34=-377
t. Increase in notes payable 492-421= 71
u. Pay dividends 98+219= 317
v. Net cash flow from financing activities 71+147-317= -99
w. Plus: Net income for 2015 $664
x. Preferred stock $98
Worldwide Widget Manufacturing, Inc.
Company | Industry | Comparison | |
Current Ratio | 2.2 times | ||
Quick Ratio | 1.1 times | ||
Cash Ratio | 0.35 times | ||
Inventory Turnover | 2 times or 1 time | ||
Days' sales in inventory | 135 days or 335 days | ||
Average payment period | 110 days | ||
Sales to working capital | 3 times | ||
total asset turnover | 0.6 times | ||
debt to equity | 1.1 times | ||
profit margin | 16.5% | ||
gross profit margin | 48.13% | ||
ROA | 8.78% | ||
ROE | 19.45% | ||
Dividend payout | 32% |
A. Use the information found in Worldwide Widget Manufacturing’s financial statements to calculate all of the listed financial ratios in the above table for your company. Then, for each ratio, provide a comparison of the company’s result with the industry standards, indicating if your company’s results are lower than, higher than, slower than, or faster than the industry standards.
B. Calculate your company’s internal and sustainable growth rates.
Additional funds needed
Morrissey Technologies Inc.'s 2012 financial statements are shown here.
Morrissey Technologies Inc.: Balance Sheet as of December 31, 2012 | ||||
Cash | $180,000 | Accounts payable | $360,000 | |
Receivables | 360,000 | Notes payable | 56,000 | |
Inventories | 720,000 | Accrued liabilities | 180,000 | |
Total current assets | $1,260,000 | Total current liabilities | $596,000 | |
Long-term debt | 100,000 | |||
Fixed assets | 1,440,000 | Common stock | 1,800,000 | |
Retained earnings | 204,000 | |||
Total assets | $2,700,000 | Total liabilities and equity | $2,700,000 |
Morrissey Technologies Inc.: Income Statement for December 31, 2012 | |||
Sales | $3,600,000 | ||
Operating costs including depreciation | 3,279,720 | ||
EBIT | $320,280 | ||
Interest | 20,280 | ||
EBT | $300,000 | ||
Taxes (40%) | 120,000 | ||
Net Income | $180,000 | ||
Per Share Data: | |||
Common stock price | $45.00 | ||
Earnings per share (EPS) | $1.80 | ||
Dividends per share (DPS) | $1.08 |
Suppose that in 2013, sales increase by 15% over 2012 sales. The firm currently has 100,000 shares outstanding. It expects to maintain its 2012 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would like to reduce its Operating costs/Sales ratio to 89.5% and increase its total debt-to-assets ratio to 30%. (It believes that its current debt ratio is too low relative to the industry average.) The firm will raise 30% of 2013 forecasted total debt as notes payable, and it will issue long-term bonds for the remainder. The firm forecasts that its before-tax cost of debt (which includes both short-term and long-term debt) is 12%. Assume that any common stock issuances or repurchases can be made at the firm's current stock price of $45.
- Construct the forecasted financial statements assuming that these changes are made. What are the firm's forecasted notes payable and long-term debt balances? What is the forecasted addition to retained earnings? Round your answers to the nearest cent.
Morrissey Technologies Inc. Pro Forma Income Statement December 31, 2013 2012 2013 Pro Forma Sales $3,600,000 $ Operating costs (includes depreciation) 3,279,720 $ EBIT $320,280 $ Interest expense 20,280 $ EBT $300,000 $ Taxes (40%) 120,000 $ Net Income $180,000 $ Dividends $ $ Addition to RE $ $ Morrissey Technologies Inc. Pro Forma Balance Statement December 31, 2013 2012 2013 Pro Forma Cash $180,000 $ Accounts receivable 360,000 $ Inventories 720,000 $ Fixed assets 1,440,000 $ Total assets $2,700,000 $ Payables + accruals $540,000 $ Short-term bank loans 56,000 $ Total current liabilities $596,000 $ Long-term bonds 100,000 $ Total debt $696,000 $ Common stock 1,800,000 $ Retained earnings 204,000 $ Total common equity $2,004,000 $ Total liab. and equity $2,700,000 $ - If the profit margin remains at 5% and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In otherwords, what is the firm's sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.) Round your answer to two decimal places.
%