EXCEL PROBLEM You are borrowing $200,000 on a 30-year mortgage with an annual interest rate of...
EXCEL PROBLEM
You are borrowing $200,000 on a 30-year mortgage with an annual
interest rate of 10
percent. Assuming end-of-month payments, determine the monthly
payment, interest
payment each month, and amount paid toward principal each
month.
Homework Answers
Add Answer to:
EXCEL PROBLEM
You are borrowing $200,000 on a 30-year mortgage with an annual
interest rate of...
A 30-year mortgage has an annual interest rate of 5.25 percent and a loan amount of...
A 30-year mortgage has an annual interest rate of 5.25 percent and a loan amount of $175,000. What are the monthly mortgage payments? (Round your answer to 2 decimal places.) Payment A 30-year mortgage has an annual interest rate of 4.65 percent and a loan amount of $225,000. (Hint: Use the "IPMT" and "PPMT" functions in Excel.) What are the interest and principal for the 84th payment? (Round your answers to 2 decimal places.) Interest Principal A 20-year mortgage has...
You plan to purchase a $200,000 house using either a 30-year mortgage obtained from your local...
You plan to purchase a $200,000 house using either a 30-year mortgage obtained from your local savings bank with a rate of 7.25 percent, or a 15-year mortgage with a rate of 6.50 percent. You will make a down payment of 20 percent of the purchase price. (LG 7-3) a. Calculate the amount of interest and, separately, principal paid on each mortgage. What is the difference in interest paid? b. Calculate your monthly payments on the two mortgages. What is...
You just entered into a $150,000 30-year home mortgage at an annual interest rate of 4.25%...
You just entered into a $150,000 30-year home mortgage at an annual interest rate of 4.25% making monthly payments of $737.91. Suppose you add an additional payment of $295.97 each month to the $737.91 house payment making your total monthly payments equal to $1,033.88. This extra amount is applied against the principal of the original loan. How long will it take you to pay off your loan of $150,000? Use a calculator to determine your answer. a. It will take...
A family buys a house for which they assume a mortgage of $200,000. The annual mortgage...
A family buys a house for which they assume a mortgage of $200,000. The annual mortgage rate is 9% and is compounded monthly. The loan amortization period is 15 years and the mortgage payments will be made at the end of each month What is the monthly mortgage payment? What will be the outstanding loan amount at the end of five years? What is the total interest that will be paid over the amortization period?
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...
ii. Frank Lewis has a 30-year, $100,000 mortgage with a nominal interest rate of 10 percent and monthly compoundin...
ii. Frank Lewis has a 30-year, $100,000 mortgage with a nominal interest rate of 10 percent and monthly compounding. Which of the following statements regarding his mortgage is most correct? a. The monthly payments will decline over time. b. The proportion of the monthly payment that represents interest will be lower for the last payment than for the first payment on the loan. c. The total dollar amount of principal being paid off each month gets larger as the loan...
Frank Lewis has a 30-year, $100,000 mortgage with a nominal interest rate of 10 percent and monthly compounding. Wh...
Frank Lewis has a 30-year, $100,000 mortgage with a nominal interest rate of 10 percent and monthly compounding. Which of the following statements regarding his mortgage is most correct? a. The monthly payments will decline over time. b. The proportion of the monthly payment that represents interest will be lower for the last payment than for the first payment on the loan. c. The total dollar amount of principal being paid off each month gets larger as the loan approaches...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...
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...
Question 6: Chandra is considering borrowing $150,000 to buy a house, using a 15-year fixed-rate mortgage....
Question 6: Chandra is considering borrowing $150,000 to buy a house, using a 15-year fixed-rate mortgage. Assuming quoted annual interest rate (APR) of 3.9%, put together an amortization table showing all of the monthly payments broken down into the amount going toward paying interest and the amount going toward paying down the mortgage loan balance. You should also have the beginning and ending balance for each month in your table. Please make sure you use cell references and copying and...
You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit...
You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 4.5 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately. principal paid in the 30th payment. c. Calculate the amount of interest and, separately. principal paid in the 210th payment. d. Calculate the amount of...
A 30-year mortgage has an annual interest rate of 5.25 percent and a loan amount of $175,000. What are the monthly mortgage payments? (Round your answer to 2 decimal places.) Payment A 30-year mortgage has an annual interest rate of 4.65 percent and a loan amount of $225,000. (Hint: Use the "IPMT" and "PPMT" functions in Excel.) What are the interest and principal for the 84th payment? (Round your answers to 2 decimal places.) Interest Principal A 20-year mortgage has...
ii. Frank Lewis has a 30-year, $100,000 mortgage with a nominal interest rate of 10 percent and monthly compounding. Which of the following statements regarding his mortgage is most correct? a. The monthly payments will decline over time. b. The proportion of the monthly payment that represents interest will be lower for the last payment than for the first payment on the loan. c. The total dollar amount of principal being paid off each month gets larger as the loan...
Frank Lewis has a 30-year, $100,000 mortgage with a nominal interest rate of 10 percent and monthly compounding. Which of the following statements regarding his mortgage is most correct? a. The monthly payments will decline over time. b. The proportion of the monthly payment that represents interest will be lower for the last payment than for the first payment on the loan. c. The total dollar amount of principal being paid off each month gets larger as the loan approaches...
You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 4.5 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately. principal paid in the 30th payment. c. Calculate the amount of interest and, separately. principal paid in the 210th payment. d. Calculate the amount of...
Most questions answered within 3 hours.
-
Why do organizations decline? What steps can top
management take to halt, decline, and restore organizational...
asked 6 minutes ago -
Under the influence of its drive force, a snowmobile is moving
at a constant velocity along...
asked 20 minutes ago -
What mechanisms Drive speciation??
(I.e. what was Dawins theory on the orgin of species, and how...
asked 1 hour ago -
The manager at a car assembly plant believes that the mean
assembly time for a car...
asked 2 hours ago -
Which of the following is true of electron capture?
A) It decreases the nuclide's mass number...
asked 4 hours ago -
Assuming an efficiency of 43.10%, calculate the actual yield of
magnesium nitrate formed from 114.9 g...
asked 4 hours ago -
The highly pathogenic bacterium Clostridium
perfringens causes gangrene, a disease that results in the
destruction of...
asked 6 hours ago -
In the context of situation analysis, which of the following is
a category for analysis in...
asked 6 hours ago -
In a study of the gas phase decomposition of sulfuryl chloride
at 600 K SO2Cl2(g)SO2(g) +...
asked 6 hours ago -
75 g of 2-propanol (C3H8O) and 25 g of pentane are mixed in a
200 mL...
asked 6 hours ago -
The 2800-turn coil in a dc motor has an area per turn of 1.1 ×
10-2...
asked 6 hours ago -
Draw a combinational logic circuit diagram with a symbol inside
the box for two I/P of...
asked 6 hours ago