24. 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.
Solved by A. J. in 23 mins