In: Finance
1. i) Your factory has been offered a contract to produce a part for a new printer. The contract would last for 33years and your cash flows from the contract would be $ 5.22 million per year. Your upfront setup costs to be ready to produce the part would be $7.86million. Your discount rate for this contract is 7.5%.
a) The NPV of the project is ____ millions (Round to two decimals)
(Also, SHOW HOW TO PUT IT IN THE TI-83 CALCULATOR)
ii) You are a real estate agent thinking of placing a sign advertising your services at a local bus stop. The sign will cost $4,700and will be posted for one year. You expect that it will generate additional revenue of $564 a month. What is the paybackperiod? (Round to one decimal) (Also, SHOW HOW TO PUT IT IN THE TI-83 CALCULATOR)
iii) You have been offered a unique investment opportunity. If you invest $11,200today, you will receive $560 one year from now, $1,680 two years from now, and $11,200 ten years from now.
a. What is the NPV of the opportunity if the cost of capital is 5.4% per year? Should you take the opportunity?
b. What is the NPV of the opportunity if the cost of capital is 1.4%per year? Should you take it now?
| Solution | |||||
| Question 1 | |||||
| intial investments =$7.86 millions | |||||
| Contract is for (n) =33 years | |||||
| Per year inflow of cash from prinitng machine =$5.22 millions | |||||
| Disount rate is (r) =7.5% | |||||
| presnt value annuity factor =1/(1+r)^n | |||||
| Year | PVF @ 7.5% | Cash Flow | Presen value | ||
| Initial outflow | -7.86 | ||||
| 1 | 0.930232558 | 5.22 | 4.855813953 | ||
| 2 | 0.865332612 | 5.22 | 4.517036236 | ||
| 3 | 0.80496057 | 5.22 | 4.201894173 | ||
| 4 | 0.74880053 | 5.22 | 3.908738765 | ||
| 5 | 0.696558632 | 5.22 | 3.636036061 | ||
| 6 | 0.647961518 | 5.22 | 3.382359126 | ||
| 7 | 0.602754901 | 5.22 | 3.146380583 | ||
| 8 | 0.560702233 | 5.22 | 2.926865658 | ||
| 9 | 0.521583473 | 5.22 | 2.722665729 | ||
| 10 | 0.485193928 | 5.22 | 2.532712306 | ||
| 11 | 0.451343189 | 5.22 | 2.356011447 | ||
| 12 | 0.419854129 | 5.22 | 2.191638556 | ||
| 13 | 0.390561981 | 5.22 | 2.03873354 | ||
| 14 | 0.363313471 | 5.22 | 1.896496316 | ||
| 15 | 0.337966019 | 5.22 | 1.76418262 | ||
| 16 | 0.314386995 | 5.22 | 1.641100111 | ||
| 17 | 0.292453018 | 5.22 | 1.526604755 | ||
| 18 | 0.272049319 | 5.22 | 1.420097446 | ||
| 19 | 0.253069134 | 5.22 | 1.32102088 | ||
| 20 | 0.235413148 | 5.22 | 1.228856633 | ||
| 21 | 0.218988975 | 5.22 | 1.143122449 | ||
| 22 | 0.203710674 | 5.22 | 1.06336972 | ||
| 23 | 0.189498302 | 5.22 | 0.989181135 | ||
| 24 | 0.17627749 | 5.22 | 0.920168498 | ||
| 25 | 0.16397906 | 5.22 | 0.855970696 | ||
| 26 | 0.152538661 | 5.22 | 0.79625181 | ||
| 27 | 0.141896429 | 5.22 | 0.740699358 | ||
| 28 | 0.131996678 | 5.22 | 0.689022659 | ||
| 29 | 0.122787607 | 5.22 | 0.64095131 | ||
| 30 | 0.11422103 | 5.22 | 0.596233777 | ||
| 31 | 0.106252121 | 5.22 | 0.554636072 | ||
| 32 | 0.098839182 | 5.22 | 0.515940532 | ||
| 33 | 0.091943425 | 5.22 | 0.479944681 | ||
| NPV | 55.34073759 | ||||
| Positive NPV means you can invest in project and buy a machine | |||||
| ii) | |||||
| Calculation of Payback period is | |||||
| payback period = inflow of cash / out flow of cash | |||||
| Inflow of cash = 564*12 | |||||
| $6,768 | |||||
| Now, | |||||
| =6768/4700 | |||||
| 1.44 years | |||||
| iii) | intial investments =$11200 | ||||
| Contract is for (n) =10 years | |||||
| Disount rate is (r) =5.4% for caseA | |||||
| Disount rate is (r) =1.4% for case B | |||||
| presnt value annuity factor =1/(1+r)^n | |||||
| therei is two option lets make it case A & B | |||||
| Year | PVF @ 5.4% | Cash flow | Present value (pvf*cash flow) | ||
| Initial cash flow | 1 | -11200 | -11200 | ||
| 1 | 0.948766603 | 560 | 531.3092979 | ||
| 2 | 0.900158068 | 1680 | 1512.265554 | ||
| 3 | 0.854039912 | 0 | |||
| 4 | 0.810284547 | 0 | |||
| 5 | 0.768770917 | 0 | |||
| 6 | 0.729384172 | 0 | |||
| 7 | 0.692015344 | 0 | |||
| 8 | 0.656561047 | 0 | |||
| 9 | 0.622923195 | 0 | |||
| 10 | 0.591008723 | 11200 | 6619.297703 | ||
| NPV | -2537.127446 | ||||
| IN case A NPV is negative hence investment is not beneficial | |||||
| For case B | |||||
| Year | PVF @ 5.4% | Cash flow | Present value (pvf*cash flow) | ||
| Initial cash flow | 1 | -11200 | -11200 | ||
| 1 | 0.986193294 | 560 | 552.2682446 | ||
| 2 | 0.972577213 | 1680 | 1633.929718 | ||
| 3 | 0.959149125 | 0 | |||
| 4 | 0.945906435 | 0 | |||
| 5 | 0.932846583 | 0 | |||
| 6 | 0.919967044 | 0 | |||
| 7 | 0.90726533 | 0 | |||
| 8 | 0.894738984 | 0 | |||
| 9 | 0.882385586 | 0 | |||
| 10 | 0.870202747 | 11200 | 9746.270769 | ||
| NPV | 732.4687312 | ||||
| IN case B NPV is positive hence investment is beneficial | |||||