In: Finance
If there are 500 million shares outstanding, use the following information to find a fair value for Galaxy Interiors stock using the Free Cash Flow (FCF) model.
| 
 GALAXY INTERIORS INCOME STATEMENT  | 
|||
| 
 ($ in millions)  | 
|||
| 
 NET SALES  | 
 $ 35,000  | 
||
| 
 COST OF GOODS SOLD  | 
 $ 17,500  | 
||
| 
 DEPRECIATION  | 
 $ 2,500  | 
||
| 
 EARNINGS BEFORE INTEREST AND TAXES (EBIT)  | 
 $ 15,000  | 
||
| 
 INTEREST EXPENSE  | 
 $ 1,300  | 
||
| 
 TAXABLE INCOME (EARNINGS BEFORE TAXES; EBT)  | 
 $ 13,700  | 
||
| 
 TAXES (0.30)  | 
 $ 4,110  | 
||
| 
 NET INCOME  | 
 $ 9,590  | 
||
| 
 GALAXY INTERIORS BALANCE SHEET (PAST & CURRENT)  | 
||||||
| 
 ($ IN MILLIONS)  | 
||||||
| 
 PAST YR  | 
 CURRENT YR  | 
 PAST YR  | 
 CURRENT YR  | 
|||
| 
 CURRENT ASSETS  | 
 5500  | 
 6700  | 
 CURRENT LIABILITIES  | 
 2200  | 
 3000  | 
|
| 
 (NET) FIXED ASSETS  | 
 25000  | 
 27000  | 
 LONG TERM DEBT  | 
 9300  | 
 9700  | 
|
| 
 TOTAL ASSETS  | 
 30500  | 
 33700  | 
 TOTAL EQUITY  | 
 19000  | 
 21000  | 
|
| 
 TOTAL LIAB & EQUITY  | 
 30500  | 
 33700  | 
||||
Also, assume the following:
| 
 approx. $125  | 
||
| 
 approx. $199  | 
||
| 
 approx. $375  | 
||
| 
 approx. $258  | 
FCFF (Free cash flow to the Firm) is the cash flow that is available to all the investors of a firm (shareholders + debt investors) after the firm has met all its expenses.
FCFE (Free cash flow to equity) is the cash flow that is available to only the shareholders of a firm once all the expenses including expense to the debt holders is taken care of.
Here we are ssupposed to find a fair value for Galaxy Interiors stock. There are 2 approches:
1. Common equity can be valued directly by using FCFE
2. Common equity can be valued indirectly by first using a FCFF model to estimate the value of the firm and then subtracting the value of non-common-stock capital (usually debt) from FCFF
Here I will be using the Approach 1.

and FCFE can be found from FCFF

= 27000-25000 = 2000
includes the current asset and current liablities. I am assuming
here that cash part of current asset is 0
Increase in current asset is use of cash. Increase in current liabilities is a source of cash
= -(6700-5500)+ (3000-2200) = -1200+800 = -400
-ve sign just indicates that it is a outflow of cash.
= 10600
Its also mentioned that FCF will grow at 2.5%. As the growth rate is constant, we can use growth model to value the firm
Cost of equity r can be found using CAPM Model
= 0.03 + 1.5 (0.13-.03) = 0.18 = 18%


= 70096.77
Value of equity = Value of firm - MV of debt
Equity value = 70096.77 - 9700 = 60396.77 M
Shares outstanding = 500 M
Fair value per share = Equity value of firm / Shares outstanding = approx $125