2011 cash flow evaluator

Cash Flow EvaluatorProperty Name

Address

City, State, Zip Code:

Property InformationProperty Type Residential

Commercial

Building Type:

Down Payment Goal:(check ALL that apply)

Financing Goal:(check ALL that apply)

Property Class:

Acquisition Information

Purchase Price $3,500,000$350,000 - Actual Down Payment 10%

$3,150,000 - Mortgages (enter info below)$0 - Buyer/Repair Credit

$105,000 + Loan Points 3%$175,000 + Closing Costs 5%

$0 + Other Acquisition Costs$630,000 = Initial Investment

Private Note Hard Money Private Lender PartnerGrants Gift Out of Pocket Other

Private Note Hard Money Private Lender Partner

Government Programs Other

Low-Rise (up to 7 stories above ground level)Mid-Rise (7-25 stories above ground level)High-Rise (25+ stories above ground level)

A B C

Retail Strip Big Box Power Center Nursing Home

Office Bldg Hotel Hospital Special Use

Single Family Multi-Unit (1-4 Units) Residential-Commercial (5+ Units)

Mobile Home Park

Self-Storage R&D Other

Financing Information / Assumptions

% of Asking Price100.0%

Initial Loan Periodic Payment1st $3,500,000 $23,632 12 6.5%

2nd $500,000 $4,544 12 10.0%3rd $300,000 $2,726 12 10.0%

Total Payments $30,902

Gross Rental Income CalculatorEnter GR (if already known):

Office / Retail / Warehouse Multi-Family / Apartments

Rentable Square Feet: Apartments # Units1000 Studios 83

1/1 17Average Annual Rent / Square Foot: 2/1 2

$0 2/2 52 3/1 12

Annual Total: $0 Other 6Total Units: 172

IncomeALL FIGURES ANNUAL $ Total $ Sq Ft.Gross Rental Income 750000 750.00 + Other Income (i.e. Laundry, etc.) 0Total Gross Rental Income 750000 - Vacancy & Credit Loss 5% 37500 38= GROSS OPERATING INCOME 712500 713

ExpensesALL FIGURES ANNUAL $ Total $ Sq Ft.Real Estate Property Taxes $0 0.00Supplemental Property Taxes (if any) $0 0.00Property Insurance $0 0.00Management $0 0.00Payroll $0 0.00 Expenses / Benefits 2.0% $0 0.00

Payments Per Year

Interest Rate

Taxes / Workers' Comp 2.0% $0 0.00Repairs and Maintenance: Materials $0 0.00 Labor $0 0.00Utilities: Phone $0 0.00 Gas $0 0.00 Electric $0 0.00 Water $0 0.00 Sewer $0 0.00Accounting and Legal $0 0.00Licenses and Permits $0 0.00Advertising $0 0.00Supplies $0 0.00Contract Services: Trash $0 0.00 Lawn Care $0 0.00 Landscaping $0 0.00 Snow Removal $0 0.00Misc $0 0.00 Other (or "Lump Sum") $100,000 Replacement Reserves 1.5% $10,688TOTAL OPERATING EXPENSES $110,688 110.69

Net IncomeNET OPERATING INCOME $601,813 - Annual Debt Service $370,822 - Funded Reserves $0 - Leasing Commissions $0 - Capital Additions $0

ANNUAL $230,990MONTHLY $19,249

Notes

= CASH FLOW BEFORE TAXES

Copyright © 2010 Monica Main

Lead Date Lead Source

Cash Flow Evaluator

$3,500

Per Unit $20,349

Price Per Square Foot

Partner Traditional MortgageOther

Partner Traditional Mortgage

Low-Rise (up to 7 stories above ground level)Mid-Rise (7-25 stories above ground level)

D

Nursing Home Medical Building

Special Use Industrial / Warehouse

Residential-Commercial (5+ Units)

25 $18,95825 $4,16725 $2,500

$750,000

Multi-Family / ApartmentsMonthly Rent Annual

Per Unit Rent$10 $9,960

$435 $88,740

$100 $7,200Total Rent: $105,900

% GOI % Op Exp0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%

Amortization Period (Years)

Interest Only Loan Payment

0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%0% 0%

16% 100%

DCR - BANK 2.122

CAP Rate 17.19%

The Speedy Price FinderProperty Name

Acquisition InformationAsking Price $ 3,500,000.00

Yearly Income InformationGross Rental Income $ 750,000.00

% Vacancy 5.0%Gross Operating Income $ 37,500.00

Yearly Expense InformationOperating Expenses $ 110,687.50

Net Operating Income (NOI) $ 601,812.50 Calculated Offer

Actual Cap Rate 17.2%Offer Price Based on Cap Rate $ -


Asking Price FinderRequirement $ 25,000 per $ 1,000,000

Asking Price Information $ 3,500,000 Asking Price $ 87,500 Required Cash FlowYour Information $ 9,239,608.83 Asking Price Supported by Your Cash Flow $ 230,990 Your Cash FlowDeltas $ - Asking Price Shortfall $ - Additional Cash Flow Required


Down Payment Assistance (DPA) Purchase Price: $3,500,000.00

------------------------------------------------------------------------------------------------------------------------------------------------------------------ Amount Needed for Down Payment:

DPA Fees: Other DPA Fees:

+ Total DPA:

------------------------------------------------------------------------------------------------------------------------------------------------------------------ Approximate Closing Costs: $350,000

------------------------------------------------------------------------------------------------------------------------------------------------------------------ Total Needed to Ask for a Buyer's Repair Credit:


Down Payment Assistance (DPA)85%

------------------------------------------------------------------------------------------------------------------------------------------------------------------$525,000

7%$2,500

____________________$564,250

------------------------------------------------------------------------------------------------------------------------------------------------------------------10%

------------------------------------------------------------------------------------------------------------------------------------------------------------------$914,250


Multi-Mortgage AmortizationMortgage Information

Mortgage 1st 2ndPrinciple $3,500,000 $500,000Interest 6.5% 10.0%

Term 25 25Payment $23,632 $4,544

Amoritization Information

1st Mortgage 2nd Mortgage

Interest Paid0 $3,500,000 $0 $500,000 $01 $3,495,326 $18,958 $499,623 $4,167 2 $3,490,627 $37,891 $499,243 $8,330 3 $3,485,902 $56,799 $498,860 $12,491 4 $3,481,152 $75,681 $498,474 $16,648 5 $3,476,376 $94,537 $498,084 $20,802 6 $3,471,574 $113,367 $497,691 $24,952 7 $3,466,746 $132,172 $497,295 $29,100 8 $3,461,892 $150,950 $496,896 $33,244 9 $3,457,012 $169,702 $496,493 $37,385

10 $3,452,105 $188,427 $496,087 $41,522 11 $3,447,172 $207,126 $495,678 $45,656 12 $3,442,212 $225,799 $495,265 $49,787 13 $3,437,225 $244,444 $494,849 $53,914 14 $3,432,211 $263,062 $494,429 $58,038 15 $3,427,170 $281,653 $494,006 $62,158 16 $3,422,101 $300,217 $493,579 $66,275 17 $3,417,005 $318,754 $493,148 $70,388 18 $3,411,882 $337,262 $492,714 $74,497 19 $3,406,731 $355,743 $492,277 $78,603 20 $3,401,551 $374,196 $491,836 $82,706 21 $3,396,344 $392,622 $491,391 $86,804 22 $3,391,109 $411,018 $490,942 $90,899 23 $3,385,845 $429,387 $490,490 $94,990 24 $3,380,553 $447,727 $490,034 $99,078 25 $3,375,232 $466,038 $489,574 $103,162 26 $3,369,882 $484,321 $489,110 $107,241 27 $3,364,503 $502,574 $488,643 $111,317 28 $3,359,096 $520,799 $488,171 $115,389 29 $3,353,658 $538,994 $487,696 $119,457 30 $3,348,192 $557,159 $487,216 $123,521 31 $3,342,696 $575,295 $486,733 $127,582 32 $3,337,170 $593,402 $486,246 $131,638 33 $3,331,614 $611,478 $485,754 $135,690 34 $3,326,028 $629,524 $485,259 $139,738 35 $3,320,411 $647,540 $484,759 $143,782 36 $3,314,765 $665,526 $484,255 $147,821

Payment Number

Remaining Balance

Remaining Balance

Interest Paid

37 $3,309,088 $683,481 $483,747 $151,857 38 $3,303,379 $701,405 $483,235 $155,888 39 $3,297,641 $719,298 $482,718 $159,915 40 $3,291,871 $737,161 $482,197 $163,937 41 $3,286,069 $754,991 $481,672 $167,956 42 $3,280,237 $772,791 $481,143 $171,970 43 $3,274,372 $790,559 $480,609 $175,979 44 $3,268,476 $808,295 $480,070 $179,984 45 $3,262,548 $825,999 $479,527 $183,985 46 $3,256,588 $843,672 $478,980 $187,981 47 $3,250,596 $861,311 $478,428 $191,972 48 $3,244,571 $878,919 $477,871 $195,959 49 $3,238,513 $896,494 $477,310 $199,942 50 $3,232,423 $914,035 $476,744 $203,919 51 $3,226,300 $931,544 $476,173 $207,892 52 $3,220,143 $949,020 $475,598 $211,860 53 $3,213,953 $966,463 $475,018 $215,824 54 $3,207,730 $983,872 $474,433 $219,782 55 $3,201,473 $1,001,247 $473,843 $223,736 56 $3,195,182 $1,018,588 $473,248 $227,684 57 $3,188,857 $1,035,895 $472,648 $231,628 58 $3,182,498 $1,053,168 $472,044 $235,567 59 $3,176,104 $1,070,407 $471,434 $239,500 60 $3,169,676 $1,087,611 $470,819 $243,429 61 $3,163,213 $1,104,780 $470,199 $247,353 62 $3,156,714 $1,121,914 $469,574 $251,271 63 $3,150,181 $1,139,013 $468,943 $255,184 64 $3,143,612 $1,156,076 $468,308 $259,092 65 $3,137,008 $1,173,104 $467,667 $262,994 66 $3,130,368 $1,190,096 $467,020 $266,892 67 $3,123,692 $1,207,052 $466,369 $270,783 68 $3,116,979 $1,223,972 $465,712 $274,670 69 $3,110,231 $1,240,856 $465,049 $278,551 70 $3,103,446 $1,257,703 $464,381 $282,426 71 $3,096,624 $1,274,513 $463,707 $286,296 72 $3,089,765 $1,291,287 $463,028 $290,160 73 $3,082,869 $1,308,023 $462,343 $294,019 74 $3,075,935 $1,324,722 $461,652 $297,872 75 $3,068,964 $1,341,383 $460,956 $301,719 76 $3,061,956 $1,358,007 $460,254 $305,560 77 $3,054,909 $1,374,592 $459,546 $309,396 78 $3,047,824 $1,391,140 $458,832 $313,225 79 $3,040,701 $1,407,649 $458,112 $317,049 80 $3,033,539 $1,424,119 $457,386 $320,866 81 $3,026,339 $1,440,551 $456,654 $324,678 82 $3,019,099 $1,456,944 $455,916 $328,483 83 $3,011,820 $1,473,297 $455,172 $332,283 84 $3,004,502 $1,489,611 $454,421 $336,076 85 $2,997,144 $1,505,886 $453,665 $339,863 86 $2,989,747 $1,522,120 $452,902 $343,643 87 $2,982,309 $1,538,315 $452,132 $347,417 88 $2,974,831 $1,554,469 $451,357 $351,185 89 $2,967,312 $1,570,582 $450,575 $354,946

90 $2,959,753 $1,586,655 $449,786 $358,701 91 $2,952,153 $1,602,687 $448,991 $362,449 92 $2,944,511 $1,618,678 $448,189 $366,191 93 $2,936,828 $1,634,628 $447,380 $369,926 94 $2,929,104 $1,650,535 $446,565 $373,654 95 $2,921,338 $1,666,401 $445,743 $377,375 96 $2,913,529 $1,682,225 $444,914 $381,090 97 $2,905,679 $1,698,007 $444,078 $384,798 98 $2,897,785 $1,713,746 $443,235 $388,498 99 $2,889,850 $1,729,442 $442,385 $392,192

