Real Estate Excel Template 43071 | Flip Analyzer By Calvert Home Mortgage Ontario

Partial file snippet.
Sheet 1: Title (2)

	
	
	
	
		
 
		
		Calvert Home Mortgage
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Investment Corporation
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		Flip Analyzer Tool
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		For Real Estate Investors
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		CHMIC Version 2.0
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		For more information about Calvert Home Mortgage Investment Corporation please visit our web site.
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		www.chmic.ca
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		© 2015 Calvert Home Mortgage Investment Corporation. All rights reserved.
	



Sheet 2: Instructions

	
	
	
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Flip Analyzer Spreadsheet Instructions
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Purpose
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		The Purpose of this spreadshee is to assist real estate investors in evaluating the flipping of real estate.
		
	
		

		There are two spreadsheet tabs to assist you in your analysis
		
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		1
		Flip - Profit
		This spreadsheet assumes you know what profit you would like to make and calculates the MAXIMUM Purchase price for the property.  Your profitability is based on a few assumptions in order to calculate your costs. Items you need to assume include: your purchase price, down payment and mortgage you wish to borrow.
		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		2
		Flip - Sales Price
		This spreadsheet assumes you know what your purchase and sale prices are and it calculates the profit.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		COMPANY INFORMATION
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		This section is for you to enter in your personal contact information if you decide to share this document with other real estate investors, joint venture partners, lenders, or family members. It will make it easy to reference who you are, and your full contact information.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		A
		PROPERTY INFORMATION
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Complete this section with all the relevant address and purchase information about the property being analyzed.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		B
		PURCHASE COSTS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		There are a number of costs associated with buying a property. We have listed typical costs that results from a purchase. Take some time to consider the cost for each of the items listed.
		

		

		

	
	
		

		

		

		

	
	
		

		We recommend that you contact numerous lawyers to find the best rate available.  Some charge more, and others charge less, for the same services.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		C
		SELLING COSTS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		There are a number of costs associated with selling a property. These costs are listed in this section and include a number of spaces to customize any additional costs.
		

		

		

	
	
		

		

		

		

	
	
		

		The Realtor® fees are calculated based on commission of 7% of the first $100,000 and 3% of the balance of the selling price, plus GST.  If you have been able to negotiate a discount on this amount, then enter the amount of the discount in the "Agent Fee discount" line. Example: you only end up paying a buyer's Realtor® fee, or you find a private buyer on your own before completion.  We always recommend that you account for full Realtor® commissions to sell the property.  If you are fortunate enough to sell without a Realtor®, then your savings are a bonus, increasing your returns.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		D
		OPERATING COSTS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		There are a number of costs associated with owning the property.  In this case it accounts for all costs during the time it takes to renovate and sell the property. They are calculated on a monthly basis to provide an accurate estimate as to the carrying/holding costs that will result from owning the property.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		E
		RENOVATION SCHEDULE
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		In this section you will estimate the time that it will take to renovate the property and the time it will take to sell the property. You will also need to estimate the costs associated with renovating the property to achieve a realistic After-Repaired Value.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		We recommend that you estimate conservatively your renovation timeline, allowing for a few extra weeks to cover project delays and work on unforseen items.  Also, consider the time of year your renovation will take place, and account for holiday time which may affect you and your contractor.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Consider in your selling timeframe the time it will take the market and attract a buyer, negotiate with your buyer(s), and then some time waiting for the possession to take place.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		We recommend that in total, you plan for a five month flip, and that you set a goal to complete in 3 months or less.  The scope of your renovation and the current market conditions should be taken into account in this goal setting and planning exercise.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		F
		FINANCING COSTS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		This section determines the financing cost of purchasing the property.  Issues to be aware of: Calvert Home Mortgage charges 15.5% simple interest, with no prepayment penalty if you put the minimum down of $20,000 on your profitable flip.  You may be able to attract a lower mortgage rate if you are able, and choose, to invest a greater down payment, such as 20% of your purchase price. Contact Calvert Home Mortgage to discuss your particular situation.  Consider volume: if you have excess cash to invest in a larger down payment, you will decrease your total costs; however if you have other opportunities to flip a greater number of homes by saving your capital and flipping more in the year, your total profit may be bigger, but putting less money down.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		G
		TOTAL PROJECT COST SUMMARY
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		This section totals all of the costs based on the information you have provided.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Purchasing Costs:
		Total costs from Section B.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Selling Costs:
		Total costs from Section C.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Operating Costs:
		Total costs from Section D, multiplied by the Renovation Schedule from Section E.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Financing Costs:
		Total monthly costs from Section F associated with financing all the debt that was used to purchase the property, multiplied by Renovation Schedule from Section E.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Renovation Costs:
		The total estimated costs from Section E.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Costs:
		This is the sum of all of the costs listed above.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		FLIP ANALYSIS SUMMARY
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Maximum Purchase Price:
		This is the maximum price you can pay for a property to achieve the desired Profit selected in Section F.
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Profit:
		This is a calculation of the sale of the property based on the After Repaired Value (ARV) less the Purchase Price of the property and the associated costs based on the timeline provided.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Cash Needed:
		This is the amount of cash that is required to purchase, finance, renovate, maintain, and sell the property.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Return on Cash Invested:
		Based on the amount of cash that is required, this is the return you are receiving on your investment.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Return on Cash Invested Annualized:
		This is the annualized return on your investment.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Ratio of Cost to ARV:
		This is a good check and balance for you to analyze and consider, and a good tool to compare one investment property to another. A good rule of thumb is to stay below 60%.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		FLIP ANALYSIS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		This section provides an analysis of the project and assumes one of two situations. Either the property took an additional month to rennovate or sell or it took one less month to renovate and sell. This provides you with some sensitivity analysis to understand the time cost of month.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Doing Business with Calvert Home Mortgage
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Calvert Home Mortgage's approval philosophy is simple: if you are likely to be profitable, we are likely to approve your flip.
		

		

		

	
	
		

		Here is what we look for:
		

		

		

	
	
		

		1. Profitability is our first requirement: will you make money?
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		2. We consider your profitability by valuing the property as if it is completed with your planned renovations.  We ask you for your renovation budget, and description of renovations to help us value the property, and confirm your profitability.
		

		

		

	
	
		

		

		

		

	
	
		

		3. We ask for a minimum of $20,000 down payment, and our financing will not exceed 80% of the after-repaired value.  We  may ask for higher down payments in some limited circumstances.
		

		

		

	
	
		

		

		

		

	
	
		

		4. Your renovation costs are your responsibility to cover.  In cases where renovations costs are very high, we may consider a draw mortgage, or you may request us to review a second mortgage, equity take out on other property.  Call us for more details.
		

		

		

	
	
		

		

		

		

	
	
		

		5. Monthly, interest only payments are required while you own the home.
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		On the first flip you do with Calvert Home Mortgage, we will require you to complete an application form. Contact us at 1-888-752-4642 or www.chmic.ca.
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		On all flips, we require the following:
		

		

		

	
	
		

		A. purchase agreement
		

		

		

	
	
		

		B. renovation budget and description
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		We sincerely hope this tool will help you find profitable flips.  When you do, we'd be excited to help you.
		

		

		

	

 
 




Sheet 3: Flip - Sales Price

	
	
	
	
	
	
		
		Sales Price Focused: After Repaired Value Focused

This spreadsheet assumes you know what your purchase and sale price is and it calculates your profit. 
		Flip Analyzer Spreadsheet (Sales Price Focused)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Calvert Home Mortgage Investment Corporation
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Instructions: First enter the "After Repair Value" then complete only the orange shaded fields with your information.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		
		Company Information

This section is for you to enter in your personal contact information if you decide to share this document with other real estate investors, joint venture partners, lenders, or family members. It will make it easy to reference who you are and your contact information.

		COMPANY INFORMATION
		

		A
		
		Property Information

Complete this section with all the relevant address and purchase information about that property being analyzed.
		PROPERTY INFORMATION
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Company Name:
		

		

		Project Name:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		First Name:
		

		

		Street:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Last Name:
		

		

		City:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Street:
		

		

		Province:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		City:
		

		

		Postal Code:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Province:
		

		Postal Code:
		

		

		Property Type:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Phone:
		

		Fax:
		

		

		Purchase Date:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Email:
		

		Website:
		

		

		Notes:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		B
		
		Purchase Costs

There are a number of costs associated to buying a property. Here are some typical costs that results from a purchase. Take some time to consider the cost amounts for each of the items listed.

We recommend that you contact numerous lawyers to find the best rate available.  Some charge more, and others charge less, for the same services.
		PURCHASE COSTS
		

		C
		SELLING COSTS
		

		D
		OPERATING COSTS
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		One-Time
		

		

		One-Time
		

		

		Monthly
		Project total
		% of Total
		

		

		  
		

		

		

		

		

		

		

		

		

	
	
		

		Legal Costs:
		$1,000.00
		

		Real Estate Agent Fee:
		
		Real Estate Commissions

The real estate agent fee in Ontario is 5%. The commission is usually split evenly between the seller's agent and buyer's agent - typically 2.5% to the seller's agent and 2.5% to the buyer's agent. If you have been able to negotiate a discount on this amount, then enter the amount of the discount in the "Agent Fee discount" line. Example: you only end up paying a buyer's real estate agent fee, or you find a private buyer on your own before completion. We always recommend that you account for full realt estate agent commissions to sell the property. If you are fortunate enough to sell without a real estate agent, then your savings are a bonus, increasing your returns.
		$30,000.00
		

		Electrical:
		$100.00
		$300.00
		20%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Real Estate Agent Fee:
		
		Real Estate Agent Fee

While the real estate commission is a cost to the seller, this section is for any fees you might pay to your real estate agent as incentive for working hard to find good flips for you.  There is a separate calculation under "C" Selling Costs to calculate the commissions due when you sell the property.
		$0.00
		

		Real Estate Agent Discount:
		
		Real Estate Agent Discount

Enter in a discount if your Realtor is offering you one.
		

		

		Gas:
		$100.00
		$300.00
		20%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Title Insurance:
		
		Title Insurance

This is normally a cost at your lawyer's office, and is sometimes paid for by the seller if they cannot provide you an RPR (real property report).

		$185.00
		

		Legal Fees:
		$1,000.00
		

		Water/Sewer:
		$45.00
		$135.00
		9%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Title Search:
		$10.00
		

		R.P.R./Title insurance:
		$300.00
		

		Alarm System:
		$0.00
		$0.00
		0%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Appraisal Fee:
		
		Appraisal Fee

Some banks and mortgage companies will require a professional appraisal.

Calvert Home Mortgage conducts their own in-house valuation at no cost to you.  The two advantages of this service is the cost savings, as well as the time savings: we can produce this valuation quickly as part of our review of your deal, and this saves a significant amount of time.  When you receive our approval, you know we've approved the value of the property. 

(We reserve the right to require an outside appraisal. This is only likely on multifamily properties in excess of 4 units, or when the value of the proerty is above $1 million.)
		$0.00
		

		2nd Appraisal:
		$0.00
		

		Lawn Care/Snow Removal:
		$0.00
		$0.00
		0%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Inspection Fee:
		$425.00
		

		Land Transfer Tax:
		
		Land Transfer Tax

There is no land transfer tax in Alberta.  In most provinces this is a cost to the seller.  Check with your real estate agent or lawyer for information on land transfer tax in the province you are operating in.

		$0.00
		

		Insurance:
		
		Property Insurance

While this cost is expressed as a monthly cost, you may pay up front for an annual policy.  If so, adjust the formula so it does not multiply your one time annual premium by the number of months you will own the property for.
		$100.00
		$300.00
		20%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Transfer Tax:
		
		Ontario Land Transfer Tax
Approximately:
- Amounts up to and including $55,000 of the purchase price: tax rate is 0.5%. 
- Amounts exceeding $55,000, up to and including $250,000 of the purchase price: marginal tax rate is 1.0%. 
- Amounts exceeding $250,000, up to and including $400,000 of the purchase price: marginal tax rate is 1.5%.
- Amounts exceeding $400,000 of the purchase price: marginal tax rate is 2%.

Check with your Realtor or lawyer for information on land transfer tax in the province you are operating in.
		$4,475.00
		

		Other:
		$0.00
		

		Property Taxes:
		$150.00
		$450.00
		30%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Property Tax Adjustments:
		
		Property Taxes

On the purchase date, there is a property tax adjustment, which is credited either to the buyer (in the first half of the year) or to the seller (in the second half of the year). Remember that property taxes are always due at the end of June each year, and even if there is an adjustment made on the possession date, if you own the property on June 30th, you will owe the property taxes for that year.  Note that under the Operating Costs section you can input your monthly property tax cost while you own the property.

		$600.00
		

		Other:
		$0.00
		

		Condo Fees:
		$0.00
		$0.00
		0%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		If Property is in Toronto 
(Municipal Land Transfer Tax):
		
		If purchasing a home in Toronto, there is an additional municipal land transfer tax.

Toronto's Land Transfer Tax applies within the following boundaries: Steeles Avenue as the North border, Etobicoke as the West border, Scarborough as the East border and Lake Ontario as the South border.

Toronto's Municipal Land Transfer Tax (MLTT) is calculated the same as Ontario's Land Transfer Tax.
		$0.00
		

		Other:
		$0.00
		

		Other:
		$0.00
		$0.00
		0%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Other:
		$0.00
		

		Other:
		$0.00
		

		Other:
		$0.00
		$0.00
		0%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Purchase Costs:
		$6,695.00
		

		Total Selling Costs:
		$31,300.00
		

		Total Operating Costs:
		$495.00
		$1,485.00
		100.00%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		E
		RENOVATION BUDGET
		

		F 
		FINANCING COSTS
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Number of Months
 to Renovate:
		
		Renovation Timeline

We recommend that you estimate conservatively your renovation timeline, allowing for a few extra weeks to cover project delays and work on unforseen items.  Also, consider the time of year your renovation will take place, and account for holiday time which may affect you and your contractor.
		2 months
		

		After Repaired Value (ARV):
		
		Profit Goal

Protect your profit by estimating fairly and conservatively your After-Repaired Value.  If you are able to sell your property for more than your conservative estimate, then you will have bonused your income, while still protecting your minimum profit to the best of your abilities.

To estimate your After-Repaired Value work with sold comparables in the same neighbourhood, or close in neighbourhoods which are very similar.  Conservatively value the property with the likely low end sale price, and not the high end list price, or low end list price: what you ask for and what you expect to receive are often two different numbers.
		$600,000.00
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Number of Months
 to Sell:
		
		Selling Timeline

Consider in your selling timeframe the time it will take the market and attract a buyer, negotiate with your buyer(s), and then some time waiting for the possession to take place.

We recommend that in total, you plan for a five month flip, and that you set a goal to complete in 3 months or less.  The scope of your renovation and the current market conditions should be taken into account in this goal setting and planning exercise.
		1 months
		

		Purchase Price:
		$400,000.00
		Interest Rate (simple):
		15.50%
		Financing Fees:
		$7,600.00
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		% Fee:
		2.00%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Months:
		3 months
		

		Down Payment:
		
		Down Payment Requirements

When you finance with Calvert Home Mortgage your minimum down payment is $20,000.  We may ask for a higher down payment in some circumstances.  We will not finance more than 80% of the After-Repaired Value (ARV x 80% = maximum financing).

Calvert's focus is to ensure your flip is profitable: we will only approve deals we believe you will be profitable on.
		$20,000.00
		Interest Costs /month:
		
		Monthly Interest

At Calvert Home Mortgage we calculate the monthly payment based on a 31 day month, and for months shorter than 31 days, the extra interest is credited as prepaid interest and the adjustment is made on the payout date.  You are only charged for the exact number of days the mortgage is outstanding.
		$5,102.52
		Total Interest Costs:
		$15,307.55
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Renovation Budget:
		
		Renovation Budget

We recommned you build in a 10% contingency for your renovation budget to cover any unforeseen items or cost overruns.
		$60,000.00
		

		Net Mortgage:
		
		Net Mortgage 

The net mortgage is the amount that the lender will advance in cash to the lawyer at closing of the purchase, and does not include any commitment/financing fees.  The purchase price should equal the down payment plus the net mortgage. 

		$380,000.00
		Interest Costs /day:
		$164.60
		Total Financing Costs:
		$22,907.55
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		G
		TOTAL PROJECT COST SUMMARY
		

		H
		FLIP SUMMARY
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Purchase Costs:
		$6,695.00
		
 
		
		Profit
		$77,612.45
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Operating Costs:
		$1,485.00
		Total Cash Needed:
		
		Total Cash Needed

This the total amount of cash needed that is out of your pocket.  It does not include costs not paid by you up front or during the project (such as the Financing Fees).

Before investing in your project, ensure you have access to this amount of cash, plus a contingency fund if necessary.

		$103,487.55
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Financing Costs:
		$22,907.55
		Return on Cash Invested:
		
		Return on Cash Invested

Your return on cash invested is a calculation of your total profit divided by the cash you invested (out of pocket costs).
		75.00%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Selling Costs:
		$31,300.00
		Return on Cash Invested:
(Annualized)
		
		Annualized Return on Cash Invested

This is the return to you on the capital you invested, annualizing your return.  It takes into account the number of months you expect to own the property for.
		299.99%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Renovation Costs:
		$60,000.00
		Ratio of Costs to ARV:
		
		Ratio of Costs to After-Repaired Value

One measure of your success on your flip, are your total costs, divided by your after repaired value.  

This is the ratio of all of your costs (including out of pocket as well as costs of sale), by your ARV sale price.  

Some investors will favour flips in which they can reduce this ratio as much as possible.  They measure their total effort of time and money (costs) over the end value of the property.  If you have limited cash, and excess deals, pick the most efficient deals that you can limit your capital and time investment.

When you take on a bigger project, with higher costs, you should expect a higher return.


		20.40%
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Costs:
		$122,387.55
		Variable Monthly Costs:
		
		Variable Monthly Costs

Also known as a burn rate: this is your monthly cost to own and maintain the property.

When you are setting your list price, or negotiating your sale and possession date, take into account your burn rate.  Consider if it is more profitable to sell at a lower amount, but get a quicker sale, versus the risk of owning a project longer, even if you project a higher sale price.
		$5,597.52
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		I
		FLIP ANALYSIS
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		What if project takes….
		
		Operating Costs

This is the monthly Operating Costs (section D above), multiplied by the number of months for your renovation and sale, plus or minus one month.



		Operating Cost
		
		Financing Cost

These are your total financing costs including fees and monthly interest.  This includes the number of months you expect to own the property for, plus or minus one month.
		Financing Cost
		Total Cost
		Total Cash Needed
		ROI
		ROI
		Ratio of Costs to ARV
		Profit
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(Annualized)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		One additional month
		$1,980.00
		$28,010.06
		$127,985.06
		$89,085.06
		80.84%
		242.52%
		21.33%
		
		Profit

Assuming you own the property one more month than planned.
		$72,014.94
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		One less month
		$990.00
		$17,805.03
		$116,790.03
		$78,880.03
		105.49%
		632.94%
		19.47%
		
		Profit

Assuming you own the property one less month than planned.
		$83,209.97
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		© 2015 Calvert Home Mortgage Investment Corporation. All rights reserved.
The words contained in this file might help you see if this file matches what you are looking for:

...Sheet title calvert home mortgage investment corporation flip analyzer tool for real estate investors chmic version more information about please visit our web site wwwchmicca copy all rights reserved instructions spreadsheet purpose the of this spreadshee is to assist in evaluating flipping there are two tabs you your analysis profit assumes know what would like make and calculates maximum purchase price property profitability based on a few assumptions order calculate costs items need assume include down payment wish borrow sales sale prices it company section enter personal contact if decide share document with other joint venture partners lenders or family members will easy reference who full complete relevant address being analyzed b number associated buying we have listed typical that results from take some time consider cost each recommend numerous lawyers find best rate available charge others less same services c selling these spaces customize any additional realtor reg fees c...
Related files

Share

Help

Related files

Share

Share to social media

Help

Login Area
