Foreclosure: Net Present Value Calculator
In a foreclosure situation, the bank may be required to determine the "Net Present Value" of your home. Doing this math can help the lender know whether a loan modification would be in everyone's best interests. The attachment below is the calculator the FDIC posted on its website until recently and the one that Maine mediators are still using to guide the lender and homeowner in the foreclosure mediation process. This tool is difficult to use if you are not familiar with it. But it can give you an idea of what a court mediator will be looking at to determine whether you may qualify for a loan modification.
Note: The attached file is an Excel spreadsheet. You will need Excel - or a similar spreadsheet software - to view it.
PTLA # 677
February 2012 update: The FDIC has re-posted its version of the calculator here.