Course Advanced valuation-model
Value a business
An investor is deciding what to pay for a small company and wants a discounted cash flow valuation. Every assumption is on the Assumptions sheet. Build a five-year forecast on the Model sheet and turn it into a value for the business. Refer to the assumptions; do not type their numbers in.
Sheet What it is for Filled cells
Parts
Part What to do Done
1 Revenue forecast Not done yet
2 Profit and tax Not done yet
3 Free cash flow Not done yet
4 Discounting Not done yet
5 The valuation Not done yet
Part 1 of 5 · Revenue forecast
In B2:F2, forecast revenue for years 1 to 5. Each year is the year before, grown by the growth assumption; year 1 grows from last year's revenue.
Loading spreadsheet…
- =
- start a formula
- ↑ ↓ ← →
- move, or pick cells
- Ctrl D
- fill down
- Alt =
- AutoSum
- Ctrl Enter
- check
- ?
- all shortcuts