A company sold $100,000 bonds and set up a sinking fund that was earning 8% compounded semi-annually to retire to bonds in 3 years.

Schedule can be completed in Excel. No work needs to be shown for schedule entries.

a. If the company made equal deposits into the fund, at the beginning of every six months, calculate the size of the periodic payments deposited.

Round up to the next cent

b. Construct a sinking fund schedule, showing the details of all the payments, and the totals of the schedule.

For answers: Round to the nearest cent

Payment Period	Payment	Interest Earned	Increase in the Fund	Fund Balance	Book Value
0				$0.00	$100,000.00
1
2
3
4
5
6
Total