While Jack was a student at the University of Georgia she borrowed $12,000in student loans at an annual interest rate of 9%. If Jack repays $1,500 per year then how long (to the nearest year) will it take him to repay the loan? Use an excel to understand the calculation

While Jack was a student at the University of Georgia she borrowed $12,000in student loans at an annual interest rate of 9%. If Jack repays $1,500 per year then how long (to the nearest year) will it take him to repay the loan? Use an excel to understand the calculation

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

ChapterM: Time Value Of Money Module

Section: Chapter Questions

Problem 11RE: Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the...

See similar textbooks

Related questions

Q: Ian loaned his friend $25,000 to start a new business. He considers this loan to be an investment,…

A: Calculation of annual payment and capital recovery schedule: Answer: The annual payment is $7,716.72

Q: Elin purchased a used car for $15,000. She wrote a check for $3000 as a down payment for the car and…

A: Equated monthly installment or EMI is referred to as the amount that are paid in monthly basis…

Q: Patricia has borrowed an amount of Sh. 4 million to start a boutique business in Kileleshwa . The…

A: A loan amortization schedule is used to indicate the amount of principal and interest paid for each…

Q: Jim made a down payment of 2500 dollars toward the purchase of a car. To pay the balance of the…

A: Given information: Down payment is $2,500 Nominal interest rate is 4% compounded monthly Payment of…

Q: John took a personal loan of $100,000 from the bank at a nominal interest rate of 6% per year…

A: Disclaimer: “Since you have asked multiple questions, we will solve the first question for you. If…

Q: Grandma Riley wants to help Scott while he's in college by giving him a S220 monthly allowance for 5…

A: Time Value of Money:The time value of money is the idea that the value of money received today will…

Q: Sandy Kupchack just graduated from State University with a bachelor's degree in history. During her…

A: In the given question, the amount is to be paid quarterly. Therefore, the effective rate to be used…

Q: Melissa Hernandez received an 8-year subsidized student loan of $24,000 at an annual interest rate…

A: Present Value of the Loan (pv) = $24,000Interest Rate (rate) = 4.1%Time Period of Interest not Paid…

Q: Carter bought a new car and financed $⁢25,000 to make the purchase. He financed the car for 60…

A: Loan amount (PV) = $ 25000 Interest rate = 5.5% Monthly interest rate (r) =…

Q: Dan opens a line of credit at a local bank, and immediately borrows 2080 dollars. 5 months later, he…

A: A financial instrument that provides never-ending borrowing and paying facility to the borrowers is…

Q: Ruby loaned 500,000 php in preparation for her daughter’s college education. The loan comes with 8%…

A: Note: This post has two questions, each with multiple sub-parts. The first question has been…

Q: While Mary Corens was a student at the University of Tennessee, she borrowed $14,000 in student…

A: It can be calculated using following function in excel =NPER(rate,pmt,pv,[fv],[type]) Rate The…

Q: Suzanne opens a line of credit at a local bank, and immediately borrows 1510 dollars. 5 months…

Q: Huai takes out a $3200 student loan at 6.7% to help him with 2 years of community college. After…

A: The act of repaying a loan, as well as the associated interest, is referred to as loan payback. In…

Q: Joe secured a loan of $15,000 two years ago from a bank for use toward his college expenses. The…

A: Monthly payment The minimum value that is required to be paid each month by an individual for the…

Q: While Mary Corens was a student at the University of Tennessee, she borrowed $11,000 in student…

A: Present Value of annuity refers to the present value of all the future payments of and series of…

Q: A lump-sum loan of $5,000 is needed by Chandra to pay for college expenses. She has obtained small…

A: Interest on the loan is the excess money paid along with the principal every year or in a lump sum…

Q: Ashea Smith is a 22-year-old senior who used the Stafford loan program to borrow $4,000 four years…

A: The annual payment amount can be calculated. But the first step is to calculate present value of all…

Q: Suzanne opens a line of credit at a local bank, and immediately borrows 1510 dollars. 5 months…

A: Line of credit is a type of bank account which allows business to borrow a certain amount of money…

