Question

You borrowed an X amount of money from a local bank to be repaid over Nmonths...

You borrowed an X amount of money from a local bank to be repaid over Nmonths at an interest rate i (assume your own numbers for X, i, N).

  1. 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.
  2. Suppose that you decided to pay out the remaining principal all at once after few monthly payments (<N), how much will you pay? Use the P/A relationship to answer this part and compare to the numbers in the table you established in part (a).

Homework Answers

Answer #1

total interest = $718.07

interst rate = 13%

part b ) payment is completed after 6 months of installments

          

therfore if we pay 12 months installments we have to pay a interest of $718.07

but if we pay six months of installlments and pay rest amount in one go then we have to pay net interest = $576.52

diffrence of interest = approx $142

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Zetix borrowed $20,000 on a one-year, 10 percent note payable from the local bank on March...
Zetix borrowed $20,000 on a one-year, 10 percent note payable from the local bank on March 1. Interest was paid quarterly, and the note was repaid one year from the time the money was borrowed. Requirements Calculate the amount of cash payments Zetix was required to make in each of the two calendar years that were affected by the note payable assuming accounting period ends on Dec. 31 each year. Part II Topic: Liabilities and Payroll Total Marks=2.5 3 Glen...
Mahmoud has borrowed SR 7,000 from a local bank, such that he will pay them back...
Mahmoud has borrowed SR 7,000 from a local bank, such that he will pay them back in 5 equal installments starting from the end of year 1 (i.e. first payment will be due at n=1). After making the second installment (i.e. at n=2), Mahmoud decided to settle his loan (i.e. pay the remaining amounts to the bank), how much should the bank charge him at 9% interest? a) 6345 b) 5760 c) 5163 d) 4555 e) 3936
Kingsley Toyota borrowed $170,000 from a local bank. The loan requires Kingsley to pay 14 equal...
Kingsley Toyota borrowed $170,000 from a local bank. The loan requires Kingsley to pay 14 equal annual installments beginning one year from today. Assume an interest rate of 6%. What is the amount of each annual installment payment? (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) (Round your final answers to nearest whole dollar amount.) Table or calculator function: Loan Amount: n...
a. Mr. Peter borrowed money amounting to $10,000.00 from Captec bank to finance his Livestock farming...
a. Mr. Peter borrowed money amounting to $10,000.00 from Captec bank to finance his Livestock farming business. The Bank’s interest rate is at 24% with the loan to be repaid in 4 years. i. Calculate the loan repayment using Equal Total Payment Loan Principal method. b. Given that Mr. Peter’s net operating income before depreciation of his farm building is $42,000 annually and the overall capitalization rate for this type of property is 13%. Calculate the value of his property?
Canliss Mining Company borrowed money from a local bank. The note the company signed requires five...
Canliss Mining Company borrowed money from a local bank. The note the company signed requires five annual installment payments of $20,000 beginning one year from today. The interest rate on the note is 9%.(FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) What amount did Canliss borrow? (Round your final answers to nearest whole dollar amount.) Table or calculator function: Payment: n =...
Use an Excel worksheet to answer the following five car loan problems you borrowed money from...
Use an Excel worksheet to answer the following five car loan problems you borrowed money from your local bank to purchase a car. The bank requires you to repay the loan over 48 months and charges a fixed, annual interest rate of 6 percent. The amount of your loan is $25,000 a,How much will your loan payment be each month? b,How much of the first loan payment will go toward principal? c,How much interest will you pay during the 1st...
Ms. Klein borrowed $2,000 from a bank on annuity for 2 years at 10% annual interest...
Ms. Klein borrowed $2,000 from a bank on annuity for 2 years at 10% annual interest compounded and payable semiannually (every six months). Calculate the semiannual payments and provide a table that shows semiannual payment, balance, interest payment, payment to principal for each payment as well as total amount which Ms. Klein will pay to the bank for the borrowed amount including interest and principal payments in the entire period of two years.
4. Ms. Klein borrowed $2,000 from a bank on annuity for 2 years at 10% annual...
4. Ms. Klein borrowed $2,000 from a bank on annuity for 2 years at 10% annual interest compounded and payable semiannually (every six months). Calculate the semiannual payments and provide a table that shows semiannual payment, balance, interest payment, payment to principal for each payment as well as total amount which Ms. Klein will pay to the bank for the borrowed amount including interest and principal payments in the entire period of two years.   
4. Ms. Klein borrowed $2,000 from a bank on annuity for 2 years at 10% annual...
4. Ms. Klein borrowed $2,000 from a bank on annuity for 2 years at 10% annual interest compounded and payable semiannually (every six months). Calculate the semiannual payments and provide a table that shows semiannual payment, balance, interest payment, payment to principal for each payment as well as total amount which Ms. Klein will pay to the bank for the borrowed amount including interest and principal payments in the entire period of two years.
5. Mr. Smart borrowed $25,000 from a bank on annuity for 2 years at 10% annual...
5. Mr. Smart borrowed $25,000 from a bank on annuity for 2 years at 10% annual interest compounded and payable semiannually (every six months). Calculate the semiannual payments and provide a table that shows periodic payment, balance, interest payment, payment to principal for each payment as well as total amount which Mr. Smart will pay to the bank for the borrowed amount including interest and principal payments in the entire period of two years.