2023 financial statements that will be prepared in Chapter 9. Be sure to select 2024 in the [Year] menu. 1. [Para. 6-d-1] On January 2, 2024, the Street Improvement Bond Debt Service Fund budget for 2024 is legally adopted. The budget should provide for estimated property tax revenue of $645,000, of which $300,000 will be invested to accumulate resources over the next four years for the $750,000 principal payment that will be due on January 1 , 2028 for the 2.5% deferred serial bonds. The budget should include estimated investment earnings of $4,000 during 2024. Property tax revenues are intended to help pay $75,000 interest due during 2024 on the 2.5% deferred serial bonds (due January 1 and July 1), as well as the $82,500 interest payment that will be due on the 2.75% serial bonds on July 1 , 2024. The property tax levy will also provide resources to help pay interest of $120,000 due on January 1,2025 ( $37,500 interest on the 2.5% deferred serial bonds and $82,500 on the 2.75% serial bonds). No premium or accrued interest on bonds sold is included in the 2024 estimated other financing sources or estimated revenues. If the Street Improvement Debt Service Fund does receive such items the budget will be amended accordingly to reflect such items. Required: Record the budget for FY 2024 in the general journals for the Street Improvement Bond Debt Service Fund. [As a reminder, you should make journal entries for FY 2024 only in the debt service fund, ignoring any entries for governmental activities at the government-wide level or any other funds.] 2. [Para. 6-d-2] Property taxes were levied in the amount of $650,000, of which $5,000 was estimated to be uncollectible. Required: Prepare the journal entry to record the taxes levied and related estimated uncollectible. 3. [Para. 6-d-3] Bond interest due on January 1, 2024 in the amount of $37,500 was paid for the 2.5% deferred serial bonds. Required: Prepare the journal entry to record the payment of interest. 4. [Para. 6-d-4] On March 1, 2024, the Street Improvement Debt Service Fund received $27,500 for two months of accrued interest from the sale of the additional $6,000,000 street improvement bonds (see first paragraph of section d). Required: Prepare journal entries to record the receipt of $27,500 in cash. Also, prepare a journal entry to amend the FY 2024 budget to reflect the amount of the accrued interest on bonds sold. You should credit Budgetary Fund Balance for the full $27,500, since the appropriation for the interest payment due on July 1,2024, was recorded in Paragraph 6d-1. f. Export a pre-closing trial balance for year 2024 to Excel to prepare a statement of revenues, expenditures, and changes in fund balance for the Street Improvement Bond Debt Service Fund for the year ended December 31, 2024. g. Use the same trial balance exported in item f above to prepare a schedule of revenues, expenditures, and changes in fund balance- budget and actual for the Street Improvement Bond Debt Service Fund for the year ended December 31, 2024. [Note: Retain a printout of all worksheets and your financial statements in your cumulative file until directed by your instructor to submit them, unless your instructor specifies that you should submit files electronically, in which case you will need to save a .pdf version of your trial balance.] Before closing the City of Smithville it is recommended that you save a backup copy of your work to another location by clicking on [File] and [Save As]. Required: Record this transaction in the debt service fund. No entry is required at this time in the governmental activities general journal since the bond issue, including the related premium and accrued interest, was recorded in the governmental activities general journal in transaction 5-a-2. 3. [Para. 6-a-3] To permit payment of the $37,500 interest payments due on July 1, 2023 and January 1, 2024, the Street Improvement Bond Debt Service Fund received \$38,750 from the General Fund. Required: Record the interfund transfer in the debt service fund journal only. This transaction was previously recorded in the General Fund in Chapter 4 of this problem. The transaction has no effect at the government-wide level since it occurs between two governmental funds. 4. [Para. 6-a-4] The July 1, 2023, interest payment was made in the amount of $37,500. Required: Record the interest payment in both the debt service fund and the governmental activities general journals. Since Expense-Interest on Long-Term Debt was credited for $6,250 in 5a2 in the governmental activities general joumal record the full July 1,2023 interest payment as a debit to Interest Expense, less amortization of the premium. For the entry in the governmental activities journal, assume that the appropriate amount of amortization of the Premium on Deferred Serial Bonds Payable for the period the bonds have been outstanding (February 1 to July 1) is \$231. Although premiums and discounts on bonds issued are not amortized in a debt service fund, they should be amortized at the government-wide level since the accrual basis of accounting is used at that level. 5. [Para. 6-a-5] Accrue six months of interest payable on the 2.5% deferred serial bonds from the July 1 interest payment until the end of the fiscal year, December 31,2023. Required: Make the required journal entry in the governmental activities general journal. For this entry, assume that the appropriate amount of amortization of the Premium on Deferred Serial Bonds Payable is \$233. Recall that interest is not accrued for the period July 1 to December 31,2023 in the debt service fund as no appropriation exists for this expenditure and the interest is not due this fiscal year. 6. Verify the accuracy of journal entries, including dates and paragraph numbers, and, if you have not already done so, post all entries to the general ledger of both the Street Improvement Bond Debt Service Fund and governmental activities by clicking on [Post entries]. Make the entries needed to close the budgetary and operating statement accounts at the end of fiscal year 2023. Budgetary and operating statement accounts should be closed to Budgetary Fund Balance and Fund Balance-Restricted, as appropriate. Make this entry only in the Street Improvement Bond Debt Service Fund journal. Be sure that for each account being closed that the check mark for [Closing Entry] is on and that "Closing Entry" appears in the [Add description] box. Closing entries for governmental activities at the government-wide level will be made in Chapter 9 of this cumulative problem. b. Go to [File/Export] and export Excel files of the pre-closing and post-closing trial balances for the Street Improvement Bond Debt Service Fund as of December 31, 2023, and use them to prepare a balance sheet; statement of revenues, expenditures, and changes in fund balances; schedule of revenues, expenditures, and changes in fund balances - budget and actual for the Street Improvement Bond Debt Service Fund. The format for the statements will be similar to that of the combing statements in Illustrations 68,69, and 610 of the textbook. [Note: Retain all required printouts in your cumulative folder until directed by your instructor to submit them, unless your instructor specifies submission of files electronically, in which case you will need to save a .pdf version of your trial balance.] Before closing the City of Smithville it is recommended that you save a backup copy of your work to another location by clicking on [File] and [Save As]. c. As given later in Chapter 8 of this project, the assessed valuation of property within the City of Smithville is $342,581,818. Assuming the legal general obligation debt limit is 8 percent of assessed valuation, prepare in good form a schedule showing the legal debt limit, debt outstanding subject to the limit, and the legal debt margin of the city as of December 31, 2023 , rounding the debt limit to the nearest whole dollar (see Illustration 6-3 for an example). A note at the bottom of the schedule should disclose the bonds authorized but unissued, as described in the introductory paragraph of Chapter 5 of the City of Smithville cumulative problem. This will inform the reader that additional debt issuances are pending. Fiscal year 2024 Transactions: d. On January 2, 2024, the City of Smithville approved the issuance of additional street improvement bonds in the total amount of $6,000,000. The new bonds will be serial bonds and will bear interest at the nominal annual rate of 2.75 percent. These bonds are dated January 1,2024, and will be issued during the next few months when the city's bond underwriters believe market conditions are most favorable. The first interest payment on the new bonds will be due on July 1,2024 ; interest will be payable January 1 and July 1 of each following year until maturity. Bonds in the amount of $200,000 will mature on January 1,2025, and in the same amount at each interest payment date thereafter until all bonds of the 2024 issue have been retired. To give you some additional practice on accounting for a debt service fund record the following events and transactions that are presumed to occur in fiscal year 2024. The transactions are to be recorded in the Street Improvement Bond Debt Service Fund only. You should ignore entries that would be required in the General Fund and in the governmental activities general journal related to these transactions for fiscal year 2024. Keep in mind that these transactions will not affect the Chapter 6 Transactions Affecting General Long-term Liabilities and Debt Service The City of Smithville created a Street Improvement Bond Debt Service Fund to be used to retire the bonds issued for the purposes described in Chapter 5 of this cumulative problem, and to pay the interest on the bonds. The $3,000,000 face value of bonds issued during 2023 are dated January 1,2023, but were not issued until February 1, 2023. Because bondholders will receive six months of interest on July 1,2023 in the total amount of $37,500, they were required to pay $6,250 on the date of issue to pay the city for unearned interest from January 1 to February 1 . The bonds bear interest of 2.5 percent per annum. The first interest payment of $37,500 is due July 1,2023 . Subsequent semiannual interest payments will be made January 1 and July 1 of each following year until the maturity of the bonds. Bonds in the amount of $750,000 are to mature five years after the date of the bonds (January 1,2028), and $150,000 is to mature January 1 of each year thereafter until all the bonds issued in 2023 have been retired. Thus, these bonds are deferred serial bonds as discussed in Chapter 6 of the textbook. Make entries as instructed in the following paragraphs. Bond covenants related to this bond issue require the city to levy property taxes sufficient to make principal and interest payments until the bonds have been retired. The city council has approved a resolution to enable the property tax levy, beginning in fiscal year 2024. As the bond issue did not occur until February 2023, the city will not levy debt service property taxes until next year. a. Prepare general journal entries, as necessary to record the transactions described below in the Street Improvement Bond Debt Service Fund general journal and, if applicable, in the governmental activities general journal. Use account titles listed under the drop down [Account] menu. Be sure the year 2023 is selected from the drop-down [Year] menu and the appropriate paragraph number shown in bold-face font below is in the [Add description] box. 1. [Para. 6-a-1] In early February 2023, an amendment to the annual budget for 2023 was approved by the city council for inflows and outflows in the Street Improvement Bond Debt Service Fund related to the bond issue. The debt service fund budget amendment provides for estimated other financing sources of $30,000 for the premium on bonds sold, estimated other financing sources of $38,750 for a transfer from the General Fund that will be used to help pay interest due on July 1, 2023 and January 1, 2024, estimated revenues of $6,250 for accrued interest on bonds sold, and appropriations in the amount of the one interest payment of $37,500 to be made during 2023. (The payment that is due on July 1,2023 .) Required: Record the budget for the Street Improvement Bond Debt Service Fund for year 2023. Budgetary entries have no effect on the government-wide accounting records. 2. [Para. 6-a-2] On February 1, 2023, the premium and accrued interest on bonds sold were received by the Street Improvement Bond Debt Service Fund. (See Transaction 5-a-2 in the Street Improvement Fund.)