Cademy logoCademy Marketplace

Course Images

Best Practice Financial Modelling

Best Practice Financial Modelling

By F1F9 Academy

4.8(48)
  • 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.

Frequently Asked Questions

  • What restrictions apply to the video-based courses?

    We offer unfettered access to our video-based courses. Visit as many times as you wish; there is no expiration date.

  • If I buy a video-based course, will I get immediate access to the course material?

    Yes, if you purchase through our website then you’ll have automatic access to the material.

    If you are booking on one of our in-person courses, then there may be a short delay before one of our team gets back in touch with full details.

  • Why can’t I access my online courses?

    Our online learning platform is hosted by Cademy and you can access your account here with your email address: https://cademy.io/login.

    If this doesn’t work, then please try logging out of Cademy: https://cademy.io/logout. Then go to: https://f1f9.cademy.io and click on “My Account”, then “Log In” (or “Sign Up” if prompted). Log in using your email address.

course Content

19 sections•108 lessons
NEW COURSE! Best Practice Financial Modelling19 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
  6. 64. NEW! Working capital
  7. 7NEW! Test yourself #2
  8. 85. NEW! Depreciation
  9. 9NEW! Test yourself #3
  10. 106. NEW! Financing
  11. 11NEW! Test yourself #4
  12. 127. NEW! Taxation
  13. 138. NEW! Shareholder distributions
  14. 14NEW! Test yourself #5
  15. 159. NEW! Valuation
  16. 1610. NEW! Key outputs & analysis
  17. 1711. NEW! Quality control
  18. 1812. NEW! Model finalisation
  19. 19NEW! Test yourself #6
OLD COURSE: 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
OLD COURSE: 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
OLD COURSE: 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
OLD COURSE: Revenue Summary1 lessons
  1. 11. Revenue summary - Case Study
OLD COURSE: 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
OLD COURSE: 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
OLD COURSE: 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
OLD COURSE: Business Operations2 lessons
  1. 11. How to review a FAST model
  2. 22. Business Operations - Analysis
OLD COURSE: 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
OLD COURSE: Tax Effects of Non Current Assets2 lessons
  1. 11. Tax depreciation - Rough Work
  2. 22. Tax depreciation - Case Study
OLD COURSE: 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
OLD COURSE: Business Assets1 lessons
  1. 11. Business Assets - Analysis
OLD COURSE: 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
OLD COURSE: 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
OLD COURSE: Business Finance1 lessons
  1. 11. Business Finance - Analysis
OLD COURSE: 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
OLD COURSE: 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
OLD COURSE: Model Finalisation6 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. 6Now you've finished

About The Provider

F1F9 Academy

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

Read more about F1F9 Academy

Reviews

5.0(2)

+ Add Review
Material Covered
5
Facilitator
5
Organiser
5
Resources Provided
5
Location/Delivery
5
Communication
5