Learn to Excel at Financial Modeling & Take Your Career to the Next Level!
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.
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.
Module 3 – Financial Modeling
Brings everything together and shows you step by step how to build a highly accurate integrated financial model.
Get Real World Financial Modeling Training
In a Fun, Highly Effective Interactive Learning Environment
Professionally-produced video lectures featuring engaging expert instructors, a comprehensive course guide & more ensure you become highly proficient at financial modeling and valuation.
What is financial modeling 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?
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.
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.
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.
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.
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?
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. Learn the comps method of Trading Multiples.
Learn the comps method of Precedent Transactions.
Spreading Comps is the task of collecting and calculating relevant multiples from a number of different comparable companies.
What are the different valuation methods and their advantages and disadvantages?
What are the uses of financial models? How can they aid decision making? Tips for finding company financials and setting up financial models.
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.
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.
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.
We will now set the scene and start creating a financial model. Download the financial model and follow along.
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.
In this tab the size of the target market is calculated. The data is linked form the data backed and qualitative assumptions tab.
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.
We will project how many customers will demand our product and service each year. We will work out the demand for 5 years.
This tab will show a table of start-up expenses and the amount of capital invested.
This is a depreciation schedule for 5 years for the company. The data is linked to the P & L statement and balance sheet.
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.
Cash flow for 5 years is projected. The data is linked from the start-up expenses tab and the P & L statement.
This is the last and most important statement of any financial model.
Bringing everything together we will calculate the business valuation.
iBanking Training Limited is the provider of online financial modeling courses to students and professionals that want to develop expertise in company valuation and seek lucrative careers in investment banking and corporate finance.
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.