Corporate Financial Modelling: Valuation Sensitivity and Reporting
This course will enable you to:
- Generate cash flows attributable to debt providers and shareholders
- Use historic data to calculate discount rates for net present value calculations
- Build a flexible financial model that can calculate different futures, circumstances and outcomes efficiently
- Consider the needs of different audiences and produce financial reports accordingly
Building a functional financial model is one thing but building a sophisticated financial model can elevated your business and provide you with vital information on financial analysis, loan sizing, debt restructuring and valuation.
Using a historic spreadsheet model, which includes a financial forecast, this course looks at how to further develop the model to add valuation and reporting. It will lead you through a series of spreadsheet examples and the steps required to further develop your own model.
Corporate Financial Modelling: Valuation Sensitivity and Reporting is the third CPD course in a three-part series.
Corporate Financial Modelling: Setting up Financial Models set out a methodology for building models in Excel.
Corporate Financial Modelling: Building Forecasts and Cash Flows leads you through a series of steps required to create your own model.
Free cash flow
- What is the methodology for a basic valuation?
- How do we use the cash flow statement?
- What is free cash flow?
- What is the time value of money?
- How do we deal with a varying interest rate?
Cost of capital
- What are the components of WACC?
- What data sources can we use?
- What are the limitations of WACC?
- What is the capital asset pricing model?
- What is asset beta and leveraging?
- Example: Sector beta
- What are terminal values?
- Discounted cash flows refresher
- What are the common mistakes?
- What are the required functions?
- Comparison to market value
- What are the components of value periods?
- How can we use scenarios?
- Can we use multiple values?
- How do we use scenario manager?
- How do we use multiple calculations?
- How do we use data tables?
- How do we use complex tables?
Reports and completion
- What are the common charting failures?
- How can we use composite charts?
- How can we use dynamic charts?
- How do we create a report template?
- How do prepare for model completion?
ACCA partner with accountingcpd.net to provide high quality CPD for members. As an ACCA member, you are required to complete at least 40 relevant units of CPD each year, where one unit is equal to one hour. 21 units must be verifiable; the other 19 can be non-verifiable.
Your accountingcpd.net course counts as verifiable CPD, if you can answer "yes" to these questions:
- Was the learning activity relevant to your career?
- Can you explain how you will apply the learning in the workplace?
You select courses that meet these criteria, and as you complete each course you get a CPD certificate so you can provide ACCA with the evidence that you undertook the learning activity.