Docstoc

propertycalculator

Document Sample
propertycalculator Powered By Docstoc
					                                                                                                                     TEL: 0861 000 584
                      www.PropertyInvesting.co.za                                                                    FAX: 086 697 5217
                                                                                                                info@propertyinvesting.co.za


                             INVESTMENT PROPERTY EVALUATION
                                                                                                                 PROPERTY INFORMATION
                                              Income Statement                                                   Valuation                                  R 500,000
                                                                                                                 Purchase Price                             R 465,000
                        Income                                                   Expenses                        Mortgage                                   R 500,000
Description                                 Amount         Description                             Amount       Cash Back / Shortfall Assistance                  R-
Rental                                  R      3,500.00 Bond Payment                           R     5,857.88    Expected Capital Expenditure                     R-
Minus Vacancy Losses                    R       -140.00 Rental Management                      R       350.00   Initial Interest Rate on Loan                      13   % p.a.
                                                        Repairs/Maintenance                    R       140.00   Term of Loan:                                      20   yrs.
                                                        Property taxes / Levy                  R       350.00   Vacancy/Collection losses                           4   % of Rental
                                                        Insurance                              R          -       Rental Management                                10   % of Rental
                                                        Electricity                            R          -       Repairs/Maintenance                               4   % of Rental
                                                        Water                                  R          -     Annual Increase of Income                          10   % p.a.
                                                        Refuse                                 R          -     Annual Increase of Expenses                        10   % p.a.
                                                        Advertising                            R          -     Annual Appreciation Rate                           15   % p.a.
                                                        Security                               R          -       Annual Appreciation Decrease                      0   % p.a.
                                                        Garden Services                        R          -       Depreciation Limit                                3   % p.a.
                                                        Fire Protection                        R          -     Income Tax Bracket                                 40   %
                                                        Administration                         R          -     Approximate Transfer Costs                         10   % of total
Total                                   R      3,360.00                                        R     6,697.88   Approximate Refinance Cost                        1.5   % of total
                                                 Balance Sheet                                                  Buildings Area                                     60   m²
                        Assets                                                   Liabilities                    Purchase Date                              2009-01-30
Description                                 Amount          Description                            Amount       Expected Registration Date                 2009-05-30
Property                                R    500,000.00 Mortgage                               R   500,000.00

Total                                   R    500,000.00                                        R   500,000.00

                                     ACQUISITION DATA
Purchase Price                             R 465,000 Monthly Shortfall                                R 3,338
Mortgage                                   R 500,000 1st years cash investment                       R 86,555
Transfer Costs                               R 46,500 Gross Yield                                      9.03%    (Income / Purchase Price)
Capital Expenditure                               R 0 1st years Net Return                           R 68,923   (Equity - capital expenses + shortfall) / 1st year investment
Deposit                                           R 0 Return on Investment                            79.63%    Net Return / 1st year investment
Purchase Value                           R 7,750.0 m² Rent / Bond Ratio                               59.75%
Property Value                           R 8,333.3 m² Rent / Purchase Ratio                            0.75%
Equity Purchased                             R 35,000 Rental Value                                  R 58.3 m²
This report is based on certain assumptions.The projections are estimates only

ALL AREAS INDICATED WITH THIS COLOUR, ARE INPUT FIELDS
                                             INVESTMENT PROPERTY EVALUATION

                                                                    Income Statement
                                                                             End of Year                                       1
                                  Income                                                                   Expenses
Description                                                  Amount              Description                                 Amount
Effective Gross Income                                 R          42,000.00      Bond Payment                            R     70,294.54
 Less Vacancy Losses                                   R          -1,680.00      Management                              R       4,200.00
                                                                                 Repairs/Maintenance                     R       1,680.00
                                                                                 Property Taxes / Levies                 R       4,200.00
                                                                                 Insurance                               R            -
                                                                                 Electricity                             R            -
                                                                                 Water                                   R            -
                                                                                 Refuse                                  R            -
                                                                                 Advertising                             R            -
                                                                                 Security                                R            -
                                                                                 Garden Services                         R            -
                                                                                 Fire Protection                         R            -
                                                                                 Administration                          R            -
