1.
Discount rate | 1.95% | ||||||||||
Project A | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 |
Present value | -$60,000.00 | $8,827.86 | $8,659.01 | $8,493.39 | $8,330.93 | $8,171.59 | $8,015.29 | $7,861.98 | $7,711.60 | $7,564.10 | $7,419.42 |
NPV | $21,055.16 | ||||||||||
Project B | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $27,000.00 | $27,000.00 | $27,000.00 |
Present value | -$60,000.00 | $1,961.75 | $1,924.22 | $1,887.42 | $1,851.32 | $1,815.91 | $1,781.18 | $1,747.11 | $23,134.81 | $22,692.31 | $22,258.27 |
NPV | $21,054.29 |
At discount rate 1.95% NPV for both project is same.
2. b.
Discount rate | 1.00% | ||||||||||
Project A | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 |
Present value | -$60,000.00 | $8,910.89 | $8,822.66 | $8,735.31 | $8,648.82 | $8,563.19 | $8,478.41 | $8,394.46 | $8,311.35 | $8,229.06 | $8,147.58 |
NPV | $25,241.74 | ||||||||||
Project B | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $27,000.00 | $27,000.00 | $27,000.00 |
Present value | -$60,000.00 | $1,980.20 | $1,960.59 | $1,941.18 | $1,921.96 | $1,902.93 | $1,884.09 | $1,865.44 | $24,934.05 | $24,687.18 | $24,442.75 |
NPV | $27,520.36 |
At discount rate 1%, i would accept Project B
3. a.
Discount rate | 5.00% | ||||||||||
Project A | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 |
Present value | -$60,000.00 | $8,571.43 | $8,163.27 | $7,774.54 | $7,404.32 | $7,051.74 | $6,715.94 | $6,396.13 | $6,091.55 | $5,801.48 | $5,525.22 |
NPV | $9,495.61 | ||||||||||
Project B | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $27,000.00 | $27,000.00 | $27,000.00 |
Present value | -$60,000.00 | $1,904.76 | $1,814.06 | $1,727.68 | $1,645.40 | $1,567.05 | $1,492.43 | $1,421.36 | $18,274.66 | $17,404.44 | $16,575.66 |
NPV | $3,827.51 |
At discount rate 5%, i would accept Project A
4. d.
Discount rate | 10.00% | ||||||||||
Project A | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 |
Present value | -$60,000.00 | $8,181.82 | $7,438.02 | $6,761.83 | $6,147.12 | $5,588.29 | $5,080.27 | $4,618.42 | $4,198.57 | $3,816.88 | $3,469.89 |
NPV | -$4,698.90 | ||||||||||
Project B | |||||||||||
years | |||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Cash flow | -$60,000 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $27,000.00 | $27,000.00 | $27,000.00 |
Present value | -$60,000.00 | $1,818.18 | $1,652.89 | $1,502.63 | $1,366.03 | $1,241.84 | $1,128.95 | $1,026.32 | $12,595.70 | $11,450.64 | $10,409.67 |
NPV | -$15,807.16 |
at 10% discount rate, i would not except any project as both the projects are producing negative NPV at 10% discount rate.
Use the following for Questions 1 - 5: You are considering two mutually exclusive projects, A...
3. You are considering two mutually exclusive projects with the following cash flows. Which project(s) should you accept if the discount rate is 8.5 percent? What if the discount rate is 13 percent? Year Project A Project B -$80,000 -$80,000 31,000 31,000 0 31,000 110,000 A. accept project A as it always has the higher NPV B. accept project B as it always has the higher NPV C. accept A at 8.5 percent and B at 13 percent D. accept...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown below. The required rate of return on projects of both of their risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the projects are 2 and 3 years, respectively. Time: 0123 Project -35,000 25,000 45,000 16,000 A Cash Flow Project -45,000 25,000 35,000 B Cash Flow Use the NPV decision rule to evaluate these projects; which one(s) should...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown below. The required rate of return on projects of both of their risk class is 12 percent, and that the maximum allowable payback and discounted payback statistic for the projects are 2 and 3 years, respectively. Time: 1 2 3 14,000 34,000 Project A Cash Flow 24,000 5,000 24,000 Project B Cash Flow -34,000 14,000 54,000 Use the NPV decision rule to evaluate these projects;...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown below. The required rate of return on projects of both of their risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the projects are 2 and 3 years, respectively. Time: 0 1 2 3 Project A Cash Flow -30,000 20,000 40,000 11,000 Project B Cash Flow -40,000 20,000 30,000 60,000 Use the NPV decision rule to evaluate these...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown below. The required rate of return on projects of both of their risk class is 10 percent, and that the maximum allowable payback and discounted payback statistic for the projects are 2 and 3 years, respectively. Time: 0 1 2 3 Project A Cash Flow -37,000 27,000 47,000 18,000 Project B Cash Flow -47,000 27,000 37,000 67,000 Use the NPV decision rule to evaluate these...
You must know all the cash flows of an investment project to compute its NPV, IRR, PI and payback period OA NPV, PI, IRR ОВ. Ос. OD IRR, PI payback period and discount payback period NPV, IRR, PI payback period, and discount payback period IRR, PI and payback period NPV, IRR, PI and discount payback period OE. OF.
8.11 NPV versus IRR Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 14 percent. Main Page Year Deepwater Fishing New Submarine Ride Incremental (Ride-Fishing) 0 $(850,000.00) $(1,650,000.00) $(800,000.00) 1 $320,000.00 $810,000.00 $490,000.00 2 $470,000.00 $750,000.00 $280,000.00 3 $410,000.00 $690,000.00 $280,000.00 Discount Rate IRR NPV As a financial analyst for BRC, you are asked the following questions: a. If your decision rule is to accept the...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown below. The required rate of return on projects of both of their risk class is 11 percent, and that the maximum allowable payback and discounted payback statistic for the projects are 2 and 3 years, respectively. 0 Time: 43,000 Project A 33,000 23,000 Flow Project B 43,000 23,000 33,000 63,000 Cash Flow Use the discounted payback decision rule to evaluate these projects; which one(s) should...
Question 24 1 pts You are considering the following two mutually exclusive projects. Which project(s) should be recommended? Project A Project B Year Cash Flow Year Cash Flow 0 $75,000 0 -$70,000 1 $19,000 1 $10,000 2 $48,000 2 $16,000 3 $12,000 3 $72,000 Required rate of return: 10 percent (for A) 13 percent (for B) O accept project B and reject project A. accept both project A and project B. O reject both project A and project B. O...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown below. The required rate of return on projects of both of their risk class is 11 percent, and that the maximum allowable payback and discounted payback statistic for the projects are 2 and 3 years, respectively. 0 3 8000 1 28.000 2 48.000 19.000 Time: Project A Cash Flow Project B Cash Flow -48,000 28,000 2,000 68,000 Use the payback decision rule to evaluate these...