Best Financial Modeling Courses

Find the best online Financial Modeling Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Financial Modeling Courses.

Beginner to Pro in Excel: Financial Modeling and Valuation

Financial Modeling in Excel that would allow you to walk into a job and be a rockstar from day one!

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 150875, Price: $139.99

Students: 150875, Price:  Paid

**Updated for February 2021!**

Do you want to learn how to use Excel in a real working environment?

Are you about to graduate from university and start looking for your first job? 

Are you a young professional looking to establish yourself in your new position? 

Would you like to become your team's go-to person when it comes to Financial Modeling in Excel? 

If you answered yes to any of these, then this is the right course for you!

Join over 119,002 successful students taking this course!

The instructor of this course has extensive experience in Financial Modeling: 

  • Worked in the Financial advisory unit of a top-tier consulting firm

  • Experience in transactions carried out in Italy, Germany, Switzerland and Poland

  • Worked in the in-house Mergers & Acquisitions department of a large multinational corporation

  • Been a financial advisor in multiple M&A deals with sizes ranging from €2 million to €5 billion

  • Worked on company valuations, due diligence analysis, impairment tests, bankruptcy proceedings, cash flow analysis, and more.

Learn the subtleties of Financial Modeling from someone who has walked the same path. Beat the learning curve and stand out from your colleagues. 

 A comprehensive guide to Financial Modeling in Excel: 

  • Become an Excel expert

  • Learn how to build sound Financial Models and stand out among your colleagues

  • Gain an in-depth understanding of the mechanics of Company Valuation

  • Build your files professionally

  • Demonstrate superior Excel skills at work

  • Be prepared from day one for your Investment Banking, Financial Advisory or Consulting career

What we offer: 

  • Well-designed and easy-to-understand materials

  • Detailed explanations with comprehensible case studies based on real situations

  • Downloadable course materials

  • Regular course updates

  • NEW! Includes professional chart examples that are 1:1 with those used by major banks and consulting firms.

By completing this course, you will:

  • Be able to work comfortably with Microsoft Excel and many of its advanced features

  • Become one of the top Excel users in your team

  • Be much quicker at carrying out regular tasks

  • Be able to build a P&L statement from a raw data extraction

  • Be able to build a cash flow statement

  • Know how to value a company

  • Be able to build a valuation model from scratch

  • Know how to create a model with multiple scenarios

  • Know how to create professional and good-looking advanced charts

About the course:

  • An unconditional Udemy 30-day money-back guarantee – because we believe in the quality of our content

  • No significant previous experience is needed to understand the course properly and benefit from its content

  • Unlimited access to all course materials

  • Emphasis on learning by doing

  • You can always contact us for any clarification free of charge

  • Our goal is to take your Microsoft Excel and Financial Modeling skills to the next level

Make an investment that will be highly rewarded in career prospects, positive feedback, and personal growth. 

This course is suitable for graduates who aspire to become investment bankers as it includes a well-structured DCF model and goes through the theoretical concepts behind it. Moreover, it will encourage you to be more confident when coping with daily tasks and will give you the edge when the firm must decide whether to take you on for a full-time position. 

People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills. 

Go ahead and subscribe to this course! If you don't acquire these skills now, you will miss an opportunity to separate yourself from others. Don't risk your future success! Let's start learning together now! 

Financial Analysis and Financial Modeling using MS Excel

Perform financial analysis & financial modeling using Microsoft excel. For people who want to become a Financial Analyst

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 113833, Price: $29.99

Students: 113833, Price:  Paid

You're looking for a complete course on understanding Financial Analysis and Financial Modeling using MS Excel to drive business decisions, right?

You've found the right Financial Analysis using MS Excel course! Financial Analysis and Financial analytics provides scientific support to decision-making concerning a firm's money related matters. This course addresses the topic of Financial analysis with a practical focus, focusing especially on demystifying analytics for finance managers, financial analysts from both statistical and computing point of view.

After completing this course you will be able to:

  • Use MS Excel to create and automate the calculation of Financial Ratios

  • Gain solid understanding on Financial Analysis and the role of Financial Analyst using MS Excel

  • Learn basics and advanced level Financial Accounting concepts that are required for Financial Analysis, specifically for job roles of Financial Analysts.

  • Make Finance Dashboards required for Financial Analysis and understand all the charts that you can draw in Excel

  • Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real-world financial problems

  • Use pivot tables filtering and sorting options in Excel to summarize and derive information out of the financial data and to do Financial Analysis for your organization

  • Learn the commonly used financial formulas available in excel to calculate depreciation, loan-related calculations, NPV, IRR, etc., required for Financial Analysis

How this course will help you?

A Verifiable Certificate of Completion is presented to all students who undertake this course on Financial Analysis, Strategies & Models in Excel.

If you are a Finance manager, or a Financial Analyst or an executive, or a student who wants to learn Financial Analysis concepts and apply analytics techniques to real-world problems of the Finance business function, this course will give you a solid base for Financial Analysis by teaching you the most popular Financial analysis models and concepts of Financial Accounting and how to implement it them in MS Excel.

Why should you choose this course?

We believe in teaching by example. This course is no exception. Every Section’s primary focus is to teach you the concepts through how-to examples. Each section has the following components:

  • Theoretical concepts and use cases of different Financial models required for laying foundation of Financial Analysis

  • Step-by-step instructions on implementing Financial Analysis models in MS Excel

  • Downloadable Excel files containing data and solutions used in each lecture of Financial Analysis, Financial Accounting in MS Excel

  • Class notes and assignments to revise and practice the concepts Financial Analysis, Financial Accounting in MS Excel

The practical classes where we create the model for each of these strategies is something that differentiates this course from any other course available online.

What makes us qualified to teach you?

The course is taught by Abhishek (MBA - FMS Delhi, B.Tech - IIT Roorkee) and Pukhraj (MBA - IIM Ahmedabad, B.Tech - IIT Roorkee). As managers in the Global Analytics Consulting firm, we have helped businesses solve their business problem using Analytics and we have used our experience to include the practical aspects of HR analytics in this course. We have in-hand experience in Financial Analysis and MS Excel.

We are also the creators of some of the most popular online courses - with over 600,000 enrollments and thousands of 5-star reviews like these ones:

This is very good, i love the fact the all explanation given can be understood by a layman - Joshua

Thank you Author for this wonderful course. You are the best and this course is worth any price. - Daisy

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there are class notes attached for you to follow along. You can also take quizzes to check your understanding of concepts like Financial Analysis, Financial Accounting in MS Excel. Each section contains a practice assignment for you to practically implement your learning on Financial Analysis, Financial Accounting in MS Excel.

What is covered in this course?

The analysis of data is not the main crux of analytics. It is the interpretation that helps provide insights after the application of analytical techniques that makes analytics such an important discipline. We have used the most popular analytics software tool which is MS Excel. This will aid the students who have no prior coding background to learn and implement analytics concepts to actually solve real-world problems of Financial Analysis and Financial Accounting.

Let me give you a brief overview of the course

  • Part 1 - Introduction

In this section, we will learn about the course structure and the meaning of some key terms associated with Financial Analysis.

  • Part 2 - Essential MS Excel formulas and using them to calculate Financial metrics

In this part, we will start with a tutorial on all the popular MS Excel formulas. Then we will see the implementation of these to calculate and automate the Financial metrics. We also discuss a separate case study where we use Excel to calculate the average cost of external and internal hiring.

  • Part 3 - Visualization in Excel and Financial Dashboarding

In this part, we will begin with a tutorial on all the popular charts and graphs that can be drawn in MS Excel. Then we will see the implementation of these to create visualize Financial data. This is an important part of the course which help you grasp in-depth concepts of Financial Analysis in the later part of the course.

  • Part 4 - Data summarization using Pivot tables

In this part, we will learn about several advanced topics in MS Excel such as Pivot tables, indirect functions, and also about data formatting. Then we will see the implementation of these to create beautiful summaries of Finance Data. This is one of the building blocks of Financial Analysis and one of the major responsibilities of a Financial Analyst.

  • Part 5 - Basics of Machine Learning and Statistics

In this part, we introduce the students to the basics of statistics and ML, as nowadays Financial Analysis is getting integrated with these concepts. This part is for students who have no background understanding of ML and statistics concepts.

  • Part 6 - Preprocessing Data for ML models

In this section, you will learn what actions you need to take step by step to get the data and then prepare it for analysis, these steps are very important. We start with understanding the importance of business knowledge then we will see how to do data exploration. We learn how to do uni-variate analysis and bivariate analysis then we cover topics like outlier treatment, missing value imputation, variable transformation, and correlation.

  • Part 7 - Linear regression model for predicting metrics

This section starts with a simple linear regression and then covers multiple linear regression.

We have covered the basic theory behind each concept without getting too mathematical about it so that you understand where the concept is coming from and how it is important. But even if you don't understand it, it will be okay as long as you learn how to run and interpret the result as taught in the practical lectures.

I am pretty confident that the course will give you the necessary knowledge on Financial Accounting, Financial Analysis using MS Excel and skill sets of a Financial Analyst to immediately see practical benefits in your workplace.

Go ahead and click the enroll button, and I'll see you in lesson 1 of this Financial Analysis course!

Cheers

Start-Tech Academy

Financial Modeling for Startups & Small Businesses

Learn the best practices for building practical financial models and forecasts for your startup business.

Created by Evan Kimbrell - Founder of Sprintkick | Ex-VC | Ex-startup founder

"]

Students: 60696, Price: $129.99

Students: 60696, Price:  Paid

Reasons why you should create a financial model for your startup or small business.  A good financial model can help you:

  1. Test your assumptions and verify key drivers of your business

  2. Compare and contrast different business choices, like pricing models

  3. Calculate the ACTUAL amount of capital you need to startup

  4. Calculate your burn rate

  5. Model out your user growth 

  6. Model out your expenses

  7. Be more prepared talking to potential investors

  8. And loads more.

Building a financial model isn't just a vanity exercise. When done right, it could help you better understand your business, whether it's a startup or an existing business you're growing.

But it's not easy and there is a right way and a wrong way to go about it.

Even if you have little to no finance background, if you're going to be starting or running a business, this is a skill you need to have.

A good financial model is an indicator of how deeply you understand your business model and market. But building a good one requires the right tools and the right approach.

We're going to show you how to do that with a wide variety of examples and exercises.  But we'll also be teaching general best practices that will help you, no matter what you'll be building your financial models for in the future.

Why learn from us?

By signing up with us, you will be learning from two highly rated instructors that have a combined student count of over 350,000 students and 25,000 reviews! 

Check out our profiles and see that we take care of your students and deliver the goods.

Evan has extensive startup experience and previously worked as a venture capitalist, where he evaluated 100's of startups that trying to convince him to invest in them.

Symon also has startup experience in both tech and brick & mortar businesses. Previously he built tons of models while working in mergers and acquisitions as well as in private equity.  And he's helped dozens of startups build financial models across a dozen different business models and industries.  

Together, we pull directly from our experience and put it in this course--in fact, two of the case studies use the ACTUAL financial models used to raise funding.  The other case studies are inspired by well known startups you're sure to recognize.

How is this different from Symon's Intro to Financial Modeling Course?

The Intro to Financial Modeling course taught by Symon He and Brandon Young is an introductory course on financial modeling that presents a general overview covering the topic and is more relevant to those who wish to explore finance as a career option or those who want to understand financial modeling in a corporate context.

This course is all about financial modeling for startup businesses so it's more geared towards entrepreneurs or business owners who want to better understand the key drivers of a new business.

There is almost zero overlap.  Even though both courses introduce a lemonade stand as an example, those examples and models are quite different as they serve very different purposes.  

What if I don't have any finance or Excel background?

No worries! This course isn't an Excel or Finance course, although you will learn a bit of both.  We focus more on the rationale and the logic of modeling specifically for startups or growing businesses, so you can take what you learn to other spreadsheet tools.  

But it will take practice.  You won't get better just watching the videos.  That's why have lots of practice exercises and sample models for you to learn from.

What will I be able to do after I take your course?

After taking our course, you will be:

  • Able to confidently build financial models for your startup or new business from scratch

  • Able to apply the best financial modeling practices and techniques

  • Able to read and understand other financial models by looking at lots of practice models and case studies

  • Able to leverage financial modeling to help you make smarter choices about your business.

  • Able to learn a new skill set that you can take with you for any and every business venture you take up in the future.

Why lemonade stand example?

Because learning how to model on its own is tough enough but learning it while also having to learn a new business model makes it even harder. 

But, even with a simple business model such as a lemonade stand, you'll be surprised by how complex and sophisticated the analysis could become. 

And since this is all about modeling for startups and new businesses, this example is different from the one in the Intro to Financial Modeling course.  

After the simple lemonade example, we cover 7 distinct case studies involving different business models in different industries.

Tell me again why I should take your course?

You have absolutely ZERO risk.

Udemy gives you a solid as an oak tree 30-day money back guarantee.  

So if you've read this far, we welcome you to join us inside.

Excel Crash Course: Master Excel for Financial Analysis

Beginner to Advanced: Learn Excel Shortcuts, Formulas & Functions for Financial Modeling & Corporate Finance

Created by Tim Vipond - CEO at Corporate Finance Institute | 350,000+ students

"]

Students: 26098, Price: $44.99

Students: 26098, Price:  Paid

Course Description

Learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user.  This course is designed specifically for Excel users who are performing professional financial analysis and financial modeling. We cover all levels - from beginner to advanced users. 

Build a strong foundation in Excel for careers in:

  • Investment banking
  • Private equity
  • Corporate development
  • Equity research
  • Financial Planning & Analysis (FP&A)

Learn industry leading best practices.  This course is based on first-hand investment banking training programs at global banks.  The quality of instruction you receive in this course will have you just as sharp as if you took an expensive, live Wall Street course.

Content and Overview  This course starts with the basics and quickly progresses to a level where even experts will learn something new.  We think it's important to start at the bottom and build a solid base, which is why we review all the foundational skills you need.

In the second half of the course you'll notice the functions and formulas getting more sophisticated and the quality of financial analysis and financial modeling becoming much higher.

What am I going to get from this course?

  • Learn everything you need to know about Excel for a career in corporate finance
  • Master shortcuts, functions, and formulas to save time speed up you modeling skills
  • Follow industry leading best practices
  • Stand out in an interview or move up the ladder at work by dramatically boosting your Excel skills and confidence

Financial Modeling: Build a Complete DCF Valuation Model

The Ultimate Guide to Company Valuation For Aspiring Investment Bankers and Corporate Finance Practitioners

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 21786, Price: $94.99

Students: 21786, Price:  Paid

Would you like to learn how to value a company?

Even people who don't have a Finance degree can take this course and learn how to build a complete Discounted Cash Flow Model! 

Attention! You will have to go through the videos and the course materials in order to obtain the promised result! 

If you want to:

  • Improve your Microsoft Excel modeling skills

  • Learn how to value a company

  • Understand what drives a company's value

Then this is the right course for you!

What we offer:

  • Well designed and easy to understand materials

  • Detailed and comprehensible explanations

  • Regular course updates

By the completion of this course you will:

  • Be able to build a Cash Flow statement

  • Know how to value a company

  • Be able to build a Valuation model from scratch

  • Know how to create a model with multiple scenarios

  • Be able to perform sensitivity analysis

  • Know how to create professional and good-looking advanced charts

The instructor of this course has extensive experience in Financial Modeling:

  • Worked in the Financial advisory unit of a top-tier consulting firm

  • Experience in M&A transactions carried out in Italy, Germany, Switzerland and Poland

  • Worked in the in-house Mergers & Acquisitions department of one of the largest semiconductor firms in the world

  • Financial advisor in multiple M&A deals with sizes ranging from €2 million up to €5 billion

About the course:

  • An unconditional Udemy 30 day money-back guarantee – because we believe in the quality of our content

  • No significant previous experience is needed in order to understand the course well and benefit fully from its content

  • Unlimited access to all course materials

  • Emphasis on learning by doing

  • You can always contact us for any clarification free of charge

  • Our goal is to take your Valuation skills to the next level

Make an investment that will pay for itself in terms of career perspectives, positive feedback and personal growth. 

Just go ahead and subscribe to this course! Nowadays the job market has become very competitive. If you don't acquire these skills now you will miss an opportunity to separate yourself from others. Don't risk your future success! 

Let's start learning together now! 

The Real Estate Financial Modeling Bootcamp

The Complete A to Z Guide to Modeling Real Estate Transactions in Microsoft Excel For Smarter Real Estate Investing

Created by Justin Kivel - Real Estate Investing & Financial Modeling

"]

Students: 20524, Price: $119.99

Students: 20524, Price:  Paid

Learn real estate financial modeling. Advance your career. Make more money. Built by an instructor with over eight years of real estate private equity finance experience modeling over $1.5 billion of closed commercial real estate transactions, this course was designed to take you from complete beginner with no knowledge of real estate financial modeling to a real estate financial modeling pro. The skills and concepts you will learn in this course can be used to help you break into the real estate private equity industry, increase your compensation at your existing real estate job, or confidently analyze and model a commercial real estate investment on your own.

This course was created to help our students:

  • Begin a lucrative career in the commercial real estate private equity industry - According to CEL & Associates, Inc., the 2020 median total compensation for an acquisitions associate in retail, office/industrial, and multifamily was $137K, $143K, and $121K, respectively. This course will teach you the core fundamental Excel financial modeling skills necessary to land one of these jobs and succeed in your first commercial real estate investing role.

  • Increase overall compensation and career opportunities in their current real estate role - Real estate agents, property managers, construction managers, and architects all have extremely valuable skills that are highly desirable in the commercial real estate finance industry. Whether you want to earn more money in your current role or make a transition into commercial real estate acquisitions, this course will give you the foundational knowledge to take your real estate investing career to the next level.

  • Confidently model large real estate transactions - For property acquisitions larger than single-family homes, having the ability to confidently create a financial model projecting real estate investment returns is essential to buying profitable deals and garnering the confidence of your investors. Whether you are modeling a real estate investment you are looking to buy with your own money or leading a real estate syndication, strong financial modeling skills are an essential component of the real estate investment process.

This course will teach you the key fundamentals necessary in order for you to be able to model real estate investment transactions accurately, quickly, and efficiently.

Here's what some of our students have said about the course:

★★★★★ "Excellent course that teaches you financial modeling in Excel for CRE. I purchased the course after starting a new job as valuation analyst for a RE asset manager and it has helped me immensely. I have a background in PE funds and my excel skills are fairly advanced so for me the added value was understanding the specificities of CRE. I now look forward to completing the advanced RE modelling course. This instructor is great: no fluff, clear explanations, top notch material and step-by-step directions. Justin is also very responsive with answering your queries. I highly recommend the course!"

★★★★★ "This course is great. I learned everything I needed to build a model for an interview for a Financial Analyst role at a Real Estate Private Equity Fund. And I got the job. I have since gotten other courses by Justin, as they are what I need to get me up to speed at my new job. Also, Justin is great at answering questions when I get stuck and pointing me in the right direction."

★★★★★ "Excellent Course! Thank you for all your hard work in transforming a complex concept into an easy to understand format. This course has multiplied my understanding of financial modeling and the use of Excel. I learned more through this platform than the traditional institutional setting. A great resource and educator."

★★★★★ "Overall, this course was such an awesome experience! As a CRE investor as well, I took this course with the goal of it helping to rebuild my financial model and, what can I say, mission accomplished! From the structure, to the pace, the exercises, Justin's CRE knowledge and Excel tips/tricks - it was exactly what I was looking for and more!"

★★★★★ "Cannot believe the value in this course!! Best deal in real estate education. Thank you Justin, can't wait to take the next course. I could not recommend it more."

★★★★★ "This is a top notch course. The self-pace is perfect for me and it helped refresh all of the concepts that I learned in my grad school real estate courses. Just follow along and practice the examples and you'll extract tremendous value from a modeling perspective!!"

★★★★★ "Justin is awesome! His teaching style makes learning very intuitive. I would recommend this class for anyone that is trying to break into CRE or expand their current foundation of CRE. I was recommended by a friend who spent $600 on a course but found this one to be more helpful and easier to follow/understand."

★★★★★ "Superb course that teaches you the fundamentals of CRE modelling you need to know. Justin is a really good lecturer and he is very responsive with answering your queries, not just about the course material but even things related to your career in CRE. I would recommend the course to anyone looking to understand the fundamentals of CRE modelling."

★★★★★ "Wow! This course and Justin's other courses are the equivalent of an MBA level curriculum. If you are willing to put in the time and effort you will benefit."

If you're looking to learn to model commercial real estate investments to jump-start your career, make more money in your current job, or do your own big deals, you're in the right place.

Join us!

Introduction to Financial Modeling for Beginners

Learn how to build your first financial models in Excel from scratch.

Created by Symon He - Author | Investor | MBA

"]

Students: 18355, Price: $99.99

Students: 18355, Price:  Paid

Arun Mohan - 5 Stars

“The experience was an enlightening one as I was a novice in Finance and Excel and this Class was best fit for me. I could understand everything as the instructor took time to explain at a good pace and patiently introduced excel as well as accounting methods. Looking forward to getting acquainted with more of Finance.”

 

Ethan Wong - 5 Stars

“The course was designed very well, with clear explanations of the topic matter. Having the instructor show you everything step-by-step was very useful for learning. Also, having the excel spreadsheets to practice on was perhaps the most useful thing for me.”

 

There are THREE things you need to do in order to learn financial modeling:

            1.         You need to understand the key concepts of Finance

            2.         You need to understand the relevant features & techniques in Excel

            3.         You need to be able to put both of those together in practice.

 

 

You're reading this because you have an interest in learning financial modeling for your work or a desire to get into corporate finance.

 

We did too many years ago.

 

But when we first started out, we wasted a lot of time and effort learning useless and unnecessary information and techniques.

 

