Financial modeling, as the name suggests, is to create models for making business decisions involving finance.

The process helps users make financial decisions and understand their impact on profit & loss statements, ROI, IRR, Cash Flow.

In this course, we will teach you key aspects of financial modeling and will be doing a live case study & demonstrating

• How do we make assumptions
• What inputs are required for making decisions.
• How we model decisions flow into excel models.
• Making 3 Financial statements (Profit & Loss Statement, cash flow, balance sheet)

This course will also take you through the process of making assumptions about projections and how to justify them and defend when potential investors may ask questions. By taking this course you will be able to

• Evaluate your revenue and cost models.
• Understand what can breakeven
• Calculate cash burns and ability to project how much you need.

Why choose Edplx?

• Internationally recognised accredited qualification
• Access to our free career advisors
• Approved UK Learning Centre
• 1 year accessibility to the course
• Attain PDF or hardcopy certificate to show employers
• Study at your own pace anywhere
• Employer has access to certificate validation
• Tutor Support available Monday-Friday
• Invitation to job fairs

Course Curriculum

This Course will cover some of the following topics:-

INTRODUCTION

• Introduction to the Business Process
• What is Financial Modelling
• Starting Point of a Financial Model 
• Key Features of Clear Financial Model and How to get Started 
• First Steps before Starting to create Financial Model and Linking Business Model 

CASE STUDY – RESTAURANT – BASIC MODEL FOR SELECTING INITIAL IDEA

• CS-1 Starting with end in mind-Comparative P&L 
• CS-2 Customer Acquisition Model 
• CS-3 Revenue and Cost Models 
• CS-4 Adding Product and modelling labour and other Costs 
• CS-5 Modelling Capital Investments and ROI calculations 
• Excel: Case Study 

BUSINESS PLAN AND 3 FINANCIAL STATEMENT MODELS

• BP-1 Detailed Customer Acquisition Model and Revenue Model 
• BP-2 Cost of Sale Model
• BP-3 Modelling Labour cost 
• BP-4 Modelling Other Operating Expenses 
• BP-5 Modelling Income Statement and Cash Flows
• BP-6 Modelling Balance Sheet 
• BP-7. Fixing the errors in Financial Model and brief of IRR 
• Excel: Financial Model for Business plan for New Business 

Who is this Course for

This course is suitable for

• Finance professionals
• startups founders and cofounders
• business professionals

Requirement

This course is open to all with no formal entry requirements.