Docstoc

Project ROI Calculator

Document Sample
Project ROI Calculator Powered By Docstoc
					          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
				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:954
posted:1/10/2012
language:Unknown
pages:9
Description: The Project Return on Investment (ROI) Calculator allows an investor or project manager to calculate the ROI and IRR values for a given project. The user should input all project costs, the project's equity structure, a funding schedule, a depreciation rate, and certain figures for the profit and loss account. The spreadsheet will automatically calculate debt annuity payments, interest during project construction, depreciation, cash flow, and numerous figures in the profit and loss account, such as earnings after taxes and ROI.