100 $2,881,871 $1,745,096 $441,528 $395,878 101 $2,873,849 $1,760,706 $440,664 $399,558 102 $2,865,783 $1,776,273 $439,793 $403,230 103 $2,857,674 $1,791,796 $438,914 $406,895 104 $2,849,521 $1,807,275 $438,028 $410,552 105 $2,841,323 $1,822,709 $437,135 $414,203 106 $2,833,081 $1,838,100 $436,234 $417,846 107 $2,824,795 $1,853,446 $435,326 $421,481 108 $2,816,464 $1,868,747 $434,410 $425,109 109 $2,808,087 $1,884,003 $433,487 $428,729 110 $2,799,666 $1,899,213 $432,556 $432,341 111 $2,791,198 $1,914,378 $431,617 $435,946 112 $2,782,685 $1,929,497 $430,670 $439,542 113 $2,774,126 $1,944,570 $429,715 $443,131 114 $2,765,520 $1,959,596 $428,753 $446,712 115 $2,756,867 $1,974,576 $427,782 $450,285 116 $2,748,168 $1,989,509 $426,804 $453,850 117 $2,739,422 $2,004,395 $425,817 $457,407 118 $2,730,628 $2,019,234 $424,822 $460,955 119 $2,721,787 $2,034,025 $423,819 $464,495 120 $2,712,898 $2,048,768 $422,807 $468,027 121 $2,703,960 $2,063,463 $421,787 $471,551 122 $2,694,974 $2,078,109 $420,758 $475,066 123 $2,685,940 $2,092,707 $419,721 $478,572 124 $2,676,857 $2,107,256 $418,675 $482,070 125 $2,667,724 $2,121,755 $417,621 $485,558 126 $2,658,542 $2,136,205 $416,557 $489,039 127 $2,649,310 $2,150,606 $415,485 $492,510 128 $2,640,028 $2,164,956 $414,404 $495,972 129 $2,630,696 $2,179,256 $413,314 $499,426 130 $2,621,313 $2,193,506 $412,215 $502,870 131 $2,611,880 $2,207,705 $411,106 $506,305 132 $2,602,395 $2,221,852 $409,989 $509,731 133 $2,592,859 $2,235,949 $408,862 $513,148 134 $2,583,272 $2,249,993 $407,725 $516,555 135 $2,573,632 $2,263,986 $406,579 $519,952 136 $2,563,941 $2,277,927 $405,424 $523,341 137 $2,554,196 $2,291,815 $404,259 $526,719 138 $2,544,399 $2,305,650 $403,084 $530,088 139 $2,534,549 $2,319,432 $401,900 $533,447 140 $2,524,646 $2,333,161 $400,706 $536,796 141 $2,514,689 $2,346,836 $399,501 $540,135 142 $2,504,678 $2,360,457 $398,287 $543,465

143 $2,494,612 $2,374,024 $397,063 $546,784 144 $2,484,493 $2,387,537 $395,828 $550,093 145 $2,474,318 $2,400,994 $394,583 $553,391 146 $2,464,088 $2,414,397 $393,328 $556,679 147 $2,453,803 $2,427,744 $392,062 $559,957 148 $2,443,462 $2,441,036 $390,786 $563,224 149 $2,433,066 $2,454,271 $389,499 $566,481 150 $2,422,613 $2,467,450 $388,201 $569,727 151 $2,412,103 $2,480,573 $386,892 $572,962 152 $2,401,536 $2,493,638 $385,573 $576,186 153 $2,390,912 $2,506,646 $384,243 $579,399 154 $2,380,231 $2,519,597 $382,901 $582,601 155 $2,369,491 $2,532,490 $381,549 $585,792 156 $2,358,694 $2,545,325 $380,185 $588,971 157 $2,347,838 $2,558,101 $378,809 $592,139 158 $2,336,923 $2,570,819 $377,423 $595,296 159 $2,325,949 $2,583,477 $376,024 $598,441 160 $2,314,916 $2,596,076 $374,614 $601,575 161 $2,303,823 $2,608,615 $373,193 $604,697 162 $2,292,669 $2,621,094 $371,759 $607,807 163 $2,281,456 $2,633,513 $370,313 $610,905 164 $2,270,181 $2,645,871 $368,856 $613,991 165 $2,258,846 $2,658,167 $367,386 $617,064 166 $2,247,449 $2,670,403 $365,904 $620,126 167 $2,235,991 $2,682,576 $364,410 $623,175 168 $2,224,470 $2,694,688 $362,903 $626,212 169 $2,212,887 $2,706,737 $361,384 $629,236 170 $2,201,241 $2,718,724 $359,852 $632,248 171 $2,189,532 $2,730,647 $358,307 $635,246 172 $2,177,760 $2,742,507 $356,750 $638,232 173 $2,165,924 $2,754,303 $355,179 $641,205 174 $2,154,024 $2,766,035 $353,595 $644,165 175 $2,142,059 $2,777,703 $351,998 $647,112 176 $2,130,030 $2,789,306 $350,388 $650,045 177 $2,117,935 $2,800,843 $348,765 $652,965 178 $2,105,775 $2,812,316 $347,128 $655,871 179 $2,093,549 $2,823,722 $345,477 $658,764 180 $2,081,257 $2,835,062 $343,812 $661,643 181 $2,068,898 $2,846,335 $342,134 $664,508 182 $2,056,472 $2,857,542 $340,441 $667,359 183 $2,043,979 $2,868,681 $338,735 $670,196 184 $2,031,419 $2,879,753 $337,014 $673,019 185 $2,018,790 $2,890,756 $335,279 $675,827 186 $2,006,093 $2,901,691 $333,530 $678,621 187 $1,993,327 $2,912,558 $331,766 $681,401 188 $1,980,492 $2,923,355 $329,987 $684,165 189 $1,967,587 $2,934,083 $328,193 $686,915 190 $1,954,613 $2,944,740 $326,385 $689,650 191 $1,941,568 $2,955,328 $324,561 $692,370 192 $1,928,453 $2,965,845 $322,722 $695,075 193 $1,915,266 $2,976,290 $320,868 $697,764 194 $1,902,008 $2,986,665 $318,998 $700,438 195 $1,888,678 $2,996,967 $317,113 $703,096

196 $1,875,277 $3,007,198 $315,212 $705,739 197 $1,861,802 $3,017,355 $313,296 $708,366 198 $1,848,255 $3,027,440 $311,363 $710,977 199 $1,834,634 $3,037,452 $309,414 $713,571 200 $1,820,939 $3,047,389 $307,449 $716,150 201 $1,807,170 $3,057,253 $305,468 $718,712 202 $1,793,327 $3,067,041 $303,470 $721,257 203 $1,779,408 $3,076,755 $301,455 $723,786 204 $1,765,415 $3,086,394 $299,424 $726,298 205 $1,751,345 $3,095,956 $297,375 $728,794 206 $1,737,199 $3,105,443 $295,310 $731,272 207 $1,722,977 $3,114,853 $293,227 $733,733 208 $1,708,677 $3,124,185 $291,127 $736,176 209 $1,694,300 $3,133,441 $289,010 $738,602 210 $1,679,846 $3,142,618 $286,875 $741,011 211 $1,665,313 $3,151,717 $284,722 $743,401 212 $1,650,701 $3,160,738 $282,551 $745,774 213 $1,636,010 $3,169,679 $280,362 $748,129 214 $1,621,239 $3,178,541 $278,155 $750,465 215 $1,606,389 $3,187,323 $275,930 $752,783 216 $1,591,458 $3,196,024 $273,686 $755,082 217 $1,576,446 $3,204,644 $271,423 $757,363 218 $1,561,353 $3,213,183 $269,141 $759,625 219 $1,546,178 $3,221,641 $266,840 $761,868 220 $1,530,921 $3,230,016 $264,521 $764,091 221 $1,515,581 $3,238,308 $262,181 $766,296 222 $1,500,158 $3,246,518 $259,823 $768,481 223 $1,484,652 $3,254,644 $257,444 $770,646 224 $1,469,061 $3,262,685 $255,046 $772,791 225 $1,453,386 $3,270,643 $252,628 $774,917 226 $1,437,627 $3,278,515 $250,190 $777,022 227 $1,421,782 $3,286,302 $247,731 $779,107 228 $1,405,851 $3,294,004 $245,252 $781,171 229 $1,389,833 $3,301,619 $242,753 $783,215 230 $1,373,729 $3,309,147 $240,232 $785,238 231 $1,357,538 $3,316,588 $237,690 $787,240 232 $1,341,259 $3,323,941 $235,128 $789,221 233 $1,324,892 $3,331,207 $232,544 $791,180 234 $1,308,436 $3,338,383 $229,938 $793,118 235 $1,291,892 $3,345,470 $227,311 $795,034 236 $1,275,257 $3,352,468 $224,661 $796,928 237 $1,258,532 $3,359,376 $221,990 $798,800 238 $1,241,717 $3,366,193 $219,296 $800,650 239 $1,224,811 $3,372,919 $216,580 $802,478 240 $1,207,813 $3,379,553 $213,842 $804,283 241 $1,190,723 $3,386,096 $211,080 $806,065 242 $1,173,541 $3,392,545 $208,296 $807,824 243 $1,156,265 $3,398,902 $205,488 $809,559 244 $1,138,896 $3,405,165 $202,657 $811,272 245 $1,121,433 $3,411,334 $199,802 $812,961 246 $1,103,875 $3,417,409 $196,924 $814,626 247 $1,086,222 $3,423,388 $194,021 $816,267 248 $1,068,473 $3,429,272 $191,095 $817,883

