Preview

Financial Modeling

Satisfactory Essays
Open Document
Open Document
387 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Financial Modeling
INDIAN INSTITUTE OF QUANTITATIVE FINANCE

CERTIFICATE PROGRAM IN FINANCIAL MODELLING IN EXCEL

CURRICULUM
Advanced Excel (2 Days)
(A) Excel Features and Techniques
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. Excel Shortcuts Excel formulae Usage of names to make formulas easier Data Sorting Excel formatting Data Formats Lines and Borders Colours and Patterns Excel functions Excel charts Dynamic Graphs Conditional Formatting Linking worksheets Data Validation Controls – Macros, Combo Boxes and buttons User Forms and controls Data Tables Splitting screens to facilitate working between several worksheets Excel protection option

(B) Advanced Excel Features and Techniques
1. Use of Pivot Tables 2. Use of HLOOKUP, VLOOKUP, COUNTIF, SUMIF, SUMPRODUCT 3. Excel Database Functions – DCOUNT, DSUM, DPODUCT, DMAX, DMIN, DAVERAGE, DSTDEV, DSTDEVP, DVAR, DVARP, DGET 4. Scenario Analysis in Excel 5. Use of Goal Seek 6. Recording Excel Macro 7. Creating Macro and Running from a Button

(C) Overview
1. Introduction to Modelling 2. Excel as tool for Modelling

INDIAN INSTITUTE OF QUANTITATIVE FINANCE

(D) Designing Spreadsheet models
1. 2. 3. 4. 5. 6. 7. 8. Set aims and Objectives Examine User needs and User interface Set out Key variables and rules Breakdown calculations into manageable groups Produce individual modules Testing and auditing Protection as an application Documentation

