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

Assignment Help Financial Management

Reference no: EM131445319

Able Medical Clinic has borrowed $60 million from a bank under the following terms: Payments are to be made end of every quarter for next 10 years. Interest rate is 8.4% compounded quarterly (i.e., 2.1% per quarter). Prepare an amortization table. You may like to use Excel to do this, even though you could do it manually. The firm also plans to make additional $1 million payment at the end of each of the years 1 thru 5.

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 12 to check and highlight the result for question b, above.

Reference no: EM131445319

Questions Cloud

The investment will be depreciated straight line : The initial investment in the project will be $21 million, and the investment will be depreciated straight line, down to a salvage value of $9 million at the end of the fourth year. The revenues are expected to be $24 million next year and to grow 5%..

Sufficient to maintain the long-standing policy : The manager of a municipal ice rink is concerned that the flow of patrons will not be sufficient to maintain the long-standing policy of keeping the rink on a self-supporting basis. Revenues come mainly from the hourly rental of ice time (the city ha..

What is the duration of a two-year zero-coupon bond : What is the duration of a two-year bond that pays an annual coupon of 10.1 percent and has a current yield to maturity of 12.1 percent? Use $1,000 as the face value. What is the duration of a two-year zero-coupon bond that is yielding 11.5 percent?

Project requires initial investment in net working capital : Down Under Boomerang, Inc. is considering a new three-year expansion project that requires an initial fixed asset investment of $4,200,000. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it wi..

How much interest did you pay over the term of the loan : Able Medical Clinic has borrowed $60 million from a bank under the following terms: Payments are to be made end of every quarter for next 10 years. Interest rate is 8.4% compounded quarterly (i.e., 2.1% per quarter). Prepare an amortization table. Ho..

Which specializes in making of natural gas furnaces : Peter is a salesman for Kroner industries which specializes in making of natural gas furnaces. Peter has told you that your current furnace needs to be replaced and he offers the following choices. All furnaces have a useful life of 10 years. Choice ..

Stock has standard deviation of return : A portfolio is composed of two stocks, A and B. Stock A has a standard deviation of return of 17%, while stock B has a standard deviation of return of 23%. Stock A comprises 70% of the portfolio, while stock B comprises 30% of the portfolio.

What is the total return of the tips in percentage : Consider a 2.85 percent TIPS with an issue CPI reference of 200.4. The bond is purchased at the beginning of the year (after the interest payment), when the CPI was 210.3. What is the total return of the TIPS in percentage?

Calculate the price-earnings ratio : You are considering an investment in Roxie's Bed & Breakfast Corp. During the last year, the firm's income statement listed an addition to retained earnings of $12.60 million and common stock dividends of $1.90 million. What is Roxie's Bed & Breakfas..

User Account

All Pages