D G 1 Title here 2 12/14/2021 3 Principal 5 Interest rate tyearlyl 6 Term in years 7 s 5,000.00 Use #PMT to calculate the monthly payment in B 9 Monthly payment 10 Goal seek: If we can only afford a $150 per month payment, what is the maximum amout that can be borrowed under existing terms? Answer: 12 13 14 15 16 D G 1 Title here 2 12/14/2021 3 Principal 5 Interest rate tyearlyl 6 Term in years 7 s 5,000.00 Use #PMT to calculate the monthly payment in B 9 Monthly payment 10 Goal seek: If we can only afford a $150 per month payment, what is the maximum amout that can be borrowed under existing terms? Answer: 12 13 14 15 16