Financial Modeling Foundations
4.4 /5- Offered byLinkedin Learning
Financial Modeling Foundations at Linkedin Learning Overview
Duration | 3 hours |
Total fee | ₹899 |
Mode of learning | Online |
Credential | Certificate |
Financial Modeling Foundations at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Financial Modeling Foundations at Linkedin Learning Course details
- In this course, learn how to build financial models that can be used in corporate finance, investment banking, commercial banking, and portfolio management
- Professor Michael McDonald covers financial statement models, investment banking models, M&A models, buyout models, and DCF models—all using Microsoft Excel
- Throughout the course, Michael includes exercises—together with downloadable exercise files—that can provide you with a practical understanding of these key topics
- By distilling key information regarding cash flow levels and risks, financial modeling helps decision-makers make informed choices based on data analytics that move their firms forward
Financial Modeling Foundations at Linkedin Learning Curriculum
Introduction
Using Excel for financial modeling
What you should know before watching this course
Financial Modeling Basics
What is financial modeling?
Why is financial modeling important?
Business questions and financial models
Data for a model
Sources of data
Gathering data from FRED for Excel
Getting started with the project
Excel tips for financial modeling
Corporate Financial Modeling: Three-Statement Financial Model
Foundations of the model
Linking financial statements
Three-statement financial model
Setting source parameters
Assumptions in financial statements
Forecasting in financial statements
Putting it all together
Improving model quality
Evaluating Corporate Financial Models: Three-Statement Model
Financial modeling strategies
Sensitivity analysis and financial models
Adding visuals to a financial model
Investment Models: DCF Model
Financial valuation models
Cash flows in the valuation model
Terminal value in a valuation model
Interpreting a DCF model
Banking Models
Beyond the basics in financial models
Corkscrews and models
Waterfalls and models
Adding toggles to a financial model
Model outputs
Hiding tabs and making models readable
Stress testing models
Buyout Models
Interest rate assumptions in models
Discount rates in models
Top-down financial models
Bottom-up financial models
IRR decisions in financial models
NPV decisions in financial models
Limits of financial models
Financial Modeling across Industries
Characteristics of financial models
Modeling in banking
Modeling in corporate finance
Modeling in investments
Building and Maintaining Models
Applications of financial models
Bitcoin and cryptocurrency valuation modeling
Updating financial models
Maintaining ongoing financial models
Conclusion
Next steps
Financial Modeling Foundations at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?