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

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

Steve Crute

8 лет назад

144,598 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

D H 17
D H 17 - 10.10.2023 15:55

Thank You (:

Ответить
april moe
april moe - 09.09.2022 04:01

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.

Ответить
Derby Jake Malazarte
Derby Jake Malazarte - 16.08.2022 18:55

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

Ответить
Jayakanthan R
Jayakanthan R - 03.07.2022 12:39

Awesome explanation. Thanks dude.

Ответить
allegri9cl
allegri9cl - 04.05.2022 04:45

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

Ответить
Marlon Asas
Marlon Asas - 02.05.2022 14:13

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

Ответить
SeKrEtOrOsA
SeKrEtOrOsA - 09.02.2022 09:05

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.

Ответить
Varun Sood
Varun Sood - 09.01.2022 08:12

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

Ответить
Sk Lee
Sk Lee - 12.12.2021 02:05

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

Ответить
emma lournet
emma lournet - 05.12.2021 21:58

my does in negative numbers, why?

Ответить
thatgirlsandra
thatgirlsandra - 01.11.2021 03:03

Excellent explanation. Thanks!!

Ответить
Yee Xuen Shyuenne
Yee Xuen Shyuenne - 24.08.2021 11:01

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

Ответить
Thura Roblox
Thura Roblox - 12.06.2021 15:35

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

Ответить
Hassan Ansari
Hassan Ansari - 03.03.2021 11:09

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

Ответить
Hassan Ansari
Hassan Ansari - 03.03.2021 10:36

excellent work, great value, keep it up

Ответить
Holly T
Holly T - 17.12.2020 17:05

God bless you

Ответить
Ukeme Isaac
Ukeme Isaac - 02.12.2020 13:32

Great value! Thank you Sir.

Ответить
Veli Em
Veli Em - 13.10.2020 20:23

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

Ответить
Anish kr
Anish kr - 11.10.2020 14:34

can we do reverse of it?

Ответить
N Frazier
N Frazier - 08.10.2020 04:35

So clear.

Ответить
Roseanna Henwood
Roseanna Henwood - 22.09.2020 03:28

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

Ответить
Shobhana Patel
Shobhana Patel - 08.04.2020 01:34

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

Ответить
piyumi imalka
piyumi imalka - 11.03.2020 07:44

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

Ответить
Lisa Gagnon
Lisa Gagnon - 24.10.2019 03:32

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

Ответить
paulseldn
paulseldn - 15.07.2019 23:51

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 :)

Ответить
paulseldn
paulseldn - 15.07.2019 20:03

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?

Ответить
Saroj Pokharel
Saroj Pokharel - 07.06.2019 05:59

my pc does not take

Ответить
Stephen Phan
Stephen Phan - 21.04.2019 13:10

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

Ответить
Stjohn Black
Stjohn Black - 06.04.2019 11:51

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

Ответить
Quang Anh Ngô Minh
Quang Anh Ngô Minh - 28.03.2019 14:32

nice video

Ответить
Ayman Rabee
Ayman Rabee - 29.01.2019 12:54

NICE VIDEO

Ответить
gloriouz89
gloriouz89 - 16.01.2019 08:31

Excellent my man. TY

Ответить
westfield90
westfield90 - 11.01.2019 16:53

Superb

Ответить
hasan barzani
hasan barzani - 25.11.2018 20:43

wooow

Ответить
We360
We360 - 04.05.2018 10:13

Wonderful. Just appropriate. To the point. :)

Ответить
Shirley Liao
Shirley Liao - 08.03.2018 21:16

Great video! Thank you!

Ответить