# Financial Modeling

Topics: Spreadsheet, Venture capital, Pivot table Pages: 6 (1653 words) Published: July 8, 2013
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.
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.

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 contained in the third column of the range and on the same row as the lookup value ("Axel Delgado"). * ookup_value    Required. The value to search in the first column of the table or range. The lookup_valueargument can be a value or a reference. If the value you supply for the lookup_value argument is smaller than the smallest value in the first column of the table_array argument, VLOOKUP returns the #N/A error value. * table_array    Required. The range of cells that contains the data. You can use a reference to a range (for example, A2:D8), or a range name. The values in the first column of table_array are the values searched bylookup_value. These values can be text, numbers, or logical values. Uppercase and lowercase text are equivalent. * -------------------------------------------------

col_index_num    Required. The column number in the table_array argument from which the matching value must be returned. A col_index_num argument of 1 returns the value in the first column in table_array; acol_index_num of 2 returns the value in the second column in table_array, and so on. In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name. -------------------------------------------------

Explanation of a pivot table
For typical data entry and storage, data usually appear in flat tables, meaning that it consists of only columns and rows While tables such as these can contain a lot of data,...