Liz borrowed $52,500 to purchase a home. The bank offered her an APR of 3.49% for a term length of 15 years. Excel calculates the monthly payment to be $375.06. If she were to pay only the minimum payment for the lifetime of the loan, how much will Liz be paying in interest?

Liz borrowed $52,500 to purchase a home. The bank offered her an APR of 3.49% for a term length of 15 years. Excel calculates the monthly payment to be $375.06. If she were to pay only the minimum payment for the lifetime of the loan, how much will Liz be paying in interest?

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 25PROB

See similar textbooks

Related questions

Q: Sam took a $5000 loan to build a deck in the backyard. The loan requires payments at the end of each…

A: Converting rate of interest from 9% compounded monthly to quarterly Effective rate of interest =…

Q: For her son's tuition fee, Maria borrowed 10,000 pesos from a lending company with annual simple…

A: Borrowed Amount (P)=10,000 pesos Duration (n)= 2 years Rate of simple interest (r)=0.084 p.a.…

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

A: To know period we have to calculating present value FACTOR annuity and depending on value and…

Q: Chuck Ponzi has talked an elderly woman into loaning him $50,000 for a new business venture. She…

A: Using loan amortization table to find the cashflow and installment payment. Using excel pmt function…

Q: Margo borrows $900, agreeing to pay it back with 4% annual interest after 14 months. How much…

A: The amount borrowed is recorded as principal amount and extra amount paid to pay off the loan at…

Q: Henry Fuller has agreed to purchase a used automobile for $13,500. He wishes to limit his monthly…

A: The portion of the purchase price of goods and services that are paid immediately at the time of…

Q: Taylor Swift, a college student of USEP decides to get a student loan amounting to $4,000 with an…

A: Amortized Loan: Amortized loan is a type of loan in which the borrower would pay periodic payments…

Q: Mrs. Maria Alading borrowed 20,000 pesos from her friend Ms. Petra Hausen to pay the tuition fee of…

A: Simple Interest is the method in which we calculate the interest on a specific principal amount at a…

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: Lillian took out a 20-year loan for $170,000 at 8.8% interest, compounded monthly. If her monthly…

A: A loan is a financial arrangement in which one person borrows funds from another person at a…

Q: Cynthia is 27 and has 3 years' worth of payments remaining on her student loan. She pays $312.75 a)…

A: Present value of annuity is the sum of the present value of all the cash flow in the future.

Q: Lupe made a down payment of $2000 toward the purchase of a new car. To pay the balance of the…

A: Loan borrowed: loan is $5,258.53

Q: Fatimah pays monthly rent of $520 for her townhouse. If she bought the property, the mortgage loan,…

A: When a series of deposits or payments are made of equal amounts at equal intervals of time, it is…

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: While buying a new car, Thomas made a down payment of $1,000.00 and agreed to make month-end…

A: Present value of annuity is current value of the future annuity flow.

Q: ictor received an 8-year subsidized student loan of $22,000 at an annual interest rate of 4.85%. If…

A: The question gives the following information:

Q: Lia plans to buy a house for Php 157,950. She wants to make a down payment of Php 24, 937 and to…

A: Mortgage- A mortgage is a sort of loan used to buy or maintain tangible assets such as a home,…

Q: A woman, with her employer's matching program, contributes $600 at the end of each month to her…

A: The Future Value of the annuity is the total value of all the payments which is occurred regularly…

Q: Reggie availed of a deferred payment scheme from a bank that gave her an option to pay ₱5,500…

A: solution given Monthly payment 5500 Rate of interest 12% annual Compounding…

Q: Juan took out a $20,000 loan for 146 days and was charged simple interest. The total interest he…

A: We need to use simple interest formula to solve this problem Simple interest =Principal*Rate*Time

Q: Peggy made a down payment of $400 toward the purchase of new furniture. To pay the balance of the…

A: Purchase price of the furniture is present value of monthly payments plus down payments

Q: Max borrows $15,500 for her last 2 years of college, acquiring a federal student loan at 8%…

A: Federal student loans, also known as government loans, allow students and their parents/guardians to…

Q: Rose, recently purchased a new automobile for $25,000. She made a $5,000 down payment and financed…

