Building a Financial Model

Print Friendly, PDF & Email

Building a Financial Model Online CPD Training CourseOnline Course on Building a Financial Model

This is course number two in a series of four courses.

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

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

buy Building a Financial Model

Understanding Building a Financial Model
enables the learner to:

• Set up and build a comprehensive 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

 

Rating: 5 Stars for online course 100% said it met their professional development objectives
Reviews:

“I frequently prepare financial models, this course highlighted several modelling improvements I can use in future.”

“Very useful guidelines to use in any type of project going forward.”

“It built upon the knowledge/practice gained from the introductory course and provided me with a better understanding of modelling that I can use in my everyday work.”

You can review this course using the questionnaire in the course completion area.

Learning outcomes of Building a Financial Model

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?
Building a FM Setting up

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?
costs and revenues

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?
Building a FM time periods

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

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?
Building a FM reporting

Target audience for Building a Financial Model

Accounting and finance professionals in practice and in industry.

About the author of Building a Financial Model

Grant ThorntonGrant Thornton UK LLP specialise in developing, building and reviewing financial models for clients.

Grant Thornton is one of the world’s leading organisations of independent assurance, tax and advisory firms. Over 38,500 Grant Thornton people, across 120 countries, are focused on making a difference to clients, colleagues and the communities in which they live and work.

Flexible learning

Learners take their own route through the topics covered in the course. They will learn at their own pace through a variety of activities designed to accommodate a range of learning styles.

You might also be interested in

Introduction to Financial Modelling
Financial Control in SMEs
Making Budgeting Work in the Real World
Alternative Finance

Register now for free module

To purchase a course or to try a free module please register. Registration is free and there is no obligation to purchase. Just click the button below:

Please review our Frequently Answers Questions (FAQs) for answers to the most common questions we receive (opens in a new window).

 

Buy Building a Financial Model

Pay online

Add to cart / basket

Required access period:

Instant Purchase

Required access period:


Click on the Buy Now or Add to Cart button above to make your purchase via credit or debit card. Your payment will be collected securely via PayPal. Please note that a PayPal account is NOT required to process your payment (simply click on the option to pay via credit or debit card). No surcharge will be levied on card payments for purchases. You will automatically be emailed a receipt after your purchase.

Pay by invoice and bank transfer


If preferred you can pay via bank transfer (BACS / EFT / Online banking).
Please complete the form below and we will send you an invoice with our bank details.

Your Name (required)

Your Email (required)

Invoice addressee, if required
(e.g. company name, address)

Additional courses, if required

Required access period (for online courses)
3 months12 months

Other relevant information


View cart or checkout

If using our shopping cart, you can view the cart and checkout here.


Access

You will receive 3 or 12 months (depending upon your chosen option) unlimited free access after payment of a one off registration fee.

Length of courses

Each course takes approximately 4 hours to complete.

CPD points

Once you've completed the course you will be able to claim 4 verifiable CPD hours, if required. CPD points are claimed by the registered user, who can be someone different to the person who pays if required.

*VAT

VAT will be calculated and added automatically during the checkout process (and before any payment is taken) based on your location.

VAT is applicable at the prevailing rate for customers within the EU. VAT will be added during checkout at the rate applicable to your Country. For customers outside the EU, where UK VAT is non-applicable, the checkout will automatically detect your location and VAT will not be added.

For customers in the Channel Islands please contact us in advance of purchase.

Delivery

You will be emailed instructions of how to access your course and an activation code within one working day, usually a few hours.

Do you wish to pay in a different currency?

Simply email support@financialfluency.co.uk with a list of the courses you wish to purchase and your chosen currency and we will send you an invoice in your desired currency.

Any more questions?

For any questions, please see our frequently asked questions or send an email to support@financial-fluency.co.uk