This subject focuses on the skills and techniques required to construct financial models to measure the effects of varying economic and environmental scenarios on an organisation’s performance. Spreadsheet models are used in business valuation, business analysis and risk management. Therefore, the ability to construct, understand and stress test models is an essential skill in applied finance. This subject covers model construction, assumptions, advanced excel functionality, detection and prevention of errors, sensitivity analysis, presentation of model output, and tips and traps. Application involves creation of models to make accurate predictions across varied scenarios and case studies, including reporting and communicating with relevant scenario stakeholders. For more information, please refer to the subject outline here.
Learning outcomes Subject content Duration Assessment Prerequisites Assumed knowledge Course transition subject equivalence Reading list Learning outcomes On successful completion of this subject, individuals should be able to: Explain the concept and principles of financial modelling and the skill set required to become a financial modeller Use Excel to effectively model business problems and extract essential data from spreadsheets Illustrate best practice modelling techniques by applying strategies for user-friendly design, consistency, error reduction and data security Effectively summarise and communicate the assumptions, implications and results of spreadsheet models Interpret and audit model results in the context of the business situation, and address the inherent assumptions through stress testing Subject content TopicTitle Topic 1Introduction to financial modelling Topic 2Building a financial model Topic 3Using Excel in financial modelling Topic 4Functions for financial modelling Topic 5Tools for model display Topic 6Tools for financial modelling Topic 7Common uses of tools in financial modelling Topic 8Model review Topic 9Stress-testing, scenarios, and sensitivity analysis in financial modelling Topic 10Presenting model output Duration The duration of this subject is one study period (12 weeks). Assessment Assessment TypeAssessedWeighting TaskWeek 420% Assignment 1Week 740% Assignment 2Week 1240% Prerequisites There are no prerequisites for this subject. However please review the Assumed Knowledge tab to understand the prior knowledge Kaplan advises you should hold before enrolling in this subject. Assumed knowledge Whilst there are no prerequisites for this subject, Kaplan assumes that individuals have completed FIN202 Fundamentals of Asset Valuation, or understand the content covered in this subject, prior to undertaking FIN280 Financial Modelling. Course transition subject equivalence Individuals may not be required to complete this subject if they have transitioned from a SIA/Finsia/Kaplan Professional course and have completed the following subjects: There are no equivalences for this subject Reading list There is no prescribed text for this subject. Individuals are provided with key readings and access to Kaplan’s online databases. Individuals are encouraged to research and read widely on the topic.
Learn more about Master of Applied Finance, Graduate Diploma of Applied Finance or Graduate Certificate in Applied Finance >
This subject focuses on the skills and techniques required to construct financial models to measure the effects of varying economic and environmental scenarios on an organisation’s performance. Spreadsheet models are used in business valuation, business analysis and risk management. Therefore, the ability to construct, understand and stress test models is an essential skill in applied finance. This subject covers model construction, assumptions, advanced excel functionality, detection and prevention of errors, sensitivity analysis, presentation of model output, and tips and traps. Application involves creation of models to make accurate predictions across varied scenarios and case studies, including reporting and communicating with relevant scenario stakeholders. For more information, please refer to the subject outline here.
Learning outcomes Subject content Duration Assessment Prerequisites Assumed knowledge Course transition subject equivalence Reading list Learning outcomes On successful completion of this subject, individuals should be able to: Explain the concept and principles of financial modelling and the skill set required to become a financial modeller Use Excel to effectively model business problems and extract essential data from spreadsheets Illustrate best practice modelling techniques by applying strategies for user-friendly design, consistency, error reduction and data security Effectively summarise and communicate the assumptions, implications and results of spreadsheet models Interpret and audit model results in the context of the business situation, and address the inherent assumptions through stress testing Subject content TopicTitle Topic 1Introduction to financial modelling Topic 2Building a financial model Topic 3Using Excel in financial modelling Topic 4Functions for financial modelling Topic 5Tools for model display Topic 6Tools for financial modelling Topic 7Common uses of tools in financial modelling Topic 8Model review Topic 9Stress-testing, scenarios, and sensitivity analysis in financial modelling Topic 10Presenting model output Duration The duration of this subject is one study period (12 weeks). Assessment Assessment TypeAssessedWeighting TaskWeek 420% Assignment 1Week 740% Assignment 2Week 1240% Prerequisites There are no prerequisites for this subject. However please review the Assumed Knowledge tab to understand the prior knowledge Kaplan advises you should hold before enrolling in this subject. Assumed knowledge Whilst there are no prerequisites for this subject, Kaplan assumes that individuals have completed FIN202 Fundamentals of Asset Valuation, or understand the content covered in this subject, prior to undertaking FIN280 Financial Modelling. Course transition subject equivalence Individuals may not be required to complete this subject if they have transitioned from a SIA/Finsia/Kaplan Professional course and have completed the following subjects: There are no equivalences for this subject Reading list There is no prescribed text for this subject. Individuals are provided with key readings and access to Kaplan’s online databases. Individuals are encouraged to research and read widely on the topic.
Learn more about Master of Applied Finance, Graduate Diploma of Applied Finance or Graduate Certificate in Applied Finance >