In: Finance
Q1. A company plans to undertake an expansion project and is evaluating two proposals, A and B.
Proposal A Proposal B
Year 0 -$150,000 -$150,000
Year 1 $50,000 $60,000
Year 2
$50,000                           $55,000
Year 3
$50,000                          
$50,000
Year 4
  $50,000                           $40,000
Year 5
  $50,000                           $35,000
Since the previous answer gave results, what is the cross-over rate?
A. 16.94%
B. 17.20%
C. 16.66%
D. 16.20%
Q2. ABC Inc. is considering purchase of a new equipment that will produce a new range of spare parts to complement its existing line of products. The new equipment will cost $500,000. Sales are expected to be around $200,000 per year and variable costs at $60,000. At the end of five years, the equipment can be sold for $100,000. Using straight line depreciation, should they purchase this equipment. Assume the cost of capital is 12% and the tax rate is 30%. Why or why not?
A. No, NPV = - $38,588.65
B. Yes, NPV = #24,000.44
C. No, NPV = - $12,086.99
D. Yes, NPV = $1,131.23
Q3. Red Hook Inc. is considering the purchase new equipment to improve their production rates. They are considering two competing offers. Offer A's equipment costs $400,000 and will help increase after-tax cash flows by $120,000 for six years. Offer B's equipment costs $700,00 and will help increase after-tax cash flows by 152,000 for 10 years. Which offer should they accept and why? Note the offers have unequal lives and assume a discount rate of 15%.
| 
 A. Choose B because EANPV= $12,523.56  | 
||
| 
 B. Choose A because EANPV = $14,305.24  | 
||
| 
 C. Choose A because EANPV = $54,127.92  | 
||
| 
 D. Choose B because EANPV = $62,852.83  | 
Q1
| Cross over rate | 16.94% | Project A | Project B | ||
| Year | Discount factor | Cash flow | Present value @ 0.1694 | Cash flow | Present value @ 0.1694 | 
| 0 | 1 | $ (150,000) | $ (150,000.00) | $ (150,000) | $ (150,000.00) | 
| 1 | 0.855139 | $ 50,000 | $ 42,756.97 | $ 60,000 | $ 51,308.36 | 
| 2 | 0.731263 | $ 50,000 | $ 36,563.17 | $ 55,000 | $ 40,219.49 | 
| 3 | 0.625332 | $ 50,000 | $ 31,266.61 | $ 50,000 | $ 31,266.61 | 
| 4 | 0.534746 | $ 50,000 | $ 26,737.31 | $ 40,000 | $ 21,389.84 | 
| 5 | 0.457282 | $ 50,000 | $ 22,864.12 | $ 35,000 | $ 16,004.89 | 
| NPV | $ 10,188.17 | $ 10,189.19 | 
Answer is 16.94% at this rate NPV is equal under both.
2
| Year | Cash flow | × factor@ 12.0% | Present value | 
| 0 | $ (500,000.00) | 1.0000 | $ (500,000.00) | 
| 1 | $ 128,000.00 | 0.8929 | $ 114,285.71 | 
| 2 | $ 128,000.00 | 0.7972 | $ 102,040.82 | 
| 3 | $ 128,000.00 | 0.7118 | $ 91,107.87 | 
| 4 | $ 128,000.00 | 0.6355 | $ 81,346.31 | 
| 5 | $ 128,000.00 | 0.5674 | $ 72,630.64 | 
| 5 | $ 70,000.00 | 0.5674 | $ 39,719.88 | 
| $ - | |||
| NPV | 4.1722 | $ 1,131.23 | 
| Particulars | Amount | 
| Sales | 200000 | 
| Less: costs | -60000 | 
| Depreciation | -100000 | 
| PBT | 40000 | 
| Less: taxes | -12,000.00 | 
| net income | 28000 | 
| Add: depreciation | 100000 | 
| Cash flow | 128000 | 
Terminal flow = 100000*(1-30%) =70000
Yes, NPV is 1,131.23
Q3
| Project A | Year | Cash flow | × discount factor | Present value | 
| $ (400,000) | $(400,000.00) | |||
| 1 | $ 120,000 | 0.869565 | $ 104,347.83 | |
| 2 | $ 120,000 | 0.756144 | $ 90,737.24 | |
| 3 | $ 120,000 | 0.657516 | $ 78,901.95 | |
| 4 | $ 120,000 | 0.571753 | $ 68,610.39 | |
| 5 | $ 120,000 | 0.497177 | $ 59,661.21 | |
| 6 | $ 120,000 | 0.432328 | $ 51,879.31 | |
| Total | 3.784483 | $ 54,137.92 | ||
| (a) | EAA - A | 54137.92/ 3.784483 | $ 14,305.24 | |
| Project B | Year | Cash flow | × discount factor | Present value | 
| $ (700,000) | $(700,000.00) | |||
| 1 | $ 152,000 | 0.869565 | $ 132,173.91 | |
| 2 | $ 152,000 | 0.756144 | $ 114,933.84 | |
| 3 | $ 152,000 | 0.657516 | $ 99,942.47 | |
| 4 | $ 152,000 | 0.571753 | $ 86,906.49 | |
| 5 | $ 152,000 | 0.497177 | $ 75,570.86 | |
| 6 | $ 152,000 | 0.432328 | $ 65,713.79 | |
| 7 | $ 152,000 | 0.375937 | $ 57,142.43 | |
| 8 | $ 152,000 | 0.326902 | $ 49,689.07 | |
| 9 | $ 152,000 | 0.284262 | $ 43,207.89 | |
| 10 | $ 152,000 | 0.247185 | $ 37,572.08 | |
| Total | 5.018769 | $ 62,852.83 | ||
| (b) | EAA - B | 62852.83/ 5.018769 | $ 12,523.56 | 
Answer is:
| 
 B. Choose A because EANPV = $14,305.24  | 
| please rate. |