Contextual Evaluation of Firm Value

7 Oct No Comments






                           
                           
    Year 0 1 2 3 4 5          
    Initial Investment -40 ($ Million) ($ Million) ($ Million) ($ Million) ($ Million)          
    Sales $ 27.00 $ 27.00 $ 27.00 $ 27.00 $ 27.00          
    Gross Margin $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50        
    Depreciation $ 2.70 $ 13.50 $ 13.50 $ 13.50 $ 13.50        
    EBT $ 10.80 $ 13.50 $ 13.50 $ 13.50 $ 13.50          
    Tax@35% $ 3.78 $ 2.70 $ 2.70 $ 2.70 $ 2.70          
    Final Value $ 5.00          
    Profit after tax -40 $ 7.02 $ 10.80 $ 10.80 $ 10.80 $ 10.80          
    WACC 10%          
    IRR #VALUE!          
    PV -38.71308862635833          
 
 





Click following link to download this document

Contextual Evaluation of Firm Value.xlsx

Would you like your assignment done free from plagiarism by an expert? Place your order now and it shall be done within the timeframe you indicate.

To view and download a complete answer, scroll down to the bottom to pay Pay to view