Question

Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years and an interest rate of 7% per year 1. What initial principal will this repay? 2. Prepare a loan payment schedule showing the payments and interest for the life of the loan. (3) (10 pts) (a) A 10-year mortgage for $95,000 is issued at a 6% annual interest rate (a) What is the monthly payment? (b) How long does it take to pay off the mortgage, if $1500 per month is paid? (c) What is the monthly payment, if the interest rate is 0.5% per month? (4) (15 pts) Calculate the Issuance Price of a 10 year bond with a face value of $250.000, stated interest rate of 4% to yield 5%. Interest payments are paid semiannually. 1 Calculate the price in excel 2 Prepare a bond amortization schedule using the straight line method 3 Prepare a bond amortization schedule using the effective interest method

should be explain it on excel

Answer 1

2)a)

annual payment	6000
Duration	4
Rate	0.09
pv	₹ 19,438.32

b)

It is the same as (a) because the monthly values have simply been converted into annual figures

c)

annual payment	6000
Duration	4
Rate	0.07
pv	₹ 20,323.27

3)

a)

pv	95000
rate	0.06
duration	10
annual payment	₹ 12,907.46
monthly payment	₹ 1,075.62

b)

pv	95000
rate	0.06
duration	-4.7212707
annual payment	₹ 18,000.00
monthly payment	₹ 1,500.00

Therefore, 57 monthly repayments reqd.