HOw do i prepare an Excel Worksheet and name the file Trailing 12 Financial Analytics - Party City - Your name The following Tabs should be included: Trailing 12 Financials: First Tab - Label as Trailing 12 Financials -

a TRAILING 12 month Side-by-Side Income statement for two consecutive 12 -month periods using the most recent NON-YEAR END QUARTER as the end date. For example, if you are using June 2019 Quarter end, the Trailing 12 Income statements will cover July 1, 2018 Thru June 30, 2019 and July 1, 2017 Thru June 30, 2018. o Common Size the Statement o Variance Income Statement and compute change a Common Size the Incremental Statement Second Tab - Balance Sheets - Create side by side Balance Sheets for the Trailing Year End you have created o Include a Variance Column Third Tab - Ratio Analysis o For EACH Trailing 12 months calculate pertinent ratios, which include the "Required" calculations below and any others you believe important to your discussion of the company's financial condition. Fourth Tab - Cash flow observations o Calculate

Sources and Uses of Cash from the Balance Sheet