Sarah is taking out a loan for $35,000. The current APR is 3.5% and the payments are around $539.65 per month. How long will Sarah be paying on this loan? **Please show work breakdown, and excel equation breakdown** - 6 years - 68 months - 71 months - 5 years - 60 months

Sarah is taking out a loan for $35,000. The current APR is 3.5% and the payments are around $539.65 per month. How long will Sarah be paying on this loan? Please show work breakdown, and excel equation breakdown - 6 years - 68 months - 71 months - 5 years - 60 months

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 13PROB

See similar textbooks

Related questions

Q: A computer with software costs $2,941, and Catherine Stevens has agreed to pay a 17% per year…

A: Given, Cash price of computer = $ 2,941 Rate per 18 months = 0.17/12 * 18 = 25.5%

Q: Larry has decided to take out a loan for college. He expects to graduate 4 years and 9 months later…

A: Calculation of the monthly interest rate is as follows:

Q: Mary bought a bike payable monthly for 10 months starting at the end of the month. How much is the…

A: Mortgage is a loan to buy an asset. The cost of the asset will be paid in equal instalments of…

Q: Ben Spendlove just purchased a new stereo system for $975 and will be making payments of $45 per…

A: The amount borrowed from bank is known as loan. The interest rate on loan can either be charged…

Q: Adrian has taken a loan to buy computer servers for their small bussiness. They need to borrow…

A: Borrowed amount is $91,000 Interest rate is 5.8% compounded quaterly Time period 7 years To Find:…

Q: You finance a $500 car repair completely on credit, you will just pay the minimum payment each month…

A: Given: Finance amount = $500 Minimum payment rate = 4% APR (Annual percentage rate) = 18.99%…

Q: In Aug. 2007, Irene Engels borrowed $50,000, and she borrowed another $50,000 in Aug. 2008, for…

A: The concept of the time value of money states that the current worth of money is more than its value…

Q: Miguel purchased a hot tub costing $5,010 by taking out an installment loan. He made a down payment…

A: The Annual percentage rate(APR) is the percentage rate that shows the interest rate calculates on…

Q: Prisha received a loan of $25,000 from the bank at 3.50% compounded monthly. If she had to repay…

A: Solution:- When an amount is borrowed, it can either be repaid as a lump sum payment or in…

Q: Month Unpaid Monthly Principal Total New Interest Payment Payment Balance

A: The question is related to Amortization Schedule. The details are given.

Q: Robyn is considering the purchase of a new car that sells for $34,000. Čalculate her monthly payment…

A: Using the PMT function

Q: Lush Gardens bought a new truck for $85,000. It paid $10,000 as a down payment and financed the…

Q: A young engineer’s starting salary is $52,000. The engineer expects annual raises of 3%. The…

A: Interest charged on the principal amount and the interest accrued is known as Compound Interest. It…

Q: A young executive is going to purchase a vacation property for investment purposes. She needs to…

A: Borrowed Amount =$130000.00 YEars =28 Terms(m) =28*12 = 336 Monthly Rate(r) = 4.7%/12 = 0.39166667%…

Q: I need help working out this problem. Please explain in detail. Polly Flin borrowed $5,000 for 60…

A: The question is based on the concept of simple interest calculation and adjustment in principle by…

Q: Richard purchased a car which had a selling price of 7200. He paid 30% down and agreed to pay 240 RO…

A: Installment is the periodic amount paid by the borrower to the lender in order to pay back the loan…

Q: a) Bianca takes out a 20-year home loan of $480,000 for her property. She makes equal month-end…

A: A mortgage loan is the type of loan that is provided to a borrower by a bank or financial…

Q: 5. An employee borrowed P200,000 with 16% interest compounded semi-annually promised to pay every 6…

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

Q: A young executive is going to purchase a vacation property for investment purposes. She needs to…

A: Amount Borrowed =$85,000.00 Interest Rate = 6.5% = 6.5/12 = 0.54167% Years = 29 Terms = 29*12 = 348…

Q: 3.- Carmen Arámbula received her paycheck on August 15 for $23,450.00, and decided to invest it…

A: Annualized return or interest rate shows the return that an investment will generate if the amount…

Q: a Let A, be the balance of the loan after n months. find series expression for An

A: Time value of money (TVM) refers to the method used to measure the amount of money at different…

Q: An engineer wants to purchase a house for $100,000 and has $20,000 cash to use as the down payment.…

A: Cost of house = $100,000 Down payment = $20,000 Interest rate = 9% Time period = 20 years Payment…

Q: how much would you save or lose by taking the debt consolidation company’s offer?

A: An Annuity is a series of payments of fixed amounts and at fixed intervals. These can be of two…

Q: uston purchased a wall unit for $2,200. He made a $600 down payment and financed the balance with an…

A: The given problem can be solved using RATE function in excel. RATE function computes interest rate…

Q: A young executive is going to purchase a vacation property for investment purposes. She needs to…

A: Introduction: Compound interest is the interest generated on the initial principle plus the interest…

Q: Suppose that you charged $8430 on a credit card to relocate for your first job. When you realized…

Q: Mariah applied for a loan in a bank that gave 10, 000 pesos monthly payment for 2 years. The first…

A: The present value of an annuity is the current value of the future payments that are calculated…

Q: A young engineer borrowed P 10,000 at 12% interest and paid P 2,000 per annum for the last 4 years.…

A: Loan amount = P 10000 Interest rate = 12% Annual payment = P 2000 Number of annual payments = 4

Q: Can you please help me work this problem out in detail? Carol is depositing $250 into an account…

A: The amount deposited every six months is $250. The total number of deposits in 5 years would be 10.…

Q: Miguel purchased a hot tub costing $5,070 by taking out an installment loan. He made a down payment…

A: APR (Annual Percentage Return) The rate of interest charged by a creditor on the amount lent or the…

Q: Dave Krug finances a new automobile by paying $6,500 cash and agreeing to make 40 monthly payments…

A: Present value: It refers to today’s value of the money that will be received by an investor at some…

Q: You currently have two loans outstanding: a car loan and a student loan. The car loan requires that…

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

Q: Mary bought a bike payable monthly for 9 months starting at the end of the month. How much is the…

A: We need to use the concept of time value of money (TVM) to solve the question. According to the TVM,…

Q: A person needs $20,000 immediately as a down payment on a new home. Suppose that she can borrow this…

A: Loan amount (PV) = $ 20,000 Annual interest rate = 10% Number of compounding per year = 6 Effective…

Q: Rachel has a $15,000, 36 month loan with an APR of 8.25%. a. What is the monthly payment? $

A: Here we will use the concept of time value of money. As per the concept of time value of money the…

Q: Miguel purchased a hot tub costing $5,030 by taking out an installment loan. He made a down payment…

A: Monthly payments interest rate is calculated by excel function RATE, where the inputs are: pv:…

Q: What is the formula needed for Excel to find the monthly payment

A: Re-payment of loan undertaken is as per the decided terms between the loan provider and receiver.…

Q: Miguel purchased a hot tub costing $5,010 by taking out an installment loan. He made a down payment…

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

Q: You decide to earn some money during the summer by running a lawn mowing service called Blade for…

A: In the context of the given question, we compute the accounts receivable balance reported on the…

Q: You need a quick loan and decide to use the local "payday" loan office. The loan is for $800 and you…

A: FV = PV*(1+r)^n, Where, Given that Loan obtained (PV) = $ 800 Loan amount paid (FV) = $ 1025…

Q: Last January, Robyn bought a laptop worth Php 48,000 on loan. To pay off th made monthly payments of…

A: In this we need to calculate the the present value of loan paid and than find out the monthly…

Q: An auto dealer has designed a marketing gimmick. They are asking their customers tinky only $109 at…

A: The monthly payment is the lowest amount which an investor needed to save to get the required amount…

Q: A young executive is going to purchase a vacation property for investment purposes. She needs to…

A: Time period is 26 years Borrowed amount is $112,000 Interest rate is 5.9% Compounded monthly To…

Q: Jerry signs a $16,000 loan for the purchase of a new car. The terms is for 48 months, at an…

A: The question is based on the concept of Financial Management.

Q: You currently have two loans outstanding: a car loan and a student loan. The car loan requires that…

A: In this question equal payment is paid monthly in future. So we have to find present value of loan.

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

- 6 years

- 68 months

- 71 months

- 5 years