Q: ohn has just borrowed an amount of K5,000 to pay his school fees. The loan is to be repaid in equal…

A: Loans are paid by the annual payment that carry the payment of loan and payment of interest also but…

Q: Business and engineering seniors are comparing methods of financing their college education during…

A: The question is based on the concept loan and interest calculation by use of future value method.

Q: Jack has borrowed money from his financial institution, and has agreed to pay $200 at the end of…

A: 1) Computation:

Q: Joe borrowed $100,000 from a local bank, which charges him an interest rate of 7% per year. If Joe…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: Shaun has just been awarded his degree in business. He has three education loans outstanding. They…

A: Computation of weighted average annual interest is as follows: Weighted average annual interest…

Q: Joan Hart borrowed $9,800 to travel to France to see her son Dick. Joan’s loan was to be paid in 50…

A: A loan rebate signifies the amount saved by paying a loan early. The amount is generally saved from…

Q: In order to pay his university fees, Feynman borrowed $ 7000 for five months at 5.5 % Calculate…

A: Simple Interest Charged = Amount Borrowed x Interest Rate x time in months / 12 months

Q: Nona purchased a new car earlier today for $32,000. She financed the entire amount using a five-year…

A: GIVEN, R = 3% LOAN AMOUNT = $32000 N= 5 YEARS = 60 MONTHS PMT = P×R12×1+R12N1+R12N-1PMT =…

Q: A civil engineering student borrowed P40,000 to meet college expenses during his senior year. He…

A: We need to find the future value at the end of 3 years then use pmt function to calculate equated…

Q: Kristen purchased a car for $43,000; she paid $2150 as a down payment and financed the balance…

A: Using excel NPER and PMT function

Q: Mary, a college student, needs to borrow $8,000 today for her tuition. She agrees to pay back the…

A: Initial amount is $8,000, Number of years is 4, Interest rate is 3.85%

Q: Sandy Kupchack just graduated from State University with a bachelor’s degree in history. During her…

A: Present value: This is the amount of future value reduced or discounted at a rate of interest till…

Q: Bill took out a 6 year loan to buy a car. If the loan carried an annual interest rate of 6.5% and he…

A: The amount of interest paid is calculated as difference of total payments less present value of…

Q: Robin has taken out a loan for $485,000 from Mammon Financial, Inc. that provides pay off the…

A: in this problem we have to find out present value FACTOR and from that we can find out period…

Q: Philip works at a nursing home as an aide and earns $27,000 a year. IF he went to school to get a…

A: An education loan seems to be an amount of money obtained to cover the costs of graduate school or…

Q: ment for his full load subjects. His friend, Richdin, has the same amount of money for the same…

A: Return of investment: Return of investment can be defined as an additional income earned upon the…

Q: Sandy Kupchack just graduated from State University with a bachelor’s degree in history. During her…

Q: Huai takes out a $3700 student loan at 6.7% to help him with 2 years of community college.…

A: Loan-1 Loan amount is $3,700 Interest rate is 6.7% Loan-2 Loan amount is $11,900 Interest rate 7.1%…

Q: Andrew just bought a new boat for $15,000 to use on the river near his home. He has taken delivery…

A: A balloon loan is a loan which is paid off with a large single, final payment. It involves making…

Q: mount saved on interest

A: Amortized loan refers to the amount of loan which requires regular monthly payments. Every payment…

Q: Rita borrowed $4000 from a bank for 5 years and was charged simple interest. The total interest that…

A: Loan amount = $ 4,000 Period = 5 Years Interest amount = $ 1,600

Q: Huai takes out a $3300 student loan at 6.6% to help him with 2 years of community college. After…

A: Consider the following student loan: • First he takes out a loan of $3300. • The interest rate for…

Q: Ian loaned his friend $20,000 to start a new business. He considers this loan to be an investment,…

A: Total Loaned amount is $20,000 Interest rate is 6% Time period is 4 years To Find:- Annual Payment…

Q: Huai takes out a $3500 student loan at 6.7% to help him with 2 years of community college.…

A: Details of Loan-1 Loan amount is $3500 Interest rate is 6.7% Details of second loan Loan amount…

Q: Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down at purchase…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: mary, a college student, needs to borrow $8000 today for her tuition. She agrees to pay back the…

A: Loan is referred as the amount of fund is given to a party in exchange of repayment of principal…

Concept explainers

Cost of Credit

The cost of credit is an extra amount that the borrower has to pay besides the loan amount. These credit charges may vary from loan to loan. The cost of credit includes interest charges, maintenance charges, and arrangement charges. Some of the costs are mandatorily collected by the lender based on the loan amount and tenure of the loan. The cost of credit is also called finance charges of the credit.

Question

While Jack was a student at the University of Georgia she borrowed $12,000in student loans at an annual interest rate of 9%. If Jack repays $1,500 per year then how long (to the nearest year) will it take him to repay the loan? Use an excel to understand the calculation

Expert Solution

Step 1

The nper function in excel can be used for the purpose of determining the amount of time required to repay a loan amount using the applicable interest rate.

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
While Mary Corens was a student at the University of Tennessee, she borrowed $15,000 in student loans at an annual interest rate of 10%. If Mary repays $1,800 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number. ________year(s)
While Mary Corens was a student at the University of Tennessee, she borrowed $11,000 in student loans at an annual interest rate of 9%. If Mary repays $1,300 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number. How many year(s)?
While Mary Corens was a student at the University of Tennessee, she borrowed $10,000 in student loans at an annual interest rate of 11%. If Mary repays $1,400 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number.
Repaying a Loan While Mary Corens was a student at the University of Tennessee, she borrowed $9,000 in student loans at an annual interest rate of 10%. If Mary repays $1,300 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number.
LaTisha owed $65,000 when she graduated from college. Suppose her 10-year loan had an APR of 4.5% with monthly payments of $673.65. How much will she spend on interest over the life of the loan? Round your answer to the nearest cent. Use the spreadsheet to solve.
Please help me answer the following time value of money question. Edison borrowed $10,000 from the Niederriter Loan Company. He has to pay off the loan in 36 monthly payments of $500. What interest rate is he being charged?
Repaying a Loan While Mary Corens was a student at the University of Tennessee, she borrowed $10,000 in student loans at an annual interest rate of 10%. If Mary repays $1,300 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number. year(s)
Determine whether each scenario below is a savings/investments question or a loans question. 1. Sabrina finances a $21,999 car at 4.25% APR over 5 years. If she makes a down payment for $5,000, how much will she end up paying in interest for the car? 2. Alejandro deposits $1,500 into an investment account with an APR of 2.25% compounded monthly. How much does Alejandro need to put into his account each month in order to have $5,000 in 3 years to purchase a car in cash? 3. Amy wants to buy a house for $150,000. She doesn't have enough yet for a 20% down payment. If she puts $2,000 into the account now and $500 every month, how long will it take for her to have enough for a 20% down payment to buy this house? 4. Arnie paid $500 for his $1,200 laptop. If he finances the rest at 6.75% over 24 months, how much money will he end up paying in total for this laptop?
Sarah graduated from college with $29000 in student loan debt. The annual rate on her loans is 6 percent simple interest, and she will make monthly payments for 10 years. What is the remaining balance on her loan after five years, or 60 months? (Hint: Use the amortization function on your financial calculator or Excel Worksheet 5.6.) O $14500 O $16654 O $9682 $19318
A man plans to take a vacation in 4 years. He wants to buy a certificate of deposit for $1200 that he will cash in for the trip. What is the minimum annual interest rate he must obtain on the certificate if he needs at least $1700 for the trip? Assume that the interest on the loan is computed using simple interest The rate he must obtain is ___%
Create an Amortization schedule-see amortization video. How much student debt will I bear by the time I graduate? What will my student loan payments be? a. My undergraduate student debt is $32,500. I have secured a 4.08% annual rate (EAR) for a 25-year loan, identify the monthly payment. b. What is the total amount of interest paid on this loan? c. In total (interest plus principle) how much did you pay for this $32,500 loan?