Homework Answers
We need to use the funtion PMT
| Rate | 5% |
| NPER | 15 |
| PV | -240000 |
| fv | 0 |
| type | 0 |
Excel Funtion =PMT(5%,15,-240000,0,0)
Pretax Mortage Payment=$23122.15
Add Answer to:
You are interested in buying a house that costs $300,000. You plan to make a 20%...
You are buying a home and have saved $45,000 for a down payment. The house costs...
You are buying a home and have saved $45,000 for a down payment. The house costs $360,000. You are given a choice by the mortgage banker. You can use your entire $45,000 for the down payment, and borrow $315,000 at a 4.2% annual rate with monthly payments of about $1540 per month for 30 years (360 monthly payments). Or you can buy down the interest rate by paying an upfront fee to the lender of $8,000. This will reduce the...
You are buying a house priced at $354,125. You plan to pay 20% of the price...
You are buying a house priced at $354,125. You plan to pay 20% of the price for down payment and finance the rest. The mortgage loan you need to borrow lasts 30 years and requires 4.25% interest rate per annum. What is your payment EACH MONTH for the mortgage loan? please show all work
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...
You are buying a house that costs $440000 and plan on taking out a 30-year fixed...
You are buying a house that costs $440000 and plan on taking out a 30-year fixed rate mortgage at an annual interest rate of 2.4%. 1)You make a 15% down payment of 66000, and take out a loan for the remaining $374000. How much would your mortgage payments be? (Ignore taxes, fees, and other charges, and round to the nearest penny.) . 2)You make this mortgage payment at the end of the first month. Your mortgage payment at the end of...
Problem 3: How many years will it take for an intial investment of $2000, earning 5.4%...
Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...
Cri computer Problem 5: You are buying a car. The one you have choosen to purchase...
Cri computer Problem 5: You are buying a car. The one you have choosen to purchase is going to cost you $32,985. Your car salesman has told you that you can purchase this vehicle for $525 per month for 72 months. What interest rate will you be paying? Note: For a loan the price is listed Because the bank gives you the money in FV is 0, because the loan will be paid off NPER 1/Y (Rate) PV PMT FV...
You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage...
You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage rate offered to you is 4.50 percent for a 15 year Mortgage. You will make a down payment of 20 percent of the purchase price. Either using formula or Excel, calculate: A. Calculate your monthly payments on this mortgage? B. What is your loan balance at the end of 4 years (48 payment)? C. What is your loan balance at the end of 10...
1) You wish to borrow $150,000 from a lending institution for the purchase of a house....
1) You wish to borrow $150,000 from a lending institution for the purchase of a house. The bank will lend this amount at an Annual Percentage Rate of 4.5% to be paid-off with equal monthly mortgage payments over a 30-year period. This is a 4.5% APR, 30-year fixed-rate mortgage loan. You wish to know how this loan will affect your federal income tax burden, as only the interest paid on a home mortgage, not the principal, is tax deductible. Construct...
Suppose you are buying a house that cost $300,000. You make a 10% down payment and...
Suppose you are buying a house that cost $300,000. You make a 10% down payment and are also going to make semiannual payments for next 10 years on the balance of the loan which you are financing at 5% APR. Also, the IRS allows the tax exemption for the mortgage interest payment at the end of each year and your tax rate is 30% (i.e. Tax saving = annual interest * tax rate). Using the given information, construct the amortization...
Problem #2 (30%) To buy a house you ask a bank for a mortgage loan of...
Problem #2 (30%) To buy a house you ask a bank for a mortgage loan of $ 400,000, repayable a mortgage loan of $ 400,000, repayable in 30 years of monthly payments at a yearly interest rate of 3%. After 20 years (240 m yearly interest rate of 3%. After 20 years (240 monthly payments) you decide to pay of the remainder of the loan. A) What is your monthly payment? B) What sum you must pay to the bank...
Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...
Cri computer Problem 5: You are buying a car. The one you have choosen to purchase is going to cost you $32,985. Your car salesman has told you that you can purchase this vehicle for $525 per month for 72 months. What interest rate will you be paying? Note: For a loan the price is listed Because the bank gives you the money in FV is 0, because the loan will be paid off NPER 1/Y (Rate) PV PMT FV...
You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage rate offered to you is 4.50 percent for a 15 year Mortgage. You will make a down payment of 20 percent of the purchase price. Either using formula or Excel, calculate: A. Calculate your monthly payments on this mortgage? B. What is your loan balance at the end of 4 years (48 payment)? C. What is your loan balance at the end of 10...
1) You wish to borrow $150,000 from a lending institution for the purchase of a house. The bank will lend this amount at an Annual Percentage Rate of 4.5% to be paid-off with equal monthly mortgage payments over a 30-year period. This is a 4.5% APR, 30-year fixed-rate mortgage loan. You wish to know how this loan will affect your federal income tax burden, as only the interest paid on a home mortgage, not the principal, is tax deductible. Construct...
Problem #2 (30%) To buy a house you ask a bank for a mortgage loan of $ 400,000, repayable a mortgage loan of $ 400,000, repayable in 30 years of monthly payments at a yearly interest rate of 3%. After 20 years (240 m yearly interest rate of 3%. After 20 years (240 monthly payments) you decide to pay of the remainder of the loan. A) What is your monthly payment? B) What sum you must pay to the bank...
Most questions answered within 3 hours.
-
Calculate the final discrete available-to-promise quantity for
Week 1 using the following table.
Weeks
1
2...
asked 19 minutes ago -
Bob is gambling in the casino. The probability that he will win
nothing is 0.2. The...
asked 1 hour ago -
A free electron and a free proton are exactly 0.70 cm apart.
A)
Find the magnitude...
asked 1 hour ago -
Identify and Describe the major sources of U.S law. Provide a
sport-related example of each.
asked 2 hours ago -
NASA's Ames Research Center in Mountain View, California, houses
a 20g centrifuge used to conduct research...
asked 3 hours ago -
I want a python code using recursion ONLY.
I cannot use any loops, dictionaries or modules....
asked 3 hours ago -
Tobin Supplies Company expects sales next year to be $450,000.
Inventory and accounts receivable will increase...
asked 3 hours ago -
Give the relative rates for the following with a neighbor at your
desk
PH3(g) to P4(g)...
asked 4 hours ago -
Suppose Acap Corporation will pay a dividend of $2.87 per share
at the end of this...
asked 4 hours ago -
Scientists make earthquake forecasts using data from:
A.
geodesy
B.
seismology
C.
geology
D.
paleoseismology
E....
asked 4 hours ago -
Employee training can
be defined as planned organizational efforts to help employees
learn job-related knowledge, skills,...
asked 5 hours ago -
Which for loop is implemented correctly in Java?
Group of answer choices
for (i = 0...
asked 6 hours ago