Open the file Wk $04$ Goal Seek Source file. $0$

$2$ In the range B$5$:B$7$ name the cells Rate, Period, and Loan$\_$Amount $3$

$3$

Use a function that will calculate the payment for a loan. Use range names and display the

result as a positive value $3$

$4$

Use Goal seek to determine how much you can borrow in order for your payments to be $$500$

per month $2$

$5$

Create a custom footer that will display the file name on the left of the footer. The file name

displayed should update automatically each time the file is saved with a different name, i$.$e$.$

use the Footer code built into Excel.

$2$

$6$ Save and close the Wk $04$ Goal Seek Source file $0$

$7$ Submit for grading$``$

Finding a Loan Amount

You can afford $$500$ payments

Rate $($per year$)3\%$

Period $($in years$)20$

Loan $$150,000\mathrm{.}00$

Payment