Buy land, they aren’t making it anymore
—Mark Twain
$370,000 for 2,600 square feet = $6.2m/acre
$100,000 for 1.15 acres = $87,000/acre
$17,900 for 1.95 acres = $9,200/acre
Why are there tall buildings in Manhattan, NYC, but not Edison, NJ?


University Tower, Durham, NC, © Ildar Sagdejev
Density gradient, Greater Boston, MA (2020 decennial census)
Density gradient, Greater Boston, MA (2020 decennial census)
— George Box
Monthly rent by ZIP code, Manhattan and Jersey City/Hoboken (Data: Zillow)
The present value of money received \(x\) years in the future is
\[\frac{1}{(1 + r)^x}d\]
where \(r\) is is the discount rate and \(d\) is the amount to be received (Miles et al. 2015)
Why is this an exponential and not just a multiplication?
Each year we discount the already discounted values further
PMT function calculates the paymentPPMT and IPMT functions calculate how much of each payment goes to principal and interestPMT function is =PMT(rate, number of periods, present value)=PMT(0.062 / 12, 360, 400000) = $2,450/month=PMT(0.05575 / 12, 360, 400000) * 360 = [824,405]PPMT function will calculate thisPPMT function, the syntax is =PPMT(rate, period, number of periods, present value)=PPMT(0.062 / 12, 1, 360, 400000) = $383IPMT function will calculate thisIPMT function, the syntax is =IPMT(rate, period, number of periods, present value)=IPMT(0.062 / 12, 1, 360, 400000) = \(2,067\)=CUMPRINC(0.062 / 12, 360, 400000, 1, period, 0)70% of Boston leases begin on September 1 © Que165 on Reddit
$ syntax so you can just expand down
This work by Matthew Bhagat-Conway is licensed under a Creative Commons Attribution 4.0 International License.
