Free IRR, commercial mortgage, and debt yield calculators#
The IRR calculator builds the cash flow series instead of asking for one. A generic IRR box takes a list of flows, which means the hard part already happened somewhere else; this one takes the deal, the equity, the year-one NOI and its growth, a flat debt service, the hold, and the net sale proceeds, and constructs the series on screen, so the arithmetic that actually goes wrong is visible. It also does two things most do not: it reports when a series changes direction more than once, because then more than one rate solves it and quoting one as the answer is wrong, and it prints the naive average annual return beside the real figure and labels it as not being an IRR, which on the default deal reads 13.78% against 11.68%. The commercial mortgage calculator answers the question loan sizing does not: what a quoted loan costs and what is still owed when the term ends. It has the field a residential calculator has no room for, the balance at maturity, and it prices an interest-only period in both directions rather than showing only the lighter early payment, so two years of interest only on the default quote reports both the $107,788 of extra interest and the $244,475 of extra balance it leaves behind. The debt yield calculator solves its triangle in any direction and then shows the identity the test is really about: debt yield is the going-in cap rate divided by the loan to value, exactly, computed from both sides independently so a reader watches the two tie. Read backwards, that is why a 6.0% cap property cannot be levered past about 67% against a 9% floor however comfortable the coverage looks. All three are embeddable with one line of HTML, and all three open on the same property the other calculators do.