Financial Modeling In Excel - Dcf Model Of Big Books Corp

Learn Financial Analysis, DCF Valuation and Financial Modeling of Big Books Corp. from scratch

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.