Mapping Income Statement Accounts

Income Statement Structure

Income Statement Design

Inserting Values to the Income Statement

Identify differences between years

Use Conditional Formatting in the Income Statement

Determine average growth through the income statement

Predicting Future Growth Rates

Relate the expectation criterion using the Choose equation

Relate the expectation criterion using Offset's equation

Migrate data based on expectation ratios

Build a budget list

Posting values to the budget

Explaining the company's cash cycle measurement ratio

Calculating ratios for cash cycle measurement rates

Calculate the company's net cash cycle

Calculate forecast rates for the budget

Calculate inventory, customers and suppliers for forecast years

Forecasting other assets and liabilities

Set up Fixed Asset Forward

Forecast fixed assets and depreciation

Forecasting long-term financial liabilities and interest rates

Construct a schedule of long-term financial obligations

Equity

Preparing the Cash Flow

Tips