Financial Modelling in Excel Workshop

Partner: Udemy
Affiliate Name:
Area:
Description: Welcome to our financial modelling course! In this course, we will cover the essential skills and techniques needed to build accurate financial models using Microsoft Excel.In the first session, we will start with an introduction to financial modelling and explain its importance in the business world. We will also explore the various applications of MS Excel in financial modelling, as well as basic functions and formulas in Excel that are necessary for building financial models.In session two, we will cover the techniques for collecting financial data and how to analyze it using MS Excel. You will also learn how to create tables and charts in Excel to help you better visualize and understand your data.Session three will focus on building a financial model framework, including creating a financial model template and linking worksheets to create dynamic models. You will also learn best practices in financial modelling.We will then move on to session four, where we will cover how to project financial statements using Excel. You will learn how to build a model to project income statement, balance sheet, and cash flow statement, as well as perform sensitivity analysis.In session five, we will cover investment analysis using financial models. You will learn how to evaluate investment opportunities and build a model to calculate key investment metrics such as NPV, IRR, and payback period. We will also cover sensitivity analysis for investment decisions.Session six will explore valuation techniques, including an overview of different techniques and how to build a model to perform discounted cash flow (DCF) valuation. We will also cover sensitivity analysis for DCF valuation.In session seven, we will cover techniques for scenario analysis and stress testing. You will learn how to build a model to perform scenario analysis and stress testing and understand the impact of changing assumptions on financial models.In session eight, we will cover advanced Excel function
Category: Finance & Accounting > Accounting & Bookkeeping > Accounting
Partner ID:
Price: 29.99
Commission:
Source: Impact
Go to Course