Advanced DCF

Please provide the model information. Click each of the step headings and fill out the data forms. Click on Run Model once you have entered all the data. By selecting Run Model, you agree to our Terms and Conditions.

1. Model Info

Model Name:

To run a new model, pick the model parameters and you can save the model after the results screen.

Tutorial

'

Model Parameters

Model Parameters.

Type of Period defines if the model is run on a monthly, quarterly, semester or annual basis.
Number of Periods defines the model horizon.
Use Period - Starting Year and Period - Starting Month to indicate the start of the project.
Categories - Revenue - specify how many revenue categories are included in the model. For example, if you have 5 different types of products with different prices, then select 5 for Revenue Categories.
Categories - Costs - specify how many cost categories are included in the model. For example, if you have 3 different types of costs (say, staff, offices and services), then select 3 for Cost Categories.
Capex Items - defines the number of capital items that you will need to depreciate.
Number of Loans - specifies how many loan will the project take. If the loan has multiple tranches then consider them as separate loans.
Currency defines the currency of the analysis.
Show Results in - specify if the output is desired in units, thousands, millions or billions.

Model Description

Type of Period		Number of Periods
Period - Starting Year		Period - Starting Month
Categories - Revenue		Categories - Costs
Capex Items		Number of Loans
Currency		Reserved for future use
Show Results In		Reserved for future use

If you have changed any of the parameters above, then please update the data entry form before making changes to the revenue and cost data below.

2. Revenue Data

3. Cost Data

Cost Details

Use the table below to specify the different costs for each period.

Total costs will be calculated as the sum of cost items (for example, Total Cost = Cost 1 + Cost 2 + Cost 3 + Cost 4 + ... + Cost n.)
The table will not self populate. You have put in data for each period otherwise the default values will be used.
To change the number of cost items, you can increase or decrease the Categories - Costs in the model parameters above.

Period	Jan-20	Jan-21	Jan-22	Jan-23	Jan-24	Inflation

Capitalized Items - Details

Provide the details for each of the capital cost items that will be subject to depreciation.

Depreciation assumed to start in the period after the period when the cost is incurred.
We assume straight line depreciation.
To change the number of capex items, you can increase or decrease the Capex Items in the model parameters above.

Item	Cost	Cost Incurred in (period)	Start Depreciation in (period)	Time for Depreciation	Type of Treatment

Loan	Amount	Start Period	Term	Interest Rate (% per year)

Tax Rate (%)	%	Discount Rate (%)	%
Inflation - Revenue (% per year)	%	Inflation - Cost (% per year)	%
Accounts Receivable	Days	Accounts Payable	Days
Sensitivity - Revenue (% of Base)	%	Sensitivity - Cost (% of Base)	%
Dividend (% of Net Income)	%	Long Term Growth (%)	%

Hello

Advanced DCF

1. Model Info

Tutorial

'

Model Parameters

2. Revenue Data

Volume and Price Details

3. Cost Data

Cost Details

Capitalized Items - Details

4. Financing and Other Data

Debt/Loan Details

Other info

Hello

Advanced DCF

1. Model Info

Tutorial '

Model Parameters

2. Revenue Data

Volume and Price Details

3. Cost Data

Cost Details

Capitalized Items - Details

4. Financing and Other Data

Debt/Loan Details

Other info

Tutorial

'