Calculate Loan Payments with Excel PMT Function

[vishnuvamshi]

Can you please help me to create a excel sheet for this case:-
I have a loan of ₹6Lac and earning salary ₹15k with every year of increment ₹3k and from that my expenses are per month ₹6k and the rest is used for clearing loan payment then how many years it took to clear the loan????

[ahorangistarchild]

I'm studying Business Admin and your channel helps me so much. You explain so well, straight to the point. You are always my go to.. Thank you!

[jacobodiong]

Great video! Your approach is simple and easy to follow. Kindly create a video on payroll. Thanks in advance.

[lawrencekazibwe]

Thanks alot Boss, it has been very informative

[shandell]

You want to see how fast I am? Let me get a notification from this gentleman, and I'll click on the video so fast, lol.

[shashankr]

Sir plz do hlookup, vlookup, xlookup newer version videos ASAP!!

[jennifertunacao]

How to compute using a manual calculator?

[CautiousSquirrel]

Great video, thank you! Would you consider doing something similar for calculating interest (and future balance) on a high interest/ high APY savings account? For example, how to determine how much interest will be earned over a certain period of time with consistent deposits each week/month. Let's say interest is compounded daily and applied monthly. I did find two videos about this, but I wasn't able to follow along as easily as I do when watching your tutorials.

[teciataylor]

Great video it was very helpful. I will share with anyone I know in need of more details solving this type of problem 😊

[tolgakiyak]

When you calculate back (which is on first example) 2835, 43*30*12= 1020754, 8 is the future value and when you divide it with primary value 1.020.754, 8/450.000= 2, 268344 (this is the 30 years rate . When you divide this number by 30 The annual interest rate shows 0, 0756 which is 7, 56% is not the same interest rate (6, 47%) . Where is the mistake ???

[Its_ani_]

Can you pls help to how to calculate weekly payment...?

[naniche]

Hello,

Could you please assist us to resolve this exempl,

I need an excel formula to split an amount over several cells while respecting the limit of each cell

eg:
A1 : 10000 $

I want to automatically split this amount to

B1 (MAX 200)
B2 (MAX 200)
B3 (MAX 250)
B4 (MAX 250)
B5 (THE REST)

Thanks

[AmitKumar-pztu]

Watching from India, the way you explained is amazing

[shesallaboutthebusiness]

Hi supposed if i want to use a bimonthly system instead of paying monthly. I would replace the 12 with a 26, is that correct?

[handriana]

Hello! How we can calculate loan payments with residual value at the end of perriod?