Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If Philco borrows $60,000 from a loan company at an interest rate of 3.5% per year compounded continuously, and plans to make a payment of
If Philco borrows $60,000 from a loan company at an interest rate of 3.5% per year compounded continuously, and plans to make a payment of $950 per quarter, how may years will it take him to pay off the loan? | ||||||||
PV | $60,000 | |||||||
Rate | 3.50% | pycc | ||||||
PMT | ($950) | pq | ||||||
Nom Rate | pqcc | |||||||
NPERY | cc per qt | |||||||
Effect | pqcq | |||||||
NPER | quarters | |||||||
Years |
What functions will I use for the Nom Rate, the NPERY, the Effect and the NPER. what will be the amount of years if done in excel
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