Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 06-03-2006, 12:57 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Additional Loan pmt messes up total interest paid

I can't duplicate the result in M04, but it wouldn't surprise me if that's
just the way the Analyze Loan Amortization (the loan amortization report)
thing works. In M04 it just gives you a static report for the loan terms
regardless of how you've paid the loan off and lots of users complained
about this. Microsoft may have "fixed" this in an equally broken way.

I also think you are saying that the lender took some of the extra payment
and applied it to interest and the Other option didn't have a place to put
the interest. That's why it wants a transfer account in the extra payment
choice. It needs somewhere to put a Loan Payment that it can split into a
Principal Transfer and an Interest Expense. Say you just endorsed the
windfall check to the lender, so you don't really have a transfer account.
Pretend. "Deposit" it to some account (like you pocket cash account, if you
have one) and then make a Loan Payment. In the bogus "deposit" you can
account for the Income. Since the amount in = the amount out in the account
where you put the "deposit", it's just two entries that don't change the
balance of the cash account. Then you have a place/a Loan Payment
transaction where you can adjust the interest and the principal.

"Loretta" <Loretta[at]discussions.microsoft.com> wrote in message
news:5B69A0F9-D035-49B5-BAC9-AB1FA12748C4[at]microsoft.com...
- quote -

> I recently came into a bit of a windfall and made a large extra payment.
> I
> went into the account register for the loan and clicked [New] to add this
> additional payment. The "Make a regular loan payment" and "Make an extra
> loan payment" options both require me to transfer from an existing
> account.
> The "other" option requires me to enter the principle paid, not the total
> payment, Both it and "Update amount owed" put the same value in the
> Payment
> and Principle columns - not showing how much I actually paid.
> I selected the "Other" option and filled in the Principle paid
> Selecting the "Analyze loan - View amortization schedule" shows the entry
> as
> Payment amount=$4,000 Principle amount=$4,000 Interest=($4,000) which
> means that the grand total for interest is ($3,000) Makes it look like
> the
> bank paid ME to borrow money from them (I wish)
> Did I do something wrong, or is this just the way Money works (or doesn't
> work)
> --
> Lori



  #-1  
Old 06-03-2006, 03:21 AM
Loretta
Guest
 
Posts: n/a
Default Additional Loan pmt messes up total interest paid

Hopefully I have enough detail without flooding you with trivia.

Money 2006 standard edition
Advanced register

I set up a car loan a while back. Money's been calculating principle and
interest correctly (within a peny or so each month - roundoff error) The
loan pmt in Money is set to pay automatically from my checking account

I recently came into a bit of a windfall and made a large extra payment. I
went into the account register for the loan and clicked [New] to add this
additional payment. The "Make a regular loan payment" and "Make an extra
loan payment" options both require me to transfer from an existing account.
The "other" option requires me to enter the principle paid, not the total
payment, Both it and "Update amount owed" put the same value in the Payment
and Principle columns - not showing how much I actually paid.

I selected the "Other" option and filled in the Principle paid

Selecting the "Analyze loan - View amortization schedule" shows the entry as
Payment amount=$4,000 Principle amount=$4,000 Interest=($4,000) which
means that the grand total for interest is ($3,000) Makes it look like the
bank paid ME to borrow money from them (I wish)

Did I do something wrong, or is this just the way Money works (or doesn't
work)
--
Lori
 

Tags
additional, interest, loan, messes, paid, pmt, total
Similar Threads
Thread Forum Replies Last Post
Home Equity Loan - Interest computed on a 365/365 simple interest basis
Kathleen Anderson [MVP - FrontPage]: 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...
Microsoft Money 11 10-21-2005 03:45 PM
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
Interest-Only Mortgage Loan
Miazike: What is the best way to set up an interest-only ARM? Money wants to calculate a payment consisting of principal plus interest.
Microsoft Money 6 12-11-2004 09:41 PM
Reports only using Interest paid for its calculations?
DRUAngell: I've been using Money since Money03...I'm using Money 05 now. I've got a very simple financial life and I've never really tried to use any of...
Microsoft Money 5 11-21-2004 04:08 PM



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 07:56 PM.