Abigail received a 15 year loan of $280,000 to purchase a house. The interest rate on the loan was 5.80% compounded semi-annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of year 2? c. By how much will the amortization period shorten if Abigail makes an extra payment of $30,000 at the end of year

Abigail received a 15 year loan of $280,000 to purchase a house. The interest rate on the loan was 5.80% compounded semi-annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of year 2? c. By how much will the amortization period shorten if Abigail makes an extra payment of $30,000 at the end of year

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 5E

See similar textbooks

Similar questions

Cassandra received a 30 year loan of $320,000 to purchase a house. The interest rate on the loan was 3.70% compounded semi-annually. a. What is the size of the monthly loan payment? Round to the nearest cent b. What is the balance of the loan at the end of year 3? Round to the nearest cent c. By how much will the amortization period shorten if Cassandra makes an extra payment of $30,000 at the end of year 3? years and monthsm
James received a 15 year loan of $230,000 to purchase a house. The interest rate on the loan was 2.10% compounded semi- annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of year 2? Round to the nearest cent c. By how much will the amortization period shorten if James makes an extra payment of $30,000 at the end of year 2?
Brian received a 15 year loan of $285,000 to purchase a house. The interest rate on the loan was 2.50% compounded semi-annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of the year 2? c. By how much will the amortization period shorten if Brian makes an extra payment of $30,000 at the end of year 2? ____ years ____ months
5. Jenna received a 15 year loan of $375,000 to purchase a house. The interest rate on the loan was 5.10% compounded semi-annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of year 3? c. By how much will the amortization period shorten if Jenna makes an extra payment of $30,000 at the end of year 3? Answer in years and in months.
Laura received a 15 year loan of $245,000 to purchase an RV. The interest rate on the loan was 4.10% compounded monthly. a. What is the size of the monthly loan payment? %24 Round to the nearest cent b. What is the principal balance of the loan at the end of 4 years? Round to the nearest cent c. By how much will the amortization period shorten if Laura made an extra payment of $51,000 at the end of the year 4? years months Express the answer in years and months, rounded to the next month
c. By how much will the amortization period shorten if Shawn made an extra payment of $54,000 at the end of the year 3? years E months Express the answer in years and months, rounded to the next month
Jason received a 30 year loan of $290,000 to purchase a house. The interest rate on the loan was 2.80% compounded semi-annually. a. What is the size of the monthly loan payment? Round to the nearest cent b. What is the balance of the loan at the end of year 3?
Joan Tanaka borrows $80,000 at 14 percent interest toward the purchase of a vacation home.Her mortgage is for 25 years. a. How much will her annual payments be? (home payments are usually on a monthly basis, but we shall do our analysis on an annual basis for ease of computation.) b. How much interest will she pay over the life of the loan?
Devin received a 15 year loan of $305,000 to purchase a house. The interest rate on the loan was 4.10% compounded semi-annually. a. What is the size of the monthly loan payment? Round to the nearest cent b. What is the balance of the loan at the end of year 4? Round to the nearest cent
Jessica purchases a house for $323,000 and takes a mortgage for the full amount. Her mortgage charges 6.75% per year and interest is compounded monthly. She will repay the loan over 25 years with equal monthly payments. a) What is her monthly payment amount? b) How much of the 8th payment would be applied toward interest? c) How much would be the payoff amount if the mortgage is to be paid at the end of year 2 (i.e., before the 24th payment is made)?
Maryanne purchases a house for $380,000 and takes a mortage for the full amount. Her mortgage charges 3% per year and interest is compounded monthly. She will repay the loan over 30 years with equal monthly payments. a) What is her monthly payment amount? b) How much of the 6th payment would be applied toward interest? c) How much of the 6th payment would be applied toward principal? Please show work or excel formuals used
7. Joan Tanaka borrows $80,000 at 14 percent interest toward the purchase of a vacation home. Her mortgage is for 25 years. a. How much will her annual payments be? (home payments are usually on a monthly basis, but we shall do our analysis on an annual basis for ease of computation.) b. How much interest will she pay over the life of the loan?