Question

Suppose that you obtain a ten-year $ 100,000 loan to purchase a house and the annual...

Suppose that you obtain a ten-year $ 100,000 loan to purchase a house and the annual interest rate is 7 percent, what should be your monthly payment of principal and interest for the next ten years? (Hint: In the Excel PMT process, convert the annual interest rate and payment periods to the monthly rate and payment periods).

Suppose the length of the loan is twenty years in Question 5, what should your monthly payment of principal and interest be for the next twenty years?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

1)

2)

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Suppose that you obtain a ten-year $100,000 loan to purchase a house and the annual interest...
Suppose that you obtain a ten-year $100,000 loan to purchase a house and the annual interest rate is 7 percent, what should be your monthly payment of principal and interest for the next ten years? (Hint: In the Excel PMT process, convert the annual interest rate and payment periods to the monthly rate and payment periods.)
Catherine received a 30 year loan of $240,000 to purchase a house. The interest rate on...
Catherine received a 30 year loan of $240,000 to purchase a house. The interest rate on the loan was 5.90% compounded monthly. a. What is the size of the monthly loan payment? $ Round to the nearest cent b. What is the principal balance of the loan at the end of 3 years?$ Round to the nearest cent c. By how much will the amortization period shorten if Catherine made an extra payment of $54,000 at the end of the...
Buying a house: Purchase Price = $100,000 Loan to Value Ratio = 75% Interest Rate =...
Buying a house: Purchase Price = $100,000 Loan to Value Ratio = 75% Interest Rate = 6% Term = 30 years 1.) What is the numerator of the mortgage constant equal to? 2.) What is the monthly mortgage constant equal to? 3.) What is the monthly payment equal to? 4.) How much interest do you pay in the second month? 5.) What is the percentage of the mortgage paid off after 5 years?
You received a loan from a bank for $100,000 at an interest rate of 6%. You...
You received a loan from a bank for $100,000 at an interest rate of 6%. You are expected to pay back the loan in equal monthly payments over the next 10 years. Calculate: 1. your monthly payment 2. how much you owe after 5 years of payments 3. how much of the first payment went to interest 4. wow much of the first payment went to principal
You purchase a cottage for $185,000. You obtain a 20-year, fixed rate mortgage loan at 13.0%...
You purchase a cottage for $185,000. You obtain a 20-year, fixed rate mortgage loan at 13.0% after paying a down payment of 30%. Of the second month's mortgage payment, how much is interest and how much is applied to the principal? (Round your answers to the nearest cent.) A. interest $_____ B. applied to the principal $_____
Problem 4 and 5-7 House Appreciation and Mortgage Payments Say that you purchase a house for...
Problem 4 and 5-7 House Appreciation and Mortgage Payments Say that you purchase a house for $314,000 by getting a mortgage for $275,000 and paying a $39,000 down payment. If you get a 25-year mortgage with a 6 percent interest rate, what are the monthly payments? (Do not round intermediate calculations and round your final answer to 2 decimal places.)   PMT $    What would the loan balance be in ten years? (Round the payment amount to the nearest cent but...
You are planning to purchase a house that costs $550,000, and you will use a 30-year...
You are planning to purchase a house that costs $550,000, and you will use a 30-year mortgage. You want to determine whether or not you should save some of your money and put only 10% down on your house. Because you are only putting 10% down, lenders require that you purchase private mortgage insurance (PMI). You want to pay the PMI with a monthly payment (for the same 30-year). Assume that PMI is 1% of the mortgage amount and has...
You buy a house for $300,000. The mortgage company offers a 30 year loan with an...
You buy a house for $300,000. The mortgage company offers a 30 year loan with an annual interest rate of 10% (but the loan requires monthly payments and the interest will compound monthly). Your monthly house payment is? Show equation please
A house costs $138,000. It is to be paid off in exactly ten years, with monthly...
A house costs $138,000. It is to be paid off in exactly ten years, with monthly payments of $1675. What is the APR of this loan? (Hint: calculate monthly rate first; then use APR= monthly rate*12) Do this on excel.
Part B: Planning problems using Excel Mortgage payments : ( 10 % of this assignment) Loan...
Part B: Planning problems using Excel Mortgage payments : ( 10 % of this assignment) Loan amount : $200,000 Interest rate (annual): 4.00 % Term : 30 years Calculate monthly payments: ( Hint : Rate and number of periods should be adjusted for monthly) Total interest amount over the life of the loan In reference to (1, above). ( 10 % of this assignment) Calculate PMT ( Monthly payments) if you want to pay of the above loan in 20...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT