Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #8  
Old 10-01-2007, 06:12 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

There's a somewhat out-of-date FAQ on refinancing at
http://umpmfaq.info/faqdb.php?q=86. I say somewhat out of date because it
refers to a wizard that isn't there anymore. Also the referenced article
deals with a real refi. In your case, you could skip lots of the steps. It
might also just not be worth it. You could hand edit 24 transactions a year
to match data from your statements and/or the lender's website.

"bleitner" <bleitner[at]discussions.microsoft.com> wrote in message
news:123E4BE8-9C3F-40E4-A858-1DF200F57F86[at]microsoft.com...
- quote -

> refinancing was mentioned earlier, I assume that would be an option to
> getting my loan fequency to twice monthly and allow P&I to be auto
> calculated? If this is an option, how do you do a refinance in Money? I
> don't see any options to do it and Help doesn't offer anything? I'll also
> check the google groups as you suggested.



  #7  
Old 10-01-2007, 01:34 PM
bleitner
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

refinancing was mentioned earlier, I assume that would be an option to
getting my loan fequency to twice monthly and allow P&I to be auto
calculated? If this is an option, how do you do a refinance in Money? I
don't see any options to do it and Help doesn't offer anything? I'll also
check the google groups as you suggested.

Thanks!
Bob


"Dick Watson" wrote:

- quote -

> I guess I'm out of good ideas. I've never tried a test case (or real world
> case) of this, so I'm not sure how best to workaround. Nor do I know why
> they let you edit loan terms besides payment frequency. It does come up here
> form time to time though. You might search the archives of group
> microsoft.public.money at http://groups.google.com.
> "bleitner" <bleitner[at]discussions.microsoft.com> wrote in message
> news:C6068FC3-3AF1-424E-A24B-C12DA6CBE637[at]microsoft.com...
> > Thanks for the reply. I can enter a loan payment in the register but if I
> > tie it to the loan then it calculates the P and I based on the the monthly
> > frequency. This doesn't help much because I don't know what the
> > amoritization schedule is from month to month so it makes it a little hard
> > to
> > do it this way. If I change the frequency of the bill it doesn't change
> > the
> > frequency of the loan and the payment is still calculated based on the
> > loan.
> > Since the split shows calculated for the P and I, and I can't change it,
> > it
> > just makes the original payment amount due twice a month. If I change the
> > total then it barks at me the that the sum of the splits doesn't match the
> > total payment, but none of the options allow me to change the splits
> > because
> > they're calculated. Any other ideas or suggestions? I don't understand
> > why
> > when you set up a loan it asks you the frequency, but if you go to edit it
> > you can edit everything else but the frequency???

  #6  
Old 10-01-2007, 12:52 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

I guess I'm out of good ideas. I've never tried a test case (or real world
case) of this, so I'm not sure how best to workaround. Nor do I know why
they let you edit loan terms besides payment frequency. It does come up here
form time to time though. You might search the archives of group
microsoft.public.money at http://groups.google.com.

"bleitner" <bleitner[at]discussions.microsoft.com> wrote in message
news:C6068FC3-3AF1-424E-A24B-C12DA6CBE637[at]microsoft.com...
- quote -

> Thanks for the reply. I can enter a loan payment in the register but if I
> tie it to the loan then it calculates the P and I based on the the monthly
> frequency. This doesn't help much because I don't know what the
> amoritization schedule is from month to month so it makes it a little hard
> to
> do it this way. If I change the frequency of the bill it doesn't change
> the
> frequency of the loan and the payment is still calculated based on the
> loan.
> Since the split shows calculated for the P and I, and I can't change it,
> it
> just makes the original payment amount due twice a month. If I change the
> total then it barks at me the that the sum of the splits doesn't match the
> total payment, but none of the options allow me to change the splits
> because
> they're calculated. Any other ideas or suggestions? I don't understand
> why
> when you set up a loan it asks you the frequency, but if you go to edit it
> you can edit everything else but the frequency???



  #5  
Old 10-01-2007, 05:00 AM
bleitner
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

Hi Dick,

Thanks for the reply. I can enter a loan payment in the register but if I
tie it to the loan then it calculates the P and I based on the the monthly
frequency. This doesn't help much because I don't know what the
amoritization schedule is from month to month so it makes it a little hard to
do it this way. If I change the frequency of the bill it doesn't change the
frequency of the loan and the payment is still calculated based on the loan.
Since the split shows calculated for the P and I, and I can't change it, it
just makes the original payment amount due twice a month. If I change the
total then it barks at me the that the sum of the splits doesn't match the
total payment, but none of the options allow me to change the splits because
they're calculated. Any other ideas or suggestions? I don't understand why
when you set up a loan it asks you the frequency, but if you go to edit it
you can edit everything else but the frequency???

Thanks,
Bob


"Dick Watson" wrote:

- quote -

> Independent of the P&I in the loan setup, what happens if you just go to a
> register and enter a Loan Payment? What happens if you just change the
> frequency of the scheduled Loan Payment and don't worry about the Loan
> Setup? I know in the case of extra principal it calculates the owed interest
> in a payment as a function of the balance since the last payment without
> regard to the original amortization schedule. It really doesn't matter what
> the dialog boxes say--what matters is what it calculates in the payment it
> puts in the register.
> "bleitner" <bleitner[at]discussions.microsoft.com> wrote in message
> news:1B275FB3-A2BB-4E1B-A508-3434C2DB0C01[at]microsoft.com...
> > I can add a new line item for extra principle transfer, but at this moment
> > it doesn't do me any good because I have only one payment per month and
> > the
> > split for P&I is calculated based on the loan. If I could change the
> > frequency from once a month to twice a month then I think I would be good,
> > but I can't find any way to change that??? Any other ideas?

  #4  
Old 09-25-2007, 12:59 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

Independent of the P&I in the loan setup, what happens if you just go to a
register and enter a Loan Payment? What happens if you just change the
frequency of the scheduled Loan Payment and don't worry about the Loan
Setup? I know in the case of extra principal it calculates the owed interest
in a payment as a function of the balance since the last payment without
regard to the original amortization schedule. It really doesn't matter what
the dialog boxes say--what matters is what it calculates in the payment it
puts in the register.

"bleitner" <bleitner[at]discussions.microsoft.com> wrote in message
news:1B275FB3-A2BB-4E1B-A508-3434C2DB0C01[at]microsoft.com...
- quote -

> I can add a new line item for extra principle transfer, but at this moment
> it doesn't do me any good because I have only one payment per month and
> the
> split for P&I is calculated based on the loan. If I could change the
> frequency from once a month to twice a month then I think I would be good,
> but I can't find any way to change that??? Any other ideas?



  #3  
Old 09-25-2007, 06:52 AM
bleitner
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

Hi Dick,

I can add a new line item for extra principle transfer, but at this moment
it doesn't do me any good because I have only one payment per month and the
split for P&I is calculated based on the loan. If I could change the
frequency from once a month to twice a month then I think I would be good,
but I can't find any way to change that??? Any other ideas?

Thanks!
Bob

"Dick Watson" wrote:

- quote -

> comments below...
> "bleitner" <bleitner[at]discussions.microsoft.com> wrote in message
> news:436B93E0-7E24-4AD7-85E0-C8D5463FC6CF[at]microsoft.com...
> > Thanks for the reply. It actually is a bi-monthly type program and they
> > throw in an extra payment annually that's divided up across all payments,
> > pluss I rounded up a little. A little extra goes a long way, turns a 30
> > yr
> > mortgage into a 23 1/2 yr mortgage. Anyway, I read what the link below
> > contains about a refinance but don't have that option in money 2007
> > deluxe,

> I'll have to investigate that.
> > when I go to my mortgage account the only thing under analyze loan is view
> > amoritization schedule, not consider refinance. I even created another
> > dummy
> > loan and it was the same, plus when I went to add in the extra I now chose
> > to
> > add to principle to round up there was no where to add that. It told me
> > to
> > do it after I create the loan in loan details but can't find anywhere to
> > do
> > it there.

> Go into the scheduled loan payment in Bills & Deposits and edit the series
> of Loan Payments. In the splits, add another Principal Transfer line in the
> amount of extra principal for each loan payment.
> > It's funny that you can change all the other loan terms, like
> > length, interest, P&I, and baloon amount, but you can't change the
> > frequency
> > or add extra to principle? Any other thoughts you have would be
> > appreciated.

  #2  
Old 09-24-2007, 12:11 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

comments below...

"bleitner" <bleitner[at]discussions.microsoft.com> wrote in message
news:436B93E0-7E24-4AD7-85E0-C8D5463FC6CF[at]microsoft.com...
- quote -

> Thanks for the reply. It actually is a bi-monthly type program and they
> throw in an extra payment annually that's divided up across all payments,
> pluss I rounded up a little. A little extra goes a long way, turns a 30
> yr
> mortgage into a 23 1/2 yr mortgage. Anyway, I read what the link below
> contains about a refinance but don't have that option in money 2007
> deluxe,


I'll have to investigate that.

- quote -

> when I go to my mortgage account the only thing under analyze loan is view
> amoritization schedule, not consider refinance. I even created another
> dummy
> loan and it was the same, plus when I went to add in the extra I now chose
> to
> add to principle to round up there was no where to add that. It told me
> to
> do it after I create the loan in loan details but can't find anywhere to
> do
> it there.


Go into the scheduled loan payment in Bills & Deposits and edit the series
of Loan Payments. In the splits, add another Principal Transfer line in the
amount of extra principal for each loan payment.

- quote -

> It's funny that you can change all the other loan terms, like
> length, interest, P&I, and baloon amount, but you can't change the
> frequency
> or add extra to principle? Any other thoughts you have would be
> appreciated.



  #1  
Old 09-24-2007, 08:06 AM
bleitner
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

Hi Cal,

Thanks for the reply. It actually is a bi-monthly type program and they
throw in an extra payment annually that's divided up across all payments,
pluss I rounded up a little. A little extra goes a long way, turns a 30 yr
mortgage into a 23 1/2 yr mortgage. Anyway, I read what the link below
contains about a refinance but don't have that option in money 2007 deluxe,
when I go to my mortgage account the only thing under analyze loan is view
amoritization schedule, not consider refinance. I even created another dummy
loan and it was the same, plus when I went to add in the extra I now chose to
add to principle to round up there was no where to add that. It told me to
do it after I create the loan in loan details but can't find anywhere to do
it there. It's funny that you can change all the other loan terms, like
length, interest, P&I, and baloon amount, but you can't change the frequency
or add extra to principle? Any other thoughts you have would be appreciated.

Thanks,
Bob

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, bleitner wrote:
> > > I recently took advantage of an accelerator program with my mortgage company

> > in which you pay your monthly mortgage payment twice a month instead of once.
> > The problem is that I orginally set up my mortgage payment for once a month
> > and when I go to try and change it to twice a month both the principle and
> > interest lines in the details view show the amount as calculated. When I try
> > to change the total amount and the frequency the details view (split) is
> > coming up as wrong because it's calculating it as a monthly payment not
> > bi-monthly. How can I fix this?

> Looking at
> http://articles.moneycentral.msn.com...YourHouse.aspx
> it would seem that you are using a method much better than the more
> common biweekly programs sold by third parties.
> While you could model this more precisely by scheduling payments to
> be taken from a separate account and then making principal payments
> with the extra, it seems easier to treat this as a refinance of your
> mortgage. http://umpmfaq.info/faq.html#Q86

 
Old 09-23-2007, 07:15 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Splitting monthly mortgage payment into two payments

In microsoft.public.money, bleitner wrote:

- quote -

> I recently took advantage of an accelerator program with my mortgage company
> in which you pay your monthly mortgage payment twice a month instead of once.
> The problem is that I orginally set up my mortgage payment for once a month
> and when I go to try and change it to twice a month both the principle and
> interest lines in the details view show the amount as calculated. When I try
> to change the total amount and the frequency the details view (split) is
> coming up as wrong because it's calculating it as a monthly payment not
> bi-monthly. How can I fix this?


Looking at
http://articles.moneycentral.msn.com...YourHouse.aspx
it would seem that you are using a method much better than the more
common biweekly programs sold by third parties.

While you could model this more precisely by scheduling payments to
be taken from a separate account and then making principal payments
with the extra, it seems easier to treat this as a refinance of your
mortgage. http://umpmfaq.info/faq.html#Q86

  #-1  
Old 09-23-2007, 06:56 PM
bleitner
Guest
 
Posts: n/a
Default Splitting monthly mortgage payment into two payments

Hi,

I recently took advantage of an accelerator program with my mortgage company
in which you pay your monthly mortgage payment twice a month instead of once.
The problem is that I orginally set up my mortgage payment for once a month
and when I go to try and change it to twice a month both the principle and
interest lines in the details view show the amount as calculated. When I try
to change the total amount and the frequency the details view (split) is
coming up as wrong because it's calculating it as a monthly payment not
bi-monthly. How can I fix this?

Thanks,
Bob
 

Tags
monthly, mortgage, payment, payments, splitting
Similar Threads
Thread Forum Replies Last Post
Amortizing loan Account stopped splitting the payment
beamone: I have a House loan that is Amortized . When I look at the Amortizition Schedule the automatic payment amortized properly into the 2 Accounts...
Microsoft Money 15 04-10-2006 05:21 AM
Changing Mortgage/Loan payment from monthly to every other week
AdrianB: Using MS MONEY 2005 Deluxe, I've been successful in converting my car loan payment frequencies and values from monthly to every-other-week. ...
Microsoft Money 2 09-22-2005 02:37 AM
Bi monthly mortgage payments
bob: Does anyone know if a mortgage can be set up in money (2000} with 1/2 payments every other week? I'm not having much luck getting an answer...
Microsoft Money 3 05-14-2004 12:17 PM
Bi-monthly mortgage payments
xzzy: using 2004, how do I set up our mortgage which is two 1/2 payments a month? Thanks, John Bickmore www.BicycleCam.com www.Feed-Zone.com
Microsoft Money 2 12-13-2003 05:09 PM
How to change monthly mortgage payment to biweekly?
Pauldcwa: Using Money 2002 Deluxe: I'm set up on a monthly basis at present but will shortly be making b-weekly mortgage house payments. How do you change...
Microsoft Money 1 11-16-2003 08:26 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 12:53 AM.