Chapter 1 Working with Income Statements Keeping Score Choosing the Right Perspective Defining Two Purposes for Accounting Using the Income Statement Choosing a Reporting Method Cells in Excel Measuring the Operating and Nonoperating Segments Moving from the General Journal to the Income Statement Getting the General Journal into Excel Understanding Absolute, Relative, and Mixed References Getting the Journal Data to the Ledger Getting the Ledger Data to the Income Statement Managing the Financial Analyses with Accrual Accounting Using Straight-Line Depreciation Preparing the Trial Balance Moving Information into an Income Statement Organizing with Traditional Versus Contribution Approaches About Power BI Power BI Desktop Power BI Service and Mobile Apps Summary Chapter 2 Balance Sheet: Current Assets Designing the Balance Sheet Understanding Balance Sheet Accounts Understanding Debit and Credit Entries Getting a Current Asset Cash Balance Using Sheet-Level Names Getting a Cash Balance for Multiple Cash Accounts Handling Restricted Cash Accounts Getting a Current Asset Accounts Receivable Balance Allowing for Doubtful Accounts Using the Aging Approach to Estimating Uncollectibles Using the Percentage of Sales Approach to Estimating Uncollectibles Displaying Doubtful Account Balances with Power BI Managing the Sort Order Via the Axis Values Managing the Sort Order with Another Field Getting a Prepaid Expenses Balance Dealing with Insurance as a Prepaid Expense Getting a Current Asset Balance Understanding the Inventory Flow Closing the Inventory Account Closing the Revenue and Expense Accounts Summary Chapter 3 Valuing Inventories for the Balance Sheet Understanding Perpetual and Periodic Inventory Systems Perpetual Inventory Systems Periodic Inventory Systems Valuing Inventories Valuation Methods Summarized Using Specific Identification Using Average Cost Using the Moving Average Method Using FIFO Using LIFO Comparing the Four Valuation Methods Specification Identification Average Cost FIFO LIFO Handling Purchase Discounts Calculating Turns Ratios Summary Chapter 4 Summarizing Transactions: From the Journals to the Balance Sheet Understanding Journals Understanding Special Journals Structuring the Special Sales Journal Structuring the Special Purchases Journal Structuring the Cash Receipts Journal Structuring the Cash Payments Journal Excel Tables and Dynamic Range Names Building Dynamic Range Names Using Dynamic Range Names in the Journals Choosing Between Tables and Dynamic Range Names Understanding Ledgers Creating the General Ledger Using Subsidiary Ledgers Automating the Posting Process Getting a Current Liabilities Balance Summary Chapter 5 Working Capital and Cash Flow Analysis Matching Costs and Revenues Broadening the Definition: Cash Versus Working Capital Determining the Amount of Working Capital Determining Changes in Working Capital Analyzing Cash Flow Developing the Basic Information Summarizing the Sources and Uses of Working Capital Identifying Cash Flows Due to Operating Activities Combining Cash from Operations with Cash from Nonoperating Transactions Summary Chapter 6 Statement Analysis Understanding a Report by Means of Common-Sizing Using Common-Sized Income Statements Using Common-Sized Balance Sheets Using Comparative Financial Statements Using Dollar and Percent Changes in Statement Analysis Assessing the Financial Statements Handling Error Values Evaluating Percentage Changes Common-Sizing for Variance Analysis Common-Sizing by Headcount Showing Common-Sized Statements with Power BI Summary Chapter 7 Ratio Analysis Interpreting Industry Averages and Trends Comparing Ratios Within Industries Analyzing Ratios Vertically and Horizontally Getting a Basis for Ratios Analyzing Profitability Ratios Finding and Evaluating Earnings Per Share Determining Gross Profit Margin Determining Net Profit Margin Determining the Return on Assets Determining the Return on Equity Analyzing Leverage Ratios Determining the Debt Ratio Determining the Equity Ratio Determining the Times Interest Earned Ratio Analyzing Liquidity Ratios Determining the Current Ratio Determining the Quick Ratio Analyzing Activity Ratios Determining the Average Collection Period Determining Inventory Turnover Displaying Financial Ratios in Power BI Reports Summary Chapter 8 Budgeting and Planning Cycle Creating Pro Forma Financial Statements Forecasting by Percentage of Sales Using Excel to Manage the Analysis Performing Sensitivity Analysis Moving from the Pro Forma to the Budget Projecting Quarterly Sales Estimating Inventory Levels Fitting the Budget to the Business Plan Summary