Projects/Northstar Furnishings
Profit on paper, cash under pressure
Reconcile a month of sales, costs and payments. Explain the margin gap and turn it into a finance report.
The brief
Northstar's finance manager has monthly sales, product costs, operating expenses, inventory, receivables and payables. Revenue has grown while cash stays tight. Reconcile the figures, explain the drivers, and recommend what management should watch next month.
- Data: one quarter of monthly schedules.
- You deliver a checked model, a finance report and a readout.
- Stages open as the content lands.
The project path
Open any available stage- 1Excel40 min
Reconcile the schedules
Calculate gross margin and working-capital movements, and keep a reported result apart from an assumption.
- Reads
- sales · costs · balances
- Produces
- monthly_model · reconciliation_log
Power BI reads the checked model.
Coming soonContent in progress - 2Power BI40 min
Build the finance report
Show margin drivers and the cash tied up in inventory and receivables.
- Reads
- monthly_model
- Produces
- finance_report
Your readout cites the report.
Coming soonContent in progress - 3Readout20 min
Explain profit and cash
Explain the main drivers, keep profit apart from cash, and recommend next month’s checks.
- Reads
- finance_report
- Produces
Optional: present it in Interview Hub.
Coming soonContent in progress
Each stage includes reference inputs. Starting in the middle or using them doesn't complete the earlier stages.