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
- 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.
- 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.
- 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.
- 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
- Capital Expenditure and Depreciation: An asset register, useful lives, part year depreciation and disposals. Activity: Add a five asset register to the model.
- 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.
- 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.
- 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
- 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.
- 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.
- 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.
- 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
Every session includes practical exercises you can apply at work.
Courses come from accredited Malaysian training providers.
See the full price per learner before you enquire.
Every listing shows whether the course is HRD Corp claimable.
Session Schedule
| Start date | Mode | Location | Seats | Price |
|---|---|---|---|---|
| 9 Dec 2026 | In-person | Shah Alam | 18 | RM 1,950 |