Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #8  
Old 06-11-2008, 05:37 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Asset account question:

Glad I could help. Thanks for the feedback.

"atlanta678" <atlanta678[at]discussions.microsoft.com> wrote in message
newsC3ACDBC-7E8D-427C-AA66-B15F9AA681EF[at]microsoft.com...
- quote -

> Thanks for posting this suggestion. I was searching the threads for
> just such a solution.


  #7  
Old 06-10-2008, 02:01 PM
atlanta678
Guest
 
Posts: n/a
Default Re: Asset account question:

Dick,

Thanks for posting this suggestion. I was searching the threads for
just such a solution.

"Dick Watson" wrote:

- quote -

> Here's one approach via example.
> Say you purchase the car for $20,000 with an $15,000 loan and an additional
> $1,500 in taxes, $200 in fees, and a $2,000 trade-in and $4,700 cash down.
> Split a $4,700 transaction, in the account you write the check for the down
> payment out of, into parts more or less like this:
> $20,000 Automobile : Payment, memo: buy the '08 MasterCar Blaster
> ($2,000) Automobile : Payment, memo: trade-in the '97 MegaMotors Beater
> $1,500 Taxes : Sales
> ($15,000) Other Income : Loan Proceeds Received, memo: this is from the Loan
> Account "08 Blaster Auto Loan" but Money doesn't provide an easy way to
> transfer those proceeds into this transaction
> $200 Miscellaneous : Service Charges & Fees
> Then you setup the loan account. I'd skip letting it create an Asset
> Account, but there is no One Right Answer.
> So, the net Automobile : Payment is all in this one transaction. When you
> payoff the loan, you transfer principal. This reduces liability but reduces
> cash as well. Net worth change: $0. The loan payments also include the
> interest expense portion.
> "drokkon" <drokkon[at]live.com> wrote in message
> news:B0C7DD39-3D27-4903-8A50-81D6607F5B10[at]microsoft.com...
> > So taking a simple car purchase, you wouldn't recommend an asset account.
> > Fine by me (my net worth is disastrous anyway), but then should I only
> > deal with the loan account and transferring funds to it from my checking
> > (eg - monthly payments)? What exactly do you mean by "expense the car when
> > you buy it?"

  #6  
Old 05-29-2008, 02:01 AM
Mark Fields
Guest
 
Posts: n/a
Default Re: Asset account question:


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:%23aKdTayvIHA.4492[at]TK2MSFTNGP02.phx.gbl...
- quote -

> Here's one approach via example.
> Then you setup the loan account. I'd skip letting it create an Asset
> Account, but there is no One Right Answer.


If you don't skip setting up the asset account, then the Asset Value (on the
day of the sale) is the value of the car that you agreed to pay for it.
Then remember to immediately, on the same date, take a depreciation expense
that is appropriate. This is the expense you will incur. As some would say
"... a new car loses x% of value the moment you drive it off the lot...".

Then at regular intervals of your choice look uo the trade in value of the
car and make an expense entry in your asset account for Auto: Depreciation
to show the declining value of your automobile.

In rare cases, such as if you happen to buy a rare car, and keep it long
enough; or you buy for example an economy car that in the face of rising
gasoline prices has a higher trade in value then you would make the entry as
a credit.

It's a little more work but this will show the effect of buying the car on
your net worth.

Likewise if you buy a used car there is an agreed purchase price and most
likely of you got a good deal you won't incur the large depreciation expense
when you pick up your vehicle.

- quote -

> So, the net Automobile : Payment is all in this one transaction. When you
> payoff the loan, you transfer principal. This reduces liability but
> reduces cash as well. Net worth change: $0. The loan payments also include
> the interest expense portion.


If you go this route (no asset account) when the car is paid off you can
then create an asset account and value the car at the current book value.
In some states this might be useful for determining your personal property
taxes or licensing fees for certain vehicles.


Mark

- quote -

> "drokkon" <drokkon[at]live.com> wrote in message
> news:B0C7DD39-3D27-4903-8A50-81D6607F5B10[at]microsoft.com...
> > So taking a simple car purchase, you wouldn't recommend an asset account.
> > Fine by me (my net worth is disastrous anyway), but then should I only
> > deal with the loan account and transferring funds to it from my checking
> > (eg - monthly payments)? What exactly do you mean by "expense the car
> > when you buy it?"



  #5  
Old 05-26-2008, 12:49 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Asset account question:

Here's one approach via example.

Say you purchase the car for $20,000 with an $15,000 loan and an additional
$1,500 in taxes, $200 in fees, and a $2,000 trade-in and $4,700 cash down.

Split a $4,700 transaction, in the account you write the check for the down
payment out of, into parts more or less like this:

$20,000 Automobile : Payment, memo: buy the '08 MasterCar Blaster
($2,000) Automobile : Payment, memo: trade-in the '97 MegaMotors Beater
$1,500 Taxes : Sales
($15,000) Other Income : Loan Proceeds Received, memo: this is from the Loan
Account "08 Blaster Auto Loan" but Money doesn't provide an easy way to
transfer those proceeds into this transaction
$200 Miscellaneous : Service Charges & Fees

Then you setup the loan account. I'd skip letting it create an Asset
Account, but there is no One Right Answer.

So, the net Automobile : Payment is all in this one transaction. When you
payoff the loan, you transfer principal. This reduces liability but reduces
cash as well. Net worth change: $0. The loan payments also include the
interest expense portion.

"drokkon" <drokkon[at]live.com> wrote in message
news:B0C7DD39-3D27-4903-8A50-81D6607F5B10[at]microsoft.com...
- quote -

> So taking a simple car purchase, you wouldn't recommend an asset account.
> Fine by me (my net worth is disastrous anyway), but then should I only
> deal with the loan account and transferring funds to it from my checking
> (eg - monthly payments)? What exactly do you mean by "expense the car when
> you buy it?"



  #4  
Old 05-26-2008, 05:50 AM
drokkon
Guest
 
Posts: n/a
Default Re: Asset account question:

Thanks guys.

So taking a simple car purchase, you wouldn't recommend an asset account.
Fine by me (my net worth is disastrous anyway), but then should I only deal
with the loan account and transferring funds to it from my checking (eg -
monthly payments)? What exactly do you mean by "expense the car when you buy
it?"

"Scott Tyler" <agent_scotty-at-hotmail-dot-com> wrote in message
news:A556E22B-7F9F-462C-B57F-BE11EA55BE97[at]microsoft.com...
- quote -

> I deal with my car's asset account by checking the value every 3-12
> months, dividing the depreciation by the number of months, and enter
> smaller monthly amounts.
> As this restates my net worth for the prior 2-11 months, it probably
> violates accounting principles, but as I don't own a business or submit
> monthly reports to an accountant or anything like that, I don't worry too
> much about that.
> Other users don't even bother with asset accounts for cars: They just
> expense the car when they buy it, as this saves the effort of 10 years of
> depreciation entries that wipe out most of the original value.
> --
> Scott Tyler
> agent_scotty-at-hotmail-dot-com
> "drokkon" <drokkon[at]live.com> wrote in message
> news:%23PiS4YovIHA.3792[at]TK2MSFTNGP02.phx.gbl...
> > I totally understand that, and I realize it's not a mistake... I'm just
> > wondering if there's some other way I'm supposed to manage asset
> > accounts...
> > > "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in

> > message news:uJ789FmvIHA.2292[at]TK2MSFTNGP05.phx.gbl...
> > > You lost $4k of net worth. The transaction that did it was entered this
> > > month. That's about all Money knows. What else can it say?
> > > > > "drokkon" <drokkon[at]live.com> wrote in message
> > > news:2A11B522-A1CE-4D50-9438-36595ABABEF8[at]microsoft.com...
> > > > My newest question is how to deal with asset accounts. I added my car,
> > > > and added the initial value (price tag). This month, I went to adjust
> > > > the value by looking up my vehicle in the Blue Book. Once I entered the
> > > > newest value, my car devaluing by $4k shows up in ALL of my spending
> > > > charts. Obviously this wasn't an "expenditure," and it happened
> > > > gradually since I bought the car - not all this month!
> > > >
  #3  
Old 05-26-2008, 12:27 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Asset account question:

Whatever works for you is fine. Many of us do not even track the cars as
assets since they depreciate more or less to zero. Seems like more trouble
than it's worth. YMMV. Oh, and if you have a 1955 Mercedes-Benz 300SL
"Gullwing" by all means have an asset account for it.

This is one of many where there is no One Right Answer.

"drokkon" <drokkon[at]live.com> wrote in message
news:%23PiS4YovIHA.3792[at]TK2MSFTNGP02.phx.gbl...
- quote -

> I totally understand that, and I realize it's not a mistake... I'm just
> wondering if there's some other way I'm supposed to manage asset
> accounts...



  #2  
Old 05-25-2008, 10:05 PM
Scott Tyler
Guest
 
Posts: n/a
Default Re: Asset account question:

I deal with my car's asset account by checking the value every 3-12 months,
dividing the depreciation by the number of months, and enter smaller monthly
amounts.

As this restates my net worth for the prior 2-11 months, it probably
violates accounting principles, but as I don't own a business or submit
monthly reports to an accountant or anything like that, I don't worry too
much about that.

