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...


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<br>37<br>38<br>39 Amount of Principal paid in the first three payments:<br>40<br>41 Balance after the 3rd payment:<br>42<br>43 Amount of interest in the last instalment<br>44<br>45 Amount of the last payment:<br>46<br>47 Total interest paid:<br>48<br>

Extracted 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:<br>20<br>21 Complete the Amortization table below, making the necessary adjustments to accommodate prepayments in the schedule:<br>22<br>Beginning of period<br>End of Period Loan<br>Number of periods<br>Principal<br>23<br>Loan Balance<br>Payment<br>Interest<br>Pre-Payment<br>Balance<br>24<br>25<br>2<br>26<br>3<br>27<br>4<br>28<br>5<br>29<br>6<br>30<br>7<br>31<br>8<br>32<br>33<br>10<br>34<br>11<br>35<br>12<br>(Hint: Cell 135 m<br>

Extracted 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

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here