PFA the excel test. Request to let me know if any one could help me out with it.
dhaval
(owner)
(41 Points)
Replied 13 August 2013
| I am sending you a model which has the forecast numbers for Income Statement & BS (except debt and cash). You have to link the entire model. |
| Please incorporate the following assumption: |
| 1. The company has to maintain a minimum cash balance of $20MM. If they go below the $20MM mark they need to take a short-term loan for the balance. If they have excess amount, they will use it to repay any outstanding debt. |
| 2. Calculate the FCF to firm and equity. Link everything in the valuation sheet so that you get a fair value of the shares. |
| 3. Create a sensitivity table for analyzing the change in fair value due to corresponding changes in Terminal growth & Cost of Capital |
| 4. Assumptions are already present and use any other assumptions that you feel are required to complete the model. Feel free to insert/delete columns/rows/sheets/functionalities. |
| 5. Please feel free to correct any errors and highlight the same. |
Live Course on Invoice Management System (IMS) - 2nd Batch(With Recording)
CAclubindia
