Accounting Practicals
Financial Modeling in Excel (After Excel Zero to Hero)
Time value of money, investment appraisal and a three-year forecast with scenarios - for people who already know Excel.
New (0 ratings)
2 students
Intermediate
English
Created by JMatrix Learn
About this course
A step-by-step workshop on the financial side of Excel, built for people who are already comfortable with formulas, absolute references, SUMIFS and lookups. You start with loan, savings and depreciation functions and project appraisal with NPV and IRR, then build a three-year forecast with profit and loss, cash flow and a balance sheet that checks itself, with a scenario selector, a sensitivity test and a dashboard. Every lesson shows the expected results so you can check your own work.
What you'll learn
Use PMT, PV, FV, NPER, RATE, NPV, IRR, XNPV, XIRR and depreciation functions correctly, including the NPV time-zero trap
Build a three-year forecast with profit and loss, cash flow and a balance sheet that proves it balances
Switch between best, base and worst cases with one drop-down
Run sensitivity tests and explain which assumption matters most
Present the results on a clean dashboard
Curriculum
9 lessons · 265 minutes total
- Loans and Savings: PMT, PV, FV, NPER and RATE Preview 30 min
- Investment Appraisal: NPV, IRR, XNPV and XIRR 30 min
- Depreciation Functions: SLN, DB and DDB 30 min
- Practical Lab - Loan Schedule, Project Appraisal and Depreciation 40 min
- Module 1: Time Value of Money and Financial Functions — Quiz 10 min
- Loan, appraisal and depreciation pack
- A Three-Year Forecast Model and Dashboard 35 min
- Scenarios and Stress Tests: Best, Base and Worst Case 35 min
- Practical Lab - Build, Break and Present the Forecast 45 min
- Module 2: Building a Forecast Model You Can Defend — Quiz 10 min
- A three-year forecast with scenarios and a dashboard
Requirements
- Finish the Excel for Accountants: Zero to Hero course first, or be comfortable with relative and absolute references, SUMIFS, IF and lookups
- A computer with Microsoft Excel (365, 2021, 2019 or 2016)
- Basic accounting vocabulary: profit, cash, assets, equity, depreciation
Also available in a bundle
Practical Accounting Skills
Save 0% buying all 4 courses together
Student reviews
New (0)No reviews yet — be the first to share your experience.
Related courses
Accounting Practicals
FREE
Live classes for this course
Ask the tutor for a live class
- Full lifetime access
- Access on mobile and desktop
- Learn by doing: written lessons, quizzes and hands-on practice (video lessons coming soon)
- Instructor Q&A on every lesson