I need help with journal entries to find the Net Positions. (That's all I have)

813. The fund-basis financial statements of Jefferson County have been completed for the year 2020 and appear in the first tab of the Excel spreadsheet provided with this exercise. The following information is also available:

1. Capital Assets

Capital assets purchased in previous years through governmental-type funds totaled $7,890,000 (net of accumulated depreciation) as of January 1.

Depreciation on capital assets used in governmental-type activities amounted to $327,000.

No capital assets were sold or disposed of, and all purchases are properly reflected in the fund-basis statements as capital expenditures.

2. Long-Term Debt 1. There was no outstanding long-term debt associated with governmental-type funds as of January 1.

April 1, 6 percent bonds with a face value of $700,000 were issued at a premium. Bond payments are made on October 1 and April 1 of each year. Interest is based on an annual rate of 6 percent, and principal payments are $22,000 each. The first payment (interest and principal) was made on October 1.

Amortization of the bond premium for the current year is $1,800.

3. Deferred Inflows of Resources 1. Deferred inflows (comprised solely of property taxes) are expected to be collected more than 60 days after year-end. The balance of deferred taxes at the end of 2019 was $18,700.

4. Transfers

Transfers were between governmental-type funds.

Internal Service Fund

The (motor pool) internal service funds revenue is predominantly derived from departments classified as governmental-type activities.

There were no amounts due to the internal service fund from the General Fund. The outstanding balance of Due to Other Funds was with the enterprise fund and is not capital related.

The enterprise fund provided a long-term advance to the internal service fund (not capital related).

Required: Use the Excel template provided to complete the following requirements; a separate tab is provided in Excel for each of these steps.

a. Prepare the journal entries necessary to convert the governmental fund financial statements to the accrual basis of accounting.

b. Post the journal entries to the conversion worksheet provided.

c. Prepare a government-wide Statement of Activities and Statement of Net Position for the year 2020. All of the governmental fund revenues are general revenues.

This is an involved problem, requiring many steps. Here are some hints.

1. Tab 1 is information to be used in the problem. You do not enter anything here. After you make the journal entries (Tab 2), post these to the worksheet to convert to the accrual basis. This worksheet is set up so that you enter debits as positive numbers and credits as negative. After you post your entries, look at the numbers below the total credit column to see that debits equal credits. If not, you probably entered a credit as a positive number.

2. Make sure that total debits equal total credits in the last column (balances for government-wide statements).

3. When calculating Restricted Net Position, recall that permanent fund principal is added to restricted fund balances.

Liabilities, Deferred Inflows and Fund Balance Liabilities Accounts Payable Wages Payable Contracts payable Total Liabilities 21,000 21,000 Fund Balances Nonspendable Inventories Permanent fund principal Restricted Assigned Unassigned Total Fund Equity Jefferson County Statement of Revenues Expenditures and Changes in Fund Balance for the year ended 12312020 \begin{tabular}{ccccc} & Capital & & & Total \\ General & Projects & Debt Service & Permanent & Governmental \\ Fund & Fund & Fund & Fund & Funds \\ \hline \end{tabular} Revenues Property Taxes \begin{tabular}{crrrr} S262,075 S & - & & & 262,075 \\ & 280,000 & & 280,000 \\ & & & 21,100 & 21,100 \\ \hline 262,075 & 280,000 & - & 21,100 & 563,175 \\ \hline & & & & \end{tabular} Expenditures Current: General Government Operations Library Capital Outlay 41,400612,000 Excess (Deficiency) of Revenues Over Expenditure 40,615(332,000) (43,000) (325,985) Other financing sources (uses) Proceeds of bonds Premum on bonds Transfers in Transfers out total other financing sources (uses) \begin{tabular}{lllll} (43,000) & (22,800) & & & (65,800) \\ \hline(43,000) & 700,000 & 65,800 & - & 722,800 \end{tabular} Net Change in Fund Balance Fund Balance, January 1 Fund Balance, December 31 Jefferson County Jefferson County Note: Enter all amouts as positive numbers. The vorksheet is fonmatted to add debits to ass credits to liabilities, equities a Liabilities, Deferred Inflows and Fund Balance Liabilities Accounts Payable Wages Payable Contracts payable Total Liabilities 21,000 21,000 Fund Balances Nonspendable Inventories Permanent fund principal Restricted Assigned Unassigned Total Fund Equity Jefferson County Statement of Revenues Expenditures and Changes in Fund Balance for the year ended 12312020 \begin{tabular}{ccccc} & Capital & & & Total \\ General & Projects & Debt Service & Permanent & Governmental \\ Fund & Fund & Fund & Fund & Funds \\ \hline \end{tabular} Revenues Property Taxes \begin{tabular}{crrrr} S262,075 S & - & & & 262,075 \\ & 280,000 & & 280,000 \\ & & & 21,100 & 21,100 \\ \hline 262,075 & 280,000 & - & 21,100 & 563,175 \\ \hline & & & & \end{tabular} Expenditures Current: General Government Operations Library Capital Outlay 41,400612,000 Excess (Deficiency) of Revenues Over Expenditure 40,615(332,000) (43,000) (325,985) Other financing sources (uses) Proceeds of bonds Premum on bonds Transfers in Transfers out total other financing sources (uses) \begin{tabular}{lllll} (43,000) & (22,800) & & & (65,800) \\ \hline(43,000) & 700,000 & 65,800 & - & 722,800 \end{tabular} Net Change in Fund Balance Fund Balance, January 1 Fund Balance, December 31 Jefferson County Jefferson County Note: Enter all amouts as positive numbers. The vorksheet is fonmatted to add debits to ass credits to liabilities, equities a