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?
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.
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 =

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.