Financial Modelling Course - Only £47

Gain the Financial Modeling Skills That Will Prepare You for a Lucrative Career in Investment Banking or Corporate Finance -

Professionally-produced video lectures featuring engaging expert instructors, a comprehensive course guide & more ensure you become highly proficient at financial modeling and valuation.

___________________________________________________

Cutting Edge Training

Learn the very latest and most effective financial modeling techniques that will allow you to stand out from the competition

Expert Instructors

Our instructors are extremely knowledgeable and know how to break down complex processes so that you understand

Attend Class Anytime, Anywhere

Our courses are available via the 24/7 convenience of the Internet so you can study anytime, anywhere you have an Internet connection

Learn at Your Own Pace

We know how busy people are today and have structured our courses so that they can be completed on your schedule

Lifetime Access

Have a question about how to do something? With our course you can log in anytime to refresh your memory

Learn to Excel at Financial Modeling & Take Your Career to the Next Level!

• Step-by-step courses
• Expert instructors
• Interactive classes keep you engaged
• Downloadable exercises improve your skills
• Course guide puts info at your fingertips

• Attend class when it’s convenient
• Learn at your own pace
• Enjoy lifetime access
• Gain skills that set you apart
• Make yourself more valuable to your company

• Get recognized as a valuation expert
• Open door to new career possibilities
• Ace that investment banking interview
• Move into private equity & hedge funds

___________________________________________________________________

Here’s What You Get in This Course:

Module 1 – Introduction to Financial Modeling

Covers the fundamental principles you need to know to successfully
build financial models.

• What Financial Models Do
• Leading Approaches to Model Building
• Using Accounting Strategies & Ratios
• Financial Statement Analysis
• How to Excel at Excel (functions)
• Translating Financial Data into Excel

Module 2 – Valuation Methods

Reveals why we value companies in the first place and the differences between the various types of values and valuation methods.

• The 3 Top Valuation Methods
• When to Use Different Valuation Methods
• Difference Between Book & Market Value
• Equity Value Versus Total Enterprise Value
• How to Use Trading Multiples
• How to Become a Valuation Expert

Module 3 – Financial Modeling

Brings everything together and shows you step by step how to build a highly accurate integrated financial model.

• Build a Model from Start to Finish
• How to Tailor Results to End Users
• How to Interpret the Results
• How to Reduce Modeling Errors
• Disciplined, Structured Model Building
• Telling Good Models from Bad

_________________________________________________________________________

Get Real World Financial Modeling Training

In a Fun, Highly Effective Interactive Learning Environment

Learn to Create Financial Models

It doesn’t matter if you have no finance or accounting experience, our 5 hours of video tutorials with exercises will give you the solid foundation you need to create financial models from scratch.

Avoid Expensive Travel Costs

We bring the training to you via the Internet so you don’t have to incur expensive travel and accommodation expenses. You can attend class anytime, anywhere, 24/7.

Impress Your Peers

Our comprehensive training gives you the knowledge and skills that will put you in demand in your chosen field, whether that’s investment banking, corporate finance, private equity, hedge funds or something else.

__________________________________________________________

iBanking Training is Your Best Choice for

Financial Modeling Training!

Interactive Learning

Video lectures & exercises keep you engaged & on track

Expert Instruction

Instructors have been there, done that AND can explain it

Low Cost

Our inexpensive course costs a fraction of class-room based programmes and delivers highly engaging content with downloads and exercises to aid understanding

Lifetime Access

Course membership never expires, you can access content anytime

What you get:

• 5 hours of highly instructive video
  
  
• Downloadable exercises to improve your skills
• Comprehensive course guide that will become a valuable resource

• PLUS,lifetime access
• Remember, With iBanking Training, we bring expert instructors and cutting-edge content right to you via streaming video, downloadable exercises and a comprehensive course guide. You don’t have to battle traffic or the weather to get to class. You can attend class right in the comfort of your own home or office.

Financial Modelling and Valuation

The comprehensive course covers exactly what you need to know to build highly accurate financial models. You’ll learn what valuation methods are best, when to use one valuation method instead of another, Excel functions, Revolver Modeling, Sensitivity Analysis, 5 year projections and much more.

The course is divided into three modules and covers everything you need to know to build integrated financial models – no prior knowledge or experience necessary.

Module 1 – Introduction to Financial Modeling

Here you’ll learn the basics, such as general accounting principles and how to work with financial statements and ratios – which are all prerequisites for being able to successfully build a financial model. In this module, you will also learn essential Excel functions that are used to create financial models:

• Lesson 1: Introduction

What is financial modelling and what are its advantages? How can financial models aid decision making? What are the essential Excel functions to quickly and easily create accurate financial models?

• Lesson 2: Overview of Accounting and Financial Statements

Accounting is a structured way to present the financial position of a business. Learn about the different financial statements and how they can help paint a picture of an organisation’s financial health.

• Lesson 3: Cash Flow Statement and Balance Sheet

A cashflow statement shows the flow of money into and out of a business. A balance sheet shows the balances of assets, liabilities and capital of a business at a specific date.

• Lesson 4: Financial Analysis and Ratios

Evaluate the financial health of a company by carrying out financial statement analysis. Learn ratio analysis to interpret financial statements and assess the strengths and weaknesses of businesses.

