Sample Lease Vs. Buy Analysis. Sample Lease Buy Analysis SCENARIO

SCENARIO Sample Lease Buy Analysis Lease vs. Buy is designed for a user/occupier to compare the costs of ownership with the costs of leasing. In eit...
Author: Cecil Cook
48 downloads 0 Views 119KB Size
SCENARIO

Sample Lease Buy Analysis

Lease vs. Buy is designed for a user/occupier to compare the costs of ownership with the costs of leasing. In either event, at the end of the analysis term, if leasing you would assume you will move, so if buying, you need to also assume you will move and sell the property. In this example two different properties are being compared, one that is available for lease and one that can be purchased. The Mgmt Summary and Key Assumptions reports show the comparison and the differences. Financing for the Purchased property includes a Balloon Loan with the payment amortized over 30 years and the balloon payment due after 5 years. Typically in a lease vs. buy analysis, the key decision metric is when it becomes cheaper to Buy than Lease based on Cash Flow, either before or after taxes. (See graphs G - 1 and G 2). When the cumulative cost of Leasing exceeds the cumulative cost of Buying (called the crossover), then buying becomes the preferred route. Historically, the crossover (when buying becomes cheaper than leasing) occurs in years 6 through 8. Note: the crossover is dependent upon the rent, the purchase price and financing. From an Income Statement perspective, i.e. the annual tax impact that is reported to the IRS, purchasing is almost always cheaper than leasing because in leasing the rental cost is higher than the depreciation cost associated with purchasing (depreciation on the building is usually spread over 39 years). (See graphs G - 3 and G - 4).

To learn more about how our services will be of benefit to you please contact us at:

All Brokers Commercial Real Estate Services 3926 E Pima Tucson, Arizona 85712 520-770-9221 [email protected]

Sample Lease Vs. Buy Analysis

All Brokers Commercial Real Estate Services

Management Summary of Key Costs

MANAGEMENT SUMMARY - LEASE vs. BUY ANALYSIS Client: Leased Property: Purchased Property:

ABC Co. 253 Green Steet 48 Aubrey Way Compare different properties. Optional - include pictures

Leased Property 253 Green Steet

Comparison of Key Variables Analysis Period (in Months) Square Footage Purchase Price (including Construction Costs) Loans @85.0% (Less Fees) Net Down Payment (Purchase Cost - Loans less fees) Average Base Rent (or loan pmt.)/Month Average Base Rent (or loan pmt.)/Sq.Ft./Year

120 50,000

120 48,500

$77,651 $18.64

$8,287,438 $6,734,734 $1,552,703 $41,356 $10.23

$170.88/sf $138.86/sf $32.01/sf $0.85/sf

$9,873,245 $4,806,510 $5,066,736

$203.57/sf $99.10/sf $104.47/sf

$5,066,736 ($503,536) ($1,552,703) $3,010,497

$104.47/sf ($10.38)/sf ($32.01)/sf $62.07/sf

$1.55/sf

0 1,500 ( 100.0% ) ( 81.3% ) ( 18.7% ) $36,295 $8.40

Sale Analysis Sale Price (before selling costs) * Unamortized Principal Equity Before Sale Equity Before Sale Less Selling Expenses Less Down Payment Cash Gain (Loss) before Taxes

Compares the Cost

* Land and Building assumed to increase in value annually by 2.0% and 2.0% respectively.

Cash after sale and paying off loans.

PreTax - Tax Deductible Cost Comparison Year 1 Total Cost NPV @8% Average Annual Cost

$1,213,750 $14,383,516 $9,885,516 $1,438,352

Cash Flow - Annual Cost Comparison Leased Property PreTax AfterTax Cash Flow Cash Flow Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10

$1,099,364 $8,007,248 $6,221,086 $800,725 Compares Cash Flow - Before & After Tax, and the Difference! Purchased Property PreTax AfterTax PreTax Cash Flow Cash Flow Cash Flow

$1,663,750 $1,196,625 $1,303,372 $1,340,333 $1,378,349 $1,417,450 $1,457,668 $1,499,035 $1,541,584 $1,585,350

$1,238,938 $760,306 $829,692 $853,716 $878,427 $903,842 $929,984 $956,873 $984,530 $1,012,977

$2,551,565 $1,010,197 $1,021,830 $1,033,769 $2,190,040 $926,114 $939,018 $952,261 $965,852 ($3,583,399)

$2,166,788 $623,360 $632,972 $642,938 $1,797,293 $573,814 $584,255 $595,055 $606,228 ($3,398,755)

NPV @8% Avg./Year

$19.77 $28.77

$12.96 $18.70

$14.67 $16.51

$9.83 $9.95

Year 1 Total Cost NPV @8% Avg./Year

$1,663,750 $14,383,516 $9,885,516 $1,438,352

$1,238,938 $9,349,285 $6,479,586 $934,929

$2,551,565 $8,007,248 $7,116,089 $800,725

$2,166,788 $4,823,948 $4,766,022 $482,395

First Year of Purchase Crossover

($887,815) $186,428 $281,542 $306,564 ($811,691) $491,336 $518,650 $546,774 $575,732 $5,168,748

$114,386 $6,376,268 $3,664,431 $637,627

Difference (Lease - Purchase) Cumulative AfterTax Cash Flow ($887,815) ($701,388) ($419,846) ($113,282) ($924,973) ($433,637) $85,013 $631,787 $1,207,520 $6,376,268

$5.10 $12.26

($927,850) $136,946 $196,720 $210,779 ($918,867) $330,029 $345,729 $361,818 $378,302 $4,411,732

Cumulative ($927,850) ($790,904) ($594,184) ($383,405) ($1,302,272) ($972,243) ($626,514) ($264,696) $113,606 $4,525,338

$3.13 $8.75

($887,815) $6,376,268 $2,769,428 $637,627

($927,850) $4,525,338 $1,713,564 $452,534 Yr. 7

Yr. 9

(When the cumulative Purchase cost is less than the cumulative Lease cost.)

