Building a Financial Model

Summary

Every financial model is built on the same foundations: an understanding of its purpose, who it is for, and its scope.

This course is provided by a third party provider accountingcpd.net and the fee charged is exclusive of VAT.  Training tickets are not applicable on this product. 

Venue details:  
Online, ,
Start date & time:  
01 January 2019 00:00
End date & time:  
01 January 2022 00:00
Price: €85.00  (€85.00 Member price)
By registering for this course you have accepted the terms and conditions
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
Finance, management reporting and analysis

This course explains how to set up the Excel spreadsheet and complete the initial steps of building a financial model, structuring calculations, and looking into costs and revenues, time periods, cash balances and reporting. 

Course overview

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 building?
  • What should be included in a template?
  • How should I incorporate FAST principles?

Cost 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 model the operating costs?
  • What would be different in the revenue calculation?
  • 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 building output sheets?
  • How do I construct the output sheet?