PLEASE DO THE FOLLOWING ON AN EXCEL SPREADSHEET: Consider a loan of $1,000,000 with the nominal annual interest rate of 10% compounded annually that must be paid off in 15 years. The loan fees include 2.0 points plus originating fee of $1,000. Calculate the loan monthly installments and APR of the loan.

PLEASE DO THE FOLLOWING ON AN EXCEL SPREADSHEET: Consider a loan of $1,000,000 with the nominal annual interest rate of 10% compounded annually that must be paid off in 15 years. The loan fees include 2.0 points plus originating fee of $1,000. Calculate the loan monthly installments and APR of the loan.

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter7: Using Consumer Loans

Section: Chapter Questions

Problem 7FPE: Calculating interest and APR of installment loan. Assuming that interest is the only finance charge,...

See similar textbooks

Similar questions

If Bergen Air Systems takes out a $100,000 loan, with eight equal principal payments due over the next eight years, how much will be accounted for as a current portion of a noncurrent note payable each year?
Calculating and comparing add-on and simple interest loans. Eli Nelson is borrowing 10,000 for five years at 7 percent. Payments, which are made on a monthly basis, are determined using the add-on method. a. How much total interest will Eli pay on the loan if it is held for the full five-year term? b. What are Elis monthly payments? c. How much higher are the monthly payments under the add-on method than under the simple interest method?
Calculating interest and APR of installment loan. Assuming that interest is the only finance charge, how much interest would be paid on a 5,000 installment loan to be repaid in 36 monthly installments of 166.10? What is the APR on this loan?
Calculating single-payment loan amount due at maturity. Stanley Price plans to borrow 8,000 for five years. The loan will be repaid with a single payment after five years, and the interest on the loan will be computed using the simple interest method at an annual rate of 6 percent. How much will Stanley have to pay in five years? How much will he have to pay at maturity if hes required to make annual interest payments at the end of each year?
Cost of Bank Loan Mary Jones recently obtained an equipment loan from a local bank. The loan is for 15,000 with a nominal interest rate of 11%. However, this is an installment loan, so the bank also charges add-on interest. Mary must make monthly payments on the loan, and the loan is to be repaid in 1 year. What is the effective annual rate on the loan (assuming a 365-day year)?
Del Hawley, owner of Hawleys Hardware, is negotiating with First City Bank for a 1-year loan of 50,000. First City has offered Hawley the alternatives listed here. Calculate the effective annual interest rate for each alternative. Which alternative has the lowest effective annual interest rate? a. A 12% annual rate on a simple interest loan, with no compensating balance required and interest due at the end of the year b. A 9% annual rate on a simple interest loan, with a 20% compensating balance required and interest due at the end of the year c. An 8.75% annual rate on a discounted loan, with a 15% compensating balance d. Interest figured as 8% of the 50,000 amount, payable at the end of the year, but with the loan amount repayable in monthly installments during the year