Mr. Nina borrows $425,000 from the bank at 3.5% per year interest over a 30-year period. He can make a monthly month-end payment of $1,400 and would like to make a balloon payment at the end of the 30-year period. What would be the size of the balloon payment? $218,058 $323,069 $433,197 $548,512 Please show how to work this out in Excel if possible?

Mr. Nina borrows $425,000 from the bank at 3.5% per year interest over a 30-year period. He can make a monthly month-end payment of $1,400 and would like to make a balloon payment at the end of the 30-year period. What would be the size of the balloon payment? $218,058 $323,069 $433,197 $548,512 Please show how to work this out in Excel if possible?

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
Refer to the present value table information on the previous page. What amount should Brett have in his bank account today, before withdrawal, if he needs 2,000 each year for 4 years, with the first withdrawal to be made today and each subsequent withdrawal at 1-year intervals? (Brett is to have exactly a zero balance in his bank account after the fourth withdrawal.) a. 2,000 + (2,000 0.926) + (2,000 0. 857) + (2,000 0.794) b. 2,0000.7354 c. (2,000 0.926) + (2,000 0.857) + (2,000 0.794) + (2,000 0.735) d. 2,0000.9264
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.
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?
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?
Cost of Bank Loan Mary Jones recently obtained an equipment loan from a local bank. The loan is for 15,000 with a nominal interest rate of 11%. However, this is an installment loan, so the bank also charges add-on interest. Mary must make monthly payments on the loan, and the loan is to be repaid in 1 year. What is the effective annual rate on the loan (assuming a 365-day year)?
Calculating and comparing add-on and simple interest loans. Eli Nelson is borrowing 10,000 for five years at 7 percent. Payments, which are made on a monthly basis, are determined using the add-on method. a. How much total interest will Eli pay on the loan if it is held for the full five-year term? b. What are Elis monthly payments? c. How much higher are the monthly payments under the add-on method than under the simple interest method?
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.
Calculating single-payment loan amount due at maturity. Stanley Price plans to borrow 8,000 for five years. The loan will be repaid with a single payment after five years, and the interest on the loan will be computed using the simple interest method at an annual rate of 6 percent. How much will Stanley have to pay in five years? How much will he have to pay at maturity if hes required to make annual interest payments at the end of each year?
You take out a 14-year personal loan for $13000 at rate of 8.1% which compounds 4 times per year. After 1 years, you refinance the loan and get a 13-year loan at a rate of 6.48%. a) When you first get the loan, how much is your payment? $ 390.24 Correct b) Make a spreadsheet for your loan balance, interest, and payments. After 1 years of paying, how much do you owe? $ c) Adjust your spreadsheet for the new interest rate starting when you refinance in year 1. What is your new payment? $
A man plans to take a vacation in 4 years. He wants to buy a certificate of deposit for $1200 that he will cash in for the trip. What is the minimum annual interest rate he must obtain on the certificate if he needs at least $1700 for the trip? Assume that the interest on the loan is computed using simple interest The rate he must obtain is ___%