Convert monthly recurring revenue to ARR and leave out one-time fees

About this exercise

Make a markdown table with columns Customer | MRR | ARR for the three customers in the order given, then a Total row. ARR = MRR x 12. Write amounts like $14,400. One-time fees and usage overages are excluded from MRR and ARR. After the table add one line starting "Excluded:" naming the excluded amounts and their total. No bold, under 80 words.

Common mistakes when you ask AI for this

• Including one-time fees. The AI adds the $500 and $120. Try: Add: "Exclude one-time fees and overages."
• Missing the Excluded line. The AI doesn't name what was left out. Try: Add: "Add an Excluded: line with the amounts and total."
• Wrong ARR formula. The AI multiplies by 52. Try: Add: "ARR = MRR x 12."
• Bold and extras. The AI bolds Total and adds notes. Try: Add: "No bold, under 80 words."

What a strong prompt includes

• Names the columns
• Gives the formula
• Excludes one-time items
• Adds the Excluded line
• No bold

Practice this now ↑

Related exercises

• Accept the buyer's counteroffer on three stated conditions (Sales AI · Sales and customer success)
• Accrue goods received but not invoiced at PO price (Finance AI · Accountants)
• Add dark mode by overriding your existing CSS variables (Coding AI · Software developers)
• Add input checks to your number guessing game (Coding AI · High school students)
• Add labels to a signup form without rewriting the page (Coding AI · High school students)