249 $1,050,629 $3,435,059 $188,144 $819,476 250 $1,032,687 $3,440,750 $185,168 $821,044 251 $1,014,649 $3,446,344 $182,167 $822,587 252 $996,513 $3,451,840 $179,142 $824,105 253 $978,278 $3,457,238 $176,091 $825,598 254 $959,945 $3,462,537 $173,015 $827,065 255 $941,512 $3,467,736 $169,914 $828,507 256 $922,980 $3,472,836 $166,786 $829,923 257 $904,347 $3,477,836 $163,632 $831,313 258 $885,614 $3,482,734 $160,452 $832,676 259 $866,778 $3,487,531 $157,246 $834,014 260 $847,841 $3,492,226 $154,013 $835,324 261 $828,801 $3,496,819 $150,753 $836,607 262 $809,658 $3,501,308 $147,466 $837,864 263 $790,412 $3,505,694 $144,151 $839,093 264 $771,061 $3,509,975 $140,809 $840,294 265 $751,605 $3,514,152 $137,439 $841,467 266 $732,044 $3,518,223 $134,041 $842,613 267 $712,377 $3,522,188 $130,614 $843,730 268 $692,604 $3,526,047 $127,159 $844,818 269 $672,723 $3,529,798 $123,675 $845,878 270 $652,735 $3,533,442 $120,162 $846,908 271 $632,638 $3,536,978 $116,620 $847,910 272 $612,433 $3,540,405 $113,048 $848,881 273 $592,118 $3,543,722 $109,447 $849,824 274 $571,693 $3,546,929 $105,816 $850,736 275 $551,157 $3,550,026 $102,154 $851,617 276 $530,510 $3,553,012 $98,462 $852,469 277 $509,752 $3,555,885 $94,739 $853,289 278 $488,881 $3,558,646 $90,985 $854,079 279 $467,897 $3,561,294 $87,199 $854,837 280 $446,799 $3,563,829 $83,382 $855,564 281 $425,587 $3,566,249 $79,534 $856,258 282 $404,260 $3,568,554 $75,653 $856,921 283 $382,817 $3,570,744 $71,740 $857,552 284 $361,258 $3,572,818 $67,794 $858,149 285 $339,583 $3,574,774 $63,816 $858,714 286 $317,790 $3,576,614 $59,804 $859,246 287 $295,879 $3,578,335 $55,759 $859,745 288 $273,850 $3,579,938 $51,680 $860,209 289 $251,701 $3,581,421 $47,567 $860,640 290 $229,432 $3,582,785 $43,420 $861,036 291 $207,042 $3,584,027 $39,239 $861,398 292 $184,532 $3,585,149 $35,022 $861,725 293 $161,899 $3,586,148 $30,770 $862,017 294 $139,144 $3,587,025 $26,483 $862,273 295 $116,265 $3,587,779 $22,160 $862,494 296 $93,263 $3,588,409 $17,802 $862,679 297 $70,136 $3,588,914 $13,406 $862,827 298 $46,883 $3,589,294 $8,975 $862,939 299 $23,505 $3,589,548 $4,506 $863,014 300 $0 $3,589,675 $0 $863,051 301 $0 $3,589,675 $0 $863,051

302 $0 $3,589,675 $0 $863,051 303 $0 $3,589,675 $0 $863,051 304 $0 $3,589,675 $0 $863,051 305 $0 $3,589,675 $0 $863,051 306 $0 $3,589,675 $0 $863,051 307 $0 $3,589,675 $0 $863,051 308 $0 $3,589,675 $0 $863,051 309 $0 $3,589,675 $0 $863,051 310 $0 $3,589,675 $0 $863,051 311 $0 $3,589,675 $0 $863,051 312 $0 $3,589,675 $0 $863,051 313 $0 $3,589,675 $0 $863,051 314 $0 $3,589,675 $0 $863,051 315 $0 $3,589,675 $0 $863,051 316 $0 $3,589,675 $0 $863,051 317 $0 $3,589,675 $0 $863,051 318 $0 $3,589,675 $0 $863,051 319 $0 $3,589,675 $0 $863,051 320 $0 $3,589,675 $0 $863,051 321 $0 $3,589,675 $0 $863,051 322 $0 $3,589,675 $0 $863,051 323 $0 $3,589,675 $0 $863,051 324 $0 $3,589,675 $0 $863,051 325 $0 $3,589,675 $0 $863,051 326 $0 $3,589,675 $0 $863,051 327 $0 $3,589,675 $0 $863,051 328 $0 $3,589,675 $0 $863,051 329 $0 $3,589,675 $0 $863,051 330 $0 $3,589,675 $0 $863,051 331 $0 $3,589,675 $0 $863,051 332 $0 $3,589,675 $0 $863,051 333 $0 $3,589,675 $0 $863,051 334 $0 $3,589,675 $0 $863,051 335 $0 $3,589,675 $0 $863,051 336 $0 $3,589,675 $0 $863,051 337 $0 $3,589,675 $0 $863,051 338 $0 $3,589,675 $0 $863,051 339 $0 $3,589,675 $0 $863,051 340 $0 $3,589,675 $0 $863,051 341 $0 $3,589,675 $0 $863,051 342 $0 $3,589,675 $0 $863,051 343 $0 $3,589,675 $0 $863,051 344 $0 $3,589,675 $0 $863,051 345 $0 $3,589,675 $0 $863,051 346 $0 $3,589,675 $0 $863,051 347 $0 $3,589,675 $0 $863,051 348 $0 $3,589,675 $0 $863,051 349 $0 $3,589,675 $0 $863,051 350 $0 $3,589,675 $0 $863,051 351 $0 $3,589,675 $0 $863,051 352 $0 $3,589,675 $0 $863,051 353 $0 $3,589,675 $0 $863,051 354 $0 $3,589,675 $0 $863,051

355 $0 $3,589,675 $0 $863,051 356 $0 $3,589,675 $0 $863,051 357 $0 $3,589,675 $0 $863,051 358 $0 $3,589,675 $0 $863,051 359 $0 $3,589,675 $0 $863,051 360 $0 $3,589,675 $0 $863,051

Multi-Mortgage Amortization

3rd Total$300,000 $4,300,000

10.0%25 25

$2,726 $30,902

3rd Mortgage Total

Interest Paid$300,000 $0 $4,300,000 $0

$299,774 $2,500 $4,294,723 $25,625$299,546 $4,998 $4,289,416 $51,220$299,316 $7,494 $4,284,078 $76,784$299,084 $9,989 $4,278,710 $102,317$298,850 $12,481 $4,273,311 $127,820$298,615 $14,971 $4,267,880 $153,291$298,377 $17,460 $4,262,419 $178,732$298,138 $19,946 $4,256,925 $204,140$297,896 $22,431 $4,251,401 $229,518$297,652 $24,913 $4,245,844 $254,863$297,407 $27,394 $4,240,256 $280,176

$297,159 $29,872 $4,234,635 $305,458$296,909 $32,348 $4,228,982 $330,706$296,657 $34,823 $4,223,297 $355,923$296,403 $37,295 $4,217,578 $381,106$296,147 $39,765 $4,211,827 $406,257$295,889 $42,233 $4,206,043 $431,374$295,629 $44,698 $4,200,225 $456,458$295,366 $47,162 $4,194,374 $481,509$295,101 $49,623 $4,188,489 $506,526$294,834 $52,083 $4,182,570 $531,509$294,565 $54,540 $4,176,616 $556,457$294,294 $56,994 $4,170,629 $581,372

$294,020 $59,447 $4,164,607 $606,252$293,744 $61,897 $4,158,550 $631,097$293,466 $64,345 $4,152,459 $655,907$293,186 $66,790 $4,146,332 $680,682$292,903 $69,234 $4,140,169 $705,421$292,617 $71,674 $4,133,972 $730,125$292,330 $74,113 $4,127,738 $754,794$292,040 $76,549 $4,121,468 $779,426$291,747 $78,983 $4,115,163 $804,022$291,452 $81,414 $4,108,820 $828,582$291,155 $83,843 $4,102,441 $853,105$290,855 $86,269 $4,096,026 $877,591

$290,553 $88,693 $4,089,573 $902,040

Remaining Balance

Interest Paid

Remaining Balance

$290,248 $91,114 $4,083,083 $926,451$289,941 $93,533 $4,076,555 $950,826$289,631 $95,949 $4,069,990 $975,162$289,318 $98,362 $4,063,386 $999,461$289,003 $100,773 $4,056,745 $1,023,721$288,686 $103,182 $4,050,065 $1,047,943$288,365 $105,588 $4,043,346 $1,072,126$288,042 $107,991 $4,036,588 $1,096,270$287,716 $110,391 $4,029,792 $1,120,375$287,388 $112,789 $4,022,956 $1,144,441$287,057 $115,183 $4,016,080 $1,168,467

$286,723 $117,576 $4,009,165 $1,192,454$286,386 $119,965 $4,002,209 $1,216,400$286,046 $122,352 $3,995,213 $1,240,306$285,704 $124,735 $3,988,177 $1,264,172$285,359 $127,116 $3,981,100 $1,287,997$285,011 $129,494 $3,973,982 $1,311,780$284,660 $131,869 $3,966,823 $1,335,523$284,306 $134,241 $3,959,622 $1,359,224$283,949 $136,611 $3,952,379 $1,382,883$283,589 $138,977 $3,945,094 $1,406,500$283,226 $141,340 $3,937,767 $1,430,075$282,860 $143,700 $3,930,398 $1,453,608

$282,491 $146,057 $3,922,986 $1,477,097$282,119 $148,412 $3,915,531 $1,500,544$281,744 $150,763 $3,908,032 $1,523,947$281,366 $153,110 $3,900,490 $1,547,307$280,985 $155,455 $3,892,904 $1,570,623$280,600 $157,797 $3,885,275 $1,593,895$280,212 $160,135 $3,877,600 $1,617,123$279,821 $162,470 $3,869,882 $1,640,306$279,427 $164,802 $3,862,118 $1,663,444$279,029 $167,130 $3,854,309 $1,686,537$278,629 $169,456 $3,846,455 $1,709,585$278,224 $171,778 $3,838,555 $1,732,587

$277,817 $174,096 $3,830,610 $1,755,543$277,406 $176,411 $3,822,618 $1,778,453$276,991 $178,723 $3,814,579 $1,801,317$276,574 $181,031 $3,806,494 $1,824,133$276,152 $183,336 $3,798,362 $1,846,903$275,727 $185,637 $3,790,182 $1,869,625$275,299 $187,935 $3,781,955 $1,892,300$274,867 $190,229 $3,773,680 $1,914,927$274,432 $192,520 $3,765,357 $1,937,505$273,992 $194,807 $3,756,985 $1,960,036$273,550 $197,090 $3,748,565 $1,982,517$273,103 $199,370 $3,740,095 $2,004,949

$272,653 $201,645 $3,731,576 $2,027,332$272,199 $203,918 $3,723,008 $2,049,666$271,741 $206,186 $3,714,389 $2,071,949$271,279 $208,450 $3,705,721 $2,094,182$270,814 $210,711 $3,697,001 $2,116,365$270,345 $212,968 $3,688,231 $2,138,497

$269,871 $215,221 $3,679,410 $2,160,577$269,394 $217,470 $3,670,537 $2,182,606$268,913 $219,715 $3,661,613 $2,204,584$268,428 $221,956 $3,652,636 $2,226,509$267,939 $224,192 $3,643,607 $2,248,382$267,446 $226,425 $3,634,526 $2,270,202

$266,948 $228,654 $3,625,391 $2,291,969$266,447 $230,879 $3,616,203 $2,313,683$265,941 $233,099 $3,606,961 $2,335,343$265,431 $235,315 $3,597,665 $2,356,949$264,917 $237,527 $3,588,315 $2,378,501$264,398 $239,735 $3,578,911 $2,399,998$263,876 $241,938 $3,569,451 $2,421,440$263,348 $244,137 $3,559,936 $2,442,827$262,817 $246,331 $3,550,365 $2,464,159$262,281 $248,522 $3,540,739 $2,485,434$261,740 $250,707 $3,531,056 $2,506,653$261,196 $252,888 $3,521,316 $2,527,815

