Uploaded image for project: 'OSCAR'
  1. OSCAR
  2. OS-19086

PAC- Payback Years and 5-year NPV is Incorrect

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Bug
    • Resolution: Completed
    • Medium
    • None
    • None
    • AE
    • stage

    • AE Sprint 136
    • Regulatory cost was not calculated correctly.
    • Code
    • Hide
      Given: User has created New PAC
      When: User enters all necessary information and save changes
      Then: Payback (Years) and 5-year NPV is calculated based on entered cost and benefit value
      Show
      Given: User has created New PAC When: User enters all necessary information and save changes Then: Payback (Years) and 5-year NPV is calculated based on entered cost and benefit value

    Description

      Navigate to PAC central and create a New PAC

      enter all necessary details and navigate to prioritization page

      Select Financial benefit question as Yes and navigate to Financial Information page

      Enter financial benefit for Y1 to Y5, Select standard PGS cost and Standard Regulatory cost.

      Select reg filing type and save changes

      Payback(Years) and 5-year NPV are not calculated correctly.

      Ex: 2024-PAC-7000065

      Total Financial benefit = 16,116

      Standard PGS cost = 25,000

      Reg cost = 146,584

      total cost = PGS cost + reg cost = 25000+146584 =  171584

      Payback(Years) = total cost/financial benefit = 171584/16116 = 10.646 but value is displayed as 8.250

      Expected NPV:

        Year 1 Year 2 Year 3 Year 4 Year 5
      Total Est. Financial Benefits ($) 19,548 116 1,616 1,616 0
      Est. Total PGS Cost ($) 12,500 5,000 2,500 2,500 2,500
      Est. Total Regulatory Costs ($) 63,200 29,317 29,317 12,378 12,378
      total Cost -56,152 -34,201 -30,201 -13,262 -14,878
      NPV -53478.09524 -31021.32 -26088.8 -10910.7 -11657.3
      5-Year NPV -133156        

      Actual NPV: -104,240

      refer attached snapshots

      Attachments

        1. Bug-19086 Fixed.docx
          528 kB
          Srinivasan, Kowsalya
        2. PAC-Summary.PNG
          97 kB
          Srinivasan, Kowsalya

        Activity

          People

            MAHESP13 Mahesh Gundekar, Pallavi
            SRINIK18 Srinivasan, Kowsalya
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours
                4h