Assignment 1_2017-18_T1_B00340389 (XLSX) - Fichier XLS

Fichier partagé

Assignment 1_2017-18_T1_B00340389 (XLSX)

Aperçu texte

WORST CASE      
 N N+1 N+2 N+3 N+4 N+5
Investment " 2 200 000.00    "     
Inflows  -       " 450 000.00    " " 560 000.00    " " 850 000.00    " " 450 000.00    " " 250 000.00    "
Salvages  -        -        -        -        -        -      
      
Free Cash Flow "-2 200 000.00    " " 450 000.00    " " 560 000.00    " " 850 000.00    " " 450 000.00    " " 250 000.00    "
DCF (8%)  0.08     " 416 666.67    " " 480 109.74    " " 674 757.40    " " 330 763.43    " " 170 145.80    "
FCF cumulated  " 450 000.00    " " 1 010 000.00    " " 1 860 000.00    " " 2 310 000.00    " " 2 560 000.00    "
DCF cumulated  " 416 666.67    " " 896 776.41    " " 1 571 533.81    " " 1 902 297.24    " " 2 072 443.04    "
      
NPV "-127 556.96    "     
"Assigment 1 : Advanced Financial Functions (Trimester 1  2017-18)"      
 N N+1 N+2 N+3 N+4 N+5
Investment " 2 150 000.00    "     
Inflows  -       " 450 000.00    " " 560 000.00    " " 850 000.00    " " 450 000.00    " " 250 000.00    "
Salvages  -        -        -        -        -       " 125 000.00    "
      
Free Cash Flow "-2 150 000.00    " " 450 000.00    " " 560 000.00    " " 850 000.00    " " 450 000.00    " " 375 000.00    "
DCF (8%)  0.08     " 416 666.67    " " 480 109.74    " " 674 757.40    " " 330 763.43    " " 255 218.70    "
FCF cumulated  " 450 000.00    " " 1 010 000.00    " " 1 860 000.00    " " 2 310 000.00    " " 2 685 000.00    "
DCF cumulated  " 416 666.67    " " 896 776.41    " " 1 571 533.81    " " 1 902 297.24    " " 2 157 515.94    "
      
NPV " 7 515.94    "     
IRR 8%     
NPV (0)  0.00         
      
Payback Period FCF  3.64         
Time  234     " Then  3 years + 234 days (according to 365 days a year) "    
      
Discounted Payback Period  4.97         
Time  354     "Then  4 years + 354 days (according to 365 days a year)"

Assignment 1_2017-18_T1_B00340389 (XLSX) - Fichier XLS

Assignment 1_2017-18_T1_B00340389 (XLSX)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent