Financial Modelling in Excel

Various techniques in investment appraisal, budgeting, financial analysis and forecasting.

Free

Financial Modelling in Excel

2 days
All levels
0 lessons
0 quizzes
0 students

Course Info

The most fundamental and widely sought after skills in the finance industry is financial modelling. The Microsoft Excel financial model depicts the financial statement and investment analysis. In addition, Participants gain various techniques in investment appraisal, budgeting, financial analysis and forecasting. The presentation of the performance of a business, a project or any other investment cab represent by financial models.

What Will I Learn From This Course?

The repetitive tasks can be time consuming. The macro programming allows users to automate repetitive tasks and leverage on Excel’s built in to consolidate data in the most efficient way in order to minimise errors.

The process of learning step by step where each component build up or feed into another component in a budget model is significantly important. Majority of professional are familiar with output of financial statement, only few are truly adept a building an accurate and effective financial from scratch.

Using Excel Solver helps to find the parameter that optimize cost and find best way to achieve an objective in many situations

Pre-requisites

Completion of Basic & Intermediate Microsoft Excel course or equivalent knowledge. Basic financial related working knowledge is required.

Methodology

This is practical lab exercises using Microsoft office tools such as PowerPoint, Word and Excel

Course Outline for This Programme

a. Moving Average
b. Exponential Smoothing
c. Trend lines
d. Handling Seasonality & Trend
e. Correlation
f. Regression Analysis

a. Linking Data
b. Consolidating Data
c. Consolidating With Formulas
d. What If Analysis
e. Introduction To Macro Programming

a. Sales Budget
b. Cost Of Sales Budget
c. Inventory Budget
d. Budgeted Income Statement
e. Budgeted Balance Sheet
f. Budgeted Cashflow

a. Net Present Value Function
b. Internal Rate Of Return Function
c. Mutually Exclusive Project
d. Non Mutually Exclusive Projects

a. Using Excel’s Solver
b. Building An Optimising Investment Model

Curriculum is empty