In: Accounting
f 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
Assume the following:
• Free cash flow (FCF) will grow at 2.5%
• Galaxy's equity beta is 1.50
• Risk-free rate is 3% and market return is 13%
• Currently, Galaxy is not paying any dividends
• Book value of total debt is equal to the market value of debt
• further note that, FCF (Free cash flow) = EBIT*(1-t) + depreciation - NCS - change in NWC
approx. $125
approx. $199
approx. $375
approx. $258
| 
 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  | 
||||