Create the spreadsheet models shown in Figures $8\mathrm{.}3$ and $8\mathrm{.}4.$ from Chapter $8$ of your Textbook.

What is the effect of a change in the interest rate from $8\%$ to $10\%$ in the spreadsheet model shown in Figure $8\mathrm{.}3?$

For the original model in Figure $8\mathrm{.}3,$ what interest rate is required to decrease the monthly payments by $20\%?$

What change in the loan amount would have the same effect?

In the spreadsheet shown in Figure $8\mathrm{.}4,$ what is the effect of a prepayment of $$200$ per month?

What prepayment would be necessary to pay off the loan in $25$ years instead of $30$ years?

Solve the MBI product$-$mix problem described in chapter $8$ p$479,$ using Excel$$s Solver. Examine the solution $($output$)$ reports for the answers and sensitivity report. Did you get the same results as described in the chapter and shown in Figure $8\mathrm{.}6$ p$481?$