Author Topic: How To: Write a "Case Study" Topic  (Read 65477 times)

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #50 on: June 20, 2016, 03:04:40 PM »
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...?

slappy

  • Stubble
  • **
  • Posts: 215
Re: How To: Write a "Case Study" Topic
« Reply #51 on: August 02, 2016, 06:51:51 AM »
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. 

MoonLiteNite

  • Bristles
  • ***
  • Posts: 408
Re: How To: Write a "Case Study" Topic
« Reply #52 on: August 21, 2016, 02:34:42 AM »
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

jsa307

  • 5 O'Clock Shadow
  • *
  • Posts: 3
Re: How To: Write a "Case Study" Topic
« Reply #53 on: November 28, 2016, 08:44:57 AM »
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!

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #54 on: November 28, 2016, 12:21:56 PM »
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.

jsa307

  • 5 O'Clock Shadow
  • *
  • Posts: 3
Re: How To: Write a "Case Study" Topic
« Reply #55 on: November 28, 2016, 12:57:19 PM »
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!

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #56 on: November 28, 2016, 01:10:57 PM »
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.

jsa307

  • 5 O'Clock Shadow
  • *
  • Posts: 3
Re: How To: Write a "Case Study" Topic
« Reply #57 on: November 29, 2016, 05:21:04 AM »
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..

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #58 on: November 29, 2016, 09:49:14 AM »
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....

swick

  • Global Moderator
  • Magnum Stache
  • *****
  • Posts: 2914
Re: How To: Write a "Case Study" Topic
« Reply #59 on: January 18, 2017, 01:32:37 PM »
Yes, Thanks RetiredAt63, I'll update instructions.

RetiredAt63

  • Walrus Stache
  • *******
  • Posts: 6224
  • Location: Eastern Ontario, Canada
Re: How To: Write a "Case Study" Topic
« Reply #60 on: January 18, 2017, 02:18:40 PM »
Thanks.
The measure of civilization is how people treat one another.

http://forum.mrmoneymustache.com/meetups-and-social-events/ontario's-own-camp-mustache-2017/ - MEET US THERE!

bluetick

  • 5 O'Clock Shadow
  • *
  • Posts: 5
Re: How To: Write a "Case Study" Topic
« Reply #61 on: March 17, 2017, 10:40:54 AM »
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?

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #62 on: March 17, 2017, 11:14:41 AM »
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.

bluetick

  • 5 O'Clock Shadow
  • *
  • Posts: 5
Re: How To: Write a "Case Study" Topic
« Reply #63 on: April 11, 2017, 11:16:38 PM »
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

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #64 on: April 12, 2017, 12:13:57 AM »
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 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....

rockeTree

  • Stubble
  • **
  • Posts: 124
Re: How To: Write a "Case Study" Topic
« Reply #65 on: April 14, 2017, 08:19:09 AM »
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.
« Last Edit: April 15, 2017, 09:05:04 AM by rockeTree »

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #66 on: April 14, 2017, 11:59:49 AM »
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....

Heroes821

  • Bristles
  • ***
  • Posts: 445
Re: How To: Write a "Case Study" Topic
« Reply #67 on: July 11, 2017, 01:54:06 PM »
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.

MDM

  • Walrus Stache
  • *******
  • Posts: 6583
Re: How To: Write a "Case Study" Topic
« Reply #68 on: July 11, 2017, 08:17:38 PM »
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.

Quote
I see a section for property tax, and for house insurance, but is the mortgage insurance part for PMI?
Yes.

Quote
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.

Quote
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.

Good questions!  Keep 'em coming as needed.