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

MDM

  • Walrus Stache
  • *******
  • Posts: 6437
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: 190
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: 394
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: 6437
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: 6437
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: 6437
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: 2911
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: 5963
  • 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: 6437
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: 6437
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: 115
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: 6437
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....