Loading component...
Project Modelling Using Excel
Overview
In this recorded webinar, you will learn how to develop various scenarios using an assumption page and seamlessly switch between them to conduct comprehensive project-based scenario analysis. The ultimate goal is for you to build a cash flow model that discounts cash flows for a 30-year duration. You will be presented with a practical problem, and with the aid of a reliable Excel template, you will compare two distinct solutions.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Generate a range of scenarios for users to conduct sensitivity analysis
- Generate a set of calculations leading to a cash flow analysis
- Isolate data in a single template intelligently so that template can be used in the other scenario
- Generate a range of output assumptions to compare the two projects against one another
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step-by-step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Clickherefor Marcus' biography.
Course updated: May 2023
What you'll learn
- Develop formulas using a combination of text and numerical criteria
- Demonstrate proficiency in Excel modeling by utilising a versatile template applicable to various projects
- Conduct a thorough NPV analysis using discounted cash flows spanning 30 years
- Produce a concise output report that enables users to easily compare the results of the NPV analysis
Who is this for ?
