Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #10  
Old 10-21-2005, 03:45 PM
Kathleen Anderson [MVP - FrontPage]
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

"Chris Cowles" <NoSpam[at]For.me> wrote in message
news:%23FGrTpk1FHA.164[at]TK2MSFTNGP10.phx.gbl...
- quote -

> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman[at]mvps.org> wrote in
> message
> > > What about adjusting the initial payment, to reflect the way BOA applied

> > the payment?

> That's an equally valid approach.


I did it - the results are a lot closer than before. Thanks.

- quote -

> Do a backup first.

I always do. I was actually getting ready to move Money to a different PC
with more memory, so I killed two birds with one stone.

Thanks for your help,


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/



  #9  
Old 10-21-2005, 02:18 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman[at]mvps.org> wrote in
message
- quote -

> What about adjusting the initial payment, to reflect the way BOA applied
> the payment?


That's an equally valid approach. Do a backup first.


  #8  
Old 10-21-2005, 11:35 AM
Kathleen Anderson [MVP - FrontPage]
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

"Chris Cowles" <NoSpam[at]For.me> wrote in message
news:efGVNEf1FHA.3336[at]TK2MSFTNGP12.phx.gbl...
- quote -

> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman[at]mvps.org> wrote in
> message news:uxa3JCd1FHA.1256[at]TK2MSFTNGP09.phx.gbl...
> > Yes. I discovered another section called "Service My Mortage", created an
> > account, and got the schedule. What's really odd is that the principal
> > and interest figures are pretty close to each other - within a couple of
> > dollars - but the principal balance is off by about $240.00.

> I'll guess it's related to the initial payment period. Money assumes 30
> days. The lapse between funding and initial payment probably was more than
> that. An adjustment dated 1 day after the initial payment, to match it to
> the bank's figures, probably will result in Money prompting you to adjust
> interest on subsequent payments. Let it, and check out the result.
> Do a backup first.


It was almost 60 days.

What about adjusting the initial payment, to reflect the way BOA applied the
payment?


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/



  #7  
Old 10-21-2005, 03:39 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman[at]mvps.org> wrote in
message news:uxa3JCd1FHA.1256[at]TK2MSFTNGP09.phx.gbl...
- quote -

> Yes. I discovered another section called "Service My Mortage", created an
> account, and got the schedule. What's really odd is that the principal and
> interest figures are pretty close to each other - within a couple of
> dollars - but the principal balance is off by about $240.00.


I'll guess it's related to the initial payment period. Money assumes 30
days. The lapse between funding and initial payment probably was more than
that. An adjustment dated 1 day after the initial payment, to match it to
the bank's figures, probably will result in Money prompting you to adjust
interest on subsequent payments. Let it, and check out the result.

Do a backup first.


  #6  
Old 10-20-2005, 11:46 PM
Kathleen Anderson [MVP - FrontPage]
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

"Chris Cowles" <NoSpam[at]For.me> wrote in message
news:uZZt4Vc1FHA.4064[at]TK2MSFTNGP09.phx.gbl...
- quote -

> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman[at]mvps.org> wrote in
> message news:%23j66J5Z1FHA.2788[at]TK2MSFTNGP10.phx.gbl...
> > > Thanks, Cal. I will give that a try. I also called BOA and asked them to

> > send me a copy of the amortization schedule for the note - it's coming by
> > snail mail - I should receive it in 5 to 10 business days. It'll be
> > interesting to see if I can get this to match up.

> I think you can view that on the BofA web site, can you not?


Yes. I discovered another section called "Service My Mortage", created an
account, and got the schedule. What's really odd is that the principal and
interest figures are pretty close to each other - within a couple of
dollars - but the principal balance is off by about $240.00.

- quote -

> Do try to improve but don't try to match it up exactly. You won't. Do as
> Cal states, and accept the few cents or dollars difference per month. At
> the end of the tax/calendar year, enter an adjustment directly in the loan
> account, categorized to mortgage interest. Your tax reports will match the
> bank at that point, and future payments will calculate a little closer to
> the banks, compared to not making the adjustment.


I'll give that a try. Thanks.


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


  #5  
Old 10-20-2005, 10:56 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

Gee, if I had an answer to this, I'd love to trade it for some insight into
why FrontPage PhotoGallery produces pages that are so utterly useless on
anything besides a Windows web host.

My best guess would align with Cal's input.

"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman[at]mvps.org> wrote in
message news:uXtPQJY1FHA.268[at]TK2MSFTNGP09.phx.gbl...
- quote -

> I recently took out a Home Equity Loan with Bank of America and set it up
> in Money 2004. The first payment was taken by auto-debit a couple of days
> ago. The figures on the BOA web site (current principal balance and
> interest paid) do not match what Money calculated. The remaining balance
> according to BOA is higher than Money, and the interest is lower.



  #4  
Old 10-20-2005, 10:27 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis


"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman[at]mvps.org> wrote in
message news:%23j66J5Z1FHA.2788[at]TK2MSFTNGP10.phx.gbl...
- quote -

> Thanks, Cal. I will give that a try. I also called BOA and asked them to
> send me a copy of the amortization schedule for the note - it's coming by
> snail mail - I should receive it in 5 to 10 business days. It'll be
> interesting to see if I can get this to match up.


I think you can view that on the BofA web site, can you not?

Do try to improve but don't try to match it up exactly. You won't. Do as Cal
states, and accept the few cents or dollars difference per month. At the end
of the tax/calendar year, enter an adjustment directly in the loan account,
categorized to mortgage interest. Your tax reports will match the bank at
that point, and future payments will calculate a little closer to the banks,
compared to not making the adjustment.
--
Chris Cowles
Gainesville, FL



  #3  
Old 10-20-2005, 05:56 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

In microsoft.public.money, Kathleen Anderson [MVP - FrontPage]
wrote:

- quote -

> Thanks, Cal. I will give that a try. I also called BOA and asked them to
> send me a copy of the amortization schedule for the note - it's coming by
> snail mail - I should receive it in 5 to 10 business days. It'll be
> interesting to see if I can get this to match up.


You will find that the Money method matches most loan amortization
utilities. If the bank's method shows you owing more than what Money
expected, their "simple" interest is a bit creative. It probably
means that you are paying interest on some of the principle you paid
off already.
  #2  
Old 10-20-2005, 05:47 PM
Kathleen Anderson [MVP - FrontPage]
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:iblfl1t6ve6gupuio59sfpacae58kbsqjp[at]4ax.com...
- quote -

> In microsoft.public.money, Kathleen Anderson [MVP - FrontPage]
> wrote:
> > I recently took out a Home Equity Loan with Bank of America and set it up
> > in
> > Money 2004. The first payment was taken by auto-debit a couple of days
> > ago.
> > The figures on the BOA web site (current principal balance and interest
> > paid) do not match what Money calculated. The remaining balance according
> > to BOA is higher than Money, and the interest is lower.
> > > I looked at the note and it says: "Interest on this Note is computed on a

> > 365/365 simple interest rate, that is, by applying the ratio of the annual
> > interest rate over the number of days in a year, multiplied by the
> > outstanding principal balance, multiplied by the actual number of days the
> > principal balance is outstanding."
> > > I'm assuming that Money does not calculate this way - is there any way

> > around this? Or have I done something wrong?

> The best thing to do is usually to leave the interest rate blank,
> and to enter the other data into the load for Money. So enter the
> payment size, duration, principle, and balloon data.


Thanks, Cal. I will give that a try. I also called BOA and asked them to
send me a copy of the amortization schedule for the note - it's coming by
snail mail - I should receive it in 5 to 10 business days. It'll be
interesting to see if I can get this to match up.


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/



  #1  
Old 10-20-2005, 05:39 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

In microsoft.public.money, Cal Learner-- MVP wrote:

- quote -

> into the load for Money

That should have been "into the loan for Money."
 
Old 10-20-2005, 05:38 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Home Equity Loan - Interest computed on a 365/365 simple interest basis

In microsoft.public.money, Kathleen Anderson [MVP - FrontPage]
wrote:

- quote -

> I recently took out a Home Equity Loan with Bank of America and set it up in
> Money 2004. The first payment was taken by auto-debit a couple of days ago.
> The figures on the BOA web site (current principal balance and interest
> paid) do not match what Money calculated. The remaining balance according
> to BOA is higher than Money, and the interest is lower.
> I looked at the note and it says: "Interest on this Note is computed on a
> 365/365 simple interest rate, that is, by applying the ratio of the annual
> interest rate over the number of days in a year, multiplied by the
> outstanding principal balance, multiplied by the actual number of days the
> principal balance is outstanding."
> I'm assuming that Money does not calculate this way - is there any way
> around this? Or have I done something wrong?


The best thing to do is usually to leave the interest rate blank,
and to enter the other data into the load for Money. So enter the
payment size, duration, principle, and balloon data.

  #-1  
Old 10-20-2005, 02:26 PM
Kathleen Anderson [MVP - FrontPage]
Guest
 
Posts: n/a
Default Home Equity Loan - Interest computed on a 365/365 simple interest basis

I recently took out a Home Equity Loan with Bank of America and set it up in
Money 2004. The first payment was taken by auto-debit a couple of days ago.
The figures on the BOA web site (current principal balance and interest
paid) do not match what Money calculated. The remaining balance according
to BOA is higher than Money, and the interest is lower.

I looked at the note and it says: "Interest on this Note is computed on a
365/365 simple interest rate, that is, by applying the ratio of the annual
interest rate over the number of days in a year, multiplied by the
outstanding principal balance, multiplied by the actual number of days the
principal balance is outstanding."

I'm assuming that Money does not calculate this way - is there any way
around this? Or have I done something wrong?


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/





 

Tags
basis, computed, equity, home, interest, loan, simple
Similar Threads
Thread Forum Replies Last Post
Interest Only loan
stevev: How do you set up a home mortgage that is interest only for the first 5 years? When you go through the "normal" setup Money splits the payment...
Microsoft Money 1 04-09-2005 08:21 PM
Automatic interest calculation in equity line
Frank A Spina: I have an interest only equity line of credit. Is there a way to automate the the interest transaction calculated on the balance of the loan.
Microsoft Money 1 03-11-2005 02:57 AM
Home Equity loan
MG: When I download new information from my bank (which holds a home equity loan for me) and try to setup the home equity line, Money keeps assigning...
Microsoft Money 1 09-01-2004 02:13 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

All times are GMT. The time now is 01:55 PM.