Prepare spreadsheet to show repayment schedule

Assignment Help Financial Management

Reference no: EM132031862

1. 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.

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

Reference no: EM132031862

Questions Cloud

Calculate after tax internal rate of return achieved : Calculate the after tax internal rate of return achieved by the lender on its investment over this loan to an accuracy of 0.01%,

What is the impact and scope of the issue : At least 2 HC related managerial issues your job role is dealing with. Proposed solutions and the policies supporting them.

What is AMCs share price prior to the share repurchase : AMC's enterprise value to either $580 million or $180 million. What is AMC's share price prior to the share repurchase?

Identify the most relevant learning points in this course : Identify the 3 most relevant learning points in this course that you have felt will make a difference in your job, or future career

Prepare spreadsheet to show repayment schedule : Prepare a spreadsheet to show a repayment schedule for a loan of $100,000,

Evaluate existing operations as well as proposed new : Compose a document that explains the advantages and disadvantages of each of the three methods and recommends one for adoption.

Explain why employees who collect chemical samples : Identify three factors that can contribute to the severity of a chemical burn. Propose a control method for each factor.

What is expected capital gains yield over next year for bond : what is the expected capital gains yield over the next year for Bond P and Bond D?

What you hope to achieve in the graduate program : How your past education and other experiences have prepared you to be successful in the graduate program. What you hope to achieve in the graduate program

User Account

All Pages