Total                                                  R          40,320.00                                                   R 80,374.54
                                                                       Balance Sheet
                                  Assets                                                                   Liabilities
Description                                                  Amount              Description                                 Amount
Property Value (Growth)                                R        603,356.16       Mortgage                                R    494,378.32

Total                                                  R        603,356.16                                               R    494,378.32

OPERATIONS                                                                       LOAN DATA
TOTAL OPERATING EXPENSES                                       R 10,080.00       (Expected Interest Rate)                         13.00%
Operating Expenses as % of income                                    25.0%       Mortage Principle                           R 500,000.00
Operating Income                                               R 30,240.00       TOTAL PRINCIPAL REDUCTION                     R 5,621.68
NET OPERATING INCOME                                           R -40,054.54      TOTAL ANNUAL APPRECIATION                    R 78,698.63
Taxable Income                                                 R -44,512.86      ACQUISITION DATA
Vacancy/Collection losses                                            4.00%       Purchase Price                              R 465,000.00
Rental Management                                                   10.00%       Mortgage                                R       494,378
Repairs/Maintenance                                                  4.00%       Buying Costs (Registration&Transfer)         R 46,500.00
Annual Increase of Income                                           10.00%       Capital Expendature                               R 0.00
Annual Increase of Expenses                                         10.00%       Down Payment                                      R 0.00
Annual Appreciation Rate                                            15.00%       Buildings Purchase Price                    R 7750.00/m²
Annual Appreciation Decrease                                         0.00%

This report is based on certain assumptions.The projections are estimates only
30 YEAR PROJECTION                                   Year                    0               1               2               3               4               5               6               7               8               9               10              11              12              13              14              15              16              17              18              19              20              21            22             23             24             25             26             27             28             29             30
ANNUAL OPERATING INCOME                                                   120 days
Increase in income                                 10.00%                                          10.00%          10.00%          10.00%          10.00%          10.00%         10.00%          10.00%          10.00%          10.00%           10.00%       10.00%          10.00%          10.00%          10.00%          10.00%          10.00%          10.00%          10.00%          10.00%          10.00%          10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%
Expected Gross Income                                                                             R 42,000        R 46,200        R 50,820        R 55,902        R 61,492       R 67,641        R 74,406        R 81,846        R 90,031         R 99,034    R 108,937       R 119,831       R 131,814       R 144,995       R 159,495       R 175,444       R 192,989       R 212,288       R 233,517       R 256,868       R 282,555      R 310,810      R 341,892      R 376,081      R 413,689      R 455,058      R 500,563      R 550,620      R 605,682      R 666,250
 - Vacancy/Collection losses                        4.00%                                          R 1,680         R 1,747         R 1,817         R 1,890         R 1,965        R 2,044         R 2,126         R 2,211         R 2,299          R 2,391      R 2,487         R 2,586         R 2,690         R 2,797         R 2,909         R 3,026         R 3,147         R 3,272         R 3,403         R 3,540         R 3,681        R 3,828        R 3,981        R 4,141        R 4,306        R 4,479        R 4,658        R 4,844        R 5,038        R 5,239
EFFECTIVE GROSS INCOME                                                                            R 40,320        R 44,453        R 49,003        R 54,012        R 59,527       R 65,597        R 72,280        R 79,635        R 87,732         R 96,643    R 106,450       R 117,245       R 129,124       R 142,198       R 156,586       R 172,419       R 189,842       R 209,015       R 230,113       R 253,329       R 278,874      R 306,982      R 337,910      R 371,940      R 409,382      R 450,579      R 495,906      R 545,776      R 600,644      R 661,011

