ABCDEFGHIJKLMOPQRSTUVWXYZAAABACAD
1
2.88E+04
2
 NoteFlips Modeling Calculator v6.0 Release Date 12-20-22
3
DEAL INPUTS
4
Property InfoCF
5
Property Full Address:
MASTER-MAKE A COPY
TUTORIAL VIDEO: WATCH THIS FIRSTNOTE AMORTIZATION CALCULATORNS
6
Property Picture Link:
Also, see Disclaimer (rows 79-83)
LA
7
Acquisition Inputs Disposition Inputs
Rehab, Repair Inputs
TM
8
Sales Price Make LivableEstActualFix & Flip EstActual
9
Acquisition Price $ 230,000 Sales Price $ 325,000 Total $ - $ - Total $ - $ -
10
 Repairs Needed OFV $ - Min OFV $ 328,571 Clean $ - Clean $ -
11
Total Cost Basis $ 230,000 Wholesale $ 243,750 Paint $ - Paint $ -
12
Management Fee $ 10,000 Flooring $ - $ - Flooring $ -
13
Adjusted Cost Basis for Finance $ 240,000 Other 1 $ - $ - Appliances $ -
14
Comp Analysis
Seller Financing Terms
Other 2 $ - $ - Ext Paint $ -
15
Comp 1-1st Lien Rate10.50%
Repairs Estimate
 $ - $ - Granite $ -
16
Comp 2- 2nd Lien Rate10.50%
(Over)/Under Budget
 $ - Fixtures $ -
17
ZHVI 3rd Lien Rate10.50% Labor $ -
18
ZHVI 12 month +/-
Sales Commission
0.00% Other 1 $ -
19
Rental Value Down Payment $ $ 35,000 Other 2 $ - $ -
20
Appraisal ValueDown Payment %10.77%
8% minimum suggested
Other 3 $ - $ -
21
Other Property Info Needed
(Over)/Under Budget
 $ -
22
FLOOD FACTOR (Cell I77)F&F Sales Terms
Fix & Flip Holding Period
23
Annual Property Taxes ($)
Est F&F ARV Price
 $ 315,250
Days to Close Aquire Flip
 60
24
HOA Fees ($) $ - F&F Cost Basis $ 230,000
Days to Rehab
 60
25
 Total Annual Taxes & Fees $ - Days to Sell 60
26
FINANCING COSTS
Time to Sell/Close Flip
 180
27
Money Rate0.00%
28
Money Points0%
29
Sub 2/Seller Financing10%
30
Self Imposed Point0%
31
Holding Period
TEXAS NOTES
90%
32
Acquisition Date11/1/2022
33
Disposition Date12/31/2022
34
Est Days in Deal 60
35
DEAL MODELING
36
Traditional DispositionsSeller Financing DispositionsLien Summary & Rental Gap
37
WholesaleFix n Flip ARVSub 2/SFNoteFlips ModelNote RatioNote Sale DiscountLiensInitial Lien ValueMonthly Payment10 Year Value
38
coming soon
Also, SEE DISCLAIMER (rows 79-83)
39
Price $ 243,750 $ 315,250 $ 325,000 $ 325,000 1st 72.00%90%1st Lien $ 234,000 $ 2,140 $ 211,676
40
1st Loan $ 210,600 $ 210,600 2nd23.00%2nd Lien $ 39,750 $ 364 $ 36,419
41
3rd5.00%3rd Lien $ 16,250 $ 149 $ 14,888
42
2nd LoanCash Down $ 35,000 $ - $ -
43
 $ - Totals $ 325,000 $ 2,653 $ 262,984
44
TBD $ - $ (1,500) $ (1,500) $ - -1000Rent Gap #VALUE!#VALUE!
45
Buyer Down Payment $ - $ - $ 35,000 $ 35,000 Cost Basis$240,000$246,495
46
Less:Cost to Value73.85%75.84%
47
Acquisition Price $ (230,000) $ (230,000) $ (230,000) $ (230,000)ProgramSeller FinanceRetail
48
TBD $ - $ (500) $ - $ -
49
 TBD $ - $ - $ (24,150) $ -
1st Lien Investor Return:
12.20%
50
Transaction Coordinator $ (1,200) $ (1,200) $ (1,200) $ (6,495)
Judicial Investor Return >11%
51
 TBD $ - $ - $ (3,781) $ -
Non-Judicial Investor Return >10%
52
TBD $ - $ (30) $ -
53
Rehab Costs $ - $ - $ - Cash Now $ (6,620)
minimum $3K
54
Management Fee $ (10,000) $ (10,000) $ (10,000)Cash Flow $ 364
55
Sales Commission $ - $ - $ - $ - Cash Later $ 36,419
56
Appraisal $ - $ (3,000) $ (3,000) $ (850) 2nd Lien Value $ 39,750
minimum $25K
57
Seller Pd Closing Costs (1.5% Estimate)
 $ - $ - $ (4,875)
58
Seller Contribution $ - $ (1,000) $ (1,000) $ -
Net Cash Now ROI Analysis
59
 Net Cash Now $ 12,550 $ 68,050 $ (29,061) $ (6,620)
If NEGATIVE see Optional Exit
If Negative, equals ROI on Net Cash Now
 (18.21)
60
 Wrap Mortage 2nd Lien Total Deal Value Calculation
Personal Investment Yield
-65.91%
61
Net Cash + 2nd Lien Value
$ 10,689 $ 33,130 >25K min
62
Profit Per Day
 $ 178 $ 552
>$350/day
Sub2 ROI Analysis-COMING SOON
63
Sub2 P&I
64
2nd Lien Monthly Cashflow
 $ 364 $ 364 OFV P&I $ 2,653
65
Total 10 Year Projected Payout
Net Monthly Cash
$2,652.74
66
10 Year Net Cash Now
$ (29,061) $ (6,620)
If Negative, equals ROI on Net Cash Now
 (2.50)
67
10 Year Cashflow
 $ 43,633 $ 43,633
If postive, no out of pocket costs
68
10 Year Future Note Value
 $ 36,419 $ 36,419
Optional Exit -Forecast Only
69
10 Year Total Cash Received
 $ 50,991 $ 73,432
IF: Net Cash NEGATIVE then 2nd Lien Value. >3X
-6.00
70
THEN: MAX CASH OUT: 42% of 2nd note Value (<180 mo)
$16,695$10,075
Adjusted Cash Now
71
Option 2-100% CASH OUT 50% 2nd Lien Value:
$19,875
72
Full Cash Payout
$13,255
73
Pictures:YellowRequired
74
75
76
Notes:
77
78
Flood Factor Rating
79
80
EARNINGS DISCLAIMER. The NoteFlips calculator displays a summary of sample results for illustrative purposes only. Substitute your own known and estimated figures in the worksheet. The results are an estimated forecast or model scenario, and are NOT a guarantee concerning the exact amounts for your specific project. Exact amounts can be offered when an approved (underwritten by an RMLO) buyer is found and actual numbers are submitted for review to your NoteFlips Consultant.
81
82
By doing a NoteFlip and/or using this calculator, you acknowledge your understanding that actual earnings differ by property and by project. Tax laws and the real estate and financial markets (home prices, rental rates, interest rates, etc.) are ever changing. You accept the risk of using this information, knowing final decisions are yours alone and should be based on your own due diligence and consultation with your tax/legal advisors.
83
84
FLOS$FLiPS staff nor its affiliates are legal and/or tax professionals and are not offering legal or tax advice. You should check with your own legal and tax professional before implementing any strategies.
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100