File Edit View Insert Format Tools Data Window AutoSave OF A 6. 6 0 = Ch 12 Home Auto Save OFF Final Exam ome Insert Draw Page Layout Formulas Data Review View Developer Arial 10 v A ab General Paste BI U V V Q VAv $ ~ % 9 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? X V fx A B C D E F G Q7: Our Company presented the following financial data for 2 years. Calculate the dollar amount of change and percent of change for each account Our Company Balance Sheet (partial) As for December 31 Current Year Last Year Dollar Change Percent Change Cash $186,330 $201,210 Accounts Receivable, Net $10,100 $10,520 0 Merchandise Inventory $12,300 $10, 100 1 Long Term Investments $83,000 $76,200 2 Plant Assets, Net $150,290 $174,300 TOTAL ASSETS $442,020 $472,330 Q8: BDC Inc. reported for the following Income Statement for the year ended December 31. Calculate the common-size percents and analyze this financial statement. 28 BDC Inc. 29 Income Statement For Year Ending December 31 31 Sales Revenue $291,000 32 Cost of Goods Sold 141,281 33 Gross Profit 149,719 34 Selling expenses 60,170 35 Admin expenses 71,580 36 Total Operating Expenses 131,750 37 Net Income $17,969 38 139 40 b. Explain what you learn specifically about this company using your analysis. 141 142 143 144 Q9: Exam Company reported the following financial statement data: Exam Settings 9,743 DEC 32 16