 # Financial Statement Analysis

Autor:   •  April 26, 2016  •  Exam  •  4,564 Words (19 Pages)  •  613 Views

Page 1 of 19

MGT 3075, Sample Midterm #1

Answer ANY 4 of the 6 questions

The total points are 100

The exam counts for 20% of your final grade

Name:  ____________________________________

1. Financial Statement Analysis

Using the financial statements provided below, calculate / answer the following for the year 2010.  You will not get points if you just wrote down the answer; please show clearly what the numerator and the denominator is, and then what that ratio equals to.

1. Market to Book ratio [2.5 points]  = Market Value of Equity / Book Value of Equity = (\$16 x 10.2m) / 126.6m = 1.29
2. Enterprise Value [2.5 points]  = Market Value of Equity + Total Debt – Cash (\$16 x 10.2m) + (239.7 + 10.5 + 39.9) – 63.6 = 389.7m
3. Current Ratio [2.5 points]  = Current Assets / Current Liabilities = 171/144 = 1.1875
4. Gross Margin [2.5 points] = Gross Profit / Sales = 109.9 / 610.1 = 0.18 or 18.01%
5. Calculate the AR-days in the two years, and then tell us whether the firm is managing its AR better than the previous year or worse? (Calculate both the numbers, and then make a statement.) [2.5 points]  AR-days = AR / Average Daily Sales = (AR x 365 / Total Sales).  AR-days for 2010 = (55.5 x 365) / 610.1 = 33.2 days.  AR-days for 2009 = (39.6 x 365) / 578.3 = 24.99 days.  This suggests that the firm is not managing its credit well, when comparing 2010 with 2009 as the number of days that they take to get payment from customers has gone up.
6. Calculate the Inventory-days in the two years, and then tell us whether the firm is managing its inventory better than the previous year or worse? (Calculate both the numbers, and then make a statement.) [2.5 points] Inventory days = Inventory / Average Daily COGS = (Inventory x 365 / COGS). Inventory days for 2010 = (45.9 x 365) / 500.2 = 33.49 days.  Inventory days for 2009 = (42.9 x 365) / 481.9 = 32.49 days.  This suggests that their inventory management has worsened slightly from 2009 to 2010. Or, given the small magnitude, one could also say that it hasn’t changed much at all.

1. ROE [2.5 points] = Net Income as a % of Book Equity = 10.6 / 126.6 = 8.37%.
2. ROA [2.5 points] = Net income as a % of Total Assets = 10.6 / 533.1 = 1.99%.
3. P/E ratio [2.5 points] = Price per Share / Earnings per Share = Market Value of Equity / Net Income = (16 x 10.2) / 10.6 = 15.40.
4. Interest Coverage Ratio (using the Net Income) [2.5 points] = Net Income / Interest Expense = 10.6 / 25.1 = 0.42 or 42.23%.

 Foogle Hoogle Company's (FHC's) Balance Sheet (\$ millions): Assets 2010 2009 Liabilities and Stockholders' Equity 2010 2009 Current Assets Current Liabilities Cash 63.6 58.5 Accounts Payable 87.6 73.5 Accounts Receivable 55.5 39.6 Short-term Debt 10.5 9.6 Inventory 45.9 42.9 Current Maturities of Long-term Debt 39.9 36.9 Other Current Assets 6.0 3.0 Other Current Liabilities 6.0 12.0 Total Current Assets 171.0 144.0 Total Current Liabilities 144.0 132.0 Long-term Assets Long-term Liabilities Land 66.6 62.1 Long-term Debt 239.7 168.9 Buildings 109.5 91.5 Capital Lease Obligations 0.0 0.0 Equipment 119.1 99.6 Total Debt 239.7 168.9 Less Accumulated Depreciation -56.1 -52.5 Deferred Taxes 22.8 22.2 Net PPE 239.1 200.7 Other Long-term Liabilities 0.0 0.0 Goodwill 60.0 0.0 Total Long-term Liabilities 262.5 191.1 Other Long-term Assets 63.0 42.0 Tota Liabilities 406.5 323.1 Total Long-term Assets 362.1 242.7 Stockholders' Equity 126.6 63.6 TOTAL ASSETS 533.1 386.7 TOTAL LIABILITIES + EQUITY 533.1 386.7 Foogle Hoogle Company's (FHC's) Income Statement (\$ millions): 2010 2009 Total Sales 610.1 578.3 COGS -500.2 -481.9 Gross Profit 109.9 96.4 SG&A -40.5 -39.0 R&D -24.6 -22.8 Depreciation and Amortization -3.6 -3.3 EBIT 41.2 31.3 Interest Expense -25.1 -15.8 Taxes -5.5 -5.3 Net Income 10.6 10.2 Dividends Paid 5.1 5.0 Price / share \$16.0 \$15.0 Shares Outstanding (millions) 10.2 8.0 Stock Options Outstanding (millions) 0.3 0.2
1. Time Value of Money
1. What is the PV of the following cashflow stream if the discount rate is 10%?  (Please write out the formula that shows how you got the final answer; you won’t earn points otherwise.)  [5 points]

0                1                2                3                4                5[pic 1][pic 2][pic 3][pic 4][pic 5]

???                5,000.00        5,250.00        5,512.50        5,788.12        6,077.53

[pic 6]

The same answer can be found by using the formula for a growing annuity (as it seems to be growing at 5%):

...

Download as:   txt (21.2 Kb)   pdf (868 Kb)   docx (707 Kb)
Continue for 18 more pages »