Other users don't even bother with asset accounts for cars: They just
expense the car when they buy it, as this saves the effort of 10 years of
depreciation entries that wipe out most of the original value.

--
Scott Tyler
agent_scotty-at-hotmail-dot-com

"drokkon" <drokkon[at]live.com> wrote in message
news:%23PiS4YovIHA.3792[at]TK2MSFTNGP02.phx.gbl...
- quote -

> I totally understand that, and I realize it's not a mistake... I'm just
> wondering if there's some other way I'm supposed to manage asset
> accounts...
> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
> message news:uJ789FmvIHA.2292[at]TK2MSFTNGP05.phx.gbl...
> > You lost $4k of net worth. The transaction that did it was entered this
> > month. That's about all Money knows. What else can it say?
> > > "drokkon" <drokkon[at]live.com> wrote in message

> > news:2A11B522-A1CE-4D50-9438-36595ABABEF8[at]microsoft.com...
> > > My newest question is how to deal with asset accounts. I added my car,
> > > and added the initial value (price tag). This month, I went to adjust
> > > the value by looking up my vehicle in the Blue Book. Once I entered the
> > > newest value, my car devaluing by $4k shows up in ALL of my spending
> > > charts. Obviously this wasn't an "expenditure," and it happened
> > > gradually since I bought the car - not all this month!

> >

  #1  
Old 05-25-2008, 05:41 PM
drokkon
Guest
 
Posts: n/a
Default Re: Asset account question:

I totally understand that, and I realize it's not a mistake... I'm just
wondering if there's some other way I'm supposed to manage asset accounts...

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uJ789FmvIHA.2292[at]TK2MSFTNGP05.phx.gbl...
- quote -

> You lost $4k of net worth. The transaction that did it was entered this
> month. That's about all Money knows. What else can it say?
> "drokkon" <drokkon[at]live.com> wrote in message
> news:2A11B522-A1CE-4D50-9438-36595ABABEF8[at]microsoft.com...
> > My newest question is how to deal with asset accounts. I added my car,
> > and added the initial value (price tag). This month, I went to adjust the
> > value by looking up my vehicle in the Blue Book. Once I entered the
> > newest value, my car devaluing by $4k shows up in ALL of my spending
> > charts. Obviously this wasn't an "expenditure," and it happened gradually
> > since I bought the car - not all this month!

 
Old 05-25-2008, 01:18 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Asset account question:

You lost $4k of net worth. The transaction that did it was entered this
month. That's about all Money knows. What else can it say?

"drokkon" <drokkon[at]live.com> wrote in message
news:2A11B522-A1CE-4D50-9438-36595ABABEF8[at]microsoft.com...
- quote -

> My newest question is how to deal with asset accounts. I added my car, and
> added the initial value (price tag). This month, I went to adjust the
> value by looking up my vehicle in the Blue Book. Once I entered the newest
> value, my car devaluing by $4k shows up in ALL of my spending charts.
> Obviously this wasn't an "expenditure," and it happened gradually since I
> bought the car - not all this month!



  #-1  
Old 05-25-2008, 07:23 AM
drokkon
Guest
 
Posts: n/a
Default Asset account question:

My newest question is how to deal with asset accounts. I added my car, and
added the initial value (price tag). This month, I went to adjust the value
by looking up my vehicle in the Blue Book. Once I entered the newest value,
my car devaluing by $4k shows up in ALL of my spending charts. Obviously
this wasn't an "expenditure," and it happened gradually since I bought the
car - not all this month!

 

Tags
account, asset, question
Similar Threads
Thread Forum Replies Last Post
Pls help Asset Allocation Question
avacohen100@yahoo.com: My brother is 51 years and his wife is 46 yrs old. He is thinking of buying a home. He is not sure of how much of his total wealth / net worth...
Microsoft Money 1 10-14-2006 01:57 AM
How to set up a loan account from an asset account already created
Fabio: I need to set up the opening balance for a mortgage from an asset already created. Is it a way to do it? Rigth now, I just get a link to a Loan...
Microsoft Money 3 04-17-2006 06:38 AM
Asset Allocation question
John DeMastri: I spent time putting in the detailed percentages of holdings (small / mid / large / cash / bonds / other) into all of my mutual funds, then tried to...
Microsoft Money 2 10-18-2005 06:33 PM
Asset accounts for cars and depreciation question
Richard Forester: I have an asset account for my car so I can weigh it against money I borrowed to finance it. Over time the car will, of course, depreciate and I...
Microsoft Money 21 04-25-2005 02:26 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 03:13 PM.