ANNUAL OPERATING EXPENSES
(Increase in expenses)                             10.00%                                          10.00%          10.00%          10.00%          10.00%          10.00%         10.00%          10.00%          10.00%          10.00%           10.00%          10.00%          10.00%          10.00%       10.00%          10.00%          10.00%          10.00%          10.00%          10.00%          10.00%          10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%         10.00%
Rental Management                                                                                  R 4,200         R 4,620         R 5,082         R 5,590         R 6,149        R 6,764         R 7,441         R 8,185         R 9,003          R 9,903        R 10,894        R 11,983        R 13,181     R 14,500        R 15,949        R 17,544        R 19,299        R 21,229        R 23,352        R 25,687        R 28,255       R 31,081       R 34,189       R 37,608       R 41,369       R 45,506       R 50,056       R 55,062       R 60,568       R 66,625
Repairs/Maintenance                                                                                R 1,680         R 1,848         R 2,033         R 2,236         R 2,460        R 2,706         R 2,976         R 3,274         R 3,601          R 3,961         R 4,357         R 4,793         R 5,273      R 5,800         R 6,380         R 7,018         R 7,720         R 8,492         R 9,341        R 10,275        R 11,302       R 12,432       R 13,676       R 15,043       R 16,548       R 18,202       R 20,023       R 22,025       R 24,227       R 26,650
Property Taxes / Levies                                                                            R 4,200         R 4,620         R 5,082         R 5,590         R 6,149        R 6,764         R 7,441         R 8,185         R 9,003          R 9,903        R 10,894        R 11,983        R 13,181     R 14,500        R 15,949        R 17,544        R 19,299        R 21,229        R 23,352        R 25,687        R 28,255       R 31,081       R 34,189       R 37,608       R 41,369       R 45,506       R 50,056       R 55,062       R 60,568       R 66,625
Insurance                                                                                              R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Electricity                                                                                            R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Water                                                                                                  R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Reffuse                                                                                                R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Advertising                                                                                            R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Security                                                                                               R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Gardern Service                                                                                        R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Fire Protection                                                                                        R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Administration                                                                                         R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
Refinancing Cost                                                                                       R0              R0              R0              R0              R0             R0              R0              R0              R0               R0              R0              R0              R0           R0              R0              R0              R0              R0              R0              R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
TOTAL OPERATING EXPENSES                                                                          R 10,080        R 11,088        R 12,197        R 13,416        R 14,758       R 16,234        R 17,857        R 19,643        R 21,607         R 23,768        R 26,145        R 28,759        R 31,635     R 34,799        R 38,279        R 42,107        R 46,317        R 50,949        R 56,044        R 61,648        R 67,813       R 74,595       R 82,054       R 90,259       R 99,285      R 109,214      R 120,135      R 132,149      R 145,364      R 159,900
Operating Income (excluding finance costs)                                                        R 30,240        R 33,365        R 36,806        R 40,596        R 44,769       R 49,364        R 54,422        R 59,992        R 66,124         R 72,875        R 80,305        R 88,485        R 97,489    R 107,399       R 118,307       R 130,312       R 143,525       R 158,066       R 174,069       R 191,680       R 211,061      R 232,388      R 255,856      R 281,681      R 310,097      R 341,365      R 375,770      R 413,627      R 455,280      R 501,111
Operating Expenses as % of income                                                                  25.00%          24.94%          24.89%          24.84%          24.79%         24.75%          24.71%          24.67%          24.63%           24.59%          24.56%          24.53%          24.50%       24.47%          24.45%          24.42%          24.40%          24.38%          24.35%          24.34%          24.32%         24.30%         24.28%         24.27%         24.25%         24.24%         24.23%         24.21%         24.20%         24.19%

CASH FLOW (BEFORE TAXES)
Operating Income                                                                                 R 30,240        R 33,365      R 36,806        R 40,596         R 44,769        R 49,364        R 54,422        R 59,992        R 66,124        R 72,875        R 80,305        R 88,485        R 97,489      R 107,399       R 118,307       R 130,312       R 143,525       R 158,066       R 174,069       R 191,680       R 211,061      R 232,388      R 255,856      R 281,681      R 310,097      R 341,365      R 375,770      R 413,627      R 455,280      R 501,111
-Annual Payment & Interest                       R 1,405,891                                     R 70,295        R 70,295      R 70,295        R 70,295         R 70,295        R 70,295        R 70,295        R 70,295        R 70,295        R 70,295        R 70,295        R 70,295        R 70,295        R 70,295       R 70,295        R 70,295        R 70,295        R 70,295        R 70,295        R 70,295             R0             R0              R0             R0             R0             R0             R0             R0             R0             R0
CASH FLOW                                                                        R -11,500       R -40,055       R -36,930    R -33,488       R -29,699        R -25,526       R -20,931       R -15,872       R -10,302         R -4,170        R 2,580        R 10,011        R 18,191        R 27,194        R 37,105       R 48,012        R 60,018        R 73,230        R 87,772       R 103,775       R 121,386       R 211,061      R 232,388      R 255,856      R 281,681      R 310,097      R 341,365      R 375,770      R 413,627      R 455,280      R 501,111
ACCUMULATED ANNUAL CASH FLOW                                                                     R -51,555       R -88,484   R -121,973      R -151,672       R -177,197      R -198,128      R -214,000      R -224,303      R -228,473      R -225,893      R -215,882      R -197,692      R -170,497      R -133,393      R -85,380       R -25,363        R 47,868       R 135,640       R 239,414       R 360,800       R 571,861      R 804,248     R 1,060,104    R 1,341,785    R 1,651,882    R 1,993,247    R 2,369,018    R 2,782,645    R 3,237,925    R 3,739,036

TAXATION
Operating Income                                                                                  R 30,240        R 33,365        R 36,806        R 40,596        R 44,769        R 49,364        R 54,422        R 59,992        R 66,124        R 72,875        R 80,305        R 88,485        R 97,489    R 107,399       R 118,307       R 130,312       R 143,525       R 158,066       R 174,069       R 191,680       R 211,061      R 232,388      R 255,856      R 281,681      R 310,097      R 341,365      R 375,770      R 413,627      R 455,280      R 501,111
 - Interest                                                                                       R 64,673        R 63,897        R 63,014        R 62,009        R 60,865        R 59,564        R 58,082        R 56,397        R 54,478        R 52,295        R 49,811        R 46,983        R 43,765     R 40,104        R 35,936        R 31,194        R 25,796        R 19,654        R 12,664         R 4,709             R0             R0             R0             R0             R0             R0              R0             R0             R0             R0
 -Allowed Expenses                                                                                R 10,080        R 11,088        R 12,197        R 13,416        R 14,758        R 16,234        R 17,857        R 19,643        R 21,607        R 23,768        R 26,145        R 28,759        R 31,635     R 34,799        R 38,279        R 42,107        R 46,317        R 50,949        R 56,044        R 61,648        R 67,813       R 74,595       R 82,054       R 90,259       R 99,285      R 109,214      R 120,135      R 132,149      R 145,364      R 159,900
Taxable Income                                                                                   R -44,513       R -41,620       R -38,404       R -34,830       R -30,855       R -26,434       R -21,517       R -16,047        R -9,962        R -3,189         R 4,350        R 12,743        R 22,088     R 32,497        R 44,092        R 57,012        R 71,411        R 87,463       R 105,361       R 125,322       R 143,248      R 157,793      R 173,802      R 191,421      R 210,812      R 232,151      R 255,635      R 281,478      R 309,917      R 341,211
x Investor's Tax Bracket                           40.00%                                          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%       40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%          40.00%         40.00%         40.00%         40.00%         40.00%         40.00%          40.00%         40.00%         40.00%         40.00%
TAX BENEFIT                                                                                       R 17,805        R 16,648        R 15,362        R 13,932        R 12,342        R 10,574         R 8,607         R 6,419         R 3,985         R 1,275        R -1,740        R -5,097        R -8,835    R -12,999       R -17,637       R -22,805       R -28,564       R -34,985       R -42,144       R -50,129       R -57,299      R -63,117      R -69,521      R -76,568      R -84,325      R -92,861      R -102,254     R -112,591     R -123,967     R -136,484
TAX PAYABLE                                                                                            R0              R0              R0              R0              R0              R0              R0              R0              R0              R0          R 1,740         R 5,097         R 8,835     R 12,999        R 17,637        R 22,805        R 28,564        R 34,985        R 42,144        R 50,129        R 57,299       R 63,117       R 69,521       R 76,568       R 84,325       R 92,861      R 102,254      R 112,591      R 123,967      R 136,484
NET OPERATING INCOME                                                                             R -40,055       R -36,930       R -33,488       R -29,699       R -25,526       R -20,931       R -15,872       R -10,302        R -4,170         R 2,580         R 8,271        R 13,094        R 18,359     R 24,106        R 30,376        R 37,213        R 44,666        R 52,787        R 61,630        R 71,257       R 153,762      R 169,270      R 186,335      R 205,112      R 225,772      R 248,505      R 273,516      R 301,036      R 331,314      R 364,626

