tag:blogger.com,1999:blog-1234818185922146658.post544949514795658516..comments2019-09-16T09:09:30.291-07:00Comments on NNN Real Estate Blog: Comparing Lease TermsBlack Doghttp://www.blogger.com/profile/12972902657284994438noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1234818185922146658.post-25158976610227733812016-11-14T21:32:06.386-08:002016-11-14T21:32:06.386-08:00Hey, thanks for reading and thanks for the feedbac...Hey, thanks for reading and thanks for the feedback! I just took a look at the original spreadsheet and my calculation is correct. Not sure what's causing the confusion, but really do appreciate you taking the time!Black Doghttps://www.blogger.com/profile/12972902657284994438noreply@blogger.comtag:blogger.com,1999:blog-1234818185922146658.post-42311266012541388102016-11-01T04:28:22.663-07:002016-11-01T04:28:22.663-07:00Hi, I am an interested reader of the blog and I th...Hi, I am an interested reader of the blog and I think I noticed some errors within the excel template. The calculation for the Income of lease 2 seems to be incorrect as you arrive at the very same numbers as in case 1 even though sqf rent is different. Further, I adjusted the formula for the income (so you can apply it in a general case). For cell H77 (year 1, lease 2) it should be: <br />=+IF(H$68<=$H$11;IF($H$8<H$68*12;(MIN(H$68*12-$H$8;12))*$H$17*$H$15*((1+$H$18)^(H$68-1));0);0)<br />With this formula rent free months can be any number rather than just be applicable for the first 2 years (plus the formula for year2 had weird results of which I am not sure if they were correct)<br /><br />I hope you find this helpful. <br />Kind regards and keep up those efforts witht this blog.some guyhttps://www.blogger.com/profile/05962226861067081964noreply@blogger.com