Integrated Valuation Model – Step VIII (Creating Financing Schedule)
- Recap
- Conceptual Understanding
- Debt Schedule
- BASE rule
- Interest
- Equity Schedule
- Updating B/S
- Updating P&L
- Summary
Asset Schedule
Integrated Valuation Model – Step VII (Creating Asset Schedule)
- Recap
- Items to be updated in P&L and B/S
- Capex
- Depreciation
- Updating B/S
- Updating P&L
- Summary
Projecting BS
Integrated Valuation Model – Step VI (Projecting Balance Sheet)
- Recap
- Projecting Inventory
- Projecting Accounts Receivables
- Projecting Current Assets
- Projecting Current Liabilities
- Summary
Projecting PL
Integrated Valuation Model – Step V (Projecting P&L)
- Recap
- Projecting P&L
- Projecting Revenues
- Projecting Costs
- Linking P&L
- Summary
Break Even Analysis
Additional Material – Break Even Analysis
- Basic fundamental behind breakeven analysis
- Model creation steps
- Templates
In this post, I have posted three simple slides on break even analysis. These slides explain the fundamental concept behind break even analysis.
Also included on the post is an unfilled template and a filled one, to see how breakeven analysis can be done.
This is part of extra material (Optional).
Notes for Week 3
Notes for Week 3
Welcome to Financial Modeling School. In this page you can find the notes for week 3 in the form of PNG files.
Other Cost buildup
Integrated Valuation Model – Step V (b) (Other Costs buildup)
- Recap
- Employee Cost
- Packaging Cost
- Total Cost
- Summary and Way forward
Raw Material Cost Buildup
Integrated Valuation Model – Step V (a) (Raw Material Cost buildup)
- Recap
- Raw Material Volume Concept
- Raw Material Volume in Model
- Unit Conversion for RM Cost
- RM Cost in USD Mn
- Summary
Revenue Buildup
Integrated Valuation Model – Step IV (Revenue buildup)
- Recap
- Revenue Buildup
- Model Implementation
Building Assumptions Numbers
Integrated Valuation Model – Step III (b) (Building Assumptions Numbers)
- Recap
- Building Assumptions in Numbers
- Concept
- Revenue Assumptions
- Cost Assumptions
- Summary
Building B/S Assumptions
Integrated Valuation Model – Step III (b) (Building Assumptions for Balance Sheet)
- Recap
- Manpower Cost
- Packaging
- Selling Cost
- Balance Sheet Assumptions
- Summary
Building P&L Assumptions
Integrated Valuation Model – Step III (a) (Building Assumptions for P&L)
- Recap
- Making Assumptions
- Revenue Assumptions
- Cost Assumptions (RM)
- Summary
Balance Sheet Drivers
Integrated Valuation Model – Step II (c) (Balance Sheet Drivers)
- Recap
- BS Drivers
- Days of Inventory
- Implementing Drivers in Model
- Other Similar Drivers
- Implementing Other drivers in Model
- Summary
Cost Drivers
Integrated Valuation Model – Step II (b) (Cost Drivers)
- Review of Revenue Drivers
- Cost Drivers
- Raw Material
- Manpower Cost
- Other Costs
- Sales Cost
- Summary
Revenue Drivers
Integrated Valuation Model – Step II (a) (Revenue Drivers)
- Overview of work till now
- Overview of Drivers
- Overview of P&L Drivers
- Revenue Drivers
Notes for week 2
Notes for Week 2
Welcome to Financial Modeling School. In this page you can find the notes for week 2 in the form of PNG files.
Complete Material for FM School
Complete Material for FM School
Welcome to Financial Modeling School. In this page you can find the complete course material in the form of presentation. The presentation covers the conceptual part as well as the important steps in creation of an integrated valuation model.
Integrated Valuation Model – Historical Statement (BS)
Integrated Valuation Model – Step I (Historical P&L)
- Introduction
- Historical Sources of Funds
- Historical Uses of Funds
- Check
- Summarization
Continue reading “Integrated Valuation Model – Historical Statement (BS)”
Integrated Valuation Model – Historical Statement (P&L)
Integrated Valuation Model – Step I (Historical P&L)
- Introduction
- Template for Historical P&L
- Linking Historical P&L
- Understanding P&L
- Linking Remaining P&L
- Summarization
Continue reading “Integrated Valuation Model – Historical Statement (P&L)”
Understanding Integrated Valuation Case
Understanding Integrated Valuation Model Case
- Introduction to case
- Product Mix
- Market
- Competitive Landscape
- Market Sizing
- Growth and Competition
- Raw Material
- Manpower
- Uses of Funds
- Summarization