Skip to content

Financial Modelling Techniques

GoSkills

Summary

Price
£29 inc VAT
Study method
Online
Duration
Self-paced
Qualification
No formal qualification
CPD
29 CPD hours / points
CPD What's this?
Certificates
  • Certificate of completion - Free
69 students purchased this course

Add to basket or enquire

Overview

Financial modeling in Excel is extremely useful to forecast and make key business decisions for your company. Learn this career-boosting skill in this online course, through proven methodologies and tools to help you construct a financial model step by step. The training covers financial statement theory and how they link together, building on the best practices and Excel functions covered in the Financial Modeling Basics course. Examples are provided throughout so that you can apply the practical knowledge you learn through hands-on application in Excel.

Certificates

Certificate of completion

Digital certificate - Included

CPD

29 CPD hours / points
Accredited by The CPD Certification Service

Description

Highlights:

  • 59 practical tutorials.
  • Understand the different financial statement types and their key line items.
  • Link the three financial statements together and add them to the model.
  • Recognize the importance control accounts play in balancing the model.
  • How to add the checks worksheet system to keep your model error-free.
  • How to model revenue and working capital adjustments.
  • Highlight the differences between the four different input methods.
  • How to input COGS, OPEX and CAPEX into the financial statement.
  • Calculate the control account for debt and interest payable.
  • How to calculate tax components including tax expense, depreciation and losses.
  • How to calculate Net Operating Cashflow using the Indirect Cashflow method.

Who is this course for?

This course is designed for those who have some knowledge in creating a Financial Model. If you are a beginner, check out our Financial Modelling Basics course.

Career path

Business, Finance, Financial Modeling

Questions and answers

No questions or answers found containing ''.

Solomon asked:

Hi, are the presentations in British £ or USD$

Answer:

The pricing of the GoSkills courses on the Reed site is in British £.

This was helpful. Thank you for your feedback.
Micaela asked:

What is the timeframe for access? Do we need to complete this course in a certain time frame? one momth, 2 etc?

Answer:

Hi Micaela, You will have access to the course for 12 months. This allows plenty of time for you to complete all lessons within the course. Cheers, GoSkills Support

This was helpful. Thank you for your feedback.
Jose Miguel Ferreira asked:

Does this training provide an international certification/recognition for both the UK and worldwide?

Answer:

GoSkills courses are certified by the Continuing Professional Development Certification Service. We provide a Certificate of Achievement at the end of the course, which you can add to your CV or resume, to show potential employers that you have undertaken training from us. Any employer can verify your training on our website by entering your certificate verification number and reviewing the syllabus you've completed. Cheers, GoSkills Support

This was helpful. Thank you for your feedback.
Ask a question

Reviews

4.3
Course rating
80%
Service
100%
Content
80%
Value

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Accountancy courses, Accounting courses, Business Finance courses, Online courses