Inhouse Online Training Basic Financial Management and Modeling

PT Mitsubishi Corporation Jakarta Representative Office

Zoom Arcarta Consultant | Tanggal 26 Februari 2025

INVESTASI IN HOUSE ONLINE TRAINING

OVERVIEW

The Basic Financial Management and Modeling course provides a foundational understanding of financial principles and their application in decision-making and financial modeling. It begins with an overview of financial management, explaining its definition, importance, and key objectives, such as profit maximization versus wealth maximization. The course then explores the core functions of financial management, including investment decisions, financing strategies, dividend policies, and working capital management, all of which are essential for maintaining business sustainability.

A crucial aspect of financial decision-making is understanding the time value of money and conducting financial analysis. This section covers concepts like present value and future value, which are critical for evaluating investment opportunities. Additionally, participants will learn about basic financial ratios, such as liquidity and profitability, to assess a company’s financial health. The course then introduces financial modeling, explaining its purpose and significance in business decision-making, particularly in forecasting and evaluating financial scenarios.

Finally, participants will gain hands-on experience in building simple financial models. This involves identifying key assumptions, constructing financial reports, and developing basic financial projections. The course also highlights common errors in modeling and provides best practices for validation. By the end of the training, participants will have a solid understanding of financial management principles and the ability to apply financial modeling techniques to support informed business decisions.

Introduction to Financial Modeling

• • Definition and Purpose of Financial Modeling
  • Role of Financial Modeling in Business Decision- Making

Spreadsheet Fundamentals

• Navigating Spreadsheets
• Using Basic Functions and Formulas
• Cell Referencing and Naming Cells

 Building Simple Financial Models

• Constructing an Income Statement
• Building a Balance Sheet
• Creating a Cash Flow Statement

 Assumptions and Projections

• Identifying Key Assumptions
• Simple Projection Techniques
• Developing Basic Financial Projections

 Model Validation and Verification

• Model Validation Techniques
• Identifying Common Errors

Basic Financial Management and Modeling

1. Overview of Financial Management

• Definition and Importance
• Key Objectives: Profit Maximization Wealth Maximization

2. Core Functions of Financial Management

• Investment Decisions
• Financing Decisions
• Dividend Decisions
• Working Capital Management

3. Time Value of Money and Financial Analysis

• Concept of Present Value and Future Value
• Basic Ratio Analysis (Liquidity, Profitability)

4. Introduction to Financial Modeling

• Definition and Purpose of Financial Modeling
• Role of Financial Modeling in Business Decision- Making

5. Assumption and Building Simple Financial Models

• Identifying Key Assumptions
• Constructing a Financial Report
• Developing Basic Financial Projections
• Identifying Common Errors

Inhouse Online Training Intermediate Financial Modeling

PT Mitsubishi Corporation Jakarta Representative Office

Zoom Arcarta Consultant | Tanggal 27 Februari 2025

Intermediate Level (4 Hours)

• Introduction to Intermediate Financial Modeling
• Differences Between Basic and Intermediate Levels
• Goals of More Complex Models

Advanced Projection Techniques

• Sales Growth Projections
• Expense Projections Using Indexation
• Adjusting Working Capital

Sensitivity Analysis

• Introduction to Sensitivity Analysis
• Creating “What-If” Scenarios
• Using Data Tables for Analysis

Company Valuation

• Discounted Cash Flow (DCF) Method
• Determining Weighted Average Cost of Capital (WACC)
• Projecting Cash Flows for DCF

Introduction to Dynamic Reporting

• Creating Interactive Dashboards
• Using Pivot Tables and Charts

Intermediate Level – Financial Modeling

Introduction to Intermediate Financial Modeling

• Differences Between Basic and Intermediate Levels
• Goals of More Complex Models

Advanced Projection Techniques

• Sales Growth Projections
• Expense Projections Using Indexation
• Adjusting Working Capital

Sensitivity Analysis

• Introduction to Sensitivity Analysis
• Creating “What-If” Scenarios
• Using Data Tables for Analysis

Company Valuation

• Discounted Cash Flow (DCF) Method
• Determining Weighted Average Cost of Capital (WACC)
• Projecting Cash Flows for DCF

Introduction to Dynamic Reporting

• Creating Interactive Dashboards
• Using Pivot Tables and Charts