JV Gain Calculator.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
The Purchase
3
4
Purchase Price$700,000.00
Average % gain per year
6
5
6
Down Payment %20Innitial$700,000.00
7
After Year 1$742,000.00
8
Down Payment$140,000.00After Year 2$786,520.00
9
After Year 3$833,711.20
10
Closing costs$10,000.00After Year 4$883,733.87
11
After Year 5$936,757.90
12
Total Initial $$150,000.00After Year 6$992,963.38
13
After Year 7$1,052,541.18
14
After Year 8$1,115,693.65
15
After Year 9$1,182,635.27
16
Estimated mortgage paydown$60,000.00After Year 10$1,253,593.39
17
18
19
20
21
The numbers
22
23
Years of ownership (5-10)10.00
24
Sell Value$1,253,593.39
25
Selling Costs$25,000.00
26
Net Sale$1,228,593.39
27
28
29
Cost$700,000.00
30
Minus Down Payment$140,000.00Money Partner$439,296.69
31
Minus Mortgage Paydown$60,000.00
Real Estate Investor
$289,296.69
32
Net Owing$500,000.00
33
34
35
Proceeds after sale$728,593.39
36
37
Original returned to Money Partner
$150,000.00
38
39
Remainder Split 50/50$578,593.39
40
41
Gain for each$289,296.69
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
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...