(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. 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 bond amortization schedule using the straight line method

3 bond amortization schedule using the effective interest method

Please note: For all of the above please label your work. Work will be graded on accuracy and the

utilization of excel throughout your work.

Final Project Problems 2, 3 4 Solve all oi the iollowing problems with Excel. Please use iorrnulas in excel to solve. (2} (10 PB) (a) Assume monthly car payments oi $500 per month ior 4 years and an interest rate oi 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments oi $6000 for 4 years and an interest rate oi 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments oi $500 per month ior 4 years and an interest rate cl 7% per year. 1. What initial principal will this repay? 2. Prepare a loan payment schedule showing the payments and interest tor the lite oi the loan. (3) (10 Dis} (a) A 10-year mortgage ior $95,000 is issued at a 6% annual interest rate. {a} What is the monthly payment? (b) How long does it take to pay oil the mortgage, ii $1500 per month is paid? (c) What is the monthly payment, it the interest rate is 0.5% per month? (4) {15 P18) Calculate the Issuance Price oi a 10 year bond with a face value oi $250,000, stated interest rate oi 4% to yield 5%. Interest payments are paid serniannually. 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 eectiye interest method Please note: For all oi the above please label your work. Work will be graded on accuracy and the utilization oi excel throughout your work