In: Finance
Hubrey Home Inc. is considering a new three-year expansion project that requires an initial fixed asset investment of $3.2 million. The fixed asset falls into Class 10 for tax purposes (CCA rate of 30% per year), and at the end of the three years can be sold for a salvage value equal to its UCC. The project is estimated to generate $2,580,000 in annual sales, with costs of $817,000. If the tax rate is 35%, what is the OCF for each year of this project? (Enter the answers in dollars. Do not round your intermediate calculations. Round the final answers to 2 decimal places. Omit $ sign in your response.)
OCF1 | $ |
OCF2 | $ |
OCF3 | $ |
Computation of Operating Cash flows
S.No | Particulars | Year 1 | Year 2 | Year 3 |
A | Annual Sales | $2,580,000 | $2,580,000 | $2,580,000 |
B | Annual Cost | $817,000 | $817,000 | $817,000 |
C | Depreciation( Wn) | $480,000 | $816,000 | $571,200 |
D | EBIT( A-B-C) | $1,283,000 | $947,000 | $1,191,800 |
E | Interest | $0 | $0 | $0 |
F | EBT( D-E) | $1,283,000 | $947,000 | $1,191,800 |
G | Taxes @ 35%( F*0.35) | $449,050.00 | $331,450.00 | $417,130.00 |
H | Net Income( F-G) | $833,950.00 | $615,550.00 | $774,670.00 |
Working Note: Depreciation
Year | Calculation | Depreciation Amount | Book Value after Depreciation |
1 | $ 3200000*30% /2 = $ 480000 | $480,000 | $ 3200000-$ 480000=$ 2720000 |
2 | $ 2720000*30% =$ 816000 | $816,000 | $ 2720000-$ 816000= $ 1904000 |
3 | $ 1904000*30% = $ 571200 | $571,200 | $ 1904000-$ 571200=$ 1332800 |
We know that Operating Cash flow = EBIT + Depreciation - Taxes
Year | EBIT | Depreciation | Taxes | Operating Income = EBIT + Depreciation - Taxes |
1 | $1,283,000 | $480,000.00 | $449,050.00 | $1,313,950.00 |
2 | $947,000 | $816,000.00 | $331,450.00 | $1,431,550.00 |
3 | $1,191,800 | $571,200.00 | $417,130.00 | $1,345,870.00 |
OCF1 | 1313950 |
OCF2 | 1431550 |
OCF 3 | 1345870 |
If you are having any doubt, Plesae post a comment.
Thank you. Please rate it.