Question

In: Finance

You borrow $1,500 at 12% (M) and owe $1,741.45 on the due date. What is the...

You borrow $1,500 at 12% (M) and owe $1,741.45 on the due date. What is the term of the loan? Round the answer to n to a whole (i.e. n = 13.999 = 14, n= 4.00005 = 4) - do this before you convert to years and months. Answer in years and months (use zero if no years or no months).

Solutions

Expert Solution

Here PV = 1500; rate = 12%/12 (as M or monthly); FV = $1,741.45. PMT = 0.

We have to compute the nper and the formula will be: NPER (12%/12, 0, -1500, 1741.45)

This will give a value of 14.9998. This will be rounded to nearest whole i.e. 15. Thus n = 15 (in months)

This is in months and hence in years and months =1 year 3 months (15 months = 1 year + 3 months or 1.25 years)


Related Solutions

You borrow $1,600 at 6% (SA) and owe $2,026.83. What is the termof the loan?...
You borrow $1,600 at 6% (SA) and owe $2,026.83. What is the term of the loan? Round the answer to n to a whole (i.e. n = 13.999 = 14, n= 4.00005 = 4) - do this before you convert to years and months. Answer in Years and Months (if years or months are zero, place 0).
You owe suppliers balances at 90 days + past due for contract work. -What is the...
You owe suppliers balances at 90 days + past due for contract work. -What is the purpose of a Mechanics Lien for vendors demanding payment?
1) To borrow $1,500, you are offered an add on interest loan at 8.4 percent with...
1) To borrow $1,500, you are offered an add on interest loan at 8.4 percent with 12 monthly payments. Compute the 12 equal payments. 2) Use the amount you borrowed and the monthly payments you computed to calculate the APR of the loan. Then, use that APR to compute the EAR of the loan. 1-? 2-?
assume you borrow $ 15000 for 42 monthsat 10.5% interest, a. how much will still owe...
assume you borrow $ 15000 for 42 monthsat 10.5% interest, a. how much will still owe after the 17th payment? b. how much are your monthly payments? c. how much will you have pain in interest by the 17th payment?
Recreate the above in excel. You seek to borrow $1,500 from a friend to cover your...
Recreate the above in excel. You seek to borrow $1,500 from a friend to cover your gym fees. You promise to repay the loan in 24 monthly repayments commencing today. If the effective annual interest (EAR) rate is 20.6% what is the amount of the monthly repayment? (answer do not include $ sign; show cents eg 100.00)
Determine Due Date and Interest on Notes Determine the due date and the amount of interest...
Determine Due Date and Interest on Notes Determine the due date and the amount of interest due at maturity on the following notes: Date of Note Face Amount Interest Rate Term of Note a. January 10* $40,000 5% 90 days b. March 19 18,000 8 180 days c. June 5 90,000 7 30 days d. September 8 36,000 3 90 days e. November 20 27,000 4 60 days *Assume that February has 28 days. Assume 360-days in a year when...
our company plans to borrow $12 million for 12 months, and your banker gives you a...
our company plans to borrow $12 million for 12 months, and your banker gives you a stated rate of 21 percent interest.      Calculate the effective rate of interest for the following types of loans.      a. Simple 21 percent interest with a compensating balance of 12 percent. (Use a 360-day year. Input your answer as a percent rounded to 2 decimal places.)    Effective rate of interest %       b. Discounted interest (with no compensating balance). (Input your...
If you don't file your tax return by the due date and assuming that you money,...
If you don't file your tax return by the due date and assuming that you money, you would be hit with two penalties: failure to file and failure to pay. The failure-to-file penalty is equal to 5% of the taxes you owe for each part of a month you're late, up to a maximum of 25% of unpaid taxes. Therefore, this penalty reaches its maximum after a 5-month filing delay. For example, if you're two days late with filing and...
What is the normal due date for the tax return of​ calendar-year taxpayers? What happens to...
What is the normal due date for the tax return of​ calendar-year taxpayers? What happens to the due date if it falls on a​ Saturday, Sunday, or​ holiday? A. The normal due date for​ calendar-year individuals, partnerships and​ calendar-year corporations is April 30. The normal due date is delayed to the next Tuesday that is not a​ Saturday, Sunday or holiday. If the normal due date falls on​ Saturday, Sunday, or​ holiday, it is delayed to the next Tuesday. B....
Determine the due date and the amount of interest due at maturity on the following notes....
Determine the due date and the amount of interest due at maturity on the following notes. When calculating interest amounts, assume there are 350 days in a year. Note Issue Date Amount Interest Rate Time(Days) 1.   Jan. 20 $100,000 6% 30 2. March 10 $50,000 3% 60 3. May 15 $85,000 4% 45 4. Sept. 21 $90,000 7% 90    5. Dec.1    $75,000   8% 120 Note Due Date Interest on Note Maturity Value Select an answer: a. Feb. 19,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT