loan amount
=80%*450000
=360000
monthly payments=360000/((1-(1+(3.9%/12))^(-30*12))/(3.9%/12))=1698.01 is answer
total interest to pay over the term of loan=1698.01*360-360000=251283.60 is answer
loan balance after 15 years=1698.01*((1-(1+(3.9%/12))^(-15*12))/(3.9%/12))=231120.29 is answer
the above are answers
you just bought an investment property for $450,000 . The loan is fully amortized over 30...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...
A loan of $450,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.3%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the first 15 payments. $ Suppose that payment number...
You borrowed $100,000 exactly 5 years ago. The loan is structured as an amortized loan. The interest rate is 7% and you make quarterly (end-of-quarter) payments of $2124.88. The loan is amortized over 25 years. How much principal have you paid over the first 5 years? Use Excel to calculate. Please show all Excel formulas.
Calculate the equal monthly payment of interest and principal for a $750,000 loan fully amortized over 12 years at an annual rate of interest of 5.75%.
You want to buy a house, and a local bank will lend you $100,000. The loan will be fully amortized over 20 years, and the nominal interest rate will be 12% with interest paid monthly. What will be the monthly loan payment?
You want to buy a car, and a local bank will lend you $30,000. The loan would be fully amortized over 3 years (36 months), and the nominal interest rate would be 8%, with interest paid monthly. What is the monthly loan payment? Round your answer to the nearest cent.
A loan of $370,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.9%, compounded monthly. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30...
Q4: You want to buy a car, and a bank will lend you $30,000. The loan would be fully amortized over 3 years (36 months), and the nominal interest rate would be 5%, with interest paid monthly. What is the monthly loan payment? What is the loan's EFF%?
Q4: You want to buy a car, and a bank will lend you $30,000. The loan would be fully amortized over 3 years (36 months), and the nominal interest rate would be 5%, with interest paid monthly. What is the monthly loan payment? What is the loan's EFF%?
You borrow $150,000. The loan is structured as an amortized loan to repaid over 4 years with annual (end-of-period) payments of $41909.42 per year. The lender is charging you a rate of 4.6% APR. In the second year, how much interest is paid?