MORTGAGE PRINCIPAL REDUCTION
(Expected Interest Rate)                             13%                                           13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%       13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%          13.00%            13.00%        13.00%         13.00%         13.00%         13.00%         13.00%         13.00%         13.00%         13.00%         13.00%
Mortage Principle                                                                                R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000    R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000       R 500,000               R0            R0             R0             R0             R0             R0             R0             R0             R0             R0
Start of Yr. Balance                                                                             R 500,000       R 494,378       R 487,981       R 480,700       R 472,414       R 462,985       R 452,254       R 440,042       R 426,144    R 410,327       R 392,328       R 371,844       R 348,533       R 322,004       R 291,813       R 257,454       R 218,354       R 173,855       R 123,215        R 65,585               R0            R0             R0             R0             R0             R0             R0             R0             R0             R0
 -End of Yr. Balance                                                                             R 494,378       R 487,981       R 480,700       R 472,414       R 462,985       R 452,254       R 440,042       R 426,144       R 410,327    R 392,328       R 371,844       R 348,533       R 322,004       R 291,813       R 257,454       R 218,354       R 173,855       R 123,215        R 65,585             R0                R0            R0             R0             R0             R0             R0             R0             R0             R0             R0
TOTAL PRINCIPAL REDUCTION                                                                          R 5,622         R 6,398         R 7,281         R 8,286         R 9,429        R 10,731        R 12,212        R 13,898        R 15,816     R 17,999        R 20,484        R 23,311        R 26,529        R 30,191        R 34,358        R 39,101        R 44,498        R 50,640        R 57,630        R 65,585               R0            R0             R0             R0             R0             R0             R0             R0             R0             R0

PROPERTY APPRECIATION
(Increase)                                         15.00%                           4.93%          15.00%          15.00%          15.00%          15.00%        15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%          15.00%         15.00%         15.00%         15.00%         15.00%         15.00%         15.00%         15.00%         15.00%         15.00%
Start of Year Value                                                              R 500,000       R 524,658       R 603,356       R 693,860       R 797,939    R 917,629      R 1,055,274     R 1,213,565     R 1,395,599     R 1,604,939     R 1,845,680     R 2,122,532     R 2,440,912     R 2,807,049     R 3,228,106     R 3,712,322     R 4,269,171     R 4,909,546     R 5,645,978     R 6,492,875     R 7,466,806     R 8,586,827    R 9,874,851   R 11,356,079   R 13,059,491   R 15,018,414   R 17,271,177   R 19,861,853   R 22,841,131   R 26,267,301   R 30,207,396
End of Year Value                                                                R 524,658       R 603,356       R 693,860       R 797,939       R 917,629   R 1,055,274     R 1,213,565     R 1,395,599     R 1,604,939     R 1,845,680     R 2,122,532     R 2,440,912     R 2,807,049     R 3,228,106     R 3,712,322     R 4,269,171     R 4,909,546     R 5,645,978     R 6,492,875     R 7,466,806     R 8,586,827     R 9,874,851   R 11,356,079   R 13,059,491   R 15,018,414   R 17,271,177   R 19,861,853   R 22,841,131   R 26,267,301   R 30,207,396   R 34,738,505
TOTAL ANNUAL APPRECIATION                                                         R 24,658        R 78,699        R 90,503       R 104,079       R 119,691    R 137,644       R 158,291       R 182,035       R 209,340       R 240,741       R 276,852       R 318,380       R 366,137       R 421,057       R 484,216       R 556,848       R 640,376       R 736,432       R 846,897       R 973,931      R 1,120,021     R 1,288,024    R 1,481,228    R 1,703,412    R 1,958,924    R 2,252,762    R 2,590,676    R 2,979,278    R 3,426,170    R 3,940,095    R 4,531,109

