Free testing period: everything is free while we test. Try it out and tell us what you think.
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

  • 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
View bundle

Student reviews

New (0)

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
Feedback