PFA the excel test. Request to let me know if any one could help me out with it.
Attached File : 369957 1218936 dhaval shah.xls downloaded: 205 times
Menu
Excel related to balancesheet & incomestatement
Attached File : 369957 1218936 dhaval shah.xls downloaded: 205 times
Replies (1)
| 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. |
Recent Threads
- Does ca inter have negative marking
- Best CA Inter classes
- Sale of Private Limited Company
- Is PPF interest Taxabl;e in NEW tax regime??
- Income Tax filing returns
- Pan Card - Change of record
- IND AS 116 / IFRS 16: The standard that changed th
- Closure of first level step down subsidiary in Mau
- E way bill for rejected and re sold goods.
- Supporting Documents Required for GST Notice on Cr
Related Threads
CAclubindia
