3. Your firm is buying a piece of equipment. The payments are $1236 per month for...
A fifteen-year adjustable-rate mortgage of $117,134.80 is being repaid with monthly payments of $988.45 based upon a nominal interest rate of 6% convertible monthly. Immediately after the 60th payment, the interest rate is increased to a nominal interest rate of 7.5% convertible monthly. The monthly payments remain at $988.45, and there will be an additional balloon payment at the end of the fifteen years to pay the outstanding loan balance. (a) Calculate the loan balance immediately after the 84th payment....
10. What is the payment in month 234 on a 30-year loan for $725,000 at 4.85% that requires payments of $0 for the first five years and fully amortizing payments for the remaining years of the loan? (On Excel) Loan Amount: Years: Periods Per Year: Interest Rate: Balance at EOM 60: Total Amortization Years: What is the balloon payment due at maturity for a 10-year loan for $225,000 at 5.85% if the negotiated payment amount each month is $100 less...
You are looking to purchase a Tesla Model X sport utility vehicle. The price of the vehicle is $94,000. You negotiate a six-year loan. with no money down and no monthly payments during the first year. After the first year, you will pay $1,350 per month for the following five years, with a balloon payment at the end to cover the remaining principal on the loan. The APR on the loan with monthly compounding is 3.2 percent. What will be...
Problem Set 1. A man is paying off a debt of $15,000 with regular payments of $300 at the end of each month. Annual interest is 18% compounded monthly. (a) Find the exact amount of time to at least five decimal places that it will take to pay off this loan. (b) Determine the size of the balloon payment to be made to pay off the loan at the time of the last regular payment. (c) Determine the size of...
Your uncle will sell you his bicycle shop for $170,000, with "seller financing," at a 6.0% nominal annual rate. The terms of the loan would require you to make 12 equal end-of-month payments per year for 4 years, and then make an additional final (balloon) payment of $50,000 at the end of the last month. What would your equal monthly payments be?
You are looking to purchase a Tesla Model X sport utility vehicle. The price of the vehicle is $94,250. You negotiate a six-year loan, with no money down and no monthly payments during the first year. After the first year, you will pay $1,375 per month for the following five years, with a balloon payment at the end to cover the remaining principal on the loan. The APR on the loan with monthly compounding is 3.4 percent. What will be...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
Langara Woodcraft borrowed money to purchase equipment. The loan is repaid by making payments of $1154.26 at the end of every three months over five years. If interest is 7.6 % compounded monthly , what was the original loan balance?
3. A $300,000 home loan is amortized by equal monthly payments for 25 years, starting one month from the time of the loan at a nominal rate of 7% convertible monthly. a. Find the monthly payment amount. b. Find the outstanding balance when 10 years of payments remain. c. Find the total interest paid during the last 10 years of the loan? 4. Eddie is repaying a 20-year loan of 10,000 with payments at the end of each year. Each...