A company sold $300,000 bonds and set up a sinking fund that was earning 7.5% compounded semi-annually to retire the bonds in three years. If it made equal deposits into the fund at the beginning of every six months, construct a partial sinking fund schedule showing the details for the first two and last two payments and the totals of the schedule.

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

Round the payment up to the next cent. Round all other values to the nearest cent

Payment Period	Payment	Interest Earned	Increase in the Fund	Fund Balance	Book Value
0				$0.00	$300,000.00
1
2
: :	: :	: :	: :	: :	: :
: :	: :	: :	: :	: :	: :
		_
Total