[MUSIC] Welcome back, we are doing mega problem, application two. And what I'm going to do now is something cool, because I want to like in application one, get as much value out of this problem. Because it'll kind of enable you to run on your own and empower you. And finances for everyone is this course I keep reminding myself, it's important that I give you some tools to work with properly, right? So what I'm going to do is I'm going to confirm that my calculations are right. How do you do that? And that's one of the beautiful things about finances. You can play things out in real time and see if all of it makes sense. So what does that mean? I'm going to start with the amount that we decided a million needed in the bank today in our fund, and it was 34,000 at time zero. It was 34,213.09, yeah? We needed that money in the bank, and I'm going to play it out in real time. And then later I'll do an application which will make you do things smarter and quicker. But right now I want to go step wise. So here's the timeline. And I'm interested in years five, six, seven, eight. She will of course graduate in year nine, okay, if things go as planned. So the first thing I'm going to do is I'm going to tell you the value or work with the value of the fund. Then from this, I will subtract tuition every year. And the fund, please remember, increases at 5% and this increases at 2.5%. We have calculated these numbers already, the tuition that is, and it's a negative number. So what I'm going to do is I'm going to take fund to each year after figuring out the net value, net fund. And at the end, what should you, if you have saved enough and things work out, you would have come up with zero at the end. So I'm going to put a zero right here. That's what I want to get, right? Because you would have paid off everything. You wouldn't be left with either positive or negative, right? So let's start off, the first issue is, what is the value of the fund in year five? Very simple, how would you do it? It's a future value problem, very simple. Then the interest rate is what? 5%. And number of years is? Five? And the PV is 34,213. So I'm going to write out that number. It's 43,665.53. This is the amount of money in my fund. However, at the end of five years, I'll have to make a withdrawal from this fund for tuition, and the withdrawal amount will be 11,314.08. We have already calculated it, but you can redo it. What is this number? How would I get it? It'll be 10,000, today's value of the tuition carried forward for five years but now at 2.5%. What am I left with? I'm left with 32,351.45. This is the first step, but we got to keep going, and that's what makes it interesting. So the question is in year six, what's the value of the fund after having paid one tuition? And the answer is, it's got to be greater than 32, but at which rate? 5%, it's a future value problem, that n equals 1. 33,969.02. But now I have to subtract the second tuition in year six. And that second tuition has to be greater than 11,314. Why? Because of inflation of 2.5%, so it turns out, 11,596.93, and you're left with 22,372.09. Because there's a lot of numbers, I'm kind of going a little slow so that I don't make a silly mistake. It just making sense, right? Because the tuition is pretty hefty. So you go from 33 to about 22. How do I get this top number now? Again, take, 22,000 forward, but at which rate? 5%, so this is 23,409. Sorry, 490. 23,490.69. And I want to now subtract a tuition that's increased again, one more time for one year. And that is 11,886.86. And what am I left with? I'm left with 11,603.84 I should carry this forward but the number I should get here is the same as the tuition, and seems like I'm on the right track, right? But I carry this forward at 5%. I get 12,184.03. And that's exactly the tuition, 12,184.03. Isn't this cool? So what I've done is I have worked on two mega problems which I promise you will not only empower you to do these in your own time, which I will recommend very strongly. But will empower you to do the problems in the assignments which in turn will help you run the things even better beyond the assignments. I purposely make some of the questions and the assignment tough so that you have to think. But in this course I'm doing a lot of stuff applied and more so to problems that you'll encounter in different aspects of your life. Obviously, I can't cover every aspect but hopefully, the flavor of the problems is such and the mixes between them across problems are such that we'll cover most issues.
