Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 418
Default Rembrandt Mortgage Function

Dave wrote:
Sounds like just an excuse to
shade things towards the lender. The issue came up when talking to a local
banker (clerk) who gave me the numbers I listed previously, but referred to
them as from the 'Home Office' and interestingly were not the numbers she
came up with on her desktop mortgage calculator.


Sounds to me more like the game of "telephone" and lots of room for
human error.

You mentioned -
the software implementation might be proprietary. But the methodology is
not; it is defined by US federal regulations.


What is the US regulation methodology?


I was referring to computational methods defined by HMDA and HOEPA.
"Heavy stuff" and really not relevant. I was just making the point
that __those__ algorithms are defined by the
US federal government. They are not proprietary.

accumulates interest for a few days before the monthly payment
window begins, for example to align payments with some "nice" time of
the month like the 1st, 15th, or end of the month.


This is probably one of the better possibilities.


Actually, on second thought, I think it is unlikely. The common
practice is to add such "prepaid interest" to the loan fees, which are
paid on the front end. I have never heard of adding it to the loan
principal. I mentioned it before without really thinking about it,
based on what-if numerical experiments.

Again, we need to see the
amortization schedule. BTW, how can I get it to you, since I believe
msnewsgroups does allow attachments? Can I just use ?


Yes.

Stay tuned - I'll let you know when the schedule arrives


Thanks. You've piqued my curiosity.

Reply
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
Fill Function to next Column shital shah Excel Worksheet Functions 0 August 16th 06 02:53 PM
VBA Monty Excel Worksheet Functions 2 January 30th 06 01:37 PM
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 10:59 PM.

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"