PLEASE SHOW IN EXCEL You purchase a $325,000 town home and you pay 25 percent down....

PLEASE SHOW IN EXCEL

You purchase a $325,000 town home and you pay 25 percent down. You obtain a 30-year fixed-rate mortgage with an annual interest rate of 5.75 percent and monthly payments. After five years you refinance the mortgage for 25 years at a 5.1 percent annual interest rate. After you refinance, what is the new monthly payment (to the nearest dollar)?

Expert Solution

We calculate the monthly payments using the function PMT in excel

Before refinance
Cost of the home	325000
Downpayment	81250
Loan amount	243750
Annual interest rate	5.75%
Number of years	30
Monthly payment for 5 years	$1,422.46
Loan amount remaining after 5 years	$226,107.83

After refinance
Annual interest rate	5.10%
Number of years	25
Loan amount at the start of refinance	$226,107.83
Monthly payments	$1,335.01

New monthly payment = $1335

jeff jeffy answered 3 years ago

You purchase a $325,000 town home and you pay 25 percent down. You obtain a 30-year...

You purchase a $325,000 town home and you pay 25 percent down. You obtain a 30-year fixed-rate mortgage with an annual interest rate of 5.75 percent and monthly payments. After five years you refinance the mortgage for 25 years at a 5.1 percent annual interest rate. After you refinance, what is the new monthly payment (to the nearest dollar)?

1. You purchase a $350,000 town home and you pay 25% down. You obtain a 30...

1. You purchase a $350,000 town home and you pay 25% down. You obtain a 30 year fixed rate mortgage with an annual interest rate of 6.25%. After 5 years you refinance the mortgage for 25 years at a 5% annual interest rate. After you refinance what is the new monthly payment? 2. You plan to purchase a $175,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate offered to you is 7.75%. You will make...

You purchase a $450,000 town home and you pay 20 percent down. You obtain a 30-year...

You purchase a $450,000 town home and you pay 20 percent down. You obtain a 30-year fixed-rate mortgage with an annual interest rate of 6.5 percent. After five years you refinance the mortgage for 25 years at a 5.75 percent annual interest rate. After you refinance, what is the new monthly payment (to the nearest dollar)?

You purchase a $225,000 town home and you pay 20% down. You obtain a 30 year...

You purchase a $225,000 town home and you pay 20% down. You obtain a 30 year fixed rate mortgage with an annual interest rate of 3.75%. After 20 years you refinance the mortgage for 10 years at a 3.25% annual interest rate. After you refinance what is the new monthly payment to the nearest dollar? 1.) 797 2.)814 3.) 932 4.)1,335 5.) 1,500

Abner Corporation's bonds mature in 25 years and pay 7 percent interest annually. If you purchase...

Abner Corporation's bonds mature in 25 years and pay 7 percent interest annually. If you purchase the bonds for $725, what is your yield to maturity? (round to 2 decimal points)

You put 20% down on a home with a purchase price of $250,000. The down payment...

You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a balance owed of $200,000. A bank will loan you this remaining balance at 3.91% APR. You will make monthly end-of-the-period payments with a 30-year payment schedule. What is the monthly annuity payment under this schedule?

You purchase a boat for $35,000 and pay $5,000 down. You also agree to pay the...

You purchase a boat for $35,000 and pay $5,000 down. You also agree to pay the rest over the next 10 years in 10 equal end of the year payments plus 13 percent compound interest on the unpaid balance. What will be the amount of each payment? -monthly rate? -number of payments? -down payment? -total loan amount? Please show work in excel

please show your work and formula on excel You are now 25 years old. You would...

please show your work and formula on excel You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.

You purchase a town house for $250,000. Since you are able to make a down payment...

You purchase a town house for $250,000. Since you are able to make a down payment of 20 percent ($50,000), you are able to obtain a $200,000 mortgage loan for 20 years at a 5 percent annual rate of interest. a. What are the annual payments that cover the interest and principal repayment? b. How much of the first payment goes to cover the interest? c. How much of the loan is paid off during the first year? d. What...

please show your work and formula on excel You can afford to pay $375 monthly car...

please show your work and formula on excel You can afford to pay $375 monthly car payments. Assume an annual interest rate of 6%, and assume 60 monthly payments. You can afford to put down $3,000. Can you afford to buy a car that costs $30,000?

Question