In: Accounting
Incremental
Year After-tax Earnings
1 $15,000
2 20,000
3 23,000
4 26,000
5 30,000
6 35,000
7 40,000
8 50,000
9 60,000
10 70,000
You have a discount rate of 10.0%. Lastly, in order to get to/from class, you
will need to spend more on transportation, and you will also have to eat
several meals a week at fast food restaurants. These incremental net
working capital costs will be $3,000 for the year. Your on-going fixed
overhead costs—for rent, clothes, insurance, food, etc.—are $20,000 per
year.
USING THE PRECEDING INFORMATION, PLEASE ANSWER THE
FOLLOWING QUESTIONS:
Let's calculate NPV of the entire project considering discount factor of 10%
Particulars | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total |
Initial Investment | -120000 | $ 15,000 | $ 20,000 | $ 23,000 | $ 26,000 | $ 30,000 | $ 35,000 | $ 40,000 | $ 50,000 | $ 60,000 | $ 70,000 | |
Incremental Working Capital | $ (3,000) | $ (3,000) | $ (3,000) | $ (3,000) | $ (3,000) | $ (3,000) | $ (3,000) | $ (3,000) | $ (3,000) | $ (3,000) | ||
Ongoing fixed overhead cost | $ (20,000) | $ (20,000) | $ (20,000) | $ (20,000) | $ (20,000) | $ (20,000) | $ (20,000) | $ (20,000) | $ (20,000) | $ (20,000) | ||
$ (120,000) | $ (8,000) | $ (3,000) | $ - | $ 3,000 | $ 7,000 | $ 12,000 | $ 17,000 | $ 27,000 | $ 37,000 | $ 47,000 | 19,000 | |
Discount Rate | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | |
DCF | 1 | $0.909 | $0.826 | $0.751 | $0.683 | $0.621 | $0.564 | $0.513 | $0.467 | $0.424 | $0.386 | |
NPV @ 10% | (120,000) | 13,636 | 16,529 | 17,280 | 17,758 | 18,628 | 19,757 | 20,526 | 23,325 | 25,446 | 26,988 | 79,874 |
A
Sunk Cost - It's the cost of education of 200,000 $ in Loyola Education which is irrelevant to this choice of taking MBA.
Fixed Overhead Cost = (181,818) discounted NPV
Project Cost = Actual Education Cost + Erosion + Opportunity Cost
= 120,000 $ + 50,000 $ + 10,000 $
= 180,000 $
Erosion = 50,000 $ salary lost
Opportunity Cost = 10,000 $ incremental
Incremental Net working capital cost = (18,434) discounted NPV
B Present Value of Incremental After tax earnings
Net Present Value of MBA = 79,874 $
Should you pursue the MBA = Yes, since it results in positive cash flow NPV
Should you factor in financing costs = No, they shouldn't be considered for investment decision
Should you factor in ongoing fixed overhead costs - Overhead costs are not relevant in NPV and shouldn't be considered.