Question

In: Finance

After the problem has been set up, the calculator should be used to compute NPV and...

After the problem has been set up, the calculator should be used to compute NPV and IRR.   Show calculator inputs.

Chunky Monkey Ice Cream has a 12% cost of capital, and has generated the following information on two mutually exclusive projects.   Project A will require an investment of $100,000 while the initial outlay for Project B is 2 ½ times greater:

            

Year

Project A

Project B

1

30,000

75,000

2

30,000

75,000

3

30,000

75,000

4

30,000

75,000

5

50,000

100,000

            

  1. Compute the payback of both projects.                                                     5 points
  2. Compute the NPV of both projects                                                         10 points
  3. Compute the IRR of both projects.                                                          10 points
  4. Which project should Chunky Monkey adopt?   Why?                                5 points

Solutions

Expert Solution

a) Payback period is calcualted as follows:

Project A

Year Opening Balance CF Closing Balance
1 $        1,00,000.00 $                   30,000.00 $         70,000.00
2 $            70,000.00 $                   30,000.00 $         40,000.00
3 $            40,000.00 $                   30,000.00 $         10,000.00
4 $            10,000.00 $                   30,000.00 $        -20,000.00
5 $          -20,000.00 $                   50,000.00 $        -70,000.00

Opening balance of year 1= Cost
Opening balance = previous year's closing balance for all years after year 1
Closing balance = Opening balance - CF

The closing balance of year 3 was 10000 and the CF for year 4 was was 30000 so the portion of year during which the 10000 is recovered is 10000/30000 x 12 = 4 months

Total time taken to recover initial investment of 100000 is 3 years 4 months
Project B

Year Opening Balance CF Closing Balance
1 $        2,50,000.00 $                   75,000.00 $      1,75,000.00
2 $        1,75,000.00 $                   75,000.00 $      1,00,000.00
3 $        1,00,000.00 $                   75,000.00 $         25,000.00
4 $            25,000.00 $                   75,000.00 $        -50,000.00
5 $          -50,000.00 $                1,00,000.00 $    -1,50,000.00

The closing balance of year 3 was 25000 and the CF for year 4 was was 75000 so the portion of year during which the 10000 is recovered is 25000/75000x 12 = 4 months

Total time taken to recover initial investment of 250000 is 3 years 4 months

b) NPV of project A is as follows:

Year CF Discount Factor Discounted CF
0 $ -1,00,000.00 1/(1+0.12)^0= 1 1*-100000= $ -1,00,000.00
1 $      30,000.00 1/(1+0.12)^1= 0.892857143 0.892857142857143*30000= $       26,785.71
2 $      30,000.00 1/(1+0.12)^2= 0.797193878 0.79719387755102*30000= $       23,915.82
3 $      30,000.00 1/(1+0.12)^3= 0.711780248 0.711780247813411*30000= $       21,353.41
4 $      30,000.00 1/(1+0.12)^4= 0.635518078 0.635518078404831*30000= $       19,065.54
5 $      50,000.00 1/(1+0.12)^5= 0.567426856 0.567426855718599*50000= $       28,371.34
NPV = Sum of all Discounted CF $       19,491.82

Calculator inputs would be: CF0 = -100000, CF1 = 30000 with frequency = 4 CF2 = 50000 frequency 1 then we compute the NPV at i = 12 or we can even input CF0 = -100000, CF1 = 30000 , CF2 = 30000, CF3 = 30000, CF4=30000, CF5 = 50000 each with frequency 1

NPV of project B is as follows:

Year CF Discount Factor Discounted CF
0 $ -2,50,000.00 1/(1+0.12)^0= 1 1*-250000= -2,50,000.00
1 $      75,000.00 1/(1+0.12)^1= 0.892857143 0.892857142857143*75000=        66,964.29
2 $      75,000.00 1/(1+0.12)^2= 0.797193878 0.79719387755102*75000=        59,789.54
3 $      75,000.00 1/(1+0.12)^3= 0.711780248 0.711780247813411*75000=        53,383.52
4 $      75,000.00 1/(1+0.12)^4= 0.635518078 0.635518078404831*75000=        47,663.86
5 $   1,00,000.00 1/(1+0.12)^5= 0.567426856 0.567426855718599*100000=        56,742.69
NPV = Sum of all Discounted CF        34,543.89

Calculator inputs would be: CF0 = -250000, CF1 = 75000 with frequency = 4 CF2 = 100000 frequency 1 then we compute the NPV at i = 12 or we can even input CF0 = -250000, CF1 = 75000, CF2 = 75000, CF3 = 75000, CF4=75000, CF5 = 100000 each with frequency 1

c) IRR is calculated for both using the financial calculator:

Project A: IRR is the rate at which the NPV = 0

Calculator inputs would be: CF0 = -100000, CF1 = 30000 with frequency = 4 CF2 = 50000 frequency 1 then we compute the IRR = 19.05% rounded to 2 decimal places or we can even input CF0 = -100000, CF1 = 30000 , CF2 = 30000, CF3 = 30000, CF4=30000, CF5 = 50000 each with frequency 1

Verifying scheduleis as follows:

