Question

Mary’s Manufacturing borrows $100,000 from a bank. The loan has to be repaid over 7 years,...

Mary’s Manufacturing borrows $100,000 from a bank. The loan has to be repaid over 7 years, but the regular payments are calculated as though it were a 14 year loan. Payments are due quarterly. The APR is 12%. What is the regular payment (quarters 1 through 19)? What is the total payment due in the last quarter (quarter 20)?

Homework Answers

Answer #1

Quarterly payment on loan is calculated in excel and screen shot provided below:

Quarterly payment on loan is $3,708.45.

Outstanding balance after 7 year is present value of next 7 year payment. So outstanding balance at end of year 7 is calculated in excel and screen shot provided below:

outstanding balance at end of year 7 is $69,585.71.

Total payment in 28th payment = $69,585.71 + $3,708.45

= $73,294.15

Total payment in 28th payment is $73,294.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
Micro Brewery borrows $330,000 to be repaid in equal installments over a period of six years....
Micro Brewery borrows $330,000 to be repaid in equal installments over a period of six years. The loan payments are semiannual with the first payment due in six months, and interest is at 6%. What is the amount of each payment? a. $33,152. b. $27,500. c. $32,187. d. $28,325.
Gloria borrows 100,000 to be repaid over 30 years. You are given: (i) Her first payment...
Gloria borrows 100,000 to be repaid over 30 years. You are given: (i) Her first payment is X at the end of year 1. (ii) Her payments increase at the rate of 100 per year for the next 19 years and remain level for the following 10 years. (iii) The effective rate of interest is 5% per annum. Calculate X Ans: 5505
M. Oocher borrows $15,000 from Al Ender.  The debt is to be repaid quarterly over 6.5 years.  If...
M. Oocher borrows $15,000 from Al Ender.  The debt is to be repaid quarterly over 6.5 years.  If the money is lent at a nominal rate of 4.4% per year, compounded 4 times per year, what are the periodic payments at the end of each 3-months?
You are taking out a $100,000 mortgage loan to be repaid over 25 years in 300...
You are taking out a $100,000 mortgage loan to be repaid over 25 years in 300 monthly payments. If the interest rate is 16% per year, what is the amount of the monthly payment? If you can only afford to pay $1,000 per month, how large a loan could you afford to take? If you can afford to pay $1,500 per month and need to borrow $100,000, how many months would it take to pay off the mortgage? If you...
you are taking out a $100,000 mortgage loan to be repaid over 25 years in 300...
you are taking out a $100,000 mortgage loan to be repaid over 25 years in 300 monthly payments. a. if the interest rate is 16% per year, what is the amount of the monthly payment? b. if you can only afford to pay $1000 per month, how large a loan can you take? c. if you can afford to pay $1500 per month and need to borrow $100,000, how many months would it take to pay the mortgage? d. if...
You are taking out a $100,000 mortgage loan to be repaid over 25 years in 300...
You are taking out a $100,000 mortgage loan to be repaid over 25 years in 300 monthly payments. a. If the interest rate is 16% per year, what is the amount of the monthly payment? b. If you can only afford to pay $1,000 per month, how large a loan could you afford to take? c. If you can afford to pay $1,500 per month and need to borrow $100,000, how many months would it take to pay off the...
Manufacturing company borrows 5 million euros from the bank to fight the consequences of the corona...
Manufacturing company borrows 5 million euros from the bank to fight the consequences of the corona virus. The repayment schedule is based on an annuity. The interest rate is 10% and the loan is paid back with 6 annual payments. Question: * What is the loan balance immediately the first loan payment is made? please dont do it in excel
please answer all questions!!! 1. A loan may be repaid using the following two options of...
please answer all questions!!! 1. A loan may be repaid using the following two options of payments: i) Payments of 2,000 at the end of each year for eighteen years ii) Payments of 2,500 at the end of each year for nine years. Which of the following is closest to the effective annual interest rate being paid on the loan? A. 14% B. 17%. C. 20%. D.23%. E. 26% 2. A loan is being repaid by payments of 1100 at...
Question 1 Jack took a $ 5,000 loan, which he repaid in monthly installments over seven...
Question 1 Jack took a $ 5,000 loan, which he repaid in monthly installments over seven months. Payments were always made at the end of the month (each payment month was 1/12 part of the year) so that the first repayment was made 4 months after the loan was drawn down. Each equal installment consisted of an installment of the loan amount of $ 5,000 / 7 and an interest component of $ 30 and an account management fee of...
1) Jens just took out a loan from the bank for 79,702 dollars. He plans to...
1) Jens just took out a loan from the bank for 79,702 dollars. He plans to repay this loan by making a special payment to the bank of 4,130 dollars in 4 years and by also making equal, regular annual payments of X for 8 years. If the interest rate on the loan is 12.57 percent per year and he makes his first regular annual payment in 1 year, then what is X, Jens’s regular annual payment? 2) Theo just...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT