Financial Modelling, Budgeting and Forecasting هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Overview
In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user.
 
By attending this course, you will be able to effectively prepare and build financial models, 
 
Course objective
 
By the end of the course, participants will be able to:

• Apply a structured approach to financial modelling in Excel
• Outline the hallmarks of good financial models
• Explain the importance of planning, and prep your model structure
• Build from operating revenues down to operating profit
• Forecast property, plant and equipment and other operating assets
• Forecast the various components of working capital
• Forecast debt financing and related interest costs
• Forecast equity financing and dividends
• Use an iterative analytic approach to managing circular references
• Understand the importance of error checking
• Derive a forecast cash flow statement based on a forecast income statement and balance sheet
• Perform Financial Model integration

تحديث بتاريخ 25 November, 2019