$260,646 $255,065 $3,511,520 $2,548,920$260,092 $257,237 $3,501,666 $2,569,968$259,533 $259,405 $3,491,754 $2,590,959$258,970 $261,567 $3,481,785 $2,611,891$258,402 $263,725 $3,471,757 $2,632,765$257,829 $265,879 $3,461,670 $2,653,580$257,252 $268,027 $3,451,524 $2,674,336$256,669 $270,171 $3,441,319 $2,695,033$256,082 $272,310 $3,431,054 $2,715,669$255,490 $274,444 $3,420,729 $2,736,246$254,893 $276,573 $3,410,343 $2,756,762$254,291 $278,697 $3,399,896 $2,777,217

$253,684 $280,816 $3,389,388 $2,797,611$253,072 $282,930 $3,378,819 $2,817,944$252,455 $285,039 $3,368,187 $2,838,214$251,833 $287,143 $3,357,493 $2,858,422$251,205 $289,242 $3,346,737 $2,878,567$250,572 $291,335 $3,335,917 $2,898,649$249,934 $293,423 $3,325,033 $2,918,667$249,291 $295,506 $3,314,086 $2,938,622$248,642 $297,583 $3,303,074 $2,958,512$247,988 $299,655 $3,291,998 $2,978,338$247,329 $301,722 $3,280,857 $2,998,098$246,664 $303,783 $3,269,650 $3,017,793

$245,993 $305,839 $3,258,377 $3,037,422$245,317 $307,889 $3,247,038 $3,056,985$244,635 $309,933 $3,235,632 $3,076,481$243,948 $311,971 $3,224,159 $3,095,910$243,254 $314,004 $3,212,619 $3,115,272$242,555 $316,031 $3,201,011 $3,134,565$241,851 $318,053 $3,189,334 $3,153,791$241,140 $320,068 $3,177,589 $3,172,947$240,423 $322,078 $3,165,775 $3,192,035$239,701 $324,081 $3,153,891 $3,211,053$238,972 $326,079 $3,141,937 $3,230,001

$238,238 $328,070 $3,129,913 $3,248,878$237,497 $330,056 $3,117,817 $3,267,685$236,750 $332,035 $3,105,651 $3,286,420$235,997 $334,008 $3,093,413 $3,305,084$235,237 $335,974 $3,081,102 $3,323,675$234,471 $337,935 $3,068,719 $3,342,194$233,699 $339,888 $3,056,264 $3,360,640$232,921 $341,836 $3,043,734 $3,379,013$232,135 $343,777 $3,031,131 $3,397,311$231,344 $345,711 $3,018,453 $3,415,535$230,546 $347,639 $3,005,700 $3,433,684$229,741 $349,560 $2,992,873 $3,451,759$228,929 $351,475 $2,979,969 $3,469,757

$228,111 $353,383 $2,966,989 $3,487,679$227,286 $355,284 $2,953,933 $3,505,524$226,454 $357,178 $2,940,799 $3,523,292$225,615 $359,065 $2,927,588 $3,540,983$224,769 $360,945 $2,914,299 $3,558,596$223,916 $362,818 $2,900,931 $3,576,130$223,055 $364,684 $2,887,484 $3,593,585$222,188 $366,543 $2,873,957 $3,610,960$221,314 $368,394 $2,860,351 $3,628,255$220,432 $370,239 $2,846,664 $3,645,470$219,543 $372,076 $2,832,896 $3,662,604$218,646 $373,905 $2,819,047 $3,679,657

$217,742 $375,727 $2,805,115 $3,696,627$216,830 $377,542 $2,791,101 $3,713,515$215,911 $379,349 $2,777,004 $3,730,320$214,984 $381,148 $2,762,824 $3,747,041$214,050 $382,939 $2,748,559 $3,763,679$213,107 $384,723 $2,734,210 $3,780,232$212,157 $386,499 $2,719,776 $3,796,699$211,199 $388,267 $2,705,257 $3,813,082$210,233 $390,027 $2,690,651 $3,829,378$209,259 $391,779 $2,675,959 $3,845,587$208,277 $393,523 $2,661,179 $3,861,710$207,286 $395,258 $2,646,312 $3,877,744

$206,287 $396,986 $2,631,356 $3,893,691$205,280 $398,705 $2,616,312 $3,909,548$204,265 $400,415 $2,601,179 $3,925,317$203,241 $402,118 $2,585,955 $3,940,995$202,209 $403,811 $2,570,641 $3,956,583$201,167 $405,496 $2,555,237 $3,972,080$200,118 $407,173 $2,539,740 $3,987,486$199,059 $408,840 $2,524,152 $4,002,799$197,992 $410,499 $2,508,471 $4,018,020$196,916 $412,149 $2,492,696 $4,033,147$195,831 $413,790 $2,476,828 $4,048,181$194,737 $415,422 $2,460,866 $4,063,120

$193,633 $417,045 $2,444,808 $4,077,964$192,521 $418,659 $2,428,655 $4,092,713$191,399 $420,263 $2,412,406 $4,107,366$190,268 $421,858 $2,396,060 $4,121,922

$189,127 $423,443 $2,379,616 $4,136,380$187,977 $425,019 $2,363,075 $4,150,741$186,818 $426,586 $2,346,435 $4,165,003$185,648 $428,143 $2,329,696 $4,179,166$184,469 $429,690 $2,312,857 $4,193,229$183,281 $431,227 $2,295,918 $4,207,191$182,082 $432,754 $2,278,878 $4,221,053$180,873 $434,272 $2,261,736 $4,234,813

$179,654 $435,779 $2,244,492 $4,248,471$178,425 $437,276 $2,227,146 $4,262,026$177,186 $438,763 $2,209,695 $4,275,478$175,936 $440,240 $2,192,141 $4,288,825$174,676 $441,706 $2,174,481 $4,302,067$173,406 $443,161 $2,156,716 $4,315,204$172,125 $444,606 $2,138,846 $4,328,235$170,833 $446,041 $2,120,868 $4,341,160$169,531 $447,464 $2,102,783 $4,353,976$168,217 $448,877 $2,084,589 $4,366,685$166,893 $450,279 $2,066,288 $4,379,285$165,558 $451,670 $2,047,876 $4,391,775

$164,211 $453,049 $2,029,355 $4,404,156$162,854 $454,418 $2,010,722 $4,416,425$161,485 $455,775 $1,991,978 $4,428,583$160,104 $457,121 $1,973,122 $4,440,629$158,712 $458,455 $1,954,154 $4,452,562$157,309 $459,777 $1,935,071 $4,464,382$155,894 $461,088 $1,915,874 $4,476,087$154,467 $462,387 $1,896,563 $4,487,677$153,028 $463,675 $1,877,135 $4,499,151$151,577 $464,950 $1,857,592 $4,510,509$150,114 $466,213 $1,837,931 $4,521,750$148,639 $467,464 $1,818,152 $4,532,873

