Updated Dental School Costs Spreadsheet

[bhar03]

Advertisement - Members don't see this ad

Well i posted the original version of this a little bit ago and said i would make some updates. After reviewing it I realized there was a lot of mistakes so hopefully I got most of them cleared up. As for most people not much will change, but this version will work better for In-staters or scholarship people who won't have to necessarily max out their stafford loans. Also for those UoP people that are on the 3 year track. Other than the internal formulas and cell-linkages, its basically the same as last one; just more all encompassing.

Just change the blue cells and your good to go.

Edit: I created a separate UoP sheet just for you special people out there. The interest would have been funky otherwise so hopefully it makes it a little more accurate for you people.

 

[iwannabadentist]

not that I don't appreciate all your hard work, but just so that everyone doesn't get the wrong information, the UoP specific numbers are not accurate. Unlike, UNLV where you can get in-state residency after a year, UoP tuition+fees+living is maintained at ~90k per year. I tried making the change on my own on the spreadsheet but the formula seems too complicated and everything gets messed up. If you could fix this, or rather, make it so that everyone can edit their principal amount as desired without affecting anything else, that'd be FANTASTIC. thanks 🙂

 

[bhar03]

Ah yes, sorry.. The Numbers in there arn't right in the UoP Sheet ( i didn't have any number for tuition, cost of living in SF, etc) but you should just be able to enter those numbers in the blue cells; no formula modifying needed. Regardless, i'll just upload a new document with the 90k figures in it, and just disregard all the other writing that doesn't really apply to UoP

p.s. I'm still stumped though as where you are wanting to chnage up some formulas.

 

[iwannabadentist]

Ah yes, sorry.. The Numbers in there arn't right in the UoP Sheet ( i didn't have any number for tuition, cost of living in SF, etc) but you should just be able to enter those numbers in the blue cells; no formula modifying needed. Regardless, i'll just upload a new document with the 90k figures in it, and just disregard all the other writing that doesn't really apply to UoP

p.s. I'm still stumped though as where you are wanting to chnage up some formulas.

the bolded is all i wanted to do. i don't know i tried it and it didn't work too well...but now that i try it again it works fine?! after putting the numbers for my school...im totally stumped. this is insane! thanks again for making this!

 

[denner]

Well i posted the original version of this a little bit ago and said i would make some updates. After reviewing it I realized there was a lot of mistakes so hopefully I got most of them cleared up. As for most people not much will change, but this version will work better for In-staters or scholarship people who won't have to necessarily max out their stafford loans. Also for those UoP people that are on the 3 year track. Other than the internal formulas and cell-linkages, its basically the same as last one; just more all encompassing.

Just change the blue cells and your good to go.

Edit: I created a separate UoP sheet just for you special people out there. The interest would have been funky otherwise so hopefully it makes it a little more accurate for you people.

This thing is fantastic, thanks a ton! Now if I only had some numbers to put in it....hmmmmm....c'mon Dec. 1st.

I knew you business people were good for something 😛

 

[sketo43]

This spreadsheet is excellent! Thank you! I really like how it breaks down the interest by loan type, and even accounts for disbursement fees.

If you ever make a version 2.0 of this spreadsheet, I have one suggestion: make a field where you can type the projected annual % increase in costs. At many schools, it's increasing by 5% per year, which is huge. At the interviews I've been to, the schools tell us the costs for the 09-10 school year. But next year it will be higher. By our 4th year it will be much higher.

Thanks again!

 

[Badgerfaithful]

Nice spreadsheet, definitely a great starting point for people to figure out where they're at. I think if people want to add 5% increases in tuition each year it would be easy to do yourself..

But where did you get the 7.9% interest rate for Grad PLUS loans? As far as I've seen and been told by financial aid people this rate is currently at 8.5%.

Thanks!

 

[pacific2013]

Nice spreadsheet, definitely a great starting point for people to figure out where they're at. I think if people want to add 5% increases in tuition each year it would be easy to do yourself..

But where did you get the 7.9% interest rate for Grad PLUS loans? As far as I've seen and been told by financial aid people this rate is currently at 8.5%.

Thanks!

7.9% is through the William D. Ford Federal Direct PLUS loan program. I'm not aware how many schools utilize this type, but I know Boston, and I think ASDOH go through that way.

OP, are you sure the Subsidized Stafford loan rate is 5.6%? It may be UNLV specific, but most schools have 6.8% just like the unsubsidized loan.

Below are just info you can incorporate in future updates if you would like.
1)Fees are usually 0.5% after applying the 1.0% upfront rebate for Stafford loans.
2)At least for the Federal Direct PLUS loans, not sure about regular PLUS loans, the fees are 2.5% after an 1.5% upfront rebate.
3)Fees are taken away from your loan, not added on principal from what I hear. So for example, you can apply for $8500 for Stafford subsidized loan and they will give you $8457.50 to spend. They didn't give me the specific numbers but this is what I heard.

 

[BiomajorPreDent]

Spread sheet is great. I worked out one of my own of these and I am happy to say we had the same figuring down.

I feel better about the whole loan process now.

😀