I have bought a house for $300,000. I made a 20% down payment and borrowed the...

I have bought a house for $300,000. I made a 20% down payment and borrowed the rest at 4.2% APR with monthly compounding. It is a 30-year amortized loan. What will be my payments each month at t=1,2,…,360?

Expert Solution

Calculations-

As no method was mentioned I have solved the problem using excel function.

Please upvote if the answer is helpful.In case of doubt,do comment.Thanks.

jeff jeffy answered 2 years ago

I have bought a house for $300,000. I made a 20% down payment and borrowed the...

I have bought a house for $300,000. I made a 20% down payment and borrowed the rest at 4.2% APR with monthly compounding. It is a 30-year amortized loan. Prepare the first two rows of the amortization table (beginning balance, PMT, interest paid, principal paid, ending balance).

I have bought a house for $300,000. I made a 20% down paymentand borrowed the...

I have bought a house for $300,000. I made a 20% down payment and borrowed the rest at 4.2% APR with monthly compounding. It is a 30-year amortized loan. What will be my payments each month at t=1,2,…,360?*Please post any calculator use and formulas*

I have bought a house for $300,000. I made a 20% down paymentand borrowed the...

I have bought a house for $300,000. I made a 20% down payment and borrowed the rest at 4.2% APR with monthly compounding. It is a 30-year amortized loan. Prepare the first two rows of the amortization table (beginning balance, PMT, interest paid, principal paid, ending balance).*Please pot any formulas used or calculations done on calculator*

"I recently bought a new house for $200,000. There was a 20% down payment, and the...

"I recently bought a new house for $200,000. There was a 20% down payment, and the rest was financed at 4.8 percent APR with monthly compounding. Monthly payments starting from next month will be $1,248.66. How many years will it take the firm to pay off this debt?" Please let me know values used in calculator or any formulas.

I recently bought a new house for $200,000. There was a 20% down payment, and the...

I recently bought a new house for $200,000. There was a 20% down payment, and the rest was financed at 4.8 percent APR with monthly compounding. Monthly payments starting from next month will be $1,248.66. How many years will it take the firm to pay off this debt?

1. You just bought a house for $300,000. You put $100,000 as a down payment and...

1. You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank. You take out a 30-year mortgage that charges you 6 percent APR but with monthly compounding. a. How much is your monthly mortgage payment? Show your work. b. How much of your second mortgage payment goes towards interest? Show your work.

Adam bought a house for $220000. He is making a 20% down payment and finance the...

Adam bought a house for $220000. He is making a 20% down payment and finance the rest through a mortgage loan with an interest rate of j4=5.5%j4=5.5%. Calculate the monthly payment for the following time periods: a) 20 years: $ b) 25 years: $ c) 30 years: $

You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank.

You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank. You take out a 30-year mortgage that charges you 6 percent APR but with monthly compounding. A. (15 points) How much is your monthly mortgage payment? Show your work. B. (5 points) How much of your second mortgage payment goes towards interest? Show your work.

The Taylors have purchased a $250,000 house. They made aninitial down payment of $10,000 and...

The Taylors have purchased a $250,000 house. They made an initial down payment of $10,000 and secured a mortgage with interest charged at the rate of 8%/year on the unpaid balance. Interest computations are made at the end of each month. If the loan is to be amortized over 30 years, what monthly payment will the Taylors be required to make? (Round your answer to the nearest cent.)$ ________What is their equity (disregarding appreciation) after 5 years? After 10 years?...

The Taylors have purchased a $250,000 house. They made an initial down payment of $10,000 and...

The Taylors have purchased a $250,000 house. They made an initial down payment of $10,000 and secured a mortgage with interest charged at the rate of 8%/year on the unpaid balance. Interest computations are made at the end of each month. If the loan is to be amortized over 30 years, what monthly payment will the Taylors be required to make? (Round your answer to the nearest cent.) $ 1761.03 What is their equity (disregarding appreciation) after 5 years? After...

Question

I have bought a house for $300,000. I made a 20% down payment and borrowed the...

Solutions

Expert Solution

Related Solutions

I have bought a house for $300,000. I made a 20% down payment and borrowed the...

I have bought a house for $300,000. I made a 20% down paymentand borrowed the...

I have bought a house for $300,000. I made a 20% down paymentand borrowed the...

"I recently bought a new house for $200,000. There was a 20% down payment, and the...

I recently bought a new house for $200,000. There was a 20% down payment, and the...

1. You just bought a house for $300,000. You put $100,000 as a down payment and...

Adam bought a house for $220000. He is making a 20% down payment and finance the...

You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank.

The Taylors have purchased a $250,000 house. They made aninitial down payment of $10,000 and...

The Taylors have purchased a $250,000 house. They made an initial down payment of $10,000 and...