Skip to content

Instructor key — Module 2: Revenue, Margins, and Driver-Based Forecasting

Instructor/solutions version. Keep separate from the student assignment during assessment.

Calculation solution

A business retains 80 of 100 contracts, adds 20 evenly during the year and charges 36 per full year. Calculate recurring revenue.

Calculated result: 3,240.00000000 ($000, except where the question requests a ratio or return). Retained cohort earns 2,880; new cohort earns 360, not 720. Use appropriate display rounding while retaining formula precision. This result is generated from the independent assignment inputs, not copied from the chapter answer.

Conceptual and judgment marking

A complete conceptual response identifies the measure's economic purpose, the defined perimeter and the risk of confusing it with another metric. Award up to 20 points for explanation, not terminology alone. For the applied question, award up to 15 for linking evidence to a concrete acquisition consequence; do not require an optimistic recommendation.

Spreadsheet marking

Award 15 of the 30 spreadsheet points for live links from assumptions, 10 for a coherent 10% mutation and predicted direction, and 5 for units, readable formatting and checks. Inspect formulas directly rather than accepting cached numbers. Use the instructor workbook for the controlling capstone model; this independent lab uses different inputs.

Calculation marking: 10 points for the correct equation/perimeter, 15 for intermediate arithmetic, and 10 for result, units and rounding. Overall pass requires 80 and all critical checks in the student version.

Original chapter practice solutions

The following solutions were moved out of the chapter so full answers no longer sit immediately below student questions. Match them in order to the chapter's practice problems.

Answer: Contracts equal 97; maintenance revenue is 3,104; total revenue is 4,904; EBITDA is 4,904 × 40% - 1,100 = 861.6. This assumes full-year new wins and no incremental hiring expense. State those assumptions before using the result.

Student assignment