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: 250 times
Menu
Excel related to balancesheet & incomestatement
Attached File : 369957 1218936 dhaval shah.xls downloaded: 250 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 Topic
- Error in totalling salary amount in AIS
- Client consent under DPDPA: Is client sharing PAN,
- TDS MISMATCH
- Rebate on other income even if LTCG is above my 12
- Need CA to certify shareholding pattern.
- Ltcg savings
- Please share the roc and income tax compliance fo
- Proprietor have 2 business. One is registered unde
- ITR-4 – Gross Receipts or Turnover for Secti
- Unrelated entries in AIS and Form 26as
Related Topics
CAclubindia
