Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Excel Basics
·
Module 8
Financial Modeling Fundamentals
1
Structuring Your Financial Model
Design the structure for a financial model with separate sections for assumptions, calculations, and outputs.
2
Forecasting Revenue and Expenses with Assumptions
Build revenue and expense forecasts linked to a dedicated assumptions section.
3
Calculating Profit Metrics
Consolidate projections to calculate key profit metrics such as Gross Profit and Net Income.
4
TVM Functions for Loan and Investment Analysis
Use time value of money functions (PMT, PV, FV) to analyze loans and investments.
5
Capital Budgeting: NPV & IRR for Project Profitability
Use capital budgeting functions (NPV, IRR) to evaluate project profitability.
6
Loan Amortization Schedule Creation
Create a loan amortization schedule.
7
Sensitivity Analysis with Data Tables
Perform sensitivity analysis using one-variable and two-variable Data Tables.
8
Optimizing with Goal Seek and Solver
Use Goal Seek and Solver to find optimal solutions for target values.
Previous module
Data Visualization and Interactive Dashboards
Next module
Introduction to Macros and VBA