Ask Question, Ask an Expert


Ask Basic Finance Expert

Able Medical Clinic has borrowed $20 million from a bank under the following terms: Payments are to be made end of every quarter for next 10 years. Interest rate is 1.65% per quarter. Prepare an amortization table. You may like to use xl 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 2 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) Cut and paste the results of the amortization table showing the rows for quarters 1 to 10, and quarters 38 to 40. You can do this by simply hiding the printing of quarters using the format command in xl. You may like to color code the display for quarters 1 to 10 and quarters 38 to 40 to improve readability

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M940010

Have any Question? 

Related Questions in Basic Finance

A firm has a capital structure that uses 45 percent equity

A firm has a capital structure that uses 45 percent equity, 20 percent preferred shares, and 35 percent debt. The preferred shares have a current yield of 5.5 percent. The debt has a coupon rate of 10 percent and a curre ...

1 to what agencies and other users of financial statements

1. To what agencies and other users of financial statements must banks report? 2. Why must the user be cautious in analyzing bank holding companies? 3. What is usually the biggest expense item for a bank? 4. What does th ...

1 under what conditions could it make sense to combine

1. Under what conditions could it make sense to combine private and public warehouses in a logistical system? 2. What role can a warehouse play in postponement strategies? 3. What is the concept of market presence, and h ...

What is storage why is it risky what role does it play in

What is storage? Why is it risky? What role does it play in the economy? Why is delivery important if so few futures contracts end in delivery? What are the major functions of derivative markets in an economy? Why is spe ...

1 profits might be compared with sales assets or

1. Profits might be compared with sales, assets, or stockholders' equity. Why might all three bases be used? Will trends in these ratios always move in the same direction? 2. What is the advantage of segregating extraord ...

Taxable income- nick is married and has three children in

Taxable Income:- Nick is married and has three children in college. His wife is a homemaker. Nick has an adjusted gross income of $37,400. If Nick's standard deduction is $11,900, his itemized deductions are $12,200, and ...

1 based on the following information construct a

1. Based on the following information, construct a traditional financial institution balance sheet AND a balance sheet including off-balance sheet items. Market value of assets = 200                                      ...

The following financial information is for a galler company

The following financial information is for A. Galler Company for 2011, 2010, and 2009 Required a. For 2011, 2010, and 2009, determine the following: 1. Return on assets (using end-of-year total assets) 2. Return on inves ...

Problems -1 triangular arbitragesuppose you observe the

Problems - 1. Triangular Arbitrage Suppose you observe the following posted exchange rates on the Japanese yen (¥) and South African ran (R) against the US dollar: JPY - ¥97.3702/$ ZAR - R10.1453/$ The posted cross rate ...

1 what are the main advantages and disadvantages to

1) What are the main advantages, and disadvantages, to entering a futures hedge? Explain your answer with reference to a futures contract on wheat. Assume the current price is 400 cents per bushel and the futures price i ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro