Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #12  
Old 01-03-2006, 10:21 PM
Eric
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

Hello Dick,

I think I did it. With a bit of both of your suggestions. I set the date to
where I got the new mortgage, filled out everything with zxero, except the
length, made the transfer through a temp account and then updated the loan
info to the right info. Seemed that the first payment MSmoney thought it was
all princupal but now everything goes right.

Thanks,

Eric
"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> schreef in
bericht news:%23LMr%230JEGHA.2872[at]TK2MSFTNGP14.phx.gbl...
- quote -

> I'm not in a position to test this, nor do I have your numbers. But here's
> what I'd test: setup the loan straight away. Skip the issue of the
> transfer--just create it the way Money wants to create it. Skip the $0
> setup--again, just let Money do this its way. Skip the payments already
> made--set the loan account up from Day 1 whenever that was. (You can just
> spin the machine's clock back if Day 1 is further back than Money likes to
> setup the loan--though why it cares is still a complete mystery to me. Why
> on earth does it care if I setup a loan that began in 1976?) See if you
> get
> correct Loan Payments recorded. If so, then pick which problem you want to
> solve and how to solve it. To solve the back payment problem, enter the
> payments in some temporary account that you can offset with some
> unassigned
> income or jest let float negative until you get to the current payment or
> the first payment you want to actually record as coming from another Money
> account. As to the Transfer out of principal, I'm on record as saying
> that's
> more trouble than it's worth. I still think that. I wish there were a way
> to
> do it that didn't involve faking Money out. There isn't. So I set my loans
> up without worrying about it. Faking out Money tends to get you in
> trouble.
> I'm not sure Quicken has a trial version. If you find one, let me know!
> "Eric" <evdslh[at]tiscali.nl> wrote in message
> news:43bacb38$0$744$5fc3050[at]dreader2.news.tiscali.nl...
> > I don't think my loan values are insane. Even if I try to do it just as

> you
> > guys describe it, MSmoney seems to do it differently.
> > > I just started from scratch. I added a new account, Loan, and wanted to

> give
> > all details. So after some details, I said is twas a fixed-rate and

> payments
> > had been made that I wanted to record. After that, I put in an amount of
> > zero, interest zero, length 360 payments, balloon amont zero as Steve
> > described. Then I transferred from this account to the old mortgage, so

> that
> > I owed the right sum. Now I chenged the loan terms, one day after the

> first
> > payment to the right (and sane) terms. I changed the interest rate and
> > entered the right payment and made the balloon amount the same as the
> > loan
> > amount. Now MSmoney calculated 4 terms and had in every term a small
> > principal.



  #11  
Old 01-03-2006, 06:38 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

I'm not in a position to test this, nor do I have your numbers. But here's
what I'd test: setup the loan straight away. Skip the issue of the
transfer--just create it the way Money wants to create it. Skip the $0
setup--again, just let Money do this its way. Skip the payments already
made--set the loan account up from Day 1 whenever that was. (You can just
spin the machine's clock back if Day 1 is further back than Money likes to
setup the loan--though why it cares is still a complete mystery to me. Why
on earth does it care if I setup a loan that began in 1976?) See if you get
correct Loan Payments recorded. If so, then pick which problem you want to
solve and how to solve it. To solve the back payment problem, enter the
payments in some temporary account that you can offset with some unassigned
income or jest let float negative until you get to the current payment or
the first payment you want to actually record as coming from another Money
account. As to the Transfer out of principal, I'm on record as saying that's
more trouble than it's worth. I still think that. I wish there were a way to
do it that didn't involve faking Money out. There isn't. So I set my loans
up without worrying about it. Faking out Money tends to get you in trouble.

I'm not sure Quicken has a trial version. If you find one, let me know!

"Eric" <evdslh[at]tiscali.nl> wrote in message
news:43bacb38$0$744$5fc3050[at]dreader2.news.tiscali.nl...
- quote -

> I don't think my loan values are insane. Even if I try to do it just as
you
> guys describe it, MSmoney seems to do it differently.
> I just started from scratch. I added a new account, Loan, and wanted to

