Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Using Exhibit 13-14 Town of Millbridge’s Statement of Revenue, Expenditures, and

ID: 2535126 • Letter: U

Question

Using Exhibit 13-14 Town of Millbridge’s Statement of Revenue, Expenditures, and Changes in Fund Balance-Governmental Fund. calculate the following numbers and interpret them.

            (1) Debt service burden for total governmental fund

            (2) Risk exposure factor for total governmental fund

using this formula:

Debt service burden = Total debt service / Total revenue–Debt service: Principal and interest payments (and other charges)

Risk exposure factor= [Intergovernmental revenue (e.g. grant) + transfer In + investment revenue] / Own revenue sources.

EXHIBIT 13-14 Millbridge Governmental Funds Statement of Revenues, Expenditures, and Changes in Fund Balances Town of Millbridge Statement of Revenues, Expenditures, and Changes in Fund Balances Governmental Funds December 31, 2018 General Fund Debt Service Fund Capital Projects Fund Total Governmental Funds 611,000 $611,000 Property Taxes Fees Permits Intergovernmental state aid Charges for services Investment earnings 150,000 150,000 $ 761,000 Total Revenues $ 761,000 Current General government Public safety Sanitation $340,000 215,000 105,000 340,000 215,000 105,000 Debt service: 50,000 15,000 270,000 $995,000 Principal Interest and other charges 50,000 15,000 270,000 Capital outlay $ 660,000 65,000 270,000 Total Expenditures Excess/(Deficiency) of Revenues $101,000 $(65,000) $(270 234 Over Expenditures Other Financing Sources/(Uses) Proceeds from long-term capital $ 200,000 $200,000 related debt Transfers in Transfers out 100,000 100 100,000 $(100,000) 1,000 15,000 $ 16.000 $100,000 35,000 28,000 S 63,000 $200,000 (70,000) 90,000 $ 20,000 200,000 $(34,000) 133,000 $ 99,000 Total Other Financing Sources and Uses Net Change in Fund Balances Fund balances-beginning Fund balances-beginning

Explanation / Answer

Using Exhibit 13-14 Town of Millbridge’s Statement of Revenue, Expenditures, and Changes in Fund Balance-Governmental Fund. calculate the following numbers and interpret them.             (1) Debt service burden for total governmental fund             (2) Risk exposure factor for total governmental fund Town of Millbridge Statement of Revenues, Expenditures and changes in Fund Balances Government Funds 31-Dec-18 General Fund Debt Service Fund Capital Projects fund Total Government Funds Revenue Property Taxes $       6,11,000 $ 6,11,000 Fees Permits Intergovernmental - State Aid $       1,50,000 $ 1,50,000 Charges for Services Investment Earnings $                                -        Total Revenues $       7,61,000 $                   -   $                    -   $ 7,61,000 Expenditures Current       General Governmental $       3,40,000 $ 3,40,000      Public Safety $       2,15,000 $ 2,15,000      Sanitation $       1,05,000 $ 1,05,000 Debt Service $ -        Principal $         50,000 $ 50,000      Interest and other charges $         15,000 $ 15,000 Capital Outlay $       2,70,000 $ 2,70,000 Total Expenditures $       6,60,000 $         65,000 $       2,70,000 $ 9,95,000 Excess (Deficiency) of Revenues $                                -        Over Expenditures $       1,01,000 $       (65,000) $     (2,70,000) $ (2,34,000) Other Financing Sources (Uses) $                                -   Proceeds from Long Term Capital $                                -        Related Debt $       2,00,000 $ 2,00,000      Transfers - In $      1,00,000 $ 1,00,000      Transfers - Out $     (1,00,000) $ (1,00,000) Total Other Financing Sourses and Uses $     (1,00,000) $      1,00,000 $       2,00,000 $ 2,00,000 Net Change in Fund Balances $             1,000 $         35,000 $        (70,000) $ (34,000) Fund Balances - Beginning $           15,000 $         28,000 $           90,000 $ 1,33,000 Fund Balances - Ending $           16,000 $         63,000 $           20,000 $ 99,000 Using this formula: Debt service burden = Total debt service / Total revenue–Debt service: Principal and interest payments (and other charges) Ans: Debt Service Burden = $        (65,000) =(65000/761000)-65000 Risk exposure factor= [Intergovernmental revenue (e.g. grant) + transfer In + investment revenue] / Own revenue sources. ANS: Risk Exposure Factor = 0.3285 =(150000+100000+0)/761000

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote