Cademy logoCademy Marketplace

Course Images

Best Practice Financial Modelling

Best Practice Financial Modelling

By F1F9 Academy

4.9(16)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 12 hours

  • All levels

Description

Building an Excel spreadsheet model that forecast profits and cash flows across a regular series of future dates is a common requirement for the financial analyst and professional modeller. Modellers undertaking such assignments require sound commercial and accounting knowledge, and need to make important design and construction decisions in relation to their models.

Modellers using the FAST Standard will have made the task considerably easier for themselves by following a standard approach that is recognised by others. Financial Statement Modelling reminds you of the basic construction and design skills you need and applies them to the complexities that arise from a case study - in this instance the acquisition of a concession to run an airport over a 30 year period.

The financial statements - income statement, balance sheet and cash flow statement - form the core content around which the course fits. In addition, you will cover valuation techniques, sensitivities and scenario managers.

On completing the course and its assessments, you will be in a position to start building models that are FAST compliant and meet all the requirements of a financial statement forecast model.

course Content

19 sections•101 lessons
NEW! Best Practice Financial Modelling: refreshed course coming soon!5 lessons
  1. 10. NEW! Getting ready
  2. 21. NEW! Welcome to your course
  3. 32. NEW! Operating revenue
  4. 43. NEW! Operating costs
  5. 5NEW! Test yourself #1
Primary Financial Statements10 lessons
  1. 10. Before you begin
  2. 21. Placeholders - Quick Reminder
  3. 32. Calculation blocks - Quick Reminder
  4. 43. Corkscrews - Quick Reminder
  5. 54. Row anchored links - Quick Reminder
  6. 65. Copy or link? - Quick Reminder
  7. 76. Quick charts - Quick Reminder
  8. 87. Import / export - Quick Reminder
  9. 98. Equity - Rough Work
  10. 109. Equity - Case Study
Revenue Price9 lessons
  1. 11. Constants - Quick Reminder
  2. 22. Pyramid structure - How To
  3. 33. Formatting numbers - Quick Reminder
  4. 44. Flags - How To
  5. 55. Embedded constants - How To
  6. 66. Precedents and dependents - Quick Reminder
  7. 77. Editing a formula - Quick Reminder
  8. 88. Revenue price - Rough Work
  9. 99. Revenue price - Case Study
Revenue Demand5 lessons
  1. 11. 2D calculation blocks - How To
  2. 22. F1F9 macros - Quick Reminder
  3. 33. Find & replace - Quick Reminder
  4. 44. Revenue demand - Rough Work
  5. 55. Revenue demand - Case Study
Revenue Summary1 lessons
  1. 11. Revenue summary - Case Study
Operating Costs5 lessons
  1. 11. Writing a good label - How To
  2. 22. Sign conventions - Quick Reminder
  3. 33. Sign switch - Quick Reminder
  4. 44. Operating Costs - Rough Work
  5. 55. Operating Costs - Case Study
Escalation6 lessons
  1. 11. Day counts - How To
  2. 22. Date functions - How To
  3. 33. Data picks - How To
  4. 44. ISNA - How To
  5. 55. Escalation - Rough Work
  6. 66. Escalation - Case Study
Deferred Tax5 lessons
  1. 11. Counterflows - Quick Reminder
  2. 22. MIN and MAX - How To
  3. 33. Goal seek - How To
  4. 44. Deferred Tax - Rough Work
  5. 55. Deferred Tax - Case Study
Business Operations3 lessons
  1. 1How to review a FAST model
  2. 22. Business Operations - Analysis
  3. 3Model build challenge: Hotel Raja part 1
Non Current Assets7 lessons
  1. 11. Initial balances - Rough Work
  2. 22. Initial balances - Case Study
  3. 33. Accounting depreciation - Rough Work
  4. 44. Accounting depreciation - Case Study
  5. 55. Look back functions - How To
  6. 66. Capital expenditure - Rough Work
  7. 77. Capital expenditure - Case Study
Tax Effects of Non Current Assets2 lessons
  1. 11. Tax depreciation - Rough Work
  2. 22. Tax depreciation - Case Study
Working Capital4 lessons
  1. 11. Accounts receivable - Rough Work
  2. 22. Accounts receivable - Case Study
  3. 33. Accounts payable - Rough Work
  4. 44. Accounts payable - Case Study
Business Assets2 lessons
  1. 11. Business Assets - Analysis
  2. 2Model build challenge: Hotel Raja part 2
Equity Finance4 lessons
  1. 11. Share capital - Rough Work
  2. 22. Share capital - Case Study
  3. 33. Dividends - Rough Work
  4. 44. Dividends - Case Study
Debt Finance8 lessons
  1. 11. Scenario selection (nested IF and CHOOSE) - How To
  2. 22. Scenario selection (OFFSET) - How To
  3. 33. Scenario selection (INDEX) - How To
  4. 44. Senior debt principal repayment - Rough Work
  5. 55. Senior debt principal repayment - Case Study
  6. 66. Senior debt interest I - Rough Work
  7. 77. Senior debt interest II - Rough Work
  8. 88. Senior debt interest - Case Study
Business Finance2 lessons
  1. 11. Business Finance - Analysis
  2. 2Model build challenge: Hotel Raja part 3
Key Outputs / Analysis8 lessons
  1. 11. Sensitivities & scenarios - Rough Work
  2. 22. NPV and XNPV - How To
  3. 33. IRR and XIRR - How To
  4. 44. Valuation - Rough Work
  5. 55. Valuation - Case Study
  6. 66. Ratios - How To
  7. 77. Ratios - Rough Work
  8. 88. Ratios - Case Study
Quality Control5 lessons
  1. 11. Track sheet - Rough Work
  2. 22. Track sheet I - Case Study
  3. 33. Track sheet II - Case Study
  4. 44. Checks & Alerts - How To
  5. 55. Checks & Alerts - Case Study
Model Finalisation10 lessons
  1. 11. Placeholders - Rough Work
  2. 22. Flags - Rough Work
  3. 33. Flags - Case Study
  4. 44. Relocating inputs - Rough Work
  5. 55. Relocating inputs - Case Study
  6. 6Model build challenge: Hotel Raja part 4
  7. 7Model build challenge: Hotel Raja part 5
  8. 8Model build challenge: Hotel Raja part 6
  9. 9Now you've finished
  10. 10Feedback module

About The Provider

F1F9 Academy

Expert & Certified Financial Modelling courses for best-in-class modelling

Read more about F1F9 Academy

Reviews

+ Add Review