vikas_newports
Board Regular
- Joined
- May 26, 2016
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
I took a vehicle car loan for $777,700 at 8.85% for 7 years. I used PMT and got a monthly payment of $12,453. The bank has a payment of $12,473
I inquired the bank why the difference and they said it was the difference between 360 days vs 365. I don't know what is this.
How do I calculate it to get their monthly payment and make an amortization schedule with interest and principal?
I have attached my calculation in excel file and a calculation in pdf file from Bank end in a google drive link. link below
I inquired the bank why the difference and they said it was the difference between 360 days vs 365. I don't know what is this.
How do I calculate it to get their monthly payment and make an amortization schedule with interest and principal?
I have attached my calculation in excel file and a calculation in pdf file from Bank end in a google drive link. link below
Code:
https://drive.google.com/drive/folders/1ES3sUR_4fWgpaRr82L3TcGuQ-pwXF5ie?usp=sharing