Тёмный

How to Calculate Monthly Payments in Excel with PMT Function 

Excel University
Подписаться 43 тыс.
Просмотров 43 тыс.
50% 1

Опубликовано:

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 13   
@MutualFundsFunda
@MutualFundsFunda Год назад
nice
@mohdrahmatmohdnoordin1736
@mohdrahmatmohdnoordin1736 Год назад
i hv a questions... if loan amount is 10k, annual int is 4%, tenure 5 yrs... montly should be 200... why pmt value is 184.xx is the formula wrong...
@arshadhkabeer
@arshadhkabeer 8 месяцев назад
The PMT is calculating the period with 30 days per month, which is 360 days per year, I think this is the problem, there should be a solution for this, let me know if you have any.
@danteencinas7020
@danteencinas7020 Месяц назад
Thank you for the excellent & concise explanation!
@rickbolner8909
@rickbolner8909 6 месяцев назад
Good job: quick, informative, even covered some theory--"shows up negative because it's shown as a cash outflow. . , something like that. thanks,
@josealvesferreira1683
@josealvesferreira1683 Год назад
Very good, congratulations.
@ExcelU
@ExcelU Год назад
Thanks!
@shayalsharma677
@shayalsharma677 5 месяцев назад
wow, you have really helped me in one of my assignments, thank you sir
@robertross3188
@robertross3188 Год назад
What about if your starting off with a loan that already has accumulated unpaid interest? How do you calculate the monthly payment without the added interest affecting the rate that is only charged based on the principal and not the principal + interest?
@TheShayre
@TheShayre 2 месяца назад
Awesome!!
@draincel
@draincel 7 месяцев назад
EXCELLENT
@PrintSales
@PrintSales 11 месяцев назад
Excellent explanation, Thank You.
@ExcelU
@ExcelU 11 месяцев назад
Glad you liked it
Далее
Microsoft Excel Tutorial: IPMT Function
3:58
Просмотров 49 тыс.
Почему?
00:22
Просмотров 238 тыс.
DAXSHAT!!! Avaz Oxun sahnada yeg'lab yubordi
10:46
Просмотров 388 тыс.
КВН 2024 Встреча выпускников
2:00:41
How To Calculate Monthly Payment With Excel
10:28
Просмотров 9 тыс.
Can You Pass This Excel Interview Test?
11:20
Просмотров 918 тыс.
Use the PMT, IPMT & PPMT Functions
5:43
Просмотров 107 тыс.
The Ultimate XLOOKUP Tutorial (The Best Excel Formula)
11:03
Почему?
00:22
Просмотров 238 тыс.