Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
What this course is about?
This course is a practical one where we teach you how to make a financial model for projecting the financial position of a company in the future. In particular we look at estimating the income statement, balance sheet and cash flows statement and establish the linkage between them
What kind of materials that you will find?
There is a video that consists of a recorded exercise that we go through to understand the course. In the video, we are working through an excel spreadsheet which will be also be available to you for your practice.
How long will the course take to complete?
The course will take around 1 hour to finish. But we strongly recommend that you practice the exercises on your own to understand the model and be able to do it on your own.
How is the course structured?
The course is structured in a series of lectures. In each lecture, we look at one critical aspect of financial modeling before we move to the next one. Hence, it is recommended that you watch the videos in a sequence and not jump from one to another.
Why take this course?
This course is meant for both entrepreneurs who are looking to make their financial statements to secure funding from bank or investors. The course is also useful for current and prospective analysts with consulting, private equity, investment banking, equity research, corporate planning profiles.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: How to make an integrated financial model?|
What are we going to learn in this modular course?Preview
What are the key financial statements?Preview
Illustration for this modular coursePreview
Download the illustration exercise for the course
The six steps to forecast the financial statements of a companyPreview
Step 1: Capturing the historical IS & BS
Step 2a: Calculating historical IS ratios
Step 2b: Calculating historical BS ratios
Step 3a: Extrapolating future IS ratios
Step 3b: Extrapolating future BS ratios
Quick recap so far
Step 4a: Forecasting the future IS statement
Step 4b: Forecasting the future BS - assets side
Step 4c: Forecasting the future BS - liabilities side
What are the components of a CF statement
Step 5a: Forecast CF from operations
Step 5b: Forecasting the CF from investments
Step 5c: Forecasting CF from financing
Step 5d: Calculating the cash balance at end of year
Step 6: Integrating CF statement with BS
Recap: What did we learn in the course?
Hey there, welcome to our online courses.
Skillfin Learning is a group of corporate finance and business analytics professionals who have extensive experience and world class expertise in practical financial modeling applications in real world. We have been associated with large consulting and financial services organizations and understand the content requirement from analysts/professionals who can excel in this field. Our aim is to spread the learning in financial modeling and business analysis skills to whoever is keen to learn.
Our courses are comprehensive to impart skills around financial modeling and analytics i.e. excel, financial analysis and valuation. All our courses are practical and illustrations based that gives an on the job like training to our students.
We remain committed to help you in your professional learning experience and development. You have access to our expertise 24 x 7 on all the courses you subscribe to.
Our courses are listed below. Look forward to seeing you inside.