Question

John Asiedu agreed to You are required to: cisehoborrowed GHC 10,000 from his bank at interest rate of 18% and 6. 1 ay equal installments over five years. De termine the size of the payments an amortization schedule for the loan. b) Set up amort Solution A PMT A-GHe10.000 3.127 A GHe3,197.95 a) Amortization Schedule
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

SORRY BUT WE HAVE TO USE PVIFA AND NOT FVIFA WORD. AND A/PVIFA AND NOT PMT/FVIFA

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text aCopy FormatCietEditing в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard Alignment Number Cells N90 83 84 85 86 87 STEP 1 PRESENT VALUE OF ANNUITY PVIFA PVIFA 1/0.18 (1-(1/(1+0.18)A5) 3.127171 (ROUNDED TILL 6 DECIMALS) ANS a: SIZE OF PAYMENTS PMT STEP 2 PMT LOAN/PVIFA 10000/3.127171 89 90 91 92 93 94 95 96 97 98 PMT PMT = 3197.778439 ANS b : AMORTIZATION SCHEDULE STEP 3 BALANCE YEAR PORTION TO INTEREST C- A*0.15 PORTION TO PRINCIPAL D- B-C NEW BALANCE E-A-D FORWARD PAYMENT 1 10,000.00 $ 3,197.78 $ 1,800.00$1,397.78 $ 8,602.22 2 $ 8,602.223,197.78 1,548.401,649.38 $ 6,952.84 3 6,952.843,197.78 $ 1,251.51 4 5,006.583,197.78 901.182,296.59 $ 2,709.98 5 2,709.98$ 3,197.78 S 487.802,709.98 $ 1,946.27 5,006.58 100 101 11 トトー MÍN VAR PORT BEST CAL BİNOMIAL 2 TIME- SINKING AMORTIZA Sheet2 0.00 ORDAN INSURANCE 130% 02:17 10-01-2019

Add a comment
Know the answer?
Add Answer to:
John Asiedu agreed to You are required to: cisehoborrowed GHC 10,000 from his bank at interest...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2) You have received a 3-year $10,000 loan from your bank. This is an amortized loan...

    2) You have received a 3-year $10,000 loan from your bank. This is an amortized loan which means you have to make 3 equal annual payments to the bank. The bank is charging you 12% APR (annual percentage rate) for this loan. a. Complete the following amortization schedule. (25 points) Amortization schedule Beginning Balance Annual Payment Interest Balance Reduction year End Balance Expense $10,000 $0.00 How much in total you end up paying back to the bank? (5 points) Assume...

  • You want to borrow $10,000 from a local bank, which is to be repaid in 2...

    You want to borrow $10,000 from a local bank, which is to be repaid in 2 equal semiannual installments. The loan officer initially offered an interest rate of 12% compounded monthly. However, you were able to negotiate that interest be compounded semiannually instead of monthly. With this negotiation, how much do you save in total interest payments over the loan life?

  • Brian borrows $5,000 from a bank at 8 percent annually compounded interest to be repaid in five annual installments. Cal...

    Brian borrows $5,000 from a bank at 8 percent annually compounded interest to be repaid in five annual installments. Calculate the principal paid in the third year. a. Calculate the​ annual, end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. Amortization Schedule End-of-year Beginning-of-year principle Loan Payment Loan Payment End-of-year balance Interest Paid Principal Paid 1 5,000 2 3 c. Explain why the interest portion of each...

  • 30 A bank is offering you a loan of $10,000 for 20 years. The stated interest...

    30 A bank is offering you a loan of $10,000 for 20 years. The stated interest rate (APR) is 7%. If this is an interest-only loan for 5 years with monthly payment, i.e., you pay monthly interest only for the first five years, and then you make equal amortized payments monthly in the second fifteen years, how much are your monthly payments in second fifteen years? Type in your numerical answer with two decimal numbers. No dollar symbol. t of...

  • 6.            You would like to borrow $10,000 at an interest rate of 8 percent per year...

    6.            You would like to borrow $10,000 at an interest rate of 8 percent per year for five years. You agree to make interest and principal payments totaling $2,401.49 at the end of each year. Prepare a loan amortization schedule for each of the five years, showing the beginning principal balance, the total payment of $2,401.49, the interest component of the payment, the principal component of the payment, and the ending principal balance.   a.            Fill in the blank spaces in...

  • Name: SID: nment 5 Barbara borrowed $12 000.00 from the bank at 9% compounded monthly. The...

    Name: SID: nment 5 Barbara borrowed $12 000.00 from the bank at 9% compounded monthly. The loan is amortized with end-of-month payments over five years. a) Calculate the interest included in the 20th payment. b) Calculate the principal repaid in the 36th payment. c) Construct a partial amortization schedule showing the details of the first two payments, the 20th payment, the 36th payment, and the last two payments. d) Calculate the totals of amount paid, interest paid, and the principal...

  • 2-13 interest Idle P J. R. Smith plans to borrow $200,000 through a 30-year mortgage from his bank to buy a home....

    2-13 interest Idle P J. R. Smith plans to borrow $200,000 through a 30-year mortgage from his bank to buy a home. If the bank charges him an interest rate of 7 percent, find the (a) Monthly mortgage payment (b) Amortization schedule for the first 3 months: balance after each payment: principal and interest portions of each payment. (c) For the first 221 payments, what is the total interest paid and the total principal. (d) How much would J. R....

  • aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...

    aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...

  • RussEll MK (a) Mr Muzungu is running a sole proprietorship business which he inherited from his...

    RussEll MK (a) Mr Muzungu is running a sole proprietorship business which he inherited from his father several years ago. As part of his expansion plans, he intends to get a motor vehicle to be used to run several errands, as the current car he uses, is shared between himself and his wife. He has been advised by his colleague that he should get a motor vehicle loan from one of the top banks. The motor vehicle he intends to...

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT