Calibri (Body) A A Paste BIU Wrap Text Merge & Center General $%9 Conditional Format Formatting as Table Styles Cell G22 1 Module 8-2 Goal Seek-Chemistry Analyzer 21. Use Goal Seek (Data/What-if Analysis) (training video is in Canvas Assignment) to see what price you need to get from the manufacturer. 3 2. Your budget only allows for a maximum of $4,000 per month payment. The best interest rate you can get is 3.5%. The term must be 60 months 4 3. The manufacturer has submitted a quote for $240,000. The monthly payment for that amount is $4,366. 54. Use the Goal Seek tool to develop a counter offer to give to the manufacturer. 65. Copy/Paste your counter offer from using Goal Seek into cell 816. 7 6. Save the file. Submit through Canvas. 8 9 10 Loan for a new Chemistry Analyzer 11 Rate 12 Term in Months 13 Principal 14 Payment 15 16 Counter Offer 17 18 19 3.5% 60 $ 219,880 $4,000