$147,151 $468,703 $1,798,254 $4,543,878$145,652 $469,929 $1,778,237 $4,554,763$144,139 $471,143 $1,758,101 $4,565,528$142,614 $472,344 $1,737,843 $4,576,172$141,077 $473,532 $1,717,464 $4,586,694$139,526 $474,708 $1,696,962 $4,597,094$137,963 $475,871 $1,676,337 $4,607,372$136,386 $477,020 $1,655,588 $4,617,525$134,797 $478,157 $1,634,715 $4,627,553$133,194 $479,280 $1,613,716 $4,637,456$131,578 $480,390 $1,592,591 $4,647,233$129,948 $481,487 $1,571,340 $4,656,883

$128,305 $482,570 $1,549,960 $4,666,405$126,648 $483,639 $1,528,452 $4,675,799$124,977 $484,694 $1,506,814 $4,685,063$123,293 $485,736 $1,485,046 $4,694,197$121,594 $486,763 $1,463,147 $4,703,200$119,881 $487,776 $1,441,116 $4,712,071$118,154 $488,775 $1,418,953 $4,720,810$116,413 $489,760 $1,396,656 $4,729,415$114,657 $490,730 $1,374,225 $4,737,885

$112,886 $491,686 $1,351,658 $4,746,221$111,101 $492,626 $1,328,956 $4,754,420$109,300 $493,552 $1,306,117 $4,762,483

$107,485 $494,463 $1,283,140 $4,770,408$105,655 $495,359 $1,260,024 $4,778,194$103,809 $496,239 $1,236,769 $4,785,841$101,948 $497,104 $1,213,374 $4,793,348$100,072 $497,954 $1,189,838 $4,800,713

$98,179 $498,788 $1,166,159 $4,807,936$96,271 $499,606 $1,142,337 $4,815,016$94,348 $500,408 $1,118,372 $4,821,953$92,408 $501,194 $1,094,262 $4,828,745$90,452 $501,964 $1,070,006 $4,835,391$88,479 $502,718 $1,045,604 $4,841,890$86,491 $503,456 $1,021,054 $4,848,242

$84,485 $504,176 $996,355 $4,854,445$82,463 $504,880 $971,507 $4,860,499$80,424 $505,568 $946,509 $4,866,403$78,368 $506,238 $921,360 $4,872,155$76,295 $506,891 $896,058 $4,877,756$74,205 $507,527 $870,603 $4,883,203$72,097 $508,145 $844,994 $4,888,496$69,972 $508,746 $819,230 $4,893,633$67,829 $509,329 $793,310 $4,898,615$65,668 $509,894 $767,233 $4,903,440$63,489 $510,441 $740,998 $4,908,106$61,292 $510,970 $714,603 $4,912,614

$59,077 $511,481 $688,049 $4,916,961$56,843 $511,973 $661,334 $4,921,148$54,591 $512,447 $634,456 $4,925,172$52,320 $512,902 $607,415 $4,929,033$50,029 $513,338 $580,211 $4,932,731$47,720 $513,755 $552,841 $4,936,262$45,392 $514,153 $525,305 $4,939,628$43,044 $514,531 $497,601 $4,942,827$40,677 $514,890 $469,729 $4,945,857$38,289 $515,229 $441,688 $4,948,717$35,882 $515,548 $413,477 $4,951,408$33,455 $515,847 $385,094 $4,953,926

$31,008 $516,126 $356,538 $4,956,273$28,540 $516,384 $327,808 $4,958,445$26,052 $516,622 $298,904 $4,960,443$23,543 $516,839 $269,824 $4,962,264$21,013 $517,035 $240,567 $4,963,909$18,462 $517,210 $211,132 $4,965,376$15,890 $517,364 $181,517 $4,966,663$13,296 $517,496 $151,722 $4,967,770$10,681 $517,607 $121,745 $4,968,695

$8,044 $517,696 $91,586 $4,969,437$5,385 $517,763 $61,243 $4,969,996$2,704 $517,808 $30,714 $4,970,370

$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557

$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557

$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557$0 $517,831 $0 $4,970,557

Property NotesProperty Name

Address

City, State, Zip Code:

Contact InformationRealtor Seller

NamePhoneMobile

Property InformationProperty Characteristics:

Name:Size: (Rentable Sq. Ft.) 1000

Year Built:Actual Age:

Unit Mix:

Property ConditionParking Lot Cond.

Who pays Utilities?How is it heated?

Age of roof(s)Age of windows

Garages?

Found Property:

Status:

Did Contact Agent & Owner Seemed:

Property Owner Would Like (if applicable):

Online Search Broker/AgentAd Drive-ByOwner Contacted Me from Ad or Letter Other

ReceptiveUnreceptive to a Private Onwer Financing Deal

Did Not Contact Owner or Agent Yet

Cash OutTake Back a Private Second

Still Negotiating

COMMENTS / NOTES


Still Negotiating

Not Sure

Property Notes

Seller

(Units) 172

Effective Age:

Occupancy %

Drive-By ReferralOther

Unreceptive to a Private Onwer Financing Deal

Investment AnalysisMulti-Year Cash Flow Proforma

Financing Information / AssumptionsPurchase SummaryPurchase Price $3,500,000Mortgages $3,150,000Loan Points $105,000Acquisition Costs $0Owner Equity / Down Payment $350,000Total Payment at Purchase $455,000

Income% Change

GROSS RENTAL INCOME 2% - Vacancy & Credit Loss 2% + Other Income 2%=GROSS RENTAL INCOME

Depreciation

Property Value $3,500,000 Property Value %Land Value $525,000 85%

ExpensesOPERATING EXPENSESReal Estate Taxes 2%Personal Property Taxes 2%Property Insurance 2%Management 2%Payroll 2% Expenses / Benefits 2% Taxes / Workers' Comp 2%Repairs and Maintenance: Materials 2% Labor 2%Utilities: Phone 2% Gas 2% Electric 2% Water 2% Sewer 2%Accounting and Legal 2%

Licenses and Permits 2%Advertising 2%Supplies 2%Contract Services: Trash 2% Lawn Care 2% Landscaping 2% Snow Removal 2%Other / Misc 2% Other (or "Lump Sum") 10%TOTAL OPERATING EXPENSES

Net Income

NET OPERATING INCOME - Annual Debt Service - Funded Reserves 2% - Leasing Commissions 2% - Capital Additions 2%= NET INCOME (CASH FLOW)+Residential Depreciation

OR+Commercial Depreciation

Return on Equity

Net IncomeEquity Growth (Loan Principle)Property Future Value 2%Property AppreciationTotal Equity

Cumulative Net Profit


