Level
Level 5
Credits
120
Guided Learning
240
Total Qualification Time
1200
Qualification overview
A simple summary of who this qualification is for and what learners can expect.
About this qualification
The Level 5 Diploma in Financial Modelling & Business Forecasting is an IQ Awards qualification at Level 5. It supports learners in developing knowledge, practical skills and professional behaviours in accounting & finance.
The qualification is structured for clear delivery, assessment and quality assurance through approved centres.
Who is it for?
- Learners with prior study, training or work experience who want to develop specialist knowledge.
- Professionals seeking career progression or a recognised route into higher-level study.
- Centres delivering practical, work-related learning for local or international learners.
Entry and assessment guidance
Centres should check learner suitability before registration.
Entry requirements
- Entry is at the discretion of the approved centre.
- Learners will normally hold a qualification at the previous level or have relevant work experience.
- Learners should be able to research, analyse and apply concepts within accounting & finance.
- Centres should confirm that learners have sufficient English language ability for higher-level study.
Assessment approach
Assessment may include assignments, projects, practical evidence, workplace evidence, portfolios, presentations or other centre-devised assessment methods approved under IQ Awards quality assurance.
Language requirements
Centres should ensure learners have sufficient language competency to complete learning and assessment.
Qualification units
Jump to any unit below. Each unit opens with its own learning outcomes, criteria and content where available.
Unit 1 of 8
Spreadsheet Model Architecture and Governance
FMBF501
Learning outcomes
- LO1: Critically analyse model purpose, structure and design standards.
- LO2: Evaluate alternative approaches to inputs, calculations, outputs, controls and documentation in relevant vocational or organisational contexts.
- LO3: Integrate construction of a transparent governed model to produce a controlled spreadsheet model and governance file.
- LO4: Critically review model error risk, usability and review findings and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in model purpose, structure and design standards.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting model purpose, structure and design standards.
- 2.1 Evaluate the quality and relevance of evidence for inputs, calculations, outputs, controls and documentation.
- 2.2 Compare alternative methods or responses to inputs, calculations, outputs, controls and documentation.
- 3.1 Develop a controlled spreadsheet model and governance file that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in spreadsheet model architecture and governance. It focuses on model purpose, structure and design standards, inputs, calculations, outputs, controls and documentation, construction of a transparent governed model, model error risk, usability and review findings. Learners will use appropriate evidence and methods to produce a controlled spreadsheet model and governance file, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: model purpose, structure and design standards.
- Analysis and context: inputs, calculations, outputs, controls and documentation.
- Applied methods: construction of a transparent governed model.
- Evaluation and improvement: model error risk, usability and review findings.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Spreadsheet Model Architecture and Governance - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to model purpose, structure and design standards and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to inputs, calculations, outputs, controls and documentation. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce a controlled spreadsheet model and governance file. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to model error risk, usability and review findings. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Practical evidence: include direct observation or realistic simulation, an assessor observation record, the learner's working documents and a reflective account. Unsafe, unauthorised or unsupervised activity must not be assessed.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Unit 2 of 8
Financial Statement Analysis and Business Drivers
FMBF502
Learning outcomes
- LO1: Critically analyse financial statements, ratios and quality of earnings.
- LO2: Evaluate alternative approaches to operational value drivers and historical trend analysis in relevant vocational or organisational contexts.
- LO3: Integrate driver-based analytical model development to produce a driver-based financial analysis workbook and report.
- LO4: Critically review performance causes and forecast implications and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in financial statements, ratios and quality of earnings.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting financial statements, ratios and quality of earnings.
- 2.1 Evaluate the quality and relevance of evidence for operational value drivers and historical trend analysis.
- 2.2 Compare alternative methods or responses to operational value drivers and historical trend analysis.
- 3.1 Develop a driver-based financial analysis workbook and report that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in financial statement analysis and business drivers. It focuses on financial statements, ratios and quality of earnings, operational value drivers and historical trend analysis, driver-based analytical model development, performance causes and forecast implications. Learners will use appropriate evidence and methods to produce a driver-based financial analysis workbook and report, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: financial statements, ratios and quality of earnings.
- Analysis and context: operational value drivers and historical trend analysis.
- Applied methods: driver-based analytical model development.
- Evaluation and improvement: performance causes and forecast implications.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Financial Statement Analysis and Business Drivers - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to financial statements, ratios and quality of earnings and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to operational value drivers and historical trend analysis. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce a driver-based financial analysis workbook and report. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to performance causes and forecast implications. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Unit 3 of 8
Integrated Three-Statement Modelling
FMBF503
Learning outcomes
- LO1: Critically analyse income statement, balance sheet and cash-flow linkages.
- LO2: Evaluate alternative approaches to forecast schedules, circularity and balancing controls in relevant vocational or organisational contexts.
- LO3: Integrate integrated three-statement model construction to produce an integrated three-statement financial model.
- LO4: Critically review model integrity and forecast reasonableness and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in income statement, balance sheet and cash-flow linkages.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting income statement, balance sheet and cash-flow linkages.
- 2.1 Evaluate the quality and relevance of evidence for forecast schedules, circularity and balancing controls.
- 2.2 Compare alternative methods or responses to forecast schedules, circularity and balancing controls.
- 3.1 Develop an integrated three-statement financial model that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in integrated three-statement modelling. It focuses on income statement, balance sheet and cash-flow linkages, forecast schedules, circularity and balancing controls, integrated three-statement model construction, model integrity and forecast reasonableness. Learners will use appropriate evidence and methods to produce an integrated three-statement financial model, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: income statement, balance sheet and cash-flow linkages.
- Analysis and context: forecast schedules, circularity and balancing controls.
- Applied methods: integrated three-statement model construction.
- Evaluation and improvement: model integrity and forecast reasonableness.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Integrated Three-Statement Modelling - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to income statement, balance sheet and cash-flow linkages and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to forecast schedules, circularity and balancing controls. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce an integrated three-statement financial model. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to model integrity and forecast reasonableness. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Practical evidence: include direct observation or realistic simulation, an assessor observation record, the learner's working documents and a reflective account. Unsafe, unauthorised or unsupervised activity must not be assessed.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Unit 4 of 8
Budgeting, Rolling Forecasts and Scenario Planning
FMBF504
Learning outcomes
- LO1: Critically analyse planning cycles, assumptions and forecast governance.
- LO2: Evaluate alternative approaches to rolling forecasts, scenarios and operational drivers in relevant vocational or organisational contexts.
- LO3: Integrate development of a dynamic planning model to produce a rolling forecast and scenario-planning model.
- LO4: Critically review forecast performance and scenario implications and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in planning cycles, assumptions and forecast governance.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting planning cycles, assumptions and forecast governance.
- 2.1 Evaluate the quality and relevance of evidence for rolling forecasts, scenarios and operational drivers.
- 2.2 Compare alternative methods or responses to rolling forecasts, scenarios and operational drivers.
- 3.1 Develop a rolling forecast and scenario-planning model that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in budgeting, rolling forecasts and scenario planning. It focuses on planning cycles, assumptions and forecast governance, rolling forecasts, scenarios and operational drivers, development of a dynamic planning model, forecast performance and scenario implications. Learners will use appropriate evidence and methods to produce a rolling forecast and scenario-planning model, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: planning cycles, assumptions and forecast governance.
- Analysis and context: rolling forecasts, scenarios and operational drivers.
- Applied methods: development of a dynamic planning model.
- Evaluation and improvement: forecast performance and scenario implications.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Budgeting, Rolling Forecasts and Scenario Planning - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to planning cycles, assumptions and forecast governance and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to rolling forecasts, scenarios and operational drivers. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce a rolling forecast and scenario-planning model. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to forecast performance and scenario implications. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Unit 5 of 8
Valuation and Investment Appraisal Models
FMBF505
Learning outcomes
- LO1: Critically analyse discounted cash flow, multiples and investment criteria.
- LO2: Evaluate alternative approaches to cash-flow estimation, discount rates and terminal value in relevant vocational or organisational contexts.
- LO3: Integrate valuation and capital-investment model construction to produce a valuation and investment-appraisal model.
- LO4: Critically review valuation range, limitations and recommendation and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in discounted cash flow, multiples and investment criteria.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting discounted cash flow, multiples and investment criteria.
- 2.1 Evaluate the quality and relevance of evidence for cash-flow estimation, discount rates and terminal value.
- 2.2 Compare alternative methods or responses to cash-flow estimation, discount rates and terminal value.
- 3.1 Develop a valuation and investment-appraisal model that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in valuation and investment appraisal models. It focuses on discounted cash flow, multiples and investment criteria, cash-flow estimation, discount rates and terminal value, valuation and capital-investment model construction, valuation range, limitations and recommendation. Learners will use appropriate evidence and methods to produce a valuation and investment-appraisal model, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: discounted cash flow, multiples and investment criteria.
- Analysis and context: cash-flow estimation, discount rates and terminal value.
- Applied methods: valuation and capital-investment model construction.
- Evaluation and improvement: valuation range, limitations and recommendation.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Valuation and Investment Appraisal Models - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to discounted cash flow, multiples and investment criteria and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to cash-flow estimation, discount rates and terminal value. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce a valuation and investment-appraisal model. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to valuation range, limitations and recommendation. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Unit 6 of 8
Risk, Sensitivity, Simulation and Stress Testing
FMBF506
Learning outcomes
- LO1: Critically analyse financial uncertainty, risk variables and dependencies.
- LO2: Evaluate alternative approaches to sensitivity, scenario, break-even and simulation concepts in relevant vocational or organisational contexts.
- LO3: Integrate design of stress tests and risk outputs to produce a model risk and stress-testing report.
- LO4: Critically review risk exposure and management response and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in financial uncertainty, risk variables and dependencies.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting financial uncertainty, risk variables and dependencies.
- 2.1 Evaluate the quality and relevance of evidence for sensitivity, scenario, break-even and simulation concepts.
- 2.2 Compare alternative methods or responses to sensitivity, scenario, break-even and simulation concepts.
- 3.1 Develop a model risk and stress-testing report that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in risk, sensitivity, simulation and stress testing. It focuses on financial uncertainty, risk variables and dependencies, sensitivity, scenario, break-even and simulation concepts, design of stress tests and risk outputs, risk exposure and management response. Learners will use appropriate evidence and methods to produce a model risk and stress-testing report, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: financial uncertainty, risk variables and dependencies.
- Analysis and context: sensitivity, scenario, break-even and simulation concepts.
- Applied methods: design of stress tests and risk outputs.
- Evaluation and improvement: risk exposure and management response.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Risk, Sensitivity, Simulation and Stress Testing - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to financial uncertainty, risk variables and dependencies and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to sensitivity, scenario, break-even and simulation concepts. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce a model risk and stress-testing report. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to risk exposure and management response. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Unit 7 of 8
Business Intelligence and Forecast Communication
FMBF507
Learning outcomes
- LO1: Critically analyse decision-focused metrics and visualisation principles.
- LO2: Evaluate alternative approaches to dashboard design, narrative and stakeholder communication in relevant vocational or organisational contexts.
- LO3: Integrate production of forecast dashboards and executive insight to produce a board-level forecast dashboard and briefing.
- LO4: Critically review clarity, bias, accessibility and decision impact and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in decision-focused metrics and visualisation principles.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting decision-focused metrics and visualisation principles.
- 2.1 Evaluate the quality and relevance of evidence for dashboard design, narrative and stakeholder communication.
- 2.2 Compare alternative methods or responses to dashboard design, narrative and stakeholder communication.
- 3.1 Develop a board-level forecast dashboard and briefing that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in business intelligence and forecast communication. It focuses on decision-focused metrics and visualisation principles, dashboard design, narrative and stakeholder communication, production of forecast dashboards and executive insight, clarity, bias, accessibility and decision impact. Learners will use appropriate evidence and methods to produce a board-level forecast dashboard and briefing, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: decision-focused metrics and visualisation principles.
- Analysis and context: dashboard design, narrative and stakeholder communication.
- Applied methods: production of forecast dashboards and executive insight.
- Evaluation and improvement: clarity, bias, accessibility and decision impact.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Business Intelligence and Forecast Communication - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to decision-focused metrics and visualisation principles and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to dashboard design, narrative and stakeholder communication. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce a board-level forecast dashboard and briefing. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to clarity, bias, accessibility and decision impact. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Practical evidence: include direct observation or realistic simulation, an assessor observation record, the learner's working documents and a reflective account. Unsafe, unauthorised or unsupervised activity must not be assessed.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Unit 8 of 8
Capstone Financial Model and Board Report
FMBF508
Learning outcomes
- LO1: Critically analyse project scoping, requirements and model specification.
- LO2: Evaluate alternative approaches to research, data validation and model development in relevant vocational or organisational contexts.
- LO3: Integrate delivery of an integrated decision model to produce an independent financial model, technical file and board report.
- LO4: Critically review model conclusions, assurance and reflective improvement and justify improvements.
Assessment criteria
- 1.1 Critically analyse the theories, systems and contextual factors involved in project scoping, requirements and model specification.
- 1.2 Examine significant professional, ethical, legal, safety and stakeholder tensions affecting project scoping, requirements and model specification.
- 2.1 Evaluate the quality and relevance of evidence for research, data validation and model development.
- 2.2 Compare alternative methods or responses to research, data validation and model development.
- 3.1 Develop an independent financial model, technical file and board report that meets the stated scenario and stakeholder requirements.
- 3.2 Integrate evidence, controls, assumptions and stakeholder requirements coherently.
- 4.1 Critically review the completed work using appropriate performance and risk criteria.
- 4.2 Propose and justify prioritised improvements, recognising uncertainty and trade-offs.
Unit aim
This unit develops the learner's knowledge and applied capability in capstone financial model and board report. It focuses on project scoping, requirements and model specification, research, data validation and model development, delivery of an integrated decision model, model conclusions, assurance and reflective improvement. Learners will use appropriate evidence and methods to produce an independent financial model, technical file and board report, then evaluate its quality, safety, ethics and effectiveness.
Indicative content
- Core principles: project scoping, requirements and model specification.
- Analysis and context: research, data validation and model development.
- Applied methods: delivery of an integrated decision model.
- Evaluation and improvement: model conclusions, assurance and reflective improvement.
- Professional themes: stakeholder needs; legal and ethical responsibilities; equality and accessibility; health, safety and risk; data quality and confidentiality; communication and record keeping; quality assurance; sustainability; reflective practice.
Assignment brief
- Assignment title: Capstone Financial Model and Board Report - Applied Vocational Assignment
- Scenario: You are acting as a financial modelling and planning analyst for a realistic organisation or service. A manager has asked you to investigate a defined problem relating to project scoping, requirements and model specification and provide a defensible professional response.
- Task 1 - Context and analysis (AC 1.1, 1.2, 2.1, 2.2): Critically analyse and compare the key principles, responsibilities and supplied case evidence relating to research, data validation and model development. Identify material risks, needs, causes or decision factors and support the response with credible sources appropriate to Level 5.
- Task 2 - Applied output (AC 3.1, 3.2): Produce an independent financial model, technical file and board report. Show the method, assumptions, calculations or procedures used; include appropriate controls, records and stakeholder communication.
- Task 3 - Evaluation (AC 4.1, 4.2): Evaluate the completed output in relation to model conclusions, assurance and reflective improvement. Discuss limitations, ethical and safety implications, and make prioritised, evidence-based recommendations.
- Evidence requirements: one coherent 3,000 to 3,500-word equivalent submission, excluding appendices, together with the named applied output and supporting evidence. Use an accepted referencing style, map evidence clearly to every assessment criterion, identify all external sources and include an authenticity declaration.
- Practical evidence: include direct observation or realistic simulation, an assessor observation record, the learner's working documents and a reflective account. Unsafe, unauthorised or unsupervised activity must not be assessed.
- Assessment decision: Pass is awarded only when every criterion is met with valid, authentic, current and sufficient evidence. Unmet criteria must be referred for targeted reassessment in line with IQA policy.
Progression routes
Typical routes after completing this qualification.
Progression
Progression to Level 6 degree-level study, top-up routes where accepted, or professional roles.
Learning outcomes summary
- LO1: Critically analyse model purpose, structure and design standards.
- LO2: Evaluate alternative approaches to inputs, calculations, outputs, controls and documentation in relevant vocational or organisational contexts.
- LO3: Integrate construction of a transparent governed model to produce a controlled spreadsheet model and governance file.
- LO4: Critically review model error risk, usability and review findings and justify improvements.
- LO1: Critically analyse financial statements, ratios and quality of earnings.
- LO2: Evaluate alternative approaches to operational value drivers and historical trend analysis in relevant vocational or organisational contexts.
- LO3: Integrate driver-based analytical model development to produce a driver-based financial analysis workbook and report.
- LO4: Critically review performance causes and forecast implications and justify improvements.
- LO1: Critically analyse income statement, balance sheet and cash-flow linkages.
- LO2: Evaluate alternative approaches to forecast schedules, circularity and balancing controls in relevant vocational or organisational contexts.