Question

Carolina is considering a purchase of a new warehouse for its expanding parts division. Purchase will...

Carolina is considering a purchase of a new warehouse for its expanding parts division. Purchase will be financed with a $4,000,000 loan. The term of the loan: 15 years, amortizing (monthly payments), APR of 4.80%. The first payment is due one month from the day loan is taken. What will be the amount of each monthly payment? Alternatively, Carolina can use 20-year, monthly amortizing loan with 5.40% APR. How much more in total interest Carolina will pay if it goes with 20-year rather than 15-year loan? (Assume no pre-payments, refinancing, late payments etc.)

Homework Answers

Answer #1
Loan A Loan B
Loan = principal $4,000,000.00 $4,000,000.00
Term (Nper) = 15 x 12 months ; 20 x 12 months 180 240
Rate = 4.80%/12 ; 5.40%/12 0.40% 0.45%
Monthly Payments = PMT(rate,nper,-Principal) $31,216.58 $27,290.06
Total Payments = Monthly payment x term (a) $5,618,983.93 $6,549,615.27
Less: Principal (b) -$4,000,000.00 -$4,000,000.00
Total Interest paid (a -b) $1,618,983.93 $2,549,615.27
Total interest Carolina will pay if it goes with 20-year rather than 15-year loan ($2549615.27 -$1,618,983.93) $930,631.33
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
3. Carolina is considering a purchase of a new warehouse for its expanding parts division. Purchase...
3. Carolina is considering a purchase of a new warehouse for its expanding parts division. Purchase will be financed with a $3,000,000 loan. The term of the loan: 15 years, amortizing (monthly payments), APR of 4%. The first payment is due one month from the day loan is taken. a) What will be the amount of each monthly payment? b) Alternatively, Carolina can use 20-year, monthly amortizing loan with 4.6% APR. How much more in total interest Carolina will pay...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year mortgage loan for 80 percent of the $3,400,000 purchase price. The monthly payment on this loan will be $17,500. What is the APR on this loan? What is the EAR on this loan?
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 30-year mortgage for 80 percent of the $3,700,000 purchase price. The monthly payment on this loan will be $17,800. What is the APR on this loan? What is the EAR on this loan?
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 35-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 35-year mortgage for 85 percent of the $4,100,000 purchase price. The monthly payment on this loan will be $18,200. what is the apr and ear of this loan?
You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year...
You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year mortgage loan for 80 percent of the $2,800,000 purchase price. The monthly payment on this loan will be $17,000. a. What is the APR on this loan? b. What is the EAR?
You have just purchased a new warehouse. To finance the purchase, you have arranged for a...
You have just purchased a new warehouse. To finance the purchase, you have arranged for a 30-year mortgage loan for 80% of the $3,400,000 purchase price. The monthly payment on this loan will be $17,500. What is the monthly compounded APR on this loan? What is the EAR? I need a proper solution with formula and not financial calculator.
3. You have purchased a new warehouse for $4 million. To finance the purchase, you have...
3. You have purchased a new warehouse for $4 million. To finance the purchase, you have arranged for a 30-year mortgage for 75 percent of the purchase price. The monthly payment on the loan will be $30,000 with zero balance after the final payment. a. What is the APR on the loan? b. What is the EAR?
A couple has decided to purchase their dream house at a price of $400,000. The couple...
A couple has decided to purchase their dream house at a price of $400,000. The couple will put 20% down in cash and finance the remaining balance with a 15-year mortgage. The mortgage will have an APR of 4.80%, The mortgage will have monthly payments and monthly compounding of interest. What will be the monthly payment for the couple's mortgage
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 25-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 25-year mortgage loan for 75 percent of the $2,700,000 purchase price. The monthly payment on this loan will be $16,800. a. What is the APR on this loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What is the EAR on this loan? (Do not round intermediate calculations. Enter your answer as a percent...
An engineer bought a house four years ago for $70,000. She paid cash equal to 10%...
An engineer bought a house four years ago for $70,000. She paid cash equal to 10% of the purchase price as the down payment. The rest she financed with two loans. One is a company subsidized loan of 12% for $20,000, with equal monthly payments for 20 years. The other loan (for the remainder of the money needed) was provided by a local bank, with an interest rate of 15%, also payable over 20 years, with uniform monthly payments. What...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • How can you use Bayes’ theorem in light of new information? In Bayes’ theorem, how does...
    asked 34 seconds ago
  • Which of the following is not one of the four states of a working file? Unchanged,...
    asked 3 minutes ago
  • Assume we have CPU instructions that look like this: load register, address save register, address Where...
    asked 16 minutes ago
  • What is the difference between the following two declarations? char array[] = “Hello World”; char *array...
    asked 31 minutes ago
  • Discuss knowledge and understanding gleaned from The Least Dangerous Assumption and Strategies for Presuming Competence. How...
    asked 32 minutes ago
  • Exercise 13-20 (LO13-3) The owner of Maumee Ford-Volvo wants to study the relationship between the age...
    asked 34 minutes ago
  • Scenario The Department of Administrative Services (DAS) provides a number of services to other departments in...
    asked 42 minutes ago
  • Linear Regressions The number of newly reported crime cases in a county in New York State...
    asked 46 minutes ago
  • Specialty courts have been developed for various categories of crimes and offenders (e.g., mental health, substance...
    asked 51 minutes ago
  • An air-track cart with mass m=0.40kg and speed v0=1.2m/s approaches two other carts that are at...
    asked 51 minutes ago
  • Write a program in C# that reverses a collection and removes elements that are divisible by...
    asked 54 minutes ago
  • A gas pipeline with the thickness of 4mm is to be joint together by using welding...
    asked 1 hour ago