A. Compare and contrast the Balance Sheet of Colgate-Palmolive with the Balance Sheet of the City of Dallas Governmental-Type Funds for 2017 (25 marks). B. Compare and contrast the Income statement of Colgate-Palmolive with the City of Dallas Statements of Revenue, Expenditures and Changes in Fund Balances for 2017 (25 marks).
Note: This is a descriptive financial analysis; no data analysis is required. This question requires us to compare a governmental fund balance sheet and Statements of revenue, expenditures and changes in fund balance with the business equivalents in the for-profit sector.
Breakdown 12/31/2018 12/31/2017 12/31/2016 12/31/2015 v Assets Prem Current ASsets Le Cash Cash And Cash Equivalents 726,000 1,535,000 1,315,000 970,000 Short Term Investments Total Cash 726,000 1,535,000 1,315,000 970,000 Net Receivables 1,400,000 1,480,000 1,411,000 1.427,000 1,171,000 1,180,000 Inventory 1,250,000 1,221,000 807,000 Other Current Assets 417,000 403,000 441,000 3,793,000 4,338,000 Total Current Assets 4,839,000 4,384,000 Non-current assets Property. plant and equip.. Gross property, plant and e- 8,336,000 8,460,000 7,942,000 8,059,000 Accumulated Depreciation -4,455,000 -4,388,000 -4,102,000 -4,263,000 Net property, plant and eq 3,881,000 4,072,000 3,840,000 3,798,000 Equity and other investments 2,530,000 2,218,000 Goodwill 2.107,000 2,103,000 Intangible Assets 1,346,000 1,837,000 3,985,000 1,313,000 Other long-term assets 4,487,000 218,000 224,000 3,778,000 Total non-current assets 8,368,000 8,037,000 7,785,000 7,574,000 11,958,000 Total Assets 12,161,000 12,676,000 12,123,000 For the Year Ended September 30, 2017 in thousands) Nanmajor Govemmental Funds General Total Debt Service Revenues Ad vaiorem tax 578,032 229,607 46,004 853 733 Tax increment financing, intergavemmental 8829 8,829 Sales tax 295,361 295.361 Franchise fees 138,998 5,207 144 205 Lioenses and pamits 5,242 5242 Intergavemmental 85,299 95.019 9,720 Service to others 126498 65,922 192420 Fines and forfeitures 6.870 37 336 30,466 Investment income 2,655 437 6,232 9.324 Contributions and gifts Confiscated money awards 18.930 1 18931 2,810 2810 Other revenuee Total revenues 14 808 5.888 1305 7,615 1,192,861 231.529 253,718 1678.108 Current expenditures General government 121.278 118,864 240.142 721.753 40500 Publc safety 712.990 8,763 Code enforcement 40,021 488 Enviranmental and health services 16,597 16.597 Streets, public works, and transportation Equipment and building services Culture and recreation 112.924 83.206 29,718 24,778 633 25411 10,114 136,984 147,008 Housing 14,075 14.075 Human services 25,284 25,284 Debt service Principal 16820 17452 148,s6 3,402 Interest and fiscal charges Captal outlay 1521 87,307 950 89,778 213,060 1,816 451 7.739 205,321 Total expenditures 420,134 1,160,044 236 273 Excess (deficiency) of revenues over (138,343) (under) expenditures 32,817 (4,744) (166416) Other firancing sources (uses) 27 545 (16,253) 30.536 (12,676) Transfers in 6,278 64.359 Transfers out (28,929) Proceeds from sae of capital assets Capital lease 24 318 342 25,050 25,060 Issuance of notes 19.147 19.147 79.969 Total other financing sources (uses) 11316 6278 62.375 Net change in fund balances 1.534 (104,041) (58374) 44,133 Fund balances, begining of year Fund balances, end of year 983 480 $ 191.031 11.088 781 361 235,164 12,622 677 320 925106 Breakdown 12/31/2018 12/31/2017 12/31/2016 12/31/2015 v Assets Prem Current ASsets Le Cash Cash And Cash Equivalents 726,000 1,535,000 1,315,000 970,000 Short Term Investments Total Cash 726,000 1,535,000 1,315,000 970,000 Net Receivables 1,400,000 1,480,000 1,411,000 1.427,000 1,171,000 1,180,000 Inventory 1,250,000 1,221,000 807,000 Other Current Assets 417,000 403,000 441,000 3,793,000 4,338,000 Total Current Assets 4,839,000 4,384,000 Non-current assets Property. plant and equip.. Gross property, plant and e- 8,336,000 8,460,000 7,942,000 8,059,000 Accumulated Depreciation -4,455,000 -4,388,000 -4,102,000 -4,263,000 Net property, plant and eq 3,881,000 4,072,000 3,840,000 3,798,000 Equity and other investments 2,530,000 2,218,000 Goodwill 2.107,000 2,103,000 Intangible Assets 1,346,000 1,837,000 3,985,000 1,313,000 Other long-term assets 4,487,000 218,000 224,000 3,778,000 Total non-current assets 8,368,000 8,037,000 7,785,000 7,574,000 11,958,000 Total Assets 12,161,000 12,676,000 12,123,000 For the Year Ended September 30, 2017 in thousands) Nanmajor Govemmental Funds General Total Debt Service Revenues Ad vaiorem tax 578,032 229,607 46,004 853 733 Tax increment financing, intergavemmental 8829 8,829 Sales tax 295,361 295.361 Franchise fees 138,998 5,207 144 205 Lioenses and pamits 5,242 5242 Intergavemmental 85,299 95.019 9,720 Service to others 126498 65,922 192420 Fines and forfeitures 6.870 37 336 30,466 Investment income 2,655 437 6,232 9.324 Contributions and gifts Confiscated money awards 18.930 1 18931 2,810 2810 Other revenuee Total revenues 14 808 5.888 1305 7,615 1,192,861 231.529 253,718 1678.108 Current expenditures General government 121.278 118,864 240.142 721.753 40500 Publc safety 712.990 8,763 Code enforcement 40,021 488 Enviranmental and health services 16,597 16.597 Streets, public works, and transportation Equipment and building services Culture and recreation 112.924 83.206 29,718 24,778 633 25411 10,114 136,984 147,008 Housing 14,075 14.075 Human services 25,284 25,284 Debt service Principal 16820 17452 148,s6 3,402 Interest and fiscal charges Captal outlay 1521 87,307 950 89,778 213,060 1,816 451 7.739 205,321 Total expenditures 420,134 1,160,044 236 273 Excess (deficiency) of revenues over (138,343) (under) expenditures 32,817 (4,744) (166416) Other firancing sources (uses) 27 545 (16,253) 30.536 (12,676) Transfers in 6,278 64.359 Transfers out (28,929) Proceeds from sae of capital assets Capital lease 24 318 342 25,050 25,060 Issuance of notes 19.147 19.147 79.969 Total other financing sources (uses) 11316 6278 62.375 Net change in fund balances 1.534 (104,041) (58374) 44,133 Fund balances, begining of year Fund balances, end of year 983 480 $ 191.031 11.088 781 361 235,164 12,622 677 320 925106
