| | |||
| |||
| 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
My personal opinion is I can give someone a detailed financial picture> 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. 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
| |||
| |||
| 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 | |
| |