Project Description:

Use Goal Seek to determine a loan amount

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,$\backslash$table$[[$Points$],[$Possible$]]],[1,$Open the file Wk $04$ Goal Seek Source file.,$],[2,$In the range B$5$:B$7$ name the cells Rate, Period, and Loan$\_$Amount,$3],[3,\backslash$table$[[$Use a function that will calculate the payment for a loan. Use range names and display the$],[$result as a positive value$]],3],[4,\backslash$table$[[$Use Goal seek to determine how much you can borrow in order for your payments to be $$500$

$2$ Finding a Loan Amount

$3$ You can afford $$500$ payments

$9$ Payment

$10$

$11$

$12$

$13$

$14$

$15$

$15$

$17$

$18$

$19$

$20$

$24$