world133_ln_03
Management Consulting Document CreationDetermine CAGR for total points sold over the entire covered time period from the Profit and Loss Master Profitability Workbook.
Apply that growth rate to average points per member from the Member Points Summary (Balance & Expiry) Sheet to project points per member (PPM) per year, 2 years out. Assume the average in this data set is the year end 2025 average.
Return the state Average PPM and CAGR of points sold for the base year and each of the two years out in a New spreadsheet. Round to two decimals.
Input Files
1 fileYour Answer
Expected: make_new_sheet
0 / 12,000
chars
Cmd/Ctrl+Enter to submit & evaluate
Evaluation
Submit your answer to see evaluation results.