Question

A group of private investors purchased a condominium complex for $4 million. They made an initial...

A group of private investors purchased a condominium complex for $4 million. They made an initial down payment of 12% and obtained financing for the balance. If the loan is to be amortized over 12 years at an interest rate of 6.6%/year compounded quarterly, find the required quarterly payment. (Round your answer to the nearest cent.)

Homework Answers

Answer #1

Loan amount = cost of condominium - down payment

Loan amount = $4,000,000 - ($4,000,000 * 12%) = $3,520,000

Quarterly loan payment is calculated using PMT function in Excel :

rate = 6.6% / 4   (converting annual rate into quarterly rate)

nper = 12*4 (12 year loan with 4 quarterly payments each year)

pv = 3520000 (loan amount)

PMT is calculated to be $106,740.15

Quarterly loan payment is $106,740.15

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
A group of private investors purchased a condominium complex for $3 million. They made an initial...
A group of private investors purchased a condominium complex for $3 million. They made an initial down payment of 12% and obtained financing for the balance. If the loan is to be amortized over 14 years at an interest rate of 8.1%/year compounded quarterly, find the required quarterly payment. (Round your answer to the nearest cent.)
A group of private investors purchased a condominium complex for $2 million. They made an initial...
A group of private investors purchased a condominium complex for $2 million. They made an initial down payment of 15% and obtained financing for the balance. The loan is to be amortized over 14 years at an interest rate of 11% per year compounded quarterly. (Round your answers to the nearest cent.) What is the required quarterly payment? $   How much total interest will be paid on the loan? $  
A group of private investors purchased a condominium complex for $3million. They made an initial down...
A group of private investors purchased a condominium complex for $3million. They made an initial down payment of 12% and obtained financing for the balance. If the loan is to be amortized over 10 years at an interest rate of 5.1%/year compounded quarterly, find the required quarterly payment. (Round your answer to the nearest cent.)
The Turners have purchased a house for $170,000. They made an initial down payment of $40,000...
The Turners have purchased a house for $170,000. They made an initial down payment of $40,000 and secured a mortgage with interest charged at the rate of 10%/year compounded monthly on the unpaid balance. The loan is to be amortized over 30 yr. (Round your answers to the nearest cent.) (a) What monthly payment will the Turners be required to make? (b) How much total interest will they pay on the loan? (c) What will be their equity after 10...
The Taylors have purchased a $200,000 house. They made an initial down payment of $30,000 and...
The Taylors have purchased a $200,000 house. They made an initial down payment of $30,000 and secured a mortgage with interest charged at the rate of 7%/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...
The Taylors have purchased a $220,000 house. They made an initial down payment of $30,000 and...
The Taylors have purchased a $220,000 house. They made an initial down payment of $30,000 and secured a mortgage with interest charged at the rate of 6%/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.) $1139.14 What is their equity (disregarding appreciation) after 5 years? After 10...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value of the house and received a mortgage for the rest of the amount at 6.22% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. Round to the nearest cent b. Calculate the principal balance at the end of the 5 year term. Round to the nearest cent c. Calculate the monthly...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value of the house and received a mortgage for the rest of the amount at 6.22% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. Round to the nearest cent b. Calculate the principal balance at the end of the 5 year term. Round to the nearest cent c. Calculate the monthly...
This problem is a complex financial problem that requires several skills, perhaps some from previous sections....
This problem is a complex financial problem that requires several skills, perhaps some from previous sections. During four years of college, Nolan MacGregor's student loans are $4,000, $3,500, $4,400, and $5,000 for freshman year through senior year, respectively. Each loan amount gathers interest of 2%, compounded quarterly, while Nolan is in school and 4%, compounded quarterly, during a 6-month grace period after graduation. (a) What is the loan balance (in dollars) after the grace period? Assume the freshman year loan...
Lucy purchased a house for $400,000. She made a down payment of 25.00% of the value...
Lucy purchased a house for $400,000. She made a down payment of 25.00% of the value of the house and received a mortgage for the rest of the amount at 4.62% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. b. Calculate the principal balance at the end of the 5 year term. c. Calculate the monthly payment amount if the mortgage was renewed for another 5...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT