Excel Finance Functions: PMT() • PV() • RATE() • NPER()

[@roseannahenwood2709]

It took me 5 hours to find your video and 2 minutes to finish my assignment! Thank you for making it easy!

[@SinjBobSweatPants]

This man should be put in a museum for being an absolute treasure

[@kpfreed]

The best excel finance function video on all of youtube - exactly what I needed!

[@brendanwebb5974]

Absolutely amazing video!! I was struggling to make an amortization table for a very long time and I finally understand what I was doing wrong. I wasn't locking functions with $, and also wasn't careful about where I got certain values from out of the table.

[@stephenphan2761]

Love the way you switch between all functions to let it easy track off and understand deeply. Some short cut introduced, too. Impression. Thanks

[@aprilmoe3810]

Thank you, you made it very easy to understand how these formulas work in excel. I am quite new to excel and your Video helps me a lot to understand.

[@lisagagnon4049]

wow this helped me so much to understand these functions great job keep up the good work

[@paulseldn]

I fixed it. You only supposed to format for the rate or percent cell after you have done the rest of the sheet....Many thanks for a great video :)

[@SeKrEtOrOsA]

Im taking an Excel Intro to Spreadsheets and all the students (me included) are lost...it is an asvance course. Im definitely going to be in need of your videos to try to pass this class.

[@jayaganthan1]

Awesome explanation. Thanks dude.

[@piyumiimalka8757]

Today i have my semester exam.thank u..i got a sound knowledge .thank u

[@thatgirlsandra]

Excellent explanation. Thanks!!

[@allegri9cl]

Great video and explanation skill.. very v helpful. TY

[@ta9967]

excellent work, great value, keep it up

[@we3605]

Wonderful. Just appropriate. To the point. :)

[@ukemeisaac]

Great value! Thank you Sir.

[@shirleyliao9960]

Great video! Thank you!

[@sklee1644]

Why do we have to formulate the Pv, rate, and NPER if we really want to get monthly payment?

[@allegri9cl]

When calculate rate, my function gave #Num! Error. After some research found out pmt or pv has to be in minus. I saw you did not put minus but did now get any error. May I please know how?

[@paulseldn]

when i insert the rate formula in cell D5, my 4% just vanishes leaving me with a âNUM! error. How do you enter the formula without losing the 4% please?

[@gloriouz89]

Excellent my man. TY

[@ta9967]

quickly, why my amortization table is not coming to zero (360th installment) even with the same data as you keyed in.

[@soodvarun20]

The Excel practice file is not opening... provide the correct path..

[@derbyjakemalazarte8973]

how to get the annual interest rate, if you are paying every 10 days or 3x monthly

[@dh1713]

Thank You (:

[@veliem3935]

There are many ways to kill a cat, and I loved how he killed this one!!

[@ArthKryst]

can we do reverse of it?

[@yeexuenshyuenne5153]

May I know what do you mean “double click it down”? I cannot let the excel automatically calculate until “0”

[@sanishtv]

Its a short cut to fill the same formula down to the end of the range. when you select the first row , u will find the tiny + button at the bottom right of the selection. then you can Double click on it to apply the same formula to the down..Hope you might have understood by now

[@thuraroblox2442]

What is F4 mean? F4 in my laptop is to up to light

[@hollyt5671]

God bless you

[@nfrazier911]

So clear.

[@quanganhngominh3954]

nice video

[@emmalournet2667]

my does in negative numbers, why?

[@aymanrabee6038]

NICE VIDEO

[@westfield90]

Superb

[@marlonasas1158]

Need help i need someone to answer my activity like calcute the proper financial fiction😴😢

[@marlonasas1158]

Proper financial function

[@shobhanapatel4113]

When I do it I get - not Bearcat also I get -477. 42 not 477?

[@ferasbankosli3224]

Off course... you have to decrease Decimals.. the actual number will stay 477.42 but will appeared as 477.

[@hasanbarzani4495]

wooow

[@sarojpokharel7275]

my pc does not take

[@tayyabajaved3419]

lone bal =C15-F15=99856 IS TRUE not C15+F15 NOT SUM THIS VALUE

[@tayyabajaved3419]

Tell me this value formula