Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Mid-Life Lease Assets NPV Calculations
I am attempting to create mid-life lease assets, but the client's NPV does not match what NetSuite is calculating.
When using a source transaction for the value the client lists, NetSuite rejects the lease stating that the source transaction must be equal to the lease NPV.
The client has been using Excel's NPV function of "=NPV(H15/12,J45:J139)" where H15 is the interest rate, and J45:J139 are the monthly payments. This results in an NPV of 2,220,323.
NetSuite lists its calculation as =F16/(1+(0.0417/12))^H16, where F16 is the monthly payment and H16 is the period, resulting in a value of 2,198,336.