(Excel) Suppose that you initially borrowed $100,000, made 5 annual payments of $11,000 and owe the...
(Excel) Suppose that you initially borrowed $100,000, made 5 annual payments of $11,000 and owe the lender $98,000. What was the effective interest rate on this loan? (please setup and solve in excel. Show relevant formulas, thank you :) )
Homework Answers
Add Answer to:
(Excel) Suppose that you initially borrowed $100,000, made 5
annual payments of $11,000 and owe the...
4.(Using Excel) Suppose that you initially borrowed $100,000, made 5 annual payments of $11,000 and owe...
4.(Using Excel) Suppose that you initially borrowed $100,000, made 5 annual payments of $11,000 and owe the lender $98,000. What was the effective interest rate on this loan?
You borrowed $100,000 exactly 5 years ago. The loan is structured as an amortized loan. The...
You borrowed $100,000 exactly 5 years ago. The loan is structured as an amortized loan. The interest rate is 7% and you make quarterly (end-of-quarter) payments of $2124.88. The loan is amortized over 25 years. How much principal have you paid over the first 5 years? Use Excel to calculate. Please show all Excel formulas.
Give that you borrowed $5000 and you agree to repay the loan with 4 annual payments...
Give that you borrowed $5000 and you agree to repay the loan with 4 annual payments of $1500, what annual effective rate of interest are you paying?
need help thanks! Suppose that you have just borrowed $250,000 in the form of a 30...
need help thanks!
Suppose that you have just borrowed $250,000 in the form of a 30 year mortgage. The loan has an annual interest rate of 9% with monthly payments and monthly compounding. a. What will your monthly payment be for this loan? b. What will the balance on this loan be at the end of the 12th year? How much interest will you pay in the 7th year of this loan? d. How much of the 248th payment will...
Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments...
Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments of principal. These were to be made annually with the first payment due exactly one year after she received the $24,000. Ms. Ho also had to make annual payments of interest to the loan holder at an annual effective rate of 8.5%. Immediately after the loan is made, Brady Investment Corporation purchases the right to receive all of Ms. Ho's payments from Stewart Financial...
Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments...
Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments of principal. These were to be made annually with the first payment due exactly one year after she received the $24,000. Ms. Ho also had to make annual payments of interest to the loan holder at an annual effective rate of 8.5%. Immediately after the loan is made, Brady Investment Corporation purchases the right to receive all of Ms. Ho's payments from Stewart Financial...
Suppose you borrowed $10,000 for 4 years with quarterly payments at an APR of 7%. Please...
Suppose you borrowed $10,000 for 4 years with quarterly payments at an APR of 7%. Please show all work and formulas used!! What is the Quarterly payment? Amortize the first four payments .Set up a table like the one below: Payment Number Payment Interest Principle Remaining Balance 1 ________ ________ ________ _______________ 2 ________ ________ ________ _______________ 3 ________ ________ ________ _______________ 4 ________ ________ ________ _______________ How much interest will you pay over the life of the loan?
9. (a) Assume that you have borrowed $1,000 for 2 years and you have an annual...
9. (a) Assume that you have borrowed $1,000 for 2 years and you have an annual interest rate of 12% (annually compounded). What is the monthly payment due on the loan? (b) Switch gears here and now assume that the payments are made annually. What is the annual interest expense for the borrower, and the annual interest income for the lender, during Year 12 (Hint: Go to the TVM lecture notes for multiple cash flows and go to slide 15.)
Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $1...
Please post with mathematical
formulas please, not an excel sheet!
1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...
Suppose you take a 30-year mortgage of $300000. the annual interest rate is 4%, and the...
Suppose you take a 30-year mortgage of $300000. the annual interest rate is 4%, and the annual ... Question: Suppose you take a 30-year mortgage of $300000. The annual interest rate is 4%, and the annual AP... (2 bookmarks) Suppose you take a 30-year mortgage of $300000. The annual interest rate is 4%, and the annual APR is 5.00%. Loan payments are made annually. Calculate the amortized fees and expenses for this loan (in dollars, provide your answer with $1...
need help thanks!
Suppose that you have just borrowed $250,000 in the form of a 30 year mortgage. The loan has an annual interest rate of 9% with monthly payments and monthly compounding. a. What will your monthly payment be for this loan? b. What will the balance on this loan be at the end of the 12th year? How much interest will you pay in the 7th year of this loan? d. How much of the 248th payment will...
9. (a) Assume that you have borrowed $1,000 for 2 years and you have an annual interest rate of 12% (annually compounded). What is the monthly payment due on the loan? (b) Switch gears here and now assume that the payments are made annually. What is the annual interest expense for the borrower, and the annual interest income for the lender, during Year 12 (Hint: Go to the TVM lecture notes for multiple cash flows and go to slide 15.)
Please post with mathematical
formulas please, not an excel sheet!
1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...
Most questions answered within 3 hours.
-
Calculate the pH of each of the following solutions.
0.50 M HBr
3.1×10−4 M KOH
4.2×10−5...
asked 11 minutes ago -
For the year ended December 31, Depot Max’s cost of merchandise
sold was $85,600. Inventory at the...
asked 10 minutes ago -
Week 10 - Professional Memo Assignment
Professional Memo Assignment
Your mission for this week, should you...
asked 15 minutes ago -
Write a Python program that stores the data for each
player on the team, and it...
asked 25 minutes ago -
In
the last 3 months, mike never knows when he is going to get his
allowance...
asked 49 minutes ago -
Is Ca(OH)2 a Bronsted base, Lewis base, or both? Why?
asked 39 minutes ago -
1A- Why don’t voters complain about U.S. tariffs on imported
sugar?
Because sugar is only a...
asked 48 minutes ago -
Cash Payback Period
Primera Banco is evaluating two capital investment proposals for
a drive-up ATM kiosk,...
asked 46 minutes ago -
Create a button in Swift (Xcode) that will create a charge,
create a charge using Stripe's...
asked 46 minutes ago -
The reaction rate of CO and NO2 in the reaction
CO(g) + NO2(g) → CO2(g) +...
asked 48 minutes ago -
Imagine that a chemist puts 6.40 mol each of
C3H8 and O2 in a 1.00-L container...
asked 1 hour ago -
How much money should be invested today in order to have $8340
at the end of...
asked 1 hour ago