We have to first identify the Annual Payment that is to be made every year towards repayment. The same can be found out using the PMT function is MS Excel. The PMT function will give you the exact annual installment amount to be repaid.
Formula for PMT function is =PMT(rate,tenor,minus principal,0). The detailed workings is as below
B | C | ||
1 | Loan Amount | $ 95,000.00 | |
2 | Interest p.a | 5.50% | |
3 | Tenor (Period) | 25 | |
4 | Annual Payments | $7,082.19 | This is arrived at based on the formula given below |
Formula for calculating annual payments | =PMT(rate,tenor,minus principal,0) | ||
Formula for calculating annual payments | =PMT(C2,C3,-C1,0) |
So we now know your annual payment is $7082.19. This payment includes your principal and interest amount. Prepare another table in excel bifurcating the principal and interest amount to be paid every year. Interest amount is 5.5% of the principal outstanding every year and the difference between the interest amount and $7082.19 every year shall be the principal amount being repaid. The table so derived is detailed below. The formulas are mentioned in the top column for reference.
A | B | C | D | E |
Year | Annual Payment | Interest ( Previous Principal Balance (E)* 5.5%) | Principal Portion (Annual Payment (B) - Interest (C)) | Principal Balance (Previous Principal Balance (E) - Annual Payment in Current year (B)) |
0 | - | - | - | 95,000 |
1 | 7,082.19 | 5,225.00 | 1,857.00 | 93,143.00 |
2 | 7,082.19 | 5,122.87 | 1,959.00 | 91,184.00 |
3 | 7,082.19 | 5,015.12 | 2,067.00 | 89,117.00 |
4 | 7,082.19 | 4,901.44 | 2,181.00 | 86,936.00 |
5 | 7,082.19 | 4,781.48 | 2,301.00 | 84,635.00 |
6 | 7,082.19 | 4,654.93 | 2,427.00 | 82,208.00 |
7 | 7,082.19 | 4,521.44 | 2,561.00 | 79,647.00 |
8 | 7,082.19 | 4,380.59 | 2,702.00 | 76,945.00 |
9 | 7,082.19 | 4,231.98 | 2,850.00 | 74,095.00 |
10 | 7,082.19 | 4,075.23 | 3,007.00 | 71,088.00 |
11 | 7,082.19 | 3,909.84 | 3,172.00 | 67,916.00 |
12 | 7,082.19 | 3,735.38 | 3,347.00 | 64,569.00 |
In this table, check for the interest amount being paid in the 12th year. As per the table it is $3735.38. hence the answer is $ 3735.363.
95,000 I How much interest will you pay in the 12th year of a 343,00 S.5%,...
either is fine How much interest will you pay in the 12th year of a $95,000 3.5%, as year mortgage, assuming annual compounding? 3,909,842 9 5,000 3815.028 . 3735.363 3622.791 money markets are markets for: foreign stocks ✓ T-Billr U.S. Stocks
You have just purchased a home and taken out a $460,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR of 5.20%.a. How much will you pay in interest, and how much will you pay in principal, during the first year?b. How much will you pay in interest, and how much will you pay in principal, during the 20th year (i.e., between 19 and 20 years from now)?
You have agreed to loan the owner of a library $5000 for 5 years at a simple interest rate of 8% per year. 1. How much interest will you receive from the loan? 2. How much will the library owner pay you at the end of 5 years? You have agreed to loan the owner of a library $5000 for 5 years at a simple interest rate of 8% per year. 1. How much interest will you receive from the...
How much interest is earned in an account by the end of 5 years if $30,000 is deposited and interest is 4% per year, compounded semi-annually? What is the balance in an account at the end of 10 years if $6,500 is deposited today and the account earns 3% interest compounded annually? If you wish to accumulate $50,000 in 10 years, how much must you deposit today in an account that pays annual interest rate of 8%, with semi-annual compounding...
How much should you pay for a 6 year 6% pay bond when interest rates are 8% (the face value of the bond is $10,000)? What is the present value of a $1 billion bond paying 8%, expiring in 5 years when market interest rates are 6%?
5 points Save Answer How much is your loan amount today if you are going to repay using 63 equal monthly payments of $339 with annual interest of 5.5 percent but assuming monthly compounding? Answer to the nearest dollar amount, and enter without the dollar sign. 5 points How much is your loan amount today if you are going to repay using 63 equal monthly payments of $339 with annual interest of 5.5 percent but assuming monthly compounding? the nearest...
how much would you have to pay for a 6 year bond earning 4.5% simple intere Example 2: How much would you have to pay for a 6-year bond earning 4.5% simple interest whose future value is $1000? Example 3: A 5-year bond costs $1000 and will pay a total of $250 simple interest over its lifetime. What is its annual interest rate?
I borrow $500 today, with an interest of 10% per year. How much should I pay back after one year?
Help Save & Exi If you have a $225,000, 5%, 30-year mortgage, how much interest will you save if you 360 days a year. Round your answer to the nearest cent.)
How much is a bond worth if you pay $55 per year in interest forever in the market interest rate is 8% Question 11 2 pts How much is a bond worth if it pays $55 per year in interest forever and the market interest rate is 8%? $440 5687.50 $787.60 $1,250