In: Finance
you are the CFO of the Imaginary Products Co. the company provides the following information about its capital structure:
Debt: the firm has 200,00 bonds outstanding with a pair value of $1,000, pays 9 percent interest (semi- annual coupon payments), have a maturity of 15 years and have a quoted price of 137.55 per bond.
preferred shares: the firm also has an issue of 2 million preferred shares outstanding with a market price of $12.00 per share. the preferred shares pay an annual dividend of 2.4 percent of the par value of $50.00.
common stock: the company also has 14 million shares of common stock outstanding with a price of $20.00 per share. the firm is expected to pay a $2.20 common dividend one year from today, and that dividend is expected to increase by 5 percent per year forever.
the firm is considering a 3 year expansion project (same operations as the existing projects of the firm) that requires a purchase of a machine of $210,000. there will be an increase in inventory of $150,000, accounts receiveable of $35,000, and accounts payable of $75,000. the machine will be in the 3- year MARCS class and the annual depreciation rates are 33 percent in year 1, 44 percent in year 2, 15 percent in year 3, and 8 percent in year 4.
the project is expected to generate Earnings Before Interest, Taxes, Deprecation, and Amortization (EBITDA) of $80,000 each year. At the end of the project (year 3) the machine can be sold for $25,000. the firms tax rate is 21 percent.
what are the free cash flows in years 0,1,2, and 3?
| Calculation of free cahs flows | ||||
| Particulars | 0 | 1 | 2 | 3 | 
| Initial Investment | ||||
| Cost of Machine | -210000 | |||
| 
Investement in net working capital ($150,000 + $35,000 - $$75,000)  | 
-110000 | |||
| Net Investment (A) | -320000 | |||
| Operating Cash Flows | ||||
| EBDITA (B) | 80000 | 80000 | 80000 | |
| 
Depreciation (C ) $210,000 * 33%, 44% , 15%  | 
69300 | 92400 | 31500 | |
| Profit Before Tax (D = B-C) | 10700 | -12400 | 48500 | |
| Tax @21% (E = D*21%) | 2247 | -2604 | 10185 | |
| Profit After Tax (F = D-E) | 8453 | -9796 | 38315 | |
| Add back Depreciaiton (G = C) | 69300 | 92400 | 31500 | |
| Net Operating Cahs Flows (H = F+G) | 77753 | 82604 | 69815 | |
| Terminal Value | ||||
| Sale Value (I) | 25000 | |||
| Book value (J = $210,000 * 8%) | 16800 | |||
| Profit on sale (K = I-J) | 8200 | |||
| Tax on profit (L = K*21%) | 1722 | |||
| After tax sale value (M = I-L) | 23278 | |||
| Recovery of working capital (N) | 110000 | |||
| Net Terminal Value (O = M+N) | 133278 | |||
| Free Cash Flows (P = A+H+O) | -320000 | 77753 | 82604 | 203093 | 
| Free Cash Flow in Year 0 is -$320,000 | ||||
| Free Cash Flow in Year 1 is $77,753 | ||||
| Free Cash Flow in Year 2 is $82,604 | ||||
| Free Cash Flow in Year 3 is $203,093 |