Question

In: Finance

A house costs $143,000. It is to be paid off in exactly ten​ years, with monthly...

A house costs $143,000. It is to be paid off in exactly ten​ years, with monthly payments of $1,667.73. What is the APR of this​ loan?

A. 6.1​% B. 7.1​% C. 5.1​% D. 8.1​%

Solutions

Expert Solution

B.7.1%

APR or Annual percentage rate refers to the annual interest rate charged by the banks to the borrower of the fund.Here APR can be computed using the excel function=RATE() . The number of periods is 12*10(10 years*12 monthly payments per year) =120.the loan amount is $143,000.the monthly payment is $1,667.73 The formula is multiplied with 12 to convert the rate into an annual basis.The monthly payment is an outflow hence the negative sign is used.

The formula used=RATE(B5,-B3,B2)*12 we get APR as 7.1%

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

A house costs $139,000. It is to be paid off in exactly ten years, with monthly...
A house costs $139,000. It is to be paid off in exactly ten years, with monthly payments of $1,610.33. What is the APR (%) of this loan? Answer to two decimal places
Nick paid off a $15,000 car loan over 3 years with monthly payments of $466.59 each....
Nick paid off a $15,000 car loan over 3 years with monthly payments of $466.59 each. Find the finance charge and the APR.
$300,000 loan 6% per year APR 30 year armotization Payable monthly Paid exactly 5 years What...
$300,000 loan 6% per year APR 30 year armotization Payable monthly Paid exactly 5 years What is the loan balance? Please show standard factor notation. Answer should be: $279,163.07
Ben decided to purchase a $200,000 house. The interest rate is at 4.5%, paid monthly, and...
Ben decided to purchase a $200,000 house. The interest rate is at 4.5%, paid monthly, and is a thirty-year loan. He plans to borrow the entire $200,000 for the purchase. How much principal and interest will Ben pay over the first 10 years of the loan? N= I= 4.5% PV= 200,000 PMT= FV= Cumulative principal payments over 5 years= Cumulative interest charges over 5 years=
Jill buys a house for $800k, lives there for exactly 10 years and sells it. Suppose...
Jill buys a house for $800k, lives there for exactly 10 years and sells it. Suppose Jill’s annual cost of ownership is exactly equal to the annual rent she would have paid to live in the same house. Suppose the price of Jill’s house grows 3.4% annually. Buying expenses are 5% of purchase price and selling expenses are 8% of sale price. Compute Jill’s annual IRR from owning net of renting. (hint: look at the buy vs rent slides, assume...
It has been exactly 6 years since Alan bought his house for $375,000. Six years ago,...
It has been exactly 6 years since Alan bought his house for $375,000. Six years ago, he paid $75,000 as a down payment and took out a 35-year mortgage for the remaining amount with monthly payments and a quoted APR of 5.5% (with semi-annual compounding). Today, Alan has received a promotion to a higher paying managerial position at his firm. He has decided to pay part of his mortgage in order to reduce his monthly payments. Alan has already made...
It has been exactly 6 years since Alan bought his house for $375,000. Six years ago,...
It has been exactly 6 years since Alan bought his house for $375,000. Six years ago, he paid $75,000 as a down payment and took out a 35-year mortgage for the remaining amount with monthly payments and a quoted APR of 5.5% (with semi-annual compounding). Today, Alan has received a promotion to a higher paying managerial position at his firm. He has decided to pay part of his mortgage in order to reduce his monthly payments. Alan has already made...
Installing Tesla solar panels in a house costs $18,000. It is expected that the average monthly...
Installing Tesla solar panels in a house costs $18,000. It is expected that the average monthly savings will be 1,000 kWh per month. Assuming that the utility company charges 0.2 per $/kWhr. What is the Present worth of this investment for i=6% and N=15 years? A different approach could be to install energy efficient windows and enhance the insulation for $12,000, which would yield average monthly savings of 700 kWh per month. Assuming the same interest rate and time span....
Uneek just paid off her house and is thinking about no longer having homeowners insurance (her...
Uneek just paid off her house and is thinking about no longer having homeowners insurance (her banked required it as part of her mortgage agreement). Her house is worth $300,000. What are the pros and cons of this decision? Would your answer to the previous question change if you found out that Uneek has $3,000,000 in the bank?
The mortgage on your house in Winnipeg is five years old. It required monthly payments of...
The mortgage on your house in Winnipeg is five years old. It required monthly payments of $1402, had an original term of 30 years, and had an interest rate of 9% (APR with semiannual compounding). In the intervening five years, interest rates have fallen, housing prices in the United States have fallen, and you have decided to retire to Florida. You have decided to sell your house in Winnipeg and use your equity for the down payment on a condo...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT