Newbie problem with amortization calculations

#3 01-01-2006, 05:14 PM

"ankalime" <ankalime[at]yahoo.com> wrote in message
news:1136121769.976289.24530[at]o13g2000cwo.googlegroups.com...
- quote -

> Dick, thank you so much! Your method got it to within a few pennies. I can
> live with that!

I manually adjust the allocation of the last payment of the year so the
principal balance and interest match the bank's statement exactly. The
adjustment usually is very small.
--
Chris Cowles
Gainesville, FL

#2 01-01-2006, 01:13 PM

Good to hear you have solved your issue. Thanks for the feedback. Check back
with any new issues in the future! And a happy 2006 to you as well.

"ankalime" <ankalime[at]yahoo.com> wrote in message
news:1136121769.976289.24530[at]o13g2000cwo.googlegroups.com...
- quote -

> Dick, thank you so much! Your method got it to within a few pennies. I
> can live with that!

#1 01-01-2006, 12:22 PM

Dick Watson wrote:
- quote -

> Let Money calculate an effective interest rate. Use the number of payments,
> principal and PI payment from the loan itself. See if that gets you closer.
> It likely will not match to the penny since there are lots of variables that
> the bank knows and there's no place to tell Money. One example: a long first
> payment cycle.

Dick, thank you so much! Your method got it to within a few pennies. I
can live with that!

Happy 2006!

Cindy

01-01-2006, 04:03 AM

Let Money calculate an effective interest rate. Use the number of payments,
principal and PI payment from the loan itself. See if that gets you closer.
It likely will not match to the penny since there are lots of variables that
the bank knows and there's no place to tell Money. One example: a long first
payment cycle.

"ankalime" <ankalime[at]yahoo.com> wrote in message
news:1136072047.682813.116660[at]g47g2000cwa.googlegroups.com...
- quote -

> I've just today installed Money 2006 Deluxe trial version; a full
> version is on the way, which I am beginning to regret.
> I've only gotten as far as downloading my checking account from my bank
> and TRYING to establish an account for my mortgage. I have entered the
> information five times now, but the mortgage amortization Money
> calculates simply will NOT match my bank's. It starts off being off by
> a few pennies at best, and escalates by the end of the amortization to
> being off by anywhere from a few dollars to fifty or more. Money also
> will not allow me to make the mortgage come out to 360 payments. I can
> make it 359 payments... or 358 payments... but not 360.
> Is this just the way it is? Am I doing something wrong? Can anyone
> please help?

#-1 12-31-2005, 10:34 PM

Hello,

I've just today installed Money 2006 Deluxe trial version; a full
version is on the way, which I am beginning to regret.

I've only gotten as far as downloading my checking account from my bank
and TRYING to establish an account for my mortgage. I have entered the
information five times now, but the mortgage amortization Money
calculates simply will NOT match my bank's. It starts off being off by
a few pennies at best, and escalates by the end of the amortization to
being off by anywhere from a few dollars to fifty or more. Money also
will not allow me to make the mortgage come out to 360 payments. I can
make it 359 payments... or 358 payments... but not 360.

Is this just the way it is? Am I doing something wrong? Can anyone
please help?

TIA,
Cindy

Similar Threads
Thread	Forum	Replies	Last Post
Mortgage Calculations Money User: Can anyone tell/show me how Money calculates the mortgage principal and interest amounts? I've been pulling (what's left) my hair out the last...	Microsoft Money	6	02-06-2005 02:42 PM
Mortgage calculations Brenda \(au\): Recently I created a mortgage account in MS-Money (ver: standard, 2003, International apparently) as per bank statements. However none of the...	Microsoft Money	7	08-11-2004 05:02 PM
erroneous roi calculations cmgilldh: What causes this? I have a mutual fund for which the 3 month and ytd calc is obviously wrong. During this period I transferred the shares from one...	Microsoft Money	1	03-01-2004 06:48 PM
Invoice calculations Bill: I reported to MS Tier I tech service that there was a bug in MS Money Sm Business 2004 in the invoicing area. Specifically, while MsMo allows a...	Microsoft Money	1	02-10-2004 09:31 PM
Share price calculations Ian: Hi, When I create a share account and then download the prices from the net the calculation seems to go wrong. The share price download is in...	Microsoft Money	1	08-20-2003 05:01 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode