Question
Monthly loan payments are $610. The lender charges 1.01 percent per month interest. Hint: The interest rate is already monthly so you don't need to
Monthly loan payments are $610. The lender charges 1.01 percent per month interest. Hint: The interest rate is already monthly so you don't need to divide it by 12, just move the decimal two places to the left to place it in decimal form, for example 0.91% is .0091 in Excel. The payments are already monthly so don't mutiply them by 12. Since you've set it up monthly, the resulting number of periods that Excel calculates is the number of months. So you don't need to adjust that either.
Required:
If the loan amount is $14,830, how many months until the loan is repaid in full? (you need opposite signs on payments and present value) ( Round your answer to 2 decimal places (e.g., 32.16).)
Number of months: _____________
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