Develop a "What If" amortization table that allows the table to automatically adjust to whatever interest rate and original balance are entered. The number of years is fixed at ten. Payments are monthly and are made at the end of the month. The table will be graded assumming that the Loan Amount is $50,000 and the Yearly Interest Rate is 7.2%. Yearly Interest Rate: 7.20% Loan Amount: $50,000.00 Paid on Loan Ending Balance Payment: All Payments: All Interest: Monthly Pmt Interest Beginning Payment Paid on Num Month Rate Balance Amount Interest 1 1-Jan-10 2 1-Feb-10 3 3 1-Mar-10 4 4 1-Apr-10 5 1-May-10 6. 1-Jun-10 7 1-Jul-10 8 1-Aug-10 91-Sep-10 101 1-Oct-10 11 1-Nov-10 12 1-Dec-10 13 1-Jan-11 14 1-Feb-11 15 1-Mar-11 16 1-Apr-11 17 1-May-11 18 1-Jun-11 19 1-Jul-11 201-Aug-11 21 1-Sep-11 22 1-Oct-11 23 1-Nov-11 24 1-Dec-11 25 1-Jan-12 26 1-Feb-12 27 1-Mar-12 281 1-Apr-12 GoalSeek3 Solver Problem 1 SolverProblem2 SolverProblems : GoalSeek1 GoalSeek2 Data Questions Rules Amortization Vlookup +