Silabus Financial Modelling In Excel

Financial Modelling in Excel adalah program pelatihan yang mengajarkan cara membangun model keuangan menggunakan Microsoft Excel untuk membantu analisis bisnis dan pengambilan keputusan.

Dalam training ini, peserta akan mempelajari cara menyusun laporan keuangan (seperti laba rugi, neraca, dan arus kas), membuat proyeksi keuangan, serta melakukan analisis seperti valuasi, budgeting, dan forecasting.

Pelatihan ini sangat bermanfaat bagi profesional di bidang keuangan, akuntansi, analis bisnis, maupun pengusaha yang ingin memahami kondisi keuangan secara lebih mendalam dan terstruktur.

Dengan kemampuan financial modelling, peserta dapat membuat simulasi berbagai skenario bisnis sehingga keputusan yang diambil menjadi lebih akurat dan berbasis data.

Garis Besar Materi Training Financial Modelling in Excel

A. About Financial Modelling

1. What is Financial Modelling?

Definition of a financial model.  Can all spreadsheets be called financial models?

2. Model Design

Designing and planning the layout of your model.   Considering factors such as the purpose and audience of the model.

3. Skills needed for Financial Modelling

The technical, design, business and industry knowledge required for financial modelling

4. Best Practice in Financial Modelling

Overview of the six points of financial modelling best practice

B. Excel Tools

1. Excel Versions

Upgrading to Excel 2013 and technical differences between versions. Considerations when building a model for users of different versions.

2. Conditional Formatting

Creating an automatic variance alert.  Using icon sets, colour scales and data bars to add visual interest to model outputs.

3. Hiding and Grouping

Keep your model tidy and easy to follow by hide unnecessary information or unused parts of the model whilst still following best practice guidelines

4. Dos and Don’ts for Linking Between Files

Ways to improve model integrity and reduce errors between linked files

C. Financial Modelling Techniques

1. What Makes a Good Financial Model?

Attributes of a good model such as user-friendly and structural features

2. Strategies for Reducing Errors

Techniques to employ during the model building process to reduce the potential for formula or logic error

3. Building Error Checks

Creating in-built, self-balancing error checks and error alerts

4. Bullet-Proofing your Model

Using worksheet protection to prevent entry, and restricting data entries using data validations.  Prevent misuse of your model by restricting incorrect inputs.

5. What-if Analysis with Goal Seek

Back-solve from a desired formula output to determine a model input using the goal seek Excel tool

6. Overview of Scenario Analysis Methods

Technical methods of creating scenario and sensitivity analysis in Excel

D. Essential Formulas

1. Cell Referencing & Named Ranges

Applying absolute and relative cell referencing and understanding its importance in Financial Modelling.  Using named ranges for assumptions reference.

2. Logical Nested Functions

Using IF, OR and AND functions, and nesting these together to create simple but intelligent formulas for use within financial models

3. Aggregation Functions

Applying the COUNTIF and SUMIF functions to reports and data summaries

4. Using a VLOOKUP Function

Correctly building this much-loved and often over-used Excel function

5. Tiering Tables

Practical application of one of the more complex and widely used calculations in financial modelling, such as tax calculations and volume break discounting

6. Using the FORECAST / TREND Function

Hypothetically forecasting future data based on historical trends using simple regression analysis in Excel

7. Formula Selection

Which formula or tool is most appropriate in which modelling situation?

E. Building a Business Case

Case Study: Build an individual business case using a range of financial functions and tools utilising best practice financial modelling techniques

1. Calculating Staff costs

Modelling with consistent, nested formulas to calculate costs for employees with variable start and end dates, including compounding inflation

2. Forecasting customer numbers

Calculating customer acquisition numbers from the potential pool of customers with documented assumptions. Mitigate liability by including appropriate caveats and key assumptions.

3. Modelling market penetration in a business case

Using assumed takeup rates to model market penetration

4. Forecasting Product Profitability

Assess business case feasibility cashflow forecast

5. Project Evaluation

Evaluate project feasibility with IRR (Internal Rate of Return), NPV (Net Present Value) and the payback period

F. Analysing & Presenting your Model

Practical: Create a best, base and worst case scenario on your model. Select from the drop-down box and watch the results change

1. Scenarios and Sensitivity Analysis

Manual sensitivity analysis, creating drop-down switches for scenario selection. Adjusting inputs variables to impact outcomes.

2. Model Documentation

Summarising key assumptions, documentation and source referencing, Writing operation instructions

3. Presentation of Model Output

Summarising results and display of findings. Communicate the results of your model clearly and concisely whilst getting the key message across to the audience. Summarising model data into a presentation

Rekomendasi Untuk Peserta: Participant must bring Laptop for practice sessions

 Tempat Training: Bandung, Jakarta, Yogyakarta

Durasi Training: 4 days

Waktu Training:

Biaya Investasi/Peserta:

• Rp. 8.450.000/peserta (bayar penuh)  atau
• Rp. 8.200.000/peserta (early bird atau grup 3 orang/lebih dari perusahaan yang sama)

Fasilitas Untuk Peserta Training

1. Modul Training
2. Sertifikat
3. ATK: NoteBook dan Ballpoint
4. T-Shirt
5. Goody Bag
6. Tumbler
7. Foto Training
8. Ruang Training dengan fasilitas Full AC dan multimedia
9. Makan siang dan 2 kali coffeebreak
10. Instruktur yang Qualified

Kuasai Financial Modelling dari Dasar hingga Mahir

Ingin meningkatkan kemampuan analisis keuangan yang benar-benar dibutuhkan di dunia kerja? Silabus Financial Modelling in Excel ini akan membantu Anda memahami materi pembelajaran secara lengkap dan terstruktur.

Diselenggarakan oleh Training Indonesia, program ini dirancang untuk memberikan pemahaman praktis mulai dari penyusunan model keuangan hingga analisis proyeksi bisnis.

Menariknya, pendekatan materi juga selaras dengan kebutuhan industri modern, termasuk referensi seperti Silabus Fraud Management in Telecommunication Business.

Dengan mengikuti silabus ini, Anda tidak hanya belajar teori, tetapi juga mendapatkan skill aplikatif yang siap digunakan untuk mendukung pengambilan keputusan bisnis yang lebih akurat.