How much interest did you pay over the term of the loan

Assignment Help Financial Management

Reference no: EM131588521

Able Medical Clinic has borrowed $30 million from a bank under the following terms: Payments are to be made end of every quarter for next 10 years. The firm also plans to make additional $1 million payment at the end of each of the years 1 thru 5. Interest rate is 6.4% compounded quarterly. Prepare an amortization table. You may like to use Excel to do this, even though you could do it manually. a) How much interest did you pay over the term of the loan? b) What is the outstanding balance at the end of 3 years? Make sure you can compute this using the financial calculator. Verify that the number you obtained from the amortization table is the same as the one obtained using the calculator. c) Show the results of the amortization table showing all the 40 quarters. You may like to color code the display for quarter 12th quarter12, highlighting the result for question b, above.

Reference no: EM131588521

Questions Cloud

Discuss spanking children considered child abuse : Spanking children should or should not be considered child abuse, be sure to define what you mean by spanking.

Levels of communication dramatically : How has the evolution of cell phones changed the levels of communication dramatically.?

Advantages and disadvantages of issuing preferred stock : Preferred Stock vs. Bonds - Discuss the advantages and disadvantages of issuing preferred stock versus bonds

Plot a typical frequency response for such a lip model : Discuss the importance of such a model as the distance between the speakers lips and the microphone is varied.

How much interest did you pay over the term of the loan : How much interest did you pay over the term of the loan? What is the outstanding balance at the end of 3 years?

Use net annual cost to determine the best alternative : Peter is a salesman for Kroner industries which specializes in making of natural gas furnaces. Use net annual cost to determine the best alternative.

Examine main reasons service companies are more sensitive : Examine the main reasons service companies are more sensitive to labor and price variances, as compared to material price variances

Discuss the social and cultural norms : Discuss the social and cultural norms of your vulnerable population and how these play a role in the need for the services offered

Create a proposal for where the revenue would be derived : Create a proposal for where the revenue would be derived if the U.S. were to adopt a zero income tax model

User Account

All Pages