Calculate the amount of the quarterly repayment

Assignment Help Financial Management
Reference no: EM132031265

Prepare a spreadsheet to show a repayment schedule for a loan of $100,000, repayable quarterly over 10 years calculated at an effective interest rate of 9.68%

(a) Calculate the amount of the quarterly repayment.

(b) Calculate the loan outstanding right after the 10th payment.

(c) Calculate the interest component of the 11th payment.

(d ) Calculate the principal(capital) repaid in the 11th payment. interest rate 20.00% per annum, effective.

Reference no: EM132031265

Questions Cloud

Current trend toward nationalism : What marketing approach should multi-national companies take in light of the this current trend toward nationalism?
Activity centers and resources in low income neighborhoods : My selected topic is "There needs to be more activity centers and resources in low income neighborhoods"
How many shares can the company buyback : If WyoOne Corp. announces a share buyback program at $22.5 per share, how many shares (in millions) can the company buyback?
Differences affect how individuals view conflict : How would personality differences affect how individuals view conflict, attempt to resolve conflict or respond to conflict?
Calculate the amount of the quarterly repayment : Prepare a spreadsheet to show a repayment schedule for a loan of $100,000, Calculate the amount of the quarterly repayment.
Discuss with reference to appropriate literature sources : According to Dasgupta and Gupta "The increasing turbulence in the external business environment has focused attention on the resources and organizational
What is the amount of net fixed assets : Pearce's has a long-term debt ratio of .45 and a current ratio of 1.25. Current liabilities are $875, sales are $5, 780, profit margin is 9.5%.
What is the nature of the three promotion methods : What is the nature of the three promotion methods? Also, what are the strengths and limitations of each method?
How much more in total payments will simon make : How much more in total payments will Simon make under the $20-a-month plan than under the $60-a-month plan. Do not round intermediate calculations.

Reviews

Write a Review

Financial Management Questions & Answers

  Accepted position at major corporation earning

You recently graduated from college with a business degree and accepted a position at a major corporation earning more than you could ever dreamed. Make five lists of the financial service firms that could provide you each of these services.

  Other lending institution to offer different rates

Truth in Lending and the Equal Credit Opportunity act make it illegal for a bank or other lending institution to offer different rates.

  What floating rate can it swap this fixed rate into

Company X has been offered the rates shown in Table. It can invest for 4 years at 5.5%. What floating rate can it swap this fixed rate into?

  Convertible bond pays interest annually at coupon rate

A convertible bond pays interest annually at a coupon rate of 5% on a par value of $1,000.

  Think of major-well-known business-national government

Think of a major, well-known business; a prominent not-for-profit organization; and a state, provincial, or national government.

  Consider when choosing between these two investment options

Discuss what non-financial criteria you would consider when choosing between these two investment options? Support your conclusions, why or why not?

  Weight used for equity in computation of solar shade wacc

what would be the weight used for equity in the computation of Solar Shade's WACC?

  Calculate intrinsic value per share

HCB, Inc. just had free cash flows of $4.00 million (FCF0). Calculate HCB's intrinsic value per share.

  Considering opening up a chain of coffee shop

LilyMac Studios, a national chain of photography studios, is considering opening up a chain of coffee shop/ art galleries. While the existing operations of the firm have a beta of 1.17, the new chain is expected to have a beta of 0.8. The new chain w..

  Semiannual coupon bond matures

An 8% semiannual coupon bond matures in 5 years. What is the bond's price? What is the bond's YTM?

  Using the profitability index when evaluating projects

Good Morning Food, Inc. is using the profitability index (PI) when evaluating projects.

  Portfolio of stocks that have achieved the returns

You own the following portfolio of stocks that have achieved the following returns. [Stock A weight=25%, expected return=8%], [Stock B weight=65%, expected return=4%], [Stock C weight=10%, expected return=5%] The weighted average return is

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