{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Title","Instructions","Flip - Profit","Flip - Sales Price","Data sheet"],"not_rendered":{"charts":2,"images":5,"external_links":2,"defined_names":6,"comments":62},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Title","index":0,"n_rows":20,"n_cols":19,"rows_kept":20,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[{"$nulls":5},"Calvert Home Mortgage"]
[{"$nulls":5},"Investment Corporation"]
[]
[]
[]
[{"$nulls":5},"Flip Analyzer Tool"]
[{"$nulls":5},"For Real Estate Investors"]
[]
[]
[{"$nulls":5},"CHMIC Version 2.0"]
[{"$nulls":5},"For more information about Calvert Home Mortgage Investment Corporation please visit our web site."]
[{"$nulls":13},"www.chmic.ca"]
[]
[]
[{"$nulls":18},"© 2015 Calvert Home Mortgage Investment Corporation. All rights reserved."]

{"sheet":"Instructions","index":1,"n_rows":130,"n_cols":15,"rows_kept":130,"merged":[[1,1,2,40],[1,49,1,53],[4,1,5,17],[6,1,6,43],[7,1,7,43],[9,2,9,5],[9,6,11,40],[10,1,10,5],[12,2,12,7],[12,8,12,40],[14,1,15,17],[16,1,17,40],[19,1,20,2],[19,3,20,17],[21,1,21,40],[23,1,24,2],[23,3,24,17],[25,1,26,40],[27,1,28,40],[30,1,31,2],[30,3,31,17],[32,1,33,40],[34,1,38,40],[40,1,41,2],[40,3,41,17],[42,1,44,40],[46,1,47,2],[46,3,47,17],[48,1,49,40],[51,1,53,40],[55,1,56,40],[58,1,59,40],[61,1,62,2],[61,3,62,17],[63,1,69,40],[71,1,72,2],[71,3,72,17],[73,1,73,40],[75,1,75,8],[75,9,75,40],[77,1,77,8],[77,9,77,40],[79,1,79,8],[79,9,79,40],[81,1,81,8],[81,9,82,40],[84,1,84,8],[84,9,84,40],[86,1,86,8],[86,9,86,40],[88,1,89,17],[90,1,90,9],[90,10,91,39],[92,1,92,8],[92,9,93,40],[95,1,95,8],[95,9,95,40],[97,1,97,9],[97,10,97,40],[99,1,99,13],[99,14,99,40],[101,1,101,8],[101,9,102,40],[104,1,105,17],[106,1,107,40],[109,1,110,17],[111,1,111,40],[112,1,112,40],[114,1,115,40],[116,1,117,40],[118,1,119,40],[120,1,120,40],[122,1,123,40],[125,1,125,40],[126,1,126,40],[127,1,127,40],[129,1,129,40]],"flags":["formulas_cached_only"]}
[]
[null,"Flip Analyzer Spreadsheet Instructions"]
[]
[]
[null,"Purpose"]
[]
[null,"The Purpose of this spreadshee is to assist real estate investors in evaluating the flipping of real estate."]
[null,"There are two spreadsheet tabs to assist you in your analysis"]
[]
[null,1,"Flip - Profit",{"$nulls":3},"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."]
[]
[]
[null,2,"Flip - Sales Price",{"$nulls":5},"This spreadsheet assumes you know what your purchase and sale prices are and it calculates the profit."]
[]
[null,"COMPANY INFORMATION"]
[]
[null,"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."]
[]
[]
[null,"A",null,"PROPERTY INFORMATION"]
[]
[null,"Complete this section with all the relevant address and purchase information about the property being analyzed."]
[]
[null,"B",null,"PURCHASE COSTS"]
[]
[null,"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."]
[]
[null,"We recommend that you contact numerous lawyers to find the best rate available.  Some charge more, and others charge less, for the same services."]
[]
[]
[null,"C",null,"SELLING COSTS"]
[]
[null,"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."]
[]
[null,"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."]
[]
[]
[]
[]
[]
[null,"D",null,"OPERATING COSTS"]
[]
[null,"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."]
[]
[]
[]
[null,"E",null,"RENOVATION SCHEDULE"]
[]
[null,"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."]
[]
[]
[null,"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."]
[]
[]
[]
[null,"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."]
[]
[]
[null,"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."]
[]
[]
[null,"F",null,"FINANCING COSTS"]
[]
[null,"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 $10,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."]
{"$rows_empty":7}
[null,"G",null,"TOTAL PROJECT COST SUMMARY"]
[]
[null,"This section totals all of the costs based on the information you have provided."]
[]
[null,"Total Purchasing Costs:",{"$nulls":7},"Total costs from Section B."]
[]
[null,"Total Selling Costs:",{"$nulls":7},"Total costs from Section C."]
[]
[null,"Total Operating Costs:",{"$nulls":7},"Total costs from Section D, multiplied by the Renovation Schedule from Section E."]
[]
[null,"Total Financing Costs:",{"$nulls":7},"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."]
[]
[]
[null,"Renovation Costs:",{"$nulls":7},"The total estimated costs from Section E."]
[]
[null,"Total Costs:",{"$nulls":7},"This is the sum of all of the costs listed above."]
[]
[null,"FLIP ANALYSIS SUMMARY"]
[]
[null,"Maximum Purchase Price:",{"$nulls":8},"This is the maximum price you can pay for a property to achieve the desired Profit selected in Section F."]
[]
[null,"Profit:",{"$nulls":7},"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."]
[]
[]
[null,"Total Cash Needed:",{"$nulls":7},"This is the amount of cash that is required to purchase, finance, renovate, maintain, and sell the property."]
[]
[null,"Return on Cash Invested:",{"$nulls":8},"Based on the amount of cash that is required, this is the return you are receiving on your investment."]
[]
[null,"Return on Cash Invested Annualized:",{"$nulls":12},"This is the annualized return on your investment."]
[]
[null,"Ratio of Cost to ARV:",{"$nulls":7},"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%."]
[]
[]
[null,"FLIP ANALYSIS"]
[]
[null,"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."]
[]
[]
[null,"Doing Business with Calvert Home Mortgage"]
[]
[null,"Calvert Home Mortgage's approval philosophy is simple: if you are likely to be profitable, we are likely to approve your flip."]
[null,"Here is what we look for:"]
[null,"1. Profitability is our first requirement: will you make money?"]
[null,"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."]
[]
[null,"3. We ask for a minimum of $10,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."]
[]
[null,"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."]
[]
[null,"5. Monthly, interest only payments are required while you own the home."]
[]
[null,"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."]
[]
[]
[null,"On all flips, we require the following:"]
[null,"A. purchase agreement"]
[null,"B. renovation budget and description"]
[]
[null,"We sincerely hope this tool will help you find profitable flips.  When you do, we'd be excited to help you."]

{"sheet":"Flip - Profit","index":2,"n_rows":75,"n_cols":84,"rows_kept":75,"merged":[[0,0,1,52],[2,0,3,52],[5,1,6,52],[9,1,10,26],[9,28,10,29],[9,30,10,52],[11,1,11,5],[11,6,11,26],[11,28,11,35],[11,36,11,52],[12,1,12,5],[12,6,12,26],[12,28,12,35],[12,36,12,52],[13,1,13,5],[13,6,13,26],[13,28,13,35],[13,36,13,52],[14,1,14,5],[14,6,14,26],[14,28,14,35],[14,36,14,52],[15,1,15,5],[15,6,15,26],[15,28,15,35],[15,36,15,52],[16,1,16,5],[16,6,16,13],[16,14,16,17],[16,18,16,26],[16,28,16,35],[16,36,16,52],[17,1,17,5],[17,6,17,13],[17,14,17,17],[17,18,17,26],[17,28,17,35],[17,36,17,52],[18,1,18,5],[18,6,18,13],[18,14,18,17],[18,18,18,26],[18,28,18,35],[18,36,18,52],[21,1,22,2],[21,3,22,15],[21,17,22,18],[21,19,22,31],[21,33,22,34],[21,35,22,52],[23,1,23,8],[23,9,23,15],[23,17,23,24],[23,25,23,31],[23,33,23,40],[23,41,23,44],[23,45,23,48],[23,49,23,52],[24,1,24,8],[24,9,24,15],[24,17,24,24],[24,25,24,31],[24,33,24,40],[24,41,24,44],[24,45,24,48],[24,49,24,52],[25,1,25,8],[25,9,25,15],[25,17,25,24],[25,25,25,31],[25,33,25,40],[25,41,25,44],[25,45,25,48],[25,49,25,52],[26,1,26,8],[26,9,26,15],[26,17,26,24],[26,25,26,31],[26,33,26,40],[26,41,26,44],[26,45,26,48],[26,49,26,52],[27,1,27,8],[27,9,27,15],[27,17,27,24],[27,25,27,31],[27,33,27,40],[27,41,27,44],[27,45,27,48],[27,49,27,52],[28,1,28,8],[28,9,28,15],[28,17,28,24],[28,25,28,31],[28,33,28,40],[28,41,28,44],[28,45,28,48],[28,49,28,52],[29,1,29,8],[29,9,29,15],[29,17,29,24],[29,25,29,31],[29,33,29,40],[29,41,29,44],[29,45,29,48],[29,49,29,52],[30,1,30,8],[30,9,30,15],[30,17,30,24],[30,25,30,31],[30,33,30,40],[30,41,30,44],[30,45,30,48],[30,49,30,52],[31,1,31,8],[31,9,31,15],[31,17,31,24],[31,25,31,31],[31,33,31,40],[31,41,31,44],[31,45,31,48],[31,49,31,52],[32,1,32,8],[32,9,32,15],[32,17,32,24],[32,25,32,31],[32,33,32,40],[32,41,32,44],[32,45,32,48],[32,49,32,52],[33,1,33,8],[33,9,33,15],[33,17,33,24],[33,25,33,31],[33,33,33,40],[33,41,33,44],[33,45,33,48],[33,49,33,52],[34,1,34,8],[34,9,34,15],[34,17,34,24],[34,25,34,31],[34,33,34,40],[34,41,34,44],[34,45,34,48],[34,49,34,52],[37,1,38,2],[37,3,38,15],[37,17,38,18],[37,19,38,52],[39,1,40,8],[39,9,40,15],[39,17,40,22],[39,23,40,28],[39,29,39,34],[39,35,40,40],[39,41,40,46],[39,47,40,52],[39,53,40,60],[39,61,40,67],[39,68,40,75],[39,76,40,82],[40,29,40,31],[40,32,40,34],[41,1,42,8],[41,9,42,15],[41,17,42,22],[41,23,42,28],[41,29,42,34],[41,35,42,40],[41,41,41,46],[41,47,42,52],[41,53,42,60],[41,61,42,67],[41,68,42,75],[41,76,42,82],[41,83,41,88],[42,41,42,43],[42,44,42,46],[42,83,42,88],[43,1,44,8],[43,9,44,15],[43,17,44,22],[43,23,44,28],[43,29,44,34],[43,35,44,40],[43,41,44,46],[43,47,44,52],[43,53,44,60],[43,61,44,67],[43,68,44,75],[43,76,44,82],[45,1,46,8],[45,9,46,15],[45,17,46,22],[45,23,46,28],[45,29,46,34],[45,35,46,40],[45,41,46,46],[45,47,46,52],[45,53,46,60],[45,61,46,67],[45,68,46,75],[45,76,46,82],[49,1,50,2],[49,3,50,33],[49,35,50,36],[49,37,50,52],[51,1,52,7],[51,8,52,12],[51,35,51,42],[51,43,52,52],[52,35,52,42],[53,1,54,7],[53,8,54,12],[53,35,54,42],[53,43,54,52],[55,1,56,7],[55,8,56,12],[55,35,56,42],[55,43,56,52],[57,1,58,7],[57,8,58,12],[57,35,58,42],[57,43,58,52],[59,1,60,7],[59,8,60,12],[59,35,60,42],[59,43,60,52],[61,1,62,7],[61,8,62,12],[61,35,62,42],[61,43,62,52],[63,35,64,42],[63,43,64,52],[65,1,66,2],[65,3,66,52],[67,1,68,6],[67,7,68,11],[67,12,68,16],[67,17,68,21],[67,22,68,26],[67,27,68,31],[67,32,67,36],[67,37,68,41],[67,42,68,52],[68,32,68,36],[69,1,70,6],[69,7,70,11],[69,12,70,16],[69,17,70,21],[69,22,70,26],[69,27,70,31],[69,32,70,36],[69,37,70,41],[69,42,70,52],[71,1,72,6],[71,7,72,11],[71,12,72,16],[71,17,72,21],[71,22,72,26],[71,27,72,31],[71,32,72,36],[71,37,72,41],[71,42,72,52]],"flags":["formulas_cached_only"]}
["Flip Analyzer Spreadsheet (Profit Focused)"]
[]
["Calvert Home Mortgage Investment Corporation"]
[]
[]
[null,"Instructions: First enter the 'Desired Profit' amount, then complete only the orange shaded fields with your information."]
[]
[]
[]
[null,"COMPANY INFORMATION",{"$nulls":26},"A",null,"PROPERTY INFORMATION"]
[]
[null,"Company Name:",{"$nulls":26},"Project Name:"]
[null,"First Name:",{"$nulls":26},"Street:"]
[null,"Last Name:",{"$nulls":26},"City:"]
[null,"Street:",{"$nulls":26},"Province:"]
[null,"City:",{"$nulls":26},"Postal Code:"]
[null,"Province:",{"$nulls":12},"Postal Code:",{"$nulls":13},"Property Type:"]
[null,"Phone:",{"$nulls":12},"Fax:",{"$nulls":13},"Purchase Date:"]
[null,"Email:",{"$nulls":12},"Website:",{"$nulls":13},"Notes:"]
[]
[]
[null,"B",null,"PURCHASE COSTS",{"$nulls":13},"C",null,"SELLING COSTS",{"$nulls":13},"D",null,"OPERATING COSTS"]
[]
[{"$nulls":9},"One-Time",{"$nulls":15},"One-Time",{"$nulls":15},"Monthly",{"$nulls":3},"Project total",{"$nulls":3},"% of Total"]
[null,"Legal Costs:",{"$nulls":7},{"v":1000,"d":"$1,000.00"},{"$nulls":7},"Real Estate Agent Fee:",{"$nulls":7},{"v":18060,"d":"$18,060.00"},{"$nulls":7},"Electrical:",{"$nulls":7},{"v":100,"d":"$100.00"},{"$nulls":3},{"v":500,"d":"$500.00"},{"$nulls":3},{"v":0.19230769230769232,"d":"19%"}]
[null,"Real Estate Agent Fee:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Real Estate Agent Discount:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Gas:",{"$nulls":7},{"v":100,"d":"$100.00"},{"$nulls":3},{"v":500,"d":"$500.00"},{"$nulls":3},{"v":0.19230769230769232,"d":"19%"}]
[null,"Title Insurance:",{"$nulls":7},{"v":185,"d":"$185.00"},{"$nulls":7},"Legal Fees:",{"$nulls":7},{"v":1000,"d":"$1,000.00"},{"$nulls":7},"Water/Sewer:",{"$nulls":7},{"v":45,"d":"$45.00"},{"$nulls":3},{"v":225,"d":"$225.00"},{"$nulls":3},{"v":0.08653846153846154,"d":"9%"}]
[null,"Title Search:",{"$nulls":7},{"v":10,"d":"$10.00"},{"$nulls":7},"R.P.R./Title insurance:",{"$nulls":7},{"v":300,"d":"$300.00"},{"$nulls":7},"Alarm System:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Appraisal Fee:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"2nd Appraisal:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Lawn Care/Snow Removal:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Inspection Fee:",{"$nulls":7},{"v":425,"d":"$425.00"},{"$nulls":7},"Land Transfer Tax:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Insurance:",{"$nulls":7},{"v":120,"d":"$120.00"},{"$nulls":3},{"v":600,"d":"$600.00"},{"$nulls":3},{"v":0.23076923076923078,"d":"23%"}]
[null,"Land Transfer Tax:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Property Taxes:",{"$nulls":7},{"v":155,"d":"$155.00"},{"$nulls":3},{"v":775,"d":"$775.00"},{"$nulls":3},{"v":0.2980769230769231,"d":"30%"}]
[null,"Property Tax Adjustments:",{"$nulls":7},{"v":600,"d":"$600.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Condo Fees:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Other:",{"$nulls":15},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Total Purchase Costs:",{"$nulls":7},{"v":2220,"d":"$2,220.00"},{"$nulls":7},"Total Selling Costs:",{"$nulls":7},{"v":19360,"d":"$19,360.00"},{"$nulls":7},"Total Operating Costs:",{"$nulls":7},{"v":520,"d":"$520.00"},{"$nulls":3},{"v":2600,"d":"$2,600.00"},{"$nulls":3},{"v":1,"d":"100.00%"}]
[]
[]
[null,"E",null,"RENOVATION BUDGET",{"$nulls":13},"F ",null,"FINANCING COSTS"]
[]
[null,"Number of Months\n to Renovate:",{"$nulls":7},2,{"$nulls":7},"Desired Profit:",{"$nulls":5},{"v":25000,"d":"$25,000.00"}]
[]
[null,"Number of Months\n to Sell:",{"$nulls":7},3,{"$nulls":7},"After Repaired Value (ARV):",{"$nulls":5},{"v":440000,"d":"$440,000.00"},{"$nulls":5},"Interest Rate (simple):",{"$nulls":5},{"v":0.155,"d":"15.50%"},{"$nulls":5},"Financing Fees:",{"$nulls":5},{"v":9600,"d":"$9,600.00"},{"$nulls":35},"Interest cost /day"]
[{"$nulls":41},"% Fee:",null,null,{"v":0.03,"d":"3.00%"},{"$nulls":38},{"v":0,"d":"$0.00"}]
[null,"Total Months:",{"$nulls":7},5,{"$nulls":7},"Down Payment:",{"$nulls":5},{"v":10000,"d":"$10,000.00"},{"$nulls":5},"Interest Costs /month:",{"$nulls":5},{"v":4338.9808219178085,"d":"$4,338.98"},{"$nulls":5},"Total Interest Costs:",{"$nulls":5},{"v":21286.666666666668,"d":"$21,286.67"}]
[]
[null,"Renovation Budget:",{"$nulls":7},{"v":30000,"d":"$30,000.00"},{"$nulls":7},"Net Mortgage:",{"$nulls":5},{"v":320000,"d":"$320,000.00"},{"$nulls":5},"Interest Costs /day:",{"$nulls":5},{"v":139.96712328767123,"d":"$139.97"},{"$nulls":5},"Total Financing Costs:",{"$nulls":5},{"v":30886.666666666668,"d":"$30,886.67"}]
[]
[]
[]
[null,"G",null,"TOTAL PROJECT COST SUMMARY",{"$nulls":31},"H",null,"FLIP SUMMARY"]
[]
[null,"Total Purchase Costs:",{"$nulls":6},{"v":2220,"d":"$2,220.00"},{"$nulls":26},"Maximum",{"$nulls":7},{"v":329933.3333333333,"d":"$329,933.33"}]
[{"$nulls":35},"Purchase Price"]
[null,"Total Operating Costs:",{"$nulls":6},{"v":2600,"d":"$2,600.00"},{"$nulls":26},"Total Cash Needed:",{"$nulls":7},{"v":66106.66666666667,"d":"$66,106.67"}]
[]
[null,"Total Financing Costs:",{"$nulls":6},{"v":30886.666666666668,"d":"$30,886.67"},{"$nulls":26},"Return on Cash Invested:",{"$nulls":7},{"v":0.37817668414683336,"d":"37.82%"}]
[]
[null,"Total Selling Costs:",{"$nulls":6},{"v":19360,"d":"$19,360.00"},{"$nulls":26},"Return on Cash Invested:\n(Annualized)",{"$nulls":7},{"v":0.9076240419524,"d":"90.76%"}]
[]
[null,"Renovation Costs:",{"$nulls":6},{"v":30000,"d":"$30,000.00"},{"$nulls":26},"Ratio of Costs to ARV:",{"$nulls":7},{"v":0.19333333333333336,"d":"19.33%"}]
[]
[null,"Total Costs:",{"$nulls":6},{"v":85066.66666666667,"d":"$85,066.67"},{"$nulls":26},"Variable Monthly Costs:",{"$nulls":7},{"v":4858.9808219178085,"d":"$4,858.98"}]
[]
[]
[]
[null,"I",null,"FLIP ANALYSIS"]
[]
[null,"What if project takes….",{"$nulls":5},"Operating Cost",{"$nulls":4},"Financing Cost",{"$nulls":4},"Total Cost",{"$nulls":4},"Total Cash Needed",{"$nulls":4},"ROI",{"$nulls":4},"ROI",{"$nulls":4},"Ratio of Costs to ARV",{"$nulls":4},"Maximum Purchase Price"]
[{"$nulls":32},"(Annualized)"]
[null,"One additional month",{"$nulls":5},{"v":3120,"d":"$3,120.00"},{"$nulls":4},{"v":35633.88493150685,"d":"$35,633.88"},{"$nulls":4},{"v":90333.88493150685,"d":"$90,333.88"},{"$nulls":4},{"v":61373.88493150685,"d":"$61,373.88"},{"$nulls":4},{"v":0.4073393761515986,"d":"40.73%"},{"$nulls":4},{"v":0.8146787523031972,"d":"81.47%"},{"$nulls":4},{"v":0.20530428393524283,"d":"20.53%"},{"$nulls":4},{"v":324666.1150684932,"d":"$324,666.12"}]
[]
[null,"One less month",{"$nulls":5},{"v":2080,"d":"$2,080.00"},{"$nulls":4},{"v":26955.923287671234,"d":"$26,955.92"},{"$nulls":4},{"v":80615.92328767123,"d":"$80,615.92"},{"$nulls":4},{"v":52695.923287671234,"d":"$52,695.92"},{"$nulls":4},{"v":0.4744200014016836,"d":"47.44%"},{"$nulls":4},{"v":1.423260004205051,"d":"142.33%"},{"$nulls":4},{"v":0.18321800747198008,"d":"18.32%"},{"$nulls":4},{"v":334384.07671232877,"d":"$334,384.08"}]
[]
[]
[null,"© 2015 Calvert Home Mortgage Investment Corporation. All rights reserved."]

{"sheet":"Flip - Sales Price","index":3,"n_rows":75,"n_cols":50,"rows_kept":75,"merged":[[0,0,1,52],[2,0,3,52],[5,1,6,52],[9,1,10,26],[9,28,10,29],[9,30,10,52],[11,1,11,5],[11,6,11,26],[11,28,11,35],[11,36,11,52],[12,1,12,5],[12,6,12,26],[12,28,12,35],[12,36,12,52],[13,1,13,5],[13,6,13,26],[13,28,13,35],[13,36,13,52],[14,1,14,5],[14,6,14,26],[14,28,14,35],[14,36,14,52],[15,1,15,5],[15,6,15,26],[15,28,15,35],[15,36,15,52],[16,1,16,5],[16,6,16,13],[16,14,16,17],[16,18,16,26],[16,28,16,35],[16,36,16,52],[17,1,17,5],[17,6,17,13],[17,14,17,17],[17,18,17,26],[17,28,17,35],[17,36,17,52],[18,1,18,5],[18,6,18,13],[18,14,18,17],[18,18,18,26],[18,28,18,35],[18,36,18,52],[21,1,22,2],[21,3,22,15],[21,17,22,18],[21,19,22,31],[21,33,22,34],[21,35,22,52],[23,1,23,8],[23,9,23,15],[23,17,23,24],[23,25,23,31],[23,33,23,40],[23,41,23,44],[23,45,23,48],[23,49,23,52],[24,1,24,8],[24,9,24,15],[24,17,24,24],[24,25,24,31],[24,33,24,40],[24,41,24,44],[24,45,24,48],[24,49,24,52],[25,1,25,8],[25,9,25,15],[25,17,25,24],[25,25,25,31],[25,33,25,40],[25,41,25,44],[25,45,25,48],[25,49,25,52],[26,1,26,8],[26,9,26,15],[26,17,26,24],[26,25,26,31],[26,33,26,40],[26,41,26,44],[26,45,26,48],[26,49,26,52],[27,1,27,8],[27,9,27,15],[27,17,27,24],[27,25,27,31],[27,33,27,40],[27,41,27,44],[27,45,27,48],[27,49,27,52],[28,1,28,8],[28,9,28,15],[28,17,28,24],[28,25,28,31],[28,33,28,40],[28,41,28,44],[28,45,28,48],[28,49,28,52],[29,1,29,8],[29,9,29,15],[29,17,29,24],[29,25,29,31],[29,33,29,40],[29,41,29,44],[29,45,29,48],[29,49,29,52],[30,1,30,8],[30,9,30,15],[30,17,30,24],[30,25,30,31],[30,33,30,40],[30,41,30,44],[30,45,30,48],[30,49,30,52],[31,1,31,8],[31,9,31,15],[31,17,31,24],[31,25,31,31],[31,33,31,40],[31,41,31,44],[31,45,31,48],[31,49,31,52],[32,1,32,8],[32,9,32,15],[32,17,32,24],[32,25,32,31],[32,33,32,40],[32,41,32,44],[32,45,32,48],[32,49,32,52],[33,1,33,8],[33,9,33,15],[33,17,33,24],[33,25,33,31],[33,33,33,40],[33,41,33,44],[33,45,33,48],[33,49,33,52],[34,1,34,8],[34,9,34,15],[34,17,34,24],[34,25,34,31],[34,33,34,40],[34,41,34,44],[34,45,34,48],[34,49,34,52],[37,1,38,2],[37,3,38,15],[37,17,38,18],[37,19,38,52],[39,1,40,8],[39,9,40,15],[39,17,40,22],[39,23,40,28],[39,29,39,34],[39,35,40,40],[39,41,40,46],[39,47,40,52],[40,29,40,31],[40,32,40,34],[41,1,42,8],[41,9,42,15],[41,17,42,22],[41,23,42,28],[41,29,42,34],[41,35,42,40],[41,41,41,46],[41,47,42,52],[42,41,42,43],[42,44,42,46],[43,1,44,8],[43,9,44,15],[43,17,44,22],[43,23,44,28],[43,29,44,34],[43,35,44,40],[43,41,44,46],[43,47,44,52],[45,1,46,8],[45,9,46,15],[45,17,46,22],[45,23,46,28],[45,29,46,34],[45,35,46,40],[45,41,46,46],[45,47,46,52],[49,1,50,2],[49,3,50,33],[49,35,50,36],[49,37,50,52],[51,1,52,7],[51,8,52,12],[51,35,52,42],[51,43,52,52],[53,1,54,7],[53,8,54,12],[53,35,54,42],[53,43,54,52],[55,1,56,7],[55,8,56,12],[55,35,56,42],[55,43,56,52],[57,1,58,7],[57,8,58,12],[57,35,58,42],[57,43,58,52],[59,1,60,7],[59,8,60,12],[59,35,60,42],[59,43,60,52],[61,1,62,7],[61,8,62,12],[61,35,62,42],[61,43,62,52],[63,35,64,42],[63,43,64,52],[65,1,66,2],[65,3,66,52],[67,1,68,6],[67,7,68,11],[67,12,68,16],[67,17,68,21],[67,22,68,26],[67,27,68,31],[67,32,67,36],[67,37,68,41],[67,42,68,52],[68,32,68,36],[69,1,70,6],[69,7,70,11],[69,12,70,16],[69,17,70,21],[69,22,70,26],[69,27,70,31],[69,32,70,36],[69,37,70,41],[69,42,70,52],[71,1,72,6],[71,7,72,11],[71,12,72,16],[71,17,72,21],[71,22,72,26],[71,27,72,31],[71,32,72,36],[71,37,72,41],[71,42,72,52]],"flags":["formulas_cached_only"]}
["Flip Analyzer Spreadsheet (Sales Price Focused)"]
[]
["Calvert Home Mortgage Investment Corporation"]
[]
[]
[null,"Instructions: First enter the \"After Repair Value\" then complete only the orange shaded fields with your information."]
[]
[]
[]
[null,"COMPANY INFORMATION",{"$nulls":26},"A",null,"PROPERTY INFORMATION"]
[]
[null,"Company Name:",{"$nulls":26},"Project Name:"]
[null,"First Name:",{"$nulls":26},"Street:"]
[null,"Last Name:",{"$nulls":26},"City:"]
[null,"Street:",{"$nulls":26},"Province:"]
[null,"City:",{"$nulls":26},"Postal Code:"]
[null,"Province:",{"$nulls":12},"Postal Code:",{"$nulls":13},"Property Type:"]
[null,"Phone:",{"$nulls":12},"Fax:",{"$nulls":13},"Purchase Date:"]
[null,"Email:",{"$nulls":12},"Website:",{"$nulls":13},"Notes:"]
[]
[]
[null,"B",null,"PURCHASE COSTS",{"$nulls":13},"C",null,"SELLING COSTS",{"$nulls":13},"D",null,"OPERATING COSTS"]
[]
[{"$nulls":9},"One-Time",{"$nulls":15},"One-Time",{"$nulls":15},"Monthly",{"$nulls":3},"Project total",{"$nulls":3},"% of Total"]
[null,"Legal Costs:",{"$nulls":7},{"v":1000,"d":"$1,000.00"},{"$nulls":7},"Real Estate Agent Fee:",{"$nulls":7},{"v":18060,"d":"$18,060.00"},{"$nulls":7},"Electrical:",{"$nulls":7},{"v":100,"d":"$100.00"},{"$nulls":3},{"v":500,"d":"$500.00"},{"$nulls":3},{"v":0.20202020202020202,"d":"20%"}]
[null,"Real Estate Agent Fee:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Real Estate Agent Discount:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Gas:",{"$nulls":7},{"v":100,"d":"$100.00"},{"$nulls":3},{"v":500,"d":"$500.00"},{"$nulls":3},{"v":0.20202020202020202,"d":"20%"}]
[null,"Title Insurance:",{"$nulls":7},{"v":185,"d":"$185.00"},{"$nulls":7},"Legal Fees:",{"$nulls":7},{"v":1000,"d":"$1,000.00"},{"$nulls":7},"Water/Sewer:",{"$nulls":7},{"v":45,"d":"$45.00"},{"$nulls":3},{"v":225,"d":"$225.00"},{"$nulls":3},{"v":0.09090909090909091,"d":"9%"}]
[null,"Title Search:",{"$nulls":7},{"v":10,"d":"$10.00"},{"$nulls":7},"R.P.R./Title insurance:",{"$nulls":7},{"v":300,"d":"$300.00"},{"$nulls":7},"Alarm System:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Appraisal Fee:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"2nd Appraisal:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Lawn Care/Snow Removal:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Inspection Fee:",{"$nulls":7},{"v":425,"d":"$425.00"},{"$nulls":7},"Land Transfer Tax:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Insurance:",{"$nulls":7},{"v":100,"d":"$100.00"},{"$nulls":3},{"v":500,"d":"$500.00"},{"$nulls":3},{"v":0.20202020202020202,"d":"20%"}]
[null,"Transfer Tax:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Property Taxes:",{"$nulls":7},{"v":150,"d":"$150.00"},{"$nulls":3},{"v":750,"d":"$750.00"},{"$nulls":3},{"v":0.30303030303030304,"d":"30%"}]
[null,"Property Tax Adjustments:",{"$nulls":7},{"v":600,"d":"$600.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Condo Fees:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":7},"Other:",{"$nulls":7},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"0%"}]
[null,"Total Purchase Costs:",{"$nulls":7},{"v":2220,"d":"$2,220.00"},{"$nulls":7},"Total Selling Costs:",{"$nulls":7},{"v":19360,"d":"$19,360.00"},{"$nulls":7},"Total Operating Costs:",{"$nulls":7},{"v":495,"d":"$495.00"},{"$nulls":3},{"v":2475,"d":"$2,475.00"},{"$nulls":3},{"v":1,"d":"100.00%"}]
[]
[]
[null,"E",null,"RENOVATION BUDGET",{"$nulls":13},"F ",null,"FINANCING COSTS"]
[]
[null,"Number of Months\n to Renovate:",{"$nulls":7},2,{"$nulls":7},"After Repaired Value (ARV):",{"$nulls":5},{"v":440000,"d":"$440,000.00"}]
[]
[null,"Number of Months\n to Sell:",{"$nulls":7},3,{"$nulls":7},"Purchase Price:",{"$nulls":5},{"v":330000,"d":"$330,000.00"},{"$nulls":5},"Interest Rate (simple):",{"$nulls":5},{"v":0.155,"d":"15.50%"},{"$nulls":5},"Financing Fees:",{"$nulls":5},{"v":9600,"d":"$9,600.00"}]
[{"$nulls":41},"% Fee:",null,null,{"v":0.03,"d":"3.00%"}]
[null,"Total Months:",{"$nulls":7},5,{"$nulls":7},"Down Payment:",{"$nulls":5},{"v":10000,"d":"$10,000.00"},{"$nulls":5},"Interest Costs /month:",{"$nulls":5},{"v":4338.9808219178085,"d":"$4,338.98"},{"$nulls":5},"Total Interest Costs:",{"$nulls":5},{"v":21694.904109589042,"d":"$21,694.90"}]
[]
[null,"Renovation Budget:",{"$nulls":7},{"v":30000,"d":"$30,000.00"},{"$nulls":7},"Net Mortgage:",{"$nulls":5},{"v":320000,"d":"$320,000.00"},{"$nulls":5},"Interest Costs /day:",{"$nulls":5},{"v":139.96712328767123,"d":"$139.97"},{"$nulls":5},"Total Financing Costs:",{"$nulls":5},{"v":31294.904109589042,"d":"$31,294.90"}]
[]
[]
[]
[null,"G",null,"TOTAL PROJECT COST SUMMARY",{"$nulls":31},"H",null,"FLIP SUMMARY"]
[]
[null,"Total Purchase Costs:",{"$nulls":6},{"v":2220,"d":"$2,220.00"},{"$nulls":26},"Profit",{"$nulls":7},{"v":24650.095890410958,"d":"$24,650.10"}]
[]
[null,"Total Operating Costs:",{"$nulls":6},{"v":2475,"d":"$2,475.00"},{"$nulls":26},"Total Cash Needed:",{"$nulls":7},{"v":66389.90410958904,"d":"$66,389.90"}]
[]
[null,"Total Financing Costs:",{"$nulls":6},{"v":31294.904109589042,"d":"$31,294.90"},{"$nulls":26},"Return on Cash Invested:",{"$nulls":7},{"v":0.3712928376838944,"d":"37.13%"}]
[]
[null,"Total Selling Costs:",{"$nulls":6},{"v":19360,"d":"$19,360.00"},{"$nulls":26},"Return on Cash Invested:\n(Annualized)",{"$nulls":7},{"v":0.8911028104413464,"d":"89.11%"}]
[]
[null,"Renovation Costs:",{"$nulls":6},{"v":30000,"d":"$30,000.00"},{"$nulls":26},"Ratio of Costs to ARV:",{"$nulls":7},{"v":0.19397705479452054,"d":"19.40%"}]
[]
[null,"Total Costs:",{"$nulls":6},{"v":85349.90410958904,"d":"$85,349.90"},{"$nulls":26},"Variable Monthly Costs:",{"$nulls":7},{"v":4833.9808219178085,"d":"$4,833.98"}]
[]
[]
[]
[null,"I",null,"FLIP ANALYSIS"]
[]
[null,"What if project takes….",{"$nulls":5},"Operating Cost",{"$nulls":4},"Financing Cost",{"$nulls":4},"Total Cost",{"$nulls":4},"Total Cash Needed",{"$nulls":4},"ROI",{"$nulls":4},"ROI",{"$nulls":4},"Ratio of Costs to ARV",{"$nulls":4},"Profit"]
[{"$nulls":32},"(Annualized)"]
[null,"One additional month",{"$nulls":5},{"v":2970,"d":"$2,970.00"},{"$nulls":4},{"v":35633.88493150685,"d":"$35,633.88"},{"$nulls":4},{"v":90183.88493150685,"d":"$90,183.88"},{"$nulls":4},{"v":61223.88493150685,"d":"$61,223.88"},{"$nulls":4},{"v":0.3236664104321717,"d":"32.37%"},{"$nulls":4},{"v":0.6473328208643434,"d":"64.73%"},{"$nulls":4},{"v":0.20496337484433375,"d":"20.50%"},{"$nulls":4},{"v":19816.11506849315,"d":"$19,816.12"}]
[]
[null,"One less month",{"$nulls":5},{"v":1980,"d":"$1,980.00"},{"$nulls":4},{"v":26955.923287671234,"d":"$26,955.92"},{"$nulls":4},{"v":80515.92328767123,"d":"$80,515.92"},{"$nulls":4},{"v":52545.923287671234,"d":"$52,545.92"},{"$nulls":4},{"v":0.5611106412749354,"d":"56.11%"},{"$nulls":4},{"v":1.6833319238248061,"d":"168.33%"},{"$nulls":4},{"v":0.18299073474470734,"d":"18.30%"},{"$nulls":4},{"v":29484.076712328766,"d":"$29,484.08"}]
[]
[]
[null,"© 2015 Calvert Home Mortgage Investment Corporation. All rights reserved."]

{"sheet":"Data sheet","index":4,"n_rows":35,"n_cols":6,"rows_kept":35,"hidden":true,"merged":[[17,1,17,8],[27,1,27,8]],"flags":["formulas_cached_only"]}
[]
[null,"PROPERTY TYPE",null,null,"UNIT TYPE"]
[null,"Bungalow",null,null,"1 Bedroom"]
[null,"Two-story",null,null,"2 Bedroom"]
[null,"3-Level Split",null,null,"3 Bedroom"]
[null,"4-Level Split",null,null,"4 Bedroom"]
[null,"Apartment Condo"]
[null,"Apartment Building"]
[null,"Acerage"]
[null,"Farm"]
[null,"Serviced Land"]
[null,"Raw Land"]
[null,"Commercial Condo"]
[null,"Commercial Building"]
[null,"Warehouse"]
[]
[null,"Profit Focused"]
[null,"Total Cost Bar Chart"]
[]
[null,"Purchase",null,null,{"v":2220,"d":"2,220.00"},{"v":0.02609717868338558,"d":"2.61%"}]
[null,"Operating",null,null,{"v":2600,"d":"2,600.00"},{"v":0.030564263322884012,"d":"3.06%"}]
[null,"Financing",null,null,{"v":30886.666666666668,"d":"30,886.67"},{"v":0.3630877742946708,"d":"36.31%"}]
[null,"Selling",null,null,{"v":19360,"d":"19,360.00"},{"v":0.2275862068965517,"d":"22.76%"}]
[null,"Renovations",null,null,{"v":30000,"d":"30,000.00"},{"v":0.3526645768025078,"d":"35.27%"}]
[null,"Total",null,null,{"v":85066.66666666667,"d":"85,066.67"},{"v":1,"d":"100.00%"}]
[]
[null,"Sales Price"]
[null,"Total Cost Bar Chart"]
[]
[null,"Purchase",null,null,{"v":2220,"d":"2,220.00"},{"v":0.026010574038249957,"d":"2.60%"}]
[null,"Operating",null,null,{"v":2475,"d":"2,475.00"},{"v":0.0289982751102111,"d":"2.90%"}]
[null,"Financing",null,null,{"v":31294.904109589042,"d":"31,294.90"},{"v":0.36666595511819755,"d":"36.67%"}]
[null,"Selling",null,null,{"v":19360,"d":"19,360.00"},{"v":0.22683095197320682,"d":"22.68%"}]
[null,"Renovations",null,null,{"v":30000,"d":"30,000.00"},{"v":0.35149424376013455,"d":"35.15%"}]
[null,"Total",null,null,{"v":85349.90410958904,"d":"85,349.90"},{"v":1,"d":"100.00%"}]