7. An amount of 24,000php is borrowed for 15 years at a rate of 2%. Make an amortization scheduleshowing the monthly payment, the monthly interest on the outstanding balance, the portion of thepayment contributing toward reducing the debt, and the outstanding balance.

Using PMT function in excel PMT (rate,nper,pv,[fv]) Amortization schedule

Answered: 7. An amount of 24,000php is borrowed…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A debt of $1908 with interest at 6.3% compounded annually is to be repaid by equal payments at the end of each year for 4 years. 1. What is the balance remaining (BAL) after the first payment? 2. What is the principal repaid (PRN) in the first period? 3. What is the interest paid (INT) in the first period?
A debt is amortized for 4 years by a series of payments that decreases annually by ₱ 500, the firstpayment being ₱ 5,000. What is the equivalent future worth of the debt @ 5 % compoundedannually?
5) A loan is being repaid with payments of $750 at the end of each year for 25 years. The annual effective interest rate on the loan is 5%. Each loan payment received by the lender is immediately reinvested at an annual effective rate of 6%. a) Calculate the accumulated value of the lender's reinvested payments at the end of 25 years (i.e., immediately after the last payment is made on the loan). b) Find the effective yield rate earned by the lender over the 25-year period.
Construct the amortization schedule for a $7000 debt that is to be amortized in 5 equal quarterly payments at 2.5% interest per quarter on the unpaid balance. How much interest must be paid?
1.18q Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments on $17,500 at 3.9% for 6 years.
The interest rate for the first five years of a $95,000 mortgage is 7.2% compounded semiannually. Monthly payments are based on a 25-year amortization. Suppose a $3,000 prepayment is made at the end of the third year.a. How much will the amortization period be shortened? b. What will be the principal balance at the end of the five-year term?
3. A debt of P3,500 is to be amortized by 6 equal semiannual payments with interest at 6%compounded semiannually. What is the total interest to be paid during the term of the loan?
A loan is repayable by a decreasing annuity payable annually in arrears for 20 years. The repayment at the end of the first year is $6 000 and subsequent repayments reduce by $200 each year. The repayments were calculated using a rate of interest of 9% per annum effective.Calculate the original amount of the loan.
Complete the following from the first three lines of an amortization schedule for the following loan:You borrow $ 330000 with an annual interest rate of 6% over 20 years Starting principal = $ 330000New balance after month 1 payment = New balance after month 2 payment = New balance after month 3 payment =
A debt is amortized for 4 years by a series of payments that decreases annually by ₱ 500, the firstpayment being ₱ 5,000. What is the equivalent present worth of the debt @ 5 % compoundedannually?
1. A debit of ₱50,000 with interest at 12% compounded monthly is to be amortized by equals monthly payments on one year, the first due at the end of one month. Find the monthly payment and construct an amortization schedule.
A debt of $63 100.00 is repaid by payments of $4350.00 made at the end of every six months. Interest is 6.5% compounded quarterly.a) What is the number of payments needed to retire the debt?b) What is the cost of the debt for the first five years? c) What is the interest paid in the 11th payment?d) Construct a partial amortization schedule showing details of the first three payments, the last three payments, and totals.

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

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.