In: Finance
Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.97 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $2,170,000 in annual sales, with costs of $847,000. The project requires an initial investment in net working capital of $390,000, and the fixed asset will have a market value of $255,000 at the end of the project.
a. If the tax rate is 24 percent, what is the project’s Year 1 net cash flow? Year 2? Year 3? Table 8.3. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.)
b. If the required return is 9 percent, what is the project's NPV?(Enter your answer in dollars, not millions of dollars. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 1,234,567.89.)
Given initial investment =$ 29,70000
Computation of Cash flow
| S.No | Particulars | Year 1 | Year 2 | Year 3 | 
| A | Annual sales | $2,170,000 | $2,170,000 | $2,170,000 | 
| B | Cost | $847,000 | $847,000 | $847,000 | 
| C | Depreciation | $989,901 | $1,320,165 | $439,857 | 
| D | Profit Before Tax ( A-B-C) | $333,099 | $2,835 | $883,143 | 
| E | Tax@ 24% | $79,943.76 | $680.40 | $211,954.32 | 
| F | Profit After Tax | $253,155.24 | $2,154.60 | $671,188.68 | 
| G | Operating Cash flow( F+C) | $1,243,056.24 | $1,322,319.60 | $1,111,045.68 | 
| H | After tax sale proceeds | $26,541.48 | ||
| I | Recovery of Working Capital | $390,000.00 | ||
| J | Total Cash flow( G++H+I) | $1,243,056.24 | $1,322,319.60 | $1,527,587.16 | 
Computation of Depreciation amount.
| Year | Applicable Depreciation % | Depreciation amount | 
| 1 | 33.33% | $ 2970000*33.33% = 989901 | 
| 2 | 44.45% | $ 2970000*44.45%=1320165 | 
| 3 | 14.81% | $ 2970000*14.81% = 439857 | 
Computation of Book value of Asset at the Year end 3
Book value of an Asset = Cost of Asset - ( Accumulated Depreciation)
= $ 2970000-( $ 989901+$ 1320165+$ 439857)
= $ 2970000-$ 2749923
= $ 220077
Computation of After Tax proceeds
| S.No | Particulars | Amount | 
| A | Book value of Asset at year 3 | $220,077.00 | 
| B | Market value of Equipment | $255,000 | 
| C | Gain on sale of Equpment ( B-A) | $34,923.00 | 
| D | Tax @ 24% on C | $8,381.52 | 
| E | After Tax sale proceeds ( C-D) | $26,541.48 | 
b) Computation of Net present value
| Year | Cash flow | Disc @ 9% [ 1/ ( 1+i)^n] | Discounting factor | Discounted Cash flow ( Cash flow* Discounting factor) | 
| 0 | ($3,360,000) | 1/( 1.09)^0 | 1 | ($3,360,000.0000) | 
| 1 | $1,243,056.24 | 1/ ( 1.09)^1 | 0.917431193 | $1,140,418.5688 | 
| 2 | $1,322,319.60 | 1/ ( 1.09)^2 | 0.841679993 | $1,112,969.9520 | 
| 3 | $1,527,587.16 | 1/ ( 1.09)^3 | 0.77218348 | $1,179,577.5693 | 
| Net Present Value | $72,966.09 | 
* Cash flow in Year 0= Initial investment + Working capital
= $ 2970000+$ 390000= $ 3360000
Hence the Projects Net present value is $ 72966.09