EQUITY:
Start of Year Value                                                              R 500,000       R 524,658       R 603,356       R 693,860       R 797,939       R 917,629   R 1,055,274     R 1,213,565     R 1,395,599     R 1,604,939     R 1,845,680     R 2,122,532     R 2,440,912     R 2,807,049     R 3,228,106     R 3,712,322     R 4,269,171     R 4,909,546     R 5,645,978     R 6,492,875     R 7,466,806     R 8,586,827    R 9,874,851   R 11,356,079   R 13,059,491   R 15,018,414   R 17,271,177   R 19,861,853   R 22,841,131   R 26,267,301   R 30,207,396
-End of Yr. Balance                                                              R 500,000       R 494,378       R 487,981       R 480,700       R 472,414       R 462,985    R 452,254       R 440,042        R 426,144       R 410,327       R 392,328       R 371,844       R 348,533       R 322,004       R 291,813       R 257,454       R 218,354       R 173,855       R 123,215        R 65,585             R0              R0             R0             R0             R0             R0             R0             R0             R0             R0             R0
EQUITY                                                                            R 24,658       R 108,978       R 205,879       R 317,239       R 445,215       R 592,289    R 761,311       R 955,558      R 1,178,796     R 1,435,353     R 1,730,204     R 2,069,068     R 2,458,516     R 2,906,103     R 3,420,510     R 4,011,716     R 4,691,193     R 5,472,123     R 6,369,660     R 7,401,221     R 8,586,827     R 9,874,851   R 11,356,079   R 13,059,491   R 15,018,414   R 17,271,177   R 19,861,853   R 22,841,131   R 26,267,301   R 30,207,396   R 34,738,505
- EQUITY WITHDRAWAL (Year End)
Surplus Amount                                                                                   R -40,055       R -36,930       R -33,488       R -29,699       R -25,526       R -20,931       R -15,872       R -10,302        R -4,170         R 2,580         R 8,271        R 13,094        R 18,359        R 24,106        R 30,376        R 37,213        R 44,666        R 52,787        R 61,630        R 71,257    R 153,762      R 169,270      R 186,335      R 205,112      R 225,772      R 248,505      R 273,516      R 301,036      R 331,314      R 364,626

Break Even Point on Cash Flow                      10                                                   0               0               0               0               0               0               0               0               0               1               1               1               1               1               1               1               1               1               1               1             1              1              1              1              1              1              1              1              1              1
Total Cash Investment Needed to new break even point
Surplus Capital
Refinanced Equity Usage
Net Yield


This report is based on certain assumptions.The projections are estimates only
                                                                  Break Even Timeline

          Year     1      2      3      4       5    6      7      8      9      10     11    12    13   14   15     16    17    18   19   20
       R 600,000




       R 500,000




       R 400,000




       R 300,000




       R 200,000




       R 100,000




            R0




      R -100,000


                                      CASH FLOW                         Annual Payment & Interest                  Bond Amount



Break Even Point on Cash Flow         Year 10

This report is based on certain assumptions.The projections are estimates only
                                                                         20 Year Equity
            Year 1       2      3      4      5      6       7       8       9      10    11   12   13   14     15      16   17   18   19   20
      R 10,000,000



       R 9,000,000


       R 8,000,000


       R 7,000,000


       R 6,000,000



       R 5,000,000



       R 4,000,000


       R 3,000,000



       R 2,000,000


       R 1,000,000



              R0



                                                         Property Appreciation                            Available Equity



This report is based on certain assumptions.The projections are estimates only

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:5/18/2012
language:
pages:5
fanzhongqing fanzhongqing http://
About