Dynamic Compounding Excel Model

I need a smart Excel workbook that lets me map the journey from an initial trading capital of $10,000 to my target of $100,000. The sheet has to auto-populate four key columns—Date, Starting Capital, Lot Size, and New Balance—while compounding the balance and scaling the lot size upward each time the capital grows.

Core requirements
• A clean control panel where I can set or change the annual return rate and choose the compounding frequency (annual, quarterly, or monthly) without breaking the formulas.
• No periodic top-ups: the model must assume “No additional investments” and rely solely on compounded growth.
• Lot-size logic that recalculates itself dynamically each period so I can see at a glance what size I should trade as the account expands.
• Clear, error-free formulas (or lightweight VBA if needed) with all calculations fully transparent, so I can audit or tweak them later.

I’d like the file delivered unlocked and neatly formatted, with a brief note explaining any macros or named ranges you use. Once I see a solid draft, I’ll walk you through the exact lot-sizing rules to be sure we hit my strategy perfectly.