Marigold browws A from a bank at a norminal rate of B percent compounded monthly to be repaid in 1 year.In the first 6 payments she also wants to make additional equal contribution to the principal in the amount of C. Assumption table Loan Amount A              $5,121 Nominal Interest B           7.00% Term of loan (Annual)         1 year Additional principal Contr         46.00 Payment Monthly ?----------------

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

Marigold browws A from a bank at a norminal rate of B percent compounded monthly to be repaid in 1 year.In the first 6 payments she also wants to make additional equal contribution to the principal in the amount of C.

Assumption table

Loan Amount A              $5,121

Nominal Interest B           7.00%

Term of loan (Annual)         1 year

Additional principal Contr         46.00

Payment Monthly ?----------------

 

36
37
38
39 Amount of Principal paid in the first three payments:
40
41 Balance after the 3rd payment:
42
43 Amount of interest in the last instalment
44
45 Amount of the last payment:
46
47 Total interest paid:
48
Transcribed Image Text:36 37 38 39 Amount of Principal paid in the first three payments: 40 41 Balance after the 3rd payment: 42 43 Amount of interest in the last instalment 44 45 Amount of the last payment: 46 47 Total interest paid: 48
19 Payment Monthly:
20
21 Complete the Amortization table below, making the necessary adjustments to accommodate prepayments in the schedule:
22
Beginning of period
End of Period Loan
Number of periods
Principal
23
Loan Balance
Payment
Interest
Pre-Payment
Balance
24
25
2
26
3
27
4
28
5
29
6
30
7
31
8
32
33
10
34
11
35
12
(Hint: Cell 135 m
Transcribed Image Text:19 Payment Monthly: 20 21 Complete the Amortization table below, making the necessary adjustments to accommodate prepayments in the schedule: 22 Beginning of period End of Period Loan Number of periods Principal 23 Loan Balance Payment Interest Pre-Payment Balance 24 25 2 26 3 27 4 28 5 29 6 30 7 31 8 32 33 10 34 11 35 12 (Hint: Cell 135 m
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Effective Annual Rate Of Return
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
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