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
In Excel, the "Look-Up" function searches for values in a table based on a certain condition.

Looking Up a Value Based on Two Conditions
As demonstrated above, a "Look-Up" table can be used to pull in values based on a certain condition. The user must identify that condition and provide the column in which to find the value that is to be returned. (In the

The "Exact" Statement
The "Exact" statement (or function) is very useful in working with large sets of data, such as securities,

Using Arrays
"Arrays" is a powerful feature in Excel that allows you to make calculations within large sets of data based on multiple conditions.

The Bottom Line
Microsoft Excel has many features and functions that can add value and be used to create great efficiencies. One

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
Use IF to conduct conditional tests on values and formulas.
Syntax
IF(logical_test,value_if_true,value_if_false)
Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.
Value_if_true is the value that is returned if