Exercise – Cash Flow Statement

This exercise asks you to build a Cash Flow Statement for Colorado Ricardo Mountain Bikes.

The Scenario: Colorado Ricardo Mountain Bikes

Colorado Ricardo Mountain Bikes was founded by Ricardo Francisco, a keen off-road cyclist who grew frustrated with bikes breaking down under the strain of the Colorado mountains. After years of trial and error, he built a bike tough enough to survive the terrain and named it the “Colorado Ricardo”. Word spread quickly among local riders, and Ricardo gave up his day job to build and sell bikes full-time from a small workshop outside Denver.

This year, Colorado Ricardo sold 4,000 bikes at $1,200 each, down from a peak of around 10,000 bikes a year. Each bike costs $700 to build, and the business carries $1,800,000 a year in fixed costs, giving an operating profit of $200,000. At the year end it held $500,000 in cash, up from $400,000 at the start of the year.

During the year, operating activities generated $350,000 in cash. Ricardo spent $150,000 on new factory equipment (investing activities), and repaid $100,000 of loan principal (financing activities).

Your task: Build a cash flow statement showing the three sections – operating, investing and financing activities – and reconcile the opening cash balance of $400,000 to the closing balance. Then explain why Colorado Ricardo’s cash increased by less than its $200,000 operating profit.

Cash flow statement: operating, investing and financing activities

Once you have drafted your own answer, compare it with Marketing Teacher’s suggested answer.