sgb-analyzer-logo

SGB Analyzer

Free

SGB Maturity Planner

Plan your SGB maturities and projected cash flows

SpreadsheetExcel / Google SheetsFree

Plan your SGB maturities and cash flows

Download Free

**Plan Your SGB Cash Flows**

This template helps you visualize and plan around your SGB maturities: - See when each SGB will mature - Project maturity values based on gold price assumptions - Plan interest payment receipts - Align maturities with financial goals

**Perfect for:** - Retirement planning - Goal-based investing - Laddering strategy implementation

Features Included

Maturity timeline visualization
Projected redemption values
Interest payment calendar
Multiple gold price scenarios
Goal alignment tracker
Reinvestment planning
Tax impact projections
Export to calendar

How to Use This Template

1

Enter your SGB holdings with maturity dates

2

Set gold price growth assumptions

3

View maturity timeline and projections

4

Align with your financial goals

5

Plan reinvestment or withdrawal

**Disclaimer:** This template/tool is provided for educational and informational purposes only. It is NOT a substitute for professional financial advice. Results and calculations are estimates and may not reflect actual outcomes. Please consult a qualified financial advisor before making investment decisions. We are not responsible for any losses incurred from using this template.

Calculate Your SGB Returns

Use our calculator to estimate your potential returns based on investment amount and holding period.

Frequently Asked Questions

Projections depend on your gold price assumptions. We suggest running multiple scenarios (conservative, moderate, optimistic) for planning purposes.
The template requires manual entry of holdings. We provide guidance on fetching data from your broker statements.
Yes, the template shows both maturity date (8 years) and early redemption eligibility date (5 years) for each SGB.

More Templates & Tools

Portfolio TrackerInvestment ChecklistOnline Calculator

Related Resources

SGB Portfolio Tracker Spreadsheet

Excel/Google Sheets template to track your SGB investments

Learn more

SGB Calculators

Interactive SGB calculators

Learn more

SGB Strategies

Investment strategies

Learn more

View Real-Time SGB Prices

Track all 70+ SGBs with live prices, discounts, yields, and more. Updated every few minutes.