The Money Mustache Community
Learning, Sharing, and Teaching => Case Studies => Topic started by: swick on October 03, 2013, 12:37:02 PM
-
Want specific info related to your situation?
Please use the following guidelines/format as applicable to your situation to ensure we have ALL the information we need to help.
Topic Title: Reader Case Study - your question here
Life Situation: IRS filing status, number & ages of dependents, and anything else (state/country of residence, age, etc.) you are comfortable sharing.
Gross Salary/Wages: Before any deductions
Individual amounts of each Pre-tax deductions 401k, HSA, FSA, IRA, insurance, etc. - whatever you have
Other Ordinary Income: Provide sources and any relevant details, the more the better
Qualified Dividends & Long Term Capital Gains: If these are significant for you
Rental Income, Actual Expenses, and Depreciation: If these are significant for you
Adjusted Gross Income: This should equal the additions and subtractions above.
Taxes: Federal, state/local, and FICA. These should be consistent with your AGI and Life Situation. For non-U.S. posters, we’ll have to take your word for these.
Current expenses: Provide breakdown and relevant details. Aim to have “Miscellaneous” somewhere ~2.5%. Much lower and you may be providing too much detail, much higher and you have an obvious problem of not understanding your spending.
For mortgage payments, separate the P&I (which stop when the mortgage is paid) from the T&I (and anything else) which continue as long as you own the property.
Expected ER expenses: (optional, if relevant)
Assets: Amount & description - include current asset allocation plan if you have one
Definition of assets: Any item of economic value owned by an individual or corporation, especially that which could be converted to cash. Examples are cash, securities, accounts receivable, inventory, office equipment, real estate, a car, and other property.
Liabilities: Description, original loan amount, rate, original length, and monthly payment (which should be consistent with a spreadsheet PMT calculation). Add current balance and time remaining if close to final payment.
Specific Question(s): Providing a detailed breakdown is important, so is asking for specific information so we know what kind of help/advice you are looking for.
The Case Study Spreadsheet (see Case Study Spreadsheet updates (https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/) for a link to the latest version) can be downloaded and used to help organize your case study posting.
It includes income, expense, and investment categories that will cover most situations. For "not too complex" cases it will calculate IRS, SS, and Medicare taxes exactly, and state taxes approximately, helping one evaluate the after-tax effects of 401k, HSA, etc. There is also a simplified section to evaluate "how long to FI?".
See this post (http://forum.mrmoneymustache.com/ask-a-mustachian/how-to-write-a-%27case-study%27-topic/msg274228/#msg274228) and the spreadsheet itself for more details.
However you format your study, don't forget to subtotal each category and total up all major categories (income, expenses, assets, liabilities), rather than expecting the readers to add up your food + cable bill + etc. etc.
WARNING: If you have a "Your hair is on Fire!" debt emergency you will get face punches if your spending categories include line items such as a "new car loan" or spending that should only be part of your life if you are debt free such as a "gym memberships" or "manicures".
A few notes on a successful "Reader Case Study" topic:
If you are asked for additional info or more detail, please use the edit button to add the information to your original post - this will help keep all your info easy to access for new contributors.
Please make all responses and additions to your original post in the same conversation rather than creating a new topic. It helps everyone if the history of the discussion is available in one place.
Posters put a great deal of time and thought into their replies. As the original poster, please respond in some way to keep the conversation going and let us know that you are benefiting from the discussion and appreciate contributions.
Any questions? Please use this topic to ask for clarification if you are not sure about how to create a new "Reader Case Study" topic.
-
Thanks this is helpful! I have a case study running since yesterday titled 5 o'clock shadow. I will try to jazz it up using this template. Our hair is on fire and punching has commenced. The input has been really helpful. I am hoping to carry the energy forward to taking action. This forum has given me confidence to believe my dream of become financially independent is possible.
-
Thanks this is helpful! I have a case study running since yesterday titled 5 o'clock shadow. I will try to jazz it up using this template. Our hair is on fire and punching has commenced. The input has been really helpful. I am hoping to carry the energy forward to taking action. This forum has given me confidence to believe my dream of become financially independent is possible.
Great to hear! Thank you for your feedback, I will take a look at your case study:)
-
Just modified mine, thanks for the tips! I wasn't sure what to include, but this was helpful.
-
Hi Swick. I just wanted to leave a quick note here to say thanks for these pointers, they're very helpful. :-)
-
what's the policy of carefully 'bumping' your topic if you don't get anything the first day or so? frowned upon?
-
what's the policy of carefully 'bumping' your topic if you don't get anything the first day or so? frowned upon?
No hard and fast rule. Don't be annoying (i.e. spam). Wait at least a day, then do a single one. You may also want to consider editing at that time for either brevity, or clarity, or to add more info, depending on which your post needs.
-
Very helpful, I added some content to my case study from this.
Thanks!
-
I added a line about subtotaling/totaling up the categories, as I keep seeing case studies that have 100 line items and I have no idea how much the totals are and my brain goes cross-eyed. :)
-
good call, thanks arebelspy:)
-
What does the "ER" in expected ER expenses refer to?
Thanks
-
What does the "ER" in expected ER expenses refer to?
Thanks
Early retirement.
-
OMG ... I have been trying to post a case study but there is no New topic button? Has it been closed :(
-
OMG ... I have been trying to post a case study but there is no New topic button? Has it been closed :(
Are you signed in when you are looking to post? If you logged in as a "guest" the option doesn't show up. The option should show up at the top of the "category" page
-
Edit: superseded by spreadsheet linked below.
-
The problem with that, MDM, is people track different things.
I mean, holy shit, look how many categories you posted there. 66?!
I have less than 10 personally. HerpD on these forums has TWO (Rent and Everything Else).
People will post their budget, with the things they track and spend money on, however they categorize it. There's no need for us to tell them how to categorize and organize their spending/budget.
I'll leave your post and people can use that if they want. Seems good enough.
-
A big thank you for this, from a total noob. I just posted my case study, and I am now wincing in anticipation of many face punches. My most recent excuse for everything 'but I'm pregnant!' doesn't work well in the Interwebz.
-
The latest version of the spreadsheet linked here: Case Study Spreadsheet updates (https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/) can be downloaded and used to help organize a case study posting. It includes income, expense, and investment categories usually applicable to case studies.
Case study posts should specify gross income, then list amounts for each pre-tax deduction.
For "not too complex" cases the spreadsheet will calculate IRS, SS, and Medicare taxes closely, and state taxes approximately, helping one evaluate the after-tax effects of 401k, HSA, etc. It includes various credit calculations, including EIC, Child, Foreign income exclusion, and Saver's.
Note that these are the actual taxes you should use for your cash flow analysis, and may differ from the amounts you are withholding from each paycheck.
There is also a simplified section to evaluate "how long to FI?".
There are eleven tabs (aka sheets) in this workbook
Instructions - What you are reading now
Calculations - The main tab. "Current cash flow" and "time to FI" calculations, including many common federal tax credits and limits.
Posting - Formatted for use in Simple Machines forum posts
Investment Order - Guidelines for which accounts should get your money in what order.
Tax Rates - Calculation and graph for marginal and overall tax rates
Form6251 - Alternative Minimum Tax calculation
401k vs Taxable - Comparison of returns between a 401k with high fees vs. a taxable account with low fees
SocialSecurity - Estimates an individual's social security benefits, given historical and projected earnings
HDHP Analysis - Compares out-of-pocket costs vs. gross medical expenses for two insurance options
Misc. calcs:
- Solve for any of the five (FV, n, PMT, rate, PV) main financial function variables.
- Investing vs. mortgage payoff calculation.
- Quick calculation of "Time to FI"
- One way to evaluate "pension now" vs. "pension later"
- Comparison of immediate Lump Sum pension vs. immediate annual payments (including COLA option)
- Solve FV(i,n,P) * i = a * P for n
- Growth in a taxable account, with annual tax on dividends and LTCG tax on final withdrawal
- Breakeven rate for deciding Roth vs. Traditional.
- Fixed Rate vs. Adjustable Rate (AR) Loan: Savings (or Loss) from using AR, depending on initial AR value and later increases.
Chart of some basic investing terms. Target audience: someone who asks "is that a Roth or a Vanguard?". We were all there once….
You may attach a copy to your study or not - that is up to you. If you don't already have a similar tool, merely using it to help organize your information should be helpful.
Although this has been used to good advantage for a wide variety of case studies, it is not a commercial product and does not cover all possible tax and life situations. I highly recommend using real commercial software (i.e., not this tool) when it comes to making real changes to your own finances (e.g., YNAB, Mint, Quicken, etc.), taxes (e.g., TaxAct, TurboTax, etc.) and FI planning (e.g. http://www.esplanner.com/, etc.).
If there are any blatant errors, please PM me. Or post them for all to see: won't be the first nor last spreadsheet error I'll ever make. Improvement requests will also be seriously considered, and several have already been implemented. Of course, "this is not a commercial product" means some things will forever be out of scope but if the improvement would help a wide audience....
Assuming you do find it useful for documenting a case study, there are (at least) three ways to present it back to the community for comments:
1. Perhaps the simplest is to attach a copy using the "Attachments and other options" located below the post window
2. You could save to a Google Drive location of your own and post the link.
3. Copy from Excel & paste into the post. If you go this route, use any of:
a. Column G of the "Posting" tab. This is based on the idea given in http://forum.mrmoneymustache.com/journals/dandarc's-journal/msg367990/#msg367990. Nice idea from dandarc - any implementation errors are mine.
b. http://forum.mrmoneymustache.com/forum-information-faqs/how-to-formatting-a-table (http://forum.mrmoneymustache.com/forum-information-faqs/how-to-formatting-a-table) or
c. http://forum.mrmoneymustache.com/forum-information-faqs/how-to-simple-step-by-step-guide-for-posting-formatted-table (http://forum.mrmoneymustache.com/forum-information-faqs/how-to-simple-step-by-step-guide-for-posting-formatted-table)
so your table will be both easy to read and easy to import back into a spreadsheet.
-
In general, they need to be shorter. Have a catchy title to get people to read (and hopefully respond). But, when I see a post that takes more than a screen, I just don't have time to read it.
Keep Case Study requests short.
-
Just modified my recent post to better fit these guidelines. Thanks!
-
I have something that I wanted as a case study, but I didn't title it that, and I've since added a few other threads with more information about my situation. Could you look over my threads and make a recommendation? Do I need to try to condense all of these threads into one?
-
Where are the reader case studies going? Stupid question but what category? Journals? Ask a Mustachian?
-
Where are the reader case studies going? Stupid question but what category? Journals? Ask a Mustachian?
Ask a Mustachian is the best place. As the description for this board on the forum home page reads, "Do you need advice? Do you like helping others? Post your financial or life dilemma here and see if MMM or one of the other readers can help!"
-
Where are the reader case studies going? Stupid question but what category? Journals? Ask a Mustachian?
Depends on the purpose/topic.
A case study on sell vs. rent the house you're moving out of would go in real estate. A long term improvement over time might go in journals. A generic "help trim my budget" may go in Ask a Mustachian.
-
Hey, to whomever made that spreadsheet linked above- wow, wow, and THANKS!
It has proven SUPER useful for me and DW to really start to plan AHEAD of time (how novel!) to keep ourselves in a lower marginal tax bracket for 2015.
Anyway- you rock.
-
Is it worth putting MDM's spreadsheet in a sticky in the new tax forum?
-
How should a bonus be included? As an increase averaged out over the whole year?
-
How should a bonus be included? As an increase averaged out over the whole year?
Yes, adding the monthly average to your normal monthly wages is easiest.
-
I am almost done with my budget just wanted a little clarity.
My credit card payments are high right now as I pay them down, but it is causing my post retirement taxable savings to be negative. I know when the credit cards can be paid off and when they go off of zero balance. So I can provide that for context, but not sure how to adjust for that negative taxable savings rate.
Also some of the stuff currently isn't sustainable, like I am living in a room in a condo for $450 a month with no utilities and only paying for cable. I know I can't do this forever, I want a house and wife and kids in the future. So I want to make sure I factor that into FIRE planning.
I am also planning on going back to school for an MBA, which will increase my salary. Is the overarching idea of this spreadsheet to show a snapshot of the current state or a projected future state or a mix of the two?
I appreciate this community you guys are great and I thank everyone for putting the spreadsheet together. Can't wait to finish and hear the recommendations!
Let me know if I should post what I currently have to answer any questions. Thanks
-
Is the overarching idea of this spreadsheet to show a snapshot of the current state or a projected future state or a mix of the two?
A mix, weighted more toward the current state.
Just explain things that don't "fit": folks will likely understand and all should be well. The spreadsheet is a means, not an end.
-
Great spreadsheet. Question though, I'm planning to do some serious housing downsizing after reaching FI, enough to lower RE expenses by $20-25k/yr. When I put that into Change in spending after RE, the resulting "Stash needed for retirement @4% SWR" comes out negative. Is this because only Non-loan, non-work expenses are counted after retirement? I.e. is this spreadsheet assuming your mortgage will go away? I don't see how that can be the case...
-
Great spreadsheet. Question though, I'm planning to do some serious housing downsizing after reaching FI, enough to lower RE expenses by $20-25k/yr. When I put that into Change in spending after RE, the resulting "Stash needed for retirement @4% SWR" comes out negative. Is this because only Non-loan, non-work expenses are counted after retirement? I.e. is this spreadsheet assuming your mortgage will go away? I don't see how that can be the case...
The spreadsheet follows the "invest instead of paying off your mortgage" strategy by calculating the stash needed as ("Expenses in retirement" minus "Guaranteed income in retirement") divided by "Safe Withdrawal Rate" plus "Remaining loan principal". The most recent version is 5.12 (cell Q1 on the Instructions tab).
-
Is there a discussion on the invest instead of mortgage payoff strategy for reference? All I'm trying to do is account for selling my place and downsize upon FIRE, hopefully rendering the issue moot, which is why I was trying to use a reduced RE expenses. Is there any way to do that with this spreadsheet?
-
Is there a discussion on the invest instead of mortgage payoff strategy for reference?
Many. Start with http://forum.mrmoneymustache.com/forum-information-faqs/frequently-asked-questions/ and scroll down to "Investing".
All I'm trying to do is account for selling my place and downsize upon FIRE, hopefully rendering the issue moot, which is why I was trying to use a reduced RE expenses. Is there any way to do that with this spreadsheet?
Probably. E.g., if you could sell for X, your current mortgage principal is P, and buy a new place with cash for Y, you could add (X - P - Y) to your Taxable Current Savings and put the expected time to do this in cell H49. Other "if this then that" things are doable if that example doesn't fit. At some point, if the complexity warrants, you could use www.cfiresim.com or other time-dependent planner. You could start a thread with your case study with more details if needed.
-
wow props on the spreadsheet so helpful
-
I'm having trouble accessing the spreadsheet. It says Google Drive unavailable. Is it available anywhere else?
-
I'm having trouble accessing the spreadsheet. It says Google Drive unavailable. Is it available anywhere else?
I just tried and it worked. Could you try again? If it doesn't work, what hardware and browser are you using?
-
I'm at work so that may be the issue.
-
I've been mucking about with the very helpful spreadsheet and a couple of things aren't clear to me...can someone help out?
1. The extra income after RE...We both have public employee pensions, but we can't access them for another 20 years (@ age 65) and we are hoping to retire in 5-10. Do the calculations factor in this time lag, or assume that the "extra income" is available immediately? Or maybe it doesn't matter?
2. My employer contributes ~$400/mo to my pension. Do i put this in the employer match section of the income entries? I never actually see this money except in my pension account, so is this throwing off our "available to invest" numbers?
Thanks in advance!
-
1. The extra income after RE...We both have public employee pensions, but we can't access them for another 20 years (@ age 65) and we are hoping to retire in 5-10. Do the calculations factor in this time lag, or assume that the "extra income" is available immediately? Or maybe it doesn't matter?
The calculation assumes the extra income is available immediately and forever upon retirement. For time-dependent cash flows, look at www.i-orp.com, www.cfiresim.com, or others mentioned in https://www.bogleheads.org/forum/viewtopic.php?t=115839#p1686175 and links therein.
2. My employer contributes ~$400/mo to my pension. Do i put this in the employer match section of the income entries? I never actually see this money except in my pension account, so is this throwing off our "available to invest" numbers?
The employer match entry feeds into your 401k balance. There is no standard pension calculation so all the cash flow spreadsheet does is accept whatever "extra income after RE" you enter.
Any other questions - just ask.
-
MDM...I only just today found your terrific spreadsheet. This obviously took a substantial amount of skill and effort to put together. Thanks for sharing.
A question: I noticed that the SS tax cell ("B42") seems to be "commented out" (it has a *0 at the end of the formula). Is there a reason for this?
I am looking at version 7.05.
-
MDM...I only just today found your terrific spreadsheet. This obviously took a substantial amount of skill and effort to put together. Thanks for sharing.
A question: I noticed that the SS tax cell ("B42") seems to be "commented out" (it has a *0 at the end of the formula). Is there a reason for this?
I am looking at version 7.05.
Well, shoot, that's not right. Must have been left over from looking at someone who didn't pay SS.... Version 7.06 now online. Thanks for the beta testing!
-
MDM...I only just today found your terrific spreadsheet. This obviously took a substantial amount of skill and effort to put together. Thanks for sharing.
A question: I noticed that the SS tax cell ("B42") seems to be "commented out" (it has a *0 at the end of the formula). Is there a reason for this?
I am looking at version 7.05.
Well, shoot, that's not right. Must have been left over from looking at someone who didn't pay SS.... Version 7.06 now online. Thanks for the beta testing!
Whew. Glad I'm not going crazy! Thanks again MDM.
-
I thought I would just throw in this question since it seems slightly on the topic. If I'm not planning to stay long-term with my current employer, should I invest in the company's 401K plan or not? My employer offered me the option of opening a 401K or stocks and bonds account with them when I signed on as a full-time employee, but I didn't sign up, because I had no idea what I was doing. Could someone explain this to me?
-
I thought I would just throw in this question since it seems slightly on the topic. If I'm not planning to stay long-term with my current employer, should I invest in the company's 401K plan or not? My employer offered me the option of opening a 401K or stocks and bonds account with them when I signed on as a full-time employee, but I didn't sign up, because I had no idea what I was doing. Could someone explain this to me?
Probably better to start your own case study thread or a thread in "Investor Alley" for this question. Not trying to duck your question - just trying to keep this thread short.
-
I just want to add one more face punch on the Jeep. I know you say you want to keep it for 20+ years but I will say that is also quite a horrible option because you have to fuel that bastard for all those years. My educated guess is that beast will take about twice as much gas as a fuel efficient car. It costs me about 1500 in gas a year for a 15km commute to work (I drive a 4cyl honda accord (not that fuel efficient). My guess is your cost in gas will be closer to 2500-3000. So lets say 1000 dollar difference. That is at least 20000 dollars lost just in gas base cost. If you invested that money each year you will have 35 grand at only 5% growth. That alone would pay for the car in full.
The warranty is absolute crap with a 500 deductible. Yes it is possible for some catastrophic failure of a computer or something but most computer fails are usually only a few hundred dollar fix for a sensor and such. Second, they will fight you tooth and nail if something nasty happens and blame you for maintenance or some other crap. Most warranties do not allow you to do your own oil changes and will not be covered. Warranties make the company money using your own irrational fear of failure. They win and you will lose.
Sorry for the solid face punch but that Jeep needs to kiss the curb.
-
I just want to add one more face punch on the Jeep.
Jeep?
Wrong thread?
-
I've been playing around with the case study spreadsheet and have noticed that the income amount used for the saver's credit in the spreadsheet is the "Total Income" (cell G10). Shouldn't it be AGI (cell G17)? The official IRS form seems to use AGI directly.
-
I've been playing around with the case study spreadsheet and have noticed that the income amount used for the saver's credit in the spreadsheet is the "Total Income" (cell G10). Shouldn't it be AGI (cell G17)? The official IRS form seems to use AGI directly.
Good question. I remember having a reason at some point, but can't recall what it was. Whatever it was doesn't seem to apply anymore. Changed to use "AGI + any foreign income exclusion amount." Thanks - update online.
-
Cannot access the spreadsheet. Can you re-post it? The link just takes me to my Google Drive.
-
Cannot access the spreadsheet. Can you re-post it? The link just takes me to my Google Drive.
Works for me...?
Upthread someone speculated that a work firewall might cause access problems...?
-
Cannot access the spreadsheet. Can you re-post it? The link just takes me to my Google Drive.
Works for me...?
Upthread someone speculated that a work firewall might cause access problems...?
That was me. I can't access it at work. It says Google Drive is unavailable or something like that. I just tried on my phone and was able to access it there.
-
Cannot access the spreadsheet. Can you re-post it? The link just takes me to my Google Drive.
Works for me...?
Upthread someone speculated that a work firewall might cause access problems...?
That was me. I can't access it at work. It says Google Drive is unavailable or something like that. I just tried on my phone and was able to access it there.
Alot of IT at work block google drive and google docs/sheets to help protect IP :)
I use tor at work to bypass all that crap
-
Thanks to those who put this spreadsheet together!
A beginner question: I'm trying to use this spreadsheet to estimate my net positive cash flow each month. Would that be line 127 ("available for taxable investment") or line 140 ("after-tax investable")? What's the difference between those two items?
Thanks again!
-
I'm trying to use this spreadsheet to estimate my net positive cash flow each month. Would that be line 127 ("available for taxable investment") or line 140 ("after-tax investable")? What's the difference between those two items?
They should be the same number, reached by different groupings of income and expenses. In the current version they may differ by the pre-tax commuter amount, but that has been fixed for the next update.
-
Thanks very much for the reply -- the numbers do indeed differ by the pre-tax commuter amount.
So thinking in terms of how much "extra" money you have available each month, the final number is ultimately somewhere in between those 2 numbers? The commuter money is actually being spent, but you're getting an x% discount on the spending, applied later (with x = whatever your total tax percentage is)? Is that right?
Thanks!
-
So thinking in terms of how much "extra" money you have available each month, the final number is ultimately somewhere in between those 2 numbers?
If you edit cell B137 to remove "+B9" and then enter your actual commuter expense (which may or may not equal your pre-tax amount) in cell B82 or B95, etc., that should provide correct numbers.
-
Thanks MDM. I was actually using the "pre-tax commuter" amount as the place to enter my business deductions (I'm self employed) - is there a better cell to do that in?
Thanks again for your help, if this is getting too specific for a general thread, I can message you instead..
-
Thanks MDM. I was actually using the "pre-tax commuter" amount as the place to enter my business deductions (I'm self employed) - is there a better cell to do that in?
Thanks again for your help, if this is getting too specific for a general thread, I can message you instead..
Seems generic enough. Cell B24 is for net business income. If you want to do a more detailed calculation in the spreadsheet itself, you could unprotect the 'Calculations' sheet, do your business income and expenses calculations in some currently-blank cells (e.g., cols A-M, row 220 and below), and set B24 equal to the result. See www.excel1040.com for what may be the most detailed federal income tax spreadsheet available if you want some ideas....
-
Yes, Thanks RetiredAt63, I'll update instructions.
-
Thanks.
-
Hello,
Just downloaded the cash flow spread sheet and started to fill it out. I just started a new job and don't contribute to Social Security because of CalPERS. Is there a way to disable that cell on the Calculation Tab?
-
Just downloaded the cash flow spread sheet and started to fill it out. I just started a new job and don't contribute to Social Security because of CalPERS. Is there a way to disable that cell on the Calculation Tab?
Yes.
Unprotect the sheet, then edit or delete the formula in cell B43. E.g., change 0.062 to 0.
-
Hey All,
Working on writing up my case study and I'm not sure how to handle a few situations. I recently started working for a public agency where I have access to a CalPERS pension, a 457b and the Public Service Student Loan Forgiveness Program(PSLF) and REPAYE. I've got private and Federal student loans. I've got about $44k in student loans that are eligible for PSLF at an avg rate of 4.8%. Since I had very low income last year due to being in school, my current payments for the next year or so are $0, thanks to REPAY. Using the repayment calculator on Studentloans.gov I get the estimates below, which assumes a 5% income growth annually:
First Monthly Payment
$224
Last Monthly Payment
$395
Total Amount Paid
$36,457
Public Service Loan Forgiveness
$26,805
Repayment Period
120 months
SO my question is how to account for the effective cost of this loan in the Case Study Cash FLow to FI spreadsheet that folks use here? Should I just take the actual amount paid/ 120 payments back out the interest rate? Or use an interest rate of 0%? I want to try and make the FI projection as accurate as possible. I've got some other questions about how to account for the CalPERS, but that can wait for another post.
Thanks
-
SO my question is how to account for the effective cost of this loan in the Case Study Cash FLow to FI spreadsheet that folks use here? Should I just take the actual amount paid/ 120 payments back out the interest rate? Or use an interest rate of 0%? I want to try and make the FI projection as accurate as possible. I've got some other questions about how to account for the CalPERS, but that can wait for another post.
Definitely not an interest rate of 0%.
Unless you'd like to modify the spreadsheet formulas - always possible! :) - you'll have a tradeoff between the accuracy of the SL interest deduction vs. the time to FI calculation.
Realistically, in most cases your SL repayment accuracy will be well within the likely error estimating future investment returns, expenses, and income, so don't sweat this too much. Doing "actual amount paid/ 120 payments [and] back out the interest rate" seems reasonable.
Also see Panicked Borrowers, and the Education Department’s Unsettling Silence - The New York Times (https://www.nytimes.com/2017/04/07/your-money/student-loans/panicked-borrowers-and-the-education-departments-unsettling-silence.html?_r=0) and consider simply repaying the loans. Ten years is a long time, and you might find a great opportunity that would be outside the PSLF program during that time....
-
This is a great tool and I really appreciate the work and time that went into it (and then the answering of all the questions!). I am trying to figure out how to get my state taxes into the calculations correctly; currently it's showing zero. The instructions page seems to refer me to M30-31 on the calculations tab but that seems to connect to everything else so don't want to play with it blindly. Is there a place to put in my state that I'm missing?
Edit: (Found it - it's H-35 if you're following along at home!)
Edit: holy heck I spend a ton of money.
-
This is a great tool and I really appreciate the work and time that went into it (and then the answering of all the questions!). I am trying to figure out how to get my state taxes into the calculations correctly; currently it's showing zero. The instructions page seems to refer me to M30-31 on the calculations tab but that seems to connect to everything else so don't want to play with it blindly. Is there a place to put in my state that I'm missing?
(Found it - it's H-35 if you're following along at home!)
Yes, the instructions should say:
- State+local taxes are estimated at some % of "State Taxable".
- Here, "State Taxable" = Federal AGI - Federal Exemptions. Note: no deductions.
- You can change the % in cell H35. If you want, you can add a formula for your state in cell G35.
They will when the next version is loaded. Meanwhile, I'll have a conversation with the quality control department....
-
I finally started using the case study sheet, and I've run into some things I was confused on.
Under Mortgage do I put the total I pay there or just principle OR principle and Interest?
I see a section for property tax, and for house insurance, but is the mortgage insurance part for PMI?
Since I'm confused on that part I'm also not seeing where to find deductible Mortgage Interest in the tax section.
And lastly, that I can think of at the moment, Where is the compare to AMT part? I can't for the life of me spot it, but maybe I need to use the search tool.
-
I finally started using the case study sheet, and I've run into some things I was confused on.
Under Mortgage do I put the total I pay there or just principle OR principle and Interest?
You put the mortgage inputs - amount financed (cell E57), length of loan (F57), and interest rate (I57) - and the spreadsheet calculates the monthly payment (that includes both principle and interest). If you want to estimate "time to FI" or refine the mortgage interest estimate then you can input the current principal balance (G57) and the spreadsheet will calculate years remaining on the mortgage.
I see a section for property tax, and for house insurance, but is the mortgage insurance part for PMI?
Yes.
Since I'm confused on that part I'm also not seeing where to find deductible Mortgage Interest in the tax section.
It is estimated in cell G34 based on entries in G57 and I57.
And lastly, that I can think of at the moment, Where is the compare to AMT part? I can't for the life of me spot it, but maybe I need to use the search tool.
See the 'Form6251' tab and compare to the IRS 2016 Form 6251 - f6251.pdf (https://www.irs.gov/pub/irs-pdf/f6251.pdf).
Good questions! Keep 'em coming as needed.
-
Thanks for the great spreadsheet, MDM!
I have one question, though - does the FI calculator at the bottom of the Calculations sheet take into account the growth of qualified dividends (B26) over time? If not, how can I take into account the compounding of dividend reinvesting while adjusting the increased taxation?
-
Thanks for the great spreadsheet, MDM!
I have one question, though - does the FI calculator at the bottom of the Calculations sheet take into account the growth of qualified dividends (B26) over time?
Somewhat. The projected taxable account balance at retirement (cell B160) does include compounded growth. It doesn't include year-to-year changes in income, such as wages or dividends.
If not, how can I take into account the compounding of dividend reinvesting while adjusting the increased taxation?
Some more sophisticated calculations (which are still only as good as the rates of return and other assumptions made) can be found in Best and/or Recommended Retirement Calculator - Bogleheads.org (https://www.bogleheads.org/forum/viewtopic.php?t=115839#p1686175).
-
Thanks for the great spreadsheet, MDM!
I have one question, though - does the FI calculator at the bottom of the Calculations sheet take into account the growth of qualified dividends (B26) over time?
Somewhat. The projected taxable account balance at retirement (cell B160) does include compounded growth. It doesn't include year-to-year changes in income, such as wages or dividends.
Yeah, that's exactly what I meant. I assumed that the default 5% return rate was after subtracting dividends, since most here typically assume 7% inflation-adjusted returns that include ~2% dividends, and thus B26 has to be adjusted every year.
If not, how can I take into account the compounding of dividend reinvesting while adjusting the increased taxation?
Some more sophisticated calculations (which are still only as good as the rates of return and other assumptions made) can be found in Best and/or Recommended Retirement Calculator - Bogleheads.org (https://www.bogleheads.org/forum/viewtopic.php?t=115839#p1686175).
Thanks, I'll check it out!
-
Read and examine the case thoroughly
Take notes, highlight relevant facts, underline key problems.
Focus your analysis
Identify two to five key problems
Why do they exist?
How do they impact the organization?
Who is responsible for them?
Uncover possible solutions
Review course readings, discussions, outside research, your experience.
Select the best solution
Consider strong supporting evidence, pros, and cons: is this solution realistic?
Drafting the Case
Once you have gathered the necessary information, a draft of your analysis should include these sections:
Introduction
Identify the key problems and issues in the case study.
Formulate and include a thesis statement, summarizing the outcome of your analysis in 1–2 sentences.
Background
Set the scene: background information, relevant facts, and the most important issues.
Demonstrate that you have researched the problems in this case study.
Alternatives
Outline possible alternatives (not necessarily all of them)
Explain why alternatives were rejected
Constraints/reasons
Why are alternatives not possible at this time?
Proposed Solution
Provide one specific and realistic solution
Explain why this solution was chosen
Support this solution with solid evidence
Concepts from class (text readings, discussions, lectures)
Outside research
Personal experience (anecdotes)
Recommendations
Determine and discuss specific strategies for accomplishing the proposed solution.
If applicable, recommend further action to resolve some of the issues
What should be done and who should do it?
That's amazing, @Clara Smith. You've not only managed to completely miss the point of the thread, you've also plagiarised your response.
https://awc.ashford.edu/tocw-guidelines-for-writing-a-case-study.html
-
Does anyone know if similar spreadsheet exists for Canadians?
-
Is there a line to enter current savings and current emergency fund amounts?
I see a line for taxable savings and a monthly line for emergency fund.
Thank you!
-
Is there a line to enter current savings and current emergency fund amounts?
I see a line for taxable savings and a monthly line for emergency fund.
Thank you!
Good question. The answer requires some explanation.
The line for emergency fund contributions (cell B100 in the current version) is there to help people understand current cash flow. E.g., if they think their current e-fund balance is too low and want to understand how far down the Investment Order (https://forum.mrmoneymustache.com/investor-alley/investment-order/msg1333153/#msg1333153) they can go this year.
The line for taxable savings (cell B173 in the current version) is there for an estimate of "time to Financial Independence (FI)" . It assumes that amount is invested in things riskier, thus ultimately yielding some return above inflation, than an e-fund would be.
The spreadsheet ignores the e-fund balance, making the assumption that it merely grows with inflation and no effect on time to FI.
Does that make sense?
-
I am looking, and probably blind. Where in the spreadsheet would the income and deductions from my LLC go? I would think in non-paycheck items.....
-
I am looking, and probably blind. Where in the spreadsheet would the income and deductions from my LLC go? I would think in non-paycheck items.....
There is not a comprehensive "Schedule C" section, but there is "Schedule C net profit" (row 30) and rows 47 and 48 for a couple of "Self-employed..." items.
If one uses Schedule E instead, then rows 13 and 14 ("Rental" items) may be appropriate.
Does that help?
-
Indeed! Very helpful. Thank you.
-
Very helpful, especially the template. Thanks!
-
When I open the XL it says 2018 Cash Flow at the top.
Is that the most recent version?
Thank you!
-
When I open the XL it says 2018 Cash Flow at the top.
Is that the most recent version?
Thank you!
Good catch - no, it is not the most current.
See Case Study Spreadsheet updates (https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/) for a link to the 2019 version.
The post at the beginning of this thread should refer to the above link instead of directly to the spreadsheet, for just this reason.
E.g., instead of "This spreadsheet https://drive.google.com/file/d/0B45krBaG0b6KTWZDeXEySVBHVXc/view?usp=sharing can be downloaded and used to help organize your case study posting" it would be better to have "The Case Study Spreadsheet (see Case Study Spreadsheet updates (https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/) for a link to the latest version can be downloaded and used to help organize your case study posting."
I'll notify the moderators to see if one of them can make that change. Thanks!
-
I'll notify the moderators to see if one of them can make that change. Thanks!
And, thanks to arebelspy, it's done.
-
Judging by the inputs, I get the idea that the Case Study Spreadsheet is for people who are still working. As someone who has stopped working (for the moment) is there any value in me stepping through it?
-
Do you want advice about your income and expenses in a formalized way? If so, there is probably value in stepping through it. If not, then probably not.
-
Judging by the inputs, I get the idea that the Case Study Spreadsheet is for people who are still working. As someone who has stopped working (for the moment) is there any value in me stepping through it?
In addition to grantmeaname's perspective, it can be useful if you want to understand the marginal tax rate (https://www.bogleheads.org/wiki/Marginal_tax_rate) you would incur for various options, such as a Roth IRA conversion (https://www.bogleheads.org/wiki/Roth_IRA_conversion).
There can also be value in organizing and assessing your situation well enough that you know what input values to use.
-
What's the best way to get inputs on my spending/savings rate if I am based outside of the US? Does it work to plug in my numbers after converting them to USD for PPP (purchasing power parity)?
-
The Net Paycheck before tax (B20) is exactly $1500 higher than box 1 on my w2. I believe they should be identical.
My employer contributes $1500 to my HSA (I contribute the remaining) $6250, so it might be the source of the confusion?
I entered $6250 in Employer Sponsored HSA (B7) and added the $1500 in the Employer Match (B19_, which is not involved in the calculation of B20. (B19 also shows my 401(k) employer match)
I'd like to get it right, because I overshot on withholdings based on the calculation from this spreadsheet (not that big a deal, gave Uncle Sam a small zero interest loan for a few months), and since I'm in the phaseout area of MAGI for Roth IRA contributions, it looks like I will be able to contribute more than I expected (a good thing)
-
The Net Paycheck before tax (B20) is exactly $1500 higher than box 1 on my w2. I believe they should be identical.
My employer contributes $1500 to my HSA (I contribute the remaining) $6250, so it might be the source of the confusion?
I entered $6250 in Employer Sponsored HSA (B7) and added the $1500 in the Employer Match (B19_, which is not involved in the calculation of B20. (B19 also shows my 401(k) employer match)
I'd like to get it right, because I overshot on withholdings based on the calculation from this spreadsheet (not that big a deal, gave Uncle Sam a small zero interest loan for a few months), and since I'm in the phaseout area of MAGI for Roth IRA contributions, it looks like I will be able to contribute more than I expected (a good thing)
Can you post a screenshot similar to the one below, or just list all the non-zero amounts in cells B3:B20?
(https://lh3.googleusercontent.com/d/1gH8ZNMPuYnc1SosuPHwdX2lU9nE5amQu)
-
(https://i.postimg.cc/JzQ58MGv/Untitled.jpg)
My W2 box 1 is 197026
box 12 W is $7750
Employer match is $4757 401(k) match, plus $1500 HSA employer contribution. I think I got advice here to handle the SSA contribution that way but I could be mistaken
If I were to add the $1500 to B7 instead of B19, the number in B20 would match box 1
-
My wife has a home business where we can claim a deduction (above the line) for home office/studio use which I also didn't think to enter somewhere in the sheet, I'm guessing C49 would be the place to enter the home deduction?
-
If I were to add the $1500 to B7 instead of B19, the number in B20 would match box 1
If you do that, does B9 also match your W-2 box 5?
The note for cell B3 suggests "Often, W-2 box 5 plus all amounts in rows 4-8 on this sheet." Does that work for the W-2 and more detailed compensation report your employer provides?
-
My wife has a home business where we can claim a deduction (above the line) for home office/studio use which I also didn't think to enter somewhere in the sheet, I'm guessing C49 would be the place to enter the home deduction?
Based on Schedule C line 30 (https://www.irs.gov/pub/irs-pdf/f1040sc.pdf) you would handle that "behind the scenes" (or add a tab to the CSS for her business income/expense details) and enter the Schedule C line 31 result in cell C30.
-
My wife has a home business where we can claim a deduction (above the line) for home office/studio use which I also didn't think to enter somewhere in the sheet, I'm guessing C49 would be the place to enter the home deduction?
Based on Schedule C line 30 (https://www.irs.gov/pub/irs-pdf/f1040sc.pdf) you would handle that "behind the scenes" (or add a tab to the CSS for her business income/expense details) and enter the Schedule C line 31 result in cell C30.
Yes B5 matches too, so I'll enter the entire HSA contribution (self+employer) in B7. Thanks for the help!