Mr. Ramos buys a house and lot that cost P450,000. He pays P75,000 as down payment and promises to pay the balance by monthly installment for 25 years. If money is worth 12% compounded monthly, a. How much is the monthly amortization? b. What is the outstanding balance at the end of 15 years? c. What part of Mr. Ramos payment goes to the interest? d. What part of the 181st payment goes to repayment of the principal? e. Find the total interest paid on the transaction? Please do on excel

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter13: Long-term Liabilities
Section: Chapter Questions
Problem 1EA: Halep Inc. borrowed $30,000 from Davis Bank and signed a 4-year note payable stating the interest...
icon
Related questions
Question

Mr. Ramos buys a house and lot that cost P450,000. He pays P75,000 as down payment and promises to pay the balance by monthly installment for 25 years. If money is worth 12% compounded monthly,

a. How much is the monthly amortization?

b. What is the outstanding balance at the end of 15 years?

c. What part of Mr. Ramos payment goes to the interest?

d. What part of the 181st payment goes to repayment of the principal?

e. Find the total interest paid on the transaction?

Please do on excel

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Annuity
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage