Welcome back. In this video, you'll learn more about Microsoft excel in particular are really like reading a formula to compute monthly payments of here to buy a new
Car or use car or house into the interest rate the duration of the loan the loan amount with teacher multi payments.
And then we're going to go ahead and find we've got a range of numbers going to find out how many of these temperatures in these four cities are above 90 and then we'll go ahead and find out how many
Entries are there and which point, we're not going to this one is blank. And this was blank. So it's like 1-234-567-8910 okay well let's go ahead and get started. So the first step. I'm gonna do is open up Microsoft Excel.
In women are somewhat data. So here at the very top of the type interest rate.
If I double click on one of these tabs.
Then my toolbar will be visible which point, let me just give a little bit larger font size here for you.
Some type interest rates and then be let's assume it's okay with an eye percent of its kind of high percent interest rate.
And type into yours.
Let's say you want to pay this out over five years to get a new car this car public facility 15,000 like I have here a little amount
And we'll put in 15,000
Okay, at this point, if you wanted to, we could put a big thick border underneath his
bottom border and now new type is a monthly
Payment
Okay, maybe I'll even put a border going this direction, I'll put a recording. Okay, so if I want to buy a new car or use car make a purchase for $15,000 I want my
Payments to last for five years, interest rate is 9% annual rate. What are the monthly payments to do this summer simply use the TMC function type equals TNT.
And the first one is going to be the rate in that this is resting 9% that's an annual interest rate. So I need to compute the rate per month. So that's going to be be one.
Divided by 1212 months in the air next would be the number of payments. So I had put months here that I want to have to do this multiplication, but since I've got yours. I'm going to take what's in be
Too long. Multiply by 12 to get two months. And then finally, the next parameter is the loan amount that's going to be the three
Okay. So if I was to want to purchase a used vehicle for 15,000 spread my payments out of her five years 9% interest rate. There's so much are we paying every month $311. Okay, next one is going to be some data here. Oops.
Okay, well go ahead over some of the data.
Type
City 123
City form.
This was day one.
Day two
Day three
Okay, we go ahead and put a little border over here on the left.
And I bought her up here.
OK, now let's go ahead and enter some Adidas imma leave a couple of them blank. So if I want to match up what I had displayed earlier winner up some numbers here.
In 92 day three day five.
Blank period and then through ok so now I'm gonna come on down here attacked by a number
Of
Temperatures above
90 here, Nick. I'm going ahead and highlight that data. I'll go ahead and merge that and then right, why not. Okay. So if I want to count.
Above so it doesn't look like I can 9591 2345. Okay, let's go ahead and I specify this use of the formula somebody go account yet.
And part of the reason for this particular exercise for to illustrate that those formulas don't have to be
Either a horizontal or a perfect vertical line they can actually be more of a rectangle can shape your summer to take a look. I'm looking at v.
Seven colon D 10 and as soon as I do that I always like to take a look and I can see this kind of, it's got a blue outline around it.
It's kind of shaded slightly blue. So before I move on, I want to make sure to specify the correct rate, which I have and then we're just going to put greater than 90 above 90 so I don't even have the equal sign.
Oops.
Greater than finding. Okay.
So if I wanted to make it to number temperatures greater than equal to 90 I've had to put an equal sign here, so I got above greater than nine. So I've got 1234 and five. Okay. And one more than formula number of interest.
So again, I'm gonna highlight that Merchant Center could put that off to the right and now this one was using the accounting function. This was just going to be an account function. Some use account to specify the range be seven column.
D 10 obviously kind of visualize. Make sure your, your feedback is correct and then hit enter and turned up at 10 interest 1-234-567-8910
So again, the power of Microsoft Excel is what if I come along and change this, we're going to insert one here, you know, put it above 90 so put it in 95
hit upon doing so I can see I've now got six temperatures credit the 90 and I've got 11 interest.
Well, hopefully this video you learned a little bit more about Microsoft excel in a particular using the PMT function.
To generate or calculate monthly payments and then also we used a couple accounting function on a range that was more of a rectangle and also the count function just determine how many entries or there. Okay. Thanks. Thanks.