Explain Free Cash Flow

Words: 1669
Pages: 7
Open Document
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 …show more content…
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
Show More

Related Documents: Explain Free Cash Flow

Financial Modeling and Isbn Essay

inancial modeling is the task of building an abstract representation (a model) of a financial decision-making situation.[1] This is a mathematical model designed to represent (a simplified version of) the performance of a financial asset or portfolio of a business, project, or any other investment. Financial modeling is a general term that means different things to different users; the reference usually relates either to accounting and corporate finance applications, or to quantitative finance applications…

Words 2164 - Pages 9

Mr Daubek Ismailov Essay

Financial Modeling BM021-3-3-FINMDL Individual Assignment Hand out date 1 March, 2012 Hand in date 18 May, 2012 Assessment 50% Daubek Ismailov TP026716 UC3F1107AF Table of Contents PART A 2 PART B 3 Net Present Value 4 Profitability Index 5 Payback Period 8 Internal Rate of Return 9 SUMMARY OF THE DEVELOPED FINANCIAL MODEL 10 REFERENCES 11 PART A Financial modeling is useful tool in today’s business world. Investopedia (2012) defines financial modeling as “the process…

Words 2433 - Pages 10

Economy: Finance and Projection Group Exercise Essay

Business Plan and Financial Modeling Technique Course Contents Chapter 1: Introduction 1.1 Objectives & Expectation Collection 1.2 Presentation by participants on MF operation in their organization 1.3 Overview of business planning framework Chapter 2 Situation Analysis 2.1 Institutional Analysis 2.1.1 Vision Building of MFIs – Existing Vision and Mission- Presentation by Participants 2.1.2 Conceptual clarity on Vision and Mission of MFIs 2.1.3 Group work : Finalization of Vision…

Words 379 - Pages 2

YuxuanLi Resume Essay example

S Miami Ave, Miami, FL 33130 · +1 (404) 395-2326 · vinson.li@hotmail.com PROFESSIONAL EXPERIENCE Dec. 2012 - Present Bayview Asset Management, Miami, FL Financial Analyst  Provide analytic and modeling support to Bayview’s servicing acquisition and whole loan acquisition business. Responsibilities include a variety of pricing analysis, modeling, reporting and programming tasks  Develop proprietary prepayment and credit models for agency residential mortgage-backed securities; Analyze and price…

Words 405 - Pages 2

Managerial Accounting Essay

Kinetic Concepts Leveraged Buyout Model – Quick Reference Guide >>> Click here to save over $900 and Get All the Modeling Courses You should use this document as a quick reference for the Kinetic Concepts LBO model and webinar. We move quickly in the webinar, so you can follow along here and review the key steps afterwards. Today's Session – Outline 1. Private Equity Case Studies 101  Common to get case studies based on recent/significant deals like this  In the real world you need to…

Words 627 - Pages 3

Essay The Body Shop International Plc

vary with after-tax income, and depreciation will usually vary with gross fixed assets. GBP422.733 million (a 13% increase over 2001) op Percentage-of-sales forecasting: This method starts with a forecast of sales and then estimates other financial statement accounts based on some presumed relationship between sales and that account. While simple to execute, this technique is easily misused. For instance, some naive analysts may…

Words 4868 - Pages 20

Essay Bill Gates

Jeffrey F. Zhang EXPERTISE Business Intelligence, ETL, Data Modeling, Database MSQL Development, Data Warehouse, VBScrip & .NET Development, Business Analysis, Project Management EDUCATION Master of Computer Science & MBA, University of Virginia B.S., Computer Science, Beijing University EXPERIENCE Ullico Inc., Silver Spring, MD 2007 - Present Senior Information System Analyst Business Intelligence * Implemented ETL packages to process large data files from the Third Party…

Words 877 - Pages 4

Public Systems Modeling: Systematic Identification And Evaluation Of Public Policy Alternatives

Public Systems Modeling: Systematic identification and evaluation of public policy alternatives. We use mathematical models to do this. Two main types of mathematical models: Optimization: Finding the best of many alternatives. Addressing ‘What should be’ questions.) Simulation: Finding the impacts of alternative assumptions (Addressing ‘What if’ questions.) Mathematical models: Consists of decision variables (unknowns) and parameters in equations and inequalities that together define a system. Example…

Words 545 - Pages 3

Accounting: Management Accountants Essay

Consistent with other roles in today's corporation, management accountants have a dual reporting relationship. As a strategic partner and provider of decision based financial and operational information, management accountants are responsible for managing the business team and at the same time having to report relationships and responsibilities to the corporation's finance organization. The activities management accountants provide inclusive of forecasting and planning, performing variance analysis…

Words 395 - Pages 2

Essay about Christopher Sims Monetary Policy And It

STATISTICAL MODELING OF MONETARY POLICY AND ITS EFFECTS CHRISTOPHER A. SIMS A BSTRACT. The science of economics has some constraints and tensions that set it apart from other sciences. One reflection of these constraints and tensions is that, more than in most other scientific disciplines, it is easy to find economists of high reputation who disagree strongly with one another on issues of wide public interest. This may suggest that economics, unlike most other scientific disciplines, does not really…

Words 9146 - Pages 37