A: Using excel PMT function

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: This question is about calculating the future value. Formula: Future value = Initial amount*(1+…

Q: Bridgit has purchased a new home at auction for $655,000. To be able to pay for the house, she takes…

Q: Doris purchased a Steinway concert piano for $132,000 with a down payment of 25%, and a loan for the…

A: Cost of piano is $132,000 Down payment is 25% Equal Monthly Payment is $1,650 Interest rate…

Q: While Kate was a student at SA University, she borrowed $16,000 in student loan at an annual…

A: The concept of the present value implies that the money today is having more worth than the money…

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: When Christian bought his home, he borrowed $315,700 at 4.2% interest, compounded monthly for 25…

A: Loan amount (PV) = $315,700 Interest rate = 4.2% Monthly interest rate (r) = 4.2%/12 = 0.35% Period…

Q: Sarah secured a bank loan of $180,000 for the purchase of a house. The mortgage is to be amortized…

A: We will use this formula for calculation of monthly mortgage payment of loan. Monthly payment of…

Q: Sarah secured a bank loan of $165,000 for the purchase of a house. The mortgage is to be amortized…

A: Given information: Bank loan amount is $165,000 Term of mortgage payments is 15 years Interest rate…

Q: Sehar has accumulated $245,000 in her retirement savings plan. When she retires in exactly 4 years…

A: Accumulated saving (A) = $245000 n = 4 years = 16 quarters r = 6% per annum = 1.5% per quarter Let…

Q: Cindy and Rick purchased a home for $145,000 and financed it with a 30-year fixed-rate loan at 6.25%…

A: Introduction Mortgage Loan: A mortgage is a loan that a borrower takes out to buy or retain a house…

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: Angelica took out a 20-year loan for $170,000 at 5.4% interest, compounded monthly. What is her…

A: The monthly payment is determined by dividing the loan amount from the present value factor. The…

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

A: Using excel NPER function

Q: Lense is buying new furniture at Discount Furniture Mart because they are offering to finance her…

A: The interest paid will be the total amount paid over 24 months less the bill amount.

Q: Gabrielle obtained a business loan of $245,000.00 at 4.03% compounded semi-annually, how much should…

A: Loans are paid by the periodic payments that carry the payment for interest and payment for…

Q: A woman, with her employer's matching program, contributes $500 at the end of each month to her…

A: The future value function can be used to derive the future value of a present sum or stream of cash…

Q: Mayesha purchased a large screen TV for $4,000 and can pay it off in ten months with an add-on…

A: The add-on method is used to calculate the monthly payments that are the finance charges for the…

Q: Ria buys a two-year-old Honda from a car dealer for P450,000. She puts P150,000 down and finances…

A: Equated monthly installments(EMI) is the equally divided monthly installments that outgoes to clear…

Q: Sarah secured a bank loan of $190,000 for the purchase of a house. Themortage is the amortized…

A: Excel Spreadsheet: Excel Workings:

Q: Emma bought a $360,000.00 house, paying 10% down, and financing the rest at 2% interest for 20…

A: Price of house = $ 360,000 Dow payment =10% Loan amount (PV) = 360,000*(1-0.10)…

Q: Chuck Ponzi has talked an elderly woman into loaning him $35,000 for a new business venture. She…

A: Interest-only is the method of repayment of loan under which only interest is paid every year and…

Q: Maryanne purchases a house for $380,000 and takes a mortage for the full amount. Her mortgage…

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

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

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

sky wants to purchase a new house that cost 1,440,000. The bank agrees to provide a loan to fixed interest rate of 5.88%. Compute her amortization when spread over a. 5 years b. 10 years. which loan term will she avail if she is recieving a salary of 20,000 per month
Dana has made a down payment of $100,000 on a recent home purchase for $300,000. She was able to obtain bank financing and pays a fixed annual rate of 6 percent on her 30-year mortgage. If she makes steady, fixed monthly payments, what loan balance will remain after the 47th payment?
mary, a college student, needs to borrow $8000 today for her tuition. She agrees to pay back the loan in a lump-sum payment upon graduationg, 4 years from today. The lender agrees to lending at a fixed 3.85% interest rate during the loan period. what the total cost of Mary's student loan?
Sarah secured a bank loan of $190,000 for the purchase of a house. Themortage is the amortized through mothly paymetns for a term of 15 years, with an interst rate of 3%/year compunded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will SArah still owe on her house at that time? (round your answer to the nearest cent)
Mary, a college student, needs to borrow $8,000 today for her tuition. She agrees to pay back the loan in a lump-sum payment upon graduating, 4 years from today. The lender agrees to lending at a fixed 3.85% interest rate during the loan period. What is the total cost of Mary's student loan?
Abigail received a 15 year loan of $280,000 to purchase a house. The interest rate on the loan was 5.80% compounded semi-annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of year 2? c. By how much will the amortization period shorten if Abigail makes an extra payment of $30,000 at the end of year 2?
Mary, a college student, needs to borrow $8,000 today for her tuition. She agrees to pay back the loan in a lump-sum payment upon graduating, 4 years from today. The lender agrees to lending at a fixed 3.85% interest rate during the loan period. What is the total cost of Mary's student loan? (Round your answer to 2 decimal places.)
Megan takes out a car loan for $13,000. She intends to make monthly payments for 5 years to pay off her loan. If the bank charges her an annual interest rate of 4.2% computed monthly on the loan balance, how much will her monthly payments be?
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house? (Round your answer to the nearest cent.)
Jane Doe earns $41,400 per year and has applied for a(n) $89,000, 25-year mortgage at 7 percent interest, paid monthly. Property taxes on the house are expected to be $3,900 per year. If her bank requires a gross debt service ratio of no more than 30 percent, will Jane be able to obtain the mortgage? Is Jane eligible for the loan?
Carissa wishes to borrow $280,000. Lender A qualifies her for a rate of 4.59% over a 30-year term, and Lender B will give her 3.2% for a 20-year loan. Excluding taxes, insurance and all other charges, find the 3. amount of the loan payment for each. Round your answer to the nearest whole dollar.
Joan Tanaka borrows $80,000 at 14 percent interest toward the purchase of a vacation home.Her mortgage is for 25 years. a. How much will her annual payments be? (home payments are usually on a monthly basis, but we shall do our analysis on an annual basis for ease of computation.) b. How much interest will she pay over the life of the loan?