Notifications
Clear all
Topic starter
Hi there,
Say hi to excel expert here
I want all of you to help.
I want to make schedule loan EMI.
Assume I have loan $50000,Tenor 36Months,interest rate 1.2% per month on 13November 2016
I want a schedule with date can skip Saturday,Sunday nd holidays.
How can? Could anyone here help me out?
Thanks 🙂
Posted : 13/11/2016 8:12 pm
Hi Rathanak,
You can use the PMT function for a loan schedule: https://support.office.com/en-us/article/PMT-function-0214da64-9a63-4996-bc20-214433fa6441?ui=en-US&rs=en-US&ad=US
Loans don't usually skip days since the money is still on loan on a weekend and holidays and payments are not typically paid daily.
Why don't you have a go yourself and if you get stuck then reply with your attempt in an Excel workbook.
Mynda
Posted : 17/11/2016 8:21 pm
Topic starter
Hi Mynda,
Thanks 🙂
Posted : 18/11/2016 3:07 am
