This problem asks you to prepare one- and five-year financial fore-casts and conduct some sensitivity analysis and scenario analysis for Aquatic Supplies Company. A spreadsheet containing the company’s 2014 financial statements and management’s projections is available for download from McGraw-Hill’s Connect or your course instructor (see the Preface for more information). Use this information to answer the questions posed in the spreadsheet.