Financial Modelling in Excel (2 Days)
(A) Corporate Financial Statements
1. 2. 3. 4. 5. 6. 7. 8. Profit and Loss Account Balance Sheet Financial Ratios Cash flow statement Identify the information contained in the three main financial statements Basic concepts - NPV, IRR, Amortization, Debt repayment, etc. Ratios used in long and short term risk return analysis - DSCR etc. Making and analyzing projected financial statements in case of infrastructure companies a. Sensitivity Analysis b. Long term projections and Scenario Analysis c. Case Study of an
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    E CH04 GOV2 H3 Instructions
    • 566 Words
    • 3 Pages

    E CH04 GOV2 H3 Instructions

    In this project, you will create a named range and use it to set data validation. You will use a PMT function to calculate a value and then use it in a two-variable data table. You will also enter VLOOKUP functions to return values from a table, and format cells in the workbook. You will also audit a worksheet and correct errors.…

    • 566 Words
    • 3 Pages
    Good Essays
    Read More
  • Better Essays

    Acc 561 Financial Statements Differential
    • 910 Words
    • 4 Pages

    Acc 561 Financial Statements Differential

    Financial statements provide documentation of a company’s financial history for a set timeframe. One of the financial statement used by investors, creditors, and mangers is the balance sheet. The second statement used by accountant’s income statement, which is also important to shareholders. The third statement is the retained earnings statement, and the fourth financial statement is the statement of cash flows. Each financial statement has a different purpose and shows different aspects of the company’s finances. However, these financial statements are integrated and work together to provide shareholders financial information. This paper will defines the four financial statements while explaining the financial statement most suitable for either an investor, creditor, or management.…

    • 910 Words
    • 4 Pages
    Better Essays
    Read More
  • Good Essays

    Accounting 315
    • 1877 Words
    • 8 Pages

    Accounting 315

    Extensive detail and information is contained within the help function of Microsoft Excel and in the provided text.…

    • 1877 Words
    • 8 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Acc 220 Financial Statement
    • 264 Words
    • 2 Pages

    Acc 220 Financial Statement

    * A balance sheet is summary of a company's financial condition at a specific point in time, including assets, liabilities and net worth. It allows the company to know what they have been paying for or what they owe out to people. An income statement is a report that tracks a company’s revenues, gross profits, operating income, and net worth. All businesses need to have revenue in order to establish a good foundation to have their business up and running. A retained earnings statement is the portion of net income not paid out to investors in the business as dividends. If the company earns a profit they have to decide whether or not to invest it or keep it as theirs and distribute it evenly throughout the others in the company. Statement of cash flows provides information about an entity's cash receipts and cash payments during a period. Cash flow statements classify cash receipts and payments according to whether they stem from operating, investing, or financing activities. Assets are any item or items of economic value owned by an individual or corporation, especially that which could be converted to cash. A liability is an obligation that legally binds an individual or company to settle a debt. Comparative statements are financial statements for different periods that allow the comparison of figures to illustrate trends in a company’s performance. Stockholder’s equity is the part of the balance sheet that represents the capital received from investors in exchange for stock donated capital and retained…

    • 264 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Describe the Potential Effects of Discrimination. Ensure That You Include the Effects Discrimination Has on: the Individual; Families or Friends of the Individual; Those Who Inflict Discrimination; and the Wider Society.
    • 3311 Words
    • 14 Pages

    Describe the Potential Effects of Discrimination. Ensure That You Include the Effects Discrimination Has on: the Individual; Families or Friends of the Individual; Those Who Inflict Discrimination; and the Wider Society.

    Lesson 5: Profit and loss account and Financial Ratio Analysis and developing aims and objectives…

    • 3311 Words
    • 14 Pages
    Good Essays
    Read More
  • Powerful Essays

    M1: Compare the Benefits of Using Manual and Computerised Accounting System to Record Business Transactions.
    • 1460 Words
    • 6 Pages

    M1: Compare the Benefits of Using Manual and Computerised Accounting System to Record Business Transactions.

    Features: Excel allows users to auto sum where it helps you to add the contents of a column of adjacent cells. This is easier for businesses because they don’t have to add up the contents by their self’s and it’s less likely for them to make a mistake. List auto fill allows you to automatically extend the cells, where it allows you to make new changes rather than starting again. Auto fill is another feature which allows you to quickly fill in the cells with repetitive data such as numbers and text. Auto fill can also be used to copy and paste data, where you can modify text and numbers. Auto shapes toolbar is used to create a number of geometrical shapes, arrows, flowchart, Pie, Bar, Line charts, graphs, stars and etc…PivotTable allow you to sum data in a short period of time allowing you to perform data analysis and generating reports like periodic financial statements, statistical reports, etc…another feature is that it allows businesses to analyse complex data relations graphically.…

    • 1460 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Good Essays

    Excel 2010 Pivot Chart Creation
    • 521 Words
    • 3 Pages

    Excel 2010 Pivot Chart Creation

    7 of 9 in Series: The Essentials of Excel 2010 Pivot Tables and Pivot Charts…

    • 521 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Excel 2010: Tips and Tricks
    • 1503 Words
    • 7 Pages

    Excel 2010: Tips and Tricks

    Excel Tips and Tricks CRI CPE Week May 2011 Presented by: Francois Houde, CA, CISA Schedule of the Session        Transitioning from Excel 2003 to Excel 2010: What happened to my Excel? Managing versions Searches with wildcard characters Multiple windows of the same workbook…

    • 1503 Words
    • 7 Pages
    Good Essays
    Read More
  • Good Essays

    Project Ms Excel
    • 4275 Words
    • 18 Pages

    Project Ms Excel

    Ms-Excel has a number of features. Some of the features of Ms-Excel are as follows-…

    • 4275 Words
    • 18 Pages
    Good Essays
    Read More
  • Better Essays

    Vba Introduction
    • 10854 Words
    • 44 Pages

    Vba Introduction

    ∗ Copyright c 1995-2000 Robert L. McDonald. Thanks to Jim Dana for asking stimulating questions about VBA. † Finance Dept, Kellogg School, Northwestern University, 2001 Sheridan Rd., Evanston, IL 60208, tel: 847-491-8344, fax: 847-491-5719, E-mail: r-mcdonald@northwestern.edu.…

    • 10854 Words
    • 44 Pages
    Better Essays
    Read More
  • Good Essays

    Use of Spreadsheets in Business and Technology
    • 949 Words
    • 4 Pages

    Use of Spreadsheets in Business and Technology

    As users of spreadsheet applications such as Microsoft Excel® or Lotus 1-2-3® have become more sophisticated, so have spreadsheets. Once used to support simple functions such as logging, tracking and totaling information, spreadsheets with enhanced formulas and built-in advanced features are now used to support such business functions as complex valuation models. The use of macros and multiple spreadsheets which are linked together allows users to build very complicated—and sometimes convoluted—models and other business functions with minimal or no documentation. In addition, these complex spreadsheets are not usually supported by the same control environment as formally-developed, purchased applications. For example, the developers and users of spreadsheets are usually not trained in structured programming, testing, version control or systems development life cycles, and spreadsheets are rarely restricted from unauthorized access by security controls. (Smith, 2013)…

    • 949 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    232531581 Scottsville Textile Mill
    • 127 Words
    • 2 Pages

    232531581 Scottsville Textile Mill

    Case from Anderson, D., Sweeney D., Williams T., Martin, K. (2010), An Introduction to Management Science Quantitative Approaches…

    • 127 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Advanced Modelling in Finance
    • 57522 Words
    • 231 Pages

    Advanced Modelling in Finance

    Copyright  2001 by John Wiley & Sons, Ltd, Baffins Lane, Chichester, West Sussex PO19 1UD, England National 01243 779777 International (C44) 1243 779777 e-mail (for orders and customer service enquiries): cs-books@wiley.co.uk Visit our Home Page on http://www.wiley.co.uk or http://www.wiley.com All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or…

    • 57522 Words
    • 231 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Course Outline Is102
    • 4009 Words
    • 17 Pages

    Course Outline Is102

    Leong and Cheong 2011. Business Modeling with Spreadsheets: Problems, Principles, and Practice, 2nd edition, McGraw-Hill.…

    • 4009 Words
    • 17 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Information Technology Questions
    • 1516 Words
    • 7 Pages

    Information Technology Questions

    The best answer to this item is “spreadsheet and database software”, so answer space (A) has been shaded.…

    • 1516 Words
    • 7 Pages
    Satisfactory Essays
    Read More

Related Topics