in this video we” re going to work through the finance and Excel part one that is located in your lab publication so the purpose of this part in Excel is to reveal you just how to use the FV function and the FV function is the future worth function and we can utilize it to determine the future value of some sort of interest-bearing accounts and your book has solutions that you can utilize there in the PowerPoint and they” re likewise shown on your laboratory book in the initial paragraph or so and you” re welcome to use the formulas if you number out exactly how to use them and you like using them you” re welcome to do so however I.
think most students find that the FV feature once they figure it out is. actually much easier and quicker and you” re less most likely to make computation errors.
and I discovered that trainees that use this FV function do far better on the last examination.
In the last exam then students that attempt to do it by hand utilizing the formula.
it” s your selection so in this formula we have a lot of various variables and.
the first thing is P which is the principal it” s how
much money goes in. the account and after that APR is the annual percentage price that” s just how much rate of interest. the financial institution is paying you in stands for the number of times annually that your paint.
rate of interest and why is the variety of years that the cash” s in the account. therefore we” re gon na make use of all of that info to find out just how much money.
you” ll contend some point in the future so once again we” re gon na you see how we do. the FV feature and I” m going to create a chart so in my chart I ‘ m gon na list. out my APR a PR and Y PMT P and at the bottom of the future value and on the. test we ‘ re going to give you the formula that you see it ‘ s type of near the. base of the initial page it ‘ s in vibrant it claims amounts to as the parentheses pierre. separated by n comma n times y comma adverse PMT comma P close parentheses. we ‘ re gon na give you that formula on’the examination we put on ‘ t anticipate you to memorize. that that ‘ s what we ‘ re gon na be collaborating with and the way I’established the chart is. I ‘ m primarily looking inside the parentheses and detailing those worths in.
order so APR came first and after that end and after that why the adverse PMT.
MP so I” m simply noting those out in order and afterwards FV is the future worth.
that” s just how much cash I ‘ m mosting likely to have that” s at the bottom since that” s what. this formula is determining so once I type of obtain my chart established up currently I type.
in the formula so I” m gon na do it’precisely as it ‘ s created and once again you.
put on” t need to memorize this’we ‘ re gon na give it to you’however I ‘ m going to do. amounts to FV after that open parenthesis after that cell reference the APR cell separated by.
the n cell comma after that you” re in cell times your Y cell comma the unfavorable PMT. comma adverse P close parenthesis and the greatest error I see is that.
students leave off the adverse indications they make a difference with the means.
Excel assumes if you end the adverse indications you” re going to get wrong.
responses so we” re going to offer you that formula on the examination you don” t need to. remember it and I developed my graph by simply placing those inputs in order and.
The future values at the base and after that I” m using cell referrals to place.
all those worths into my FB feature and the very first time you do this that” s kind. of like whoa but as soon as you do it a pair times it” s actually not that bad and by.
last test times ideally you” ll find this type of very easy so allow” s see exactly how we’. use it ‘ s now that we ‘ ve got it enter so it claims treasure down payments$ 3,000 into the. account he has an APR of 1.5 %compounded daily establish the balance in 10 years. thinking no additional down payments or withdrawals so let” s fill up in what we. recognize our APR is 1.45% n is the variety of times annually that. he” s paid rate of interest given that he ‘ s paid interest daily there ‘ s 365 days
in the. year so I ‘ m going to place that in as 365 days like they” re paying him every.
solitary day they” ll pay him 365 times why is the number of years so that” s 10 PMT. represents a month-to-month repayment and for this first section we” re going to sing. that nobody” s including the additional money so that” s 0 and then FV I suggest P is the.
principle just how much cash he places in originally which is 3,000 and after that it” s. mosting likely to calculate exactly how much cash he has total.
shut off my stand out students welcomed for me.
alright so um once again we placed in our rate of interest we placed in the variety of.
times that rate of interest is compounded in the number of years we” re not including any. money some regular monthly repayments are absolutely no primary is the first money he.
places in and afterwards that” s going to tell us just how much cash Jim ‘ s mosting likely to have after.
Ten years and Excel does all the mathematics for you and it spits out the insert that” s. truly good you just established up your graph put in the numbers and you get your.
value so generally what I would do is simply drag my formula over and maintain making use of.
it but I intend to reveal you how to establish it up again just for practice so once again we.
have our formula what you” re offered and I ‘ m simply putting these values in a graph. in the order that they reveal up inside the formula and afterwards to place it in Excel. I kind equals FV open parenthesis APR separated by n comma n times Y comma.
adverse PMT comma negative P close parenthesis get in so now we” re established if.
we can do it some even more and I” m in fact mosting likely to go and drag.
this over a couple places so I wear” t retype it and now you” ve seen it a. couple times so the table the next web page that claims Andrea wants to understand just how much.
If she deposits, money she will certainly have in five years so right away 5 years.
her $500 right into an account so she” s depositing five dollars into an. account that pays a rates of interest of 2.2% so I” m placing that into my APR. compounded monthly well there ‘ s year in a year so she
‘ s gon na earn money. passion twelve times and after that we ‘ re not adding any extra money to the account so.
we can see that at the end of five years andrea will have 5 hundred and fifty.
8 dollars and eight cents that” s respectable all right so after that sort of at.
to the right of the Excel box in the middle of the page it states Andrea.
modifications her mind and determines that instead she would like to know the length of time the.
money must continue to be in the account to have a future worth of a thousand dollars all.
This one” s various currently she wants one thousand. bucks and she wishes to know the length of time is it great is it gon na take so if you. discover the inquiry that says just how lengthy must it stay in there.
that means we” re attempting to find out why so we ‘ re gon na recognize the future value. were trying to find out why this is gon na be a gold seed inquiry so.
everything” s the very same in this account is still 2.2 percent passion she” s still. making money regular monthly she” s still putting her 5 hundred bucks in yet she.
needs to know for how long is it going to be up until she has a thousand dollars so what.
we wish to do is objective seek our future worth to a thousand by altering the.
variety of years given that your own is the variable claiming how much time is it going to.
take so we” re gon na guess and examine a whole lot of various variety of years.
up until we obtain a thousand bucks so I” m going to start by clicking on that.
future worth formula and after that go up to information what happens if evaluation goal seek I need a.
thousand dollars by changing the variety of years therefore it says in thirty-one.
point 5 4 years she will have a thousand bucks so not the best financial savings.
strategy ever before yet it” s money it ‘ s much better than nothing after that at the base of the.
page it claims in a similar way Andrea intends to have an equilibrium of 6 hundred bucks.
and only seven years seven years we wish to find out what is the APR to reach.
that value in seven years so we” re thinking that still paid month-to-month she” s. still pending $500 and yet this time around it” s saying what is the APR called for to.
get that quantity of cash so once again this is goal seek we understand that certainly quantity.
we want 7 hundred no 6 hundred we want 6 hundred dollars by altering the.
APR so I” m gon na begin in my formula data what-if evaluation objective seek we desire.
6 hundred bucks by altering the APR we would like to know what APR must she reach.
get 6 hundred dollars in 7 years and we see that.
you transform that to a percent she requires 2 point 6 one percent to have 6.
hundred bucks in seven years that” s not also bad so we ‘ ve obtained 4 more.
questions let” s just undergo these appropriate quick I” m gon na drag my cell over.
so I” ve got four places to function so it claims Mario down payments before that.
Mario is a money market interest-bearing account with an APR of 3.75 percent compounded.
regular monthly and as soon as these 12 times a year let” s go and kind that in I assume this.
is the same worth for all of them so I” m gon na go on and complete so I” ve
obtained. all four spots to operate in Excel so the first one says Mario down payments $1,500 currently.
and doesn” t touch the account so he ‘ s not including anything to it just how much will.
he have in 3 years this one” s quite basic we can plug every little thing in and we.
can see in three years he” ll have one thousand six hundred seventy eight.
bucks in 30 months cents number 2 states Mario deposits fifteen.
hundred bucks currently and doesn” t touch the account the number of years should he leave.
the money to have a future value of two hundred or 2 thousand dollars so again.
it” s asking how lots of years we” re attempting to resolve for y so we need to objective look for.
or account to two thousand bucks so data what-if evaluation objective seek we desire.
it to be $2,000 if I” d seen how several years it” s mosting likely to take and we claim that.
it” s gon na take Mario seven point 6 eight years to reach two thousand. bucks if nothing changes number 3 states Mario down payments fifteen hundred.
dollars currently into an account and doesn” t touch the account it” s positive fifteen.
hundred it” s not including anything to it what rates of interest intensified monthly.
would he need to get to 2 thousand bucks and 5 years okay so.
we” re trying to identify what passion rate we require to reach two thousand. dollars in five years so I altered my years to five and currently we” re gon na
go. look for the equation to two thousand the rates of interest to see what rate of interest.
it would take so we want 2 thousand dollars by altering the rates of interest.
and we see he would require 5 point seven seven percent to get 2 thousand.
bucks in five years last one Mario down payments fifteen hundred bucks.
right into an account that paid a yearly interest rate of three factor nine.
percent alright so we have three factor nine percent.
he” s transferring fifteen hundred bucks for something that he” s not gon na
do. anything else for all these issues states after 6 years 6 years he has a.
balance of 1893 dollars and 32 cents which is not what we have down below.
Chris says establish the method of compounding all right we” re trying to.
see worsening so I” m gon na that implies we ‘ re gon na want our in just how. often times pre your he” s paid passion so we need to see the number of times a year. he was paid rate of interest to obtain to the value in your lab book and we” re doing that by.
altering the number of times it” s worsened some do information what-if analysis objective seek.
we want our equation to be one eight 9 3 point 3 two by altering.
the variety of times that it is worsened and we see that it” s.
intensified four times annually yet four times a year we state is quarterly so he.
would certainly require quarterly compounding to get this amount of cash in six years.
I ‘ m essentially looking inside the parentheses and listing those worths in.
I kind equals FV open parenthesis APR divided by n comma n times Y comma.
This one” s various currently she wants one thousand.
