Select cell F9 and use Goal Seek Analysis to determine the loan amount in the Aggressive Expansion scenario based on a monthly payment of $12,000. In the Goal Seek calculations, set the value of cell F9 to -12,000 and select cell F4 (Total Loan Amount) as the changing cell. Keep the outcome of the Goal Seek Analysis as the value of cell F4. NP EX16, CS1-4a_FeyisayoAkinyemi-Porter File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want C9 4 A SpringLeaf Designs -Loan and Revenue Scenarios 3 Loan Term (Yrs) 4 Total Loan Amount 5 Annual Interest Rate 6 Monthly Interest Rate 7 Loan Term (Yrs) 8 Total Number of Payments Status Quo Growth Moderate Growth Aggressive So 790 0.40% $150,000 7% 0.40% 3 36 350,000 S 450,000 790 0.40% 7% 0.40% 36 48 60 Monthly Payment Amount Conservative Moderate Groh Expansion 11 Revenues 12 Head Accessories 13 Arm Accessories 14 Body Accessories 15 16 17 Current Year Growth S 3,047,520 S 3,352,272 S 4,266,528 S 5,333,160 3,591,816 S 3,950,998 S 5,028,542 6,285,678 s 5,289720 S 5,818,692 S 7405608 S 9.257010 Total 20