Please see the screen shot below for the checking the output 1. Items: use list from data Validation, and choose from the Items (Item1, Item2, Item3, Item4) in shaded area (2 points) 2. Loan Amount: use lookup function to find the price based on the Items chosen, for example, if Item2 is chosen, price should be 50,000 (2 points) 3. Interest Rate, Number of Payments are given. (1 point) 4. Amount Per Payment: use PMT function: =PMT(Rate per payment, Number of payments, -Loan amount) (2 points) 5. Remaining Principal= Loan Amount for Period Number 1, for Period Number 2 to 12: Remaining Principal = Remaining Principal of Previous Period Principal Payment of Previous Period (3 points) 6. Interest Payment use IPMT function: =IPMT(Interest Rate per Payment, Period Number, Number of Payments, - Loan Amount) (4 points) Further Explanation: Interest Rate Per Payment = Interest Rate/ Number of Payments; as in the example = 5.00% / 12 7. Principal Payment use PPMT function = PPMT(Interest Rate per Payment, Period Number, Number of Payments, - Loan Amount) (4 point) 8. Add a scrollbar to enter Interest Rate, small change is 0.25%, Large Change is 1%, Min is 0, Max is 15% Code: Range("Address").Value = Scrollbar1.Value / xxx (5 points) Further Explanation: suppose my Interest Rate address is C5, scrollbar name is Scrollbar1; You need to set the scrollbar properties, then you can determine what number to be used to divide the scrollbar value. 11. Finish the spreadsheet and format as shown above, Save it as your student number in macro-enabled workbook forma