What is your monthly payment

Assignment Help Finance Basics
Reference no: EM131226715

Excel Exercise: Loan Amoritization

Loan Amoritization Video: https://www.youtube.com/watch?v=PlMvy2fnrQ0

Create a Loan Amortization Schedule Excel Assignment

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. You can rewatch the video on p. 8 of this lesson and/or create a loan amortization schedule similar to the one illustrated in under LO 4.13 of Chapter 4 of the textbook.

1. Create a loan amortization schedule using Excel for a \$15,000 car loan that will be repaid over 60 months at an annual interest rate of 6%.

a. What is your monthly payment?

b. What is the total amount of payments made over the life of the loan

2. Create a loan amortization schedule using Excel for an \$180,000 mortgage that will be repaid over 30 years with monthly payments. The annual interest rate is 5.5%.

a. What is your monthly payment?

b. What is the total amount of payments made over the life of the loan?

c. How many years will it take to pay off the loan if you pay an extra \$100 per month?

Attachment:- Attachments.rar

What is the gain or loss on this transaction

A hedger takes a short position in five T-bill futures contracts at the price of 98 5/32. Each contract is for \$100,000 principal. When the position is closed, the price is 95

Several important finance questions

The existence of financial intermediaries greatly increases the efficiency of financial markets because, without them, savers would have to provide funds directly to borrowers

Explain main aspects of regulatory environment

Explain main aspects of the regulatory environment which will protect the public from fraud within corporations. Pay particular attention to SOX needs.

Explain the meaning of each of the 2008 disclosures

Estimate the balance sheet carrying amount of the investments in associates disposed of during 2008. (Hint: Attempt to recreate the activity in the "investments in associate

Understanding of the risks involved

On Tuesday, the investor determines that due to a better understanding of the risks involved, he would have liked a yield 1⁄2 percent higher than what was implied by his Mon

Calculate what you consider should be the market value of sh

Today is 30th June 2015. Justin Beamer Limited has distributable earnings of \$6.00 per share. The company considers that it has a choice between: i) Distribute these earnings

What is the effective interest cost of this loan

A firm receives a \$1 million, 5-year loan at a 10 percent interest rate. The loan requires annual payments of \$125,000 per year (at the end of each year) for years 1 to 4. a.

Minimizing the costs of shipping goods

A Corporation wishes to minimize the costs of shipping goods from production plants to warehouses near metropolitan demand centers, while not exceeding the supply available fr