- 60 months

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 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, accounting 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.
Now assume that it is several years later. The brothers are concerned about the firm’s current credit terms of net 30, which means that contractors buying building products from the firm are not offered a discount and are supposed to pay the full amount in 30 days. Gross sales are now running $1,000,000 a year, and 80% (by dollar volume) of the firm’s paying customers generally pay the full amount on Day 30; the other 20% pay, on average, on Day 40. Of the firm’s gross sales, 2% ends up as bad-debt losses. The brothers are now considering a change in the firm’s credit policy. The change would entail: (1) changing the credit terms to 2/10, net 20, (2) employing stricter credit standards before granting credit, and (3) enforcing collections with greater vigor than in the past. Thus, cash customers and those paying within 10 days would receive a 2% discount, but all others would have to pay the full amount after only 20 days. The brothers believe the discount would both attract additional customers and encourage some existing customers to purchase more from the firm—after all, the discount amounts to a price reduction. Of course, these customers would take the discount and hence would pay in only 10 days. The net expected result is for sales to increase to $1,100,000; for 60% of the paying customers to take the discount and pay on the 10th day; for 30% to pay the full amount on Day 20; for 10% to pay late on Day 30; and for bad-debt losses to fall from 2% to 1% of gross sales. The firm’s operating cost ratio will remain unchanged at 75%, and its cost of carrying receivables will remain unchanged at 12%. To begin the analysis, describe the four variables that make up a firm’s credit policy and explain how each of them affects sales and collections.
Scrimiger Paints wants to upgrade its machinery and on September 20 takes out a loan from the bank in the amount of $500,000. The terms of the loan are 2.9% annual interest rate and payable in 8 months. Interest is due in equal payments each month. Compute the interest expense due each month. Show the journal entry to recognize the interest payment on October 20, and the entry for payment of the short-term note and final interest payment on May 20. Round to the nearest cent if required.
A woman went to the Beneficial Loan Company and borrowed $10,000. She must pay $323.53 at the end of each month for the next 60 months. What is the monthly interest rate she is paying? What effective annual interest rate is she paying?
The average age of engineering students at graduation is a little over 23 years. This means that the working career of most engineers is almost exactly 500 months. How much would an engineer need to save each month to accrue $5 million by the end of her working career? Assume a 9% interest rate, compounded monthly.
Tom wants to put aside $120 at the end of each month into an account earning 6% compounded monthly, and have 30,000 at the end of ten years. How much would tom’s initial balance have to be? show work and formula
A young engineer’s starting salary is $52,000. The engineer expects annual raises of 3%. The engineer will deposit 10% of the annual salary at the end of each year in a savings account that earns 4%. How much will the engineer have saved for starting a business after 15 years? We suggest that the spreadsheet include at least columns for the year, the year’s salary, the year’s deposit, and the year’s cumulative savings.
Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can understand better. Suppose Cindy borrows $300,000 at 4% for 30 years, monthly payments. The APR on the loan is 4.25%. What amount of points were charged if there was $5,000 origination cost?
You are considering the purchase of new living room furniture that costs $1,390. The store will allow you to make WEEKLY payments of $29.00 for one year to pay off the loan. What is the EAR of this arrangement? (There are 52 weeks in a year.) (x.xx) (Don't handwriting)
Assume that a carpenter borrowed $2,000 to be paid offin a year to finance a machine that would make him workfaster. As a result, she is able to take on more projects andcollect $400 more earnings in the first year, after paying offthe principal of $2,000. However, there is a 15% rental fee(interest) on her loan, which she also has to pay off. Whatis the carpenter’s net earnings for the first year? (Roundyour response to the nearest dollar.)
Claire is planning annual end of year withdrawals from her tax-free account after retirement for 35 years. She has Principal of $755,000, Investment return is 6%, Initial withdrawal $40,000 and annual increase of withdrawal $1,000. Show the work if Claire is possible to continue withdrawing for 35 years? In order for her to do that, what does she have to do?( show excel function & cell reference)
Megan invests $1, 500 at the end of each year into an account earning 2% effective annual interest. She reinvests the interest earned at the end of each year into a second account that will earn her 8% effective annual interest. How much is in the second account after 30 years? Also, fill in the following table (or, redraw the table on your solution sheet being handed in and fill it in