FIN 300 Study Guide - Final Guide: Fixed Asset, Balance Sheet, Annual Percentage Rate
Document Summary
Get access
Related Documents
Related Questions
Question
Analysis of Financial Statements
Balance Sheets
EXHIBITS: INPUT DATA (XYZ)
Table 1 Balance Sheets
Assets | 2013E | 2012 | 2011 |
cash | $ 85,632 | $7,282 | $57,600 |
Acount Receivable | 878,000 | 632,160 | 351,200 |
Inventories | 1,716,480 | 1,287,360 | 715,200 |
Total current assets | $2,680,112 | $1,926,802 | $ 1,124,000 |
Gross fixed assets | 1,197,160 | 1,202,950 | 491,000 |
Less: accumulated depreciation | 380,120 | 263,160 | 146,200 |
Net fixed assets | $ 817,040 | $ 939,790 | $ 344,800 |
Total assets | $3,497,152 | $2,866,592 | $ 1,468,800 |
Liabilities and equity | |||
Accounts payable | $ 436,800 | $ 524,160 | $ 145,600 |
Notes payable | 300,000 | 636,808 | 200,000 |
Accruals | 408,000 | 489,600 | 136,000 |
Total current liabilities | $1,144,800 | $1,650,568 | $ 481,600 |
Long term bonds | 400,000 | 723,432 | 323,432 |
Total debt | $1,544,800 | $2,374,000 | $ 805,032 |
Common stock (100,000 shares) | 1,721,176 | 460,000 | 460,000 |
Retained earnings | 231,176 | 32,592 | 203,768 |
Total common equity | $1,952,352 | $ 492,592 | $ 663,768 |
Total liabilities and equity | $3,497,152 | $2,866,592 | $ 1,468,800 |
Analysis of Financial Statements
Income Statements
Table 2
Income Statements
2013E | 2012 | 2011 | |
Sales | $7,035,600 | $6,034,000 | $ 3,432,000 |
Cost of goods sold | 5,875,992 | 5,528,000 | 2,864,000 |
Other expenses | 550,000 | 519,988 | 358,672 |
Total operating exp. excl. depreciation and amortization | $6,425,992 | $6,047,988 | $ 3,222,672 |
EBITDA | $ 609,608 | $(13,988) | $ 209,328 |
Depreciation and amortization | 116,960 | 116,960 | 18,900 |
Earnings before interest and taxes (EBIT) | $492,648 | $(130,948) | $190,428 |
Interest expense | 70,008 | 136,012 | 43,828 |
Earnings before taxes (EBT) | $ 422,640 | $ (266,960) | $ 146,600 |
Taxes (40%) | 169,056 | (106,784) | 58,640 |
Net Income | $ 253,584 | $ (160,176) | $ 87,960 |
Earnings per share (EPS) | $ 1.014 | $ (1.602) | $ 0.880 |
Dividends per share (DPS) | $ 0.220 | $ 0.110 | $ 0.220 |
Book value per share (BVPS) | $ 7.809 | $ 4.926 | $ 6.638 |
Stock price | $ 12.17 | $ 2.25 | $ 8.50 |
Shares outstanding | 250,000 | 100,000 | 100,000 |
Tax rate | 40.00% | 40.00% | 40.00% |
Lease payments | $ 40,000 | $ 40,000 | $ 40,000 |
Sinking fund payments | 0 | 0 | 0 |
Analysis of Financial Statements
Ratio Analysis
2013E | 2012 | 2011 | Industry Average | |
Current ratio | * | 1.2 | 2.3 | 2.7 |
Quick ratio | * | 0.4 | 0.8 | 1.0 |
Inventory turnover | * | 4.7 | 4.8 | 6.1 |
Days sales outstanding (DSO) | * | 38.2 | 37.4 | 32.0 |
Fixed assets turnover | * | 6.4 | 10.0 | 7.0 |
Total assets turnover | * | 2.1 | 2.3 | 2.6 |
Debt-to- assets ratio | * | 82.8% | 54.8% | 50.0% |
Times interest earned (TIE) | * | -1.0 | 4.3 | 6.2 |
Operating margin | * | -2.2% | 5.6% | 7.3% |
Profit margin | * | -2.7% | 2.6% | 3.5% |
Basic earning power (BEP) | * | -4.6% | 13.0% | 19.1% |
Return on assets(ROA) | * | -5.6% | 6.0% | 9.1% |
Return on equity (ROE) | * | -32.5% | 13.3% | 18.2% |
Price/earnings (P/E) | * | -1.4 | 9.7 | 14.2 |
Market/book (M/B) | * | 0.5 | 1.3 | 2.4 |
Book value per share (BVPS) | * | $4.93 | $6.64 | n.a. |
Requiremnts:
Note: Question 1 through 5 has been answered completley, thank you very much. Please I am waiting for the question 6 and 7.
6. Use the extended DuPont equation to provide a summary and overview of XYZâs financial condition as projected for 2013.
7. Use the following simplified 2013 balance sheet to show, in general terms, how an improvement in the DSO would tend to affect the stock price. For example, if the company could improve its collection procedures and thereby lower its DSO from 45.6 days to the 32-day industry average without affecting sales, how would that change âripple throughâ the financial statements (shown in thousands below) and influence the stock price?
Accounts receivable $878 Debt $1,545
Other current assets 1,802
Net fixed assets 817 Equity 1,952
Total assets $3,497 Liabilities plus equity $3,497
First, we need to calculate XYZâs daily sales.
Daily sales = Sales / 365
Daily sales = $7,035,600 / 365
Daily sales = $19,275.62
Target A/R = Daily sales à Target DSO
Target A/R = $19,276 Ã 32
Target A/R = $616,820
Freed-up cash = old A/R â new A/R
Freed-up cash = $878,000 â $616,820
Freed-up cash = $261,180
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.