Lease Rate Worksheet For Commercial Real Estate

Document Sample
Lease Rate Worksheet  For Commercial Real Estate
Your Logo Here









Your Logo Here

Your Tenant Here

Office Building

NNN LEASE

Total Square Footage: 30,505

10 Year Deal w/ Free Rent

Operating

Base Rent Operating

Yr Period Starting Period Ending Base Rent / SF Expenses Total Annually Total Monthly

Annually Expenses / SF

Annually

12/1/2010 5/31/2011 $0.00 $0 $8.33 $127,053 $127,053 $21,176

1

6/1/2011 11/30/2011 $12.50 $190,656 $8.33 $127,053 $317,710 $52,952

2 12/1/2011 11/30/2012 $12.50 $381,313 $8.50 $259,189 $640,501 $53,375

3 12/1/2012 11/30/2013 $12.50 $381,313 $8.67 $264,373 $645,685 $53,807

4 12/1/2013 11/30/2014 $13.00 $396,565 $8.84 $269,660 $666,225 $55,519

5 12/1/2014 11/30/2015 $13.00 $396,565 $9.02 $275,053 $671,618 $55,968

6 12/1/2015 11/30/2016 $13.00 $396,565 $9.20 $280,554 $677,119 $56,427

7 12/1/2016 11/30/2017 $14.00 $427,070 $9.38 $286,165 $713,235 $59,436

8 12/1/2017 11/30/2018 $15.00 $457,575 $9.57 $291,889 $749,464 $62,455

9 12/1/2018 11/30/2019 $16.00 $488,080 $9.76 $297,726 $785,806 $65,484

10 12/1/2019 11/30/2020 $17.00 $518,585 $9.96 $303,681 $822,266 $68,522

Total $4,034,286 $2,782,397 $6,816,683



Average

Effective Lease Effective Lease Effective

Total Lease Term Cost $6,816,683 $22.35 $13.23 $56,806

Rate / SF Gross Rate / SF NNN Monthly

Payment

Your Logo Here



XYZ TENANT

1234 Park Lane

Total square footage: 30,000





Operating

Base Rent Operating

Yr Period Starting Period Ending Base Rent / SF Expenses Total Annually Total Monthly

Annually Expenses / SF

Annually

12/1/2010 5/31/2011 $0.00 $0 $9.65 $144,750 $144,750 $24,125

1

6/1/2011 12/31/2011 $5.00 $75,000 $9.65 $144,750 $219,750 $36,625

2 1/1/2012 12/31/2012 $11.00 $330,000 $9.84 $295,290 $625,290 $52,108

3 1/1/2013 12/31/2013 $12.50 $375,000 $10.04 $301,196 $676,196 $56,350

4 1/1/2014 12/31/2014 $13.00 $390,000 $10.24 $307,220 $697,220 $58,102

5 1/1/2015 12/31/2015 $13.50 $405,000 $10.45 $313,364 $718,364 $59,864

6 1/1/2016 12/31/2016 $14.00 $420,000 $10.65 $319,631 $739,631 $61,636

7 1/1/2017 12/31/2017 $14.00 $420,000 $10.87 $326,024 $746,024 $62,169

8 1/1/2018 12/31/2018 $14.50 $435,000 $11.08 $332,545 $767,545 $63,962

9 1/1/2019 12/31/2019 $15.00 $450,000 $11.31 $339,195 $789,195 $65,766

10 1/1/2020 12/31/2020 $15.50 $465,000 $11.53 $345,979 $810,979 $67,582

6 Mo 1/1/2021 6/30/2021 $16.00 $240,000 $11.76 $176,449 $416,449 $69,408

Total $4,005,000 $3,346,394 $7,351,394



Average

Effective Lease Effective Lease Effective

Total Lease term Cost $7,351,394 $23.34 $12.71 $58,344

Rate / SF Gross Rate / SF NNN Monthly

Payment

1ST 8 YEARS: AVERAGE MONTHLY $55,571



*Operating Expenses are including utilities and janitorial.

YOUR LOGO

XYZ TENANT

1234 Park Lane

Total square footage: 30,000





Operati

By registering with docstoc.com you agree to our
privacy policy and terms of service

Successfully added document to cart!

Successfully added document to cart!