Investment project evaluator

Step-by-step evaluation of investment projects: WACC, depreciation, loan, income statement, balance sheet, cash flow, NPV, IRR, benefit-cost ratio, payback, sensitivity (tornado and spider) and scenarios.

Figures in millions of COP. Percentages: type 4 for 4%. Use a decimal point or comma.

Investment and assets

Evaluation horizon (years)

Years of the cash flow

Depreciable assets (equipment)

Purchase value

Non-depreciable assets (land)

Not depreciated

Useful life of the assets (years)

Book salvage value

Residual value for depreciation

Depreciation method

Sales and costs

Units sold in year 1

Unit selling price

Annual growth in units (%)

Annual price growth (%)

Variable costs (% of revenue)

Annual fixed costs

Annual growth in fixed costs (%)

Working capital

Working capital (months of sales)

Months of year-1 revenue

Recover working capital at the end

Capital structure

Debt ratio (%)

% of fixed assets

Bank interest rate (effective annual) (%)

Loan term (years)

Fixed annual payment

Cost of equity (hurdle rate) (%)

Equity ratio: 60.0%

Taxes and terminal value

Income tax rate (%)

Capital gains tax rate (%)

On the terminal value

Project terminal value

At the end of the horizon

Sensitivity

Change for the tornado (±) (%)

Scenarios (% change over the base value)

Demand (units) — pessimistic (%)

Demand (units) — optimistic (%)

Selling price — pessimistic (%)

Selling price — optimistic (%)

% variable costs — pessimistic (%)

% variable costs — optimistic (%)

Fixed costs — pessimistic (%)

Fixed costs — optimistic (%)

The moderate scenario uses the base values.

Developed by Luis Ángel Meneses Cerón

Academic tool. It does not constitute financial advice or an investment recommendation.