Go Back   CDN Business Directory > Main Category > Financial Planning

 
 
Thread Tools Display Modes
 
Old 05-13-2004, 09:27 PM
Jim
Guest
 
Posts: n/a
Default Re: Tax Model Help

Chemmy <chemmy[at]nonono.us> wrote in message news:<40A232EA.5E2[at]nonono.us> ...
- quote -

> I'm trying to build an Excel model for my future finances, so I can run
> through some different scenarios. For example, look at the effects on
> my long term situation if I put more money into the house vs. putting
> more money into retirement.
> What has me stumped is what I should try to plug in for wrinkles in the
> tax code. The mortgage interest deduction is pretty straightforward and
> easy to model. But I'm starting to wonder about the proliferation of
> tax-exemptions, tax-deferred accounts, tax credits, deductions, etc. for
> things like child care, commuting, health care, etc.
> Obviously, these things are supposed to act as incentives to do things
> that the government wants me to do, but I'm confused how to create any
> kind of reasonable way of telling what the costs and benefits are.
> One place it gets tricky is that you can end up diverting a substantial
> amount of money to these accounts which are then pulled out of your
> general pool of cash, and your budgeting gets very complicated. For
> example, I can assume $1,200 a year goes into my pre-tax commuter
> account, but my actual commuting costs are more than that, so I have to
> be careful to keep two figures for commuting (amount deducted from my
> paycheck, additional costs above the limit for the account) and then
> reconcile with the tax benefits.
> Would it make more sense to build the model on the assumption that I'm
> not doing any of these things, and just plug in a set % for income tax
> every year going forward into the future?
> I'm afraid that the steady increase in deductions, accounts, credits,
> etc. has made the tax code far too complex to help make any real life
> longterm plans. Add in the uncertainty that these provisions will be
> around and unchanged for any long period in the future, and it's unclear
> to me how to do any planning without throwing out the effects of these
> pieces and just model on a few different percentages going to taxes.


My personal opinion is I can give someone a detailed financial picture
of what my next 12-24 months will look like. Anything beyond 18+
months is a SWAG.

I save for retirement, which is 30+ years away, save for a house which
may or may not be purchased in the next year and spend as little as
possible, and buy life insturance to cover some of the un expected,
but overall detailed planning is quite difficult, IMO.

If I need help with the 2-5 year planning part, I would be consulting
a professional.

  #-1  
Old 05-12-2004, 10:47 PM
Chemmy
Guest
 
Posts: n/a
Default Tax Model Help

I'm trying to build an Excel model for my future finances, so I can run
through some different scenarios. For example, look at the effects on
my long term situation if I put more money into the house vs. putting
more money into retirement.

What has me stumped is what I should try to plug in for wrinkles in the
tax code. The mortgage interest deduction is pretty straightforward and
easy to model. But I'm starting to wonder about the proliferation of
tax-exemptions, tax-deferred accounts, tax credits, deductions, etc. for
things like child care, commuting, health care, etc.

Obviously, these things are supposed to act as incentives to do things
that the government wants me to do, but I'm confused how to create any
kind of reasonable way of telling what the costs and benefits are.

One place it gets tricky is that you can end up diverting a substantial
amount of money to these accounts which are then pulled out of your
general pool of cash, and your budgeting gets very complicated. For
example, I can assume $1,200 a year goes into my pre-tax commuter
account, but my actual commuting costs are more than that, so I have to
be careful to keep two figures for commuting (amount deducted from my
paycheck, additional costs above the limit for the account) and then
reconcile with the tax benefits.

Would it make more sense to build the model on the assumption that I'm
not doing any of these things, and just plug in a set % for income tax
every year going forward into the future?

I'm afraid that the steady increase in deductions, accounts, credits,
etc. has made the tax code far too complex to help make any real life
longterm plans. Add in the uncertainty that these provisions will be
around and unchanged for any long period in the future, and it's unclear
to me how to do any planning without throwing out the effects of these
pieces and just model on a few different percentages going to taxes.

 

Tags
model, tax
Similar Threads
Thread Forum Replies Last Post
How do I model personal loans to my business
Lu: hi, I have a question about how to model a personal loan to my own business? The situation is this. I started my own business and I am basically...
Microsoft Money 9 07-03-2008 11:36 PM
model for new tax form?
rick++: I finally took a look at the 1040EZ-T and it is only one line long! (That is the telephone tax rebate for people with no other taxable income.) ...
Taxes 3 12-06-2006 06:04 AM
How to set up model portfolio?
Dan: Hi- I am trying to set up an investment portfolio to track what *would* have happened if I bought those stocks. I tried creating a watch...
Microsoft Money 2 12-26-2004 05:05 PM
Discounted Cash Flow Model Question
Nirvana: What would you rather have: A bond which pays you 2% for the next 5 years, or a stock which trades at $44.40 and PE = 70. It's earnings growth...
Financial Planning 3 09-03-2003 05:30 PM
Object Model
Cathy: I would like to build an application that pulls data out of Money and combines it with data from Outlook. Does MS Money support a public object...
Microsoft Money 1 08-06-2003 12:21 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 11:23 AM.