Visit our US site at: www.bplans.comhide this bar
 
Edit This Plan

Real Estate Management Business Plan

MSN Real Estate

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8  

Financial Plan

We want to finance growth mainly through cash flow. We recognize that this means we will have to grow more slowly than we might like.

The most important factor in our case is collection days. We can't push our clients hard on collection days. Therefore, we need to develop a permanent system of receivables financing, using one of the established financial companies in that business.

7.3 Important Assumptions

MSN's plan depends on the assumptions that are made in the following table. These are annual and monthly assumptions that show the consistent growth of the company. Since we operate on a monthly collection basis, we are assuming that the majority of the collections will be timely and in full.

Some of the underlying assumptions are:

  1. We assume a healthy growth trend in the local real estate market, along with a continued strong local economy.
  2. We assume that we stay in line with the continuing advances in technology and housing.

7.4 Key Financial Indicators

The following chart indicates our key financial indicators for the first three years. MSN foresees growth in both unit rentals as well as increasing the percentage of growth margin.

MSN's cash flow depends on the monthly collection from the renters. We allow for a 25-day grace period, after which unpaid accounts will inhibit our cash flow. However, since we collect on a monthly basis, cash flow should maintain at a steady level.

7.5 Break-even Analysis

The following table and chart summarize our break-even analysis. With per month fixed costs and a variable per-unit cost, the number of units we will need to rent out to cover our monthly costs is shown below. MSN's first housing complex will consist of 40 units. According to the calculations, we will break-even within our first year of operation.

The break-even assumes that all units will be occupied and that all rent will be paid in a timely manner. This assumption is probably unrealistic; therefore our initial break-even per unit will most likely be higher.

Break-even Analysis
Monthly Units Break-even 37
Monthly Revenue Break-even £25,243
Assumptions:
Average Per-Unit Revenue £680.22
Average Per-Unit Variable Cost £357.71
Estimated Monthly Fixed Cost £11,968

7.6 Projected Profit and Loss

The projected profit and loss for MSN is shown on the following table. Sales are increasing in 1999 and continue steadily after the third year. We show a net profit in 2000. We are projecting a healthy gross margin for the first year. This is an aggressive projection that will help our efforts to keep total cost of sales low while increasing gross margin. We will also have very low marketing costs, due to the public exposure to the units, and good word of mouth around the university area.

The planned projections are included in the attached Profit and Loss Table.

Pro Forma Profit and Loss
1999 2000 2001
Sales £437,380 £538,498 £612,756
Direct Cost of Sales £230,009 £255,740 £273,136
Other Costs of Sales £0 £0 £0
Total Cost of Sales £230,009 £255,740 £273,136
Gross Margin £207,371 £282,758 £339,620
Gross Margin % 47.41% 52.51% 55.42%
Expenses
Payroll £90,600 £105,000 £128,000
Marketing/Promotion £13,800 £14,000 £17,700
Depreciation £12,221 £13,000 £19,333
Leased Equipment £2,400 £2,600 £2,800
Utilities £7,200 £8,200 £8,500
Insurance £14,400 £1,550 £1,600
Maintenance £0 £12,000 £15,000
Rent £3,000 £4,000 £5,000
Payroll Taxes £0 £0 £0
Other £0 £0 £0
Total Operating Expenses £143,621 £160,350 £197,933
Profit Before Interest and Taxes £63,750 £122,408 £141,687
EBITDA £75,971 £135,408 £161,020
Interest Expense £107,797 £107,129 £105,199
Taxes Incurred £0 £0 £0
Net Profit (£44,047) £15,279 £36,488
Net Profit/Sales -10.07% 2.84% 5.95%

7.7 Projected Cash Flow

The following cash flow projections are a key part of MSN's early success. The monthly cash flow is shown in the illustration, with one bar representing the cash flow per month, and the other the monthly balance. The annual cash flow figures are included here and the more important detailed monthly numbers are included in the appendix.

Pro Forma Cash Flow
1999 2000 2001
Cash Received
Cash from Operations
Cash Sales £437,380 £538,498 £612,756
Subtotal Cash from Operations £437,380 £538,498 £612,756
Additional Cash Received
Sales Tax, VAT, HST/GST Received £0 £0 £0
New Current Borrowing £8,400 £15,000 £12,000
New Other Liabilities (interest-free) £1,802 £2,500 £2,000
New Long-term Liabilities £4,500 £13,000 £2,500
Sales of Other Current Assets £0 £0 £0
Sales of Long-term Assets £0 £0 £0
New Investment Received £5,862 £6,000 £4,000
Subtotal Cash Received £457,944 £574,998 £633,256
Expenditures 1999 2000 2001
Expenditures from Operations
Cash Spending £90,600 £105,000 £128,000
Bill Payments £345,142 £409,268 £426,986
Subtotal Spent on Operations £435,742 £514,268 £554,986
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out £0 £0 £0
Principal Repayment of Current Borrowing £2,750 £5,000 £10,000
Other Liabilities Principal Repayment £650 £1,000 £1,000
Long-term Liabilities Principal Repayment £23,121 £24,469 £41,645
Purchase Other Current Assets £0 £0 £0
Purchase Long-term Assets £1,080,000 £570,000 £0
Dividends £0 £0 £0
Subtotal Cash Spent £1,542,263 £1,114,737 £607,631
Net Cash Flow (£1,084,319) (£539,739) £25,625
Cash Balance £27,011 (£512,728) (£487,103)

7.8 Projected Balance Sheet

The balance sheet in the following table shows varying but managed net worth, and a sufficiently healthy financial position. The monthly estimates are included in the appendix and are a good indicator of MSN's annual value.

Pro Forma Balance Sheet
1999 2000 2001
Assets
Current Assets
Cash £27,011 (£512,728) (£487,103)
Other Current Assets £12,000 £12,000 £12,000
Total Current Assets £39,011 (£500,728) (£475,103)
Long-term Assets
Long-term Assets £1,200,000 £1,770,000 £1,770,000
Accumulated Depreciation £12,221 £25,221 £44,554
Total Long-term Assets £1,187,779 £1,744,779 £1,725,446
Total Assets £1,226,790 £1,244,051 £1,250,343
Liabilities and Capital 1999 2000 2001
Current Liabilities
Accounts Payable £37,354 £33,306 £35,255
Current Borrowing £10,650 £20,650 £22,650
Other Current Liabilities £1,152 £2,652 £3,652
Subtotal Current Liabilities £49,156 £56,608 £61,557
Long-term Liabilities £1,061,379 £1,049,910 £1,010,765
Total Liabilities £1,110,535 £1,106,518 £1,072,322
Paid-in Capital £251,862 £257,862 £261,862
Retained Earnings (£91,560) (£135,607) (£120,329)
Earnings (£44,047) £15,279 £36,488
Total Capital £116,255 £137,533 £178,021
Total Liabilities and Capital £1,226,790 £1,244,051 £1,250,343
Net Worth £116,255 £137,533 £178,021

7.9 Business Ratios

The business ratios for the years of this plan are shown below. They point out MSN's liquidity, debt, performance and some other important aspects. We expect to generate acceptable ratios for our profitability and return. Industry profile ratios based on the NAICS code 531110, Lessors of Residential Buildings and Dwellings, are shown for comparison.

Ratio Analysis
1999 2000 2001 Industry Profile
Sales Growth 0.00% 23.12% 13.79% 4.77%
Percent of Total Assets
Other Current Assets 0.98% 0.96% 0.96% 40.83%
Total Current Assets 3.18% -40.25% -38.00% 46.21%
Long-term Assets 96.82% 140.25% 138.00% 53.79%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 4.01% 4.55% 4.92% 12.55%
Long-term Liabilities 86.52% 84.39% 80.84% 35.36%
Total Liabilities 90.52% 88.94% 85.76% 47.91%
Net Worth 9.48% 11.06% 14.24% 52.09%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 47.41% 52.51% 55.42% 100.00%
Selling, General & Administrative Expenses 57.48% 49.67% 49.47% 59.39%
Advertising Expenses 2.79% 2.41% 3.16% 0.88%
Profit Before Interest and Taxes 14.58% 22.73% 23.12% 2.37%
Main Ratios
Current 0.79 -8.85 -7.72 1.90
Quick 0.79 -8.85 -7.72 1.28
Total Debt to Total Assets 90.52% 88.94% 85.76% 59.42%
Pre-tax Return on Net Worth -37.89% 11.11% 20.50% 0.30%
Pre-tax Return on Assets -3.59% 1.23% 2.92% 0.73%
Additional Ratios 1999 2000 2001
Net Profit Margin -10.07% 2.84% 5.95% n.a
Return on Equity -37.89% 11.11% 20.50% n.a
Activity Ratios
Accounts Payable Turnover 10.14 12.17 12.17 n.a
Payment Days 27 32 29 n.a
Total Asset Turnover 0.36 0.43 0.49 n.a
Debt Ratios
Debt to Net Worth 9.55 8.05 6.02 n.a
Current Liab. to Liab. 0.04 0.05 0.06 n.a
Liquidity Ratios
Net Working Capital (£10,145) (£557,336) (£536,660) n.a
Interest Coverage 0.59 1.14 1.35 n.a
Additional Ratios
Assets to Sales 2.80 2.31 2.04 n.a
Current Debt/Total Assets 4% 5% 5% n.a
Acid Test 0.79 -8.85 -7.72 n.a
Sales/Net Worth 3.76 3.92 3.44 n.a
Dividend Payout 0.00 0.00 0.00 n.a
previous
next
Edit This Plan
Break-even Analysis
Monthly Units Break-even 37
Monthly Revenue Break-even £25,243
Assumptions:
Average Per-Unit Revenue £680.22
Average Per-Unit Variable Cost £357.71
Estimated Monthly Fixed Cost £11,968
Pro Forma Profit and Loss
1999 2000 2001
Sales £437,380 £538,498 £612,756
Direct Cost of Sales £230,009 £255,740 £273,136
Other Costs of Sales £0 £0 £0
Total Cost of Sales £230,009 £255,740 £273,136
Gross Margin £207,371 £282,758 £339,620
Gross Margin % 47.41% 52.51% 55.42%
Expenses
Payroll £90,600 £105,000 £128,000
Marketing/Promotion £13,800 £14,000 £17,700
Depreciation £12,221 £13,000 £19,333
Leased Equipment £2,400 £2,600 £2,800
Utilities £7,200 £8,200 £8,500
Insurance £14,400 £1,550 £1,600
Maintenance £0 £12,000 £15,000
Rent £3,000 £4,000 £5,000
Payroll Taxes £0 £0 £0
Other £0 £0 £0
Total Operating Expenses £143,621 £160,350 £197,933
Profit Before Interest and Taxes £63,750 £122,408 £141,687
EBITDA £75,971 £135,408 £161,020
Interest Expense £107,797 £107,129 £105,199
Taxes Incurred £0 £0 £0
Net Profit (£44,047) £15,279 £36,488
Net Profit/Sales -10.07% 2.84% 5.95%
Pro Forma Cash Flow
1999 2000 2001
Cash Received
Cash from Operations
Cash Sales £437,380 £538,498 £612,756
Subtotal Cash from Operations £437,380 £538,498 £612,756
Additional Cash Received
Sales Tax, VAT, HST/GST Received £0 £0 £0
New Current Borrowing £8,400 £15,000 £12,000
New Other Liabilities (interest-free) £1,802 £2,500 £2,000
New Long-term Liabilities £4,500 £13,000 £2,500
Sales of Other Current Assets £0 £0 £0
Sales of Long-term Assets £0 £0 £0
New Investment Received £5,862 £6,000 £4,000
Subtotal Cash Received £457,944 £574,998 £633,256
Expenditures 1999 2000 2001
Expenditures from Operations
Cash Spending £90,600 £105,000 £128,000
Bill Payments £345,142 £409,268 £426,986
Subtotal Spent on Operations £435,742 £514,268 £554,986
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out £0 £0 £0
Principal Repayment of Current Borrowing £2,750 £5,000 £10,000
Other Liabilities Principal Repayment £650 £1,000 £1,000
Long-term Liabilities Principal Repayment £23,121 £24,469 £41,645
Purchase Other Current Assets £0 £0 £0
Purchase Long-term Assets £1,080,000 £570,000 £0
Dividends £0 £0 £0
Subtotal Cash Spent £1,542,263 £1,114,737 £607,631
Net Cash Flow (£1,084,319) (£539,739) £25,625
Cash Balance £27,011 (£512,728) (£487,103)
Pro Forma Balance Sheet
1999 2000 2001
Assets
Current Assets
Cash £27,011 (£512,728) (£487,103)
Other Current Assets £12,000 £12,000 £12,000
Total Current Assets £39,011 (£500,728) (£475,103)
Long-term Assets
Long-term Assets £1,200,000 £1,770,000 £1,770,000
Accumulated Depreciation £12,221 £25,221 £44,554
Total Long-term Assets £1,187,779 £1,744,779 £1,725,446
Total Assets £1,226,790 £1,244,051 £1,250,343
Liabilities and Capital 1999 2000 2001
Current Liabilities
Accounts Payable £37,354 £33,306 £35,255
Current Borrowing £10,650 £20,650 £22,650
Other Current Liabilities £1,152 £2,652 £3,652
Subtotal Current Liabilities £49,156 £56,608 £61,557
Long-term Liabilities £1,061,379 £1,049,910 £1,010,765
Total Liabilities £1,110,535 £1,106,518 £1,072,322
Paid-in Capital £251,862 £257,862 £261,862
Retained Earnings (£91,560) (£135,607) (£120,329)
Earnings (£44,047) £15,279 £36,488
Total Capital £116,255 £137,533 £178,021
Total Liabilities and Capital £1,226,790 £1,244,051 £1,250,343
Net Worth £116,255 £137,533 £178,021
Ratio Analysis
1999 2000 2001 Industry Profile
Sales Growth 0.00% 23.12% 13.79% 4.77%
Percent of Total Assets
Other Current Assets 0.98% 0.96% 0.96% 40.83%
Total Current Assets 3.18% -40.25% -38.00% 46.21%
Long-term Assets 96.82% 140.25% 138.00% 53.79%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 4.01% 4.55% 4.92% 12.55%
Long-term Liabilities 86.52% 84.39% 80.84% 35.36%
Total Liabilities 90.52% 88.94% 85.76% 47.91%
Net Worth 9.48% 11.06% 14.24% 52.09%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 47.41% 52.51% 55.42% 100.00%
Selling, General & Administrative Expenses 57.48% 49.67% 49.47% 59.39%
Advertising Expenses 2.79% 2.41% 3.16% 0.88%
Profit Before Interest and Taxes 14.58% 22.73% 23.12% 2.37%
Main Ratios
Current 0.79 -8.85 -7.72 1.90
Quick 0.79 -8.85 -7.72 1.28
Total Debt to Total Assets 90.52% 88.94% 85.76% 59.42%
Pre-tax Return on Net Worth -37.89% 11.11% 20.50% 0.30%
Pre-tax Return on Assets -3.59% 1.23% 2.92% 0.73%
Additional Ratios 1999 2000 2001
Net Profit Margin -10.07% 2.84% 5.95% n.a
Return on Equity -37.89% 11.11% 20.50% n.a
Activity Ratios
Accounts Payable Turnover 10.14 12.17 12.17 n.a
Payment Days 27 32 29 n.a
Total Asset Turnover 0.36 0.43 0.49 n.a
Debt Ratios
Debt to Net Worth 9.55 8.05 6.02 n.a
Current Liab. to Liab. 0.04 0.05 0.06 n.a
Liquidity Ratios
Net Working Capital (£10,145) (£557,336) (£536,660) n.a
Interest Coverage 0.59 1.14 1.35 n.a
Additional Ratios
Assets to Sales 2.80 2.31 2.04 n.a
Current Debt/Total Assets 4% 5% 5% n.a
Acid Test 0.79 -8.85 -7.72 n.a
Sales/Net Worth 3.76 3.92 3.44 n.a
Dividend Payout 0.00 0.00 0.00 n.a