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?
Bookmarks