Generated TIPS Ladder
Year funded	TIPS holdings	Maturity date	Coupon	Yield to maturity	Inflation- adjusted principal	Ask price	Pre- maturity liquidation	Cost of bonds	Accrued interest cost	Net purchase cost	Pre- ladder interest³	Principal income	Interest income	Total income
2030	912828Z37 × 17	2030-01-15	0.125%	2.196%	$1205.67	$1,072.29		$18,229	$7	$18,236	$33,744	$20,496	$6,122	$60,363
2031	91282CBF7 × 45	2031-01-15	0.125%	2.197%	$1191.62	$1,038.20		$46,719	$19	$46,738		$53,623	$6,076	$59,699
2032	91282CDX6 × 48	2032-01-15	0.125%	2.203%	$1119.03	$955.02		$45,841	$19	$45,861		$53,714	$6,009	$59,723
2033	91282CGK1 × 51	2033-01-15	1.125%	2.234%	$1041.37	$950.25		$48,463	$172	$48,635		$53,110	$5,677	$58,787
2034	91282CJY8 × 58	2034-01-15	1.750%	2.236%	$1009.13	$966.56		$56,061	$295	$56,356		$58,530	$3,329	$61,859
2035¹	91282CJY8 × 58	2034-01-15	1.750%	2.236%	$1009.13	$966.56		$56,061	$295	$56,356		$58,530	$1,281	$59,811
2036¹	91282CJY8 × 58	2034-01-15	1.750%	2.236%	$1009.13	$966.56		$56,061	$295	$56,356		$58,530	$1,281	$59,811
2037¹	91282CJY8 × 58	2034-01-15	1.750%	2.236%	$1009.13	$966.56		$56,061	$295	$56,356		$58,530	$1,281	$59,811
2038²	912810QF8 × 42	2040-02-15	2.125%	2.327%	$1435.18	$1,397.06	2038-02-15	$58,676	$260	$58,937		$60,277	$640	$60,918
Totals										$443,831				$540,780

^{[1]: No TIPS matures this year so an earlier-maturing one is used.}^{[2]: No TIPS matures this year so a later-maturing one is used.}^{[3]: Interest earned before the start of the ladder's first year.}^dummy

Generated TIPS Ladder
Year funded	TIPS holdings	Net purchase cost	Pre- ladder interest³	Principal income	Interest income	Total income
2030	912828Z37 × 17	$18,236	$33743.92	$20,496	$6,122	$60,363
2031	91282CBF7 × 45	$46,738		$53,623	$6,076	$59,699
2032	91282CDX6 × 48	$45,861		$53,714	$6,009	$59,723
2033	91282CGK1 × 51	$48,635		$53,110	$5,677	$58,787
2034	91282CJY8 × 58	$56,356		$58,530	$3,329	$61,859
2035¹	91282CJY8 × 58	$56,356		$58,530	$1,281	$59,811
2036¹	91282CJY8 × 58	$56,356		$58,530	$1,281	$59,811
2037¹	91282CJY8 × 58	$56,356		$58,530	$1,281	$59,811
2038²	912810QF8 × 42	$58,937		$60,277	$640	$60,918
Totals		$443,831				$540,780

Parameters
Desired annual real income	60000
Income requirement kind	Average
Earliest year to fund	2030
Final year to fund	2038
Bond choice within year	Earliest to mature
Bond choice for years with no maturing TIPS	Bond maturing in the year nearest to the start of rung-year

Properties
Years funded	9
Cost to purchase	$443,831
Total income	$540,780
Annual income average	$60,087
Annual income minimum	$58,787
Withdrawal Rate	13.54%
XIRR	2.26%
TIPS price date	2024-4-26
Creation time (NY)	2024-4-27 1:34 PM
Purchase date	2024-4-29
Settlement date	2024-4-30