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.