NPV Function cannot get what has been provided in the technical document

Ivan_Lo_
Ivan_Lo_
in Modeling

Hi all,

 

I tried to replicate the example in the Anapedia link

However, I cannot get the same result as in the example as below.

Ivan_Lo__0-1665569014816.png  

Ivan_Lo__1-1665569038622.png

 

My module as below, my result as highlighted.

Ivan_Lo__2-1665569086429.png

Ivan_Lo__3-1665569121255.png

Even the same cash flow data, same date column, and same formula with hardcoded discount rate. 

 

What do I miss? any idea?

 

Thanks.

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @Ivan_Lo_ 

     

    You are missing Lease dimension in your target module

     

    Hope that helps

    Misbah

    Miz Logix

Answers

Categories