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          Years                      -
Debt Amount                                          -



                          Year                           1       2       3       4       5
Funding Schedule          in %
Funding Received                                     -       -       -       -       -
IDC                                                  -       -       -       -       -




Note : Cells marked in yellow require your input.




© Copyright 2013 Docstoc Inc.                                                                5
Depreciation Table



Gestation Period           -
Depreciation Rate              0%
Year                            1         2         3       4       5       6       7       8       9       10
Depreciation               -          -         -       -       -       -       -       -       -       -
Book Value                 -          -         -       -       -       -       -       -       -       -

Note : Cells marked in yellow require your input.




© Copyright 2013 Docstoc Inc.                                                                                6
Cash Flow

                                                        Year 1   Year 2   Year 3   Year 4   Year 5   Year 6   Year 7   Year 8   Year 9 Year 10
Opening Cash Balance                                        -        -        -        -        -        -        -        -        -        -

Operating Activities
                       Net Income                           -        -        -        -        -        -        -        -        -       -
                       Cash from Operations                 -        -        -        -        -        -        -        -        -       -

Investing Activities
                       Capex                                -        -        -        -        -        -        -        -        -       -
                       Depreciation                         -        -        -        -        -        -        -        -        -       -
                       Cash from Investing Activities       -        -        -        -        -        -        -        -        -       -

Financing Activities
                       Long Term Debt                       -        -        -        -        -        -        -        -        -       -
                       Share Capital                        -        -        -        -        -        -        -        -        -       -
                       Loan Principal Repayment             -        -        -        -        -        -        -        -        -       -
                       Cash from Financing Activities       -        -        -        -        -        -        -        -        -       -

Net Cash Flow                                               -        -        -        -        -        -        -        -        -       -

Ending Cash Balance                                         -        -        -        -        -        -        -        -        -       -

Project IRR                                               0%       0%       0%       0%       0%       0%       0%       0%       0%       0%


Note : Cells marked in yellow require your input.




© Copyright 2013 Docstoc Inc.                                                                                                                    7
P&L Account

Note : Cells marked in yellow require your input.
                                Year                           1       2       3       4       5       6       7       8       9       10

Sales
                                Sales                      -       -       -       -       -       -       -       -       -       -
                                Other Income               -       -       -       -       -       -       -       -       -       -
                                Total Revenue              -       -       -       -       -       -       -       -       -       -

Cost of Sales
                                Direct Cost of Sales       -       -       -       -       -       -       -       -       -       -
                                Total Cost of Sales        -       -       -       -       -       -       -       -       -       -

Gross Profit                                               -       -       -       -       -       -       -       -       -       -

Total Operating Expenses
                                Rent                       -       -       -       -       -       -       -       -       -       -
                                Salaries                   -       -       -       -       -       -       -       -       -       -
                                Administrative Expenses    -       -       -       -       -       -       -       -       -       -
                                Advertising                -       -       -       -       -       -       -       -       -       -
                                Other Operating Expenses   -       -       -       -       -       -       -       -       -       -
                                Total Operating Expenses   -       -       -       -       -       -       -       -       -       -

EBITDA                                                     -       -       -       -       -       -       -       -       -       -

                                Depreciation               -       -       -       -       -       -       -       -       -       -
                                Amortization               -       -       -       -       -       -       -       -       -       -

Earning Before Interest and Taxes (EBIT)                   -       -       -       -       -       -       -       -       -       -

                                Interest Expense           -       -       -       -       -       -       -       -       -       -

Earning Before Taxes (EBT)                                 -       -       -       -       -       -       -       -       -       -


© Copyright 2013 Docstoc Inc.                                                                                                           8
                                Tax Rate   10%
                                Tax         -       -        -        -        -        -        -        -        -        -

Earning After Taxes (EAT)                  -        -        -        -        -        -        -        -        -        -

ROI                                            0%       0%       0%       0%       0%       0%       0%       0%       0%       0%




© Copyright 2013 Docstoc Inc.                                                                                                    9
				
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.