On July 1, 2016, the first day of its 2017 fiscal year, the City of Nevin issued at par $7,500,000 of 4 percent term bonds to construct a new city office building. The bonds mature in five years on July 1, 2021. Interest is payable semiannually on January 1 and July 1. A sinking fund is to be established with equal semiannual additions made on June 30 and December 31, with the first addition to be made on December 31, 2016. Cash for the sinking fund additions and the semiannual interest payments will be transferred from the General Fund shortly before the due dates. City officials assume a yield on sinking fund investments of 4 percent per annum, compounded semiannually. Investment earnings are added to the investment principal.

Just Need the Journal ENTIRES, THE ACCOUNTS ARE CORRECT. JUST NEED THE AMOUNTS.

Requirea a. Prepare a schedule in good form showing the required additions to the sinking fund, the expected semiannual earnings, and the end-of-period balance in the sinking fund for each of the 10 semiannual periods. (Note: The future amount of an ordinary annuity of $1 for 10 periods at 2 percent per period is 10.949721.) (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Fiscal Year Period Required Addition Expected Earnings Ending Balance 684,949? $ 684,949 684,949 684,949 684,949 684,949 684,949 684,949 684,949 684,949 684,949 1,383,598 2,096,219 2,823,092 3,564,503 4,320,742 5,092,106 5,878,897 6,681,424 7,500,001 2017 13,700 27,672 41,924 56,462 71,290 86,415 101,842 117,578 133,628 2 3 4 2018 2019 6 2020 7 2021 10