LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 85
Default Reverse mortgage math?

I am curious about the math of reverse mortgages. I have done a
google search and looked at some sites, but I cannot find anything
that makes it clear to me.

Disclaimer: I am __not__ considering a reverse mortgage. So I do not
need advice. This is really just an academic exercise for me.

From what I can tell, it appears that there is a lot of smoke and
mirrors that lenders employ to determine the parameters of a reverse
mortgage. Let's not go there.

Assume that the lender has determined that the home equity is
$500,000, the applicable life expectancy(s) is 30 years, and the
lender is willing to pay interest at 5%.

Would the nominal monthly annuity (paid by the lender to me) be
simply:

=pmt(5%/12, 30*12, -500000)

And if I dispose of the property (or die) in 15 years, would the
equity to be paid to the lender be:

=500000 - fv(5%/12, 15*12, pmt, -500000)

In any case, how is the lump sum payment (to me) from the lender
determined?

I presume it's the PV of something. But what?

I have a lot of other questions that go beyond the math. For example,
it's not clear to me why a lender would offer a reverse mortgage. How
is the lender making money in the meantime before the sale of the
property?

Presumably, that "cost of capital" is factored into how the lender
chooses that the interest rate that the lender offers. But even that
math is less clear to me for reverse mortgages than for so-called
"forward" mortgages. I stumbled across an excellent book once that
explained all this. But, sigh, I don't remember the book title.

Anyway, these questions make me suspect that I have the wrong model
for the reverse mortgage, in the first place.

Any help with understanding the mechanics of reverse mortages from
both sides would be appreciated.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Computing mortgage APR NorCalHomeFinance Excel Worksheet Functions 2 August 12th 08 11:42 PM
How to do UK mortgage math? joeu2004 Excel Discussion (Misc queries) 1 June 28th 07 08:06 PM
Calculating APR on a Mortgage Sean B Excel Discussion (Misc queries) 12 June 12th 06 05:07 AM
mortgage formula Ron New Users to Excel 9 August 30th 05 01:55 AM
mortgage eddie New Users to Excel 2 June 24th 05 10:41 PM


All times are GMT +1. The time now is 05:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"