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

Why do you think there has been a strong push to revive

Why do you think there has been a strong push to revive securitisation in Europe? In particular, you should focus on the benefit that good securitisation will bring to the markets.

Hedging using futuressuppose a farmer is expecting that her

Hedging using futures Suppose a farmer is expecting that her crop of oranges will be ready for harvest and sale as 150,000 pounds of orange juice in 3 months time. Suppose each orange juice futures contract is for 15,000 ...

Forward rate what is the meaning of the forward rate in the

Forward Rate : What is the meaning of the forward rate in the context of the term structure of interest rates? Why might forward rates consistently overestimate future interest rates? How could such a bias be avoided?

Suppose a company announces a bid to acquire a smaller

Suppose a company announces a bid to acquire a smaller rival on a day that macroeconomic news indicated that inflation was picking up. On the day of both announcements, the firm's return was -0.55% while the market retur ...

Explain the changes in m1 and m2 if an individual moves

Explain the changes in M1 and M2, if an individual moves money from a small denomination time deposit to a demand deposit account?

Three marbles are selected from a base plate containing 5

Three marbles are selected from a base plate containing 5 red marbles and 3 green marbles. The number X, which represents the total of red marbles obtained in the selection, is noted. marbles are then placed back on the ...

In the face of global oil price shocks what could monetary

In the face of global oil price shocks, what could monetary policymakers do to minimize the resulting recessionary gaps? What would be the tradeoff of such a policy? Illustrate your answer using the aggregate demand-aggr ...

In terms of pumping performance how should engineers

In terms of pumping performance, how should engineers determine the use of radial flow pumps and axial flow pumps?

On 120401 consider a xed-coupon bond whose features are the

On 12/04/01, consider a ?xed-coupon bond whose features are the following: face value: $1,000 coupon rate: 8% coupon frequency: semiannual maturity: 05/06/04 What are the future cash ?ows delivered by this bond?

Finance discussionstep 1 evaluate screen stocksthe

Finance Discussion Step 1 Evaluate / Screen Stocks The objective of this discussion is to create a list of 5 stocks and 5 ETFs. There are numerous websites that have good stock screening tools such as Morningstar and Yah ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate