Joseph used the Quantitative Reasoning Procees to create a plan to pay off his student loans of $7,680. The interest rate on his loan is 2.9% annually and he plans to make monthly payments of $73.80 for 10 years. Complete months 1 and 2 of the amortization table below. How much of Joseph's payment goes to Interest in Month 2?

Joseph used the Quantitative Reasoning Procees to create a plan to pay off his student loans of $7,680. The interest rate on his loan is 2.9% annually and he plans to make monthly payments of $73.80 for 10 years. Complete months 1 and 2 of the amortization table below. How much of Joseph's payment goes to Interest in Month 2?

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 1E

See similar textbooks

Similar questions

Braxton used the Quantitative Reasoning Process to create a plan to pay off his credit card loan of $6,520 The in he will be making montthly payments of $120.5 for 6 years. Complete Month 1 of the amortization table below Month Beginning Balance Payment: To Interest Payment: To Principal Ending Balance ??? 21 What is Braxton's Ending Balance for Month 1? (Round your final answer to the nearest cent) S Number
After completing a bachelors degree, you have $15,000.00 in student loans to pay back at an interest rate of 2.25% for 6 years. Follow the steps to show work used to calculate the monthly payment on this loan. Enter the values needed for the LEFT and RIGHT sides of the amortization formula. LOOK AT YOUR FORMULA SHEET. Be sure to use parentheses as shown in class and * to show multiplication: LHS: RHS: pymt. Hint Hint Now simplify the expressions from above and enter the final values for both sides below, keeping at least 6 decimal places: = pymt. Finish your calculation of the payment and enter your result, rounded to the nearest penny, in the table below. Then use the information to complete missing values in the table. SEE THE VIDEO BELOW IF YOU NEED HELP WITH THE TABLE (Round to the nearest cent) Month Monthly Payment Interest on Prior Balance Principle Outstanding Balance 1 2 3 Question Help: Video
Jonathan wishes to borrow $180 000 from a commercial bank. He was told that the loan would be amortized over five years and that payment could be made at the beginning or at the end of each year. Please assist Jonathan by answering the following questions. a. Explain to Jonathan, what is the purpose of a loan amortization schedule? b. Jonathan borrows $180 000 at 9% per annum for five years. The loan is repayable in five equal instalments at the beginning of the year. What is the annual payment?
krystof took out a personal loan for $3, 569.74 with monthly payments for 5 years. The interest rate was 11.39% a) costruct an amortization table for the first 6 moths of this loan b) use the present value of the remaning payments method to find the amount he would owe after 6 months of payments
Justin is financing $169,600 for a home at 5.25% interest with a 25-year fixed-rate loan. Find the interest paid and principal paid for each of the first two months of the loan and find the principal owed at the end of the second month. E Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed.
You have just completed your four-year degree at Southwest Minnesota State University (SMSU)! Your student loans that you have accumulated while studying at SMSU total $25,000. Since you have graduated, you must now begin repaying these student loans. The loan’s annual interest rate is six percent (6%) and it requires four equal end-of-year payments. a) Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. B) What is the total amount that you will repay over this four-year period (principal + interest)? c) What portion or percentage are the total “Interest Payments” of the initial loan value of $25,000?
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.
We will use Excel PMT function to calculate the payment Rand then create an amortization schedule for the problem below: The Turners have purchased a house for $250,000. They made an initial down payment of $50,000 and secured a mortgage with interest charged at the rate of 6%/year on the unpaid balance . Interest computations are made at the end of each month . Assume that the loan is amortized over 15 years . Determine the size of each installment such that the loan is amortized at the end of the term Type the raw data of P, r, m, t into cells Calculate i by its definition Calculate n by its definition Calculate R by Excel function PMT. Note : please reference in PMT What will be their total interest payment ?
While Jack was a student at the University of Georgia she borrowed $12,000in student loans at an annual interest rate of 9%. If Jack repays $1,500 per year then how long (to the nearest year) will it take him to repay the loan? Use an excel to understand the calculation
You have a new 10 year Student loan for $16,500.00 that charges an interest rate of 5.35% compounded monthly. The Amortization Table below shows your activity for the first month's payment. Fill in The Interest Payment, Principle Payment, and New Balance after you make the second Payment in Month 2 Payment Payment Interest Payment Principle Payment New Balance amount $16,500.00 ---- $177.84 $73.56 $104.28 $16,395.72 $177.84 > Next Question
Doreen Short was looking over the repayment schedule for a loan of $37,858 at 7% interest for 5 years with a monthly payment of $924.02. Find the amount saved if the loan is paid off with payment 45 with a remaining principal balance of $10, 554.38.
While William was a student at Edinburgh University, he borrowed $15,000 in student loan at an annual interest rate of 9%. If he repays $2,000 per year, calculate the period required (to the nearest year) to pay off his debt. Expressing the formula and workings (not using excel).