Problem 5 (for an A grade) on this assignment: Create an Excel model to solve loan Payment using (1) Excel PMT function; (2) Spin Buttons to change Loan Amount, Payment Periods and Interest rate; (3) A check Box to change payment at beginning (or end) of period. The loan amount changes from $350k to $500k by $25k increment, Payment (monthly periods) changes 120 months to 360 months by 60 months increment (5-year), and interest changes from 3.0% to 7.0% by 0.25% increment. What you need to do is to following the link below and to create an exact work sheet, which will look like the print out below. To insert Spin button and check box, make sure that you add Developer in your tool bar. http://www.youtube.com/watch?v=vvkiqJjps-k&feature=youtube_gdata_player