Question
How do i figure out the total interest paid for the entire time and then the total payment Lender 1 Lender 2 Lender 3 Principal
How do i figure out the total interest paid for the entire time and then the total payment
|
| Lender 1 | Lender 2 | Lender 3 |
| Principal
| 100,000.00 | 103,000.00 | 99,000.00 |
| Annual Interest Rate | 4.13% | 4.05% | 3.70% |
| Number of Monthly Payments | 360 | 400 | 320 |
Add formulas for the
- Monthly Payment =PMT((Annual Interest rate/12),Number of monthly payments,-Principal,0)
- Interest =IPMT(Annual Interest rate,1,Number of monthly payments,-Principal)
- Total Payment =Principl+Interest
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Day Trading Strategies And Risk Management
Authors: Richard N. Williams
1st Edition
979-8863610528
