### 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

Welcome to Financial Modeling School. In this page you can find the notes for week 6 in the form of PNG files.

### 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

### Basics of Corporate Finance – Time Value of Money

• Concept
• Simple Interest
• Compound Interest
• Excel Implementation
• Scenario Analysis – Data Tables
• Summary

### Additional Material – Credit Rating (Part – II), Using Lookup functions

• Recap
• Finding Probabilities
• Using Lookup Function
• Using Index-Match
• Summary

### Additional Material – Credit Rating (Part – I), Using Excel Arrays

• Problem Statement and Context
• matrix Multiplication in Excel
• 2 Year Rating Transition Matrix

### Integrated Valuation Model – Step XI (C) (Analyzing Financial Statements – Other Ratios)

• Recap
• Implementing Other Rations
• Summary

### Integrated Valuation Model – Step XI (b) (Analyzing Financial Statements – Liquidity Ratios)

• Recap
• Concepts
• Examples
• Implementing Liquidity Rations
• Examples
• Implementing Leverage Rations
• Summary

### Integrated Valuation Model – Step XI (a) (Analyzing Financial Statements – Profitability Ratios)

• Conceptual Understanding
• Examples
• Implementing Profitability Rations
• Implementing Return Rations

### Integrated Valuation Model – Depicting Steps to create Integrated Financial Model

• Steps Completed Till Now
• Steps Moving Forward

### 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.

### (Optional) Additional Topic – Breaking Circular Reference with Macro

• Introduction
• Concept
• Recording a Macro
• Editing
• Using the Macro
• Limitation

### (Optional) Additional Topic – Charting Using Macros

• Recap
• Custom Charting using Macros
• Recording
• Editing
• Using
• Using with Graphical Interface

### (Optional) Additional Topic – Understanding Macros

• Enabling Macros
• Conceptual Understanding
• Recording a Macro
• Running a Macro
• Eding a Macro

### 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

### 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

### 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

### 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.

### 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