Events.com apps

FINANCE for NON-FINANCIAL MANAGERS: using spreadsheet as an analytical tool

FINANCE for NON-FINANCIAL MANAGERS: using spreadsheet as an analytical tool
Image from eventbrite.com
Event ended

FINANCE FOR NON-FINANCIAL MANAGERS




TWO day intensive workshop assisted by excel templates and models



  1. Financial diagnosis for problems identification

  2. Financial indicators for comparative performance evaluation

  3. Finance for decision making and planning purposes


Training Objective


At the end of the program, the participant shall acquire relevant knowledge and skills in finance to enable him to analyse, projecting and strategising.

Designed for anyone who wants to grow a successful career in managerial position.   This course will teach you everything required including accounting, financial math,  financial statement analysis, and business analysis.

Here are some more details of what you'll learn:

1. How to build a company's P&L from scratch and perform financial statement analysis
2. How to calculate Liquidity, Solvency, Profitability and Growth ratios to analyze a company's performance
3. The importance of timing of revenue and cost recognition
4. Understand what drives a company's stock value.

5.  Cash flows and liquidity management

Gap Analysis

  1. Benchmarking
  2. using ratios as performance indicators
  3. Strengths and weaknesses

Cost volume profit analysis

  1. determine fixed and variable costs
  2. Determine quantity sold
  3. Determine the price sold
  4. Make outsource decisions.

Working capital

  1. estimate the right amount of working capital
  2. Manage trading strategies
  3. Manage stocks, debtors and creditors

Fixed Capital

  1. Capacity planning
  2. Leasing and rental
  3. borrow to buy
  4. Financial leverage
  5. compute IRR and NPV

Financing the business

  1. Balance between equity and loans
  2. Calculate the costs of each source
  3. Control vs tax deductible expenses

Cash Flow Projections

  1. Project cash inflows and outflows
  2. Appreciate the inportance of liquidity
  3. Compute the IRR and NPV

Return on Equity Model

  1. Understand corporate objective and goals
  2. How to maximise return
  3. Profit margin x asset turnover x Asset equity leverage.
  4. Comprehensive diagnosis of the company.
  5. Income statement
  6. Balance Sheet

Purpose


To develop the knowledge concepts and techniques necessary to manage financial resources while at the same time using financial measures to measure the true performance of each activity area.


Targeted Groups

All excutives and managers, directors and entrepreneurs, teachers and students, borrowers and lenders

Benefits of this course

  1. To enable participant to analyse and process financial data, makes decisions and produce reports for management purposes.
  2. Learn financial strategies through simulations and deep root cause analysis through component ratios.
  3. Take home excel templates and models
  4. To apply the relevant financial strategies 


Course methodology

  • Assisted by excel software

  • Case study by group discussion

  • Prepared templates and models

  • Simulations to demonstrate the impact of financial strategies

COURSE CONTENTS

Among others, the following topics shall be discussed.

  1. Financial statement analysis and meaningful interpretation

  2. Veritcal, horizontal and trend analysis

  3. Cost volume profit analysis to determine the economic size of business

  4. Working capital and trading strategies

  5. Fixed capital and leverage

  6. Sources and costs of funds:  Financial structure

  7. Cash flows :  IRR and NPV

  8. Return on Equity as the key goals in business

  9. Key Performance indicators as performance measures

The teaching approach

  1. Using ratio analysis to interpret the financial data
  2. Using budget to plan and control activities
  3. Controlling cash and liquidity as opposed to profitability
  4. Applying financial strategies

Learning outcomes

  1. Critically analyse and interpret financial statements
  2. understand costs for planning and control purposes.
  3. Ability to evaluate performance
  4. Ability to use funds more efficiently and effectively.

Copyright

FAQs

  1. Certificate of attendance issued to all participants
  2. Snacks and drinks provided during breacks
  3. Please bring your Notebook or laptop and financial calculator
  4. Millenneum Square is near MRT Asia Jaya
  5. Lots of Parking at basements

 

Views - 10/01/2020 Last update
culture
Excel College
No. 98 Jalan 14/1, Petaling Jaya, 46100, Selangor, MY
Create an event
Create events for free. They will be immediately recommended to interested users.
Nearby hotels and apartments
No. 98 Jalan 14/1, Petaling Jaya, 46100, Selangor, MY
Discover more events in Petaling Jaya
Discover now
Discover more events in Petaling Jaya
Discover now
Excel College
No. 98 Jalan 14/1, Petaling Jaya, 46100, Selangor, MY
Create an event
Create events for free. They will be immediately recommended to interested users.
  1. Petaling Jaya
  2. FINANCE for NON-FINANCIAL MANAGERS: using spreadsheet as an analytical tool
 
 
 
 
Your changes have been saved.