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. 

Venue details:  
Online EU, ,
Start date & time:  
01 January 2019 00:00
End date & time:  
01 January 2022 00:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.50 Training Tickets accepted
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
Strategic finance and management reporting

Booking with a Training Ticket

Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed

Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification

Course Overview

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?