Question

Assume you have recently purchased an investment property for $89,700 and you will be making monthly...

Assume you have recently purchased an investment property for $89,700 and you will be making monthly payments on the mortgage. If the mortgage is for 15 years at an interest rate of 5%, what will be the monthly payment? For the first monthly payment, how much will go towards interest payment and how much will go towards repayment of the loan?

Homework Answers

Answer #1

Monthly loan payment is calculated using PMT function in Excel :

rate = 5% / 12   (converting annual rate into monthly rate)

nper = 15*12 (15 year loan with 12 monthly payments each year)

pv = 89700 (loan amount)

PMT is calculated to be $709.34

Interest in 1st monthly payment = loan amount at beginning * annual interest rate / 12

Interest in 1st monthly payment = $89,700 * 5% / 12 = $373.75

Amount towards repayment of loan = monthly payment - interest

Amount towards repayment of loan = $709.34 - $373.75

Amount towards repayment of loan = $335.59

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Assume you’ve recently purchased a home for $129,000 and you will be making monthly payments on...
Assume you’ve recently purchased a home for $129,000 and you will be making monthly payments on the mortgage. If the mortgage is for 30 years at an interest rate of 5%, what will be the monthly payment? For the first monthly payment, how much will go towards interest payment and how much will go towards repayment of the principal? Show your work.
3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly...
3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly payments for 10 years, 120 payments in all, with the first payment in one month. The bank charges you an interest rate of 9.6% (APR with monthly compounding). a. How much of your first payment is interest, and how much is repayment of principal? b. What is the loan balance immediately after the 10th payment? (Calculate the loan balance using the annuity formula.) c....
You have just taken out a car loan for $22,000 with a 5% APR, compounded monthly....
You have just taken out a car loan for $22,000 with a 5% APR, compounded monthly. The loan is for 5 years. When you make you first payment in one month, how much of the payment will go toward the principal of the loan and how much will go towards the interest? (Note: be careful not to round any intermediate steps less than six decimal places.) When you make you first payment, $X will go towards the principal of the...
You have taken out a $22.000 car loan with a 7% APR, compounded monthly. The loan...
You have taken out a $22.000 car loan with a 7% APR, compounded monthly. The loan is for five years.. When you make your first payment in one month, how much of the payment will go towards the principal of the loan and how much will go towards the interest?
you purchased a car for $120,000 which will paid in equal monthly payments of $1576.1 over...
you purchased a car for $120,000 which will paid in equal monthly payments of $1576.1 over 12 years. The annual interest rate you are charged is 12%.             a. How much of your second monthly payment will go the repayment of1) principal. 2) interest (use an amortization schedule or table).             b. what will the remaining balance be on the loan after he makes the 40th payment (Show me the financial calculator’s inputs).
You are considering an investment by depositing $25,000 to an account today and making monthly contributions...
You are considering an investment by depositing $25,000 to an account today and making monthly contributions of $300 into the account for 10 years. If you want to have $100,000 in the account after 10 years, what annual interest rate must you earn from the account? If you go ahead with the investment and decide to increase the monthly contribution to $400 after 5 years (deposit $25,000 today, $300 monthly for the first 5 years), how much will you have...
You have a mortgage loan of $310,000 with monthly payments. The monthly interest rate is 0.1%....
You have a mortgage loan of $310,000 with monthly payments. The monthly interest rate is 0.1%. (a) Model the mortgage with a dynamical system, where your payment is ? dollars per month. (b) If the payment is $1,800 per month, how much is still due after 120 payments? (c) What monthly payment ? will have the loan paid out in exactly 25 years?
you just took out a $500,000, 20-year mortgage from CIBC. ASSume your effective monthly rate of...
you just took out a $500,000, 20-year mortgage from CIBC. ASSume your effective monthly rate of interest is 0.5% and your monthly payments are $3582.16. (a) How much of your first monthly payment goes toward principal repayment? (b) how much of your 50th monthly payment goes toward interest?
purchase of your first home for $600,000. You have just purchased the house and have put...
purchase of your first home for $600,000. You have just purchased the house and have put a 20% down payment, and will borrow the remaining amount.  The 15-year fixed rate loan has an Annual Percentage Rate (APR) of 3.875%.   You will make monthly payments for the life of the loan. Question 12 related to your purchase of your first home for $600,000. You have just purchased the house and have put a 20% down payment, and will borrow the remaining amount.  The 15-year...
5. You recently purchased a piece of jewelry on your credit card bill for $1,800. The...
5. You recently purchased a piece of jewelry on your credit card bill for $1,800. The interest rate on the card is 22% per year. If you make the minimum monthly payments, you will pay off the balance in 36 months (3 years) assuming no further charges are made on the card. a. What is your monthly payment? b. How much will you have paid in interest when the balance is paid in full? c. How much of the first...