You got a well-paying job in Finance and took out a mortgage for your house. It...

You got a well-paying job in Finance and took out a mortgage for your house. It is paid monthly. The amount you borrowed is $790,000, at a monthly rate of 0.5% for the next 30 years (360 months). 1 Use 0.5% as both the interest rate you are paying and the discount rate r.

-Show an amortization schedule if this loan had constant monthly payments. How much do you have to pay every month? Show how much of these payments is interest and how much is paying off the principal. Please show how to do this in excel

Expert Solution

jeff jeffy answered 1 day ago

When you bought your house for $300,000 5 years ago you took out a $250,000 mortgage...

When you bought your house for $300,000 5 years ago you took out a $250,000 mortgage with a 30 year ARM at 5%. Today is the five year anniversary and the rate adjusts to 10%. What is your new mortgage payment?

Suppose you bought a house on January 1 and took out a mortgage for $400,000. The...

Suppose you bought a house on January 1 and took out a mortgage for $400,000. The amortized loan requires annual payments for 15 years. For tax purposes you want to figure out how much you will pay in interest in each year of the loan. Assuming the loan's interest rate is 9%, how much will you pay in interest in the 2nd year of the loan.

Three years ago, you bought a house. You took out a $350,000.00 mortgage at 4.75% for...

Three years ago, you bought a house. You took out a $350,000.00 mortgage at 4.75% for 30 years. Now that interest rates have fallen (beginning of year 4 of your current mortgage), you are considering refinancing your existing loan with a new 30 year loan. Your new loan must pay off the remaining balance of your old loan plus pay for all of the fees, associated with the new loan. In addition to all of the standard fees, you choose...

Over Spring Break you shopped for a mortgage for your first house. You got a quote...

Over Spring Break you shopped for a mortgage for your first house. You got a quote from a bank with an effective annual rate of 4.0% on a 30-year mortgage, that will be paid back in monthly installments. The loan amount is $100,000. However, in order to receive this relatively low interest rate, the bank required that you pay 2-points during the origination of your loan (a point is 1% of your loan). With you paying this one-time fee at...

You just took out a 15-year traditional fixed-rate mortgage for $100,000 to buy a house. The...

You just took out a 15-year traditional fixed-rate mortgage for $100,000 to buy a house. The interest rate is 6.24% (APR) and you have to make payments monthly. 1. What is your monthly payment? 2. How much of your first monthly payment goes towards paying down the outstanding balance (in $)? 3. What is the outstanding balance after 1 year if you have made all 12 payments on time? 4. How much of your 13th monthly payment goes towards paying...

You bought a house for $150,000 and put down 10% and got a mortgage at an...

You bought a house for $150,000 and put down 10% and got a mortgage at an interest rate of 4.35 % per year. You would pay it back by paying an equal amount at the end of each month for 15 years? (Show all work) How much is your loan amount? How much is your monthly loan payment? How much is your loan balance after 2 years? How much is your total interest payment by the end of year 3?

Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house....

Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house. The interest rate is 1.2% (APR) and you have to make payments monthly. Part 1 What is your monthly payment? Part 2 How much of your first monthly payment goes towards paying down the outstanding balance (in $)? Part 3 How much of your 13th monthly payment goes towards paying down the outstanding balance (in $)?

When you purchased your home, you took out a fully amortizing mortgage for $250,000 with a...

When you purchased your home, you took out a fully amortizing mortgage for $250,000 with a 6.5% rate for a 30-year term. After 10 years, you have a chance to refinance for the remaining 20 years with a rate of 4.5%, fully amortizing over the remaining 20 years; however, you have to pay $4,500 up front for the new loan. Based on the fee and how much you will be saving per month, what is the effective annualized return (RATE...

You purchased your home 6 years ago. At this time, you took out a mortgage for...

You purchased your home 6 years ago. At this time, you took out a mortgage for $200,000, for 30 years, with a fixed rate of 5%. You have made all payments on time but have paid nothing extra on the mortgage. Suppose you sell the house for $210,000 and pay a 6% commission. How much money will you receive (or have to pay) after you pay off your loan? Solve using a financial calculator.

To finance the purchase of a house valued at $200,000, a homebuyer takes-out an FHA-insured mortgage...

To finance the purchase of a house valued at $200,000, a homebuyer takes-out an FHA-insured mortgage loan for $170,000. If this homebuyer defaults on the loan, what amount of this $170,000 loan will be covered by the FHA mortgage insurance?

Question