Scribd Logo
Upload

Welcome to Scribd!

  • 735 views

    HAM 2015.11.24 Hybrid Annuity Model Bid Excel Sheet

    Uploaded by

    anon_789699787
    This document contains information about a project including the bid date, appointed date, completion date, inflation rate, construction support percentage, annuity payment percentage, bank rate, and discounting rate. It provides the quoted bid project cost of 1150 crore rupees and first year O&M quote of 10 crore rupees annually. It then shows the net present value calculations for the bid project cost, O&M payments, and bid price over the project period taking into account the dates of payments and inflation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    HAM 2015.11.24 Hybrid Annuity Model Bid Excel Sheet

    Uploaded by

    anon_789699787
    735 views5 pages
    This document contains information about a project including the bid date, appointed date, completion date, inflation rate, construction support percentage, annuity payment percentage, bank rate, and discounting rate. It provides the quoted bid project cost of 1150 crore rupees and first year O&M quote of 10 crore rupees annually. It then shows the net present value calculations for the bid project cost, O&M payments, and bid price over the project period taking into account the dates of payments and inflation.

    Original Description:

    Ham

    Original Title

    HAM-2015.11.24-Hybrid-Annuity-Model-Bid-Excel-Sheet

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains information about a project including the bid date, appointed date, completion date, inflation rate, construction support percentage, annuity payment percentage, bank rate, and discounting rate. It provides the quoted bid project cost of 1150 crore rupees and first year O&M quote of 10 crore rupees annually. It then shows the net present value calculations for the bid project cost, O&M payments, and bid price over the project period taking into account the dates of payments and inflation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    735 views5 pages

    HAM 2015.11.24 Hybrid Annuity Model Bid Excel Sheet

    Uploaded by

    anon_789699787
    This document contains information about a project including the bid date, appointed date, completion date, inflation rate, construction support percentage, annuity payment percentage, bank rate, and discounting rate. It provides the quoted bid project cost of 1150 crore rupees and first year O&M quote of 10 crore rupees annually. It then shows the net present value calculations for the bid project cost, O&M payments, and bid price over the project period taking into account the dates of payments and inflation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    Input cells - Please enter values in these cells

    Formula based cells - Please don't edit these

    Name of the Project


    Bid Date 1-Oct-15
    Appointed Date 12-Jun-16
    COD 9-Dec-18
    Inflation 5%
    Construction Support 40%
    Annuity Payment 60%
    Bank rate 8.5%
    Discounting rate 11.5%

    Parameter Quoted Value (In


    Rs. Crore)
    Bid Project Cost 1150
    First year O&M quote (Annual) 10
    20% 20%
    Date of Payments NPV 1-Oct-15 8-Apr-17 17-Jul-17
    Inflation Multiple 0 108% 109%
    Construction support - 98.99 100.25
    Adjusted BPC - 247.49 250.64
    Completion cost to be paid out in O&M period
    NPV of bid project cost 944.82
    O&M payment - - -
    NPV of O&M 73.64
    Bid Price 1,018.46
    20% 15% 15% 10%
    14-Dec-17 13-May-18 20-Sep-18 8-Dec-18 8-Jun-19 8-Dec-19 8-Jun-20 8-Dec-20 8-Jun-21 8-Dec-21
    111% 113% 115% 116% 118% 121% 123% 126% 128% 131%
    102.15 104.04 105.67 0.0 - - - - - -
    255.36 195.07 198.14 133.34
    768.92

    - - - - 5.92 6.05 6.17 6.30 6.42 6.55


    8-Jun-22 8-Dec-22 8-Jun-23 8-Dec-23 8-Jun-24 8-Dec-24 8-Jun-25 8-Dec-25 8-Jun-26
    133% 136% 138% 141% 143% 146% 148% 151% 153%
    - - - - - - - - -

    6.67 6.80 6.92 7.05 7.17 7.30 7.42 7.55 7.67


    8-Dec-26 8-Jun-27 8-Dec-27 8-Jun-28 8-Dec-28 8-Jun-29 8-Dec-29 8-Jun-30 8-Dec-30 8-Jun-31
    156% 158% 161% 163% 166% 168% 171% 173% 176% 178%
    - - - - - - - - - -

    7.80 7.92 8.05 8.17 8.30 8.42 8.55 8.67 8.80 8.92
    8-Dec-31 8-Jun-32 8-Dec-32 8-Jun-33 8-Dec-33
    181% 183% 186% 188% 191%
    - - - - -

    9.05 9.17 9.30 9.42 9.55

    You might also like