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

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 8P
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
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
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage