Question: COMPUTE FOR AMORTIZATION DUE AND CREATE AMORTIZATION SCHEDULE ON THE FOLLOWING: YOU BORROWED MONEY FROM THE BANK WITH THE FOLLOWING TENOR: AMOUNT 150,000 INTEREST 8%

COMPUTE FOR AMORTIZATION DUE AND CREATE AMORTIZATION SCHEDULE ON THE FOLLOWING:

YOU BORROWED MONEY FROM THE BANK WITH THE FOLLOWING TENOR:

AMOUNT 150,000

INTEREST 8% P.A.

MONTHLY PAYMENT

1 YEAR TO PAY

QUESTION: HOW MUCH IS TOTAL INTEREST PAID ON THE LOAN?

QUESTION 2: WHAT IS THE TOTAL BALANCE AFTER 8 PAYMENTS?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

1. Time Value of Money (20 points) 1) You have P25,000 to save for one year and a bank will pay you 2% per annum for use of your money. What will be the value of your savings after one year? (2...

Q:

2) You plan to invest P50,000 now for three years and a bank will pay you compound interest of 2.5% per year. What will be the value after three years? (2 points) 3) You plan to invest P20,000 each...

Q:

answer should be in this boxes: 4 Assessment Task Manual Accounting Electric-bike Store ances Mailings Review View Table Design Layout Tell me A 21 T AaBbCaddi ABC AaBbCodi AaBbccbd AaBbceDd No...

Q:

Cell Copying and Cell Referencing 1. This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate,...

Q:

This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and...

Q:

good afternoon, here is an assignment from pennfoster college which I am unable to do. Can you do it for me? Part 1: El Cap Climbing Company El Cap Climbing Company (ECCC) is a small startup that...

Q:

******PLEASE DON'T COPY FROM OTHER ANSWER BECAUSE THEY ARE NOT CORRECT***** 1)This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the...

Q:

1. This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed...

Q:

Question: Excel 2013 Introductory This worksheet will compute... This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or...

Q:

This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and...

Q:

A company issues $80,000 of 10-year bonds for $86,000. Immediately after the thirteenth semiannual interest payment, the company redeems the bonds for $83,700. The company uses the straightline...

Q:

1. What do you think is the major problem in this case? 2. If you were Habib, what would you do about the situation?

Q:

Anchor Inc. financial statements are presented in the table below. Based on the information in the table, calculate the firm's Operating Return on Assets ratio (EROA). Round the answers to two...

Q:

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".