INFRASTRUCTURE PROJECT ROI CALCULATOR
GUIDELINES
Return on Investment or ROI is a standard method of evaluating how efficiently management uses the average
dollar (or unit of currency) invested in assets, whether the investment came from owners or creditors. A high ROI
may result in a higher return on stockholders' equity (ROE).
ROI (Return on Investment) is probably the most important calculation one must make to ensure the long-term
viability of their business, enabling business owners, managers, and employees to increase productivity and
business profits.
The Infrastructure Project ROI Calculator included in this workbook will help generate ROI and IRR values for a
project. Both ROI and IRR are standard tools commonly used to help understand the feasibility of a project.
Note : Cells marked in yellow require your input.
© Copyright 2011 Docstoc Inc. 1
Project Costing
Note : Cells marked in yellow require your input.
Gestation Period 0
Year - - - - -
COST OF CONSTRUCTION 0
Design & Architecture - - - - -
Civil Work - - - - -
Equipment - - - - -
HVAC - - - - -
Mechanical Work - - - - -
Electrical Work - - - - -
Security System - - - - -
Audio & Visual System - - - - -
Quality Control System - - - - -
Design Miscellaneous - - - - -
Contingency - - - - -
TOTAL - - - - -
OTHER COST
PMC Fees - - - - -
Admin & Establishment Expenses - - - - -
Legal & Audit Fees - - - - -
Insurance - - - - -
TOTAL OTHERS - - - - -
Interest During Construction - - - - -
BASE CASE COST - - - - -
COST TO BE WRITTEN OFF
Bank Commission Charges - - - - -
Bank Appraisal Charges - - - - -
Market Survey and Preparation of
Feasibility Reports (Preliminary
Expenditure) - - - - -
TOTAL - - - - -
BANK GUARANTEE MARGIN - - - - -
TOTAL PROJECT COST - - - - -
© Copyright 2013 Docstoc Inc. 2
Equity Structure
Debt to be Raised -
At Interest Rate 0%
Moratorium Period 0 Years
Loan Period - Years
Year 1 2 3 4 5 6 7 8 9 10
Debt - - - - - - - - - -
Equity Raised - - - - - - - - - -
Equity - - - - - - - - - -
Repayment Schedule - - - - - - - - - -
Interest Outflow - - - - - - - - - -
Note : Cells marked in yellow require your input.
© Copyright 2013 Docstoc Inc. 3
Debt Annuity Payments
Debt
Year Annuity Interest Net Debt Debt
- Moratorium Period -
1 - - -
2 - - - Repayment Period (Include Moratorium) -
3 - - - Actual Years for Principal Payment -
4 - - - Interest
5 - - -
6 - - - Annuity Amount after Moratorium Period -
7 - - -
8 - - -
9 - - -
10 - - -
Note : Cells marked in yellow require your input.
© Copyright 2013 Docstoc Inc. 4
Interest During Construction
Unit Parameter
Interest Rate %
Gestation Period Yea