Reconcile a simplified income statement and balance sheet, calculate three ratios and write a cautious interpretation.
The fictional Cedar Services case has revenue 12,000, direct costs 7,000, operating expenses 3,000 and no tax or financing items. Its closing assets are cash 2,000, receivables 3,000, inventory 1,000 and equipment 4,000. Liabilities are 4,000 and equity 6,000; current liabilities are 2,500.
| Item | Amount |
|---|---|
| Revenue | 12000 |
| Direct costs | 7000 |
| Operating expenses | 3000 |
| Cash | 2000 |
| Receivables | 3000 |
| Inventory | 1000 |
| Equipment | 4000 |
| Total liabilities | 4000 |
| Equity | 6000 |
| Current liabilities | 2500 |
The income statement describes activity over a period; the balance sheet describes a position at a date. Mixing those time bases creates misleading comparisons. Use the supplied case boundary and label the reporting period. This exercise is simplified and does not contain enough information to reconstruct a complete cash-flow statement.
Place each supplied item in its statement and label period versus date.
Statement map
Record your result and evidence here or in a separate file.
Current liabilities are recognized as a subset, not added again to total liabilities.
Identify subtotals before summing rows.
Subtract direct costs to obtain gross profit, then operating expenses for the simplified operating result. Keep the subtotal visible so a reader can locate the cause of a change. The original exercise supplies these definitions; the selected provider parts offer accounting foundations, not a claim that every case calculation appears in the video.
Build the income statement and calculate gross and operating margins.
Income statement with margins
Record your result and evidence here or in a separate file.
Gross profit is 5,000; operating result is 2,000; margins are 41.67% and 16.67%.
Divide both margins by revenue and show the unrounded calculation.
Reconcile assets with funding before interpreting a ratio. Separate current assets from equipment and avoid treating receivables as immediately available cash. A current ratio summarizes a relationship but does not establish when collections occur or whether inventory can be sold. Ask timing and quality questions alongside the number.
Calculate total assets, working capital and the current ratio.
Balance sheet reconciliation
Record your result and evidence here or in a separate file.
Assets total 10,000, working capital is 3,500 and the current ratio is 2.4.
Use current assets 6,000 and current liabilities 2,500 for the ratio.
A percentage change needs a stated baseline. Consider a scenario with revenue unchanged and direct costs rising by 1,000. The operating result falls even though sales are stable. Distinguish what the figures show from possible explanations, and request evidence before blaming prices, waste or supplier performance.
Rebuild the income statement after the cost increase and list three diagnostic questions.
Scenario and question list
Record your result and evidence here or in a separate file.
Operating result falls to 1,000; no unsupported cause is asserted.
Label possible explanations as hypotheses.
A short financial brief should state the reconciled facts, the interpretation and the missing information. Do not combine several ratios into a vague healthy or unhealthy verdict. Explain what each number can and cannot answer. Use consistent rounding and preserve exact values in the supporting calculation.
Write a 250-word brief with three findings and three limitations.
Statement-reading brief
Record your result and evidence here or in a separate file.
The brief distinguishes profitability, position and cash timing.
Replace a broad verdict with a specific question supported by the figures.
Submit both statements, ratio calculations, changed-cost scenario and brief. Include a deliberate double-counting error in a separate test copy and explain how the reconciliation detects it.
Statements reconcile and cash availability is not inferred directly from revenue or the current ratio.
| Criterion | Points | Evidence |
|---|---|---|
| Evidence and correctness | 30 | Calculations, source use and results match the supplied case; limitations are honest. |
| Required artifacts | 30 | All five stage outputs and the capstone handoff are present and inspectable. |
| Reasoning and decisions | 20 | Choices, assumptions, alternatives and the case-specific critical condition are explained. |
| Reproducibility | 10 | A reviewer can follow the stated steps and distinguish expected from observed results. |
| Clear communication | 10 | Labels, units, structure and evidence references make the work easy to review. |
Score at least 80/100, supply every required artifact, and satisfy the path-specific critical condition. Rework missing evidence before marking complete.
Assets are 2,000 + 3,000 + 1,000 + 4,000 = 10,000, matching liabilities 4,000 plus equity 6,000. Current assets are 6,000, so the current ratio is 6,000 / 2,500 = 2.4. This does not establish that 6,000 cash is available today.
This is introductory financial literacy with synthetic data, not an audit, valuation or investment recommendation.