Market Comparison of investment properties

Address

Number of units (plex)

6

5

8

12

11

13

16

2

7

6

20

1

2

1

11

4

33

List  Price

419000

470000

760000

844900

1100000

799900

1790000

600000

699000

728000

760000

499000

548000

559000

469000

1499000

2800000

Sale price (negotiated - market price)

398050

446500

722000

802655

1045000

759905

1700500

570000

664050

691600

722000

474050

520600

531050

445550

1424050

2660000

Initial Investment

99512.5

111625

180500

200663.75

261250

189976.25

425125

142500

166012.5

172900

180500

118512.5

130150

132762.5

111387.5

356012.5

665000

Mortgage Amount

298537.5

334875

541500

601991.25

783750

569928.75

1275375

427500

498037.5

518700

541500

355537.5

390450

398287.5

334162.5

1068037.5

1995000

Potential rent income

57000

58000

88800

102340

115000

98760

258578

73800

84000

69480

120000

44960

48240

42777

56100

140123

312600

Vacancy & credit losses 2.5%

0

1450

2220

2558.5

2875

2469

6464.45

0

2100

1737

3000

0

0

0

900

0

7815

Effective rental income

57000

56550

86580

99781.5

112125

96291

252113.55

73800

81900

67743

117000

44960

48240

42777

55200

140123

304785

Other income

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Gross operating income

57000

56550

86580

99781.5

112125

96291

252113.55

73800

81900

67743

117000

44960

48240

42777

55200

140123

304785

Operating expences

8760.0

14000.0

20529.3

26800.0

21980.0

19845.0

76301.0

15109.0

12959.0

12900.0

25381.0

0.0

0.0

0.0

13500.0

0.0

85716.0

Net operating income

48240.0

42550.0

66050.8

72981.5

90145.0

76446.0

175812.6

58691.0

68941.0

54843.0

91619.0

44960.0

48240.0

42777.0

41700.0

140123.0

219069.0

Annual debt service  incl.principal

22391.2

25116.5

40613.8

45151.0

58783.3

42698.0

95656.6

32063.6

37354.0

38903.8

40613.9

26666.3

29284.8

29872.6

25063.1

80105.6

149630.3

Principal paid (1 year re-cap/equity build-up)

5571.0

6248.9

10104.7

11233.6

14625.2

10623.2

23799.3

7977.4

9293.6

9679.3

10104.7

6634.6

7286.0

7432.2

6235.7

19930.2

37227.9

Interest paid only

16820.2

18867.5

30509.1

33917.4

44158.1

32074.8

71857.2

24086.2

28060.4

29224.5

30509.2

20031.7

21998.8

22440.3

18827.4

60175.4

112402.3

Cash flow before taxes

25848.8

17433.5

25437.0

27830.5

31361.7

33748.0

80156.0

26627.4

31587.0

15939.2

51005.1

18293.7

18955.2

12904.4

16636.9

60017.4

69438.7

Return CFBT   CFBT/In Inv  per unit

4308.1

3486.7

3179.6

2319.2

2851.1

2596.0

5009.7

13313.7

4512.4

2656.5

2550.3

18293.7

9477.6

12904.4

1512.4

15004.3

2104.2

Tax liability

4308.1

2905.6

4239.5

4638.4

5226.9

5624.7

13359.3

4437.9

5264.5

2656.5

8500.9

3049.0

3159.2

2150.7

2772.8

10002.9

11573.1

Cash flow after taxes 

21540.7

14527.9

21197.5

23192.1

26134.7

28123.3

66796.7

22189.5

26322.5

13282.7

42504.3

15244.8

15796.0

10753.7

13864.1

50014.5

57865.6

Return CFBT   CFBT/In Inv (cash on cash)

26.0%

15.6%

14.1%

13.9%

12.0%

17.8%

18.9%

18.7%

19.0%

9.2%

28.3%

15.4%

14.6%

9.7%

14.9%

16.9%

10.4%

Return CFAT   CFAT/In Inv (cash on cash)

21.6%

13.0%

11.7%

11.6%

10.0%

14.8%

15.7%

15.6%

15.9%

7.7%

23.5%

12.9%

12.1%

8.1%

12.4%

14.0%

8.7%

Return CFBT   CFBT/In Inv (modified)

31.6%

21.2%

19.7%

19.5%

17.6%

23.4%

24.5%

24.3%

24.6%

14.8%

33.9%

21.0%

20.2%

15.3%

20.5%

22.5%

16.0%

Cap. Rate

12.1%

9.5%

9.1%

9.1%

8.6%

10.1%

10.3%

10.3%

10.4%

7.9%

12.7%

9.5%

9.3%

8.1%

9.4%

9.8%

8.2%

Gross income multiplier

7.4%

8.3%

8.8%

8.5%

9.8%

8.3%

7.1%

8.1%

8.5%

10.7%

6.5%

11.1%

11.4%

13.1%

8.5%

10.7%

9.2%