Financing Information / AssumptionsAmortization Details:

Amount % Rate Term / Yr1st $3,500,000 6.5% 25

2nd $500,000 10.0% 253rd $300,000 10.0% 25

Income1 2 3 4

$750,000 $765,000 $780,300 $795,906$37,500 $38,250 $39,015 $39,795

$0 $0 $0 $0$712,500 $726,750 $741,285 $756,111

Depreciation1st year Depreciation

Residential (27.5 years) $58,598Commercial (39 years) $41,319

Expenses1 2 3 4

$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0

$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0

$100,000 $110,000 $121,000 $133,100$0 $0 $0 $0

Net Income1 2 3 4

$712,500 $726,750 $741,285 $756,111$370,822 $370,822 $370,822 $370,822

$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0

$341,678 $355,928 $370,463 $385,288$400,276 $414,526 $429,061 $443,887

$382,997 $397,247 $411,782 $426,608

Return on Equity1 2 3 4

$341,678 $355,928 $370,463 $385,288$4,300,000 $4,300,000 $4,300,000 $4,300,000$3,570,000 $3,641,400 $3,714,228 $3,788,513

$70,000 $141,400 $214,228 $288,513$4,370,000 $4,441,400 $4,514,228 $4,588,513

1 2 3 4$4,711,678 $4,797,328 $4,884,691 $4,973,801

Amortization Details:Payment

$23,632$4,544$2,726

5 6 7 8 9$811,824 $828,061 $844,622 $861,514 $878,745$40,591 $41,403 $42,231 $43,076 $43,937

$0 $0 $0 $0 $0$771,233 $786,658 $802,391 $818,439 $834,807

5 6 7 8 9$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$146,410 $161,051 $177,156 $194,872 $214,359$0 $0 $0 $0 $0

5 6 7 8 9$771,233 $786,658 $802,391 $818,439 $834,807$370,822 $370,822 $370,822 $370,822 $370,822

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$400,411 $415,835 $431,568 $447,616 $463,985$459,009 $474,434 $490,167 $506,215 $522,584

$441,730 $457,155 $472,888 $488,936 $505,304

5 6 7 8 9$400,411 $415,835 $431,568 $447,616 $463,985

$4,300,000 $4,300,000 $4,300,000 $4,300,000 $4,300,000$3,864,283 $3,941,568 $4,020,400 $4,100,808 $4,182,824$364,283 $441,568 $520,400 $600,808 $682,824

$4,664,283 $4,741,568 $4,820,400 $4,900,808 $4,982,824

5 6 7 8 9$5,064,693 $5,157,404 $5,251,968 $5,348,424 $5,446,809

10 11 12 13 14$896,319 $914,246 $932,531 $951,181 $970,205$44,816 $45,712 $46,627 $47,559 $48,510

$0 $0 $0 $0 $0$851,503 $868,534 $885,904 $903,622 $921,695

10 11 12 13 14$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$235,795 $259,374 $285,312 $313,843 $345,227$0 $0 $0 $0 $0

10 11 12 13 14$851,503 $868,534 $885,904 $903,622 $921,695$370,822 $370,822 $370,822 $370,822 $370,822

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$480,681 $497,711 $515,082 $532,800 $550,872$539,280 $556,310 $573,680 $591,398 $609,471

$522,001 $539,031 $556,401 $574,119 $592,192

10 11 12 13 14$480,681 $497,711 $515,082 $532,800 $550,872

$4,300,000 $4,300,000 $4,300,000 $4,300,000 $4,300,000$4,266,480 $4,351,810 $4,438,846 $4,527,623 $4,618,176$766,480 $851,810 $938,846 $1,027,623 $1,118,176

$5,066,480 $5,151,810 $5,238,846 $5,327,623 $5,418,176

10 11 12 13 14$5,547,162 $5,649,521 $5,753,928 $5,860,423 $5,969,048

15 16 17 18 19$989,609 $1,009,401 $1,029,589 $1,050,181 $1,071,185$49,480 $50,470 $51,479 $52,509 $53,559

$0 $0 $0 $0 $0$940,129 $958,931 $978,110 $997,672 $1,017,625

15 16 17 18 19$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$379,750 $417,725 $459,497 $505,447 $555,992$0 $0 $0 $0 $0

15 16 17 18 19$940,129 $958,931 $978,110 $997,672 $1,017,625$370,822 $370,822 $370,822 $370,822 $370,822

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$569,306 $588,109 $607,288 $626,850 $646,803$627,905 $646,707 $665,886 $685,448 $705,402

$610,626 $629,428 $648,607 $668,169 $688,123

15 16 17 18 19$569,306 $588,109 $607,288 $626,850 $646,803

$4,300,000 $4,300,000 $4,300,000 $4,300,000 $4,300,000$4,710,539 $4,804,750 $4,900,845 $4,998,862 $5,098,839$1,210,539 $1,304,750 $1,400,845 $1,498,862 $1,598,839$5,510,539 $5,604,750 $5,700,845 $5,798,862 $5,898,839

15 16 17 18 19$6,079,846 $6,192,859 $6,308,133 $6,425,712 $6,545,642

20 21 22 23 24$1,092,608 $1,114,461 $1,136,750 $1,159,485 $1,182,674

$54,630 $55,723 $56,837 $57,974 $59,134$0 $0 $0 $0 $0

$1,037,978 $1,058,738 $1,079,912 $1,101,511 $1,123,541

20 21 22 23 24$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$611,591 $672,750 $740,025 $814,027 $895,430$0 $0 $0 $0 $0

20 21 22 23 24$1,037,978 $1,058,738 $1,079,912 $1,101,511 $1,123,541$370,822 $370,822 $370,822 $370,822 $370,822

$0 $0 $0 $0 $0$0 $0 $0 $0 $0$0 $0 $0 $0 $0

$667,156 $687,915 $709,090 $730,688 $752,718$725,754 $746,514 $767,688 $789,287 $811,317

$708,475 $729,235 $750,409 $772,008 $794,038

20 21 22 23 24$667,156 $687,915 $709,090 $730,688 $752,718

$4,300,000 $4,300,000 $4,300,000 $4,300,000 $4,300,000$5,200,816 $5,304,832 $5,410,929 $5,519,147 $5,629,530$1,700,816 $1,804,832 $1,910,929 $2,019,147 $2,129,530$6,000,816 $6,104,832 $6,210,929 $6,319,147 $6,429,530

20 21 22 23 24$6,667,972 $6,792,747 $6,920,019 $7,049,836 $7,182,249

25$1,206,328

$60,316$0

$1,146,012

25$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0

$0$0$0$0$0$0$0$0

$984,973$0

25$1,146,012$370,822

$0$0$0

$775,189$833,788

$816,509

25$775,189

$4,300,000$5,742,121$2,242,121$6,542,121

25$7,317,310

2011 cash flow evaluator

Documents