Problem 6-41 Calculating Annuity Present Values [LO2]You want to borrow $87,000 from your local bank to buy a new sailboat. You can affordto make monthly payments of $1,550, but no more. Assuming monthly compounding.what is the highest rate you can afford on a 72-month APR loan? (Do not roundintermediate calculations and enter your answer as a percent rounded to 2 decimalplaces, e.g., 32.16.)Interest rate%

We need to use RATE function in excel to calculate APR on loan. The equation is: =RATE(NPER,PMT,-PV)

Answered: You want to borrow $87,000 from your…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

K Which loan best meets the person's needs? (Round to the nearest cent as needed.) Someone needs to borrow $16,000 to buy a car and the person has determined that monthly payments of $300 are affordable. The bank offers a 4-year loan at 7% APR, a 5-year loan at 7.5%, or a 6-year loan at 8% APR. Which loan best meets the person's needs? Explain. ... OA. The first loan best meets the person's needs because the monthly payment of $ amount of $300 per month. B. The second loan best meets the person's needs because the monthly payment of $ amount of $300 per month. KOMENTAR OC. The third loan best meets the person's needs because the monthly payment of $ amount of $300 per month. D. None of the loans meet the person's needs. ch is less than the maximum budgeted is less than the maximum budgeted is less than the maximum budgeted
Assume you bought a car using a loan that requires payments of $3,000 to be made at the end of every yearfor the next three years. The loan agreement indicatesthe annual interest rate is 6 percent. Which table in thisappendix would you use to calculate the car’s equivalentcost if you were to pay for it in full today?a. Table C.1 (Future Value of $1)b. Table C.2 (Present Value of $1)c. Table C.3 (Future Value of Annuity of $1)d. Table C.4 (Present Value of Annuity of $1)
Assume that interest is the only finance charge. Use financial calculator to answer the questions. How much interest would be paid on a $8,000 installment loan to be repaid in 48 monthly installments of $211.10? Round the answer to 4 decimal places. % per month What is the APR on this loan? Round the answer to 2 decimal places. %
To borrow $2,400, you are offered an add-on interest loan at 10.4 percent with 12 monthly payments. Compute the 12 equal payments. 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. Note: Do not round intermediate calculations and round your final answer to 2 decimal places. Equal payment Effective annual rate. %
You want to borrow $59,000 from your local bank to buy a new sailboat. You can afford to make monthly payments of $1,100 but no more. Assuming monthly compounding, what is the hughest rate you can afford on a 66- Training month APR loan? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places
Give typing answer with explanation and conclusion Suppose your gross monthly income is $5,900 and your current monthly payments are $575. If the bank will allow you to pay up to 36% of gross monthly income (less current monthly payments) for a monthly house payment, what is the maximum loan you can obtain if the rate for a 30-year mortgage is 4.65%? (Round your answer to the nearest cent.)
Suppose you decide to buy a car for $25,485, including taxes and licensing fees. You saved $10,000 for a down payment and can get a five- year loan at 6.52%. Use the present value of an annuity formula to find the monthly payment. Round to the nearest cent as needed. -nt pmt 1- P = $218.99 O $303.13 O $498.88 O $8413.52
Give typing answer with explanation and conclusion
d You have decided to buy a car that costs $31,000. Since you do not have a big down payment, the lender offers you a loan with an APR of 6.27 percent compounded monthly for 7 years with the first monthly payment due today. What is the amount of your loan payment? Multiple Choice $294.91 $454.51 $456.89 $374.71 $293.38
Please answer fast i give you upvote.
Problems Saved Help Save You have just borrowed $250,000 to buy a condo. You will repay the loan in equal monthly payments of $2,011.56 over the next 30 years. a. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) b. What is the APR? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) c. What is the effective annual rate on that loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) d. What rate is the lender more likely to quote on the loan? a. Monthly interest rate APR b. C. Effective annual rate d. What rate is the lender more likely to quote on the loan? Prev 3 of 12 Next > earch IN W
← Use PMT- to determine the regular payment amount, rounded to the nearest dollar. Your credit card has a balance of $3600 and an annual interest rate of 16% With no further 1- purchases charged to the card and the balance being paid off over three years, the monthly payment is $127, and the total interest paid is $972. You can get a bank loan at 8.5% with a term of four years. Complete parts (a) and (b) below. a. How much will you pay each month? How does this compare with the credit card payment each month? Select the correct choice below and fill in the answer boxes to complete your choice. (Do not round until the final answer. Then round to the nearest dollar as needed) This is 5 A. The monthly payments for the bank loan are approximately $ OB. The monthly payments for the bank loan are approximately $ This is 5 less than the monthly credit card payments more than the monthly credit card payments

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS