Newmarket Real Estate Realtor for Busy People™
Header Image
Header Image

Friday Harbour For Investors


Friday Harbour for Investors

Get Your ROI if you decide to turn this purchase into an Income Property.

Get a 15-Yr Proforma spreadsheet based on key investment assumptions (rental increases, cost increases, vacancy rate, mortgage balance and interest rate). Cash Flow and Key Ratios are automatically calculated. 

SAMPLE (showing 5-yr results, analysis model goes to 15 or more years)

See Reports for a hardcopy example.

Black Cherry - 2B, 2W , 800SF (as of 2020) 

Income Details = Yearly

Year 1

Year 2

Year 3

Year 4

Year 5

Rental Income

28,800

30,240

31,752

33,340

35,007

Less Vacancy/Bad Debt

864

890

917

944

972

Gross Operating Income

27,936

29,935

30,835

32,395

34,034

Expenses

         

Property Taxes

3,600

3,744

3,894

4,050

4,211

Condo Fees

4,620

4,805

4,997

5,197

5,405

Resort Association Fees

1,500

1,560

1,622

1,687

1,755

Lake Club Fee (suspended for rental)

 

 

 

 

 

Utilities (metered and paid by tenant)

 

 

 

 

 

Advertising

 

 

 

 

 

Property Management Fee (DYI)

 

 

 

 

 

Other Expenses

 

 

 

 

 

Total Expenses

9,720

10,109

10,513

10,934

11,371

           

Income Gain & Return Projections

         

Net Operating Income (NOI)

18,216

19,241

20,322

21,462

22,462

less Mortgage Payments

40% Down, 2.65% , 25 Years

16,424

16,214

16,424

16,424

16,424

Cash Flow (CF) - This Year

1,792

2,818

3,899

5,038

6,240

Cash Flow (CF) - Accumulated 1,792 4,610 8,509 13,547 19,787

Annual Appreciation 8%

42,000

45,360

48,989

52,908

57,141

CF (this Yr) + Mky Growth

43,792

48,178

52,888

57,946

63,380

Estimated Market Value - 8%/yr

567,000

612,360

661,349

714,257

771,397

Mortgage Paydown (MPD)

8,577

8,807

9,044

9,286

9,535

           

Return on Investment Calculations

% % % % %

Simple Return

(CF Accum+ Accum MPD) / Downpayment Annualized

12

  18

21

23

25

Cap Rate Value = NOI/Purchase Price

3.64

3.85

4.06

4.29

4.53

Debt Coverage Ratio - 2.0+  preferred

1.11

1.17

1.24

1.31

1.38

 

         

Net Proceeds

         

Market Value of Home- End of Year

567,000

612,360

661,349

714,257

771,397

Original Mortgage Owed

300,000

300,000

300,000

300,000

300,000

Accumulated Mortgage Paydown

8,577

17,384

26,428

35,714

45,249

Net Proceeds if Sold (Mkt Appreciation + MPD + Cash Flow (todate) less Selling Costs of about 5.25% Mkt Value

25,834

80,256

139,420

203,663

273,349