when Purchasing (the FUTURE sale price of the property where leasing and buying are equalCrossover based on equal AfterTax NPV's.) Sale Price Point of Indifference cheaper than Property Sale Price - Point of Indifference Assumptions: Loan 1 atbecomes 70.0% of Purchase CostLeasing $4,985,604 Requires Building Annual % Increase at -8.02% Land % @2.00% Loan 2 at 15.0% of Purchase Cost Conclusion: Buy property if you can sell it for more than amount above in 9/2015. Opportunity Cost at 5.00% Notes:

User defined - unlimited rows for notes/comments

Sale Price Point of Indifference

The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 4 of 19

Key Assumptions

KEY LEASE and PURCHASE ASSUMPTIONS Client: Leased Property: Purchased Property:

ABC Co. 253 Green Steet 48 Aubrey Way

Page A2 12Feb05 Revision 1.0 Lease Assumptions

KEY LEASE ASSUMPTIONS FINANCIAL ASSUMPTIONS Type of Business Entity (Beginning of Mo. Calc.) NPV Discount Rate Ordinary Income Tax Rate Capital Gains Tax Rate Recapture 1250 Depreciation Tax Rate RENT ASSUMPTIONS Commencement Date Termination Date Lease Term Rentable SF Base Rental Rate Type of Lease Months of Rent Abatement Landlord Construction Allowance ANNUAL % RENT INCREASES Increase @3% starting 10/06 based on FIXED AMOUNT RENT INCREASES Fixed Increase #1 Fixed Increase #2 Fixed Increase #3 Fixed Increase #4 Fixed Increase #5 Fixed Increase #6 Fixed Increase #7 Fixed Increase #8 Fixed Increase #9 Fixed Increase #10 OPERATING EXPENSES & TAXES Actual Op. Exp. & Taxes Base Year Op. Exp. & Taxes Annual % Increase Pass through costs start CONSTRUCTION COSTS Interior Fit-up Contingency % Landlord Construction Allowance Net Cost to the Tenant

KEY SALE ASSUMPTIONS SALE ASSUMPTIONS Land - compounded annually @2.00% Building* - compounded annually @2.00% Total Sale Price * Building with Construction Costs

Sale Assumptions SELLING EXPENSES Commissions @5.1% of sale price Spruce-up Other Contingency Total Selling Expenses

KEY PURCHASE ASSUMPTIONS

Purchase Assumptions

TERM FOR ANALYSIS Start Date Date Property Sold Holding Period

LLC 8.0% 35.0% 15.0% 25.0%

10 / 2005 9 / 2015 120 months

PROPERTY COST Land Description Building

10 / 2005 9 / 2015 120 months 50,000 $16.50 $/rsf/yr NNN 2 $10.00 $/rsf

1 lot 48,500 rsf $/rsf

Land Purchase Cost Building Purchase Cost Total Property Cost

$38.75 $116.25 $155.00

$1,879,375 $5,638,125 $7,517,500

25.0% 75.0% 100.0%

BUILDING COST with CONSTRUCTION Building Purchase Cost $116.25 Const. Improvements $12.00 Total Building Cost $128.25

$5,638,125 $582,000 $6,220,125

90.6% 9.4% 100.0%

$16.50

Costs can be in any currency - $, £, €, ¥, ect. Measurement can be in square feet or square meters.

OTHER PURCHASING COSTS Closing costs @2.5% of Purchase Cost * Legal Fees Other Contingency Total

Expense

Capital

$187,938

0% $187,938

* Purchase Cost (Land and Building, not Const. Costs)

TOTAL PURCHASE COST

Total Purchase Cost *

$170.88

$8,287,438

* Without Loan Fees, includes all Other Purchasing Costs & Construction

FINANCING First Loan from 10 / 2005 to 9 / 2035 $8.00 $/rsf/yr Loan Amount Loan % of Land, Bldg., Const. Cost (eff. 1/2006) Monthly Payment (360 month term) 2.5% Include Balloon 10/2005 Loan Fees @2.00% loans & payments Net Proceeds from Loan 50,000 rsf Unamortized Principal (due 9 / 2015) $20.00 $/rsf 0% Second Loan from 10 / 2005 to 9 / 2010 $10.00 $/rsf Loan Amount $500,000 Loan % of Land, Bldg., Const. Cost Monthly Payment (300 month term) Loan Fees @3.00% Net Proceeds from Loan $47.24 $2,290,948 Balloon Payment (due 9 / 2010) $156.34 $7,582,298 $203.57 $9,873,245 OPPORTUNITY COST Lost Interest Income based on

@ 6.5% $5,669,650 70.0% $35,836 (30 yrs.) $113,393 $5,556,257 $4,806,510 @ 10% $1,214,925 15.0% $11,040 (25 yrs.) $36,448 $1,178,477 $1,144,019

$1,052,703

Invested @5% from 10/2005 - 9/2015; AfterTax Interest compounded monthly.

$503,536

0% $503,536

OPERATING EXPENSES AND TAXES Operating Expenses & Taxes Annual % Increase Optional - Include Opportunity Cost in DATE PROPOSAL your analysis Analysis prepared by All Brokers Inc.

$7.75 $/rsf/yr 2.5% (eff. 1/2006) 5Feb05

The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

All Brokers Commercial Real Estate Services 520-770-9221

Sample Lease vs. Buy Analysis

Page 4 of 19

Sale Analysis for Taxes

SALE ANALYSIS Client: Purchased Property:

Page A3 12Feb05 Revision 1.0

ABC Co. 48 Aubrey Way

Sale Price Land Building Less Selling Costs (A) Net Selling Price

$2,290,948 $7,582,298 -$503,536

Purchase Price Land Building Construction Costs Other Costs - Capital (B) Total Cost of Purchase

$1,879,375 $5,638,125 $582,000 $187,938

Depreciation Booked Building Purchase Cost * Construction Costs * Other Costs - Capitalized * (C) Total Depreciation Adjustments

$1,445,673 $149,231 $48,189

(D) Adjusted Cost Basis

$9,369,710

$6,644,345

$6,644,345

$8,287,438

$1,643,093

(B - C)

* Depreciation Portion of Capital Gain Building Recapture Cost Recovery [Recapture IRS Section 1250 Depreciation] Building Purchase Cost Construction Costs Other Costs - Capitalized (E) Total subject to Recapture Loan Fees First Loan - Fees, Initial Cost Second Loan - Fees, Initial Cost

$9,369,710

$1,445,673 $149,231 $48,189 $1,643,093

$113,393 $36,448 $149,841

First Loan - Amount of Fees Amortized Second Loan - Amt. of Fees Amortized

$37,798 $36,448 $74,245

(F)

(G) (H) (I) (J) (K) (L)

Net Write-Off of Loan Fees (taxed at Regular Tax Rate)

$75,595

Capital Gain (A - D) Taxable Capital Gain at the Capital Gains Tax Rate (A - D - E) Capital Gains Tax @ 15% (H x % x -1) Recapture Section IRS 1250 Depreciation Tax @ 25% (E x % x -1) Net Write-Off of Loan Fees @35% (F x %) After Tax Profit (Loss) (G + I + J + K)

Includes Cost Recovery / Recapture 1250 Depreciation for LLC's and Sole Proprietorships

$2,725,365 $1,082,272 -$162,341 -$410,773 $26,458

-$162,341 -$410,773 $26,458 $2,178,710

Sale Analysis on a Tax Basis used for computing the Tax Impact after Selling the property

The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease Vs. Buy Analysis

All Brokers 520-770-9221

Page 5 of 19

Financial Summary & Comparison of Key Costs

FINANCIAL SUMMARY Client: Leased Property: Purchased Property:

ABC Co. 253 Green Steet 48 Aubrey Way

Page 1 12Feb05 Revision 1.0

Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

Year Dates

10/05-9/06

10/06-9/07

10/07-9/08

10/08-9/09

10/09-9/10

10/10-9/11

10/11-9/12

10/12-9/13

10/13-9/14

10/14-9/15

Months Each Year

12 12 Lease Analysis: Cost Cash Flow PreTax NPV 756,250 778,938 AfterTax NPV 50,000 50,000 407,500 417,688 1,213,750 1,246,625

12

12

12

12

12

12

12

12

Year

(analysis starts 10 / 2005)

LEASE ANALYSIS COST (Tax deductible expenses only) Rent Depreciation All Other Costs Total PreTax Cost

Taxes @ 35% 424,813 AfterTaxes 788,938 Before Tax NPV @ 8% After Tax Net Present Value Discounted @ 8% CASH FLOW PreTax Cost Depreciation Capital

1,213,750 (50,000) 500,000

CASH FLOW PreTax Cost w/o Sale Depreciation Purchase Costs - Capital & TI$ Sale Price Selling Expenses Loan(s) (less fees) Principal Reduction on Loan(s)

1,099,364 (175,379) 8,287,438

(6,734,734) 74,877

120

Can be extended for a 30 year analysis. 875,243 50,000 428,130 1,353,372

901,500 50,000 438,833 1,390,333

928,545 50,000 449,804 1,428,349

956,401 50,000 461,049 1,467,450

985,093 50,000 472,575 1,507,668

1,014,646 50,000 484,389 1,549,035

1,045,085 50,000 496,499 1,591,584

1,076,438 50,000 508,912 1,635,350

9,318,138 500,000 4,565,378 14,383,516

436,319 810,306

473,680 879,692

486,616 903,716

499,922 928,427

513,607 953,842

527,684 979,984

542,162 1,006,873

557,055 1,034,530

572,372 1,062,977

5,034,231 9,349,285 9,731,229 6,325,299

1,246,625 (50,000)

1,353,372 (50,000)

1,390,333 (50,000)

1,428,349 (50,000)

1,467,450 (50,000)

1,507,668 (50,000)

1,549,035 (50,000)

1,591,584 (50,000)

1,635,350 (50,000)

14,383,516 (500,000) 500,000

1,378,349 878,427

1,417,450 903,842

1,457,668 929,984

1,499,035 956,873

1,541,584 984,530

1,585,350 1,012,977

14,383,516 9,349,285 9,885,516 6,479,586

463,247 175,379 60,833 422,675 1,122,133

342,402 168,089 62,840 433,242 1,006,572

336,533 168,089 64,912 444,073 1,013,607

330,271 168,089 67,054 455,175 1,020,589

323,590 168,089 69,266 466,554 1,027,499

1,122,133

1,006,572

1,013,607

1,020,589

1,027,499

316,461 168,089 71,551 478,218 1,034,319 (1,082,272) (1,643,093) 75,595 (1,615,451)

4,028,681 1,717,338 620,970 4,290,029 10,657,018 (1,082,272) (1,643,093) 75,595 8,007,248 (3,729,956) 162,341 410,773 (26,458) 4,823,948 6,221,086 3,871,019

10,657,018 (1,717,338) 8,287,438 (9,873,245) 503,536 (784,205) 934,046

PreTax Cash Flow 1,663,750 1,196,625 1,303,372 1,340,333 AfterTax Cash Flow 1,238,938 760,306 829,692 853,716 Cash Flow -- Before Tax NPV @ 8% Purchase Analysis: Cash Flow -- AfterTax Net Present Value Discounted @ 8% Cost Cash Flow PreTax NPV PURCHASE ANALYSIS AfterTax NPV COST (Tax deductible expenses only) Interest Expense 487,636 482,187 476,328 470,026 Depreciation/Amortization 175,379 175,379 175,379 175,379 Opportunity Cost 53,426 55,189 57,009 58,890 All Other Costs 382,923 392,496 402,308 412,366 PreTax Cost without Sale 1,099,364 1,105,250 1,111,024 1,116,660 PreTax Capital (Gain)/Loss on Sale PreTax Deprec. Recapture 1250 Net Write-Off of Loan Fees Total PreTax Cost 1,099,364 1,105,250 1,111,024 1,116,660 Tax (w/o Sale) @ 35% (384,777) Capital Gains Tax on Sale @ 15% Depreciation Recapture Tax @ 25% Loan Fee Write-Off Taxed @ 35% AfterTaxes 714,586 Before Tax NPV @ 8% After Tax Net Present Value Discounted @ 8%

Total

(386,838)

(388,858)

(390,831)

(392,746)

(352,300)

(354,763)

(357,206)

(359,625)

718,413

722,166

725,829

729,386

654,272

658,845

663,383

667,874

(362,012) 162,341 410,773 (26,458) (1,430,807)

1,122,133 (175,379)

1,006,572 (168,089)

1,013,607 (168,089)

1,020,589 (168,089)

1,027,499 (168,089)

1,034,319 (168,089)

SUMMARY - Cash Flow associated with the Purchase and Sale of the property. 1,105,250 (175,379)

80,326

PreTax Cash Flow 2,551,565 1,010,197 AfterTax Cash Flow 2,166,788 623,360 Cash Flow -- Before Tax NPV @ 8% Cash Flow -- After Tax Net Present Value Discounted @ 8%

COMPARISON - Lease vs. Buy

1,111,024 (175,379)

86,185

1,116,660 (175,379)

92,487

1,144,019 99,266

1,021,830 1,033,769 2,190,040 632,972 642,938 1,797,293 Comparison (Annual & Cumulative differences): Cost PreTax Cash Flow AfterTax Cash Flow

93,499

99,761

106,443

926,114 573,814

939,018 584,255

952,261 595,055

965,852 606,228

(3,583,399) (3,398,755)

8,007,248 4,823,948 7,116,089 4,766,022

1,467,450 1,006,572 460,878 1,538,875

Lease - PreTax Cost Purchase - PreTax Cost Difference Cumulative Difference

1,213,750 1,099,364 114,386 114,386

1,246,625 1,105,250 141,375 255,761

1,353,372 1,111,024 242,348 498,109

1,390,333 1,116,660 273,672 771,782

1,507,668 1,013,607 494,061 2,032,936

1,549,035 1,020,589 528,447 2,561,382

1,591,584 1,027,499 564,085 3,125,468

1,635,350 (1,615,451) 3,250,800 6,376,268

14,383,516 8,007,248 6,376,268

Lease - PreTax Cash Flow Purchase - PreTax Cash Flow Difference Cumulative Difference

1,663,750 2,551,565 (887,815) (887,815)

1,196,625 1,010,197 186,428 (701,388)

1,303,372 1,021,830 281,542 (419,846)

1,340,333 1,378,349 1,417,450 1,457,668 1,033,769 2,190,040 926,114 939,018 306,564 (811,691) 491,336 518,650 (113,282) (924,973) (433,637) 85,013 Compares costs on a per square foot basis.

1,499,035 952,261 546,774 631,787

1,541,584 965,852 575,732 1,207,520

1,585,350 (3,583,399) 5,168,748 6,376,268

14,383,516 8,007,248 6,376,268

PreTax Cash Flow/sf - Leasing 50,000 sf; Purchasing 48,500 sf Lease PreTax Cash Flow/sf/yr $33.28 $23.93 Purchase PreTax Cash Flow/sf/yr $52.61 $20.83 Difference ($17.76) $3.73 Cumulative Difference ($17.76) ($14.03)

$26.07 $21.07 $5.63 ($8.40)

$29.15 $19.36 $10.37 $1.70

$29.98 $19.63 $10.94 $12.64

$30.83 $19.91 $11.51 $24.15

$31.71 ($73.88) $103.37 $127.53

$28.77 $16.51 $12.75

929,984 584,255 345,729 (626,514)

956,873 595,055 361,818 (264,696)

984,530 606,228 378,302 113,606

1,012,977 (3,398,755) 4,411,732 4,525,338

9,349,285 4,823,948 4,525,338

Lease - AfterTax Cash Flow Purchase - AfterTax Cash Flow Difference Cumulative Difference

1,238,938 2,166,788 (927,850) (927,850)

760,306 623,360 136,946 (790,904)

829,692 632,972 196,720 (594,184)

$26.81 $21.31 $6.13 ($2.27)

1,428,349 1,122,133 306,216 1,077,997

87,631

(9,873,245) 503,536 4,806,510 113,571

$27.57 $45.16 ($16.23) ($18.50)

$28.35 $19.10 $9.83 ($8.67)

853,716 878,427 642,938 1,797,293 210,779 (918,867) (383,405) (1,302,272)

903,842 573,814 330,029 (972,243)

NPV calculated starting 10 / 2005 (beginning of mo. payment) The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 6 of 19

Compares PreTax Cash Flow (a back-up report)

PRE TAX CASH FLOW Client: Leased Property: Purchased Property:

ABC Co. 253 Green Steet 48 Aubrey Way

Page B 12Feb05 Revision 1.0

Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

10/05-9/06

10/06-9/07

10/07-9/08

10/08-9/09

10/09-9/10

10/10-9/11

10/11-9/12

10/12-9/13

10/13-9/14

10/14-9/15

12

12

12

12

12

12

12

12

12

12

120

Base Rent Rent Abatement % Increase Total

825,000 (68,750)

825,000

825,000

825,000

825,000

825,000

825,000

825,000

825,000

756,250

825,000 (70,813) 24,750 778,938

50,243 875,243

76,500 901,500

103,545 928,545

131,401 956,401

160,093 985,093

189,646 1,014,646

220,085 1,045,085

251,438 1,076,438

8,250,000 (139,563) 1,207,700 9,318,138

Operating Expenses / Taxes

407,500

417,688

428,130

438,833

449,804

461,049

472,575

484,389

496,499

508,912

Construction Cost

500,000

(analysis starts 10 / 2005) Year Year Dates Months Each Year

Total

LEASE ANALYSIS 50,000 square feet

Total PreTax Cash Flow Cost / Sq.Ft. / Year Cash Flow - Before Tax NPV @ 8%

1,663,750 $33.28

4,565,378 500,000

1,196,625 $23.93

1,303,372 $26.07

1,340,333 $26.81

1,378,349 $27.57

1,417,450 $28.35

1,457,668 $29.15

1,499,035 $29.98

1,541,584 $30.83

1,585,350 $31.71

14,383,516 $28.77 9,885,516

PURCHASE ANALYSIS 48,500 square feet Land - Purchase Building - Purchase Purchase - Other Capital Total

1,879,375 5,638,125 187,938 7,705,438

0

0

0

0

0

0

0

0

0

1,879,375 5,638,125 187,938 7,705,438

Operating Expenses / Taxes Opportunity Cost Total

382,923 53,426 436,349

392,496 55,189 447,685

402,308 57,009 459,317

412,366 58,890 471,256

422,675 60,833 483,508

433,242 62,840 496,081

444,073 64,912 508,985

455,175 67,054 522,229

466,554 69,266 535,820

478,218 71,551 549,769

4,290,029 620,970 4,910,999

Interest Expense - 1st Loan Interest Expense - 2nd Loan Total

366,661 120,975 487,636

362,417 119,770 482,187

357,889 118,439 476,328

353,057 116,969 470,026

347,902 115,344 463,247

342,402

336,533

330,271

323,590

316,461

342,402

336,533

330,271

323,590

316,461

3,437,185 591,496 4,028,681

67,615

72,144

76,975

87,631

93,499

99,761

106,443

4,806,510 113,571

12,711 80,326

14,042 86,185

15,512 92,487

82,130 1,144,019 17,136 1,243,286

87,631

93,499

99,761

106,443

4,920,081

0

0

0

0

0

0

0

0

0

(9,873,245) 503,536 (9,369,710)

(9,873,245) 503,536 (9,369,710)

1,969,565 $39.39

1,010,197 $20.20

1,021,830 $20.44

1,033,769 $20.68

2,190,040 $43.80

926,114 $18.52

939,018 $18.78

952,261 $19.05

965,852 $19.32

(3,583,399) ($71.67)

7,425,248 $14.85 7,116,089

First Loan, less fees First Loan - Principle Payment Second Loan, less fees Second Loan - Principle Payment Total

(5,556,257) 63,371 (1,178,477) 11,506 (6,659,857)

Cash From Sale Selling Expenses Total Total Cash Flow Cost / Sq.Ft. / Year Cash Flow - Before Tax NPV @ 8%

(749,747) 863,140 (34,458) 70,906 149,841

Shows the difference for Lease vs. Buy on a PreTax Cash Flow basis

COMPARISON: Lease - Buy Cost / Sq.Ft. Lease - PreTax Cash Flow Purchase - PreTax Cash Flow Difference Cumulative Difference

($6.12) 1,663,750 1,969,565 (305,815) (305,815)

$3.73

$5.63

$6.13

1,196,625 1,010,197

1,303,372 1,021,830

1,340,333 1,033,769

281,542 162,154

306,564 468,718

186,428 (119,388)

($16.23) 1,378,349 2,190,040 (811,691) (342,973)

$9.83

$10.37

$10.94

$11.51

1,417,450 926,114

1,457,668 939,018

1,499,035 952,261

1,541,584 965,852

1,585,350 (3,583,399)

$103.37

14,383,516 7,425,248

$13.92

491,336 148,363

518,650 667,013

546,774 1,213,787

575,732 1,789,520

5,168,748 6,958,268

6,958,268

NPV calculated starting 10 / 2005 (beginning of mo. payment) The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 7 of 19

Compares PreTax Cash Flow (a back-up report)

LEASE vs. BUY ANALYSIS Client: Leased Property: Purchased Property:

ABC Co. 253 Green Steet 48 Aubrey Way

(analysis starts 10 / 2005) Year Year Dates Months Each Year

Worksheet 12Feb05 Revision 1.0

Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

10/05-9/06

10/06-9/07

10/07-9/08

10/08-9/09

10/09-9/10

10/10-9/11

10/11-9/12

10/12-9/13

10/13-9/14

10/14-9/15

Total

12

12

12

12

12

12

12

12

12

12

120

Annual Total Cumulative Total Present Value @ 8%

1,213,750 1,213,750 1,123,843

1,246,625 2,460,375 1,068,780

1,353,372 3,813,747 1,074,350

1,390,333 5,204,080 1,021,936

1,428,349 6,632,428 972,110

1,467,450 8,099,878 924,742

1,507,668 9,607,547 879,710

1,549,035 11,156,582 836,896

1,591,584 12,748,166 796,189

1,635,350 14,383,516 757,483

14,383,516

Purchase

Annual Total Cumulative Total Present Value @ 8%

1,099,364 1,099,364 1,017,929

1,105,250 2,204,614 947,574

1,111,024 3,315,638 881,967

1,116,660 4,432,298 820,779

1,122,133 5,554,431 763,705

1,006,572 6,561,003 634,311

1,013,607 7,574,611 591,430

1,020,589 8,595,200 551,392

1,027,499 9,622,699 514,005

(1,615,451) 8,007,248 (748,266)

8,007,248

Difference

Annual Total Cumulative Total Present Value @ 8%

114,386 114,386 105,913

141,375 255,761 121,206

242,348 498,109 192,384

273,672 771,782 201,157

306,216 1,077,997 208,405

460,878 1,538,875 290,431

494,061 2,032,936 288,280

528,447 2,561,382 285,503

564,085 3,125,468 282,183

3,250,800 6,376,268 1,505,750

6,376,268

Annual Total Cumulative Total

788,938 788,938

810,306 1,599,244

879,692 2,478,936

903,716 3,382,652

928,427 4,311,078

953,842 5,264,921

979,984 6,244,905

1,006,873 7,251,778

1,034,530 8,286,308

1,062,977 9,349,285

9,349,285

Purchase

Annual Total Cumulative Total

714,586 714,586

718,413 1,432,999

722,166 2,155,165

725,829 2,880,994

729,386 3,610,380

654,272 4,264,652

658,845 4,923,497

663,383 5,586,880

667,874 6,254,754

(1,430,807) 4,823,948

4,823,948

Difference

Annual Total Cumulative Total

74,351 74,351

91,894 166,245

157,526 323,771

177,887 501,658

199,040 700,698

299,571 1,000,269

321,139 1,321,408

343,490 1,664,898

366,656 2,031,554

2,493,784 4,525,338

4,525,338

Annual Total Cumulative Total

1,663,750 1,663,750

1,196,625 2,860,375

1,303,372 4,163,747

1,340,333 5,504,080

1,378,349 6,882,428

1,417,450 8,299,878

1,457,668 9,757,547

1,499,035 11,256,582

1,541,584 12,798,166

1,585,350 14,383,516

14,383,516

Purchase

Annual Total Cumulative Total

2,551,565 2,551,565

1,010,197 3,561,763

1,021,830 4,583,593

1,033,769 5,617,362

2,190,040 7,807,402

926,114 8,733,515

939,018 9,672,533

952,261 10,624,794

965,852 11,590,647

(3,583,399) 8,007,248

8,007,248

Difference

Annual Total Cumulative Total

518,650 85,013

546,774 631,787

575,732 1,207,520

5,168,748 6,376,268

6,376,268

COST PreTax Lease

AfterTax Lease

9,456,039

5,974,826

3,481,212

CASH FLOW ANALYSIS PreTax Lease

AfterTax Lease

(887,815) (887,815)

186,428 (701,388)

281,542 (419,846)

306,564 (113,282)

(811,691) (924,973)

491,336 (433,637)

Annual Total Cumulative Total Present Value @ 8%

1,238,938 1,238,938 1,147,164

760,306 1,999,244 651,840

829,692 2,828,936 658,636

853,716 3,682,652 627,507

878,427 4,561,078 597,842

903,842 5,464,921 569,574

929,984 6,394,905 542,637

956,873 7,351,778 516,969

984,530 8,336,308 492,510

1,012,977 9,349,285 469,204

Purchase

Annual Total Cumulative Total Present Value @ 8%

2,166,788 2,166,788 2,006,285

623,360 2,790,148 534,431

632,972 3,423,120 502,474

642,938 4,066,057 472,578

1,797,293 5,863,351 1,223,208

573,814 6,437,164 361,600

584,255 7,021,420 340,907

595,055 7,616,475 321,490

606,228 8,222,702 303,265

(3,398,755) 4,823,948 (1,574,281)

4,823,948

Difference

Annual Total Cumulative Total Present Value @ 8%

4,411,732 4,525,338 2,043,486

4,525,338

(927,850) (927,850) (859,121)

136,946 (790,904) 117,409

196,720 (594,184) 156,163

210,779 (383,405) 154,929

(918,867) (1,302,272) (625,365)

330,029 (972,243) 207,974

345,729 (626,514) 201,730

361,818 (264,696) 195,479

378,302 113,606 189,245

9,349,285 6,273,884

4,491,956

1,781,928

Present value calculated using annual totals

Shows the difference for Lease vs. Buy on Used for the graphs - The Management Summary uses costs from each individual analysis. a PreTax Cash Flow basis The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 8 of 19

Lease vs. Buy - PreTax Cash Flow Comparison of the Annual and Cumulative Cost 16000000 14000000 12000000 10000000

PreTax Cash Flow - Graph shows Cumulative and Annual Costs. When lines cross, cost of Purchasing is cheaper than cost of Leasing

8000000 6000000 4000000 2000000 0 Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

-2000000 -4000000 -6000000

Intersection is when the cumulative total cost of Purchasing is cheaper than Leasing.

Lease - Annual Cost Purchase - Annual Cost Lease - Cumulative Annual Cost Purchase - Cumulative Annual Cost

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 9 of 19

Lease vs. Buy - AfterTax Cash Flow Comparison of the Annual and Cumulative Cost 10000000

8000000

6000000

AfterTax Cash Flow - Graph shows Cumulative and Annual Costs. When lines cross, cost of Purchasing is cheaper than cost of Leasing on an AfterTax Cash Flow basis.

4000000

2000000

0 Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

-2000000

-4000000

-6000000

Lease - Annual Cost Intersection is when the cumulative total cost of Purchasing is cheaper than Leasing.

Purchase - Annual Cost Lease - Cumulative Annual Cost Purchase - Cumulative Annual Cost

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 10 of 19

Lease vs. Buy - PreTax Tax Deductible Costs Comparison of the Annual and Cumulative Cost 16000000

14000000

12000000

10000000

Compares the costs that are tax deductible. Purchasing is typically cheaper since the primary cost is depreciation vs. rent

8000000

6000000

4000000

2000000

0 Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

-2000000

-4000000

Lease - Annual Cost Purchase - Annual Cost Lease - Cumulative Annual Cost Purchase - Cumulative Annual Cost

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 11 of 19

Lease vs. Buy - AfterTax Tax Deductible Costs Comparison of the Annual and Cumulative Cost 10000000

8000000

6000000

Compares AFTER TAXES the costs that are tax deductible. Purchasing is typically cheaper since the primary cost is depreciation vs. rent

4000000

2000000

0 Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

-2000000

Lease - Annual Cost Purchase - Annual Cost Lease - Cumulative Annual Cost Purchase - Cumulative Annual Cost

Sample Lease vs. Buy Analysis

All Brokers Commercial Real Estae Services 520-770-9221

Page 12 of 19

Lease vs. Buy - PreTax Tax Deductible Costs Comparison of the Present Value of the Annual Cost Compares the Present Value before taxes

1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

-200,000 -400,000 -600,000 -800,000

Lease

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Purchase

Page 13 of 19

Lease vs. Buy - AfterTax Cash Flow Comparison of the Present Value of the Annual Cost 2,500,000

2,000,000

Compares the Present Value after taxes

1,500,000

1,000,000

500,000

0 Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

-500,000

-1,000,000

-1,500,000

-2,000,000

Lease

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Purchase

Page 14 of 19

Detailed Lease Analysis (a back-up report)

LEASE ANALYSIS Client: Leased Property:

Page 1A 12Feb05 Revision 1.0

ABC Co. 253 Green Steet

(analysis starts 10 / 2005) Year Year Dates Months Leased Each Year Months of Free Rent

Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

10/05-9/06

10/06-9/07

10/07-9/08

10/08-9/09

10/09-9/10

10/10-9/11

10/11-9/12

10/12-9/13

10/13-9/14

10/14-9/15

12

12

12

12

12

12

12

12

12

12

1

1A Backup Report. Detailed listing of Costs and

Total 120 2

Cash Flow associated with Leasing that are summarized on the Financial Summary. COST (Tax Deductible Expenses Only) Base Rent Rent Abatement % Increase Total

825,000 -68,750

Operating Expenses / Taxes

825,000

825,000

825,000

825,000

825,000

825,000

825,000

825,000

756,250

825,000 -70,813 24,750 778,938

50,243 875,243

76,500 901,500

103,545 928,545

131,401 956,401

160,093 985,093

189,646 1,014,646

220,085 1,045,085

251,438 1,076,438

8,250,000 -139,563 1,207,700 9,318,138

407,500

417,688

428,130

438,833

449,804

461,049

472,575

484,389

496,499

508,912

4,565,378

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

500,000

1,213,750 424,813 788,938

1,246,625 436,319 810,306

1,353,372 473,680 879,692

1,390,333 486,616 903,716

1,428,349 499,922 928,427

1,467,450 513,607 953,842

1,507,668 527,684 979,984

1,549,035 542,162 1,006,873

1,591,584 557,055 1,034,530

1,635,350 572,372 1,062,977

13,383,516 5,034,231 9,349,285

Depreciation Total PreTax Cost Taxes @ 35% AfterTax Cost

Before Tax NPV @ 8% After Tax Net Present Value Discounted @ 8%

9,731,229 6,325,299

CASH FLOW Total PreTax Cost

1,213,750

1,246,625

1,353,372

1,390,333

1,428,349

1,467,450

1,507,668

1,549,035

1,591,584

1,635,350

13,383,516

Depreciation Construction Cost

-50,000

-50,000

-50,000

-50,000

-50,000

-50,000

-50,000

-50,000

-50,000

-50,000

-500,000

Capital Construction Cost

500,000

PreTax Cash Flow AfterTax Cash Flow

1,663,750 1,238,938

500,000 1,196,625 760,306

1,303,372 829,692

1,340,333 853,716

1,378,349 878,427

1,417,450 903,842

1,457,668 929,984

1,499,035 956,873

Cash Flow -- Before Tax NPV @ 8% Cash Flow -- After Tax Net Present Value Discounted @ 8%

1,541,584 984,530

1,585,350 1,012,977

14,383,516 9,349,285 9,885,516 6,479,586

NPV calculated starting 10 / 2005 (beginning of mo. payment)

The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Anaylsis

All Brokers 520-770-9221

Page 15 of 19

Detailed Purchase Analysis (a back-up report)

PURCHASE ANALYSIS Client: Purchased Property:

Page 1B 12Feb05 Revision 1.0

ABC Co. 48 Aubrey Way

(analysis starts 10 / 2005) Year Year Dates Months Each Year

Yr. 1

Yr. 2

Yr. 3

Yr. 4

Yr. 5

Yr. 6

Yr. 7

Yr. 8

Yr. 9

Yr. 10

10/05-9/06

10/06-9/07

10/07-9/08

10/08-9/09

10/09-9/10

10/10-9/11

10/11-9/12

10/12-9/13

10/13-9/14

10/14-9/15

Total

12

12

12

12

12

12

12

12

12

12

120

Operating Expenses / Taxes Opportunity Cost Total

382,923 53,426 436,349

392,496 55,189 447,685

402,308 57,009 459,317

412,366 58,890 471,256

422,675 60,833 483,508

433,242 62,840 496,081

444,073 64,912 508,985

455,175 67,054 522,229

466,554 69,266 535,820

478,218 71,551 549,769

4,290,029 620,970 4,910,999

Interest Expense - First Loan Interest Expense - Second Loan

366,661 120,975

362,417 119,770

357,889 118,439

353,057 116,969

347,902 115,344

342,402

336,533

330,271

323,590

316,461

3,437,185 591,496

Depreciation/Amortization

175,379

175,379

175,379

175,379

175,379

168,089

168,089

168,089

168,089

168,089

1,717,338

PreTax Cost without Sale PreTax Capital (Gain)/Loss on Sale PreTax Deprec. Recapture 1250 Net Write-Off of Loan Fees

1,099,364

1,105,250

1,111,024

1,116,660

1,122,133

1,006,572

1,013,607

1,020,589

1,027,499

1,034,319 -1,082,272 -1,643,093 75,595

10,657,018 -1,082,272 -1,643,093 75,595

PreTax Cost (total) Tax (w/o Sale) @ 35% Capital Gains Tax on Sale @ 15% Depreciation Recapture Tax @ 25% Loan Fee Write-Off Taxed @ 35% AfterTax Cost

1,099,364 -384,777

1,105,250 -386,838

1,111,024 -388,858

1,116,660 -390,831

1,122,133 -392,746

1,006,572 -352,300

1,013,607 -354,763

1,020,589 -357,206

1,027,499 -359,625

A Backup Report. Detailed listing of Costs and Cash Flow associated with Purchasing that are Financial Summary. 718,413 summarized 722,166 on the 725,829 729,386 654,272

658,845

663,383

667,874

-1,615,451 -362,012 162,341 410,773 -26,458 -1,430,807

8,007,248 -3,729,956 162,341 410,773 -26,458 4,823,948

COST (Tax Deductible Expenses Only)

714,586

Before Tax NPV @ 8% After Tax Net Present Value Discounted @ 8%

6,221,086 3,871,019

CASH FLOW PreTax Cost without Sale

1,099,364

1,105,250

1,111,024

1,116,660

1,122,133

1,006,572

1,013,607

1,020,589

1,027,499

1,034,319

10,657,018

1,879,375 5,638,125 582,000 187,938 8,287,438

Detailed listing of Financing

Capital Land - Purchase Building - Purchase Building - Const. Costs Purchase - Other Capital Total Capital

1,879,375 5,638,125 582,000 187,938 8,287,438

0

0

0

0

0

0

0

0

0

Depreciation / Amortization Building - Purchase Building - Const. Costs Purchase - Other Costs Fees - 1st Loan Fees - 2nd Loan Total

-144,567 -14,923 -4,819 -3,780 -7,290 -175,379

-144,567 -14,923 -4,819 -3,780 -7,290 -175,379

-144,567 -14,923 -4,819 -3,780 -7,290 -175,379

-144,567 -14,923 -4,819 -3,780 -7,290 -175,379

-144,567 -14,923 -4,819 -3,780 -7,290 -175,379

-144,567 -14,923 -4,819 -3,780

-144,567 -14,923 -4,819 -3,780

-144,567 -14,923 -4,819 -3,780

-144,567 -14,923 -4,819 -3,780

-144,567 -14,923 -4,819 -3,780

-168,089

-168,089

-168,089

-168,089

-168,089

67,615

72,144

76,975

87,631

93,499

99,761

106,443

4,806,510 113,571

12,711 80,326

14,042 86,185

15,512 92,487

82,130 1,144,019 17,136 1,243,286

87,631

93,499

99,761

106,443

Financing First Loan, less fees First Loan - Principle Payment Second Loan, less fees Second Loan - Principle Payment Total Financing

-5,556,257 63,371 -1,178,477 11,506 -6,659,857

Cash from Sale Selling Expenses PreTax Cash Flow AfterTax Cash Flow

Ballon Payment on 2nd loan 2,551,565 2,166,788

1,010,197 623,360

1,021,830 632,972

1,033,769 642,938

2,190,040 1,797,293

926,114 573,814

939,018 584,255

952,261 595,055

Cash Flow -- Before Tax NPV @ 8% Cash Flow -- After Tax Net Present Value Discounted @ 8%

965,852 606,228

-1,445,673 -149,231 -48,189 -37,798 -36,448 -1,717,338

4,920,081

-749,747 863,140 -34,458 70,906 149,841

-9,873,245 503,536

-9,873,245 503,536

-3,583,399 -3,398,755

8,007,248 4,823,948 7,116,089 4,766,022

NPV calculated starting 10 / 2005 (beginning of mo. payment) The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 15 of 19

Lease Assumptions Printout (a back-up report)

LEASE ASSUMPTIONS Client: Leased Property:

Page 2 12Feb05 Revision 1.0

ABC Co. 253 Green Steet

FINANCIAL ASSUMPTIONS Type of Business Entity (Beginning of Mo. Calc.) NPV Discount Rate Ordinary Income Tax Rate Capital Gains Tax Rate RENT ASSUMPTIONS Commencement Date Termination Date Lease Term Rentable SF Base Rental Rate Type of Lease Months of Rent Abatement Landlord Construction Allowance ANNUAL PERCENTAGE RENT INCREASES Increase @3% starting 10/06 based on

LLC 8.0% 35.0% 15.0%

10 / 2005 9 / 2015 120 months 50,000 $16.50 $/rsf/yr NNN 2 $10.00 $/rsf

$16.50

FIXED AMOUNT RENT INCREASES Fixed Increase #1 Fixed Increase #2 Fixed Increase #3 Fixed Increase #4 Fixed Increase #5 Fixed Increase #6 Fixed Increase #7 Fixed Increase #8 Fixed Increase #9 Fixed Increase #10 KEY RATIOS Average PreTax Cost / RSF / Year Average AfterTax Cost / RSF / Year PROPOSAL DATE Analysis prepared by All Brokers Inc.

OPERATING EXPENSES & TAXES Actual Op. Exp. & Taxes Base Year Op. Exp. & Taxes Annual % Increase Pass through costs start

$8.00 $/rsf/yr 2.5% (eff. 1/2006) 10/2005

OTHER MONTHLY EXPENSES Parking Descriptions can be changed After Hrs. HVAC include other costs in addition to Storage Space the rent and operating expenses. Other Total Monthly Expense Annual % Increase OTHER LEASING COSTS Consultants / Legal Fees Furniture Voice and Data Moving Other Contingency % Total Cost

Expense

Tenant Improvement Costs

CONSTRUCTION COSTS Interior Fit-up Contingency % Landlord Construction Allowance Net Cost to the Tenant

50,000 rsf $20.00 $/rsf 0% $10.00 $/rsf $500,000

DEPRECIATION ASSUMPTIONS Construction Additional Costs $28.77 $/rsf/yr $18.70 $/rsf/yr

Capital

Months

120

Write-Off *

yes

* Write-off remaining depreciation at the end of the analysis period.

5Feb05

A Backup Report, key assumptions are on the Key Assumptions report.

The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 17 of 19

Purchase Assumptions Printout (a back-up report) Complete assumptions printout for Purchasing. A Backup Report, key assumptions are on the Key Your Client's logo here! Assumptions report.

PURCHASE ASSUMPTIONS Client: Purchased Property:

ABC Co. 48 Aubrey Way

FINANCIAL ASSUMPTIONS Type of Business Entity (Beginning of Mo. Calc.) NPV Discount Rate Ordinary Income Tax Rate Capital Gains Tax Rate Recapture 1250 Depreciation Tax Rate

OPERATING EXPENSES AND TAXES Operating Expenses & Taxes Annual % Increase

LLC 8.0% 35.0% 15.0% 25.0%

TERM FOR ANALYSIS Start Date Date Property Sold Holding Period

1 lot 48,500 rsf $/rsf

Land Purchase Cost Building Purchase Cost Total Property Cost

$38.75 $116.25 $155.00

$1,879,375 $5,638,125 $7,517,500

25.0% 75.0% 100.0%

BUILDING COST with CONSTRUCTION Building Purchase Cost $116.25 Const. Improvements $12.00 Total Building Cost $128.25

$5,638,125 $582,000 $6,220,125

90.6% 9.4% 100.0%

OTHER PURCHASING COSTS Closing costs @2.5% of Purchase Cost * Legal Fees Other Contingency Total

Expense

Capital

0% $187,938

TOTAL PURCHASE COST $170.88

$8,287,438

* Without Loan Fees, includes all Other Purchasing Costs & Construction

Financing FINANCING First Loan from 10 / 2005 to 9 / 2035 Loan Amount Loan % of Land, Bldg., Const. Cost Monthly Payment (360 month term) Loan Fees @2.00% Net Proceeds from Loan Unamortized Principal (due 9 / 2015) Second Loan from 10 / 2005 to 9 / 2010 Loan Amount Loan % of Land, Bldg., Const. Cost Monthly Payment (300 month term) Loan Fees @3.00% Net Proceeds from Loan Balloon Payment (due 9 / 2010) OPPORTUNITY COST - Lost Interest Income Calculations based on

ADDITIONAL COSTS Furniture Voice and Data Moving Other Other Contingency % Total Cost

Expense

Capital

SPECIAL EXPENSES / CREDITS Special Tax Credits Annual increase (or decrease) in Other the value of Land & Building Other Depreciation Write-off Depreciation Carry-over

$187,938

* Purchase Cost (Land and Building, not Const. Costs)

Total Purchase Cost *

$7.75 $/rsf/yr 2.5% (eff. 1/2006)

OTHER MONTHLY COSTS Insurance Parking Storage Space Other Total Other Monthly Costs Annual % Increase

10 / 2005 9 / 2015 120 months

PROPERTY COST Land Description Building

Page 3 12Feb05 Revision 1.0

@ 6.5% $5,669,650 70.0% $35,836 (30 yrs.) $113,393 $5,556,257 $4,806,510

SALE ASSUMPTIONS Land - compounded annually @2.00% Building* - compounded annually @2.00% Total Sale Price

$47.24 $156.34 $203.57

$2,290,948 $7,582,298 $9,873,245

* Building with Construction Costs

SELLING EXPENSES Commissions @5.1% of sale price Spruce-up Other Contingency Total Selling Expenses

$503,536

0% $503,536

DEPRECIATION ASSUMPTIONS Building - Purchase Cost Building - Construction Costs Other Purchase Costs Loan Points - Amortized over the life of the loan Additional Costs

Months

Write-Off *

468 468 468

60 * Write-off remaining depreciation at the end of the analysis period. @ 10% Balloon Loan $1,214,925 15.0% KEY RATIOS Average PreTax Cost / RSF / Year $16.51 $/rsf/yr $11,040 (25 yrs.) $36,448 Average AfterTax Cost / RSF / Year $9.95 $/rsf/yr $1,178,477 $1,144,019 5Feb05 PROPOSAL DATE Analysis prepared by All Brokers, Inc

n/a n/a n/a yes

Opportunity Cost $1,052,703

Invested @5% from 10/2005 - 9/2015; AfterTax Interest compounded monthly. The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample Lease vs. Buy Analysis

All Brokers 520-770-9221

Page 18 of 19

Optional Report Showing Various Calculations

UNIT METRICS REPORT Client: Leased Property: Purchased Property:

ABC Co. 253 Green Steet 48 Aubrey Way

Page 4 12Feb05 Revision 1.0

Present Value PRESENT VALUE - calculations based on calculations based on 8% discount rate calculated monthly calculations on a $/sq.ft. basis. starting 10 / 2005 (beginning of mo. payment) NPV Occupancy cost - $/rsf/year Rentable SF PreTax Cash Flow AfterTax Cash Flow PreTax Cost AfterTax Cost NPV Rent - $/rsf/year Base Rent Operating Expenses/Taxes Gross Rent

KEY RATIOS & METRICS - $/rsf/year Average PreTax Cost / RSF / Year Average AfterTax Cost / RSF / Year

Lease

Purchase

50,000 $19.77 $12.96 $19.46 $12.65

48,500 $14.67 $9.83 $12.83 $7.98

$16.51 $9.95

LEASE INCOME FROM OWNED PROPERTY Commencement Date Termination Date Term of Lease Optional - include income Type of Lease from leasing out part of the Rentable SF owned property. Base Rental Rate Months of Rent Abatement Annual % Rent Increase Fixed Increase #1 Fixed Increase #2 Fixed Increase #3 Actual Op. Exp. & Taxes Base Year Op. Exp. & Taxes Op.Exp. & Tax Annual % Increase

LEASE INCOME - OTHER COSTS Commissions @0% of rent Construction Costs Advertising Legal Fees Other Contingency % Total Cost

Expense

Purchase

Sale

$1,879,375 $6,220,125 $337,778 $8,437,278 $173.96

$2,290,948 $7,582,298 -$503,536 $9,369,710 $193.19 $932,432 $19.23

ANNUITY - calculations based on 8% discount rate calculated monthly starting 10/2005 (beginning of mo. payment)

$12.56 $6.21 $18.77

$28.77 $18.70

GROSS SALE ANALYSIS Land Building (includes Const.) Loan Fees and Other Costs Total $/rsf Profit / (Loss) $/rsf

Occupancy cost - $/rsf/year PreTax Cash Flow AfterTax Cash Flow PreTax Cost AfterTax Cost

Lease

Purchase

$28.41 $18.62 $27.96 $18.18

$21.08 $14.12 $18.43 $11.47

Rent - $/rsf/year Base Rent Operating Expenses/Taxes Gross Rent

$18.05 $8.92 $26.97

Annuity calculations are a method to compare unit costs for different lease terms. The present value of the cost is determined and then amortized over the term at the discount rate.

Capital

The information contained herein has been given to us by sources we deem reliable, but we do not guarantee it. All data should be verified.

Sample reports - Buy

Page 19 of 19