Solution
Initial Investment = $ 100000
Life = 4 Years
Salvage Value = Nil
Depreciation per year (Straight-Line Method) = $ (100000 / 4) = $ 25000
(1)
Year | Cash Inflow | Depreciation | Cash Flow after Tax | Cumulative CFAT | PVIF @ 20% | Discounted CFAT | Cumulative Discounted CFAT |
($) | ($) | ($) | ($) | ($) | ($) | ||
1 | 40,000.00 | 25,000.00 | 65,000.00 | 65,000.00 | 0.833 | 54,166.67 | 54,166.67 |
2 | 40,000.00 | 25,000.00 | 65,000.00 | 1,30,000.00 | 0.694 | 45,138.89 | 99,305.56 |
3 | 40,000.00 | 25,000.00 | 65,000.00 | 1,95,000.00 | 0.579 | 37,615.74 | 1,36,921.30 |
4 | 40,000.00 | 25,000.00 | 65,000.00 | 2,60,000.00 | 0.482 | 31,346.45 | 1,68,267.75 |
Total Discounted CFAT | 1,68,267.75 | ||||||
Less: Initial Outflow | -1,00,000.00 | ||||||
NET PRESENT VALUE | 68,267.75 | ||||||
Therefore as it is having a positive NPV, this proposal should be selected
(2)
Year | Cumulative CFAT (See Table 1) |
($) | |
1 | 65,000.00 |
2 | 1,30,000.00 |
3 | 1,95,000.00 |
4 | 2,60,000.00 |
As per the given table, it can be said that the company can recover $ 100000 sometimes in between 1st to 2nd year.
Therefore, using interpolation method by assuming at "X" year, the company will recover $ 100000
(X - 1) / (2 - 1) = (100000 - 65000) / (130000 - 65000)
Or, X - 1 = 35000 / 65000
Or, X - 1 = 0.5 (Approx)
Or, X = 1.5
Therefore, the payback period is about 1.5 years.
(3)
Year | Cumulative Discounted CFAT (See Table 1) |
($) | |
1 | 54,167 |
2 | 99,306 |
3 | 1,36,921 |
4 | 1,68,268 |
As per the given table, it can be said that the company can recover $ 100000 sometimes in between 2nd to 3rd year.
Therefore, using interpolation method by assuming at "X" year, the company will recover $ 100000
(X - 2) / (3 - 2) = (100000 - 99306) / (136921 - 99306)
Or, X - 2 = 694 / 37615
Or, X - 2 = 0.02 (Approx)
Or, X = 2.02
Therefore, the payback period is about 2 years, or sometimes between 2nd to 3rd year
(4)
Simple Rate of Return = (Annual Cash Flow - Annual Depreciation) / Initial Investment
Here, Annual Cash Flow = $ 40000
Annual Depreciation = $ 25000
Initial Investment = $ 100000
Therefore, Simple Rate of Return = (40000 - 25000) / 100000 = 15000 / 100000 = 0.15, or 15%
Therefore, Simple Rate of Return = 15%
Question 1 (evaluating investment projects) Generic Motors Corporation is planning to invest $100,000 in year zero...
Question 1 (evaluating investment projects) Generic Motors Corporation is planning to invest $150,000 in year zero (today) in new equipment. This investment is expected to generate net cash flows of $60,000 a year for the next 4 years (years 1-4). The salvage value after 4 years is zero. The discount rate (cost of capital) is 20 % a year Required: a) What is the net present value (NPV) of this project? NPV Should the firm invest, based on NPV? (1-yes,...
Generic Motors Corporation is planning to invest $225,000 in year zero (today) in new equipment. This investment is expected to generate net cash flows of $90,000 a year for the next 4 years (years 1-4). The salvage value after 4 years is zero. The discount rate (cost of capital) is 20% a year Required: a) What is the net present value (NPV) of this project? NPV $ Should the firm invest, based on NPV? (1=yes, 2=no) b) What is the...
Question 1: Evaluating investment projects You are planning to invest $100,000 in new equipment. This investment will generate net cash flows of $60,000 a year for the next 2 years. The salvage value after 2 years is zero. The cost of capital is 25% a year. a) Compute the net present value NPV = $ Enter negative numbers with a minus sign, i.e., -100 not ($100) or (100). Should you invest? Why? O NO -- the NPV is negative, which...
Question 1: Evaluating Investment projects You are planning to invest $50,000 in new equipment. This investment will generate net cash flows of $30,000 a year for the next 2 years. The salvage value after 2 years is zero. The cost of capital is 25% a year. a) Compute the net present value NPV = $ Enter negative numbers with a minus sign, l.e., -100 not ($100) or (100). Should you invest? Why? ONO -- the NPV is negative, which indicates...
Question 1: Evaluating investment projects You are planning to invest $25,000 in new equipment. This investment will generate net cash flows of $15,000 a year for the next 2 years. The salvage value after 2 years is zero. The cost of capital is 25% a year. a) Compute the net present value NPV = $ Enter negative numbers with a minus sign, i.e., -100 not ($100) or (100). Should you invest? Why? YES -- the NPV is positive, which indicates...
Question 2 (evaluating investment projects) General Motors (or Toyota) is thinking of investing in new production equipment, which will cost $500 million in year zero, and will generate cost savings of $300 million in year 1, $200 million in year 2, and $150 million in year 3. After 3 years, the salvage value is zero. The cost of capital (discount rate) is 25% for General Motors and 10% for Toyota. (Due to GM's recent bankruptcy, investors are scared to lend...
Question 2: Evaluating investment projects You are planning to invest $35,000 in research & development (R&D). This investment will generate cost savings of $24,500 in year 1 and $17,500 in year 2. After 2 years, the salvage value is zero. The cost of capital is 25% a year. a) Compute the net present value. NPV = $ Should you invest? YES O NO b) Following a government stimulus program, the cost of capital decreased to 10% a year. Compute the...
Question 2: Evaluating investment projects You are planning to invest $20,000 in research & development (R&D). This investment will generate cost savings of $14,000 in year 1 and $10,000 in year 2. After 2 years, the salvage value is zero. The cost of capital is 25% a year. a) Compute the net present value. NPV = $ Should you invest? YES ONO b) Following a government stimulus program, the cost of capital decreased to 10% a year. Compute the net...
Question 2: Evaluating investment projects You are planning to invest $40,000 in research & development (R&D). This investment will generate cost savings of $28,000 in year 1 and $20,000 in year 2. After 2 years, the salvage value is zero. The cost of capital is 25% a year. a) Compute the net present value. NPV = $ Should you invest? YES NO b) Following a government stimulus program, the cost of capital decreased to 10% a year. Compute the net...
software company is evaluating the following projects with estimated cash flow (in $): Year (t) Project A Project B Project C 0 -100,000 -100,000 -120,000 1 30,000 30,000 40,000 2 40,000 30,000 40,000 3 40,000 30,000 40,000 4 40,000 30,000 40,000 5 100,000 130,000 120,000 Calculate the net profit, payback period, return on investment (ROI), and net present value (NPV) of all projects. Discount rate= 3.00% a) Show your calculated discount rate and fill in the table. Project A Project...