Question
In: Finance
Richard borrowed 50,000 from a bank at 12% (APR) semiannually compounded interest to be repaid in...
Richard borrowed 50,000 from a bank at 12% (APR) semiannually compounded interest to be repaid in 10 years (12 equal installments) . Calculate the interest and principal paid in the fourth year. USE EXCEL FORMULAS SO I CAN SEE THE INPUTS PLEASE AND SHOW THE WORK I WANT TO LEARN IT!
Solutions
Expert Solution
We are given the following information:
| Loan Period | 10 |
| Interest rate | 12% |
| PMT frequency | 2 |
| Loan amount | 50000 |
We need to solve the following equation to arrive at the
required PMT
So the PMT is $4359.23. We can get the following schedule:
| Year | Opening Balance | Loan | PMT | Interest | Principal repayment | Closing Balance |
| 0 | 50000 | 50000 | ||||
| 1 | 50000 | 4359.22785 | 3000 | 1359.227849 | 48640.77215 | |
| 2 | 48640.77215 | 4359.22785 | 2918.446329 | 1440.78152 | 47199.99063 | |
| 3 | 47199.99063 | 4359.22785 | 2831.999438 | 1527.228411 | 45672.76222 | |
| 4 | 45672.76222 | 4359.22785 | 2740.365733 | 1618.862116 | 44053.9001 | |
| 5 | 44053.9001 | 4359.22785 | 2643.234006 | 1715.993843 | 42337.90626 | |
| 6 | 42337.90626 | 4359.22785 | 2540.274376 | 1818.953473 | 40518.95279 | |
| 7 | 40518.95279 | 4359.22785 | 2431.137167 | 1928.090681 | 38590.86211 | |
| 8 | 38590.86211 | 4359.22785 | 2315.451726 | 2043.776122 | 36547.08599 | |
| 9 | 36547.08599 | 4359.22785 | 2192.825159 | 2166.40269 | 34380.6833 | |
| 10 | 34380.6833 | 4359.22785 | 2062.840998 | 2296.386851 | 32084.29644 | |
| 11 | 32084.29644 | 4359.22785 | 1925.057787 | 2434.170062 | 29650.12638 | |
| 12 | 29650.12638 | 4359.22785 | 1779.007583 | 2580.220266 | 27069.90612 | |
| 13 | 27069.90612 | 4359.22785 | 1624.194367 | 2735.033482 | 24334.87263 | |
| 14 | 24334.87263 | 4359.22785 | 1460.092358 | 2899.135491 | 21435.73714 | |
| 15 | 21435.73714 | 4359.22785 | 1286.144229 | 3073.08362 | 18362.65352 | |
| 16 | 18362.65352 | 4359.22785 | 1101.759211 | 3257.468637 | 15105.18489 | |
| 17 | 15105.18489 | 4359.22785 | 906.3110932 | 3452.916756 | 11652.26813 | |
| 18 | 11652.26813 | 4359.22785 | 699.1360878 | 3660.091761 | 7992.176369 | |
| 19 | 7992.176369 | 4359.22785 | 479.5305822 | 3879.697267 | 4112.479103 | |
| 20 | 4112.479103 | 4359.22785 | 246.7487462 | 4112.479103 | 0 | |
| 87184.557 | 37184.55698 | 50000 |
- Opening balance = previous year's closing balance
- Closing balance = Opening balance+Loan-Principal repayment
- PMT is calculated as per the above formula
- Interest = 0.12 x opening balance
- Principal repayment = PMT - Interest
- The yellow marked rows are for year 4. As there are semiannual payments, so first 6 rows are fore years 1-3
- Interest paid in year 4 = 4746.588894
- Principal repaid in year 4 = 3971.866804
jeff jeffy answered 1 year agoRelated Solutions
A company borrowed $16,000 paying interest at 9% compounded annually. If the loan is repaid by...
A company borrowed $16,000 paying interest at
9% compounded annually. If the loan is repaid by payments of $
1800 made at the end of each year,
construct a partial amortization schedule showing the last three
payments, the total paid, and the total interest paid.
Complete the table below for the last three payments.
(Do not round until the final answer. Then round to the nearest
cent as needed.)
Payment Number
Amount Paid
Interest Paid
Principal Repaid
Outstanding Principal
17...
a) Mariah borrowed $50,000 for 30 years at 11.2 percent compounded semiannually. How much of payment...
a)
Mariah borrowed $50,000 for 30 years at 11.2 percent compounded
semiannually. How much of payment 36 will go towards paying off
principal?
$877.79
$745.42
$831.24
$787.16
b)
Chris borrowed $52,000 for 25 years at 5.4 percent compounded
monthly. What will the ending balance be after Chris has made one
year of payments?
$51,074.87
$50,988.48
$50,901.70
Find the effective interest rate fora) 10% compounded monthly?b) 12% compounded semiannually.
Find the effective interest rate fora) 10% compounded monthly?b) 12% compounded semiannually.
Jia borrows $50,000 at 10 percent annually compounded interest to be repaid in four equal annual...
Jia borrows $50,000 at 10 percent annually compounded interest
to be repaid in four equal annual installments. The actual
end-of-year loan payment is
Cooper corporation has borrowed $120,000 from the bank at 8% annual interest rate, compounded monthly. The...
Cooper corporation has borrowed $120,000 from the bank at 8%
annual interest rate, compounded monthly. The company plans to pay
$2000 per month for the first 12 months, and then pay $2500 per
month for the next 12 months. Find the remaining balance of the
loan after 24 months. (Answer: $82655.21)
Please answer in excel format
Jesse borrowed $10,000 from Tony at an interest rate of 12% per year, compounded monthly. Jesse...
Jesse borrowed $10,000 from Tony at an interest rate of 12% per
year, compounded monthly. Jesse convinced
Tony to allow him to make monthly payments. The first payment
was agreed upon to be $100 and it would be paid
exactly one month after receiving the $1
0,000. Jesse promised Tony that fu
ture monthly payments would increase
by 1% more than the previous payment. Given Jesse’s
monthly payment schedule, the number of months necessary
to completely pay off the loan...
A loan of $13 comma 000 with interest at 12% compounded semi dash annually is repaid...
A loan of $13 comma 000 with interest at 12% compounded semi
dash annually is repaid by payments of $ 937.00 made at the end of
every three months. (a) How many payments will be required to
amortize the loan? (b) If the loan is repaid in full in 2 years,
what is the payout figure? (c) If paid out, what is the total
cost of the loan? (a) The number of payments required to amortize
the loan is nothing....
RM60,000 is borrowed for 12 years at 5% compounded annually. The borrower does not pay interest...
RM60,000 is borrowed for 12 years at 5% compounded annually. The
borrower does not pay interest currently and will pay all accrued
interest at the end of 12 years together with the principal.
(a) Find the amount annual sinking fund deposit necessary to
liquidate the loan at the end of 12 years if the sinking fund earns
3% yearly compounding and the borrower make first payment
immediately.
(b) Prepared a sinking fund schedule.
Ans: (a) RM 7,371.25
You borrowed an X amount of money from a local bank to be repaid over N...
You borrowed an X amount of money from a local bank to
be repaid over N months at an interest rate i
(assume your own numbers for X, i, N).
Create a table (using Excel) showing each month’s interest in $
(I), principal repayment, and amount of principal
remaining at the end of each month.
Suppose that you decided to pay out the remaining principal all
at once after few monthly payments (< N), how much will
you pay? Use...
You borrowed an X amount of money from a local bank to be repaid over N...
You borrowed an X amount of money from a local bank to
be repaid over N months at an interest rate i
(assume your own numbers for X, i, N).
Create a table (using Excel) showing each month’s interest in $
(I), principal repayment, and amount of principal
remaining at the end of each month.
Suppose that you decided to pay out the remaining principal all
at once after few monthly payments (< N), how much will
you pay? Use...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
- Research the internet for companies that have executed data science projects. Pick one company and describe...
- Explain two theories or frameworks for understanding how Western Europe emerged out of 1,000 years of...
- Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are...
- What is the potential of a cell made up of Zn|Zn2+ and Cu|Cu2+ half-cells at 25o...
ADVERTISEMENT