Expecting my education to continue onto graduate school, lofty goal of earning a Masters Degree to become a C.P.A., I started building a custom ‘Excel App’ Workbooks with task specific worksheets. Thinking of it as building my own personnel accounting app, “Stingray’s CPA Excel App“.
One Excel workbook with multiple sheets, all interconnected with complex accounting formulas. Comparative Income Statement, Comparative Balance Sheet, Accounting Business Ratio’s (Liquidly, Efficiency, Profitability, Solvency).
Entering numbers (#’s) in the ‘Yellow Highlighted Unlocked Cells‘.
Embedded formulas autofill in the ‘Orange Highlighted Locked Cells‘ with correct calculations.
Comparative Income Statement
The Green ‘Vertical Analysis’ compares ‘% of Business Expenses’ to the ‘Total Revenue’ generated.
The Orange ‘Horizontal Analysis’ Compares two different periods numbers for ‘$ Money and %‘ between them.
Comparative Balance Sheet
The Orange ‘Horizontal Analysis’ Compares two different period’s numbers for ‘$ Money and %‘ between them. The last 3 screenshots are all Auto-calculated complex accounting business ratios (Liquidity, Efficiency, Profitability, Solvency).
Assets -Liabilities = Equity
Accounting Business Ratio’s
Liquidly, Efficiency, Profitability, Solvency
