1. Assuming the cost of mortgage is $400,000, and theowner of the house makes a down payment of $40,000,with 8% interest rate and 10 years repayment plan.a. calculate the total amount of loan, monthly rate, numberof payment periods, monthly payment,total interest paid, and amount borrowed.b. With the aid of what PMT function in a one variablecondition, calculate monthly payment, total amountpayable, total interest payable for: 12 yrs, 16 yrs, 20 yrs ,25yrs, 30 yrs, 35 yrs mortgage.

Mortgage $ 4,00,000.00 Down Payment $ 40,000.00 Interest Rate 8% Time Period (Years) 10

Assuming the cost of mortgage is $400,000, and the wner of the house makes a down payment of $40,000, th 8% interest rate and 10 years repayment plan. calculate the total amount of loan, monthly rate, number payment periods, monthly payment, tal interest paid, and amount borrowed. With the aid of what PMT function in a one variable ndition, calculate monthly payment, total amount yable, total interest payable for: 12 yrs, 16 yrs, 20 yrs,25 s, 30 yrs, 35 yrs mortgage.

Assuming the cost of mortgage is $400,000, and the wner of the house makes a down payment of $40,000, th 8% interest rate and 10 years repayment plan. calculate the total amount of loan, monthly rate, number payment periods, monthly payment, tal interest paid, and amount borrowed. With the aid of what PMT function in a one variable ndition, calculate monthly payment, total amount yable, total interest payable for: 12 yrs, 16 yrs, 20 yrs,25 s, 30 yrs, 35 yrs mortgage.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 2P: Cost of Bank Loan Mary Jones recently obtained an equipment loan from a local bank. The loan is for...

See similar textbooks

Similar questions

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 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?
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
Using the information provided, what transaction represents the best application of the present value of an annuity due of $1? A. Falcon Products leases an office building for 8 years with annual lease payments of $100,000 to be made at the beginning of each year. B. Compass, Inc., signs a note of $32,000, which requires the company to pay back the principal plus interest in four years. C. Bahwat Company plans to deposit a lump sum of $100.000 for the construction of a solar farm In 4 years. D. NYC Industries leases a car for 4 yearly annual lease payments of $12,000, where payments are made at the end of each year.