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: 245 times
Menu
Excel related to balancesheet & incomestatement
Attached File : 369957 1218936 dhaval shah.xls downloaded: 245 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
- Tds deduction queery
- Check ITR1 on income tax Form ITR1 Instead of 1 ho
- Form 121 requirement
- Interest on reversal of ITC when ITC balance avail
- Is MirrorFly an Instant Messaging Software?
- ITR filling for legal heir
- How Can I qualify CA Final Exam?
- Wrong reporting on 22 april 2026 under article inc
- Articeship Form 107
- TAN for Multiple States
Related Threads
CAclubindia
