Monitor risk trends for management and sales

Prepare the weekly risk trends packet for management and the regional sales leads: combine last two quarters of loss rate, top five customer credit exposures, and the live watchlist into one sheet, sort by materiality, add a one-paragraph executive summary that explains the driver for any movement over 5% and attach the supporting data tab for audit. Deadline Friday 3pm; check formulas and source links first.

Before I send this to the sales directors, make the risk trends easy to act on: surface the three biggest movers at the top, show the rolling 90-day change percent next to each customer, highlight any exposure above our $5 million internal threshold, and call out where model inputs changed so a reviewer won't chase the wrong lead.

I exported collections and charge-off figures and the consolidated loss rate shows a 6% rise month-on-month. Senior Management and two regional sales VPs will read this Friday; I don't know if the jump is from a data feed change, a large one-off write-off, or a genuine portfolio deterioration. What's the most defensible next step to investigate and what should I tell the VPs now to keep credibility?

Every month we lose credibility because the same metric changes and we scramble to explain it. The recurring costs are rework, late decisions by sales, and more audit queries. Which habit should I change first — standardize a master source for key exposures, lock the calculation logic with version control, or create a change-log sheet that requires a short justification for any number over our 2% variance rule? Recommend the one change that will most quickly reduce noise.