Implementing Complex Scenarios in Cash Flow Models
The Key Topic Lectures Series is a set of 1 hour, ½-day and full-day lectures and hands-on instructor-led workshops. The modules that make up this series focus on key subjects in the areas of design & construction of models for financial forecasting and valuation and reports for financial analysis. The lectures are designed to provide thought-provoking sessions which are relevant to those in finance, commerce and public practice, which demonstrate and showcase sound solutions to common issues. The modules are available both publicly and also for private training. It is ideal as ongoing training in client organisations for students who have completed our main course in this area (the five-day Financial Analysis Certificate), and for inclusion in industry and corporate conferences.
Read More...All Key Topic Lectures All Subscriber Lectures
About This Module
Aimed at finance professionals seeking techniques to manage sets of complex criteria in models, this workshop demonstrates techniques for structuring and implementing complex table-driven assumptions for cash flow type models.
Given some starting assumptions, it builds a sample construction cash flow from scratch, implementing scenarios in which the costs are variable as to amount, timing, phasing and in which the cash flows can be automatically allocated on an S Curve basis. Finally it implements sensitivity analysis to allow the comparison of all scenarios within the one model.
Participants should be familiar with more complex formulas, the use of Data Tables, data validation, IF, MATCH and INDEX functions. Some familiarity with array formulas and the LET function would be an advantage.
Course / Event Details
| Event Date | Fri 09 Jun 2023 11:00 |
| Event End Date | Fri 09 Jun 2023 14:45 |
| Available places | 20 |
| Registrations close | Mon 05 Jun 2023 17:00 |
| Individual Price (ex GST) | $300.00 |
| Course Status | Advertised |
| Facilitator(s) | James Clarkson |
| Facilitated Instruction Hours | 4 |
| CPE Hours | 4 |
| Venue | Online via Teams |
Group Rate
| #Registrants | Rate/Person ex GST ($) |
|---|---|
| 3 | 270.00 |
| 6 | 240.00 |
Venue Information - Online via Teams
Online courses conducted using Microsoft Teams. Complete your enrolment on this site.
You will be sent a link prior to the course commencement with a link to the Teams sessions.
Clarkson ITT builds & delivers
expert training, in classrooms
& online, for professionals in
finance, funds management &
accounting - developing their
skills in modelling and analysis.
About
Learning
Contact
| +61 2 9871 0399 | |
| PO Box 104 West Pennant Hills NSW 2125 Australia |
|
| Clarkson ITT Company page | |
| @ClarksonITT |