Question

In: Finance

. Ali borrowed Rs.550,000 from a bank on terms of 12 year, 10% nominal interest rate....

. Ali borrowed Rs.550,000 from a bank on terms of 12 year, 10% nominal interest rate. The loan calls for quarterly payments. a) Calculate the amount of quarterly payment you would be paying every period? b) How much is the total amount of interest that Ahmed has paid in two years? What is the ending balance of principal after two years?

Solutions

Expert Solution

Part a)

where, P=principal =$550,000; n=Number of quarterly payment = 12years*4 = 48quarters; r=interest rate per quarter = 10%/4 =2.5%

Amount of quarterly payment = $550,000*2.5%*[(1+0.025)^48]/{[(1+0.025)^48]-1}

= 13750*(1.025^48)/[(1.025^48)-1]

= 13750*3.2714895607/2.2714895607

= $19,803.30

Part B)

Constructed repayment schedule:

Quarter (i) Outstanding at the beginning of the quarter (ii) Interest (iii) =(ii)*2.5% Repayment (iv) (refer part a) Outstanding at the end of the quarter (v)=(ii)+(iii)-(iv)
1 550,000 13,750 19,803 543,947
2 543,947 13,599 19,803 537,742
3 537,742 13,444 19,803 531,382
4 531,382 13,285 19,803 524,864
5 524,864 13,122 19,803 518,182
6 518,182 12,955 19,803 511,333
7 511,333 12,783 19,803 504,313
8 504,313 12,608 19,803 497,118
105,544

Total amount of interest paid in 2years = $105,544

Ending balance of principal after 2 years = $497,118


Related Solutions

A bank makes a 10-year loan of $100,000 at an interest rate of 12%. What are...
A bank makes a 10-year loan of $100,000 at an interest rate of 12%. What are the monthly payments. What is the balance at the end of year 4?
On November 1, 2018, Company borrowed $30,000 from a bank sign a 12-month, 6% interest rate...
On November 1, 2018, Company borrowed $30,000 from a bank sign a 12-month, 6% interest rate the first payment due on December 1, 2018. What should the company report on B/S, I/S and Statement of cashflow on Dec 31, 2018 and Dec 31, 2019?
LLB Industries borrowed $230,000 from Trust Bank by issuing a two-year, 12% note, with interest payable...
LLB Industries borrowed $230,000 from Trust Bank by issuing a two-year, 12% note, with interest payable quarterly. LLB entered into a two-year interest rate swap agreement on January 1, 2021, and designated the swap as a fair value hedge. Its intent was to hedge the risk that general interest rates will decline, causing the fair value of its debt to increase. The agreement called for the company to receive payment based on a 8% fixed interest rate on a notional...
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...
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!
You borrowed from the bank $300,000 with an annual interest rate of 6% and a maturity...
You borrowed from the bank $300,000 with an annual interest rate of 6% and a maturity of 30 years.   Determine the monthly mortgage payment.
Your bank offers a savings account that pays a stated (nominal) interest rate of 12 percent...
Your bank offers a savings account that pays a stated (nominal) interest rate of 12 percent per year, compounded quarterly. Requirement 1: If you deposit $8,000 today into this account and leave it invested for 6 years, how much will you have in the account at the end of Year 6? (Enter rounded answer as directed, but do not use rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).) Account Balance $    Requirement 2: What...
Bank A is offering a 1-year CD at a nominal compound interest rate of 5.59% with...
Bank A is offering a 1-year CD at a nominal compound interest rate of 5.59% with an APY of 5.75%. Bank B is offering a 1-year CD at a nominal compound interest rate of 5.67% with an APY of 5.75%. Showing your computations, explain in some detail how each of these banks is evidently employing one of the standard compounding frequencies (semi-annually, quarterly, monthly, weekly, or daily) to legally advertise identical APY’s even though each bank uses a different nominal...
LLB Industries borrowed $310,000 from Trust Bank by issuing a two-year, 10% note, with interest payable...
LLB Industries borrowed $310,000 from Trust Bank by issuing a two-year, 10% note, with interest payable quarterly. LLB entered into a two-year interest rate swap agreement on January 1, 2021, and designated the swap as a fair value hedge. Its intent was to hedge the risk that general interest rates will decline, causing the fair value of its debt to increase. The agreement called for the company to receive payment based on a 10% fixed interest rate on a notional...
LLB Industries borrowed $390,000 from Trust Bank by issuing a two-year, 10% note, with interest payable...
LLB Industries borrowed $390,000 from Trust Bank by issuing a two-year, 10% note, with interest payable quarterly. LLB entered into a two-year interest rate swap agreement on January 1, 2018, and designated the swap as a fair value hedge. Its intent was to hedge the risk that general interest rates will decline, causing the fair value of its debt to increase. The agreement called for the company to receive payment based on a 10% fixed interest rate on a notional...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT