"Flip Analysis
Target Purchase Price (to buy) Purchase Loan Amount
Down Payment
Monthly Payment P&I                            $0.00
Holding Period (months)                   4
Closing Costs In
Appraisal"
   "Points                            1%  $ -
Junk Fees Title Survey
Insurance Premiums (Builder's Risk)           $       -"    
"Total Closing Costs In (incl. DP)               $       -
Carrying Costs
Mortgage Payments P&I months           4  $      - Property Taxes (for hold period)
Utilities Other
Total Carrying Costs                       $       -
Fix-up Cost (Itemize Separately)
Total Needed                           $       -
Target Resale Price Sales Costs
Commission (%)                     6%  $       -
Seller Concessions/Points
Recording Fees/Tax Stamps Other
Total Sales Costs                         $       -
Net Sale Proceeds:                       $       -
Less Total Costs:                         $       -
Less Mortgage Payoff:                     $       -
NET PROFIT                           $       -"
"RATE OF RETURN                         #DIV/0!
ANNUALIZED RATE OF RETURN               #DIV/0!
Net profit divided by investment = ROI"



































"**ALL NUMBERS ARE ONLY ENTERED ON THIS TAB ONLY. Changing num
**While viewing the ""3Tier(printout)"" tab, Print-To PDF including only Page 1
**Any questions related to this Spreadsheet, please email us at trainer@pipspath.com"
                       
   "The orange cells indicate numbers and info required for formulas, and can be adjusted
The green cells indicate purely info cells about the property and are not required for formul"
   
"PROPERTY DETAILS
Lead From"                    
   ":
:
:
:
:
:
:
:
:"        
           "-------"        
               
           "-------"    
           
       ":
:"        
                       
               
                       
           0            
                       
           "1
$0
$0
$0
$0"            
                       
           "$0
$0
$0
$0 5%
5%"            
                       
           "CASH OFFER (Financed)"        
           "Amount Financed ="    0.800000        
           "Amortized(Yrs) ="    30        
           "Term/Balloon(Yrs) ="    30        
           "Interest ="    0.080000        
           "Purchase Price"    "Discount"        
           0    0.200000        
           "Result"    "Indicator"        
           "Infinite"    "GOOD"        


"30% Minimum"        
"Avg Profit per Unit / Month  :"    0    "BAD"
"$100 per Unit/ Month
GRM  :"    "#DIV/0!"    "#DIV/0!"
"Less than 6.0
Current CapRate  :"    "#DIV/0!"    "#DIV/0!"
"Greater than 10"        
"Cost per Unit  :"    0    "GOOD"
"$45,000 and less
Coverage Ratio  :"    "#DIV/0!"    "#DIV/0!"
"Greater than 1.20"        
   "#1-Seller Gets = $0
More than Asking = $0"    
"ing numbers on any of the other tabs will likely break the formulas** ly Page 1 & Page 2.**
for formulas"
                   "(off-marketing lead? Posc"
       
               
               
               
                           
       "Phone # : Mailing Adress :"        
                           
       "Phone # :"        
           
                           
   "OtherFin - 65% of Purchase Price"                    
   "Amount Financed ="    0.650000                    
   "Amortized(Yrs) ="    30                    
   "Term/Balloon(Yrs) ="    30                    
   "Interest ="    0.080000                    
   "SellerFin - 35% of Purchase Price"        "SellerFin - 100% of Purchase Price"        
               "Amount Financed ="    1.000000        
   "Amount Financed ="    0.350000                    
   "Amortized(Yrs) ="    30        "Amortized(Yrs) ="    30        
   "Term/Balloon(Yrs) ="    5        "Term/Balloon(Yrs) ="    5        
   "Interest ="    0.030000        "Interest ="    0.040000        
   "Purchase Price"    "Discount"        "Purchase Price"    "Discount"        
   0    0.075000        0    0.000000        
   "Result"    "Indicator"        "Result"    "Indicator"        
   "Infinite"    "GOOD"        "Infinite"    "GOOD"        


           
0    "BAD"        "BAD"    
"#DIV/0!          #DIV/0!
#DIV/0!          #DIV/0!"            
0    "GOOD"        "GOOD"    
"#DIV/0!          #DIV/0!"            
"#2-Seller Gets = #VALUE!              #3-Seller Gets = #VALUE!
#VALUE! #VALUE!                #VALUE! #VALUE!"
"lead? Poscards/cold-calling ect. Or for MLS listing website link)"
"LETTER OF INTENT TO PURCHASE"
"Date : June 5, 2024"
"Property Address : 0
OFFER #1 :
Cash offer if the Seller wants to sell and walk away
Total Offer Amount :  $ -
(We will pay all closing costs, excluding realtor fees)
OFFER #2 :
Seller Financing of 35% of purchase price. Amortized over 30 years—5 year Balloon"
"Total Offer Amount :  $      -
Amount from Buyer :  $      -
Amount Financed by Seller :  $      -"
       "Term :        5 years
Interest Rate :      3.0%
Amortization :       30 years"
"Monthly Payments :  $     -
Total Payments :  $      -
Balloon Payment :"
" Total Payout : #VALUE! "
"Total Amount to Seller :  $      - +  #VALUE!  =  #VALUE! "
"OFFER #3 :
Seller financing 100% of purchase price. Amortized over 30 years—5 year Balloon"
"Total Offer Amount :  $      -
Amount Financed by Seller :  $      -"
       "Term :        5 years
Interest Rate :      4.0%
Amortization :       30 years"
"Monthly Payments :  $     -
Total Payments :  $      -"
" Balloon Payment : "
"Total Amount to Seller :  $      - +        =  #VALUE! "
   "This offer pays  #VALUE!  over asking price with tax benefits, control of the property and no maintenance or management issues."
"Please note that this is an estimate. Final numbers will depend on accurate repair costs, additional financing info and inspection.
Upon Acceptance, both parties agree to move forward with a standard purchase and sales agreement generally accepted by the Board of Realtors in    -------"
"7 of 2"
"LETTER OF INTENT TO PURCHASE
Seller(s) Preferred Offer :  
Seller(s) Acceptance :   Date:  "
   "Details regarding Letter of Intent to Purchase offers:"
"We are making 3 offers for the Seller to choose from. If one is close but not quite there, please let us know and we’ll see if we can adjust some numbers to make it a Win/Win for all of us. These offers are contingent on full inspections and our approval of the results of the inspections, including our Financing partner. We will inspect within 45 days and close within 60 days.
Anyone of these offers is to purchase the property AS-IS. The Seller does not have to put any money into the property to get it ready for sale. Title must be clear of liens and encumbrances. Taxes and Utilities must be current. Normal costs are paid by Buyer, EXCEPT for Agent fees. The Seller’s Agent will be compensated by the Seller.
We are not accountants or lawyers so please have the Seller check with theirs before making a decision, as to what offer works best for them. The IRS also allows the Seller to pay Capital Gains on a monthly basis instead of a lump sum at closing if sold on terms, which allows the Seller to keep that money in the property and make interest on it."
"The Seller will also have control of the property with any financing provided, so if we would default the Seller can foreclose on the property and take it back, while keeping any payments and updates we have made.
The Seller will not have any maintenance or management responsibilities with the property just a monthly payment."
"The Seller will also receive monthly cash flow from their seller financing position."
"8 of 2"
"LETTER OF INTENT TO PURCHASE"
"9 of 2"

"LETTER OF INTENT TO PURCHASE"
"10 of 2"

"3CAE0CE6CCA814A6B7C97DF3E697B4AE"
"CASH FLOW STATEMENT REPORT
INCOME and EXPENSE STATEMENT"
                       
"Gross Income:"    "Rent:"            "$"    "-"    
   "Other:"            "$"    "-"    
   "Other:"            "$"    "-"    
   "Other:"            "$"    "-"    
                       
" Sub-Total Gross Income: $ - "
"Less : Vacancy / Bad Debt               5.00%       $     -"
" EFFECTIVE GROSS INCOME $ - 100.0% "
   "Operating Expenses:"            
       "% of Revenue"            "Per Unit/Month"                
   "Taxes"    "#DIV/0!"    "$"    "- $     -  (Est)"            
   "Insurance"    "#DIV/0!"    "$"    "- $     -"            
   "HOA"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Gas"    "#DIV/0!"    "$"    "- $     -"            
   "Lawn/Snow"    "#DIV/0!"    "$"    "- $     -"            
   "Water / Sewer"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Other"    "#DIV/0!"    "$"    "- $     -"            
   "Sub-Total"    "#DIV/0!"    "$"    "- $     -"            
   "Maintenance"    0.050000    "$"    "- $     -"            
   "Management"    0.050000    "$"    "- $     -"            
   "Sub-Total"    "#DIV/0!"    "$"    "- $     -"            
                           
   "Total Operating Expenses"            "$"    "-  #DIV/0!"        
" NET OPERATING INCOME $ - #DIV/0! "
"3CAE0CE6CCA814A6B7C97DF3E697B4AE"
"CASH FLOW STATEMENT REPORT
FINANCING OVERVIEW"
           0.200000    0.150000    0.100000    0.075000    0.050000        
"Asking Price:"    "$     -"    "$"    "- $"    "- $"    "- $"    "- $"    "-"        
   0.200000                                
"Gross - Purchase Price: Credit:
Purchase Price:"    "$
$
$"    "-
-
-       Price per unit:  $      -       Number Unit:    1"    
"Estimated Property Value:
[Based on a CapRate of 10%]"    "$"    "-"    
"Debt Service     %   Mortgage Amount"                "Term  Amortization Period
(Month)     (Year)"        "Interest
Rate"                "Monthly
Payment"                        
                                                   "TOTAL     %"
                                                               
                                                                           
"First Mortgage"    0.800000    "$"    -360    30    0.080000    "$     -  $     -"        
"Second Mortgage"    0.000000    "$"    "-"    25    7.00    "$     - $"    "-"        
"TOTAL"    0.800000    "$"    "-"            "$     - $"    "-  #DIV/0!"        
                                   
"PROMISSORY NOTE"        "$"    "-"        0.00    "$     - $"    "-  #DIV/0!"        
                                   
"CMHC"    0.000000    "$"    "-"    30    0.08    "$     - $"    "-  #DIV/0!"        
"Coverage Ratio"                                                                        
" Net Operating Income  ="    " $ - "    "=      #DIV/0!"
       "DebtService             $ -"                                    
"PROFIT / (LOSS)
EBITDA - Earning Before Interest Tax Depreciation and Amortization"    "$     -  #DIV/0!"
"3CAE0CE6CCA814A6B7C97DF3E697B4AE"
"CASH FLOW STATEMENT REPORT
CASH REQUIREMENTS"
"Total Downpayment:  $     - Closing / Acquisition Costs - Details"
"1st Deposit:  $     -
2nd Deposit: $     -"    "Lender's Fee (1st)"    "$     -  #DIV/0!
$     -  #DIV/0!"
"Credit: $     -"    "Lender's Fee (2nd)"    "$     -  #DIV/0!"
"Discount on Closing:"    "$     -"    "Legal Fee Lender (2nd)"    "$     -"    "#DIV/0!"
"Cash Back:"    "$     -"    "Mortgage Broker Application"    "$     -"    "#DIV/0!"
"Promissory Note:"    "$     -"    "Mortgage Broker's Fee"    "$     -"    "#DIV/0!"
"Balance on Closing:"    "$     -"    "Appraisal"    75    "#DIV/0!"
"Cash Down Required: Closing / Acquisition Costs:"    "$     -
$   3,150"    "Building Inspection Environmental Phase 1
Environmental Phase 2
Land Transfer Tax"    "$    75
$     -"    "#DIV/0! #DIV/0! #DIV/0!
#DIV/0!"
"Rents Pro-Rating:"    "$     -"    "Title Insurance"    500    "#DIV/0!"
"Deposit Last Month Rent:"    "$     -"    "Legal"    1200    "#DIV/0!"
   "$     -
$     -
$     -"    "Corporation
Repairs"    "$   1,200
$     -
$    100"    "#DIV/0!
#DIV/0! #DIV/0!"
   "$     -
$     -"    "Assignment Fee"    "$     -"    "#DIV/0! #DIV/0!"
"Others:"    "$     -"    "Others"    "$     -"    "#DIV/0!"
" TOTAL CASH INVESTED: $   3,150      TOT AL CLOSING / ACQUISITION COSTS $   3,150 #DIV/0! "
"Grand total  $   3,150 "
"KEY SUCCESS INDICATORS"
"Result  Indicator  Objective"
"GOOD"
"Cash-on-Cash Return:   Infinite
Avg Profit per Unit / Month:   $0"    "Goal = 30% Minimum       This is the same as Return on Investment. The money you put into a deal. You take your total yearly cash flow and divide it by the amount of your investment.
Goal = $75 per Unit/ Month     This is the profit per unit per month and in my opinion the most important as it is the money you have in your pocket each month."    
"BAD"
"GRM:   #DIV/0!    #DIV/0!  Goal = Less than 6.0       Gross rent multiplier. It is used to determine how hard your rent is working as it relates to the property investment."
"Current CapRate:   #DIV/0!    #DIV/0!  Goal = Greater than 10      Capitalization rate. This is the return you have before any debt service. It is the amount your money would make if the investment was a cash purchase."
"GOOD"
"Cost per Unit:   $0         Goal = $45,000 and less      This is the amount you pay per unit on the investment. This is the least important indicator."
"Coverage Ratio:   #DIV/0!    #DIV/0!  Goal = Greater than 1.20      This is what the bank looks at. They want the cash flow to be at least 20% more than the debt service on the property."
"CASH FLOW STATEMENT REPO
INCOME and EXPENSE STATEMENT"
                   "Number of Unit"    
                   1    
"Gross Income:                            Rent:
Other: Other: Other:"            
               
" Sub-Total Gross Income:"
"Less :
EFFECTIVE GROSS INCOME"    "Vacancy / Bad Debt"            0.050000    
"Operating Expenses:"                    
                   
"Taxes"        "#DIV/0!"    "$"    "-"    
"Insurance"        "#DIV/0!"    "$"    "-"    
"HOA"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Gas"        "#DIV/0!"    "$"    "-"    
"Lawn/Snow"        "#DIV/0!"    "$"    "-"    
"Water / Sewer"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Sub-Total"        "#DIV/0!"    "$"    "-"    
"Maintenance"        0.050000    "$"    "-"    
"Management"        0.050000    "$"    "-"    
"Sub-Total"        "#DIV/0!"    "$"    "-"    
"Total Operating Expenses"                    
"NET OPERATING INCOME"                    
"FINANCING OVERVIEW"
"Asking Price:"    "$       -
7.5%"                    
           "20.0%          15.0%
$       -  $         -"    
                       
"Gross - Purchase Price: Credit:
Purchase Price:"    "$
$
$"    "-
-
-           Price per unit:   $          -"    
"Estimated Property Value:
[Based on a CapRate of 10%]"    "$"    "-"    
   "Debt Service"    "%"    "Mortgage
Amount"    "Term"    "Amortization
Period"    "Interest
Rate"    
               "(Month)"    "(Year)"        
   "First Mortgage"    0.650000    "$"    -360    30    0.080000    
   "Second Mortgage"    0.350000    "$"    -60    30    0.030000    
   "TOTAL"    1.000000    "$"    "-"            
                           
   "PROMISSORY NOTE"        "$"    "-"        0.00    
                           
   "CMHC"    0.000000    "$"    "-"    30    0.08    
"Coverage Ratio"
" Net Operating Income  =  $ - "
               "DebtService                      $         -"
"PROFIT / (LOSS)
EBITDA - Earning Before Interest Tax Depreciation and Amortization"
"CASH REQUIREMENTS"
"Total Downpayment:  $       - Closing / Acquisitio"
"1st Deposit:  $
2nd Deposit:  $
Credit: $
Discount on Closing:  $
Cash Back: $ Promissory Note:  $ Balance on Closing: $
Cash Down Required:  $
Closing / Acquisition Costs:  $
Rents Pro-Rating:  $
Deposit Last Month Rent:  $"    "-
-
-
-
-
-
-
- 3,150
-
-"    "Lender's Fee (1st)
Lender's Fee (2nd) Legal Fee Lender (2 Mortgage Broker A Mortgage Broker's Appraisal
Building Inspection Environmental Pha Environmental Pha Land Transfer Tax Title Insurance
Legal"
"$       -
$       -
$       -
$       -
$       -
Others:  $       -"    "Corporation Repairs
Assignment Fee Others"
" TOTAL CASH INVESTED: $ 3,150        TOT AL CLOSING / ACQUISITION COST"
"KEY SUCCESS INDICATORS"
   "Result"    "Indicator"    "Objective"    
"Cash-on-Cash Return:"    "Infinite"    "GOOD"    "Goal = 30% Minimum"    
               
"Avg Profit per Unit / Month:"    0    "BAD"    "Goal = $75 per Unit/"    
"GRM:"    "#DIV/0!"    "#DIV/0!"    "Goal = Less than 6.0"    
"Current CapRate:"    "#DIV/0!"    "#DIV/0!"    "Goal = Greater than"    
"Cost per Unit:"    0    "GOOD"    "Goal = $45,000 and"    
"Coverage Ratio:"    "#DIV/0!"    "#DIV/0!"    "Goal = Greater than"    
"RT"
       "$       -
$       -
$       -
$       -"
"Avg per Unit"        
0        
"#DIV/0!"        
"#DIV/0!"        
"#DIV/0!"        
"tal Gross Income: $ - "
"$       -"
-1.000000
"Per Unit/Month"            
"$       -   (Est)
$       -
$       -
$       -
$       -
$       -
$       -
$       -
$       -
$       -
$       -
$       -
$       -
$       -
$       -"
"$       -
$       -
$       -"
"$       -    #DIV/0!"
"$       -    #DIV/0!"
"10.0%        7.5%        5.0%
$         -  $       -  $       -"    
"Number Unit:       1"
   "Monthly"    "TOTAL %"        
" Payment "
"$       -   $       -
$       -   $       -"
"$         -  $       -    #DIV/0!"
"$         -  $       -    #DIV/0!"
"$       -   $       -    #DIV/0!"
"=          #DIV/0!"
"$       -    #DIV/0!"
"/ Acquisition Costs - Details"        
   "$       -"    "#DIV/0!"    
   "$       -"    "#DIV/0!"    
   "$       -"    "#DIV/0!"    
"e Lender (2nd)"    "$       -"    "#DIV/0!"    
"e Broker Application"    "$       -"    "#DIV/0!"    
"e Broker's Fee"    "$       -"    "#DIV/0!"    
   75    "#DIV/0!"    
"Inspection"    75    "#DIV/0!"    
"mental Phase 1"    "$       -"    "#DIV/0!"    
"mental Phase 2"        "#DIV/0!"    
       "#DIV/0!"    
   500    "#DIV/0!"    
   1200    "#DIV/0!"    
"$     1,200
$       -
$      100
$       -
$       -"    "#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!"
"UISITION COSTS $ 3,150 #DIV/0! "
"Grand total  $ 3,150 "
"0% Minimum          This is the same as Return on Investment. The money you put into a deal. You 75 per Unit/ Month       This is the profit per unit per month and in my opinion the most important as it is t ess than 6.0          Gross rent multiplier. It is used to determine how hard your rent is working as it r reater than 10         Capitalization rate. This is the return you have before any debt service. It is the 45,000 and less        This is the amount you pay per unit on the investment. This is the least importan reater than 1.20        This is what the bank looks at. They want the cash flow to be at least 20% more"
"deal. You take your total yearly cash flow and divide it by the amount of your investment. ant as it is the money you have in your pocket each month.
rking as it relates to the property investment.
e. It is the amount your money would make if the investment was a cash purchase. ast important indicator.
20% more than the debt service on the property."

"CASH FLOW STATEMENT REPO
INCOME and EXPENSE STATEMENT"
"Gross Income: Rent:
Other: Other: Other:"    " Number of Unit
1 "
" Sub-Total Gross Income:"
"Less :
EFFECTIVE GROSS INCOME"    "Vacancy / Bad Debt"            0.050000    
"Operating Expenses:"                    
                   
"Taxes"        "#DIV/0!"    "$"    "-"    
"Insurance"        "#DIV/0!"    "$"    "-"    
"HOA"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Gas"        "#DIV/0!"    "$"    "-"    
"Lawn/Snow"        "#DIV/0!"    "$"    "-"    
"Water / Sewer"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Other"        "#DIV/0!"    "$"    "-"    
"Sub-Total"        "#DIV/0!"    "$"    "-"    
"Maintenance"        0.050000    "$"    "-"    
"Management"        0.050000    "$"    "-"    
"Sub-Total"        "#DIV/0!"    "$"    "-"    
"Total Operating Expenses
NET OPERATING INCOME"                    
"FINANCING OVERVIEW"
"Asking Price:"    "$       -
0.0%"                    
           "20.0%          15.0%
$       -  $         -"