The Numbers
When it comes to the analysis of numbers many people have gotten rich. And I don't mean from real estate. I mean that spreadsheet programs and number crunching analysis gets too much attention from real estate scam artists. And I am mainly referring to costly real estate programs where complex spreadsheets, bar graphs and pie charts display income, expenses, and loan payments in a myriad of ways. There is a great epitaph that works here "Bull** baffles brains". For small multi-family or commercial projects ( under 1 million) the following example will be all that you will need to make a purchase decision. Whether you are buying in Simcoe County ( Barrie, Midland, Innifil or Orillia) this speadsheet appliues to any property.
Please keep in mind this is a simplified version and with the inclusion of joint ventures or complex VTB's this spreadsheet may not suffice. But in my opinion it's all that you need to make a intelligent decision on a simple deal. ( Keep It Simple Stupid)
The financial statement is one of the first things you need to review before inputing information into any spreadsheet analysis. I will review the financial statement at a later session. It is a good idea to learn what to look for in a financial statement to access the properties strengths / weaknesses. I will first go through the basics of spreadsheet analysis by laying out necessary calculations and what they mean to your potential investment before looking a property financial statement. Learn the spreadsheet and you will learn what to look for in the financial statement.
The fully functional real estate analysis spreadsheet below is available for download from our website at www.manainvestments.com
You will notice Instruction/ explanations along the side for your guidance
| QUICK PROPERTY ANALYZER | Instructions | ||||
| Property Address: | Input amounts into GREY areas only | ||||
| Purchase Price | $200,000 | Enter purchase price | |||
| Gross Rents | Monthly | Annually | |||
| Total Rents | $2,000 | $24,000 | Enter total monthly rents collected | ||
| Operating Expenses | % | Monthly | Annually | ||
| Insurance | 4% | $80 | $960 | Enter required % amount (usually 5%) | |
| Vacancy | 3% | $60 | $720 | Enter required % amount (depends on area...usually 3%) | |
| Maintenance | 5% | $100 | $1,200 | Enter required % amount (usually 5%) | |
| Management | 6% | $120 | $1,440 | Enter required % amount (usually 5%) | |
| Condo Fees (if applicable) | $0 | $0 | Enter required $ amount from seller | ||
| Utilities | $320 | $3,840 | Enter required $ amount from seller | ||
| Property Taxes | $196 | $2,352 | Enter required $ amount from seller | ||
| Total Operating Income | $876 | $10,512 | |||
| Net Operating Income | $1,124 | $13,488 | |||
| Mortgage/Loan Information | LTV | Amount | LTV = "Loan to Value" | ||
| 1st Mortgage | 75% | $150,000 | Enter % of requested 1st mortgage | ||
| 2nd Mortgage | 10% | $20,000 | Enter % of requested 2nd mortgage | ||
| Financing | Rate | Monthly | Annually | ||
| 1st Mortgage Payment | 2.00% | $640 | $7,683 | Enter % of expected interest rate for 1st | |
| 2nd Mortgage Payment | 1.00% | $76 | $908 | Enter % of expected interest rate for 2nd | |
| Total Financing Payments | $8,591 | ||||
| Debt Service Ratios | |||||
| Debt Service Coverage Ratio (DSCR) | 1.22 | Desired minimum amount = 1.10 | |||
| CAP Rate | 6.74% | Desired minimum amount = 6% ( the higher the better) | |||
Mark Vosylius
(705)-812-1033
Email: mark(at) manainvestments com
Mana Investments - www.manainvestments.com - Educating not specualting. Learn techniques and strategies on real estate investing as well as home ownership in the Orillia, Barrie, Innisfil, Collingwood, Midland areas. We specialize in using RRSP's as a 2nd mortgage for real estate investing as well as joint venture agreements and assignment real estate contracts in Ontario
Homes by The Owner - www.homesbytheowner.ca Helping Investors buy and sell real estate properties that cash flow in Simcoe County and surrounding Oro-medonte areas
The Six Steps to Success - www.sixstepstosuccess.com - Get to your financial goal quicker...Helping you achieve success in goal planning.
 |
|
|
Professional Real Estate Investor. We sell investment real estate. We teach others how as well. Our focus is on Education. We are always looking for other real estate professionals to work with.
Barrie & Orillia Still Has Market Appeal to Real Estate Investors
Where are home prices heading and how consumer confidence affects the market
The "Good" behind Housing Price Corrections in Barrie,Orillia and Midland
Canadian Real Estate...is it affected by the negative Stock Market Headlines?
Canadian Real Estate News Headlines...is the economy Up or Down???
Barrie- Cash boost to help Real Estate Market
RippleEffect from Forbes Top 10 List to be felt as far as Barrie-Orillia
Just Reminder...We Invest in our local Barrie and Orillia real estate
ActiveRain Corp. is not responsible for the accuracy of the site's content (which is written by members of the ActiveRain Real Estate Network) and does not endorse the views of the real estate agents, mortgage brokers, and others listed here.
Powered by the ActiveRain Real Estate Network
© 2012 ActiveRain Corp. All Rights Reserved
