1. A business loan of 1,200,000 pesos is to be paid in full after 5 years. If the interest rate is 4% per annum. How much should be paid after 5 years? 2. Mr. Layug had a 43,000-peso business loan that is to be paid in 8 months. If interest rate is 8% compounded monthly, how much should be paid after 8 months? 3. For the purchase of a car worth 1,060,000 pesos, the bank requires a minimum amount of 15% down payment. Find the mortgaged amount. 4. Suppose that a condominium unit is purchased for 2,400,000 pesos and the bank requires 25% down payment, how much is the mortgaged amount? 5. Mr. Villanueva obtained a 3,800,000-peso mortgage. If the monthly payment is 45,000 pesos for 10 years, how much is the total interest paid? 6. A consumer loan worth 83,000 pesos is to be repaid in 18 months at 8% convertible monthly. How much is the monthly payment? 7. Mr. De Vera got a 96,000-peso loan to be repaid semi-annually in 3 % years. If interest rate is 15% compounded semi-annually, how much is the semi-annual payment? 8. A loan of 67,000 pesos is to be amortized by paying quarterly in 1 year. If the money is worth 12% compounded quarterly, how much is the monthly installment? 9. Mr. and Mrs. Ignacio had a lousing loan payable monthly for 15 years. After paying for 4 years, how many payments are left?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

No.7 and 8. Step by step solution. I CANNOT UNDERSTAND EXCEL

1. A business loan of 1,200,000 pesos is to be paid in full after 5 years. If the interest
rate is 4% per annum. How much should be paid after 5 years?
2. Mr. Layug had a 43,000-peso business loan that is to be paid in 8 months. If
interest rate is 8% compounded monthly, how much should be paid after 8
months?
3. For the purchase of a car worth 1,060,000 pesos, the bank requires a minimum
amount of 15% down payment. Find the mortgaged amount.
4. Suppose that a condominium unit is purchased for 2,400,000 pesos and the bank
requires 25% down payment, how much is the mortgaged amount?
5. Mr. Villanueva obtained a 3,800,000-peso mortgage. If the monthly payment is
45,000 pesos for 10 years, how much is the total interest paid?
6. A consumer loan worth 83,000 pesos is to be repaid in 18 months at 8% convertible
monthly. How much is the monthly payment?
7. Mr. De Vera got a 96,000-peso loan to be repaid semi-annually in 3 % years. If
interest rate is 15% compounded semi-annually, how much is the semi-annual
payment?
8. A loan of 67,000 pesos is to be amortized by paying quarterly in 1 year. If the
money is worth 12% compounded quarterly, how much is the monthly installment?
9. Mr. and Mrs. Ignacio had a lousing loan payable monthly for 15 years. After paying
for 4 years, how many payments are left?
10. Before borrowing a money. What are the important things to consider? Elaborate
your answer.
Transcribed Image Text:1. A business loan of 1,200,000 pesos is to be paid in full after 5 years. If the interest rate is 4% per annum. How much should be paid after 5 years? 2. Mr. Layug had a 43,000-peso business loan that is to be paid in 8 months. If interest rate is 8% compounded monthly, how much should be paid after 8 months? 3. For the purchase of a car worth 1,060,000 pesos, the bank requires a minimum amount of 15% down payment. Find the mortgaged amount. 4. Suppose that a condominium unit is purchased for 2,400,000 pesos and the bank requires 25% down payment, how much is the mortgaged amount? 5. Mr. Villanueva obtained a 3,800,000-peso mortgage. If the monthly payment is 45,000 pesos for 10 years, how much is the total interest paid? 6. A consumer loan worth 83,000 pesos is to be repaid in 18 months at 8% convertible monthly. How much is the monthly payment? 7. Mr. De Vera got a 96,000-peso loan to be repaid semi-annually in 3 % years. If interest rate is 15% compounded semi-annually, how much is the semi-annual payment? 8. A loan of 67,000 pesos is to be amortized by paying quarterly in 1 year. If the money is worth 12% compounded quarterly, how much is the monthly installment? 9. Mr. and Mrs. Ignacio had a lousing loan payable monthly for 15 years. After paying for 4 years, how many payments are left? 10. Before borrowing a money. What are the important things to consider? Elaborate your answer.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Present Value
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
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education