Property Analysis H1-2020
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTU
1
Yearly rate of return
32.5%
Portfolio value (equity + refi cash)
$160,639
2
Portfolio earnings (NPV)
$157,659
3
4
Cash Flow
5
Equity Value
H2 2019H1 2019H2 2018H1 2018H2 2017H1 2017
H2 2016
H1 2016
H2 2015
H1 2015
H2 2014
H1 2014
H2 2013
H1 2013
H2 2012
H1 2012
H2 2011
6
Property 1$61,984$1,508$1,508$1,228$1,228$632$632$2,416$2,416$669$669$596$596$1,410$1,410$1,677$1,677-$21,013
7
Property 2$56,336$1,816$1,816$2,531$2,531$2,063$2,063-$285-$285$1,747$1,747-$23,462
8
Property 3$32,091$2,766$2,766$2,550$2,550-$24,578
9
Cash from refi$35,987
10
Total+equity →$156,500$6,090$6,309$6,309-$21,883$38,682$2,131$2,131$2,417$2,417-$22,866$596$1,410$1,410$1,677$1,677-$21,013
11
12
Discount Rate Per Half
2.00%
13
14
Discounted Cash Flow
15
Half years ago
012345678910111213141516
16
Present Value
$156,500$6,212$6,564$6,695-$23,687$42,708$2,399$2,447$2,832$2,888-$27,874$741$1,789$1,824$2,212$2,257-$28,846
17
18
Cash remaining from refi
$10,229
19
20
21
22
23
24
Loading...