NO DATA IS NEEDED, THIS IS PROCEDURAL.

The course project involves the completion of a comprehensive consolidation of financial statements in EXCEL. Please note that most of the points are associated with the sophistication of the EXCEL program. The goal here is to design an EXCEL application that will complete the consolidation in future years and will minimize the chances that a future user of the EXCEL application will make an error or will struggle with the application. The fewer required inputs ongoing, the better. The fewer required decisions by future users the better. Essentially, attempt to design an EXCEL spreadsheet that automatically completes the consolidation process once the current year financial statement information is input. As a hint, cases earning all the points usually involve the use of HLOOKUPS, VLOOKUPS, or series of embedded IF statements.