Question
You want to borrow $100,000 and can afford to pay $1,497.75 per month, how long should it take (in months) to pay back this loan
You want to borrow $100,000 and can afford to pay $1,497.75 per month, how long should it take (in months) to pay back this loan at 3.75% annual interest rate?
1. Put in the =PMT function opposite Monthly Payment with 1 (one) as the Term in Months.
2. Then use Goal Seek to find the number of months using $1,497.75 per month as the desired payment. Note: payments are negative amounts.
3. Once you have the Term in Months, use the schedule on the right hand side to put a formula in under Interest Paid using the CUMIPMT function. This will then give you the amount of interest paid each month. Make sure that your schedule is long enough to cover all months that you have determined in step two.
4. Use a formula to calculate the principle paid each month.
5. Use a formula at the bottom of the Interest Paid column to calculate the total interest paid.
You want to borrow $100,000 and can afford to pay $1,497.75 per month, how long should it take (in months) to pay back this loan at 3.75% annual interest rate? 1. Put in the EPMT function opposite Monthly Payment with 1 (one) as the Term in Months. 2. Then use Goal Seek to find the number of months using $1,497.75 per month as the desired payment. Note: payments are negative amounts. 3. Once you have the Term in Months, use the schedule on the right hand side to put a formula in under Interest Paid using the CUMIPMT function. This will then give you the amount of interest paid each month. Make sure that your schedule is long enough to cover all months that you have determined in step two. 4. Use a formula to calculate the principle paid each month. 5. Use a formula at the bottom of the Interest Paid column to calculata theepest peres Raidple Paid otal Payment 1 $0.00 2 $0.00 3 $0.00 Amount of Loan 100,000.00 4 $0.00 Term in Months 1.00 5 $0.00 Annual Rate 3.75% 6 $0.00 Monthly Payment 7 $0.00 8 $0.00 9 10 $0.00 Total Interest Paid $0.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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