Copy of JV Deal Spreadsheet (Make A Copy)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
COMMUNITY RESTORATION GROUP JOINT VENTURE FLIP DEAL ESTIMATE SHEETStephen McKee(951) 777-9966
3
3585 Main St #208, Riverside, CA, 92501Todd Bayer(951) 790-0197
4
communityrestorationgroup@gmail.comwww.communityrestorationgroup.comwww.iereic.org
5
6
Fill out this section by reading all the questions to the left and answering them in the same format to the right. All calculations will happen automatically.
7
Buyer And Seller QuestionsAnswer All Questions AccuratelyFlip: Seller Offer
8
Your Info>>>>> Offer to Seller <<<<<$150,000.00
9
Your First NameJohn
Net Cash to Seller After Escrow Costs
$41,483.50
10
Your Last NameSmith
11
Your Phone Number555-555-5555Flip: Hard/Private Money
12
Your Email Addressjohn@aol.comAfter Repair Value$240,000.00
13
Your Preferred Mailing Address123 Main St, Riverside, CA 92501Resale Escrow Cost$3,683.00
14
Name or Entity for JV ContractsAwesome, LLCResale Transaction Coordination Fee$400.00
15
Home Inspection Fee$400.00
16
Property CharacteristicsResale Agent Commission (5.5%)$13,200.00
17
What is the subject property's complete address?2424 Rehab St, Riverside, CA 92507Rehab Contingency Fund$3,000.00
18
What type of property is the subject property?SFR or PUD or Condo or Townhome or MFHRehab Cost$30,000.00
19
What is the total square footage of the subject property?1060Purchase Transaction Coordination Fee$600.00
20
What is the subject property's lot size?5663Purchase Escrow + Broker Fees$3,090.00
21
How many bedrooms does the subject property have?3Offer Price (Reduced if asking price lower)$150,000.00
22
How many bathrooms does the subject property have?2Max Offer Price$150,000.00
23
What year was the subject property built?1989Total Loan Amount$188,540.00
24
How many stories is the subject property?1Interest Expense$11,622.33
25
How many garage stalls does the subject property have?2Points to Lender$0.00
26
Does the subjet property have a view?Yes or NoFees to Lender/Broker$0.00
27
Does the subjet property have a pool?Yes or NoHOA Fees$450.00
28
Utility Costs$1,000.00
29
Valuation and BalancesAdditional Up Front Expense Place Holder
30
What is the asking price for the subject property?$160,000.00Adittional At Closing Expense Place Holder
31
What is the Fully Rehabbed Value of the subject property?$240,000.00Supplemental Tax Bill$38.37
32
What is the cost of repairs to bring the property to a rentable "livable" condition?$15,000.00
Profit After Holding & Other Costs 25K Minimum
$25,516.30
33
What is the cost of repairs to bring the property to Fully Rehabbed "turnkey" condition?$30,000.00All in cost$185,540.00
34
How many days will it take to rehab and resell the subject property?150Cash on Cash return13.75%
35
What is the combined balance of all the current mortgages?$105,000.00
36
Are their any other liens or delinquent taxes that need to be paid off upon the sale of this property?
Yes or NoFlip: Hard Money Holding Cost
37
If yes, what is the total combined balance of these liens?$900.001st Loan Amount$156,000.00
38
Rate15.00%
39
Ongoing CostsPoints0.00%
40
Does the subject property have an HOA?Yes or NoLender/Broker Fees$0.00
41
If yes, what is the monthly HOA Fee?$90.002nd Loan Amount$32,540.00
42
What is the current assessed value of the subject property?$132,068.00Rate15.00%
43
What is the tax rate of the subject property?0.01069871Points0.00%
44
What are the total annual special assessments for the subject property?$703.64Lender/Broker Fees$0.00
45
What is the estimated closing date of this transaction?3/15/2017Total Loan Amount$188,540.00
46
Effective Rate15.00%
47
OccupantAnnual Interest Cost$28,281.00
48
What is the market rent for the subject property?$1,500.00Effective Points0.00%
49
Who currently occupies the subject property?Owner or Tenant or VacantTotal Points$0.00
50
If rented, what is the current monthly rent? $0.00Total Fees$0.00
51
If rented, what is the ending date of the current lease?00/00/0000
52
Joint Venture Split (Net)
53
Rental EstimateCapital From Partner Bringing Deal$0.00
54
Annual Gross Rent$18,000.00Capital From Partner Bringing Experience$0.00
55
Annual Management Cost (10% Gross Rent)$1,800.00Capital From Outside Lenders$188,540.00
56
Annual Vacancy (10% Gross Rent)$1,800.00Profit from Deal$25,516.30
57
Annual Maintenance (10% Gross Rent)$1,800.002% Internal Management fee$3,710.80
58
Annual Rent and Insurance (5% Gross Rent)$900.00Net Profit After All Costs$21,805.50
59
Capitalization rate at all in cost6.21%Profit to Partner Bringing Deal$10,902.75
60
Profit to Partner Bringing Expertise$10,902.75
61
Wholesale Fee Instead of Partnership
$4,800.00
62
Link to Photos
63
64
65
MLS Comp numbers or link
66
67
68
Comments
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1