HASP Excel Estimator Updated: Results Match White House Example.

I have updated the Homeowner Affordability and Stability Loan Modification Excel Estimator HERE.

(Current Feb.21 version is now 1.1; prior version of the Estimator has been removed).

Updates:

1. Changed baseline loan assumption to match the White House /Treasury example provided HERE on page 2. Good news is that my calculations match their example, AND I build from that to breakout/allocate costs to lender and government with user selected options for incentive payments and universe of loans.
   
2. Added the ability to vary inputs in line item 13. Users can now select different pull down values of $0-$5,000, in $1,000 increments, to see net cost impacts of various scenarios. (Lender income is automatically adjusted in line item 17 to match inputs in line item 13, subject to a cap of $3,000.
   
3. Deleted ability to input monthly income inputs, this line is calculated from annual income input.
4. Added clarifying comments in several line items.

(TIP: The estimator is in Excel 2007 file format. Some users report when they save Excel 2007 files they end up with a compressed .zip file extension. My suggestion is to download and save the file to your pc. Find the downloaded file, and if necessary, change the .zip extension to Excel 2007 extension (.xlsx), and THEN open the file with Excel).