Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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

1 why might a borrower be willing to pay a higher price for

1. Why might a borrower be willing to pay a higher price for a home with an assumable loan? 2. What is a buy down loan? What parties are usually involved in this kind of loan? 3. Why might a wraparound lender provide a w ...

Common stock of pr co has an expected return of 12 the

Common stock of pr Co. Has an expected return of 12% . The expected market return is 14% and risk free rate is 2%. What is pr Co.s Beta coefficient?

In formulating key concept exercise consider the following

In formulating Key Concept Exercise, consider the following questions: What are the benefits of just-in-time (JIT) techniques? What types of organisations use JIT techniques? Should things change if they are running smoo ...

Estate plan scenariokathi and darrin backgroundkathi and

ESTATE PLAN SCENARIO Kathi and Darrin Background Kathi and Darrin have been married for 50 years and are both in good health. Kathi and Darrin live in a community property state. They have the following children and gran ...

1 does rpm actually create a shortest path tree explain

1. Does RPM actually create a shortest path tree? Explain. What are the leaves of the tree? 2. List three steps that a DVMRP router uses to create a source-based tree. Which phase is responsible for creating the part of ...

Lowell made a taxable gift of 2 million to his grandson and

Lowell made a taxable gift of $2 million to his grandson and allocated his remaining exemption of $500,000 to the gift. What is Lowell's GST tax liability in 2014?

Use the normal distribution of fish lengths for which the

Use the normal distribution of fish lengths for which the mean is 8 inches and the standard deviation is 5 inches. Assume the variable x is normally distributed. What percent of the fish are longer than 11 inches? If 500 ...

1 what does a deficiency judgment mean2 what is a land

1. What does a deficiency judgment mean? 2. What is a land contract? 3. How can mechanics' liens achieve priority over first mortgages that were recorded prior to the mechanics' lien?

1 some industries described in this chapter are controlled

1. Some industries described in this chapter are controlled by federal regulatory agencies. How does this affect their accounting systems? 2. When reviewing the financial statements of oil and gas companies, why is it im ...

Suppose that you are following the stock of a firm that has

Suppose that you are following the stock of a firm that has been experiencing severe problems. Failure is imminent unless the firm is granted government guaranteed loans. If the firm fails, its stock will, of course, fal ...

  • 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