Notes for Week 7
Welcome to Financial Modeling School. In this page you can find the notes for week 7 in the form of PNG files.
Notes for Week 6
Notes for Week 6
Welcome to Financial Modeling School. In this page you can find the notes for week 6 in the form of PNG files.
Introduction to NPV and IRR
Basics of Corporate Finance – Understanding NPV & IRR
- Concept PV & FV
- Concept – NPV
- Concept – IRR
- Case
- Model
- Selecting Constants
- PV Factor
- NPV – Formula
- IRR – Formula
- IRR – Goal Seek
Introduction to Time Value of Money
Basics of Corporate Finance – Time Value of Money
- Concept
- Simple Interest
- Compound Interest
- Excel Implementation
- Scenario Analysis – Data Tables
- Summary
Additional Topic – Credit Risk Model (Part II)
Additional Material – Credit Rating (Part – II), Using Lookup functions
- Recap
- Finding Probabilities
- Using Lookup Function
- Using Index-Match
- Summary
Continue reading “Additional Topic – Credit Risk Model (Part II)”
Additional Topic – Credit Risk Model (Part I)
Additional Material – Credit Rating (Part – I), Using Excel Arrays
- Problem Statement and Context
- matrix Multiplication in Excel
- 2 Year Rating Transition Matrix
Continue reading “Additional Topic – Credit Risk Model (Part I)”
Integrated Valuation Model – Ratios (Other)
Integrated Valuation Model – Step XI (C) (Analyzing Financial Statements – Other Ratios)
- Recap
- Implementing Other Rations
- Summary
Continue reading “Integrated Valuation Model – Ratios (Other)”
Integrated Valuation Model – Ratios (Liquidity)
Integrated Valuation Model – Step XI (b) (Analyzing Financial Statements – Liquidity Ratios)
- Recap
- Concepts
- Examples
- Implementing Liquidity Rations
- Examples
- Implementing Leverage Rations
- Summary
Continue reading “Integrated Valuation Model – Ratios (Liquidity)”
Integrated Valuation Model – Ratios (Profitability)
Integrated Valuation Model – Step XI (a) (Analyzing Financial Statements – Profitability Ratios)
- Conceptual Understanding
- Examples
- Implementing Profitability Rations
- Implementing Return Rations
Continue reading “Integrated Valuation Model – Ratios (Profitability)”
Steps in Creating an Integrated Financial Model – Statements to Analysis
Integrated Valuation Model – Depicting Steps to create Integrated Financial Model
- Steps Completed Till Now
- Steps Moving Forward
Continue reading “Steps in Creating an Integrated Financial Model – Statements to Analysis”
Notes for Week 5
Notes for Week 5
Welcome to Financial Modeling School. In this page you can find the notes for week 5 in the form of PNG files.
Additional Topic – Breaking Circular Reference with Macro
(Optional) Additional Topic – Breaking Circular Reference with Macro
- Introduction
- Concept
- Recording a Macro
- Editing
- Using the Macro
- Limitation
Continue reading “Additional Topic – Breaking Circular Reference with Macro”
Additional Topic – Charting with Macros
(Optional) Additional Topic – Charting Using Macros
- Recap
- Custom Charting using Macros
- Recording
- Editing
- Using
- Using with Graphical Interface
Additional Topic – Understanding Macros
(Optional) Additional Topic – Understanding Macros
- Enabling Macros
- Conceptual Understanding
- Recording a Macro
- Running a Macro
- Eding a Macro
Integrated Valuation Model – Updating Interest using Circular Reference
Integrated Valuation Model – Step X (Updating Interest using Circular Reference)
- Recap
- Updating Interest on Cash
- Updating Interst Expense in P&L
- Updating B/S
- Summary
Continue reading “Integrated Valuation Model – Updating Interest using Circular Reference”
Circular References to Update Interest Expense
Using Excel Circular References to Update Interest Expense
- Recap
- Case
- Conceptual Understanding
- Model Implementation – Debt Schedule
- Model Implementation – P&L
- Model Implementation – BS
- Beware
- Breaking Circular loops
- Summary
Continue reading “Circular References to Update Interest Expense”
Understanding Circular References in Excel
Understanding Circular References in Excel
- Case
- Building Layout
- Data Validation
- Building Model
- Circular Reference
- Conceptual Understanding
- Enabling circular references
- Checks
- Beware
- Breaking Circular loops
- Summary
Continue reading “Understanding Circular References in Excel”
Notes for Week 4
Notes for Week 4
Welcome to Financial Modeling School. In this page you can find the notes for week 4 in the form of PNG files.
Modeling Cash Flow Statement
Integrated Valuation Model – Step IX (Creating the Cash Flow statement)
- Recap
- Connection in Financial Statements
- Cash Flow statement
- Modeling Operating Cash
- Cash from Investing
- Cash from Financing
- Building checks
- Linking Cash in B/S
- Summary
Financial Glossary
Basic Financial terminology (Glossary)
- Important terms used in finance