Library › Finance AI › FP&A and financial analysts

Cost a commission plan with an accelerator at three attainments

  • For FP&A and financial analysts
  • You practice Asking for a format you can use
  • Time about 5 minutes
  • Level Intermediate

About this exercise

You're costing the commission plan for the sales VP. Write a prompt for a markdown table with columns Attainment, Bookings, Commission per rep, Effective rate and Team of 8, with the commission math in the third column. Effective rate is commission divided by bookings, one decimal. The accelerator applies only to bookings above quota. Under 140 words.

Common mistakes when you ask AI for this

  • Accelerating everything. The AI applies 9% to all $600,000. Try: Say: "The accelerator applies only above quota."
  • Missing the team column. The AI stops at per-rep numbers. Try: Add: "Team of 8 = commission per rep x 8."
  • Wrong effective rate. The AI divides by quota. Try: Add: "Effective rate = commission / bookings."
  • Trusting the AI to count words. AI is bad at counting and runs past word limits. Try: Ask for fewer words than the real cap and keep each part short.

What a strong prompt includes

  • Names the columns
  • States the accelerator rule
  • Gives the rates
  • Asks for the math
  • Caps length

Practice this now ↑

Related exercises