Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 12-02-2003, 04:45 PM
Jamie Stallwood
Guest
 
Posts: n/a
Default Re: Updating Variable Rate Loan where payment stays the same.

On Mon, 1 Dec 2003 08:16:03 -0000, "Glyn Simpson, MVP" <glyn[at]serf.orgwrote in microsoft.public.uk.money:

- quote -

> Nope, left the loan term as stated on the paperwork. The loan amortisation
> schedule shows I'd pay it off beforehand. I did however, set it up as an
> interest only loan.


Ah! Of course. Very smart.

And I was thinking, these sorts of loans would be ideal for
buy-to-lets where the rental income can't gear with the variable
mortgage payments.
--
Jamie Stallwood
newser[at]bra-and-knickers.project76.tv
http://www.project76.co.uk
[Remove underwear to reply to this message]
  #2  
Old 12-01-2003, 07:16 AM
Glyn Simpson, MVP
Guest
 
Posts: n/a
Default Re: Updating Variable Rate Loan where payment stays the same.

Nope, left the loan term as stated on the paperwork. The loan amortisation
schedule shows I'd pay it off beforehand. I did however, set it up as an
interest only loan.


"Jamie Stallwood" <gnu[at]toad.com> wrote in message
news:gmljsvc9s8in5njju4ba1kvjllm253m4gr[at]4ax.com...
- quote -

> On Sun, 30 Nov 2003 08:23:30 -0000, "Glyn Simpson, MVP"
> <glyn[at]serf.org> wrote in microsoft.public.uk.money:
> > I have a similar loan, I pay the same amount each month, and if rates
> > change, then the overpayment is less, so less money goes on the

principal. I
> > handle this by adjusting the interest rate, leave the monthly payment

blank
> > and run through the options. At the end of the wizard, you can add other
> > fees - i add a principal transfer at this point to make the total payment
> > equal to the fixed amount I pay.
> > > When I get the statement every six months, or look it up online, I

manually
> > adjust the payments to have the exact principal and interest payments for
> > the fixed amount I pay

> I am presuming that when you set up the loan, you had to work out what
> loan term to set, how did you calculate that?
> --
> Jamie Stallwood
> newser[at]bra-and-knickers.project76.tv
> http://www.project76.co.uk
> [Remove underwear to reply to this message]



  #1  
Old 11-30-2003, 10:39 AM
Jamie Stallwood
Guest
 
Posts: n/a
Default Re: Updating Variable Rate Loan where payment stays the same.

On Sun, 30 Nov 2003 08:23:30 -0000, "Glyn Simpson, MVP"
<glyn[at]serf.org> wrote in microsoft.public.uk.money:

- quote -

> I have a similar loan, I pay the same amount each month, and if rates
> change, then the overpayment is less, so less money goes on the principal. I
> handle this by adjusting the interest rate, leave the monthly payment blank
> and run through the options. At the end of the wizard, you can add other
> fees - i add a principal transfer at this point to make the total payment
> equal to the fixed amount I pay.
> When I get the statement every six months, or look it up online, I manually
> adjust the payments to have the exact principal and interest payments for
> the fixed amount I pay


I am presuming that when you set up the loan, you had to work out what
loan term to set, how did you calculate that?
--
Jamie Stallwood
newser[at]bra-and-knickers.project76.tv
http://www.project76.co.uk
[Remove underwear to reply to this message]
 
Old 11-30-2003, 07:23 AM
Glyn Simpson, MVP
Guest
 
Posts: n/a
Default Re: Updating Variable Rate Loan where payment stays the same.

I have a similar loan, I pay the same amount each month, and if rates
change, then the overpayment is less, so less money goes on the principal. I
handle this by adjusting the interest rate, leave the monthly payment blank
and run through the options. At the end of the wizard, you can add other
fees - i add a principal transfer at this point to make the total payment
equal to the fixed amount I pay.

When I get the statement every six months, or look it up online, I manually
adjust the payments to have the exact principal and interest payments for
the fixed amount I pay

--
Glyn Simpson, Microsoft MVP - Money

Check http://support.microsoft.com/default...d=fh;EN-GB;mny
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email mnyukwsh[at]microsoft.com especially if it's a UK specific wish.

I do not respond to any unsolicited email regarding Money

"skube" <sean[at]skube.com> wrote in message
news:673933b2.0311291411.1ece5949[at]posting.google.com...
- quote -

> Hello, I'm hoping someone will be able to help me out. Or perhaps
> offer some suggestions...
> I'm using MS Money 2004 and have setup a variable rate loan (for my
> Canadian mortgage). Whenever my bank changes their rate, my payment
> does NOT change. Only the ratio of how much of my payment goes to
> interest and how much goes to the principal changes.
> Apparently, MS Money doesn't recognize this type of loan agreement as
> it changes the entire payment amount to reflect the new rate. I
> thought I could get around this problem by simply accepting the
> payment amount that MS Money calculates, then creating an extra loan
> payment amount on the same day to adjust the principal. However, this
> produces a balance which is slightly off.
> There doesn't seem to be any method where one can enter the new rate
> AND the payment amount since MS Money doesn't like the numbers as they
> work together.
> I can't understand how more people haven't had this issue. I can't
> find any solution anywhere.



  #-1  
Old 11-29-2003, 09:11 PM
skube
Guest
 
Posts: n/a
Default Updating Variable Rate Loan where payment stays the same.

Hello, I'm hoping someone will be able to help me out. Or perhaps
offer some suggestions...

I'm using MS Money 2004 and have setup a variable rate loan (for my
Canadian mortgage). Whenever my bank changes their rate, my payment
does NOT change. Only the ratio of how much of my payment goes to
interest and how much goes to the principal changes.

Apparently, MS Money doesn't recognize this type of loan agreement as
it changes the entire payment amount to reflect the new rate. I
thought I could get around this problem by simply accepting the
payment amount that MS Money calculates, then creating an extra loan
payment amount on the same day to adjust the principal. However, this
produces a balance which is slightly off.

There doesn't seem to be any method where one can enter the new rate
AND the payment amount since MS Money doesn't like the numbers as they
work together.

I can't understand how more people haven't had this issue. I can't
find any solution anywhere.
 

Tags
loan, payment, rate, stays, updating, variable
Similar Threads
Thread Forum Replies Last Post
Loan with different last payment
Pat DiPersia: I have a car loan that has a different P&I payment for the last payment. What's a good way to enter this info Money? Just using the "correct" P&I...
Microsoft Money 2 10-27-2003 03:10 AM
spliting a loan payment
bob hamblin: I have a loan through a bank, which is paid automatically immediately after i get my paycheck. My Money has a loan account set up for this however...
Microsoft Money 1 10-05-2003 12:26 AM
Updating Loan Accounts
Larry Ewing: I have Money 2003. I have a car loan, which is entered in Bills & Deposits for automatic entry into my checking account register once a month. How...
Microsoft Money 1 09-17-2003 12:34 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 04:18 AM.