A homebuyer takes - out a loan in the amount of $500,000 for a term of 20 years at 6% APR, compounded monthly. A balance of $200,000 will remain and must be paid - off as a lump sum when the term expires. Complete the following: • Fill-in the rest of the below spreadsheet. Determine the total interest paid during the first year. Determine the total interest paid during the second year. Payment PMT IPMT PPMT Balance 0 $500,000.00 1 -$3,149.29 -$2,500.00 -$649.29 $499,350.71 2 ? ? ? ? 3 ? ? ? ? 4 ? ? ? ? 5 ? ? ? ? 6 ? ? ? ? 7 ? ? ? 8 ? ? ? ? ? 9 ? ? ? ? 10 ? ? ? 11 ? ? ? 12 ? ? ? 13 ? ? ? ? ? ? ? 14 ? ? ? ? 15 ? ? ? ? 16 ? ? ? ? 17 ? ? ? ? 18 ? ? ? ? 19 ? ? ? ? 20 ? ? ? ? 21 ? ? ? ? 22 ? ? ? ? 23 ? ? ? ? 24 ? ? ? ? First Year Total Interest ? Second Year ?

A homebuyer takes - out a loan in the amount of $500,000 for a term of 20 years at 6% APR, compounded monthly. A balance of $200,000 will remain and must be paid - off as a lump sum when the term expires. Complete the following: • Fill-in the rest of the below spreadsheet. Determine the total interest paid during the first year. Determine the total interest paid during the second year. Payment PMT IPMT PPMT Balance 0 $500,000.00 1 -$3,149.29 -$2,500.00 -$649.29 $499,350.71 2 ? ? ? ? 3 ? ? ? ? 4 ? ? ? ? 5 ? ? ? ? 6 ? ? ? ? 7 ? ? ? 8 ? ? ? ? ? 9 ? ? ? ? 10 ? ? ? 11 ? ? ? 12 ? ? ? 13 ? ? ? ? ? ? ? 14 ? ? ? ? 15 ? ? ? ? 16 ? ? ? ? 17 ? ? ? ? 18 ? ? ? ? 19 ? ? ? ? 20 ? ? ? ? 21 ? ? ? ? 22 ? ? ? ? 23 ? ? ? ? 24 ? ? ? ? First Year Total Interest ? Second Year ?

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

ChapterM: Time Value Of Money Module

Section: Chapter Questions

Problem 11RE: Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the...

See similar textbooks

Similar questions

Next Level Potter wishes to deposit a sum that at 12% interest, compounded semiannually, will permit 2 withdrawals: 40,000 at the end of 4 years and 50,000 at the end of 10 years. Analyze the problem to determine the required deposit, stating the procedure to follow and the tables to use in developing the solution.
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.
Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $24,323.00 with an annual interest rate of 15.77%. The loan will be repaid over 7.0 years with monthly payments. Find Loan payment: Interest portion: Principle portion: Loan balance after first monthly payment:
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?
Create an amortization table for a $60,000 loan. We will assume payments are made monthly over 6 years at an interest rate of 4%. a.) First use a formula cell in your spreadsheet to calculate the monthly payment amount. b.) Create an amortization table for the 72 months. Your columns of your amortization table should include payment number, payment amount, interest paid each month, principle paid that month, amount paid on principal total, and the amount of principal remaining.
Create the amortization schedule for a loan of $15,000, paid monthly over three years using a 9 percent APR. Enter the data for the first three months. (Round your answers to 2 decimal places.)
A fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50?
A loan of $5,000 with interest at 7.75% compounded annually is amortized by equal payments at the end of each year for five years. 1. Show your financial calculator inputs for the payment calculation. 2. Create a full amortization schedule for the loan. A template is available in the Test folder (underneath the link to our test. You can fill in the Word file template and attach below,
Develop a complete amortization table for a loan of $4500, to be paid back in 24 uniform monthly installments, based on an interest rate of 6%. The amortization table must include the Payment Number, Principal Owed (beginning of period), Interest Owed in Each Period, Total Owed (end of each period), Principal Paid in Each Payment, Uniform Monthly Payment Amount. You must also show the equations used to calculate each column of thetable. You are encouraged to use spreadsheets. The entire table must be shown.
Joan Messineo borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. Required: a. Calculate the annual, end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time 4 Beg of the year L o a n payment Interest P r i n c i p a l payment E n d o f y e a r principal 1 2 3 9 no handwritten answer allowed
Prepare an amortization schedule for a three-year loan of $96,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? Year 1: Beginning Balance, Total Payment, Interest Payment, Principal Payment, Ending balance Year 2: Beginning Balance, Total Payment, Interest Payment, Principal Payment, Ending balance Year 3: Beginning Balance, Total Payment, Interest Payment, Principal Payment, Ending balance Total Interest for all 3 Years.
For the loan amount, interest rate, annual payment, and loan term shown in the following table, calculate the annual interest paid each year over the term of the loan, assuming that the payments are made at the end of each year. amount interest rate annual payment term $44,000 9% $13,581.42 4 years The portion of the payment that is applied to interest in year 1-4 is