I am looking to figure out how to recreate a general obligation municipal bond schedule and am having difficulty with this. Can you help?
The statistics are: It's a 20 year $2,035,000 bond. The net interest cost is $4.7675%. The sale date is 4/17/xx. the delivery date is 4/30/xx. the dated date?? is 4/1/xx. Capitalized interest is $45,994.10
The first interest payment is due on 11/1/x0 of $53,363.33 which is capitalized interest plus accrued interest of $7,369.23.
The principal due is 40,000 on 5/1/x1 and $105,000 the remaining 19 years.
Interest rates are: 4.0;4.0;4.0;4.0;4.1;4.2;4.3;4.35;4.4;4.4;4.4;4.5;4.6;4.7;4.8;4.9;4.95;5;5;5
Can you help me figure out how to recreate this in excel? Thanks!
The statistics are: It's a 20 year $2,035,000 bond. The net interest cost is $4.7675%. The sale date is 4/17/xx. the delivery date is 4/30/xx. the dated date?? is 4/1/xx. Capitalized interest is $45,994.10
The first interest payment is due on 11/1/x0 of $53,363.33 which is capitalized interest plus accrued interest of $7,369.23.
The principal due is 40,000 on 5/1/x1 and $105,000 the remaining 19 years.
Interest rates are: 4.0;4.0;4.0;4.0;4.1;4.2;4.3;4.35;4.4;4.4;4.4;4.5;4.6;4.7;4.8;4.9;4.95;5;5;5
Can you help me figure out how to recreate this in excel? Thanks!