excel

Excel 10 - Payment

Loan:	$200,000
Years	Monthly Payments
	5%	6%	7%	8%
10
15
20
25
30
Years	Interest Charged
	5%	6%	7%	8%
10
15
20
25
30

This problem will compute the monthly payments associated to a $200,000 loan for various rates and terms.

a.) Complete the first table which computes these monthly payments, and make them positive by multiplying each one by -1. Use an Excel function.

b.) Create a well labeled line chart displaying the information from this table.

c.) Complete the second table which computes the total interest paid over the life of each loan using the monthly payments times the total number of payments minus what you borrowed.

d.) Create a well labeled column chart displaying the information from this second table.