Calculate interest payment-complete amortization schedule

Assignment Help Financial Management
Reference no: EM131185169

You have just been granted a business loan of $1,000,000. The terms of the loan requires that you pay off the loan in quarterly installments over a period of ten years. The bank is charging you an APR of 10%, compounded monthly.

a) Calculate the interest payment and construct a complete amortization schedule that breaks down the interest and principal repayment associated with each interest payment.

b) After five years, you put down a lump sum of $100,000 on the loan. You keep your payments the same as in (a). By how much time have you shortened the life of your loan?

c) Using present value formulas you learned in class, show the interest and principal payment portions of the 32nd payment, and reconcile your result with the amortization schedule constructed in (a).

Reference no: EM131185169

Questions Cloud

What is the addition to retained earnings : Shelton, Inc., has sales of $405,000, costs of $193,000, depreciation expense of $58,000, interest expense of $39,000, and a tax rate of 40 percent. What is the net income for the firm? Suppose the company paid out $48,000 in cash dividends. What is ..
Economic downturn that has devastated our economy : A few years ago, companies like AIG, who had a hand in the cause of the economic downturn that has devastated our economy, were planning to give or actually gave out huge golden parachutes to the same executives who led and approved of the companies ..
What is value of shareholders equity account for this firm : Sankey, Inc., has current assets of $4,000, net fixed assets of $23,100, current liabilities of $2,500, and long-term debt of $12,400. What is the value of the shareholders' equity account for this firm? How much is net working capital?
Cash flows-What is the IRR for this project : A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 – 54,000 2 – 27,600 Requirement 1: What is the IRR for this project? What is the NPV of the project if the required return is 0 percent? What is the NPV of the project if the require..
Calculate interest payment-complete amortization schedule : You have just been granted a business loan of $1,000,000. The terms of the loan requires that you pay off the loan in quarterly installments over a period of ten years. The bank is charging you an APR of 10%, compounded monthly. Calculate the interes..
Compute the non-operating cash flows : You have been asked by the president of your firm to evaluate the proposed acquisition of new special-purpose equipment. The equipment's base price is $500,000, and another $50,000 for its installation costs. The equipment falls into the MACRS 3-year..
Similarities between net present value-profitability index : Explain the differences and similarities between net present value (NPV) and the profitability index (PI). Should financing costs be included as an incremental cash flow in capital budgeting analysis? Explain the use of real and nominal discount rate..
What is the price of call option on widget shares : The current spot price of a Widget share is $48. One year from now the stock price can be either high ($50 per share) or low ($46 per share). The annual risk-free interest rate is 10%. What is the price of a call option on 100 Widget shares, with an ..
Calculate the firms net income : Garden Pro Corporation has sales of 4,932,580;income tax of 364,280;selling, general and administration expenses of 299,666;depreciation 367,773;cost of goods sold of 2,985,285;interest expense of 106,942. Calculate the firms net income.

Reviews

Write a Review

Financial Management Questions & Answers

  Compute the net present value if the cost of capital

The Horizon Company will invest $96,000 in a temporary project that will generate the following cash inflows for the next three years. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator..

  Determining the monthly payments

Fred was persuaded to open a credit card account and now owes $5,150 on this card. Fred is not charging any additional purchases because he wants to get this debt paid in full. The card has an APR of 15.1 percent. How much longer will it take Fred..

  Capital structure that will maximize shareholder wealth

Financial managers want to choose the capital structure that will maximize shareholder wealth. Shareholder wealth can be maximized by maximizing both the value of the firm and WACC. Changes in capital structure benefit stockholders if the value of th..

  Requires an initial fixed asset investment

Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.43 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be w..

  How much is the stock currently worth

Netscrape Communications does not currently pay a dividend. You expect the company to begin paying a $2.2 per share dividend in 8 years, and you expect dividends to grow perpetually at 3.2 percent per year thereafter. If the discount rate is 14 perce..

  What is payback period of this investment

You are considering making a movie. The movie is expected to cost 10.4 million up front and take a year to produce. After that, it is expected to make 4.4 million in the year it is released and 1.9 million for the following four years. What is the pa..

  What stock price would you consider appropriate

The Perfect Rose Co. has earnings of $2.35 per share. The benchmark PE for the company is 21. What stock price would you consider appropriate?

  What is the financial leverage effect and what causes it

What is the financial leverage effect and what causes it?  What are the potential benefits and negative consequences of high financial leverage?

  Hedge your position resulting from offering customer

The S&P 500 index is currently priced at 1,400. The dividend yield on the index is zero. The current risk free rate is 5%. What is the no-arbitrage forward price for delivery in 6 months? You are a market maker. Demonstrate how you would hedge your p..

  Retirement or lottery

Retirement or Lottery-John is 25 years old and wishes to retire in 30 years. His plan is to invest in a mutual fund earning a 12 percent annual return and have a $1 million retirement fund at age 55. How much must he invest at the end of each year to..

  Market risk premium is estimated-cost of capital

The common stock of Gulf Corp. has a beta of 0.8. The Treasury bill rate is 4 percent and the market risk premium is estimated at 8 percent. Gulf Corp.'s capital structure is 25 percent debt paying a 5 percent interest rate, and 75 percent equity. wh..

  Growing collection animated movies

Ash has a large and growing collection animated movies she wants to replace her old television with a new LCD model so she is started saving for it at the end of each year she deposits $920 in her bank account which pays her 9% interest annually Ash ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd