DETERMINATION OF EQUAL ANNUAL PAYMENTS
Equal annual payments = Principal ÷ Present value annuity factor (4 Years, 5%)
= 14,000/3.54595050416236
= $3948.16
.
Verification:
| End of Year | Payment | Interest | Principal Repayment | Outstanding Balance |
| 0 | 3948.16 | 14000 | ||
| 1 | 3948.16 | 700 | 3248.16 | 10751.84 |
| 2 | 3948.16 | 537.59 | 3410.57 | 7341.27 |
| 3 | 3948.16 | 367.06 | 3581.1 | 3760.17 |
| 4 | 3948.16 | 188 | 3760.16 | 0 |
(i) interest is calculated on Outstanding balance:
1st year interest = $14,000 x 5% = 700, 2nd year interest = 10751.84 x 5% = 537.59, 3rd year interest = 7341.27 x 5 % = 367.06 and 4th year interest = 3760.17 x 5% = 188
(ii) Principal repayment = Payment - Interest
(iii) Outstanding balance = Previous Year's Outstanding balance - Principal repayment
| Year | Opening balance | Principal repayment | Outstanding Balance |
| 1 | 14000 | 3248.16 | 10751.84 |
| 2 | 10751.84 | 3410.57 | 7341.27 |
| 3 | 7341.27 | 3581.1 | 3760.17 |
| 4 | 3760.17 | 3760.16 | 0 |
SUMMARIZE JOHN'S FINANCIAL POSITION IN BULLET OUTLINE FORMAT
- BORROWS: $14,000
- ASSETS (Cash): $14,000
Note:
1.Bertha borrows's from John's brother do not include in the financial statements of John.
2. The value of 'Present value annuity factor (4 Years, 5%)' taken from present value Table. you can also calculate as follows
| Year | Calculation | Value |
| 1 | 1/(1+0.05)1 | 0.952380952 |
| 2 | 1/(1+0.05)2 | 0.907029478 |
| 3 | 1/(1+0.05)3 | 0.863837599 |
| 4 | 1/(1+0.05)4 | 0.822702475 |
| Annuity factor | 3.545950504 | |
JOHN BORROWS $14000 FROM THE SAVINGS AND LOAN AT A COMPOUND INTEREST RATE OF 5%/YR. HE...
A student borrows $5,000 at 12% nominal rate of interest. The loan is to be paid back in semi-annual payments over the next 4 years. a: What is the semi-annual payment? b: What is the balance of the loan after the student pays the 4th payment c: If payments are made according to the loan schedule, what will be the total interest paid after the student makes the last payment? d: If initially the student had been able to negotiate...
You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate of .5 percent per year, compounded monthly for the first six months, increasing thereafter to 17.3 percent compounded monthly. Assume you transfer the $6,300 balance from your existing credit card and make no subsequent payments. How much interest will you owe at the end of the first year? You are planning to save for retirement over the next 30 years. To do this, you...
1. What is the interest earned from a savings of P10,000 at a simple interest rate of 107 per year for 5 years? (5 points) 2. How long does a man need to invest P5,000 to be P9,000 at an interest rate of 10 compounded annually? (5 points) 3. What is the rate of interest, compounded monthly charged to an investment of P2 000 that pays P1, 205 per month for 2 years. (5 points) 4. How much annual deposit...
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...