{"product_id":"saas-mrr-bridge-excel-dashboard","title":"SaaS MRR Bridge Excel Dashboard","description":"\u003csection aria-label=\"SaaS MRR Bridge Excel Dashboard\" style=\"box-sizing:border-box;width:100%;max-width:1200px;margin:0 auto;padding:24px;border:1px solid #d9e5f2;border-top:4px solid #ffd02b;border-radius:12px;background:#eff5fc;color:#102a4c;font-family:Arial,sans-serif;font-size:16px;line-height:1.65;overflow-wrap:break-word;\"\u003e\n\u003cp style=\"margin:0 0 10px;color:#2563eb;font-size:12px;font-weight:700;line-height:1.4;letter-spacing:.08em;\"\u003eFINANCIAL MODELS LAB\u003c\/p\u003e\n\n\u003cp style=\"margin:0 0 14px;font-size:16px;line-height:1.65;color:#102a4c;font-weight:700;\"\u003eHow much of the change came from existing subscriptions?\u003c\/p\u003e\n\u003cp style=\"margin:0 0 14px;font-size:16px;line-height:1.65;color:#102a4c;\"\u003eUse the populated dashboard to read the result, investigate its components and explore the stated decision assumptions. The workbook keeps the source figures and calculation steps available so another reviewer can trace the same selection.\u003c\/p\u003e\n\u003cdiv style=\"margin:2px 0 20px;\"\u003e\n\u003cspan style=\"display:inline-block;margin:0 6px 8px 0;padding:5px 10px;border:1px solid #c7d9f2;border-radius:6px;background:#fff;color:#2563eb;font-size:12px;font-weight:700;line-height:1.5;\"\u003eEditable Excel dashboard\u003c\/span\u003e\n\u003cspan style=\"display:inline-block;margin:0 6px 8px 0;padding:5px 10px;border:1px solid #c7d9f2;border-radius:6px;background:#fff;color:#2563eb;font-size:12px;font-weight:700;line-height:1.5;\"\u003eWorking sample data\u003c\/span\u003e\n\u003cspan style=\"display:inline-block;margin:0 6px 8px 0;padding:5px 10px;border:1px solid #c7d9f2;border-radius:6px;background:#fff;color:#2563eb;font-size:12px;font-weight:700;line-height:1.5;\"\u003eInteractive financial views\u003c\/span\u003e\n\u003c\/div\u003e\n\u003ch3 style=\"margin:26px 0 12px;font-size:20px;font-weight:700;line-height:1.3;color:#102a4c;\"\u003eSee the illustrative example\u003c\/h3\u003e\n\u003cp style=\"margin:0 0 14px;font-size:16px;line-height:1.65;color:#102a4c;\"\u003eMonth: Oct 2026, Unit: Self-serve. The workbook opens with calculated sample figures and working financial charts. Each displayed amount belongs to its labelled selection and unit of measure.\u003c\/p\u003e\n\u003cdiv style=\"display:flex;flex-wrap:wrap;gap:12px;margin:16px 0 6px;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 150px;min-width:0;border:1px solid #bfd2ed;border-radius:10px;overflow:hidden;background:#fff;text-align:center;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;padding:9px 10px;background:#e6effc;color:#315577;font-size:13px;font-weight:700;line-height:1.4;\"\u003eClosing MRR\u003c\/div\u003e\n\u003cdiv style=\"padding:15px 10px 17px;color:#102a4c;font-size:24px;font-weight:700;line-height:1.25;font-variant-numeric:tabular-nums;\"\u003e$114,997\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 150px;min-width:0;border:1px solid #bfd2ed;border-radius:10px;overflow:hidden;background:#fff;text-align:center;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;padding:9px 10px;background:#e6effc;color:#315577;font-size:13px;font-weight:700;line-height:1.4;\"\u003eNet change\u003c\/div\u003e\n\u003cdiv style=\"padding:15px 10px 17px;color:#102a4c;font-size:24px;font-weight:700;line-height:1.25;font-variant-numeric:tabular-nums;\"\u003e$5,510\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 150px;min-width:0;border:1px solid #bfd2ed;border-radius:10px;overflow:hidden;background:#fff;text-align:center;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;padding:9px 10px;background:#e6effc;color:#315577;font-size:13px;font-weight:700;line-height:1.4;\"\u003eMRR losses\u003c\/div\u003e\n\u003cdiv style=\"padding:15px 10px 17px;color:#102a4c;font-size:24px;font-weight:700;line-height:1.25;font-variant-numeric:tabular-nums;\"\u003e$3,510\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 150px;min-width:0;border:1px solid #bfd2ed;border-radius:10px;overflow:hidden;background:#fff;text-align:center;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;padding:9px 10px;background:#e6effc;color:#315577;font-size:13px;font-weight:700;line-height:1.4;\"\u003eMRR growth\u003c\/div\u003e\n\u003cdiv style=\"padding:15px 10px 17px;color:#102a4c;font-size:24px;font-weight:700;line-height:1.25;font-variant-numeric:tabular-nums;\"\u003e5.0%\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 150px;min-width:0;border:1px solid #bfd2ed;border-radius:10px;overflow:hidden;background:#fff;text-align:center;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;padding:9px 10px;background:#e6effc;color:#315577;font-size:13px;font-weight:700;line-height:1.4;\"\u003eInstalled-base change\u003c\/div\u003e\n\u003cdiv style=\"padding:15px 10px 17px;color:#102a4c;font-size:24px;font-weight:700;line-height:1.25;font-variant-numeric:tabular-nums;\"\u003e($1,985)\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 150px;min-width:0;border:1px solid #bfd2ed;border-radius:10px;overflow:hidden;background:#fff;text-align:center;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;padding:9px 10px;background:#e6effc;color:#315577;font-size:13px;font-weight:700;line-height:1.4;\"\u003eNew and returning MRR\u003c\/div\u003e\n\u003cdiv style=\"padding:15px 10px 17px;color:#102a4c;font-size:24px;font-weight:700;line-height:1.25;font-variant-numeric:tabular-nums;\"\u003e$7,495\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003ch3 style=\"margin:26px 0 12px;font-size:20px;font-weight:700;line-height:1.3;color:#102a4c;\"\u003eExplore the financial questions\u003c\/h3\u003e\n\u003cdiv style=\"display:flex;flex-wrap:wrap;gap:12px;margin:0 0 6px;\"\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 250px;min-width:0;padding:18px;border:1px solid #d9e5f2;border-radius:10px;background:#fff;\"\u003e\n\u003cstrong style=\"display:block;margin:0 0 8px;color:#2563eb;font-size:16px;line-height:1.35;\"\u003eOpening to closing MRR\u003c\/strong\u003e\u003cp style=\"margin:0;color:#102a4c;font-size:15px;line-height:1.6;\"\u003eExpansion, contraction and churn describe the installed base. Reactivated subscriptions are grouped with new starts. A replacement threshold keeps closing MRR equal to opening MRR.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 250px;min-width:0;padding:18px;border:1px solid #d9e5f2;border-radius:10px;background:#fff;\"\u003e\n\u003cstrong style=\"display:block;margin:0 0 8px;color:#2563eb;font-size:16px;line-height:1.35;\"\u003eNew acquisition vs replacement floor\u003c\/strong\u003e\u003cp style=\"margin:0;color:#102a4c;font-size:15px;line-height:1.6;\"\u003eBy segment and month compare (shrink+lost)\/opening and expand\/opening, with a matching-dollar detail.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv style=\"box-sizing:border-box;flex:1 1 250px;min-width:0;padding:18px;border:1px solid #d9e5f2;border-radius:10px;background:#fff;\"\u003e\n\u003cstrong style=\"display:block;margin:0 0 8px;color:#2563eb;font-size:16px;line-height:1.35;\"\u003eSelected-month operating comparison\u003c\/strong\u003e\u003cp style=\"margin:0;color:#102a4c;font-size:15px;line-height:1.6;\"\u003eCompare the observed results using each unit’s own denominator.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003ch3 style=\"margin:26px 0 12px;font-size:20px;font-weight:700;line-height:1.3;color:#102a4c;\"\u003eMove between the decision views\u003c\/h3\u003e\n\u003cp style=\"margin:0 0 14px;font-size:16px;line-height:1.65;color:#102a4c;\"\u003eThe analytical views include Dashboard, Driver detail, Acquisition floor. Start with the overview, then use the relevant driver, register or scenario view to explain a difference. Keep the reporting context consistent when comparing an amount with its source or another operating unit.\u003c\/p\u003e\n\u003ch3 style=\"margin:26px 0 12px;font-size:20px;font-weight:700;line-height:1.3;color:#102a4c;\"\u003eHow to adapt the dashboard\u003c\/h3\u003e\n\u003cdiv style=\"box-sizing:border-box;padding:18px 20px;border:1px solid #d9e5f2;border-left:4px solid #2563eb;border-radius:10px;background:#fff;\"\u003e\n\u003cp style=\"margin:0 0 14px;font-size:16px;line-height:1.65;color:#102a4c;margin-bottom:0;\"\u003eStart with the short How to worksheet, which identifies the inputs, selectors and result views for this dashboard. Keep an unchanged copy of the sample before replacing its data. Enter your source values in the highlighted cells, review one reporting selection and reconcile a headline amount to your records. Change a material driver and check the result in its labelled unit. A decision assumption describes a modelled case; it does not replace the observed source figures.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003ch3 style=\"margin:26px 0 12px;font-size:20px;font-weight:700;line-height:1.3;color:#102a4c;\"\u003eUnderstand the calculation basis\u003c\/h3\u003e\n\u003cp style=\"margin:0 0 14px;font-size:16px;line-height:1.65;color:#102a4c;\"\u003eTransfers between segments require a consistent restatement. Exclude taxes, one-offs, cash receipts and FX changes. Only churn and expansion change. Reactivations enter before the required fresh MRR is calculated.\u003c\/p\u003e\n\u003cp style=\"margin:22px 0 0;padding-top:16px;border-top:1px solid #cbdcf1;color:#5e7591;font-size:13px;line-height:1.65;\"\u003eFor a team review, record the selected period, operating unit, source of the inputs and the case assumptions alongside the conclusion. This context helps a colleague reproduce the result and distinguish a change in the business from a change in the modelling assumptions. The included sample is illustrative rather than company reporting.\u003c\/p\u003e\n\u003c\/section\u003e\n","brand":"FinancialModelsLab","offers":[{"title":"Default Title","offer_id":68415786811635,"sku":"saas-mrr-bridge-excel-dashboard","price":0.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/saas-mrr-bridge-financial-dashboard-cover.png?v=1793800115","url":"https:\/\/financialmodelslab.com\/products\/saas-mrr-bridge-excel-dashboard","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}