adms1000 Lecture Notes - Lecture 4: Net Present Value
Document Summary
Get access
Related Documents
Related Questions
MandelMandel
âManufacturing, Inc. has a manufacturing machine that needsattention. The company is considering two options. Option 1 is torefurbish the current machine at a cost of $ 2,000,000. Ifârefurbished, Mandel expects the machine to last another 88 yearsand then have no residual value. Option 2 is to replace the machineat a cost of $4,200,000. A new machine would last 1010 years andhave no residual value. Mandel expects the following net cashinflows from the twoâ options:
Year | Refurbish Current | Purchase New |
Machine | Machine | |
1 | $1,300,000 | $3,840,000 |
2 | 450,000 | 530,000 |
3 | 340,000 | 420,000 |
4 | 230,000 | 310,000 |
5 | 120,000 | 200,000 |
6 | 120,000 | 200,000 |
7 | 120,000 | 200,000 |
8 | 120,000 | 200,000 |
9 | 200,000 | |
10 | 200,000 | |
Total | $2,800,000 | $6,300,000 |
Compute the payback for both options. Begin by completing thepayback schedule for Option 1â (refurbish).
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
Net Cash Outflows | Net Cash Inflows | |||
Year | Amount Invested | Annual | Accumulated | |
0 | $2,000,000 | |||
1 | ||||
2 | ||||
3 | ||||
4 | ||||
5 | ||||
6 | ||||
7 | ||||
8 |
â(Round your answer to one decimalâ place.)
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
Now complete the payback schedule for Option 2â (purchase).
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
Net Cash Outflows | Net Cash Inflows | |||
Year | Amount Invested | Annual | Accumulated | |
0 | $4,200,000 | |||
1 | ||||
2 | ||||
3 | ||||
4 | ||||
5 | ||||
6 | ||||
7 | ||||
8 | ||||
9 | ||||
10 |
â(Round your answer to one decimalâ place.)
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
Compute the ARRâ (accounting rate ofâ return) for each of theoptions.
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
/ | = | ARR | ||||
Refurbish | / | = | % | |||
Purchase | / | = | % |
Compute the NPV for each of the options. Begin with Option 1â(refurbish). â(Enter the factors to three decimal places. X.XXX.Use parentheses or a minus sign for a negative net presentâvalue.)
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
Net Cash | PV Factor | Present | ||||
Years | Inflow | (i = 14%) | Value | |||
Present value of each year's inflow: | ||||||
1 | (n = 1) | |||||
2 | (n = 2) | |||||
3 | (n = 3) | |||||
4 | (n = 4) | |||||
5 | (n = 5) | |||||
6 | (n = 6) | |||||
7 | (n = 7) | |||||
8 | (n = 8) | |||||
Total PV of cash inflows | ||||||
0 | Initial investment | |||||
Net present value of the project |
Now compute the NPV for Option 2â (purchase). â(Enter thefactors to three decimal places. X.XXX. Use parentheses or a minussign for a negative net presentâ value.)
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
Net Cash | PV Factor | Present | ||||
Years | Inflow | (i = 14%) | Value | |||
Present value of each year's inflow: | ||||||
1 | (n = 1) | |||||
2 | (n = 2) | |||||
3 | (n = 3) | |||||
4 | (n = 4) | |||||
5 | (n = 5) | |||||
6 | (n = 6) | |||||
7 | (n = 7) | |||||
8 | (n = 8) | |||||
9 | (n = 9) | |||||
10 | (n = 10) | |||||
Total PV of cash inflows | ||||||
0 | Initial investment | |||||
Net present value of the project |
â
Finally, compute the profitability index for each option.â(Round to two decimal placesâ X.XX.)
Save Accounting Table... | + | ||
Copy to Clipboard... | + |
/ | = | Profitability index | |||
Refurbish | / | = | |||
Purchase | / | = |