Year CF Discount Factor Discounted CF
0 $ -1,00,000.00 1/(1+0.190458899148882)^0= 1 1*-100000= $ -1,00,000.00
1 $      30,000.00 1/(1+0.190458899148882)^1= 0.840012201 0.840012200937764*30000= $       25,200.37
2 $      30,000.00 1/(1+0.190458899148882)^2= 0.705620498 0.705620497724306*30000= $       21,168.61
3 $      30,000.00 1/(1+0.190458899148882)^3= 0.592729827 0.592729827320195*30000= $       17,781.89
4 $      30,000.00 1/(1+0.190458899148882)^4= 0.497900287 0.497900286808698*30000= $       14,937.01
5 $      50,000.00 1/(1+0.190458899148882)^5= 0.418242316 0.418242315769718*50000= $       20,912.12
NPV = Sum of all Discounted CF $                 0.00

Project B:

Calculator inputs would be: CF0 = -250000, CF1 = 75000 with frequency = 4 CF2 = 100000 frequency 1 then we compute the IRR = 17.23% rounded to 2 decimal places or we can even input CF0 = -250000, CF1 = 75000, CF2 = 75000, CF3 = 75000, CF4=75000, CF5 = 100000 each with frequency 1

Year CF Discount Factor Discounted CF
0 $ -2,50,000.00 1/(1+0.172265141933036)^0= 1 1*-250000=      -2,50,000.00
1 $      75,000.00 1/(1+0.172265141933036)^1= 0.853049335 0.853049335196494*75000=           63,978.70
2 $      75,000.00 1/(1+0.172265141933036)^2= 0.727693168 0.727693168279181*75000=           54,576.99
3 $      75,000.00 1/(1+0.172265141933036)^3= 0.620758173 0.620758173427586*75000=           46,556.86
4 $      75,000.00 1/(1+0.172265141933036)^4= 0.529537347 0.529537347160192*75000=           39,715.30
5 $   1,00,000.00 1/(1+0.172265141933036)^5= 0.451721482 0.451721481956717*100000=           45,172.15
NPV = Sum of all Discounted CF                      0.00

d) He should opt for project B as it has a higher NPV. IRR rule says the project with higher IRR should be selected but in case of conflict between NPV and IRR rules, NPV decision is superios and should be gone with.


Related Solutions

show the student's calculator set-up (using the variables from a financial calculator) and answers for each...
show the student's calculator set-up (using the variables from a financial calculator) and answers for each of the 3 parts in the problem. For part c, give an exact percentage answer and not an approximate answer. Clearly identify your answers to each part. Assume that you just won the state lottery. your prize can be taken either in the form of 40000 at the end of each of the next 25 years (that is 1,000,000 over 25 years) or as...
A two-year project has been evaluated and has an NPV on an after tax basis of...
A two-year project has been evaluated and has an NPV on an after tax basis of -$2000. On reviewing the analysis the Finance Manager found that depreciation had been omitted from the tax analysis. The allowable depreciation for tax purposes is $5000 for each year. Using a tax rate of 30% and and a discount rate after tax of 12% pa, determine the correct NPV for the project (to the nearest dollar). Can someone help me to solve this and...
There is a special calculator that when used to add numbers up, it always rounds up...
There is a special calculator that when used to add numbers up, it always rounds up or down the number to the closest integer and ignore the decimals. For example, you want to add 1.1+2+3.6, it will show can calculate as 1+2+4, etc. Assume the error from each adding follows uniform distribution on (-0.5, 0.5). When adding 1500 numbers together, what is the probability of the absolute value of total error is greater than 15? How many numbers can you...
Problem 13-4 NPV with Non-normal Cash Flows (LG13-3) Compute the NPV for Project K if the...
Problem 13-4 NPV with Non-normal Cash Flows (LG13-3) Compute the NPV for Project K if the appropriate cost of capital is 7 percent. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to 2 decimal places.) Project K Time: 0 1 2 3 4 5 Cash flow: –$11,900 $5,950 $6,950 $6,950 $5,950 –$14,900
NPV and capital budgeting COLLAPSE Do you think that the NPV should be used for all...
NPV and capital budgeting COLLAPSE Do you think that the NPV should be used for all the capital budgeting cases? Explain.
Suppose that a committee has been set up to evaluate and propose improvements to the current...
Suppose that a committee has been set up to evaluate and propose improvements to the current criteria used in Shariah stock screening and that you have been asked to provide inputs and suggestions. What are the recommendations on how the Shariah stock screening process and/or the criteria used can be improved?
1-) Set up (but DO NOT COMPUTE) an integral for the volume of the solid obtained...
1-) Set up (but DO NOT COMPUTE) an integral for the volume of the solid obtained by rotating the region bounded by the graphs of y = 0, y = √ x − 2, and x = 4 around the y-axis. 2-) Find the area enclosed by one petal of the four-leaved rose curve r(θ) = sin(2θ).
It has been hypothesized that treatment after casting, of a plastic used in optic lenses will...
It has been hypothesized that treatment after casting, of a plastic used in optic lenses will improve wear. Four treatments (A – D) are to be tested. To determine whether any differences in mean wear exist among treatments, 28 castings from a single formulation of the plastic were made, and seven castings were randomly assigned to each of the treatments. Wear was determined by measuring the increase in “haze” after 200 cycles of abrasion (better wear indicated by smaller increases)....
To solve the bid price problem presented in the text, we set the project NPV equal...
To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems.       Romo Enterprises needs someone to supply it with 115,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve...
To solve the bid price problem presented in the text, we set the project NPV equal...
To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems.       Martin Enterprises needs someone to supply it with 141,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT