Accelerator/MIT 3.0: 2.4 Practicing With the Deal Analyzer

MIT 3.0
2.4 Practicing With the Deal Analyzer
Cheat Sheet

Deal Analyzer

1. Versions: Throughout the program, you’ll see different versions of the deal analyzer, and that’s okay. We’re constantly leveling up!

2. All have the same premise: With all deal analyzers, they’re structured to show cash flow, value add opportunity, cash on cash return. You can also use it to compare comps.

3. Iteration: For a more simpler version of the deal analyzer, click here.

4. How to use it: Make a copy of the sheet and save it in the Google folder:
   • Go to file, make a copy, and save. 
   • Locate “Property Description” on the upper left hand side of the spreadsheet.  
   • Rename the spreadsheet using the street address of the property you’re analyzing and include the start date.
   • Locate the tab at the bottom left hand corner and rename the spreadsheet to match.
   • Only make edits to the cells colored in blue text. Do not edit any numbers in white.

5. Cells, Columns, and Rows:

i. Scenarios

In regards to debt service, there are two scenarios: A and B listed on the spreadsheet.

1. Scenario A could be based on the asking price of the seller. 
2. Scenario B could be based on the price of what you’d like to offer or any other variation or scenario you’d like to entertain.
   • Or Scenario A and Scenario B could be used for multiple scenarios:
     1. Scenario A = Seller financing and Scenario B = No seller financing
     2. Scenario A = Business credit and Scenario B = No Business credit
     3. Scenario A = Private money and Scenario B = No Private Money

ii. Monthly Operating Income:

1. Number of units
2. Average monthly rent per unit:
   • Take the total rental income and divide it by the number of units.
3. Enter the Percentage (%) Vacancy and Credit Losses:
   • Enter 3% or 5%
4. Enter the Other Monthly Income:
   • Laundry
   • Parking
   • Vending
5. The net operating income will automatically total the cell.

iii. Monthly Operating Expenses:

1. Property Management Fees:
   • Take a percentage (8%) and multiply it by the gross monthly operating income. 
2. Repairs and Maintenance:
   • Take 10% and multiply it by the gross monthly operating income.
3. Real Estate Taxes:
   • The listing may have a yearly amount, but use a monthly amount when analyzing a deal by dividing the yearly amount by 12.
4. Rental Property Insurance:
   • Take the amount per unit and multiply it by the number of units.
5. Homeowners/ Property Association Fees:
   • Leave blank if none is reported.
6. Replacement Reserve:
   • Leave blank if none is reported.
7. Utilities:
   • Enter the monthly amount the owner is responsible for.
8. Pest Control:
   • Enter the monthly amount if any.
9. Accounting and Legal:
   • This information will not be included in the listing.
   • Enter any relevant amount regarding evictions or accounting you are responsible for.

iv. Net Operating Income (NOI):

1. The figures in this section are automatically calculated in annual totals and not in monthly amounts.
2. Calculation: NOI = Gross Operating Income (GOI) – Operating Expenses (OE).

v. Enter the capitalization rate and valuation:

1. Ask your agent for the capitalization rate percentage:
   • Enter this percentage into the Desired Capitalization Rate field.
   • What the property should be worth will automatically populate.

vi. Enter the Actual Purchase Price

vii. The Actual Capitalization Rate is automatically calculated

viii. Loan Information:

1. The down payment is the purchase price multiplied by the percentage determined by the lender. 
2. The loan amount is the purchase price minus the down payment.
3. Acquisition Costs:
   • These are the soft costs, closing costs, and loan fees; they are 5% of the asking price.
   • This is only an estimate but keep in mind that these estimates may be different in your market but you can get more accurate estimates via a closing attorney or through your Loan Officer.
4. Enter the length of the mortgage in years of how long the mortgage is amortized. 
5. Enter the annual interest rate set by the lender.
6. The form will automatically calculate:
   • The potential cash you’ll need at closing
   • The monthly mortgage payment 
   • Annual interest rate 
   • Annual principal 
   • The sum total of the annual debt service

ix. Cash flow and ROI:

The total monthly cash flow before taxes, total annual cash flow before taxes, and the cash on cash return (ROI) are all automatically calculated for you on the Deal Analyzer.

6. Locate deals in the MLS:
   • Search for active properties.
   • Select the type of properties you’re interested in.
   • Search for a specific price range.
   • Submit your criteria and potential deals will populate.
   • Take the general information from the listing and enter it into the Deal Analyzer for practice purposes. 
   • Use estimates:
     1. For property insurance, use $60 per unit
     2. For vacancy reserves, use 5%
     3. For maintenance, use 10%
     4. For property management, use 8%
     5. For taxes, find the dollar amount on the listing or look it up on the county website where the property is located.
     6. For any homeowner’s association fees ask the listing agent for the dollar amount, otherwise leave this blank on the Deal Analyzer.
     7. Utilities vary by property, so there’s no estimate to add to the Deal Analyzer.
     8. Ask the real estate agent for a better estimate for the cap rate for a property in a particular area.
     9. With all estimates, obtain a better figure in your market by consulting with local real estate professionals.
7. Shoot first, ask questions later:
   • If you analyze a deal and it looks good, but you are missing data, still submit an offer on the property with a Letter of Intent (LOI) to get the property under contract. 
     1. Make a copy of our LOI and use.
     2. Once the property is under contract, ask the agent any questions that will help complete the deal analysis.
8. Practice:
   • You can also locate deals to practice on under MIT 3.0 Resources and Tools and select Deal Presentations.
   • You can ask agents to send you deals if you have the capital to move forward with a deal.
9. Continue to use your Operational Plan (OP)/calendar.

Words of advice

• In regards to the spreadsheet, if you have multiple deals to analyze, you can click on the same tab and select “Duplicate” for however many deals you are analyzing.
• Do not edit any numbers on the spreadsheet where the cells are white in color for it will offset the entire spreadsheet.
• All calculations for the acquisition costs are estimates. The Deal Analyzer is great to use on listings, but when you get a real deal under contract, then you’ll have real concrete numbers that will give you a better idea of what the cash flow will be:
  • Reach out to the closing attorney for closing costs. 
  • Reach out to the mortgage broker for the amount per point being charged. A point is 1% of the amount being borrowed. 
• When calculating the valuation, it’s possible that the seller’s asking price may be less than what the property is worth. The overage amount is built in equity.
• The down payment amount is typically 20% of the purchase price.
• The loan amount is the mortgage amount.
• The annual interest is tax deductible, but not the annual principle since it’s a loan.
• If you decide to finance the initial investment, then your total annual debt service will be higher than what’s calculated on the Deal Analyzer.

 “If you’d like to learn more, click here”

Copyright @ 2021 by 100percentfinanced.com
All rights reserved. No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher.