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 how would stephanies banking service decisions be

1. How would Stephanie's banking service decisions be different if she were a single mother of two children? 2. How would Stephanie's banking service decisions be affected if she were 35 years old? If she were 50 years o ...

Finance assignmentquestion 1150- 200 wordsgo to the finra

Finance Assignment Question 1 150- 200 words Go to the FINRA Bonds Quick Search. http://finra-markets.morningstar.com/BondCenter/Screener.jsp • Click the Corporate check box under Bond Type then click Show Results. • Cho ...

In late 2009 federal reserve chairman ben bernanke wrote

In late 2009, Federal Reserve Chairman Ben Bernanke wrote the following in a column published in the Washington Post: [Proposals in Congress to reduce the independence of the Fed] are very much out of step with the globa ...

Find the future value of the following ordinary annuities

Find the future value of the following ordinary annuities. Payments are made and interest is compounded as given . R=$8000, 6% interest compounded annually for 20 years.

A 5-kg mass hangs on a rope wrapped around a frictionless

A 5-kg mass hangs on a rope wrapped around a frictionless disk (I = 1/2 mr^2) pulley of mass 12 kg and radius 75.0 cm. What is the acceleration of the mass?

Fixed income securitiesdirections answer the following

Fixed Income Securities Directions: Answer the following questions and submit your answers to the Dropbox by midnight Sunday CT. Part I. Short Questions: please organize your answer so that it is short but to the point. ...

Explain the following paradox a put option is a highly

Explain the following paradox. A put option is a highly volatile security. If the underlying stock has a positive beta, then a put option on that stock will have a negative beta (because the put and the stock move in opp ...

Class while us treasury stock and bonds are backed with the

Class, while US Treasury Stock and Bonds are backed with the credit of the US Government, there are still risks attached to these investments. What are these risks?

Distinguish between the front office and the back office of

Distinguish between the front office and the back office of a derivatives dealer. Explain why it is important to keep the front and back offices separate ? Explain why the traditional auditing function cannot serve as th ...

1 iilustrate the relationship between the size and shape of

1. IIlustrate the relationship between the size and shape of a distribution warehouse and the materials handling system. Why do some warehouses have square design while others are rectangular? 2. Explain the following st ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen