Unit 3 spreadsheet

Purpose

The goal of the Excel template assignments weeks 1-4 is to build a working Excel spreadsheet model with built-in formulas and circular references using provided Excel template for Walmart company for 2010-2017, following detailed instructions in the textbook. The chapters of the textbook present a comprehensive guide on how to build spreadsheet model.

IMPORTANT! You will be using the same file for building the financial statements model for weeks 1-4. By the end of unit 3 you will finalize a complete spreadsheet model with the circular references. During unit 4 you will be building the spreadsheet for the company’s valuation using the financial statement model created in units1-3.

Please note that the completed spreadsheet model must contain all required formulas. Typing just the numbers without building in the formulas will produce a grade of zero for the homework since the assignment will be considered as “uncompleted”.