give
> all details. So after some details, I said is twas a fixed-rate and

payments
> had been made that I wanted to record. After that, I put in an amount of
> zero, interest zero, length 360 payments, balloon amont zero as Steve
> described. Then I transferred from this account to the old mortgage, so

that
> I owed the right sum. Now I chenged the loan terms, one day after the

first
> payment to the right (and sane) terms. I changed the interest rate and
> entered the right payment and made the balloon amount the same as the loan
> amount. Now MSmoney calculated 4 terms and had in every term a small
> principal.



  #10  
Old 01-03-2006, 06:06 PM
Eric
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

Hello Dick,

I don't think my loan values are insane. Even if I try to do it just as you
guys describe it, MSmoney seems to do it differently.

I just started from scratch. I added a new account, Loan, and wanted to give
all details. So after some details, I said is twas a fixed-rate and payments
had been made that I wanted to record. After that, I put in an amount of
zero, interest zero, length 360 payments, balloon amont zero as Steve
described. Then I transferred from this account to the old mortgage, so that
I owed the right sum. Now I chenged the loan terms, one day after the first
payment to the right (and sane) terms. I changed the interest rate and
entered the right payment and made the balloon amount the same as the loan
amount. Now MSmoney calculated 4 terms and had in every term a small
principal.

If Quicken would do this just fine, I would be willing to get ten years of
money over to quicken, provided that the transfer would give no problems?!?

I'll download a trial to find out.

For now, if you guys know where I went wrong, I still am very curious to
find out.

Thanks,

Eric
"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> schreef in
bericht news:OoDubHIEGHA.1288[at]TK2MSFTNGP09.phx.gbl...
- quote -

> I've never had problems creating a Loan if the values are sane. It it's
> creating Loan Payments with no interest on an interest only loan, I'd
> suspect that you have not provided sane loan values.
> "Eric" <evdslh[at]tiscali.nl> wrote in message
> news:43ba9bb6$0$715$5fc3050[at]dreader2.news.tiscali.nl...
> > Thanks for your quick answers I'll try what you both suggested, but it

> will
> > take me a while. There's a lot of trial and error. Sometimes, MSmoney
> > will
> > only accept certain values for interest, principal and balloon if you
> > push
> > Next four or five times???. I'll get back as soon as I succeed. As it is
> > now, MSmoney assigns the whole payment as a principal, which is what I
> > did
> > not want at all.



  #9  
Old 01-03-2006, 03:22 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

I've never had problems creating a Loan if the values are sane. It it's
creating Loan Payments with no interest on an interest only loan, I'd
suspect that you have not provided sane loan values.

"Eric" <evdslh[at]tiscali.nl> wrote in message
news:43ba9bb6$0$715$5fc3050[at]dreader2.news.tiscali.nl...
- quote -

> Thanks for your quick answers I'll try what you both suggested, but it
will
> take me a while. There's a lot of trial and error. Sometimes, MSmoney will
> only accept certain values for interest, principal and balloon if you push
> Next four or five times???. I'll get back as soon as I succeed. As it is
> now, MSmoney assigns the whole payment as a principal, which is what I did
> not want at all.



  #8  
Old 01-03-2006, 02:43 PM
Eric
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

Thanks for your quick answers I'll try what you both suggested, but it will
take me a while. There's a lot of trial and error. Sometimes, MSmoney will
only accept certain values for interest, principal and balloon if you push
Next four or five times???. I'll get back as soon as I succeed. As it is
now, MSmoney assigns the whole payment as a principal, which is what I did
not want at all.

Thanks and bye,

Eric
"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> schreef in
bericht news:%23um7%23iGEGHA.644[at]TK2MSFTNGP09.phx.gbl...
- quote -

> There is no direct way to transfer the proceeds of a loan somewhere. I
> wish here were. If I were designing Money, there would be. Chris outlines
> the one method known to exist. The FAQ at
> http://umpmfaq.info/faqdb.php?q=86 outlines the way to do this without the
> transfer. It creates an Income entry somewhere that is not tied to the
> loan except in your head and in the transaction memo. As to the loan
> amount and the same amount for the balloon, this makes sense for an
> interest only mortgage. It reflects what's really happening.
> "Eric" <evdslh[at]tiscali.nl> wrote in message
> news:43ba2179$0$709$5fc3050[at]dreader2.news.tiscali.nl...
> > I don't seem to get a refinancing of my mortgage into money 2006. The
> > link
> > you gave puzzles me. All I need is to enter a new loan for my house,
> > which has a variable rate and is an interest
> > only mortgage. When I enter the loanthrough the wizard, I always end up
> > with a loan amount and the same amount for the balloon. This
> > "workaround"is fine, but when I want to transfer then from the new loan
> > to the old loan (through a temp account), I end up wit a loan that has
> > twice (once form the entering and another from the "transfer") the amount
> > I actually owe.
> > > Any thoughts on that?



  #7  
Old 01-03-2006, 01:33 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

"Eric" <evdslh[at]tiscali.nl> wrote in message
news:43ba840b$0$728$5fc3050[at]dreader2.news.tiscali.nl...
- quote -

> Hi Chris,
> Thanks so far,
> I came quite far, but the purpose of this all was to incorporate the loan
> into MSMoney; I mean that MSMoney calculates with it, in the lifetime
> planner etc. As I have it now MSWMoney calculates an amount for interst
> and principal that I cannot change. But I only pay interest. I cannot
> change it in the bills area and I cannot change it in the loan itself. The
> balloon amount is exactly the same as the loan amount, but otherwise it
> won't work. Beacuse there is a balloon amount, MSmoney calculates a
> principal.
> Maybe, if i have put it correctly, you have a clue about what to do then.


Delete any transfer transactions.

