I need the formuals please

A B D E F G H H 1 J 1 2 3 Exercise 1: For each of the three students below, find their final exam score that would make the course score in column G equal to the desired course score in column I. Note that the formulas in column G are correct and do not need to be modified. (You will have to use Goal Seek three times.) 4 5 6 Course Desired 7 7 8 9 Exam 2 20% 93 Exam 3 25% Exam 1 15% 100 76 Final Exam 40% score 90 95 score 57.35 49.7 46.8 Mary Bryn Chris 10 99 74 85 80 74 80 80 Exercise 2: You are buying a foreclosed house. Your income only allows you to make a payment of $800 per month. You can negotiate the price of the house or the annual percent rate (APR). Proceed as follows. 11 12 13 14 15 16 17 18 19 20 a. Based on the information in columns B and C, use Goal Seek to find the price that drives the monthly payment to $800. b. Based on the information in columns E and F, use Goal Seek to find the APR that drives the monthly payment to $800. $130,000.00 21 22 23 24 25 26 Adjust price Price APR Months of payments Monthly Payment 7.00% 360 $0.00 Adjust APR House Cost APR Months of Payments Monthly Payment 360 $361.11 27 Target Payment $800.00 Target Payment $800.00 28 29 30 31 32 33 34 35 36 37 38 39