anuradhagrewal
Board Regular
- Joined
- Dec 3, 2020
- Messages
- 85
- Office Version
- 2010
- Platform
- Windows
Hi
I am trying to make a EMI calculator with the PMT formula
Lets say I have the following variables
A1= Loan Amount
B1= Duration
C1= Rate of Interest
I need to make a table with the projections based on the following parameters
1) Let say there is a loan of Rs 1,000,000 and the EMI for a duration of 84 months will be Rs 16089.
2)I get a table of the interest and Principal paid too.
3)What I want is a formula where if I say increase the EMI payment by Rs 100 onwards what will be the total interest payable and how much less will be the loan duration
I am unable to figure out how to do it.
Can anybody please help.
Regards
Anu
I am trying to make a EMI calculator with the PMT formula
Lets say I have the following variables
A1= Loan Amount
B1= Duration
C1= Rate of Interest
I need to make a table with the projections based on the following parameters
1) Let say there is a loan of Rs 1,000,000 and the EMI for a duration of 84 months will be Rs 16089.
2)I get a table of the interest and Principal paid too.
3)What I want is a formula where if I say increase the EMI payment by Rs 100 onwards what will be the total interest payable and how much less will be the loan duration
I am unable to figure out how to do it.
Can anybody please help.
Regards
Anu
