170 likes | 402 Views
Set up chart of accounts. Set up 12-month timeline. Input beginning balances. Input change for the month. Input changes for all 12 months. Total the change for the year. Set up the ending balance. Build the Income Statement. Balance Sheet. Income Statement. Integrate the statements.
E N D
Build the Income Statement Balance Sheet Income Statement
Integrate the statements Depreciation/amortization • Others Linkages: • Interest income • Interest expense • Deferred tax • Bonus • Work-in-progress Stockholders’ Equity Net Earnings (Loss)
Integrate cash flow “plug” Balance Sheet Cash Total Assets Total Liabilities Equity Income Statement Profit (Loss) Cash Flow Circular Reference
Cash Flow Equation + Net Earnings (Loss) - Change in Total Assets + Change in Cash + Change in Total Liabilities + Change in Equity: stock & retained earnings
Extend timeline back & forward Last Year Current Year Next Year Balance Sheet Balance Sheet Balance Sheet Income Statement Income Statement Income Statement Cash Flow Cash Flow Cash Flow
Input actuals up to current month Last Year Current Year Next Year Input actuals Input actuals
Input actuals for month closed Last Year Current Year Next Year Input actuals Input actuals
Project ahead Last Year Current Year Next Year Project ahead
Set up charts Last Year Current Year Next Year