Excel: financial modelling

City Lit

Course

In London

£ 249 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

This Course is about learning how to build a financial model in Excel from scratch through the valuation process of a given company. This will be illustrated by an application analysis of a publicly traded company.While this course will cover parts of Financial Statements Analysis, the focus will be on building the model in excel.

Facilities

Location

Start date

London
See map
Keeley Street, Covent Garden, WC2B 4BA

Start date

Different dates availableEnrolment now open

About this course

By the end of this course you should be able to build and share with colleagues a financial model that links up the three statements under different scenarios (e.g., expected economic growth). The model would return an estimated value of a company under each scenario.

No.

No required work outside the class.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Financial Modelling
  • Financial
  • Financial Training
  • MS Excel

Course programme

1) - Customising the settings in Excel to accommodate the Model.
• Creating new Format in the Worksheet: Numbers, Text, Font and Size.
• Exporting the Format to other Workbooks.
• Don’t use the mouse.

2) - Advanced excel Functions:
• Advanced Conditional Functions.
• The look up School (Advanced).

3) - Start building the model
• Reformulating and transcribing the Income statement in Excel.
• Reformulating and transcribing the Balance Sheet in Excel.
• Building the Cash Flow Statement in Excel.
• Scenario Analysis: Forecast & Valuation.

Additional information


Introduction to VBA.

General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details

See related categories

Excel: financial modelling

£ 249 VAT inc.

The best Excel courses

See all

See all