It didn't have to be as painful and time-consuming as it was.

 

That's why we created this course,  so you can avoid making the same mistakes that we made and learn financial modeling fast with no wasted effort. 

 

You DON’T have to learn everything about finance or Excel to become proficient at financial modeling.

 

You just need to know the RIGHT concepts and the RIGHT tools in each to get started.

 

Now why should you learn from us?

 

I’m proud to say that I have an MBA from Stanford University and have worked on many commercial real estate properties across a dozen asset types in multiple markets. I even helped create the underwriting standards for a 2000-store private restaurant chain, helping them open new locations around the world.

 

And as a licensed broker and real estate consultant, I've helped many private clients with locating, evaluating, and structuring investment opportunities including multi-million dollar commercial property acquisitions and 1031 exchanges.

 

My co-instructor, Brandon Young, has a Masters in Real Estate Finance & Development from the University of North Carolina Charlotte as well as a Masters in Finance from Tulane University. He has over a decade of combined financial and real estate experience, including acquisitions and development.

 

We've been living and breathing in financial models for practically our entire careers.

 

Andrés Soto - 5 Stars

A really good course for beginners. Right now I understand everything.” 

Henry Taatjes - 5 Stars

"great instructors, great content”

Brady Burba - 5 Stars

“After reaching this point I see the training is going deeper into Excel and how to utilize the many tools and formulas Excel offers, without training on topics that are not relevant to my needs. Thank you!”

 

What if I don't have any Finance or Excel background?

 

No worries! This is an introductory course and it assumes ZERO prior knowledge or experience.  It is condensed because we've curated only the most relevant and useful topics to get you going fast.  

 

What will I be able to do after I take your course?

 

After taking our course, you will be:

•           Able to confidently speak to key finance, accounting, and modeling concepts

•           Able to use over a dozen of the most useful Excel features & techniques

•           Able to construct three distinct financial models from scratch

 

What’s with the lemonade stand?

 

Learning Excel or finance on their own is tough enough, and learning them at the same time can be extra challenging.  To further muddy the waters by asking students to learn an arbitrary business model would be unnecessarily confusing and a waste of time.   

But even with a simple business model such as a lemonade stand, you'll be surprised by how complex and sophisticated the analysis can become.

 

What’s holding you back?

 

Are you afraid this course won’t work?  I promise you it will.

 

Are you afraid this course will work and you’ll actually have to start investing? I think that’s a pretty good problem to have.

 

Are you afraid it will take time and effort? It will. Real estate isn’t an easy business, if it was everyone would do it. But if you put in the work I promise you’ll see results.

 

Best of all, there is absolutely ZERO risk. Udemy gives you a 30-day money back guarantee to ensure you get what you pay for.

 

So go ahead, sign up and let’s get to work right away!

Financial Modeling and Valuation Course 2021

Learn Excel for Finance, Financial Analysis, DCF and Relative Valuation and Financial Modeling from scratch.

Created by Institute of Investment Banking - Learn Investment Banking the easy way!

"]

Students: 18275, Price: $89.99

Students: 18275, Price:  Paid

This course is a comprehensive bundle of MS Excel, Valuation, Accounting, Financial Analysis and Financial Modeling. Any one interested in a career in Finance and Financial Analyst Industry. This course is a must. Many students and professionals assume that their chances of making an Analyst career in Finance Industry are bleak if they are not from the top tier colleges. However, we have seen industry trends where skilled students and professionals from lesser known universities and companies making into big financial firms and organizations. Universities are very limited in their curriculum as they are mostly restricted to focus on theoretical aspects than actual practical know-how. Financial Analyst Training involves analyzing companies’ financials in detailed manner. Analysis is conducted through a composite of financial records, news and interviews with company insiders. It is also known as securities research or Fundamental Analysis. It consist of the sell side research i.e. when research done by analyst are provided to their clients and also buy side research i.e. when analyst do research and use it to invest their firm’s money. The work within Financial Analysis mainly revolves around Financial Modeling Techniques, forecasting, valuations like DCF and Relative Valuations (estimate growth rate and valuations for companies in future). In this you will learn the following:

  1. Excel Tips and Tricks for Finance

  2. Valuations in details

  3. Financial Modeling where in we will study in details the balance sheet, income statements, cash flow, projections etc along with the financial model in practical.

Build Financial Models & Value Companies The Easy Way

I am an award winning finance professor with work experience modeling companies @Goldman Sachs, hedge fund Citadel & VC.

Created by Chris Haroun - Award Winning MBA Professor, Venture Capitalist and Author.

"]

Students: 10862, Price: $19.99

Students: 10862, Price:  Paid

** ACCORDING TO BUSINESS INSIDER: "Haroun is one of the highest rated professors on Udemy, so you can expect to be in good hands through the course of your education." **

This course is for anyone interested in modeling and valuing companies the easy way. I will teach you the easiest ways to create and understand financial modeling and valuation methodologies based on my 20+ years of valuation and modeling experience as a hedge fund investor at Citadel and other companies, while I worked at Goldman Sachs, while I started a few companies and currently where I am a venture capital parter. I am also an award winning graduate business school finance professor and have an MBA in finance from Columbia University. I will teach you the easiest ways to value and model companies based on my experience.

Thanks!
Chris

Company Valuation & Financial Modeling

Learn comprehensive financial modeling, forecasting and business valuation techniques for Finance professionals

Created by Ashish Agarwal - Corporate Finance Expert, Ex McKinsey, Ex BlackRock

"]

Students: 9784, Price: $74.99

Students: 9784, Price:  Paid

Hey, welcome to our very popular Company Valuation and Financial Modeling online course. 

We are glad to see you visit this course. 

If only we could shake hands!

What is this course about?

In this course, we will teach you the comprehensive skills to undertake the valuation of any company.

We will illustrate the following broad content topics in great detail in this course:

1) Understanding the business model 

2) Preparing the financial statements - income statement, balance sheet and cash flows statement

3) Forecasting the financial statements

4) Discounted Cash Flows based valuation techniques

5) Sensitivities of valuation estimates

It is a very comprehensive course that will teach you the complete skills to perform the valuation analysis of any company.


How is this course useful for YOUR purpose?

Hey, did you watch the promo video? If not, please do. 

This course will help you to stand in good stead for a potential Analyst profile in the following sectors:

  • Investment banking

  • Equity Research

  • Private Equity

  • Asset Management 

  • Consulting / Advisory

Look, the Analyst profile is quite demanding in all of the above jobs.

So your employer will want you to be on ready to work on a real project on Day 1!

Our course does exactly that - we make you job ready for your professional work.

The course provides all the practical training to undertake the role of an analyst in the above sectors.

You can crack your upcoming interviews easily with the learning from this course.

You have lifetime access to the course once you enroll. 

So even if you don't plan to start now, you can still enroll and come back anytime later.


What makes this course different than others?

This course content is unique!

You will learn exactly what you are required to do in your daily work.

You get access to practical real life illustrations of all key skills to be a Analyst with Financial services firms

It is a completely hands-on course.

You need to carry out the illustrations in the course along with the instructor.

We provide you the same set up as the instructor. 

All illustration spreadsheets can be downloaded at your end.

You will feel as if somebody is guiding you step by step in all illustrations.

It is a very practical on the job training for you.

You are going to love our instructor's teaching style. 

He makes it very engaging and fun learning experience.

You will have practice assignments to test your learning from the course

The Practice Assignments are marked with varying difficulty levels - High, Medium and Low.

You will have unlimited access to our support.

Our support team responds to any course queries within 24 hours of your request. 

There are manually edited hand typed captions added on all lectures of this course. 

Feel free to refer to them in case you feel the need.

What are other students saying about this course?

Check our our reviews below.

Read what student Daniel Hughes had to say about this course- 

"Valuable information, Clear explanations, Engaging delivery, Helpful practice activities, Accurate course description, Knowledgeable instructor"

Go to the reviews section below to read more such stories.


What if I do not like the course?

Well, we will be very sad to hear that you did not like the course.

But you are well protected.

You have a 30 day money back guarantee in case you are not happy with the course.

No questions asked.

But we sincerely hope, you will definitely like the course!

What  next?

If there are any doubts, don't hesitate to reach out to us.

Start learning now.

See you inside the course.

Financial Modeling for Business Analysts and Consultants

Learn Financial Modeling in Excel that will allow you to participate in due diligence, strategy or turn around projects

Created by Asen Gyczew - Expert in performance improvement, turnaround and startups

"]

Students: 7373, Price: $94.99

Students: 7373, Price:  Paid

What is the aim of this course?

As a business analysts or a consultant you will have to from time to time create financial models. There are a bit different than business models. In business models you go into details of operations and you focus on getting the links on the KPIs. Those models are usually done for internal purposes, to manage in the right direction the business. Financial models on the other hand are more for external users. You concentrate in them on creating the picture of the business in a standardized, understood by everybody way. You also want to create the financial statements: profit & loss statement, balance sheet statement, cash flow statement.

On top of that you use the financial statements for valuation purposes.

The most typical situation when, as a business analyst or a consultant, you will have to prepare such a model are connected with selling or purchasing a company. You may be doing it on the sell side or on the buy side.  Financial modeling is done as a part of strategy projects, turn around projects, due diligence.

I will NOT teach you everything on financial modelling because it is simply not efficient (and frankly you don’t need it). This course is organized around 80/20 rule and I want to teach you the most useful (from business analyst / consultant perspective) ways to go as fast as possible from rough description to working model in Excel that you can make more and more complicated.

The aim of this course is that you are able to do a financial model of the business as fast as possible.

If done properly, this course will transform you in 1 day into pretty good business analyst that knows how to create fast and efficiently financial models. It is based on my 12 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from FMCG, SMG, B2B sector that I worked for.  On the basis of what you will find in this course I have trained over 100 business analysts who now are Investment Directors, Senior Analyst, Directors in Consulting Companies, Board Members etc.

I teach step by step on the basis of Excel files that will be attached to the course.  We will go through a real life example of a business and create the financial model for it. To make the best out of the course you should follow my steps and repeat what I do with the data after every lecture. Don’t move to the next lecture if you have not done what I show in the lecture that you have gone through.

 I assume that you know basic Excel so the basic features (i.e. how to write formula in Excel) are not explained in this course. I concentrate on intermediate and advanced solutions and purposefully get rid of some things that are advanced yet later become very inflexible and useless (i.e. naming the variables).

To every lecture you will find attached  (in additional resources) the Excel shown in the Llcture so as a part of this course you will also get a library of ready-made analyses that can, with certain modification, be applied by you in your work.

 

Why I decided to create this course?

This course is a part of my attempt to help business analyst and consultants gain fast useful knowledge that will help them excel at their work. I have done 10 other courses that will help you be great business analysts or consultants. I have covered already: hacks and tricks in Excel, business modelling, market research, management productivity hacks and others. Now you have the opportunity to learn financial modeling in Excel

 

In what way will you benefit from this course?

