ACC232 - DATA ANALYTICS ASSIGNMENT The purpose of this assignment is to create an automated lease classification tool. You should use Excel formulas (e.g. IF, COUNT and PV) to use the input data to calculate and classify the lease. Your calculations and classifications should change automatically as the data in the input cells are changed. This allows us to quicly classify any lease based on the inputted data. INSTRUCTIONS: Enter your name(s) in the blue highlighted cells The orange highlighted cells in Column B are the data input cells. Data for an example lease has been entered into these cells. You can change the input data of the lease. The details in Column C in parentheses are the range of expected inputs for Column B. In the green highlighted cells in Column F, you are required to enter formulas to automate the required calculations, classification criteria and classification test. These formulas you enter in Column F should be based on the input cells from column C, and automatically change as the input data is changed. For example, the lease payments could be monthly or yearly. The lease payments could be at the beginning or end of the lease period. Your formulas/calculations must take into account all of these possibilities. Submit your completed file on Reggienet on or before the due date. If you complete this assignment as a group of 2 students, then both of you must submit it on Reggienet with both of your names on each submission.