• Downloads:

1. Case Study: Ratio Analysis
2. Ratio Analysis Excel Spreadsheet Template
3. Ratio Analysis Solution

Module 2 – Valuation Methods

In this module, you’ll learn why we strive to value companies in the first place, the real difference between Book Value (BV) and Market Value (MV) and what is Equity Value (EV) and Total Enterprise Value (TEV). You’ll also learn the strengths and weaknesses of different valuation methods, including: DCF, Trading Multiples and Precedent Transactions:

• Lesson 5: Why Do We Value Companies

What is the purpose of a business valuation and in what circumstances might one be useful? What type of assets of a business need to be valued? The factors that can affect a valuation.

• Lesson 6: Difference between Book Value and Market Value

Learn the key differences between book value and market value and how each can be useful for different purposes. What is the relationship between book value and market value?

What is Discounted Cashflow Analysis (DCF) and how can it be used to assess the intrinsic value of a business?

• Lesson 7: Comparable Company Analysis

Comparable company analysis is a market-based valuation analysis for publicly traded companies. It is based on the idea that companies with similar characteristics should have similar valuation multiples. Learn the steps for conducting a comparable company analysis.

• Lesson 8: Spreading Comps

Spreading Comps is the task of collecting and calculating relevant multiples from a number of different comparable companies.

• Lesson 9: Summary of Valuation Methodologies

What are the different valuation methods and their advantages and disadvantages?

• Downloads

1. Case Study: Values and Valuation Methods
2. Values and Valuation Methods Excel Spreadsheet Template
3. Values and Valuation Methods Solution

Module 3 – Financial Modeling

This module brings everything together that you’ve learned in the previous two modules and shows you step by step how to build a highly accurate integrated financial model:

• Lesson 10: Uses for Financial Modeling

What are the uses of financial models? How can they aid decision making? Tips for finding company financials and setting up financial models.

• Lesson 11: Debt and Interest Schedule

The debt schedule is designed to track every major type of debt a company has and the associated interest and payment schedules. It also helps track the cash available that could be used to pay down those debts and any interest income that could be generated from cash or cash equivalents available.

• Lesson 12: Revolver Modelling

A firm's revolver is a line of short-term credit which the firm can access when it needs short-term funding to pay operating expenses. The revolver is always used for short-term financing, and is almost always paid off very quickly.

• Lesson 13: Sensitivity Analysis

Sensitivity analysis is a way to ascertain the impact of a change in outcome for changes in inputs. It is a very important tool in financial modeling. Most of the sensitivity analyses use one or two variable inputs

• Downloads

1. Case Study: Sensitivity Analysis
2. Sensitivity Analysis Excel Spreadsheet Template
3. Sensitivity Analysis Solution

• Lesson 14: Creating 5 Year Projections – Setting the Scene

Case study to be used in creating a financial model in Excel.

• Downloads

1. ABC Inc. Financial Model (Follow the lessons using this spreadsheet)

• Lesson 15: Data Backed Assumptions

Data backed assumptions are those that are supported by data from a proper source. Qualitative assumptions are those for which any authentic data cannot be found. Therefore, these assumptions can be made using some kind of logical rationale.

• Lesson 16: Market Sizing

In this tab the size of the target market is calculated. The data is linked form the data backed and qualitative assumptions tab.

• Lesson 17: Traffic and Demand

This tab will show how customer traffic will flow over 5 years. We will project the demand for our products by the different market segments.

• Lesson 18: Share of Market Matrix

We will project how many customers will demand our product and service each year. We will work out the demand for 5 years.

• Lesson 19: Start-up Expenses

This tab will show a table of start-up expenses and the amount of capital invested.

• Lesson 20: CAPEX Schedule

This is a depreciation schedule for 5 years for the company. The data is linked to the P & L statement and balance sheet.

• Lesson 21: Profit & Loss Statement

This tab will show the P & L projection for 5 years. The data is taken from various tabs and the net profit or loss figure is then linked to the balance sheet and cash flow statement.

• Lesson 22: Cash Flow Statement

Cash flow for 5 years is projected. The data is linked from the start-up expenses tab and the P & L statement.

• Lesson 23: Balance Sheet

This is the last and most important statement of any financial model.

• Lesson 24: Business Valuation, ROI and Conclusion

Bringing everything together we will calculate the business valuation.

• Downloads

1. Case Study: Financial Modelling
2. Financial Modelling Excel Template
3. Financial Modelling Solution

• Whether you are a student or a working professional seeking to change careers, investment banking offers a highly rewarding and lucrative six-figure career. Learn the essential financial modeling skills and ace those technical interviews. Open doors to a career in investment banking, corporate finance, private equity and hedge funds. Not from a finance background? No problem. The course takes you through the basics of accounting and financial statement analysis along with Excel formulas. So there is no prior knowledge of finance required. Our online financial modeling course is packed full of tips and tricks to help you become an expert in company valuations and earn the respect and confidence of your employer. Practice the skills you learn with downloadable exercises and financial modeling templates.

• While no prior knowledge of finance is required some familiarity with Microsoft Excel would be beneficial

Financial modelling is an essential skill for those seeking a career in investment banking, corporate finance, private equity and hedge funds.