This estimator will be a work in progress for the foreseeable future, as new information is received and my understanding improves. (I have removed the prior version).
In the new version
- Cell entries are allowed in grey shaded cells only (Line items 1,3, and 29).
- I have updated the cost sharing arrangements to reflect my current understandings.
- Mortgage payment does not currently include taxes and insurance.
- Default entries for the baseline assumption have been set to actual owner occupant subprime average interest rate, term remaining, and mortgage principal for Oregon subprime borrowers. Borrower income is not tied to any specific known amount. See assumptions worksheet for source/link to assumptions.
- Line 5 A was added to indicate if current ratio is already 31% or below. If that is true, then ALL following calculations shown below for that column are INVALID, and borrower does NOT qualify for loan modification program.
- Under certain assumptions, it is possible that the lender would have NO net cost, but net income. This can only occur in a limited set of circumstances, and always would be subject to the borrower making 3 years of on time payments. "Possible" is key word here; will clearly be the exception and NOT the rule.
- An assumptions worksheet has been added to track current assumptions used for the estimator.
- Line item 29 is an input and can be changed to estimate costs for specific number of borrowers.
(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 .xlsx and THEN open the file with Excel).
Please do drop me a note if you discover problems : housepdx@gmail.com
No comments:
Post a Comment