Skip main navigation

New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only T&Cs apply

Find out more

Application I: The Fundamentals of a Loan

Application I: The Fundamentals of a Loan
This is a little bit of a transition, though as you must have realized by now, I think that finance is so applicable that everything we have done is, even up to this point, simple though it is, is highly applicable. But now I'm going to do something that I don't do with advanced students, or advanced programs, because this is finance for everyone. I'm going to do some really, really interesting applications which will show you how to problem solve. I hope you have started doing assignments already. There is an assignment linked to every module there is. It's good to practice, but it's entirely up to you when you're comfortable doing that.
That's the one thing I like about digital education is that you are in control. All right? So what I'm going to do is complicated problems. The one thing that will change probably is I will not stick to four or five minute videos if the situation so demands. In fact, I have a joke which I like to share with you is that one of the best practices of online education is to have short videos, six minutes or so. But I many times don't remember my name and takes me about two minutes to figure it out if you wake me up in the morning. Who are you? And I'm wondering that's just too deep for me to answer.
So I'll keep going according to the dictates of the issue, right? So just be patient. You can always pause, move forward, watch in twice the speed and so on. So let's start. I call these mega problems. So mega problem number one. It's an application that you've seen before, but I'm going to kind of show you the beauty of finance and beauty of the complex world. It's a loan. And a loan I will pick up is for college, you have done it before, and then I can expand on it. So, if you look at the screen, you'll see a very familiar problem. You're planning to go to college, and your parents and you get together and figure out you need $100,000.
And, at time zero, and you're going to take that loan, and it's required to be paid over five years, right? R is 6%, n is five years, and PV is, $100,000. I put a comma here, but don't put it in Excel, right. So just keep reminding you. So, what I'm trying to solve for here is, how much will you, every period, starting one, five times, okay?
The thing I will retain is the yearly. So let's redo this in some senses very quickly. So you'll do = sign PMT, right? And then you enter 0.06, N is 5, and PV is 100,000. And the answer you will get, is I'm just looking over to make sure. 23,739.64. Okay. So 23,739.64. We did this problem before. What I'm going to do is retain the ease of calculating this. By that I mean yearly payments. Even though we'll make it more complex. So let's see one of my most nifty ways of teaching finance. Stare at the screen and you'll find something called an amortization table. Now this will sound really complex but it's not.
I will walk through this with you, with this problem to teach you how a loan works. So, what is beginning balance? Just let me explain. So year is one, two, three, four, five.
Following convention, everything is happening at the end of the period. So when we say yearly payment, it's not happening at time zero. It's happening at time one, two, three, four, five, yeah? But it's very important to remember that this is the beginning of the period too. So, the beginning balance that you notice on top, what will it be in the first year? That's the amount you start off with. So, let's write it out. 100,000. What I'm going to do now here is work through how the loan works and you, if you have the desire start doing this in Excel because you can set it up very well in Excel. Question is, 100,000 beginning, now what is the yearly payment?
We already know it. Another word for this is PMT. And remember, we solved that number to be 23,739.64. Again, if I make some errors, I'm going to try to catch them. If not, just say, Gautam is a bozo. I know how to do this. So just write it out, 23,739.64. What I like about the amortization table is not the table in itself, but how it works gives you a sense of how things are working in real life. Now every payment, virtually every payment has two components. And sometimes one of the components is zero. But we'll talk about that later. So what are the two components? The first component is Interest.
The second component of this yearly payment is Principal Repayment because that's how it works. You pay interest for the use of money, but then you also pay some of the money you bought, or 100,000. Because if you don't do that, you'll be in what is called an interest only loan, and the loan will stay forever. There are things like that, but let's stick with the most normal stuff, which is, so how much is interest? So the way to work this out is, you know the annual interest is 0.06, right? Interest rate. But how much is the interest you are paying in terms of dollars? This times the beginning balance.
So interest is how much is the percentage rate determined by the marketplace given to you by the bank, and how much did you borrow at the beginning of the period, right? Because the interest is for the use of the money. So how much is this? 0.06 times 100,000 is 6,000. Very simple, but please remember that interest is a function that you pay at the end of the year, the cash flow is a function of what you borrow at the beginning. Then, well, how much is principle repayment? Very simple. Take this yearly amount and subtract 6,000 from it, so how much is left? 17,739.64. So now what's the next step?
So you have done one payment at the end of the first year, you know you've paid an interest of 6,000, but 70,739 is what you've paid on the beginning balance. So what's the beginning balance at the beginning of year two? Beginning of year two, beginning balance sounds pretty mouthful. It is this number. Subtract Repayment from it. How much are you left with? 82,260.36. I'm gonna be a little painful. As I said, I'm going to do these problems with you, so 82. How much are you paying at the end of the second year? Same amount.
So think of this amount as a contract. Think of this amount as a contract you're paying. Now question is, how much interest are you, is the component of this 23,000? Has it gone up or down? It's gone down because 6% of 100,000 is more than 6% of 82,260. How will you figure out the interest component? Again, simple. Take 6% interest and multiply the beginning period balance. And I'm going to write it out because it's a little bit more difficult than multiplying 6% with 1,000. 935.62. Right? I know I'm in the right direction, because the number is going down, right? [LAUGH] How much am I repaying now? Think about it, I'm repaying more or less?
I'm repaying more, because the payment I'm making is fixed and the interest has gone down. So the amount I'm repaying is 18,804.02, right? As I said, you can this by yourself. You can now set up, I've done enough. You can set up a spreadsheet which actually models all of this. Right? It's very, very simple. You start off with the payments. That's fixed, so let me just write these all down.
Right? So you've got all the payments that you're paying fixed amounts every year. What's changing is everything else in the table, but in a very systematic way, right? That is, the interest is going down and the principle is going, repayment is going up, until what's happened at the end of year five? You've paid off everything. So let me quickly enter these numbers, 63,456.34. How did I get that? I took 82,000 and subtracted 18,800 from it. Right, what will this be? This will be a number less, it's about 3,807.38. And I'll have a number here that's higher than 18, and it's 19,932.26. I'm talking so that you can compensate [LAUGH] for my bad handwriting.
Sorry, I'm laughing, but it's kind of funny to me. This is 43,524.08. This is 2,611.44. And this is 21,128.20. This number is this number minus the repayment, which is 22,395.89. You pay this. Interest is 1,343.75 and 22,395.89. What is the cool thing about it? This amount and this amount are equal. Which means what? The beginning of balance at the beginning of year six, which is end of year five, how much do you owe the bank? Nothing. So the thing to remember here is please use Excel and create this. Take the time to do that, you'll feel very cool.
This is one application where I will now take a break because I want you to work on this, create the Excel spreadsheet, we'll come back and then have some fun with this, and I'll show you how beautiful finance can be.
This article is from the free online

Finance for Everyone: Smart Tools for Decision-Making

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now