June 25, 2016
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?
July 16, 2010
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.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas