Personal Finance #2–Financial Statements & Budgeting

Construct a personal balance sheet using the accounting equation (assets equals liabilities plus net worth) with a cash-basis focus, categorizing liquid assets, liabilities, and long-term items.

Learn to classify balance sheet accounts using the accounting equation and build personal financial statements from transactions or ending balances, including assets, liabilities, and net worth.

Build a personal balance sheet and income statement, and explore cash-basis vs accrual accounting, including double-entry methods and data sources using QuickBooks, Wave, or OneNote.

Learn to build and interpret personal financial statements—balance sheets and income statements—on a cash or accrual basis, tracking inflows and outflows and net worth changes.

Practice solving the accounting equation by analyzing assets, liabilities, and net worth in two formats: assets = liabilities + net worth, and assets minus liabilities.

Construct basic financial statements from the data and calculate debt ratio and current ratio to assess liquidity, then interpret ratios for loan decisions and performance comparisons.

Apply a flexible personal budget by separating fixed and variable costs, linking income to savings, and focusing on controllable expenses to adapt with behavior.

Learn how to plan a budget, compare actual spending to budgeted amounts, and analyze variances across categories like food, auto, rent, clothing, and personal to improve future budgeting.

Compile a balance sheet from assets and liabilities to reveal net worth at a point in time, including current and long-term liabilities, linking to the income statement and using QuickBooks.

Build an income statement from personal data, compare cash basis with accrual accounting, and analyze fixed and variable outflows for budgeting against the balance sheet.

Explore budget vs actual analysis using balance sheet and income statement data, calculate net worth, cash flow, and variances in fixed and variable costs to guide future budgeting.

Create and analyze a 12-month personal budget from the prior period income statement, differentiating fixed and variable expenses, applying seasonal adjustments, and tracking cash flow and balance sheet impacts.

Practice building a balance sheet in Excel by classifying assets and liabilities, applying the accounting equation to determine net worth, and detailing current versus non-liquid assets.

Learn to construct personal financial statements in Excel, creating a cash-basis balance sheet and income statement, classifying assets, liabilities, and equity to compute net worth.

Practice building a cash-basis income statement in Excel from wage income to expenses, linking to net worth and the balance sheet, with cash vs accrual insights.

Explore the accounting equation by analyzing assets, liabilities, and net worth to understand balance sheets, equity, and how to back into unknowns.

Learn how to compute debt ratio, current ratio, and other common ratios from cash-basis balance sheets and income statements, and perform ratio analysis to assess liquidity, leverage, and net worth.

Build a flexible budget in Excel that separates fixed and variable costs, models cash flows, saves 25% of income, and uses break-even analyses to focus controllable expenses.

Explore how to perform budget vs actual analysis in Excel, using the income statement as a planning baseline, compare variances, and adjust spending categories and behavior.

Practice an Excel-based balance sheet and cash-basis income statement, then compare budget vs actual; categorize assets, liabilities, and equity to compute net worth and explore cash vs accrual.

Explore how to build a cash-basis income statement, classify fixed and variable expenses, and connect these insights to budgeting and the budget vs. actual report.

Explore a budget vs actual analysis in excel, comparing actual income and expenses to budgeted figures on an income statement, highlighting variances, savings, and fixed versus variable costs.

Develop a 12-month personal budget in Excel, starting from the income statement and projecting cash flow with fixed and variable expenses, using cash and accrual concepts.

Explore how to use Excel budget templates to build or customize a personal budget, compare from-scratch budgeting with templates, and connect data to balance sheets and income statements.