How much will be paid every three months for a loan that amounts to P1 400 500.00 if money is worth 5 1/8% compounded quarterly for 20 years? -tm 1-(1+) 1-(1+ 0.042)-2-4 - P = R- 3000- P22 904.57 0.042 m cash price = down payment + Present value cash price = 2500 + 22904.57 P25 404.57 tm = 2 * 4 = 8 Period (n-tm) Regular Payment (R) Interest (i=j/m) Repayment of the Loan Outstanding Balance 22904.57 1 3000 240.50 2759.50 20145.07 2. 3000 211.52 2788.48 17356.59 3 3000 182.24 2817.76 14538.84 4 3000 152.66 2847.34 11691.49 3000 122.76 2877.24 8814.25 3000 92.55 2907.45 5906.80 3000 62.02 2937.98 2968.82 3000 31.17 2968.83 0.00

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
The other photo is the example of the format of the supposed answer (solution and Excel). Thank you so much
How much will be paid every three months for a loan that amounts to P1 400 500.00 if money is worth 5
1/8% compounded quarterly for 20 years?
Transcribed Image Text:How much will be paid every three months for a loan that amounts to P1 400 500.00 if money is worth 5 1/8% compounded quarterly for 20 years?
-tm
1-(1+)
1-(1+
0.042)-2-4
- P = R-
3000-
P22 904.57
0.042
m
cash price = down payment + Present value
cash price = 2500 + 22904.57 P25 404.57
tm = 2 * 4 = 8
Period (n-tm) Regular Payment (R) Interest (i=j/m) Repayment of the Loan Outstanding Balance
22904.57
1
3000
240.50
2759.50
20145.07
2.
3000
211.52
2788.48
17356.59
3
3000
182.24
2817.76
14538.84
4
3000
152.66
2847.34
11691.49
3000
122.76
2877.24
8814.25
3000
92.55
2907.45
5906.80
3000
62.02
2937.98
2968.82
3000
31.17
2968.83
0.00
Transcribed Image Text:-tm 1-(1+) 1-(1+ 0.042)-2-4 - P = R- 3000- P22 904.57 0.042 m cash price = down payment + Present value cash price = 2500 + 22904.57 P25 404.57 tm = 2 * 4 = 8 Period (n-tm) Regular Payment (R) Interest (i=j/m) Repayment of the Loan Outstanding Balance 22904.57 1 3000 240.50 2759.50 20145.07 2. 3000 211.52 2788.48 17356.59 3 3000 182.24 2817.76 14538.84 4 3000 152.66 2847.34 11691.49 3000 122.76 2877.24 8814.25 3000 92.55 2907.45 5906.80 3000 62.02 2937.98 2968.82 3000 31.17 2968.83 0.00
Expert Solution
steps

Step by step

Solved in 6 steps with 8 images

Blurred answer
Knowledge Booster
Capital Budgeting
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT