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: 281 times
Menu
Excel related to balancesheet & incomestatement
Attached File : 369957 1218936 dhaval shah.xls downloaded: 281 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 Topics :
- Understanding where manual effort goes in audit wo
- Scanned purchase bills to Tally XML with GST check
- TDS applicability of foreign remittance to Oracle
- GSTR 9 LATE FEE
- Best Online Mock Test Series for CA Inter January
- COST OF IMPROVEMENT
- Pillows and Mattresses
- GST Applicability for Reg. / Un-Reg. Indian custom
- Amended GST Act & Rules
- FAST DS 2026 MAIL QUERY
Related Topics :
CAclubindia
