1. The SDN iPhone App is back and free through November! Get it today and please post a review on the App Store!
    Dismiss Notice
  2. Dismiss Notice
  3. Guest, be sure to check out How To Get Into Dental School, our free downloadable PDF with step-by-step details for dental school applicants!
    Dismiss Notice
  4. Dismiss Notice
Dismiss Notice

Interview Feedback: Visit Interview Feedback to view and submit interview information.

Interviewing Masterclass: Free masterclass on interviewing from SDN and Medical College of Georgia

Financial projections of dental school Excel document

Discussion in 'Pre-Dental' started by Bereno, Nov 11, 2011.

  1. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Hi all! I have seen a few threads on here about the financial feasibility of DS, and wanted to post here. Recently, I threw together an Excel document so that I could run the numbers and see for myself what I can expect based on certain scenarios. I thought that those of you who are curious about the costs, and how they might affect your cash flows might like to use it. I added a few comments to it, and inserted a few instructions so that it is a little easier to use.

    Some notes: Its quite comprehensive. Please read all of the blue boxes and try and understand what it is doing before you go and fiddle with everything. Also, this does not segregate the different types of loans for you. This is mainly aimed at helping determine if your financial cash flows can be sustained after graduating dental school (aka "to see if it is financially feasible").

    If you have any questions about how to use it, please post them here so others can see your question(s) along with my answer(s).

    Anyway, here it is! :thumbup:
     

    Attached Files:

    #1 Bereno, Nov 11, 2011
    Last edited: Jul 14, 2014
    CubsFan44, Tatu78, odpropofol and 7 others like this.
  2. Note: SDN Members do not see this ad.

  3. UltimateHombre

    UltimateHombre Doc Holliday D.D.S.
    7+ Year Member

    Joined:
    May 10, 2010
    Messages:
    1,144
    Likes Received:
    115
    Status:
    Dental Student
    First in on an awesome thread!!!

    Thanks for all your hard work Bereno!! You truly are a financial executive!

    But seriously this is super detailed and awesome!! How long did it take you to put this whole thing together?
     
  4. This is amazing! I wish I knew how to use excel like that lol. Thanks a lot. The only thing I see unrealistic is the model assumes you are going to make an extra $5000 (or whatever you put in) every year you practice. But there's really nothing you can do about in order to keep the model simple.
     
    fayevalentine likes this.
  5. MrAvicii

    Removed

    Joined:
    Aug 21, 2011
    Messages:
    1,169
    Likes Received:
    1
    EXCELLENT JOB BERENO! This would be awesome to use to theorize! Thanks a lot buddy!
     
  6. amanda9717

    7+ Year Member

    Joined:
    Aug 18, 2009
    Messages:
    113
    Likes Received:
    0
    Status:
    Dental Student
    Wow, Bereno! Thank you so much!!
     
  7. amalgamgrillz

    Removed 2+ Year Member

    Joined:
    Jun 24, 2008
    Messages:
    1,079
    Likes Received:
    4
    Status:
    Pre-Dental
    Amazing job, Bereno!

    Moderators: please sticky this!
     
  8. Parle G

    7+ Year Member

    Joined:
    Dec 30, 2008
    Messages:
    314
    Likes Received:
    0
    Status:
    Dental Student
    Thanks a ton Bereno!
     
  9. dentaluofm

    Joined:
    Jul 27, 2011
    Messages:
    46
    Likes Received:
    0
    This is amazing! Bereno=Boss
     
  10. letsdoitbama

    5+ Year Member

    Joined:
    Jan 7, 2011
    Messages:
    144
    Likes Received:
    1
    Status:
    Pre-Dental
    I don't know about you guys, but I see a lotttt more green if I'm using my state school here. :xf:
     
  11. hellopeople

    7+ Year Member

    Joined:
    Dec 7, 2008
    Messages:
    602
    Likes Received:
    39
    Status:
    Dentist
    Wow. Good job. I made something similar, but not nearly so detailed.

    Absolutely epic contribution.
     
  12. jackalo34

    Joined:
    Jul 29, 2011
    Messages:
    250
    Likes Received:
    0
    Status:
    Pre-Dental
    I agree. This looks like this took quite a lot of time and effort. Thanks for sharing, Bereno!
     
  13. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Thanks man, i think it probably took me about 7-8 hours or so overall (I never worked on it for more than 2 hours at a time though). The first 4 were used making it work, like getting the formulas correct and whatnot. The last 3-4 were making it usable for others who don't know what I was doing. This includes making the little notes, changing the layout and stuff like that.

    Yeah, I thought about making a dynamic system for that, but I decided against it. I think i even made a small note that pretty much said exactly what you said - I needed to keep it simple. Also, this was part of the reason for the "Gray zone" because your income can pretty much do anything after 10 years lol

    HAHA! Yeah, that might be a common theme here :thumbup:

    I'm really glad you guys like it. Like I said, I made it for myself so that i could see the overall effects of a change in either salary, payback duration, or even when I wanted to buy a house.

    Once again, if you have any questions on how to use, please let me know
     
  14. DentalGunner

    Removed

    Joined:
    Oct 30, 2011
    Messages:
    188
    Likes Received:
    3
    Status:
    Dental Student
    Using numbers for Penn:
    :scared: Please get the presidential scholarship...
    Otherwise I must give BJs to 135 strangers for $60 each, every month, for the first 7 years...to get out of the red. Ugh. Bring it on, boys. Who's first?
     
    Anetka5326 likes this.
  15. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Damn, thats about 4.4 BJs a day - I really hope you're down for that! :laugh:
     
    #14 Bereno, Nov 11, 2011
    Last edited: Dec 11, 2012
  16. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Some questions that others have had:

    Well, if you indicate that you are going to buy a house after year 3, it will stop the rent expense after year 3 even if you have no mortgage. This is because it assumes you are now living in a home, not paying rent.

    Basically, if you are never going buy a house, indicate that in the gray box by selecting 40. :thumbup:
     
    #15 Bereno, Nov 11, 2011
    Last edited: Nov 11, 2011
  17. Golfguy

    5+ Year Member

    Joined:
    Mar 5, 2011
    Messages:
    388
    Likes Received:
    28
    Status:
    Resident [Any Field]
    Awesome work Bereno!

    If you ever get the itch to add a few things, I would suggest payroll and state taxes, as well as individual loan breakdowns (stafford vs. plus).

    I would add them myself, but I'm not that smart.
     
  18. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    I would add the opportunity to alter the loans, but that kinda takes away from the intent of the document. I want it to be used for a cash flow analysis, not loan valuation.

    As far as state and payroll taxes - those are so variable that its hard to have any consistency here. Remember, I want to keep this simple. I might add a spot that can allow you to include additional taxes, but I am not sure how those would work with marginal rates. If you know how to include a marginal tax rate analysis using payroll or even state taxes, please let me know :) :thumbup:
     
  19. Tyrangiel

    7+ Year Member

    Joined:
    Jan 30, 2010
    Messages:
    214
    Likes Received:
    0
    Status:
    Dental Student
    Thanks for putting this together. It is informative if a bit sobering...
     
  20. Golfguy

    5+ Year Member

    Joined:
    Mar 5, 2011
    Messages:
    388
    Likes Received:
    28
    Status:
    Resident [Any Field]
    Agreed, it's not easy. The big hit will be funding social security at the full 15% (after the business loan is taken out, and we become self employed). But like you said, there are so many variables that it's impossible to take account of them all.

    Thanks for doing this for the benefit of others.
     
  21. Dusk

    Dusk Member
    5+ Year Member

    Joined:
    Jun 23, 2010
    Messages:
    495
    Likes Received:
    21
    Status:
    Dental Student
    amazing!!! i'm totally going to check this out in depth after midterms.. thanks:thumbup:
    being a finance major, i'm sure you'll do fine in the future!
     
  22. pupsingh

    pupsingh New Member
    10+ Year Member

    Joined:
    Feb 24, 2006
    Messages:
    152
    Likes Received:
    0
    Status:
    Pre-Dental
    do you think you could add an option for Income Based Repayment? maybe you could incorporate the ibr calculator into the excel somehow?
     
  23. Golfguy

    5+ Year Member

    Joined:
    Mar 5, 2011
    Messages:
    388
    Likes Received:
    28
    Status:
    Resident [Any Field]
    .
     
    #22 Golfguy, Nov 11, 2011
    Last edited: Nov 11, 2011
  24. Barking Lamb

    2+ Year Member

    Joined:
    Jul 4, 2011
    Messages:
    125
    Likes Received:
    1
    Status:
    Dental Student
    Hey, a few schools I looked into suggested deferring loan payments for as long as possible and accruing the maximum amount of capital for investment. They argued the returns would be significantly greater than the interest on our student loans. I'm no financial expert, could you give me your 0.02 cents on how that might factor into or affect your model?

    As a note, my comment still wouldn't leave cash lying around post graduation for a brand new car or anything. Meaning we would still be just as poor but I assume you all get the rough idea.
     
  25. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    lol, do you know how much work that would entail? Sorry, I can't do it. Not anytime soon anyway. It would take forever to determine all of the contributing factors that alter the reduced payment, let alone allow that to be included in the cash flows portion of the document. If you have looked into all the rules for IBR, you would see how much time this would take. Even then, I don't know of a good approximation method that would be relatively close to actual payments. I will think about it though.

    You might be able to figure this cash-flow boost by artificially lowering your Misc payments though...

    This document is aimed at the general population who is not going to use IBR. It is meant to be used for high level feasibility; not plan your every dime. It is used to see just how strong your cash-flows need to be to supplement your loans from dental school. Hope this helps :thumbup:
     
  26. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Are you referring to the six month grace period? I have heard of people getting early jobs, and stacking every dime away for this six months before they are required to start paying. The intent of this is to allow you to develop a small "emergency" fund. This emergency fund would be there to compensate for any large "emergency" payments that might arise. This would in no way reduce your monthly cash outflows though, which are the real killer for most. This is more of a precautionary policy than a financial one.

    BTW, 0.02 cents is a lot different than $0.02. I know you know this, but I thought it was funny. lol :D
    [YOUTUBE]http://www.youtube.com/watch?v=2Y7yqphVq54[/YOUTUBE]
     
  27. Demps

    Joined:
    Jul 26, 2011
    Messages:
    729
    Likes Received:
    1
    Status:
    Dental Student
    Bereno,

    You are the man
     
  28. MrAvicii

    Removed

    Joined:
    Aug 21, 2011
    Messages:
    1,169
    Likes Received:
    1
    You can visit the following site for IBR repayments. You dont need a whole calc for it. This will suffice http://studentaid.ed.gov/PORTALSWebApp/students/english/IBRCalc.jsp
     
  29. AlbinoPolarBear

    7+ Year Member

    Joined:
    Jun 18, 2011
    Messages:
    1,607
    Likes Received:
    303
    Awesome job Bereno. :thumbup:
     
  30. Barking Lamb

    2+ Year Member

    Joined:
    Jul 4, 2011
    Messages:
    125
    Likes Received:
    1
    Status:
    Dental Student
    Yeah, it was sarcasm. I thought it would play off my phrase "I'm no financial expert." That stuff doesn't translate very well over the internet.

    -------------------------

    No, I am not referring to the grace period. I mean making the minimum payments on your loans and not paying them back for (insert huge number of years).

    I had always been of the mindset that I would move in with my parents or my uncle after dental school and pay off the student loans in two years while living a sorry sorry life.

    However, Nova for example recommended that students make minimum payments on their loans. They argue the interest on the debt doesn't matter when compared with the returns on a 401k, mutual funds, stocks and bonds portfolio.

    I don't know, like I said I'm not well read on this material yet and I don't need to worry for a few years. But, I saw your undergrad is in the financial area and wanted your opinion.
     
  31. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Lol, got it.

    Don't listen to Nova. Simple as that. If you are sitting on 400K+ of debt and only make the minimum payments, you will be FAR worse than you would be otherwise. This still holds even if your investments have a higher rate of return than the interest rates on your loans. Essentially, paying the minimum only defers your payment, which costs you money. I don't want to go through all of the numbers right now, but I can run a valuation test sometime later, and post on here to give you a concrete example.

    Moral of the story
    : Pay it off as soon as you can (while still being comfortable)
     
  32. MrAvicii

    Removed

    Joined:
    Aug 21, 2011
    Messages:
    1,169
    Likes Received:
    1
    thats probably the dumbest advice ive ever heard LOL the compounding interest will eat away at any "investments" you can make. In addition, this market is so horrible right now that you will end up "double dipping" by losing some money on your investments and paying off significantly higher loans later on.

    Be smarter and take a schools advice with a grain of salt. They aren't the ones that are paying off the loans. :)
     
  33. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Bump for version 2.0 of the excel document! It now has the option to include a flat rate auxiliary tax. This can be in the form of either a state tax, self employment tax, whatever.

    Please note: This tax is a post deduction tax, so it is only a flat rate of what you earned after deductions. If you need a pre-deduction tax... well... sorry haha

    :thumbup:
     
  34. FLOSS UR TEETH

    7+ Year Member

    Joined:
    Jan 30, 2011
    Messages:
    668
    Likes Received:
    3
    Status:
    Dental Student
    Hey Bereno! Your the bomb! I really appreciate you sharing this with us buddy.
     
  35. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Yeah, of course! I like being able to help my fellow peers :thumbup:
     
  36. SexyMariGal

    Joined:
    Oct 13, 2011
    Messages:
    68
    Likes Received:
    0
    This deserves a bump, guess I'm going into the military, lol.
     
  37. metaverse

    Joined:
    Feb 21, 2012
    Messages:
    16
    Likes Received:
    0
    Status:
    Pre-Dental
    This is amazing! Thanks, Bereno!
     
  38. MrGoOrange

    5+ Year Member

    Joined:
    Nov 20, 2011
    Messages:
    28
    Likes Received:
    1
    Status:
    Dentist
    Thanks Bereno! This is an amazing spreadsheet!:thumbup:
     
  39. timwatley

    7+ Year Member

    Joined:
    May 4, 2009
    Messages:
    629
    Likes Received:
    18
    Status:
    Pre-Dental, Dentist
    Finally got around to plugging my numbers in, this thing rocks! thanks
     
  40. woolloo

    Joined:
    Dec 30, 2011
    Messages:
    45
    Likes Received:
    0
    Status:
    Dental Student
    You're real a savior, Bereno! I like the sophistication and elegance of this spreadsheet :thumbup:
     
  41. Cello

    Classifieds Approved 7+ Year Member

    Joined:
    Sep 10, 2011
    Messages:
    1,169
    Likes Received:
    1,407
    Status:
    Dental Student
    Just now saw and had the opportunity to use this spreadsheet, great work Bereno! If this forum had rep I'd +rep you. :D
     
  42. dantemac

    5+ Year Member

    Joined:
    Jan 16, 2011
    Messages:
    2,279
    Likes Received:
    17
    Status:
    Dental Student
    Thank god for the military. :rolleyes:
     
    agent2362 likes this.
  43. white fang

    Removed

    Joined:
    Feb 7, 2012
    Messages:
    260
    Likes Received:
    0
    Very good product. After viewing the sheet, I realized I would be happy to pay you for this spreadsheet. If I were you I would take down the link to the sheet and charge people $9.95 for the download. Your time is worth more than $10 for this wonderful spread sheet.


    Signed,

    Guy who is willing to set up the paypal and take half the profits in exchange :)
     
  44. white fang

    Removed

    Joined:
    Feb 7, 2012
    Messages:
    260
    Likes Received:
    0
    ...sorry double post....
     
    #43 white fang, Apr 6, 2012
    Last edited: Apr 6, 2012
  45. SexyMariGal

    Joined:
    Oct 13, 2011
    Messages:
    68
    Likes Received:
    0
    Wow, really? You should be put on probation too like that Wired guy you kept arguing with. Stop being an ass.
     
  46. DJPaulyDDS

    2+ Year Member

    Joined:
    Oct 6, 2010
    Messages:
    56
    Likes Received:
    0
    Status:
    Pre-Dental
    LOL not a bad idea. cut down on those loans anyway you can.
     
  47. white fang

    Removed

    Joined:
    Feb 7, 2012
    Messages:
    260
    Likes Received:
    0

    I don't understand, do you not value the time and effort that Bereno spent?

    To me it is worth at least 10 bucks, I don't know how cheap you are but it seems ridiculous...
     
  48. tinman831

    tinman831 ¯\_(ツ)_/¯
    Administrator Dentist Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Dec 11, 2004
    Messages:
    11,348
    Likes Received:
    73
    Status:
    Dentist
    Back on topic please. Personal attacks will not be permitted.
     
  49. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    Lol, no it will stay free. I am glad you appreciate it!


    Don't be hard on the guy. Even if he was being sarcastic, I would still give him the benefit of the doubt. :thumbup:
     
  50. white fang

    Removed

    Joined:
    Feb 7, 2012
    Messages:
    260
    Likes Received:
    0

    FYI I was not being sarcastic,, it really is worth being sold. Though I was joking about setting up the paypal and taking some profit.

    Not sure why it was such a bad post, I meant nothing but compliments to you.
     
  51. Bereno

    Bereno Smoking Monkey
    7+ Year Member

    Joined:
    Apr 14, 2011
    Messages:
    1,981
    Likes Received:
    421
    Status:
    Resident [Any Field]
    I figured you were being honest, hence why I said thanks! So thanks again!! :D I'm not too sure why SexyMariGal jumped on it though... Maybe the paypal thing? haha
     

Share This Page