Create an event

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

From Wed 8 April 2020 to Thu 9 April 2020
9:00 AM - 5:00 PM
Ended

FINANCE FOR NON-FINANCIAL MANAGERS TWO DAY INTENSIVE WORKSHOP ASSISTED BY EXCEL TEMPLATES AND MODELS * Financial diagnosis for problems identification * Financial indicators for comparative performance evaluation * 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 * Benchmarking * using ratios as performance indicators * Strengths and weaknesses COST VOLUME PROFIT ANALYSIS * determine fixed and variable costs * Determine quantity sold * Determine the price sold * Make outsource decisions. Working capital * estimate the right amount of working capital * Manage trading strategies * Manage stocks, debtors and creditors FIXED CAPITAL * Capacity planning * Leasing and rental * borrow to buy * Financial leverage * compute IRR and NPV FINANCING THE BUSINESS * Balance between equity and loans * Calculate the costs of each source * Control vs tax deductible expenses CASH FLOW PROJECTIONS * Project cash inflows and outflows * Appreciate the inportance of liquidity * Compute the IRR and NPV Return on Equity Model * Understand corporate objective and goals * How to maximise return * Profit margin x asset turnover x Asset equity leverage. * Comprehensive diagnosis of the company. * Income statement * 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 * To enable participant to analyse and process financial data, makes decisions and produce reports for management purposes. * Learn financial strategies through simulations and deep root cause analysis through component ratios. * Take home excel templates and models * 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. * Financial statement analysis and meaningful interpretation * Veritcal, horizontal and trend analysis * Cost volume profit analysis to determine the economic size of business * Working capital and trading strategies * Fixed capital and leverage * Sources and costs of funds:  Financial structure * Cash flows :  IRR and NPV * Return on Equity as the key goals in business * Key Performance indicators as performance measures THE TEACHING APPROACH * Using ratio analysis to interpret the financial data * Using budget to plan and control activities * Controlling cash and liquidity as opposed to profitability * Applying financial strategies LEARNING OUTCOMES * Critically analyse and interpret financial statements * understand costs for planning and control purposes. * Ability to evaluate performance * Ability to use funds more efficiently and effectively. Copyright FAQS * CERTIFICATE OF ATTENDANCE ISSUED TO ALL PARTICIPANTS * SNACKS AND DRINKS PROVIDED DURING BREACKS * Please bring your Notebook or laptop and financial calculator * Millenneum Square is near MRT Asia Jaya * Lots of Parking at basements  
culture
3149 Views
11/04/2020 Last update

Excel College
No. 98 Jalan 14/1, Petaling Jaya, 46100, Selangor, MY

View event details


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.

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