+ Reply to Thread
Results 1 to 1 of 1

Net Present Value Calculation based on Date Range

  1. #1
    Registered User
    Join Date
    12-26-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    18

    Net Present Value Calculation based on Date Range

    In the example attached. We are renewing a lease for one year with rent and all operating costs remaining flat. The NPV for the transaction should be $123,122 but is showing as $119,107. In the attached example, the lease is for a period of one year beginning April 1, 2013 and ending Mar 31, 2014. The NPV formula is calculating based on 2 years since the lease term crosses years. Is there a formula to calculate the NPV based on 1 year if the lease term crosses years?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1