Question

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.

a) Adjust the loan amount to $12,000.
b) Determine the monthly payment for $12,000 loan.
c) Find the interest rate for a $12,000 loan.
d) Determine the total loan amount for a $12,000 monthly payment.

Answer 1

To determine the loan amount in the Aggressive Expansion scenario based on a monthly payment of $12,000 using Goal Seek Analysis in Excel, select cell F9 and set its value to -12,000. Then select cell F4 as the changing cell and run the analysis to find the loan amount.

Step-by-step explanation:

To use Goal Seek Analysis in Excel to determine the loan amount in the Aggressive Expansion scenario based on a monthly payment of $12,000, follow these steps:

1. Select cell F9.
2. Go to the Data tab, click on the What-If Analysis dropdown, and select Goal Seek.
3. In the Goal Seek dialog box, set the value of cell F9 to -12,000.
4. Select cell F4 as the changing cell.
5. Click OK.
6. The outcome of the Goal Seek Analysis will be the value of cell F4, which represents the total loan amount.