For the balance sheet, treat bank loans as short term loans and bonds payable as
ID: 2766968 • Letter: F
Question
For the balance sheet, treat bank loans as short term loans and bonds payable as long term loans. The market value of debt is equal to the sum of bank loans and bonds payable.
You can find EBIT and depreciation information from the financial statement, you can also use the information in financial statements to calculate changes in net working capital. In addition to the financial statements, you also know the following information: The tax rate is 62.5%, the capital expenditure of 2007 is 40,000. The interest rate on firm’s debt is 10%, the target capital structure for debt is equal to the sum of short term loan and long term loan divided by total assets, the rest is in equity.
A comparable firm with similar capital structure has a beta of 1.2 and a price to ebitda ratio of 10. The risk free rate is 2% and a market risk premium is 8%. Analyst forecast that the firm is going to grow by 30% for the next two years.
Given the information, what is the firm’s intrinsic equity value at the end of 2007 based on forecast using FCFF approach (calculate TV using multiplier approach)? If you assume the firm is going to grow at a constant rate of 3% after the forecast period, what is the intrinsic equity value if you calculate terminal value using constant growth rate formula?
Hint: Remember for calculating changes in current assets and changes in current liability, exclude changes in cash and short term investment as well as changes in short term debt.
Flathead Lake Manufacturing Income Statement 2007 Sales Cost of Goods Sold Depreciation Gross Profit Selling and administrative expenses EBIT Interest Expense Income before tax Taxes Net Income $ 9,300,000 $5,750,000 $ 550,000 3,000,000 800,000 200,000 600,000 $ 375,000 $225,000 2006 $ 40,000 $ 600,000 S 460000 $1,100,000 $1,400 $2,500,000 Flathead Lake Manufacturing Balance Sheet 2007 $50,000 570,000 530,000 $1,150,000 $ 2,050,000 $ 3,200,000 Accounts Receivable Inventory Total Current Assets Fixed Assets Total Assets $320,000 480,000 $800,000 $ 300,000 $ 400 s 700,000 $1,000 $1,700,000 $ 200,000 S 600 $800 $2,500,000 Accounts Payable Bank loans Total current liabilities Bonds payable Total liabilities $2,300,000 200,000 $ 700,000 900,000 $ 3200,000 Common Stock (200,000 shares) Retained Earnings Total Equity Total Liabilities and shareholders' equityExplanation / Answer
To calculate free cash flow to firm, we need to first see what we need
FCFF = CF from operations + interest * ( 1 - tax rate) - capital expenditure
CF from operations
Net Income = 225000
+ depreciation = 550000
Cash profit = 775000
+ changes in the working capital from 2006 to 2007
+ decrease in receivables = 30000
- increase in inventory = - 70000
+ increase in accounts payable = 20000
+ bank loan = 80000
Cash flow from operations = 835000
FCFF = 835000 + 20000* (1- 62.5% tax)- 40000 (capital expenditure )
= 870000
The ebitda = 800000(ebit) + 550000 (depriciation) = 1350000
So, Price = 1350000*10 = 13,500,000
discounting rate = weight of debt * cost of debt + equity weight * cost of equity
=1980000/2880000 * (10% -62.5% tax) + 900000/ 2880000 * (2% + 8%*1.2)
= 2.57 + 3.625 = 6.2%
FCFF
year 1 = 870000* (1+ 30% ) = 1131000
year 2 = 1131000 *1.3 = 1470300
using constant growth rate formula
terminal value at year 2 = value at year 3 (13500000) / (6.2% - 3%) = 42187500
FCFF today = 1131000/1.062 + 1470300/1.062^2 + 42187500/1.062^2 = 39774048
value of equity = fcff - value of debt = 39774048 - 1980000 = 37794048