The course is a practical, step by step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you do the analyses as well as the quality of the conclusions coming out of available in your company data. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:

  • What is the difference between business models and financial models?
  • How to model cost positions and balance sheet position?
  • How to create on the basis of this financial statements: profit and loss statement, balance sheet statement and cash flow statements
  • How to make sure that there is integrity in the model?
  • What analyses and conclusions you can draw from the financial model?

You can also ask me any question either through the discussion mode or by messaging me directly.

 

How the course is organized?

The course is divided currently in 10 sections and will be adding new section to address other important issues. Currently you will find the following sections:

  • Introduction. We begin with little intro into the course
  • Modeling of Profit & Loss account. In this section we start by showing how to model cost positions (except for Depreciation)and how to create on the basis of this a profit & loss statement
  • Capex and Depreciation.  Capex and Depreciation are one of the most difficult elements that you will model in Excel. Therefore, we have created a separate section devoted just to this subject . In this section you will learn how to follow specific group of assets, truck their gross and net value and calculate depreciation.
  • Working Capital. Working capital is crucial to the business as it defines how much money you have to have engaged in the business. I will show you how to model specific positions of Working Capital
  • Debt.  You may need external sources of financing for the company. I will show you how to model loans and get the necessary info to create balance sheet later.
  • Equity. In this section I will show you how to model the equity and all relations with shareholders
  • Balance sheet modeling. Here we get everything together to model the balance sheet statement.
  • Cash flow modeling.  Here we get everything together to model the cash flow statement.  Here we will check integrity of the model as well.
  • Analyses of the Financial Model.  At the end, on the basis of ready model I will try to draw the conclusions that will show us whether the business we have been analyzing is interesting or not

 

 

You will be able also to download many additional resources

  • Excels with analyses shown in the course
  • Links to additional presentations and movies
  • Links to books worth reading

 

At the end of my course, students will be able to…

  • You will master financial modeling in Excel at the needed for business analyst and consultant level
  • Understand the main challenges in financial modelling
  • Perform the analyses of financial model
  • You will get ready model that you can utilize for your purposes

Who should take this course? Who should not?

  • Business analysts
  • Researchers
  • Controllers
  • Consultants
  • Small and medium business owners
  • Startups founders

 

What will students need to know or do before starting this course?

  • Basic Excel
  • Basic knowledge of economics or finance

 

 

 

The Advanced Real Estate Financial Modeling Bootcamp

The Complete Guide To Advanced Real Estate Financial Modeling For Real Estate Investment Professionals

Created by Justin Kivel - Real Estate Investing & Financial Modeling

"]

Students: 5544, Price: $109.99

Students: 5544, Price:  Paid

Master real estate financial modeling. Advance your career. Make more money.

If you're a current real estate professional looking to beef up your real estate financial modeling skill set, or you're looking to break into the real estate investment industry and want a leg up on your competition, you're in the right place.

The Advanced Real Estate Financial Modeling Bootcamp will take you from a basic knowledge of real estate finance and Excel to an expert real estate financial modeler who can model complex real estate investment scenarios, whether you're looking to land a new job or do your first deal on your own.

This course was built as a "playbook" that you can reference at any time. Need to model a construction loan? Check out the course. Modeling a hold/sell analysis? Log in again. Modeling a cash-out refinance after your renovation? Just check back into the class and follow the steps.

There are a LOT of things that you'll be able to do after taking this course, including:

  • Create dual-metric data tables to sensitize multiple investment return metrics in the same analysis

  • Build a dynamic best/base/weak case analysis that automatically calculates returns based on your upside (and downside) scenarios of any deal

  • Model a next-buyer analysis to precisely project sale proceeds at the end of a real estate investment

  • Partition your IRR so you know what percentage of your returns are coming from cash flow and what percentage are coming from sale (and your risk based on both)

  • Build a hold/sell analysis to calculate the optimal year to sell your property

  • Build out construction loan draws, dynamic equity draws, and capitalized interest to accurately model your capital structure on ground-up development deals

  • Model cash flow distributions on a monthly, quarterly, and annual basis (that can be switched at the press of a button).

This course is perfect for you if:

  • You're a college student or graduate student looking to break into the real estate investment industry after graduation, and you're looking to add the key technical skill sets to your arsenal that will put you head and shoulders above the competition and allow you to land a lucrative career opportunity in the field

  • You're an existing real estate professional looking to advance your career, increase your compensation, and break into the real estate investment industry at a high level

  • You've bought rental homes or duplexes, and now you're looking to buy larger commercial real estate properties and want to feel confident in your ability to analyze new deals

Here's what some of our students have had to say:

★★★★★ "This course was definitely intense, but the information is invaluable. Justin does a great job explaining everything thoroughly and I've learned more about Excel in my past few courses than my entire life."

★★★★★ "Another great course by Justin. I found this to be the most difficult of all his courses, very advanced. The best part is the comprehensive case study at the end that really ties everything together well. I felt like I learned a lot."

★★★★★ "Loved this course.  Justin's approach is very didactic and on point. If you have strong understanding of the basics in real estate finance, but don't know how to create a model, this course is for you. As Justin said, the secret to succeeding in this particular field is practice. Create the model again from scratch, go back to the solution file to make sure you get the right numbers."

★★★★★ "This was a fantastic course! Justin is very knowledgeable and explains all the concepts extremely well. I feel that this course has helped me very much and I am looking forward to continuing practicing the topics and improving on my skill set. I would highly recommend this course to anyone. Thank you Justin for the great work that you have put together."

★★★★★ "If you are a beginner to a veteran in CRE, and you've always wondered how to analyze an investment and the capital stack behind it, this is the only course you'll ever need. Justin Kivel does an excellent job of breaking down each of the considerations and explains them thoroughly. Thanks to Justin for putting out such a high-quality course!"

If you understand the basics of real estate finance, and you're looking to take your real estate financial modeling skill set to an expert level, I'd love to have you join us. Looking forward to seeing you inside!

Financial modeling | Project Finance & Infrastructure

Learn how build a project finance model & support infrastructure finance deals around the globe!

Created by DealMaker Financial Training - Financial modeling and Excel VBA training

"]

Students: 4957, Price: $49.99

Students: 4957, Price:  Paid

Want to work on project finance and infrastructure deals?
Want to break into private equity? Show you can build "complex financial models from scratch"?
Want to make a quantum leap in your financial modeling skills?
Want to learn Excel VBA and other tips to save you HOURS of work?

THIS is the course for YOU!

This course takes an application-led approach which will guide you through an ENTIRE project finance model build in Excel! 

That's right - you'll learn how to build one of the most complex financial modeling tools in the industry... from scratch!

You'll prepare yourself for to work on infrastructure deals ALL AROUND THE WORLD with:

  • Banks

  • Advisory teams

  • Private equity funds

  • Debt funds

  • Industrial developers

  • Asset managers

You'll cover the theory and financial modeling for:

  • SPV financings

  • Flexible capital structuring

  • Debt sizing

  • Debt sculpting/tailoring/payment structuring

  • Construction standby facilities

  • DSRA DSRF and other reserve provisions

  • VAT funding

  • Lender covenants

  • Complex cash waterfalls

  • Project finance ratios: DSCR & LLCR

  • Circular calculations  common to project finance modelling

Your financial model will:

  • Handle all the complex financial engineering and analysis applicable to almost ANY infrastructure finance deal

  • Calculate returns for debt and equity infrastructure investors

  • Give you flexibility to assess multiple financing and capital structure arrangements

  • Have clean, efficient VBA code to speed up your analysis and free up your time

  • Follow the very best practices actually used by professionals in the industry

 

This course gives you all the pro tips you'd other have to pay $1,000s to access as part of a corporate training programme!! 

DON'T WAIT ON YOUR BOSS TO APPROVE THE TRAINING YOU DESERVE!!

ENROLL NOW - there's ZERO RISK as you're covered by a 30-day money-back guarantee!

(https://support.udemy.com/hc/en-us/articles/229604248-Refund-a-Course)

Financial modeling | Renewable Energy: Solar & Wind

Learn how build a financial model for solar plants and wind plants, and help seal renewable energy deals worldwide!

Created by DealMaker Financial Training - Financial modeling and Excel VBA training

"]

Students: 2822, Price: $19.99

Students: 2822, Price:  Paid

Want to work on RENEWABLE ENERGY deals in WIND and SOLAR power?
Want to be part of the global shift to renewable energy? 
Want to break into a sector that is expected to have $10TRILLION poured into it through 2040? 

THIS is the course for YOU!

Go beyond filling out pre-prepared templates - build complex financial models from scratch!
Make a quantum leap in your financial modeling skills! 
Save hours at work - by learning Excel best practices and VBA!

This course takes an application-led approach which will guide you through an ENTIRE buyout valuation model for a newly operational WIND PLANT or SOLAR PLANT in Excel! 

You'll take a comprehensive a approach learning the BUSINESS AND RISK FUNDAMENTALS of wind and solar power plants' business, including how to find relevant information in technical engineering reports.

You won't just be taught how to build a financial model - you'll learn HOW TO USE IT. 

You'll prepare yourself for to work on solar and wind plant deals ALL AROUND THE WORLD with:

  • Banks

  • Advisory teams

  • Private equity funds

  • Debt funds

  • Industrial developers

  • Asset managers

You'll cover the theory and financial modeling for:

  • Solar and wind plant business and operations

  • Plant risk assessment

  • Debt sizing

  • Debt service sculpting/tailoring/payment structuring

  • Lender covenants

  • Complex cash waterfalls

  • Debt service ratios

  • Dynamic charts and dashboard design

  • Circular calculations common in plant financing deals

Your financial model will:

  • Handle complex financial engineering and analysis applicable to most wind and solar buyout deals

  • Calculate returns, a fair buyout price, and industry-specific multiple

  • Give you flexibility to assess multiple financing arrangements

  • Have clean, efficient VBA code to speed up your analysis and free up your time

  • Follow the very best practices actually used by professionals in the industry

 

This course gives you all the pro tips you'd other have to pay $1,000s to access as part of a corporate training programme!! 

DON'T WAIT ON YOUR BOSS TO APPROVE THE TRAINING YOU DESERVE!!


ENROLL NOW - there's ZERO RISK as you're covered by a 30-day money-back guarantee! 

(https://support.udemy.com/hc/en-us/articles/229604248-Refund-a-Course)

The Real Estate Financial Modeling Interview Exam Guide

How To Ace Your Real Estate Financial Modeling Interview Exam For Real Estate Investing Careers

Created by Justin Kivel - Real Estate Investing & Financial Modeling

"]

Students: 2530, Price: $109.99

Students: 2530, Price:  Paid

Want to land a six-figure job in private equity real estate investing?

According to CEL & Associates, Inc., the 2020 median total compensation for an acquisitions associate in retail, office/industrial, and multifamily was $137K, $143K, and $121K, respectively. This course will teach you the core fundamental Excel financial modeling skills necessary to land one of these jobs and succeed in your first commercial real estate investing role.

The opportunity in private equity real estate investing careers is HUGE. Top-tier salaries and bonuses, the ability to invest in big deals, and, unlike investment banking, a work-life balance that will general allow you to keep your friends and family and sleep more than 3 hours per night.

But breaking in isn't easy. In fact, many of these jobs require a real estate financial modeling interview exam to test your knowledge and ability to contribute from day one.

Yup, that's right. Writing "proficient in Microsoft Excel" on your resume won't cut it for these roles. The best firms (the ones you actually want to work for) will likely test your real estate financial modeling chops with a timed exam.

These firms want to know your knowledge and skill sets in five main categories:

  1. Microsoft Excel Formulas & Functions

  2. Real Estate Finance

  3. Commercial Real Estate Lease Modeling

  4. Cash Flow Statement Modeling

  5. ARGUS Export Modeling

This exam is usually the last "gatekeeper" for the most coveted private equity real estate investing analyst and associate jobs at multifamily, retail, office, and industrial investment firms.

This course will teach you how to ace that exam.

This is NOT a beginner course. If you're just starting out in real estate investing and real estate financial modeling, this course likely isn’t for you.

BUT if you have a basic understanding of real estate investing and real estate financial modeling and you're either applying for jobs or preparing for an interview at a real estate investment firm, this course will give you an unfair advantage to land the job you're looking for and stand head and shoulders above your peer group.

I'm not really sure why, but it feels like this information is hidden. While investment banking analysts and other professionals generally know what they're getting into with an interview exam, real estate financial modeling exams generally feel like Pandora's box.

When I was interviewing for jobs, no one could seem to tell me what I had to know.

I honestly didn't even know where to look.

So, after taking multiple of these exams, and actually creating these exams for incoming analysts and associates, I decided to create this resource for anyone looking to break into the real estate private equity field.

You can do this.

You just need to be prepared and KNOW what you're going to be asked ahead of time, and HOW you should answer those questions.

Firms are looking for a THOUGHT PROCESS and MODELING EFFICIENCY - and you're going to learn how to master both of these things in this course.

Here's what some of our students have had to say:

★★★★★ "Unbelievable value for money. It feels like I just accomplished an MBA in Real Estate Finance."

★★★★★ "Justin is a very clear instructor who can explain complex topics and formulas with ease. I have learned a ton from all of his courses and hope to use them to enhance my own career path! I highly recommend this course for anyone who is looking to sharpen their excel / real estate financial modeling skills and break into real estate investing."

★★★★★ "This course greatly helped as a refresher when interviewing for a large institutional Lending position. It also enabled me to be much more efficient in my modeling."

★★★★★ "Justin's classes are very clear and he drills the parts that you need to know continuously. It is also helpful that he continues to say the keyboard shortcuts so that you remember them."

★★★★★ "Awesome. Great way to end your programme of courses. I feel like I've definitely gone from a from scratch beginner to probably at the advance intermediate stage now. Many thanks for all your help in putting all these videos together!"

If you're ready to build your real estate financial modeling arsenal so you can tackle any questions that come your way on interview day, click the enroll button to get immediate access to five institutional-quality real estate private equity interview exams, with in-depth walk-throughs and explanations every step of the way.

See you on the inside.

Financial Modeling for Startups

Learn how to model a startup business in Excel and draw conclusions about your business

Created by Asen Gyczew - Expert in performance improvement, turnaround and startups

"]

Students: 2522, Price: $89.99

Students: 2522, Price:  Paid

Why have I decided to create this course?   

I work with startups, VC, and PE funds daily and I have noticed that despite tons of very good books on lean methods (i.e. Lean Analytics, Running Lean, etc.) startups as well as small/medium businesses have problems with applying this knowledge in practice. We have noticed that especially first-time startups, do not really understand their business model (which is totally understandable). That’s why it is very difficult for them to know what they should concentrate on.  Most entrepreneurs/startups have a more or less clear business idea but quite often they do not know the business models they have chosen works in practice and they end up learning it the hard way, through their own mistakes. They have even more problems with translating the business idea/business model into a coherent Excel model and checking whether the idea is worth trying.     

No matter what business you are trying to start it is worth devoting some time and building a financial / business model in the form of Excel. This simple tool will help you estimate the value of your business, see how much cash you need and how your business ideas and KPIs are affecting your business. Once you build the model you can play with it and see how using different assumptions and parameters your profit will change.   

This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 94 000 students including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

What will this course give you?   

The course is a practical, step-by-step guide loaded with tons of tips and tools that will help you significantly speed up your business, especially if you are a startup or a small/medium business. There is little theory – mainly examples, a lot of tips from our own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:   

  1. what your business model is about, what to concentrate on and what are the key KPIs for you?   

  2. How you can translate it into Excel and evaluate your business?   

  3. How to make conclusions on the basis of your business model presented in the form of Excel   

In this course I will talk about 4 online business models: e-commerce, marketplaces, SaaS, media site and 2 more traditional ones: restaurant and consulting (service) firm   

How the course is organized?   

Currently, the course is divided into 7 sections:   

  • Introduction. In this section, I give you a quick  overview of the purpose and approach we will use in each and every section   

  • E-commerce business model.  In this section, you will get insight t into the business model of different e-commerce companies. The E-commerce business group is very diversified so we will try to show the similarities and the differences between concepts. You will learn here the definition of this business model, see some examples of companies using these business models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, I will show you how you can build the model in Excel and what conclusions can you draw from it.   

  • B2C Services. In this section, I will discuss the business model of B2C services i.e. hairdressers, restaurant chains, plumbers, electricians, etc. I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. We will go into more details when it comes to the restaurant chain and I will show you how to model it in Excel   

  • 2-sided market business model. This business model has been very popular over the last 5-years and successful companies in this model can grow to be truly global players on a big scale. Here you will get insight into the business model of a 2-sided market, especially marketplaces. You will learn not only the definition of this business model but you will have also the opportunity to see some examples of companies using these models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, I will show you how you can build the model in Excel and what conclusions can you draw from it.   

  • SaaS business models. Here you will get insight into the business model of a Software as a Service company. You will learn the definition of the business model, see some examples of companies using these business models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. In the end, I will show you how you can build the model in Excel and what conclusions can you draw from it.   

  • B2B  Services. Next, we will move on to the business model of B2B services. They behave a little bit differently than the B2C service. I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. In the end, I will show you how to model consulting business in Excel.   

  • Media site business models.  Here you will have a look at a relatively simple and cheap business model – a media site. You will learn the definition of this business, see some examples of companies using these business models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, I will show you how you can build the model in Excel and what conclusions can you draw from it.   

You will be able also to download many additional resources   

  1. Models in Excel show in lectures   

  2. Links to books worth reading   

  3. Links to additional resources

At the end of my course, students will be able to…   

  • Model your business in Excel

  • Manage based on numbers your business and set well priorities

  • Pick the right business model for your business idea

  • You will understand what is important in your business

  • You will know what KPI you should look at and what are the benchmarks

  • You will be able to write down your business model in the form of an Excel model and to draw a conclusion out of it

Who should take this course? Who should not?   

  • Startup founders

  • Small and medium business owners

  • Investment Directors

  • Business analyst

  • Financial Analyst

  • Controllers

VBA for Financial Modeling | Excel Automation

Automate repetitive work tasks and revolutionise your productivity!

Created by DealMaker Financial Training - Financial modeling and Excel VBA training

"]

Students: 1767, Price: $119.99

Students: 1767, Price:  Paid

THIS COURSE WILL CHANGE EVERYTHING...!!!

Yes, of course I'd say that.... but this time it's true!

How many times have you...

  • Had to clean up your financial model to share with clients?

  • Had to reconfigure Excel display settings because they got messed up?

  • Lost sleep because you didn't keep your financial model's log up to date?

  • Had to repeatedly go through the financial model to manually remove sensitive information?

  • Wasted time keeping track of all the defined names in your model?

  • Had to lose time manually saving files for every case and scenario you calculate?

How would you feel... if all you had to do... was press a magic button and BOOM! 
You finish in less than 1 second???

And what would it be worth to YOU, to know how to build your own Excel automation routines to take over the repetitive grunt work you always knew was a job for machines to do???

Learning VBA can give you ALL OF THIS!

This course teaches VBA to automate Excel by guiding you through SEVEN automation tools built for financial modelers!

You won't be left scratching your head wondering what all the VBA's for because you will be using it straight away to discover how to save yourself time at work!

I simply can't imagine a world without VBA now... I mean how would you feel if they took away your keyboard??? ... the INTERNET?????!!!

Once you know the secrets of VBA, you will never look back and frankly, the way you use Excel will never be the same again...

New doors will open - and you will be flying through them!

Financial Modelling from Scratch using Microsoft Excel

The Ultimate Financial Modelling Course!

Created by Piyush Arora, CFA, MBA Finance - Champ at 'All Things Finance'

"]

Students: 1388, Price: $59.99

Students: 1388, Price:  Paid

Designed and delivered by an Investment Banker who has made more than 200+ financial models, this course can teach you how to make your first financial model or brush up your knowledge if you have made financial models in the past. This course is relevant for any business executive wanting to add the skill set of financial modelling to his CV/Resume. We will create a live model during the course and the instructor will provide inputs at each step. If you are an executive trying to gain financial modelling skill or if you are a startup founder looking for guidance in making your business plan or just a student interested in adding financial skills to your resume, this course is for you!

The instructor, Piyush Arora (CFA, MBA-Finance) has been an Investment Banker, a Private Equity investor and a Venture Capitalist. He has worked on more than 200 deals worth more than USD 1 bn over the last decade.

Complete Financial Modeling for Project Finance in Excel

Learn Financial Modeling for Project Finance and Infrastructure Valuation ( DCF and IRR ).

Created by Greg Ahuy - Financial Modeler at FMO - Financial Model Online

"]

Students: 1049, Price: $109.99

Students: 1049, Price:  Paid

Master the high-end financial modeling skills pivotal to developing, modifying and analyzing financial models for projects in infrastructure sector.

In an online environment you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring and operational scenario evaluation. This course will provide step-by-step instructions on how to build financial model suitable for analyzing project finance transactions.

What this course is about?

Project finance models are used to assess the risk-reward of lending to and investing in an infrastructure project. The project's debt capacity, valuation and financial feasibility depend on expected future cash flows generated by the project itself and a financial model is built to analyze this.

In The Project Finance Modeling course we will model complex greenfield toll road project finance transactions from scratch in excel.

You will learn about:

- what is project finance;

- financial modeling of complex, real-life project finance transactions;

- how to sculpt debt to a target DSCR;

- how to create best practice macro’s and VBA codes to break circularities;

- how to model Debt Service Reserve Account and Maintenance Reserve Account;

- how to model Shareholder Loan, Revolver and Blended Equity IRR;

- building project finance models in excel that cover the entire life of the project;

- carry out valuation analysis based on the discounted cash flow (DCF) and internal rate of return (IRR) methods;

- preparing trusted project finance models tailored to investors and financiers, with a focus on valuation and risk

- financial models that are designed according to the F.A.S.T standards.

This is the same comprehensive financial training used to prepare analysts and managers at top financial institutions and infrastructure funds.

Why you should enroll in the Complete Project Finance Modeling Course?

Realistic project finance training - The Project Finance Modeling in Excel course includes over 9 hours of instructor-led video content to learn at your own pace. After completing this course you will be able to build complex, real-life project finance and valuation models.

Affordability - a similar course, which provides realistic project finance modeling training will cost you anywhere from US$1000 to US$2500 per course.

Learn anytime and anywhere - The Project Finance Modeling course is 100% online so you can learn the modeling when it is convenient for you.

How does it work?

The course length is over 9 hours.

First, we will review basic project finance theory, so you understand all essential components of project finance transaction.

Then, in the second part, we will go over the toll road project case study and review modeling methods to improve our productivity in excel. We will then dive into building our project finance model. We will work on the construction costs, funding and financing fees.

In the third part, we will build fully integrated, 3 statements financial model which will include income statement, balance sheet and cash flow statement.

In the forth part, we will model such items as coverage ratios, debt sculpting, debt service reserve account and maintenance reserve account, revolver, shareholder loan. We will also carry out valuation of the project using discounted cash flow ( DCF ) and internal rate of return ( IRR ) methods. This is a core part of any project finance model.

Finally, in the fifth part, we will introduce advanced financial modeling topics such as equity first funding method, debt sizing automation, debt service reserve account automation and scenario analysis.

Is this course for you?

Yes, if you need to build, review or analyse project finance models within the infrastructure, oil & gas or mining sectors. Typical students include analysts, managers, senior managers, associate directors, financial advisors, financiers and CFOs from project companies, investment banks, private equity and infrastructure funds.

This course prerequisites:

You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows.

Build a Robust Stock Valuation System – Financial Modeling

Learn how to value any stock using Multiples. Apply rigorous finance fundamentals to build a system designed to last.

Created by Fervent #LearnWithDistinction - Rigorous courses, backed by research, taught with simplicity

"]

Students: 808, Price: $94.99

Students: 808, Price:  Paid

Make better investment decisions by becoming a master at one of the most versatile and core finance fundamentals concepts - Stock Valuation, using Multiples.

Design and build your own robust valuation system from scratch, using financial modeling techniques that are rigorously grounded in the academic and practitioner literature. Then replicate your system on any stock going forward, anytime, anywhere.

Learn how to extract, compile, and compare real financial statements while pushing the boundaries on what’s possible with financial modeling on Excel® and Google Sheets.

Explore why even credible sources can give you different information about the same thing. And what you can do to make sure you have the ‘right’ estimates for your stock valuation, so you can make robust investment decisions backed by solid finance fundamentals.

Discover how to find the most appropriate "comparable" firm by learning how to ‘match’ firms on size, profitability, competitive advantage, cashflow management, and more. This is the "make or break" factor in financial modeling of stock valuation using Multiples.

Don’t just use Multiples that are out there – learn how to create your own. From scratch.

There’s no prior knowledge required. We’ll start you from the very basics, and build you to a PRO at Stock Valuation using Multiples thanks to:

5 SECTIONS TO MASTERY (plus, all future updates included).

Introduction & The Fundamentals

  • Explore what valuation is (and what it isn’t).

  • Understand Multiples Valuation and what its single core underlying assumption is (this assumption also underlies most if not all finance fundamentals).

  • Build your Accounting Fundamentals – you’ll need it for when you work with real world financial statements, extensively applying financial modeling techniques in hands on walkthroughs that follow.

Identifying Our Target and Pool of Comparable Firms

  • Choose any company you want. Or work with us on our randomly chosen S&P500 firm (which eliminates any bias from us).

  • Start the financial modeling by explore how to identify a pool of comparable firms for your target firm.

  • See where - and how - to download financial statements from credible sources including the SEC, for free.

  • Learn how to compile financial statements from scratch and make them easily comparable and replicable financial modeling activities.

Identifying a core comparable firm

  • Remove the subjectivity and guesswork from choosing a great comparable correctly. Apply robust finance fundamentals and financial modeling techniques to your stock valuation methodology, consistently.

  • Match firms on industry, subindustry, size, liquidity, profitability, competitive advantage, and cashflow management.

  • See precisely why a firm makes a great comparable.

  • This aspect of financial modeling really is the "make or break factor" for any investment valuation done via Multiples.

Explore core Stock Valuation Multiples

  • Master the core valuation Multiples most commonly used for stock valuation.

  • Understand what the P/e, P/s, MTB, and P/OCF Multiples are, and what their underlying assumptions are (even if you don't know anything about any of them).

  • Gain a solid understanding of how each Multiple works - and why it works the way it does.

  • Discover what it takes to create your own stock valuation Multiples. From scratch. Done right, this would mean your financial modeling approach is truly unique.

Value stocks using Multiples

  • Apply the key valuation Multiples to value the target firm using all the core finance fundamentals and financial modeling techniques you've built up from scratch.

  • See first hand what constitutes a 'reasonable' estimate, and what doesn't.

  • Explore Multiples that you can obtain from third party sources - with the caveats you want to bear in mind.

  • Learn whether and when you should buy vs sell your target stock.

DESIGNED FOR DISTINCTION

We've used the same tried and tested, proven to work teaching techniques that've helped our clients ace their exams and become chartered certified accountants, get hired by the most renowned investment banks in the world, and indeed, apply rock solid financial modeling techniques to value their own stocks. We're proud of our students - whose finance fundamentals are second to none.

Here's how we'll help you master stock valuation and turn you into a PRO at financial modeling:

A Solid Foundation

You’ll gain a solid foundation of the core finance fundamentals that drive the entire stock valuation process. These fundamentals are the essence of getting a good valuation estimate, for any firm - anywhere in the world.

Complete Walkthroughs

We start from a blank spreadsheet. And build it up to a rigorous, robust, and reusable template that you can adopt and modify for your own financial modeling and valuations. You'll never feel overwhelmed, because you'll know each spreadsheet inside out.

Loads of Practice Questions

Apply what you learn immediately with 100+ practice questions, all with impeccably detailed solutions. Your finance fundamentals and financial modeling skills will be stronger than ever, seriously.

Cheat Sheets & Resources

One page cheat sheets and workable Excel® & Google Sheet spreadsheets – all included.

Push the boundaries. Take your Excel® and Google Sheets skills to the next level.

Together, we'll push the boundaries on what's possible with Excel® and Google Sheets.

You'll work with some of the most advanced and complex functions Excel® and Google Sheets have to offer. And this will help you work faster, while reducing the likelihood of errors.

Perhaps most importantly - it will help you future proof and automate your successive stock valuation and financial modeling exercises. Allowing you to identify potentially lucrative investment opportunities faster, with confidence that your methodologies are backed by rock solid finance fundamentals.

Say goodbye to information overload.

Engage with carefully thought out, clutter-free, and engaging study materials that focus on the 20% finance fundamentals that drive 80% of the great financial modeling results.

Easily follow through complex stock valuation concepts with great visuals that don’t overdo it.

Explore byte-sized lectures that don’t cut corners – so you receive the right amount of information which will hold you in good stead wherever you go, whatever you move on to do.

Watch your confidence grow.

Apply what you learn immediately in example question walkthroughs and progressively challenging quizzes with impeccably detailed solutions.

Engage with over 100 questions ranging from simple true and false ones to more complex problems that take you outside your comfort zone.

Questions are relevant for Ivy League / Russell Group University students studying any core Finance Fundamentals / Financial Analysis course, as well as professionals studying for the ICAEW CFAB, ACA, ACCA, and CFA qualifications.

All questions designed in-house, by Russell Group Distinction Tutors.

To top it all, you can work with us in conducting your own stock valuation - thanks to our hands on walkthroughs, where we show you exactly what to do and how to conduct great financial modeling... One step at a time. One cell at a time. One spreadsheet at a time.

Gaining a solid command over core finance fundamentals has never been easier.

Explore what to do when things don't go according to plan.

We've intentionally included 'hiccups' and troubleshooting in the videos, so you gain a genuine and authentic view of the kind of issues you'll encounter when conducting your own stock valuation exercises.

______________________________________________________________________________________________________________________

We're proud of our students, and inspired by these stories - we decided to share them (unedited) with you...

"I have had a great experience with Fervent tutor as I was taught more of the content and less memorizing. I think their timings and their work is professional as the tutor seeks the most efficient and productive way to help the student. I studied accounting with the tutor and it contributed greatly to my knowledge for the exam."

- Abdulaziz, BA (Hons), International Management

"Fervent goes above and beyond the call of duty. First, they help you get the basics right and then assist you until you get a firm grip of your module. Fervent provides an extremely professional and patient environment. Doesn’t matter how many questions you have or silly you think they are, they encourage all of it. I never would have passed my module rather score a merit in it if it wouldn’t have been for Fervent."

- Shambhavi, MSc, Accounting and Finance

Fervent provides an exceptional service, the whole process from start to finish was very hands on and supportive – during my final year I needed tuition for a governance paper, essentially I was hoping they would do all the work for me but in the long run I got so much more than I bargained for ….they changed my entire thought process and maintained a complete professional reserve. Working with me every step of the way, I was encouraged to think critically in achieving my objective and inspired to dig deep. As a result I produced a 2000 word essay (which I had them proof read as well) worthy of a distinction. Thank you for all the help and most importantly thank you for believing in me.

- Sean, MSc, Accounting and Finance

Throughout the period of doing my Master’s dissertation, I felt agonised from not only researching my specific topic but also writing clearly with no any grammatical errors. Fortunately, I found Fervent which offers efficient and comprehensive services. At first, I just expected my dissertation to be improved in terms of grammar; however, Fervent provided me much more than that. All essential aspects such as formatting, structure, logic, consistency of analysis and critique, strength of arguments are also checked and corrected. One thing that I’ve been very grateful is related to my topic details. In addition to pointing out some big mistakes and recommending more accurate and professional alternative solutions, Fervent gave me many more interesting and valuable ideas which helped to develop my content to have stronger arguments and more critical analysis. My tutor’s suggestions helped me become more analytical in my thought process and in producing a better research paper; my critical thinking skills also saw a considerable improvement. Without Fervent’ support, I don’t believe I could have been awarded an excellent grade for this dissertation. Thank you so much for invaluable help over my hard time.

- Duang MSc, Financial Analysis and Fund Management (with CFA®)

Undoubtedly the gains that I have acquired from the studying with Fervent are plentiful and significantly make me different from what I used to be in terms of my expanded knowledge base, improved English skills (e.g. English-writing), as well as being more confident communicating with English speakers and with the improved ability to think differently and critically for dealing with various types of course works in my study in the university more readily.

My tutor is specialized not only in the teaching of Accounting and Finance but also very familiar with the relevant knowledge in the subjects such as Marketing and Management. This is why I trust this person at an initial point along with his kind, friendly and very patient characteristics (e.g. I’m always encouraged by my tutor during the session with him, often to hear: if you really want it and then you can do it and will make it with no doubts).

“Skilled worker ushers in the gate, leads a pious life depending on individual.” This is a Chinese old saying which I can still remember vividly because it was what my tutor had told me in my  with him and made me believe an excellent learning outcome and a constructive learning process requires the hardworking from both of us. The record shows we did it. This is another reason I like Fervent as in the session with my tutor you see his hardworking as for the preparation for each session and in making the sessions distinctive from cliché-ridden teaching-and-listening classes by exploring the best way and the most suitable set of teaching methods to provide the student with the best value for money.

Jiajian BA (Hons), Business and Management

Financial Modeling for Corporates

Learn Financial Modeling for corporate strategy, banking, FP&A, equity analysis & get a world class financial model

Created by Kyle Chaning-Pearce - Founder of Finmodo | Financial Modeling Trainer | Maxwell

"]

Students: 747, Price: $34.99

Students: 747, Price:  Paid

Thank you so much for your interest in Financial Modeling for Corporates

I've been working closely with investment professionals, students, and financiers to unlock their deals... so that financial modeling is finally the "solution" they hoped for, and no longer a confusing, lengthy and stressful exercise.

Here are a few of the things you’ll end up with

- The .xlsx template that model building professionals use and jealously guard

- A step by step breakdown of EXACTLY what to do at each step to build a best practice financial model

- A company valuation and a beautifully constructed summary page

- Literally hundreds of hours saved in figuring out how to do it yourself

Here’s how it’ll work

In over 6 hours of video’s I’ll walk you through

- Overview behind financial modeling and understanding different types of models, sources of complexity so that you can apply these skills to any model in the future

- A shoe business case study to build up a financial model basically from scratch (minus some preformatting and labels to save you time)

- EVERY module you’ll ever need: The Revenue, Expenses, Capex, Depreciation, Tax, Cashflow Statement, Income Statement, Balance Sheet, Summary Sheet... the list goes on

“The gold standard” Corporate template model

Get the .xlsx file that gives you a chance to play with a business, modeled on a real shoe business.

Building a financial model is not just a tick box exercise. It is a system for thinking through major decisions and helping you better understand a business.

Building a best practice model is about 50 different things done well. It doesn’t matter if you’re the worlds smartest person, you’ll never figure it out on your own.

Why you should create a financial model for a corporate? A well-built financial model can help you to

1. Value a company or an asset for an M&A transaction

2. Plan for cash surpluses or shortages (ahem…call your bank!)

3. Run scenarios to inform Corporate Strategy

4. Test your assumptions

5. Much much more…

What will I be able to do after taking your course?

You’ll be able to build a gold standard best practice model that will serve a range of functions… follow the courses, do the material, and you’ll be able to knock the socks off recruiters, VP’s and your bosses in the following industries

- Corporate Finance

- Private Equity

- Equity Analysis

- Financial Planning & Analysis

- Investment Banking

Why learn from me?

Over the last 6 years, I’ve trained over one hundred live financial modeling courses, each course a full 2-3 days. To an audience of Wall St bankers, London Corporates, Dubai Private Equity Funds… and a mix in Saudi Arabia, Tanzania, Australia, New Zealand, Switzerland… the list goes on. I know the issues my students experience, and I know where people get stuck. Every problem that you have – chances are I’ve seen it many many times. My passion is teaching people useful skills in as short a time as possible. I’m here to help you along the way.

When I wasn’t training, I built models in that time, recently for a Californian Green Energy fund with over $2bn invested, the World Bank, and ran debt and equity processes. Trust me – it’s a lot easier to run every different combination and permutation of numbers when the model is well built!

The $2500 live courses I taught covered a fraction of the material I’m covering here – simply because you can’t fit this much learning into two days.

What if I don't have any finance or Excel background?

Most people spend years trying to figure out how to fit a model together. Most never figure it out.

With this blueprint template that helped me to put together hundreds of financial models, combined with extensive videos, you'll cut years off the learning curve too. Everything that you will need to do to build a model from scratch – I will demo for you, talk you through, explain, and even have pop-ups on the screen that you wouldn’t get in a live course. Financial modeling becomes a lot more fun when you have this.

I want to do a live course; how do I do that?

Live courses are great, you get the a added benefit of rubbing shoulders with likeminded people. You don’t, however, get the benefit of doing them again and again like an online course, with all the additional detail that comes along.

I’m not currently running live courses, but I can recommend former colleagues etc who run great live courses. Email me if you’re interested.

Why a shoe business case study?

The case study models the North American arm of a (real) industry-leading shoe business.  Why? Everyone knows shoes – it’s not super complex to understand. Additionally, it's a relatively stable industry.

How does this translate to other financial modeling uses (project finance, start-ups)

70-80% of a well-built model has the same functionality. This doesn’t cover project finance specific metrics, funding structures etc. This is geared to cover a corporate which is a stable business.

OK, so how do I get a spot?

Click the "Buy Now" button at the side of this page to get started with me now.

The sooner you get in, the sooner you start figuring out financial modeling and learning a skill set which will last you a lifetime.

With a whole lot of excitement for you,

Kyle Chaning-Pearce

P.S. If you’re on the fence

May I make a suggestion?

Don't make a decision now. Put the template to the test and try it for 30 days. Go through the model and have a play with it. Go through the videos to understand how the jigsaw of the underlying business fits together.

Feel what it feels like to have a done-for-you model at your fingertips.

See what it looks like when everything comes together in one model

Get used to crystal clear explanations.

If after 30 days it isn't everything I've promised and more, let me know and Udemy will refund every penny.

Financial Modeling & Fundamental Analysis

Complete A-Z of Financial Modelling (India Focused)

Created by Devang Maheshwari - Chartered Accountant

"]

Students: 573, Price: $49.99

Students: 573, Price:  Paid

Do you want to get into Investment banking/Equity Research/Portfolio Management i.e into Core Finance ?

Are you about to graduate from university and start looking for your first job?

Are you a young professional looking to establish yourself in your new position in Finance Domain ?

Would you like to become your team's go-to person when it comes to Financial Modeling in Excel?

If you answered yes to any of these, then this is the right course for you!

CA Devang Maheshwari (The Instructor) of this course has extensive experience in Financial Modeling:

  • Worked as Senior Analyst in ICICI Securities & Purnartha Investment Advisory thus making & updating models all day

  • Experience in making financial Modeling for various clients at Job work

  • Handled more than 400 Cr during the Job tenure

Learn the basics of Financial Modeling from someone who has walked the same path. Beat the learning curve and stand out from your colleagues.

A comprehensive guide to Financial Modeling in Excel:

  • Become an Excel expert (From Basics to Pro)

  • Learn how to build sound Financial Models and stand out among your colleagues

  • Gain an in-depth understanding of the mechanics of Company Valuation using various methods like DCF/Relative Valuations/DDM

  • Gain in depth understanding of how to make Financial Statements & also How to forecast it

  • Portfolio Management

  • Fundamental Analysis

  • Report Writing

  • Sector Analysis

  • Be prepared from day one for your Investment Banking, Financial Advisory or Consulting career

What we offer:

  • Well-designed and easy-to-understand videos FOCUSED ON INDIAN LISTED COMPANY

  • Detailed explanations with comprehensible case studies based on real situations

  • Downloadable course materials

  • 25 hrs of intensive training

By completing this course, you will:

  • Be able to work comfortably with Microsoft Excel and many of its advanced features

  • Become one of the top Excel users in your team

  • Be able to build a P&L statement from a raw data extraction

  • Be able to build a cash flow statement

  • Know how to value a company using different valuation methods

  • Know how to calculate WACC & forecast financials in real life situations

  • Be able to build a valuation model from scratch

  • Know how to create a model with multiple scenarios

  • Know how to manage a portfolio

  • Know how to write a research report

About the course:

  • No significant previous experience is needed to understand the course properly and benefit from its content

  • Unlimited access to all course materials for lifetime

  • Emphasis on learning by doing

  • Our goal is to take your Microsoft Excel and Financial Modeling skills to the next level

Make an investment that will be highly rewarded in career prospects, positive feedback, and personal growth.

This course is suitable for graduates who aspire to become investment bankers as it includes a well-structured DCF model and goes through the theoretical concepts behind it. Moreover, it will encourage you to be more confident when coping with daily tasks and will give you the edge when the firm must decide whether to take you on for a full-time position.

People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.

Go ahead and subscribe to this course! If you don't acquire these skills now, you will miss an opportunity to separate yourself from others. Don't risk your future success! Let's start learning together now!

Who this course is for:

  • Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.

  • Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills

Thank You

CA Devang Maheshwari

Fundamentals of Financial Modeling

Learn the Fundamentals of Financial Modeling and Learn Important Skills Financial Modeling

Created by Mike M. - Business Coach

"]

Students: 565, Price: $29.99

Students: 565, Price:  Paid

Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. It is an abstract numerical scenario of a real-world financial situation used to ascertain the future financial performance by making projections. The user can manipulate the inputs to maintain the quality of a financial model, which will result in accuracy and dependency one can have on the outputs.

In this course, you will learn financial modeling of different sectors that can be used in corporate finance, investment banking, commercial banking, and portfolio management. 

Using Microsoft Excel, we'll cover financial statement models, investment banking models, M&A models, buyout models, and DCF models.

This financial modeling course is designed for students and professionals who want to master excel modeling skills.

Step-by-Step 3 Statement Financial Modeling

A time-efficient way to learn how to create 3 statement financial models!

Created by Michael Ng - Global Private Equity Investor & Investment Banker

"]

Students: 279, Price: $29.99

Students: 279, Price:  Paid

The Step-by-Step 3 Statement Financial Modeling course is designed to provide you with a highly approachable & time-efficient way to learn more about how to create your own financial models and review those created by others!

We cover each component of a 3 statement financial model from creating detailed forecast assumptions to modeling out each of the financial statements (P&L, Cash Flow Statement, Balance Sheet) within Excel. We use a highly practical learning approach with a student-led case study completed during the course. We stand with you each step of the way as you discover the need-to-know concepts to make sure you can put this to use immediately! The 100% free preview lectures and course outline will give you a feel for the style and level of content that will be covered.

I have worked in senior roles at the best global investment banks such as J.P. Morgan and Citigroup, having also been a private equity investor in Europe and Asia. You should feel confident that you are in good hands!

Course Outline:

1. Course Introduction - discover the first steps of creating a 3 statement financial model in Excel 

2. Operating Assumptions - dive into how to create a set of operating assumptions for a business 

3. The First Statement - P&L - learn how to model out the profit and loss statement

4. The Second Statement - Cash Flow Statement - understand how the P&L is linked to the cash flow statement and how to model it out

5. The Third Statement - Balance Sheet - learn how to model out the balance sheet and its supporting schedules

6. Final Model Check & Troubleshooting - discover how the 3 financial statements come together & key strategies to troubleshoot a model

If you have any questions once you get started, do not hesitate to use the embedded Q&A function and we will get back to you shortly to continue your learning journey.

Whether you're wanting to improve your financial modeling skills or are even brand new to the finance world, this is the course for you!

We can't wait to see you inside the course!

Company Valuation, Financial Modelling and Analysis

Company Valuation - Discover DCF, Cost Valuation, Ratios, Comps, Precedent Transactions, EVA, WACC, CAPM and much more!

Created by John Colley MBA, MA(Cantab) - Investment Banking | Business| Entrepreneurship | Finance

"]

Students: 144, Price: $29.99

Students: 144, Price:  Paid

Welcome to this Company Valuation, Financial Modelling and Analysis Course

The complete Company Valuation Course for Finance Professionals taught by a 30 year Financial Professional!

We have divided this course into six sections (as explained in the second previewable lecture):

  • Introduction & Principles

  • Asset Based Valuation

  • Market Based Valuation

  • Intrinsic Valuation

  • Advanced Valuation

  • Results Presentation

In the first sections of this course you will discover:

  • What is meant by Valuation

  • The difference between Value and Price

  • Key Principles in Valuation, including Intrinsic Value and Time Value of Money

  • Cost Valuation and under or over valuation with Tobin's Q

  • The Role of Ratios in Comparative Valuation

  • Comparable Company Valuation - "Comps"

  • The Dangers of Rule of Thumb Valuations

  • Precedent Transactions Analysis

  • Economic Value Added and Market Value Added

Then in the comprehensive Discounted Cash Flow Sections (a course within a course) which is a close study of Intrinsic Valuation, you will discover:

  • Introduction to Discounted Cash Flow and what we mean by Present Value

  • Understanding Free Cash Flow in DCF Valuation

  • A Strategic Analysis of Business Drivers

  • Calculating the Discount Rate using the CAPM and WACC

  • Risk Measurement and the Cost of Capital

  • Discounted Cash Flow Modelling

  • The Dividend Discount Model (Gordon's Growth Model)

  • Ability to Pay Analysis

  • Sum of the Parts Analysis

    We then go on to discuss more Advanced Topics in Valuation which will set you out from the crowd

  • Complexity in Corporate Finance Valuation

  • Valuation in Mergers and Acquisitions Transactions

  • How to value Private Companies (3 different ways) and why its so difficult

  • Warren Buffet and Value Investing

  • Margin of Safety

  • The Efficient Market Hypothesis

  • How to be your own Value Investor

  • Valuation in the New Economy - valuing Internet Companies

  • How to value a Startup

  • How to Present Your Valuations in a Football Field Graph

This course also includes a series of "Mini Models" in Excel for you to download and work with.

These include:

  • Ability To Pay Analysis.xls

  • Basic Discounted Cash Flow Model Example.xls

  • Case Study Apple Book Value Per Share.xls

  • Cash Flow Valuation 3 Measures Model.xls

  • COMPANY VALUATION COURSE MODEL.xls

  • Comparable Transactions Model.xls

  • DCF and EVA Check Calculation.xls

  • eCommerce Valuation Simple Model.xls

  • Football Field Valuation Graph.xls

  • Football Field Vertical Graph Model.xls

  • Margin of Safety Calculator.xls

  • Score Card Startup Valuation .xls

  • WACC Exercise.xls

PLUS Every Slide Deck in the course is available to download!

Why should you choose this course?

Company valuation is a core topic for every finance professional. You simply cannot afford NOT to know this topic.

  • Investment Banking

  • Equity Research

  • Private Equity

  • Venture Capital

  • Asset Management

  • Consulting/Advisory

  • Enterpreneurship

What makes us qualified to teach you?

This is a Company Valuation course taught by a 30+ year, Managing Director level,  Investment Banker - from a practical perspective

Our Promise

I have been teaching on Udemy since 2014 and am fully committed to it. If you have any questions about the content or anything related to any topic, you can reach out with your questions at any time and I always do my best to respond promptly

Don't forget that this course (and all my courses) benefit from Udemy's money back guarantee!

A Verifiable Certificate of Completion is presented to all students who undertake this Company Valuation course.

What are you waiting for?

Enroll today and I will see you in the course!

Best regards

John

Quick Excel for Financial Modeling

This course teaches the fundamentals of financially modeling a business using Excel.

Created by Illumeo Learning - Condensed and Efficient Courses for Busy Professionals

"]

Students: 140, Price: $34.99

Students: 140, Price:  Paid

In this course we learn how to financially model a business using Excel. Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes. 

We concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow. We use an approach that keeps model integrity and credibility top of mind throughout development.

Financial Modeling Crash Course with detailed Excel Models

Business Modeling that includes creating a Business Plan and Discounted Cash Flow method with real life case study

Created by FinXcel Academy - Financial Modeling Expert

"]

Students: 105, Price: $24.99

Students: 105, Price:  Paid

This Course covers the financial management topics including business plan and valuation with real life case examples. The course includes building Dynamic Business Models built from scratch with multiples scenarios.

Apart from the concepts, the videos include working knowledge of building of the financial models highlighting the assumptions and formulaes involved

Stock Valuation & Financial Modelling for Stock Investing

Concise and practical stock analysis techniques on relative & absolute valuation methodology use for value investing

Created by Brennen Pak - Chief Trainer

"]

Students: 52, Price: $89.99

Students: 52, Price:  Paid

This course is to help students in stock valuation using both relative valuation as well as absolute valuation techniques.

The course starts with the ratio analysis to get students blend into the course proper. The purpose of ratio analysis is to help students use the appropriate criteria to select the good stocks to buy. This is the first step to stock investing. However, knowing the goods stock to buy or sell is not good enough. The next step is to look into ways to value a stock so that students can buy the selected at the right price. It is no point to buy a good stock at wrong price. Always remember that even if an investor managed to buy a good stock at sky-high price, he may not able to benefit from the investment. Hence, it is important to know some valuation techniques. This is to enable him to buy stocks at the right price. Generally, there are two types of valuation techniques – relative valuation and absolute valuation.

Relative valuation concept: Here, several valuation techniques, such as PE ratio, PBV and PS ratios, were shared. Valuation using these techniques are compared against each other, against industry benchmarks and against time.

Absolute valuation concept: This is where students will be taught on intrinsic valuation, and the various methods to obtain the intrinsic value using financial modelling techniques. The valuation models for this section will be Dividend Discount Model (DDM) and Discounted Cash Flow (DCF).

The course will involve theories and principal concepts, and where to obtain the data to fit into the financial formula. Exercises and financial quizzes to help reinforce the understanding on the key concepts. The course will have many examples to help reinforce the key concepts.

Reviewing Financial Models

Become more confident when reviewing financial models by using the toolkit of techniques covered in this course

Created by Deepa Ramchandani - Financial modelling & training subject matter expert

"]

Students: 40, Price: $99.99

Students: 40, Price:  Paid

This is a financial model review course covering the modules listed below.  It is designed to help participants review models from both a detailed formulae perspective and also by standing back and ‘looking at the big picture’, in order to critically analyse key results.  By implementing the techniques covered, participants should have greater confidence that their models are working as intended.

The course is designed such that:

  • You can work at your own pace and start and stop whenever you need;
  • It takes about half a day to complete and hence can easily fit around your existing schedule;
  • You will take away a comprehensive toolkit of techniques that can be applied to models reviewed in future;
  • The techniques are simple and straightforward to implement, yet their impact can be significant; and
  • You can contact the instructor anytime via email should you need additional support when completing the course.

 

What is included

  • A short video for each module listed below, covering the key concepts and supported by demonstrations in Excel;
  • A detailed slide pack describing the review techniques; and
  • An Excel file containing a practice review exercise, together with the full solution.

Course modules and objectives covered

The course consists of the following modules to be completed in this order:

Module 1: The occurrence of errors

  • Understand the types of errors that can occur in financial models
  • Gain an overview of the techniques available to uncover these errors

Module 2: Using spreadsheet review software

  • Understand what model review software can do
  • Learn which software features can help with different parts of the review process

Module 3: Using Excel’s built in features

  • See which of Excel’s features can be used for reviewing financial models
  • Put some of the features into practice

Module 4: Creating delta views

  • Understand what is meant by a “delta view”
  • View a demonstration of a delta view being set up

Module 5: Checking the financial statements

  • Understand the types of checks that can be performed on a set of financial statements
  • See some examples of these checks

Module 6: Performing analytical reviews

  • Understand what is meant by an “analytical review”
  • Explore the different techniques that may be used as part of the analytical review process

Module 7: Other model review tips

  • Obtain some additional model review tips!

Module 8: Model review case study

  • Consolidate the key lessons learned from the previous modules and perform a review on a sample model

Financial Modeling for Mining

Learn Project Finance Modeling for Natural Resource Projects

Created by Greg Ahuy - Financial Modeler at FMO - Financial Model Online

"]

Students: 16, Price: $149.99

Students: 16, Price:  Paid

Financial Modeling for Mining Course Objective

Financial Modeling for Mining course will give you the skills to develop and analyze project finance models for mining projects. The course covers essential topics including modeling mining operations, debt sizing and funding, and investment returns analysis, and will provide you with a robust financial modeling skillset for analysis of mining projects in the most sophisticated environments.

In an online environment, you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring, and operational scenario evaluation. This course will provide step-by-step instructions on how to build a financial model suitable for analyzing mining projects.

By the end of this course, you will be able to build complex, real-life project finance models for mining projects.

What This Course is About?

Project finance models for mining are used to assess the risk-reward of lending to and investing in mining projects. The project's debt capacity, investment returns, and financial feasibility depend on expected future cash flows generated by the mining project itself and a financial model is built to analyze this.

In the Financial Modeling for Mining course, we will model complex mining project finance transactions from scratch in excel.

You will learn about:

  • How to build a project finance model from scratch in excel for mining projects;

  • Learn how mining projects get developed and financed;

  • How to create best practice macro’s and Excel VBA codes to break circularities;

  • Learn how to size debt based on multiple covenants for mining projects;

  • How to model Debt Service Reserve, Maintenance Reserve, Working Capital, and Asset Retirement Obligation Reserve Accounts;

  • How to model mini-perm debt structure with a refinancing facility;

  • How to account for financing fees during construction and operation;

  • How to incorporate tax and accounting of mining operations into the financial model (asset retirement obligation, the unit of production depreciation method, NOL carry forward expiration etc.);

  • Advanced project finance modeling concepts and accounting (flexible timing, mini-perm debt, refinancing, cash sweep, equity bridge loan);

This is the same comprehensive financial training used to prepare analysts and managers at top financial institutions and infrastructure funds.

How Does It Work?

The course length is over 14 hours.

First, we will review the basics of mining project development, so we understand all essential components of mining operations and project finance transactions in the context of the mining industry.

Then, in the second part, we will review financial modeling methods and excel functions that we will use often in this course, to improve our productivity in Excel.

We will begin financial modeling in the third part, where we will build a financial model for an open-pit gold project.

Is This Course For You?

Yes, if you need to build, review or analyze project finance models for mining projects.

Typical students include analysts, managers, senior managers, associate directors, financial advisors, financiers, and CFOs from project companies, investment banks, private equity, and infrastructure funds.

Course Prerequisites

You will need previous exposure to Excel in a financial modeling context and basic knowledge of investment concepts such as NPV and IRR.