Revise the loan and enter 0 in all fields, including balloon, before you
transfer the principal from one loan to another. The exceptions are term and
interest. Leave the interest rate blank and let Money calculate it. Enter
the correct number of payments. Make the effective date the initial date of
the loan. (If it won't let you do that, delete the loan and start over.)
Because principal, payment, and balloon are 0, interest will be zero
initially.

Enter the transfer transaction.

AFTER you do the principal transfer, revise the loan and enter your correct
payment and balloon. Make the effective date one day AFTER the date of the
principal transfer. Money will already know the principal and term. Let it
recalculate the interest.


  #6  
Old 01-03-2006, 01:02 PM
Eric
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

Hi Chris,

Thanks so far,

I came quite far, but the purpose of this all was to incorporate the loan
into MSMoney; I mean that MSMoney calculates with it, in the lifetime
planner etc. As I have it now MSWMoney calculates an amount for interst and
principal that I cannot change. But I only pay interest. I cannot change it
in the bills area and I cannot change it in the loan itself. The balloon
amount is exactly the same as the loan amount, but otherwise it won't work.
Beacuse there is a balloon amount, MSmoney calculates a principal.

Maybe, if i have put it correctly, you have a clue about what to do then.

Thanks,

Eric
"Chris Cowles" <NoSpam[at]For.me> schreef in bericht
news:%23ualtRGEGHA.516[at]TK2MSFTNGP15.phx.gbl...
- quote -

> "Eric" <evdslh[at]tiscali.nl> wrote in message
> news:43ba2179$0$709$5fc3050[at]dreader2.news.tiscali.nl...
> > Hello Dick,
> > > I don't seem to get a refinancing of my mortgage into money 2006. The

> > link
> > you gave puzzles me. All I need is to enter a new loan for my house,
> > which has a variable rate and is an interest
> > only mortgage. When I enter the loanthrough the wizard, I always end up
> > with a loan amount and the same amount for the balloon. This
> > "workaround"is fine, but when I want to transfer then from the new loan
> > to the old loan (through a temp account), I end up wit a loan that has
> > twice (once form the entering and another from the "transfer") the amount
> > I actually owe.

> For the new loan, start with $0 principal, $0 payment, and $0 balloon.
> Enter the interest number of payments specified by the bank. Record the
> principal transfer.
> Go back and modify the loan terms. Enter the effective date of the changes
> as at least 1 calendar day after the date of the transfer. Enter the
> correct payment, number of payments, and balloon, if any. Let Money
> calculate the interest. It will know the principal already, because of the
> transfer transaction.
> This should accomplish what you want. You may have to play with the
> effective dates of the different events, to make it happy.
> --
> Chris Cowles
> Gainesville, FL



  #5  
Old 01-03-2006, 12:22 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

There is no direct way to transfer the proceeds of a loan somewhere. I wish
here were. If I were designing Money, there would be. Chris outlines the one
method known to exist. The FAQ at http://umpmfaq.info/faqdb.php?q=86
outlines the way to do this without the transfer. It creates an Income entry
somewhere that is not tied to the loan except in your head and in the
transaction memo. As to the loan amount and the same amount for the balloon,
this makes sense for an interest only mortgage. It reflects what's really
happening.

"Eric" <evdslh[at]tiscali.nl> wrote in message
news:43ba2179$0$709$5fc3050[at]dreader2.news.tiscali.nl...
- quote -

> I don't seem to get a refinancing of my mortgage into money 2006. The link
> you gave puzzles me. All I need is to enter a new loan for my house, which
> has a variable rate and is an interest
> only mortgage. When I enter the loanthrough the wizard, I always end up
> with a loan amount and the same amount for the balloon. This
> "workaround"is fine, but when I want to transfer then from the new loan to
> the old loan (through a temp account), I end up wit a loan that has twice
> (once form the entering and another from the "transfer") the amount I
> actually owe.
> Any thoughts on that?



  #4  
Old 01-03-2006, 11:51 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

"Eric" <evdslh[at]tiscali.nl> wrote in message
news:43ba2179$0$709$5fc3050[at]dreader2.news.tiscali.nl...
- quote -

> Hello Dick,
> I don't seem to get a refinancing of my mortgage into money 2006. The link
> you gave puzzles me. All I need is to enter a new loan for my house, which
> has a variable rate and is an interest
> only mortgage. When I enter the loanthrough the wizard, I always end up
> with a loan amount and the same amount for the balloon. This
> "workaround"is fine, but when I want to transfer then from the new loan to
> the old loan (through a temp account), I end up wit a loan that has twice
> (once form the entering and another from the "transfer") the amount I
> actually owe.


For the new loan, start with $0 principal, $0 payment, and $0 balloon. Enter
the interest number of payments specified by the bank. Record the principal
transfer.

Go back and modify the loan terms. Enter the effective date of the changes
as at least 1 calendar day after the date of the transfer. Enter the correct
payment, number of payments, and balloon, if any. Let Money calculate the
interest. It will know the principal already, because of the transfer
transaction.

This should accomplish what you want. You may have to play with the
effective dates of the different events, to make it happy.
--
Chris Cowles
Gainesville, FL



  #3  
Old 01-03-2006, 06:02 AM
Eric
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

Hello Dick,

I don't seem to get a refinancing of my mortgage into money 2006. The link
you gave puzzles me. All I need is to enter a new loan for my house, which
has a variable rate and is an interest
only mortgage. When I enter the loanthrough the wizard, I always end up with
a loan amount and the same amount for the balloon. This "workaround"is fine,
but when I want to transfer then from the new loan to the old loan (through
a temp account), I end up wit a loan that has twice (once form the entering
and another from the "transfer") the amount I actually owe.

Any thoughts on that?

Thanks very much,

Eric

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> schreef in
bericht news:etkciNP$FHA.3392[at]TK2MSFTNGP14.phx.gbl...
- quote -

> The only thing that makes it hard is all of the limitations on Principal
> Transfer and Loan Payment. Beyond that, it works pretty much straight off
> the settlement sheet.
> "Steve" <sjcohen730[at]aol.com> wrote in message
> news:1134153288.372401.291290[at]g47g2000cwa.googlegroups.com...
> > Thanks Dick. Seems like the process is even more difficult with Money
> > 2006 than when I did it with Money 1999. Basically, I had to "play"
> > with the payoff loan to get the liability reflected as of December 31.
> > The new loan "starts" January 1st because the first payment is due
> > February 1st. In reality we incorporated the December interest on the
> > old loan and the remainder of the December interest on the new loan
> > into the amortization of the new loan. No cash payout. I worked it out
> > to MY satisfaction, but I'm sure most people doing refinancing who
> > aren't accountants will have lots of trouble doing it right with Money
> > 2006. Steve

>


  #2  
Old 12-09-2005, 06:04 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

The only thing that makes it hard is all of the limitations on Principal
Transfer and Loan Payment. Beyond that, it works pretty much straight off
the settlement sheet.

"Steve" <sjcohen730[at]aol.com> wrote in message
news:1134153288.372401.291290[at]g47g2000cwa.googlegroups.com...
- quote -

> Thanks Dick. Seems like the process is even more difficult with Money
> 2006 than when I did it with Money 1999. Basically, I had to "play"
> with the payoff loan to get the liability reflected as of December 31.
> The new loan "starts" January 1st because the first payment is due
> February 1st. In reality we incorporated the December interest on the
> old loan and the remainder of the December interest on the new loan
> into the amortization of the new loan. No cash payout. I worked it out
> to MY satisfaction, but I'm sure most people doing refinancing who
> aren't accountants will have lots of trouble doing it right with Money
> 2006. Steve



  #1  
Old 12-09-2005, 05:34 PM
Steve
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

Thanks Dick. Seems like the process is even more difficult with Money
2006 than when I did it with Money 1999. Basically, I had to "play"
with the payoff loan to get the liability reflected as of December 31.
The new loan "starts" January 1st because the first payment is due
February 1st. In reality we incorporated the December interest on the
old loan and the remainder of the December interest on the new loan
into the amortization of the new loan. No cash payout. I worked it out
to MY satisfaction, but I'm sure most people doing refinancing who
aren't accountants will have lots of trouble doing it right with Money
2006. Steve

 
Old 12-09-2005, 02:08 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: REFINANCING A MORTGAGE IN MONEY 2006

See http://umpmfaq.info/faqdb.php?q=86. As always, post questions back here.

"Steve" <sjcohen730[at]aol.com> wrote in message
news:1134079453.254168.289110[at]g49g2000cwa.googlegroups.com...
- quote -

> A question I should be able to find an answer to but can't. I've just
> refinanced my mortgage loan and want to enter the transaction into
> Money 2006. I see how I can enter the new loan information, but how do
> I handle the payoff for my old loan? Thanks, Steve



  #-1  
Old 12-08-2005, 09:04 PM
Steve
Guest
 
Posts: n/a
Default REFINANCING A MORTGAGE IN MONEY 2006

A question I should be able to find an answer to but can't. I've just
refinanced my mortgage loan and want to enter the transaction into
Money 2006. I see how I can enter the new loan information, but how do
I handle the payoff for my old loan? Thanks, Steve

 

Tags
2006, money, mortgage, refinancing
Similar Threads
Thread Forum Replies Last Post
Interest-only mortgage in 2006
Jeff.P: I'm having trouble setting up an interest-only mortgage in M2006. have followed the wizard and made the balloon amount the same as th mortgage...
Microsoft Money 3 09-27-2005 03:24 AM
Refinancing an existing mortgage loan with cash-out
Joseph: Is there a way to enter transactions into Money showing refinancing an existing loan (or in my case, a first and second mortgage) into a single...
Microsoft Money 1 01-18-2004 08:37 PM
Mortgage Pay Off via Refinancing
Don Sullivan: I'm using the Money 2004 demo and am trying to close out an existing mortgage after refinancing. Typically, monies from the new mortgage(s) are...
Microsoft Money 1 09-22-2003 12:47 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 04:56 PM.