May 4, 2023
HomeVideo TutorialsOther TutorialsFinancial Modeling In Excel – Dcf Model Of Big Books Corp

Financial Modeling In Excel – Dcf Model Of Big Books Corp

By  Other Tutorials  0 Comments

Published 4/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.75 GB | Duration: 8h 39m
Learn Financial Analysis, DCF Valuation and Financial Modeling of Big Books Corp. from scratch


Free Download What you’ll learn
Discounted Cash Flow (DCF) Modelling
You Shall Understand valuation Techniques Right From Scratch on a Financial Model.
Learn model construction, assumptions, advanced excel functionality, error trapping, sensitivity analysis, presentation of model output, and pro tips and tricks
This Course Gives a Brief idea about the Revenue and Cost Drivers, Forecasting the Future Financials and the Stock Price Recommendation.
Become a successful Financial Analyst
Excel shortcuts, Formulas, Formatting and Number Formatting
This Training is Dedicated to Learning about this most commonly used DCF Valuation Techniques.
Requirements
You will need Microsoft Excel 2010, 2013, 2016, 2019 or Excel 365
Description
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). Financial modeling involves designing and building calculations to assist in decision-making. Learning how to build models with complexity in an accurate, robust, and transparent way is an essential skill in the modern workplace. The goal isn’t to teach you how to memorize Excel Models but to actually learn the skills to generate your own reports with a clear idea of how to structure a financial report so it has maximum flexibility. And by the end of this course, you will learn how to build effective, robust, flexible financial models. In this you will learn the following:Valuations in detailsFinancial Modeling where in we will study in details the balance sheet, income statements, cash flow, projections etc along with the financial model in practical.
Overview
Section 1: Introduction
Lecture 1 Overview of Big Books Corp
Section 2: Revenue & Cost Projections
Lecture 2 Segment Wise Revenue Calculations
Lecture 3 Revenue Forecasting – Notebook Segment
Lecture 4 Purpose of Buiding a Financial Model
Lecture 5 Calculating the Total Revenue from All Segments
Lecture 6 Calculating Cost of Sales
Lecture 7 Calculating SG and A Expenses
Lecture 8 Linking Revenue and Expenses
Section 3: Depreciation & Amortization Schedule
Lecture 9 Depreciation and Gross PPE
Lecture 10 Understanding Capital Expenditure
Lecture 11 Calculating Segment wise Capex
Lecture 12 Depreciation Inputs
Lecture 13 Depreciation Calculation – Machinery and Equipments
Lecture 14 Depreciation Calculations Continued
Lecture 15 Amortization Calculations
Lecture 16 Linking Depreciation and Amortization
Lecture 17 Building the Cash Flow Statement
Section 4: Working Capital Schedule
Lecture 18 Understanding Working Capital
Lecture 19 Linking the Historical Working Capital Balances
Lecture 20 What is Cash Conversion Cycle
Lecture 21 Projecting Working Capital Balances
Lecture 22 Increase and Decrease in Working Capital
Section 5: Equity & Debt Schedule
Lecture 23 Share Repurchase Forecast
Lecture 24 Share Repurchase Forecast Continued
Lecture 25 Shares Outstanding
Lecture 26 Other Assets and Liabilities
Lecture 27 Forecasting Debt
Lecture 28 Interest Expense and Interest Income
Lecture 29 Completing the Missing Links
Lecture 30 Checking the Dashboard
Section 6: DCF Valuation
Lecture 31 DCF Analysis Overview
Lecture 32 Free Cash Flow to the Firm
Lecture 33 Free Cash Flow to the Firm Continued
Lecture 34 Free Cash Flow to the Firm- Backward Calculation
Lecture 35 Free Cash Flow to Equity
Lecture 36 Net Operating Profit After Tax
Lecture 37 Complete Equity Business
Lecture 38 Building the DCF Model
Lecture 39 Risk-free Rate and Beta
Lecture 40 Cost of Capital Calculation
Lecture 41 WACC Calculation
Lecture 42 Beta Calculation
Lecture 43 Understanding the WACC Concept
Lecture 44 NPV of Explicit Period
Lecture 45 Enterprise Value
Lecture 46 Share Price- Forecast 1 and 2
Lecture 47 Share Price- Forecast 1 and 2 Continued
Section 7: Relative Valuation
Lecture 48 Relative Valuation
Lecture 49 EV to Revenue
Lecture 50 EV to EBITDA
Working Professionals,Professionals who want to pursue a career in the Finance industry,Anyone who wants to learn financial modeling and report writing,Students pursuing Degree, Diploma, Engineering and commerce who want to make a career in finance market.

Homepage

https://www.udemy.com/course/financial-modeling-in-excel-dcf-model-of-big-books-inc/
Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me

Links are Interchangeable – Single Extraction

Tags:, , , ,

Related Posts

About Author

Frankie

Add a Comment

Your email address will not be published. Required fields are marked *