A debt of $22,000 with interest of 10% compounded quarterly is to be amortized by payments of $5,000 at the end of each quarter for as long as necessary. Construct an amortization schedule showing the distribution of the payments as to interest and the repayment of principal.

A debt of $22,000 with interest of 10% compounded quarterly is to be amortized by payments of $5,000 at the end of each quarter for as long as necessary. Construct an amortization schedule showing the distribution of the payments as to interest and the repayment of principal.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Construct the amortization schedule for a $16,000.00 debt that is to be amortized in 12 equal…

A: Amount of Debt is $16,000 Interest rate per half year is 6% Total number of semi annual payments…

Q: find the term of the loan n if the amount of interest paid in the 10th payment is 300

A: Amortization is the process of repaying the loan. In an amortizing loan, a portion of each monthly…

Q: A loan of $10,000 today is to be repaid by annual payments of $800 to commence one year from now and…

A: Final payment:The "final payment" represents the concluding installment in a series of financial…

Q: A $23,300 loan is to be settled by making payments of $7,460 at the end of every six months. The…

A: Present Value of annuity is used to calculate the loan periodic payments. To calculate number of…

Q: Complete an amortization schedule for a $31, 000 loan to be repaid in equal installments at the end…

A: We need to use PMT function to calculate yearly payment.The formula is: =PMT(RATE,NPER,-PV)

Q: A company will receive payments of $8,000 per year for the next five years under a subscription…

A: In accordance with generally accepted accounting principles (GAAP), the company should record the…

Q: Consider a loan of $98,000 at 7% compounded annually, with 12 annual payments. Find the following.…

A: Loan amortization can be defined as the procedure of amortizing the loan in such a way that the loan…

Q: Complete the first three lines of an amortization schedule for the following loan: You borrow $ 5000…

A: Monthly payments for amortized loan…

Q: A sum of $80,000 is to be repaid over a 10-year period through equal installments made at the end of…

A: Interest, in finance and economics, is payment from a borrower or deposit-taking financial…

Q: Prepare a duration table for a 10-year fully amortizing loan, 6% stated rate, annual payments,…

A: The effective maturity period of a bond is given by its duration. By calculating duration, you can…

Q: Construct an amortization schedule for a $275,000, 6.8% annual rate loan with 30 equal payments.

A: Loan Amount = $ 275000Loan Term = 30 YearsInterest Rate = 6.80%

Q: Required: a) Construct an full amortization schedule for the scenerio below. Details to include pmt…

A: A loan amortization table is a schedule of repayment of a loan in periodic payments, it includes the…

Q: is amortized by level payments made at the end of each quarter for 25 years.Tge monthly rate is…

A: Amortization refers to the breakdown of loan payments into principal and interest portions. It…

Question

A debt of $22,000 with interest of 10% compounded quarterly is to be amortized by
payments of $5,000 at the end of each quarter for as long as necessary. Construct an
amortization schedule showing the distribution of the payments as to interest and the
repayment of principal.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

7. An amount of 24,000php is borrowed for 15 years at a rate of 2%. Make an amortization schedule showing the monthly payment, the monthly interest on the outstanding balance, the portion of the payment contributing toward reducing the debt, and the outstanding balance.
An $80,000 loan is amortized by payments of $1950 at the end of every quarter at a rate of 9% compounded quarterly. 1. Construct a partial amortization schedule showing the last 2 payments. 2. Determine the total amount paid to settle the loan. 3. Determine the total principal repaid. 4. Determine the total amount of interest paid.
The following loan is fully amortizing. The loan is for $12,000 at 5% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment.
A loan of $1500 is to be repaid by annual payments of $250 to commence at the end of the fifth year and to continue thereafter for as long as necessary. Find the amount of the final payment, if the final payment is to be larger than the regular payments. Assume i = 5%. Round your answer to two decimal places.
Make an amortization schedule (which includes payments made, interest paid, principal repaid, and outstanding principal for each period) given the provided details: Loan= P100,000 Interest= 14% compounded quarterly, and planned to make equal quarterly payments to pay-off this loan in three years
Construct the amortization schedule for a $17,000.00 debt that is to be amortized in 10 equal semiannual payments at 6% interest per half-year on the unpaid balance. Fill out the amortization schedule below. Round all values to the nearest cent. Unpaid Balance Reduction Payment Number 0 1 2 Payment Interest $ $ $ $ $ $ Unpaid Balance $ $ WEEKER
A loan of php 2500 is made for a period of 13 months, from january 1 to january 31 the following year at an interest rate of 5%, compounded quarterly. What future amounts is due at the end of the loan period?
Prepare an amortization table for a debt of $46,000,000 contracted for a 9-month term at a nominal quarterly interest rate of 4.5%, capitalized monthly.
A loan of $92,800.00 is repaid by equal payments made at the end of every three months for 3 years. If interest is 8% compounded quarterly, find the size of the quarterly payments and construct an amortization schedule showing the payment number, amount paid, interest paid, principal repaid and outstanding principal balance of each payment. Additionally, include the totals for amount paid, interest paid and principal repaid of the loan.
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…
A company will receive payments of $1,500 per year for the next four years under a subscription contract. The first payment will be made at the beginning of the contract. Assuming an annual interest rate of 3% is appropriate, the present value of an ordinary annuity is 3.71710 x $1,500 = $5,576, and the present value of an annuity due is 3.82861 x $1,500 = $5,743. Which amount must the company record for this sale in accordance with generally accepted accounting principles (GAAP) if collection is reasonably assured? $0 $5,576 $6,000 $5,743