• No products in the basket.

  • LOGIN

Login

  • 2 Students

  • Certified

Course Overview

Become a trained professional from the safety and comfort of your own home by taking Financial Forecasting Model for New Business . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.

One Education has been proud to produce an extensive range of best-selling courses, and Financial Forecasting Model for New Business is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time. 

Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.  

All of our tutors and IT help desk personnel are available to answer any questions regarding your training or any technical difficulties. 

By completing Financial Forecasting Model for New Business, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV.

Whatever your reason for studying Financial Forecasting Model for New Business, make the most of this opportunity from One Education and excel in your chosen field.

Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up.  

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Financial Forecasting Model for New Business is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.  

Course Curriculum

Section 01: Financial Modelling - Introduction
Course Promo 00:07:00
Course Road Map and Outline 00:03:00
What is Financial Modelling? 00:02:00
Inputs and Outputs in Financial Modelling Process 00:01:00
What is Financial Modelling used for? 00:06:00
Key Components of a Financial Model 00:03:00
Short Overview of completed Financial Model 00:06:00
Section 02: Finance and Accounting Basics for Financial Modelling
Accounting Basics and Accounting Equation 00:04:00
Accounting Basics – Debits and Credits 00:08:00
Accrual Accounting v Cash Accounting 00:06:00
Prepaid Expenses and Unearned Revenue with Accrual v Cash Accounting 00:04:00
Section 03: Key Components of Financial Modelling Explained
Balance Sheet Basics for Financial Modelling 00:06:00
Income Statement or Profit or Loss Statement (Explained) 00:05:00
Cashflow Statement – Basics about Cashflow Statement 00:04:00
Two Methods of Cashflow Statement Explained 00:05:00
Indirect Method of Cashflow Explained in detail 00:12:00
Section 04: Basics of Excel Formulas and Functions (For Financial Model Building)
Introduction of the Formulas and Functions for the Financial Model 00:04:00
Basics of Choose Function – Explained 00:13:00
Basics of MAX and MIN Functions – Explained 00:07:00
Basics of IF Function 00:07:00
Basics of IF Function and NestedIF Statements 00:06:00
VLOOKUP Function – Explained 00:06:00
Match Function – Explained 00:11:00
VLOOKUP Function with Match Function 00:06:00
SUM IF Function – Explained 00:05:00
OFFSET Full Introduction 00:14:00
IFS Function 00:08:00
Section 05: Introduction to the Financial Model in Excel
Brief Overview of Financial Model 00:01:00
What are the Excel Basics of Financial Model 00:06:00
Walkthrough of the Completed Model 00:17:00
Build as many Scenarios you want with this Financial Model 00:08:00
Section 06: Building Income Statement for New Business
Sales Forecast – Basic Structure 00:06:00
Sales Forecast – Growth Rate and Validation tab 00:10:00
Sales Forecast – Growth Type Selection with Form Controls 00:07:00
Sales Forecasting Finalisation 00:07:00
Model Cost of Goods Sold – Opening Stock 00:04:00
Cost of goods sold – Growth Rates modelling 00:08:00
Model Cost of Goods Sold – Setting up formulas for Gross Profit Change 00:07:00
Cost of Goods Sold Finalising 00:11:00
Cost of Goods Sold/Gross Profit Change – Logic Behind Setting Up 00:03:00
Direct cost and Gross Profit 00:05:00
Indirect Operating Overheads – Dynamic Property Rental cost 00:10:00
Indirect Operating Overheads – Other Overheads 00:06:00
Indirect Operating Overheads – Using IFS Function 00:06:00
Fixed Assets and Depreciation Schedule 00:05:00
Fixed Assets Schedule – Setting Gross Cost and Depreciation 00:07:00
Fixed Assets Schedule – Finalising and Linking Depreciation to PL 00:07:00
Fixed Assets Schedule – Sales and Purchase of Assets 00:03:00
Equity and Loan Schedule – Preparation and Linking to PL 00:09:00
Finishing up Income Statement Modelling 00:03:00
Section 07: Building Cashflow Statement for New Business
Cash Inflow – Cash Sales and Collection from Credit Sales 00:14:00
Cash Inflow – Dynamic Growth Rate setup with Form Controls 00:04:00
Cash Inflow – Credit days selection drop-down menu with Form controls 00:04:00
Cash Inflow – Dynamic Collection days with OFFSET Function 00:09:00
Cash outflow – Model Cash Purchases and Payments to suppliers 00:12:00
Cash outflow – Direct overheads and Indirect overheads 00:12:00
Cash Conversion Ratio – Measure Net Profit to Cashflow for business 00:04:00
Cash outflow – Capex Payment, Line of Credit and Funding Movement 00:07:00
Section 08: Building Trade Finance Schedule (LOC) for New Business
Build a Revolving Line of Credit Schedule/Overdraft Credit Schedule 00:07:00
Revolving Line of Credit – Interest Modelling 00:02:00
Revolving Line of Credit – Linking LOC Funding to Cashflow Statement 00:11:00
Section 09: Error Proofing Entire Model - IMPORTANT (New Business)
How to Setup Validation and Error Check for the entire Model – Part 1 00:08:00
How to Setup Validation and Error Check for the entire Model – Part 2 00:06:00
How to Setup Validation and Error Check – Conclusion 00:03:00
Section 10: Fixed Assets Schedule - Expansion (New Business)
Fixed Asset Schedule Expansion and Why we need it 00:03:00
Fixed Assets Schedule Expansion – Building it Step by step 00:16:00
Section 11: Indirect Method of Cashflow Statement and Balance Sheet (New Business)
Building Balance Sheet – Assets Modelling 00:10:00
Building Balance Sheet – Liability Side 00:08:00
Indirect Method of CF Statement – Cashflow Model Part 1 00:08:00
Indirect Method of CF Statement – Cashflow Building Part 2 00:06:00
Updating Error Checks and Validations 00:07:00
Creating KPI Cards for New Business Financial Model 00:08:00
Section 12: Building Financial Model for Existing Business
Building Existing Business Financial Model – Updating Ranges Tab 00:06:00
Building Existing Business Financial Model – Creating Periods 00:06:00
Building Existing Business Financial Model – Updating Validations and Error Checks 00:11:00
Building Existing Business Financial Model – Finalisation and KPI Cards 00:11:00
Section 13: Building Dashboards for Financial Model
Overview of the New Financial Model 00:09:00
Data Table Preparation for the charts – Part 1 00:09:00
Data Table Preparation for the charts – Part 2 00:04:00
Data Table Preparation for the charts – Part 3 00:03:00
Building First Column Chart – Sales and Gross Profit 00:04:00
Building Column Chart – with Max and Min Gross Profit % 00:06:00
Building Column Chart – with Max and Min Net Profit % 00:04:00
Building Column Chart for 12 Months Sales and Gross Profit 00:03:00
Building Column Chart for 12 Months Gross Profit % and Net Profit % 00:09:00
Building Column Chart for Cashflow, Collection and Payments for 12 Month 00:08:00
Building Column Chart for Trend of Operating Cashflow for 12 Months 00:08:00
Building a Donut Chart – Sales Products Distribution 00:07:00
Download FREE Stock Images for Dashboard’s Background 00:05:00
Importing Background Image and Setting up Dashboard 00:05:00
Creating Chart Backgrounds for an Amazing visual effect 00:06:00
Finalising New Business’s Dashboard with KPI Cards 00:09:00
Existing Business’s Dashboard Creation – Reusing New Business Dashboard 00:12:00
Waterfall Chart for Net Cashflow Performance 00:15:00
Section 14: Bonus: Financial Model in Google Sheets
Overview of the Financial Model in Google Sheets 00:19:00
WaterChart for Net Cashflow Performance in Google Sheets 00:07:00
Section 15: Course Wrap up and Thank you
Wrap up and Thank you (Some Important points) 00:01:00
Downloadable Resources
Resource – Financial Forecasting Model for New Business 00:00:00

Training 10 or more people?

Get your team access to 3,000+ top courses anytime, anywhere.

Try One Education Business

 width=

 

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

For any questions

Set your own speed

Self-paced learning

Save your money

Monthly subscription

COPYRIGHT © 2022 One Education

0
Your Cart