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
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
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...
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
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
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning