The MFD Practice Projector

Methodology — The monthly engine compounds AUM forward each month: new month-end AUM = (previous AUM + monthly lumpsum + current month's SIP book) × (1 + market return / 12). The SIP book itself grows by the New SIP added amount every month. Monthly brokerage = month-end AUM × (annual brokerage rate / 12). The annual P&L sums each year's twelve monthly brokerages, divides by (1 + GST) to get post-GST income, then subtracts the seven expense buckets to arrive at PBT (Profit Before Tax). Corporate Tax is applied at the user-set rate on positive PBT to give PAT (Profit After Tax). Year 1 expense percentages are applied to Year 1 post-GST brokerage only — from Year 2 onwards, salaries and expenses grow on their own track rather than as a fixed % of brokerage. Team and promoter salaries grow at their own rates; marketing/gifting, office, other grow at a common non-salary rate; technology expenses grow separately.

Tax structure notes — The Corporate Tax field defaults to 25%, the headline rate for a domestic Pvt Ltd company with turnover ≤ ₹400 Cr (effective ~27.82% after cess and surcharge). Use ~22% (Sec 115BAA opted-in), ~30% for LLP/partnership (~33.6% effective), or up to ~35-36% for proprietorship at the top individual slab. The tool treats all seven expense lines as fully deductible against profit — appropriate for a Pvt Ltd / LLP structure where directors' remuneration and business expenses are pre-tax; less accurate for a proprietorship where "salary to self" is not deductible. Spreadsheet fixes: the formerly unused "Other Exps %" is now a real input; previously hardcoded Office Maintenance % and Technology Expense ₹ values are adjustable; GST rate is exposed; corporate tax is added as a separate line (it was missing from the original model entirely — the spreadsheet's "profit" was actually PBT).