Pedro borrows P300,000.00 from lender ABC today at 12% compounded monthly. To fulfill his obligation to repay the loan, Pedro agreed to  start paying the six (6) equal monthly   payments starting next month. a. What will be the amount of his monthly amortization? b. Construct an amortization schedule. Use a table similar to that found in our textbook. c. What will be the outstanding balance of his loan at the end of 4 months from today?     d. If Pedro failed to pay the 2nd and 3rd monthly amortization, how much shall be the required single payment on the fifth month in order to fully pay his outstanding obligation?       e. Supposed that he will still not be able pay the single total payment on the Fifth month as stated in question d. above, and assuming further that both parties agree that the  outstanding obligations shall instead be  paid in  7 equal monthly installments, at 15% compounded monthly, starting on the  9th month,   what will the value of such monthly installment be?

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 27M
icon
Related questions
Question

Pedro borrows P300,000.00 from lender ABC today at 12% compounded monthly. To fulfill his obligation to repay the loan, Pedro agreed to  start paying the six (6) equal monthly   payments starting next month.

a. What will be the amount of his monthly amortization?

b. Construct an amortization schedule. Use a table similar to that found in our textbook.

c. What will be the outstanding balance of his loan at the end of 4 months from today?    

d. If Pedro failed to pay the 2nd and 3rd monthly amortization, how much shall be the required single payment on the fifth month in order to fully pay his outstanding obligation?     

 e. Supposed that he will still not be able pay the single total payment on the Fifth month as stated in question d. above, and assuming further that both parties agree that the  outstanding obligations shall instead be  paid in  7 equal monthly installments, at 15% compounded monthly, starting on the  9th month,   what will the value of such monthly installment be?

 

I need the answer especially letter E.

 

 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
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
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning