Financial Modeling
1. Explain ‘Free cash flow’. Comment on its significance in business valuation. 2. Illustrate the ‘VLookup’ function. Explain its importance.
3. Explain ‘Pivot tables’ in excel & state their value in multi-dimensional analysis. 4. Explain ‘Options’ trading. State their significance in modern day trading. 5. Comment on the business models of private equity funds.
6. Comment on valuation of ‘distressed companies’.
7. Illustrate with an example any three capital structure ratios.
8. Illustrate with an example any three profitability ratios.
9. State and explain ‘time value of money’.
10. Explain with an example, the ‘if-then’ analysis & features in excel enabling it. 11. Explain any three significant financial analysis features of excel. 12. Explain ‘derivatives’ trading. State its significance in modern day trading. 13. Comment on the business valuation through the ‘build-up’ method.
14. State & Explain and two methods of appraisal of a company or project. 15. Illustrate with an example any three liquidity ratios.
16. Illustrate with an example any three capital market ratios.
This article describes the formula syntax and usage of the VLOOKUP function in Microsoft Excel.
Description
You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range. For example, suppose that you have a list of employees contained in the range A2:C10. The employees' ID numbers are stored in the first column of the range, as shown in the following illustration.
If you know the employee's ID number, you can use the VLOOKUP function to return either the department or the name of that employee. To obtain the name of employee number 38, you can use the formula=VLOOKUP(38, A2:C10, 3, FALSE). This formula searches for the value 38 in the first column of the range A2:C10, and then returns the value that is
3. Explain ‘Pivot tables’ in excel & state their value in multi-dimensional analysis. 4. Explain ‘Options’ trading. State their significance in modern day trading. 5. Comment on the business models of private equity funds.
6. Comment on valuation of ‘distressed companies’.
7. Illustrate with an example any three capital structure ratios.
8. Illustrate with an example any three profitability ratios.
9. State and explain ‘time value of money’.
10. Explain with an example, the ‘if-then’ analysis & features in excel enabling it. 11. Explain any three significant financial analysis features of excel. 12. Explain ‘derivatives’ trading. State its significance in modern day trading. 13. Comment on the business valuation through the ‘build-up’ method.
14. State & Explain and two methods of appraisal of a company or project. 15. Illustrate with an example any three liquidity ratios.
16. Illustrate with an example any three capital market ratios.
This article describes the formula syntax and usage of the VLOOKUP function in Microsoft Excel.
Description
You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range. For example, suppose that you have a list of employees contained in the range A2:C10. The employees' ID numbers are stored in the first column of the range, as shown in the following illustration.
If you know the employee's ID number, you can use the VLOOKUP function to return either the department or the name of that employee. To obtain the name of employee number 38, you can use the formula=VLOOKUP(38, A2:C10, 3, FALSE). This formula searches for the value 38 in the first column of the range A2:C10, and then returns the value that is