You borrow a GPM of $120,000 with annual payments and 30-year term. The interest rate is 10%. The payment rises by 2% each year. please show how to solve using excel to answer a. b. and c. below a. What are the annual payments for years 1 to 30? b. What is remaining balance at the end of each year? c. What are the interest payment and principal payment for years 1 to 30?

You borrow a GPM of $120,000 with annual payments and 30-year term. The interest rate is 10%. The payment rises by 2% each year. please show how to solve using excel to answer a. b. and c. below a. What are the annual payments for years 1 to 30? b. What is remaining balance at the end of each year? c. What are the interest payment and principal payment for years 1 to 30?

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 3PB: Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate...

See similar textbooks

Similar questions

You put $600 in the bank for 3 years at 15%. A. If Interest Is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.
You put $250 in the bank for S years at 12%. A. If interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. B. Use the future value of $1 table in Appendix B and verity that your answer is correct.
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
You borrow a GPM of $120,000 with annual payments and 30-year term. The interest rate is 10%. The payment rises by 2% each year. Questions: 1. What are the annual payments for years 1 to 30? 2. What is remaining balance at the end of each year? 3. What are the interest payment and principal payment for years 1 to 30?
If you borrow $7,500 at $550 interest for one year, what is your effective interest rate for the following payment plans? (Input your answers as a percent rounded to 2 decimal places.) a. Annual payment b. Semiannual payments c. Quarterly payments d. Monthly payments Effective Rate of Interest % % %
1. Suppose you borrow $16,000. The interest rate is 9%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0".
1. Let's assume that a loan of $100,000 with an annual interest rate of 6% over 30 years pays monthly payments of $500. a. Calculate the accumulation rate b. Calculate the payment rate . c. Answer : How will the balance of the principal be at the end of the loan in relation to the original amount of the loan? Less, equal or greater? Provide calculations.
Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $17,900 with an annual interest rate of 09.00%. The loan will be repaid over 22 years with monthly payments. 1. What is the Loan Payment? 2. What portion of this payment is Interest? 3. What portion of this payment is Principal? 4. What is the Loan balance after first monthly payment?
If you borrow $5,300 at $900 interest for one year, what is your annual interest cost for the following payment plan? (Round the final answers to 2 decimal places.) Effective rate a. Annual payment % b. Semiannual payments % c. Quarterly payments % d. Monthly payments %
Suppose that you need an amount of money which equals to $10000000. It is possible to find it from bank A at an annual interest rate of 18% under 12 equal payment. If the first payment will be 1 month later the day you used the loan. Find the CF (Cash Flow), the equal payments and prepare the amortization table.
Find the interest rates earned on each of the following:a. You borrow $720 and promise to pay back $792 at the end of 1 year.b. You lend $720 and the borrower promises to pay you $792 at the end of 1 year.c. You borrow $65,000 and promise to pay back $98,319 at the end of 14 years.d. You borrow $15,000 and promise to make payments of $4,058.60 at the end of each year for 5 years.