Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Projects/Marlow & Pike

        Close October and explain the cash

        October looks profitable, yet cash ended well below forecast. Post the adjusting entries, put each cash line next to its forecast in Excel, build the CFO's view in Power BI and write the month-end note.

        ProjectMarlow & Pike · fictional company1 h 40 min4 stagesFinance and accounting

        One brief, 3 toolsThe accounts keep their numbers from the journal to the adjusted income statement in Power BI, and the cash lines keep theirs from the forecast to your variance sheet and the report.

        Marlow & Pike

        Wholesale distribution

        About the company

        A wholesale distributor of commercial kitchen equipment for restaurants and hotels in Ohio and Michigan.

        Marlow & Pike buys ovens, refrigeration, dishwashers and smallwares from manufacturers, keeps them in a warehouse in Toledo and delivers them with its own vans. It also installs larger equipment such as walk-in coolers. Customers range from single restaurants to hotel groups, and most pay on 30-day terms. Finance closes the books in the first week of each month, and the CFO compares cash with a monthly forecast. You work in the finance team as the analyst who prepares the month-end pack.

        Founded
        1998
        Head office
        Toledo, Ohio
        Customer terms
        30 days
        Employees
        About 40

        Who writes the briefs

        • Renata SilvaChief Financial Officer

        A fictional company, invented for practice. Meet the other companies

        The brief

        From
        Renata SilvaChief Financial Officer
        To
        Finance team
        Subject
        October pack, and where did the cash go?

        The October numbers show a healthy profit, but we closed the month with about $130,000 less cash than the forecast, and the bank wants an update next week.

        Before anything goes out, the books need October's adjustments: the Great Lakes Freight bill that has not arrived, the Lakeshore Hospitality Group deposit that was booked as a sale, and the month's depreciation. Then show me each cash line against the forecast, a simple view I can take to the bank, and a short note on what happened and what we do about it.

        You have October's income statement before adjustments and the cash flow forecast with the actual figures.

        Done looks like: three adjusting entries, a variance for every cash line, a Power BI view of the variance by category and a month-end note.

        • Data: October 2026, the income statement before adjustments and six cash flow lines.
        • You deliver adjusting entries, a cash variance sheet, a Power BI report and a month-end note.
        • Checks cover accruals against payables, deposits as a liability, and the sign of every variance.

        The project path

        1. 1
          Accounting25 min

          Post the October adjusting entries

          Accrue the freight, move the deposit out of revenue and book the month's depreciation.

          Reads
          pl_unadjusted
          Produces
          pl_october

          Power BI shows the adjusted income statement beside the cash.

          Open stageOne Course in Accounting or All Access
        2. 2
          Excel20 min

          Put October's cash next to the forecast

          A variance in dollars for every cash line, with the same sign for every shortfall.

          Reads
          cash_forecast
          Produces
          cash_variance

          Power BI totals your variances by category.

          Open stageOne Course in Excel or All Access
        3. 3
          Power BI30 min

          Show the CFO where the cash went

          A Cash Variance measure by category, next to the adjusted income statement.

          Reads
          cash_variance · pl_october
          Produces

          Your note quotes the report.

          Open stageOne Course in Power BI or All Access
        4. 4
          Readout20 min

          Write the month-end note

          Tell the CFO the adjusted profit, where the cash went and what to do about it.

          Reads
          pl_october · cash_variance
          Produces
          october_month_end_note.md

          Optional: present it in Interview Hub.

          Open stageAll Access

        Each stage includes reference inputs. Starting in the middle or using them doesn't complete the earlier stages.

        Project access

        Free

        $0

        Read all briefs and paths. Tool stages and written work are locked.

        Keep browsing

        One Course

        $17.99/month

        Practice the stages in your chosen tool. Reference tables let you start at that stage.

        All Access

        $29.99/month

        Every stage in every format, plus optional spoken readouts using dumbbells.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.