Building a Financial Model

BRIEF COURSE INFORMATION

Building a Financial Model
Location: Sharjah, UAE
AED 503
Course Duration: 5 Hours
Category: Finance, Accounting and Banking

COURSE DESCRIPTION

Every financial model is built on the same foundations: an getting the point of its purpose, who it is for, and its scope. This training explains how to set up the Excel spreadsheet and full the initial steps of inventing a financial model, structuring calculations, and looking into costs and revenues, time periods, cash balances and reporting.

This training will enable you to:

  • Set up and build a broad financial model
  • Calculate costs and revenues
  • Decide which time periods you need to use and when and where to use flags
  • Create understandable and useful reports
Learning Outcomes

Setting up a Financial Model

  • Who uses a financial model?
  • How should I set up a financial model?
  • What are the MS Excel settings for financial model build?
  • What should be included in a template?
  • How should I incorporate FAST principles?

Costs and Revenues

  • What are the different ingredients required to calculate the operating costs?
  • What would the concept diagram look like?
  • How do I build a calculation that I can use to quickly model the operating costs?
  • What would be different in the calculation on the revenue?
  • How do I build a calculation to quickly model the revenue?

Time Periods

  • What time periods should I use?
  • What do I need to know about flags?
  • Which ingredients are required to calculate the forecast period flag?

Cash Balances

  • Why is the cash balance particularly important?
  • What is a “balance corkscrew”?
  • What should I know about interest?
  • How is interest calculated?

Reporting

  • What will the recipient want from the summary report?
  • Should I use the same rules for inventing output sheets?

VISITORS who viewed this COURSE also viewed