Valley. So now that we have schools that we have put in the awards for, now we have stars by them. So when we go to these schools, a school like Denison, we're going to have projected and now awards. Projected and awards. So if we go over and look at the awards tab, now we have all of our schools. One of the things we like to see is, you know, that, and were we close with our projection as far as what we had left over? Were we close with what our overall net cost would be to the family? You know, something we always want to track and monitor. So when we're in awards here. So one of the things that I recommend is once you get to this element and you have Denison, Stanford, and Ohio State, I would recommend going in and creating an actual scenario. So this is a what if, just like you would have in any other financial planning software. Actual awards is what I would plug in here. And I go ahead and go to that scenario because if these are, you know, the words that we really want to and, you know, what I would, I would just go and go into the how to pay. Because if you change anything in the how to pay tab, it's going to stay changed in that tab. This is the finish line. So when you're in here, if we had something like, you know, if we wanted to go and say, hey, just Denison. And, you know, even if you wanted to, just to clean things up, you could eliminate schools that we don't want on our list. So if we're at the finish line, really down to the final schools, just go ahead and take the other schools off the list. So now everything should be nice and clean. As we go through the system and we get down to the how to pay tab, only the schools we're interested in will be in here. So that kind of cleans things up, makes it nice and tidy. So you got actual awards here for Ray. And now we know we go into Denison, we want to click on the awards tab. And you'll see here, here's the, here's the, here's the big picture, right? If we go here, here's the amount of student loans that someone was going to need to take. And for those loans, it'll be a repayment of 513 a month over 10 years or 297 over 25. And you see we've got the total repayment highlighted below to really illustrate the interest. And then also here's what you're going to make in computer science from this school, right? So that's, that's the way we're going to look at that. We're going to, this is where our starting or take home pay would be. Seems like pretty decent. We're going to give that good, it's actually pretty good outcome. And then we've got our net costs and we all, everything from awards pushed over. So you can see, we do still inflate things a little bit over the years, understanding that, you know, typically that is what will happen, particularly at private schools. But sometimes in our state schools, they will levelize tuition for us. So be aware of that. But that's kind of how it works. The grants that I have just illustrated to stay the same. And then we get into, okay, here's our budget. Here's what we plugged into the budgeting tool. So what the system default will be to spread everything evenly out over the four years. So the totals are here to the right, right? So our total budget of 65,200 and totaled out over here for each row. And then the columns, like I said, that's, that's where, um, you know, you're figuring out, okay, here's our budget and then what's our gap left over. And then, okay, well, what's our total? Let's go ahead and say, let's go ahead and use the federal direct student loan. And that's going to populate, these don't double up. It's something that system, it's, it's just, uh, when we say we want to use those, it's illustrating what subsidize, not subsidize, but it's grayed out here. So just know you have to click that use button and that's going to apply those so that when we have, here's our, here's our budget. Here's the gap. We're going to use 27,000 in these federal direct student loans. And it'll break out like this for a total here of these of 27,000 over four. So 3,500 plus two or 3,500 plus, uh, 2,000, 5,500, right. And then that totals out. You can see, so that's the total here, 27,000, 19,000 of subsidized 8,000 on sub 27,000 total. So now we've got, you know, a remaining gap of 19,000. So the tool is basically built so you can go back in and say, how do we want to make up that funding gap? So, um, you know, let's say, um, grandparents came along and said, you know what, we'll pick up whatever's not covered, uh, from there. So now we don't have a funding gap. We're going to take out just a federal direct student loan said, you know, 3783. That's going to give us no loan there and 5231, right. And then the last one, 7752. All right. So that's going to give us basically, here's a full college funding plan, right? So the grandparents and other help came up with about 19,000. So, and that could be true of any of these, right? So we can, we can go in and manipulate these numbers and take them out and plug new numbers in. You know, if parents, you know, if we said, okay, if we wanted to just, you know, uh, we like this plan, um, it'd be great if grandparents kicked in, but you can also fill up and you can click this reset button at the top. Well, that's going to do is go back to the original plan. So now we're in our awards tab. So what I just plugged in there, um, did not push over. So we've got to go in and kind of go, okay, here's our net cost. Here's our budget. Um, okay, let's use those loans. Uh, we could say, you know, instead of, uh, the 9,600, what if parents could come up with a little bit more? And we said they could cashflow 20,000, 5,000 per year. So that gets our funding gap down pretty low. Even the first year, there's even a little surplus. So, you know, again, there's, there's any, any ways that you want to, you know, plug this in and you can do it, start and it'll spread it over for, um, or you can plug in, you know, whatever you want these numbers to be. And you'll see that, you know, it, the system will do the math for you basically. So helping us understand, you know, here's our plan to pay for all four years of cost down the penny. Um, so, you know, that's, uh, whatever we want this to be, you know, push over. And then if people are exploring different types of loans, there is a loan tab in the parents that will explain different loan types. So if we wanted to make that up at a HELOC or a private student loan, plug those numbers in here. Whole idea is the family has a very well thought out full plan. You know, if they said, look, we're going to take that out in student loans, they would now have that. Um, we now have a 4631 and 7152. So here's how this is going to play out. Right. So we've got, we know we've got a gap. We're going to pay, utilize some of these, um, and then utilize some private student loans to make up the difference. Right. So our loan amount is still here, but we know what type of loans we're going to take and when by year. Um, so it's a very helpful exercise to be able to see and visualize, understand. Right. So, you know, we do the same exercise for Iowa State or, you know, these, uh, how, how these are going to shake out as well. We know, you know, how this is, this is how we're going to pay that, you know, we're going to utilize the loans. And, um, Stanford was the last one we had on the table. So, uh, we're going to go ahead and use federal direct student loans and, uh, Stanford in those first couple of years, we actually have a surplus. Um, so one of the things you'll see, like it'll have state, um, some people might say, what if we did community college for a year? Well, you could basically take this tuition number down, um, right to like 5,000, four to 5,000 community college. Let's say they lived at home. You could wipe out all these other expenses if you wanted to. Um, another thing that often happens right now is, uh, the state schools in the state of Ohio and many other states are actually levelizing tuition for four years. So that's something that could come into play. Uh, obviously that can help, uh, chip away at your total cost and your total loans. So, you know, very, very malleable tools should give you a nice way to look at things on a side-by-side basis. Um, so that's really kind of the how to pay tab using the awards versus projected. Remember the reset buttons here, if you want to just go back to defaults, um, how, how we want it to work. Um, and then you've got a pretty robust reporting section down here. So general is going to be like overview, the facts that were put in, the schools we're looking at, and you can look at the what-if cases on a side-by-side. So we've got the base versus actual, um, if we change anything, like if we changed, changed the budget or, you know, um, tried to move the EFC, you can prepare things and really show people here was the difference to a base case and, uh, and the other one, you know, in terms of something to print out. And then when you go to projections, this is where you're going to see, um, you know, we wiped out all the other schools and, you know, now we're just really looking at the actuals. So you can see in the actuals, here's, here's the award letter, um, you know, being able to see this and print it out and then the borrowing analysis. So if we went here, what's our, what's our budget, uh, versus the net cost, what's the remaining funding gap, and then the loan payments. So again, by just kind of cleaning that up and using just the three schools, now you've got this really kind of neat way to look at it. And then the how to pays are also, you know, you can have these visually, you know, printed out for folks. And then when you go down to, um, look at these of them, you know, so you can get them in a reporting function, you'll see, you can pick what you want. If you want a cover page, table of contents, let's say we want the overview and the facts, not really worry about the schools or the terms right now, but I do want the borrowing analysis in all four years. Um, but really in this case, we said, look, I just want to see the actual stuff that's going to go on. So just, here we go, here's how to pay, here's awards, um, here's, uh, the borrowing analysis. Let's go ahead and get those schools. And then, uh, you can either download it or get it, put it in a PDF that will show up in the window. I usually do the download and then, uh, you know, this is going to pop up. So, you know, you've got a nice report, a good deliverable. So if you're running a meeting with somebody, um, great way to, you know, as a follow-up, hey, here's your report that we looked through. You can click through in this PDF, um, and go to wherever you want to, uh, go to check out. So, you know, here's Denison, here's all the stats and figures and all the links and all this stuff for each of the schools. And then headed down to the finish line, as I call it, you know, here's your awards side-by-side. Uh, and then here's our, uh, our borrowing analysis. So the four-year cost versus the budget, here's the funding gap, here's the loan payment when we're done. Um, so it's all really clearly lined out. We've got definitions included in there. And then, uh, the, the how to pay, like I said, this is the roadmap to be able to help people understand here's what it's going to cost us out of pocket. Um, and here's exactly how we're going to pay for it. And that's really a very powerful thing we can do to help families just understand, hey, here's, here's what, uh, here's how this is going to actually shake out. Um, and you're actually going to, how you're actually going to be able to pay that bill, right? So those are all the schools we're interested in. And then, uh, obviously disclosures, which we can add, uh, at the end if we, if we want or need to. So, uh, hopefully that's a good overview, uh, again of the, uh, each of the parts, uh, of the tool going through, uh, the, the, uh, application and awards, and then ultimately down to how to pay and then creating great reports, uh, is the other, uh, piece we want to, um, see in there as well. And, you know, kind of now we're at the, at the finish line. And as I mentioned before, private scholarships is here for us to access and have the parents utilize as well, um, that they can go and, you know, put in their unique criteria on scholarships if they want to, um, include, you know, is it based on residency or what type, what are they studying? Um, so all these eight elements are the primary ones. There's 143 pages. So, you know, if you want to learn more about that particular scholarship, you can click out. We've got links to the websites right here if they favorite that scholarship. So that's one we want to make sure we keep on our radar, uh, keep the new due date, you know, those will be, uh, coming, uh, flipping over here soon with new deadlines for the following year. But then when we go into favorites, we're going to just have, hey, here's our, here's our list of schools that we're interested in or scholarships we're interested in that we've marked off on our list, um, as our favorites. So, uh, that should be pretty good overview of the whole system. Um, and, uh, hopefully this was helpful and let us know what questions you have.

college funding planning tool

awards tab

how to pay tab

reporting section

private scholarships