In: Finance
We need to find Net present value of each scenario and whichever scenario has the highest NPV, that option should be selected.
Scenario 1: npv calculated by NPV formula in excel using 4% as discount rate.
Scenario 1 | Bologna FC | |||||
Years | 0 | 1 | 2 | 3 | 4 | 5 |
Payments | 0 | 200000 | 200000 | 200000 | 200000 | 200000 |
NPV | $890,364.47 |
Scenario 2: Present value of payment in 5th year calculated in excel using 4% as discount rate.
NPV= 1050000/(1+.04)^5 =863023.46
Scenario 2 | FK Zalgiris | |||||
Years | 0 | 1 | 2 | 3 | 4 | 5 |
initial cost | 0 | 0 | 0 | 0 | 0 | 1050000 |
NPV | $863,023.46 |
Scenario 3: npv calculated by NPV formula in excel using 4% as discount rate.
Scenario 3 | Panathinaikos | |||||
Years | 0 | 1 | 2 | 3 | 4 | 5 |
Payments | 195000 | 195000 | 195000 | 195000 | 195000 | |
NPV | $902,829.57 |
Scenario 4: All payments done in the intial year. hence payment same as npv
Scenario 4 | SC Bastia | |||||
Years | 0 | 1 | 2 | 3 | 4 | 5 |
Payments | 897000 | |||||
NPV | $897,000.00 |
Scenario 5: Calculated based on present value of perpetuity formula = 32000/.04
Scenario 5 | SC Bastia | ||||||
Years | 0 | 1 | 2 | 3 | 4 | 5 | |
Payments | 32000 | 32000 | 32000 | 32000 | 32000 | 32000 | To infinity |
NPV | $800,000.00 |
Conclusion:
Hence by finding out NPV of all the scenarios we can see that Scenario 3 in which club Panathinakos paying 195000 annualy at the start of each year is giving highest npv and the player hence should choose this option.