Financial Modelling For Decision Making & Analysis

Most Accountants are busy will day to day compliance and accounting standard. While this is important, accountants were not able to spend time responding to the management requests. This program aims to equip you with capabilities to plan and build financial models efficiently at work. Transform the way you build financial model today.

What You Will Learn:

• Create all the 3 Financial Models
• Creatively integrate various Excel functions to achieve its desire results
• Understand how to use the Excel smartly
• Increase work efficiency in leveraging on technology
• Leverage on special features in Excel enhance your analysis

Course Structure:

• Model 1: Property Mortgage Calculation
• Create flexible scenarios to perform financial calculation and analysis for business or personal loan decision making. Blend in creatively with useful MS Excel features and formula to present easy to use loan decision dashboard.
• Model 2: Assets Management
• Create interactive reports to manage fixed assets and automate periodical depreciation schedule. Set up an effective Fixed Assets Register and interactive table for better control and analysis purposes.
• Model 3: Optimized Profit By Best Product Sales Mix Solution
• Learn how to use Excel Solver to achieve target profit at the same time to manage the production constraints in the company.
• Solution with multiple constraints
• Identify and set up the costs, production capacity and budget sheets
• Identify the decision variables for decision making purposes
• Analyse and set up the possible constraints in order to achieve the profit target.
• Model 4: Investment Appraisal For Decision Making
• Set up an analysis table to calculate different results in order to decide the feasibility of the investment. Learn the concept of NPV, Internal Rate of Return and Payback period. Leverage on the MS Excel features and formula to automate the calculation.