Question 7 5 pts Find the monthly payment to retire a $7500 loan over 3 years,...
Question 8 5 pts Find the monthly payment to retire a $7500 loan over 3 years, that requires monthly payments at 4% annual interest, compounded monthly. Solve for the unknown variable to answer the previous question. You do not need to write a dollar sign. Round your final answer to the nearest cent.
Find the monthly payment needed to amortize a typical $115,000 mortgage loan amortized over 30 years at an annual interest rate of 5.3% compounded monthly. (Round your answers to the nearest cent.) $ Find the total interest paid on the loan. $
Find the monthly payment needed to amortize a typical $205,000 mortgage loan amortized over 30 years at an annual interest rate of 7.1% compounded monthly. (Round your answers to the nearest cent.) a) $ b) Find the total interest paid on the loan. $
Find the monthly payment needed to amortize a typical $95,000 mortgage loan amortized over 30 years at an annual interest rate of 6.9% compounded monthly (Round your answers to the nearest cent.) $623.67 X Enter a number Find the total interest paid on the loan. Anther Vansion
A loan is amortized over 7 years, with monthly payments at a nominal rate of 9.5% compounded monthly. The first payment is $1000, paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior one. What is the outstanding balance immediately after the 30th payment is made?
Problem 3 B) Pierluigi is trying to get a loan for $10,000 to start a business as a financial advisor and is trying to decide between several options. (15 points) DA $10,000 loan that needs to be paid back in 6 years with a 6 % nominal annual interest rate, compounded monthly i) A $10,000 loan that needs to be paid back in 7 years, which accrues no interest during the first 2 years but has a 10% effective interest...
Questions 28-31 use the same data 28 Find mortgage payment N = 5 years, monthly payment, annuity due Interest rate = 2.9%, compounded monthly PV = 45,000 FV = 0 Compute PMT Round to 2 decimal places Amortization schedule after 3 years: same data as 228 P1 = 1 29 30 P2 = 36 Balance after 3 years of payments Total principal repayment after 3 yrs of payments Total interest payments after 3 yrs of payments Round to 2 decimal...
Use the PMT function in Excel to compute the monthly payment on a $328000 business loan at an annual interest rate of 7.15% over 20 years, where the interest is compounded monthly. Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type) Fv and Type are not necessary. Ignore them. Enter the amount of your monthly payment below. Do not include the dollar sign ($)
Enter a formula in cell C9 using the PMT function to calculate the monthly payment on a loan using the assumptions listed in the Status Quo scenario. In the PMT formula, use C6 as the monthly interest rate (rate), C8 as the total number of payments (nper), and C4 as the loan amount (pv). Enter this formula in cell C9, and then copy the formula to the range D9:F9. C9 A B D E F G 1 2 SpringLeaf Designs...
You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your monthly payment? Round your answer to 2 decimal places. 2. You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your Month 1 interest payment? Round your answer to...