Skip to content
IndividualsEmployersGovernmentHRDC ClaimableAdminENMY
JSJS AcademyFinancial Modelling in Excel
IntermediateEnglish

Financial Modelling in Excel

For analysts and finance staff who build spreadsheets other people rely on for decisions. You will construct a three statement model from a blank sheet, add scenarios and checks, and adopt layout habits that keep a model usable six months after it was built.

JS Academy
Finance & Accounting · 21 hours of training
New0 learners enrolled

About This Course

Who this is for

Analysts, planning and finance staff, corporate development executives and business owners who build their own projections. Participants should already be comfortable with formulas, absolute references and basic spreadsheet navigation, because the course spends its time on structure and integration rather than on teaching Excel from the beginning.

What you will learn

  • Set up a model layout that separates inputs, calculations and outputs
  • Build integrated profit, balance sheet and cash flow projections
  • Model debt and interest without breaking the file
  • Add scenario switches and sensitivity tables that recalculate cleanly
  • Build error checks and an audit trail another user can follow
  • Review someone else's model and name its weak points

Course outline

Day 1

  1. Model Design Rules: Sheet structure, time across columns, one formula pattern per row, and colour conventions that survive a handover. Activity: Rebuild a messy model into a clean layout.
  2. Inputs and Assumptions: Structuring an assumption sheet, units, rounding, and validation of input cells so a wrong key does not flow into the outputs. Activity: Create an assumption sheet for a distribution business.
  3. Revenue and Cost Drivers: Volume, price and mix builds, with a reconciliation back to historical results before any forecast is trusted. Activity: Build revenue for three product lines over twenty four months.
  4. Working Capital: Receivable, payable and inventory days applied monthly, including the treatment of opening balances. Activity: Model working capital for a growing wholesaler.

Day 2

  1. Capital Expenditure and Depreciation: An asset register, useful lives, part year depreciation and disposals. Activity: Add a five asset register to the model.
  2. Debt and Interest: Drawdown, repayment profiles, interest on an average balance, and how to avoid circular references that lock the file. Activity: Model a term loan with a two year drawdown period.
  3. Tax and Carried Forward Losses: Tax computation in the model, brought forward losses, and the practical limit of modelling tax detail. Activity: Add a simple tax schedule with loss carry forward.
  4. Building the Statements: Linking profit, balance sheet and cash flow so the balance sheet balances in every column. Activity: Complete the three statements and clear every check flag.

Day 3

  1. Scenarios and Switches: Choice cells, index and choose functions, and keeping scenario logic out of the core calculations. Activity: Add base, downside and upside cases to the model.
  2. Sensitivity and Outputs: One way and two way data tables, an output dashboard, and charts that answer a specific question. Activity: Build a sensitivity table on price and volume.
  3. Checks and Model Review: Balance checks, cash floor tests, formula consistency, and a review checklist for inherited files. Activity: Review a supplied model and log ten findings.
  4. Documentation and Handover: A cover sheet, version notes, formula comments and the questions a successor will ask. Activity: Document your own model and hand it to a partner for a five minute test.

Assessment

A completed three statement model with scenarios and checks, a model review log, and a short handover presentation. Files are marked on structure and error rate as well as on the final numbers.

Prerequisites

Confident spreadsheet use: formulas, absolute references, if statements and basic charts. No macros or programming experience is needed.

Why Take This Course

Hands-on Learning

Every session includes practical exercises you can apply at work.

Accredited Providers

Courses come from accredited Malaysian training providers.

Transparent Pricing

See the full price per learner before you enquire.

HRD Corp Status

Every listing shows whether the course is HRD Corp claimable.

Session Schedule

Start dateModeLocationSeatsPrice
9 Dec 2026In-personShah Alam18RM 1,950

Student reviews

No reviews yet.

Frequently asked questions

Which spreadsheet version is used in the session?

The exercises run in a standard desktop spreadsheet application available on the training machines. Functions used are long established ones, so the work transfers to any recent version without adjustment.

Do I need to know macros or Power Query?

No. Everything is built with ordinary formulas and tables. Automation is useful for data import, but it is deliberately excluded so the model logic stays visible to a reviewer.

Can I bring my own model to review?

Yes, and the final module is the best place for it. Remove confidential figures before the session, and the review checklist can be applied to your file during the workshop.