The statement of change in net debt is unique to public sector financial reporting. Assume that...

Free

90.2K

Verified Solution

Question

Finance

The statement of change in net debt is unique to public sectorfinancial reporting. Assume that you are a financial accountantwith the Municipality of Walton. Prepare the 20X5/X6statement of change in net debt using the informationbelow. (Note: prepare only the current-year column, notthe comparative numbers.)

MUNICIPALITY OF WALTON
Consolidated statement of financial position
March 31, 20X6, with comparative figures for 20X5
(in $000s)

20X6

20X5

Financial assets

Cash

95,263

87,412

Accounts receivable

24,812

18,776

Taxes receivable

62,477

78,943

Investments

  59,110

  46,545

241,662

231,676

Liabilities

Accounts payable

90,993

97,863

Deferred revenue

11,735

9,745

Employee future benefits

127,571

131,552

Long-term debt

364,747

381,001

595,046

620,161

Net debt

(353,384)

(388,485)

Non-financial assets

Tangible capital assets

356,442

364,710

Inventory

21,233

25,641

Prepaid expenses

    9,542

  10,301

387,217

400,652

Accumulated surplus (deficit)

$ 33,833

$ 12,167

MUNICIPALITY OF WALTON
Consolidated statement of operations
For the year ended March 31, 20X6, with comparative figures for20X5
(in $000s)

20X6

20X5

Revenue

Taxation

512,098

487,752

User fees and charges

104,752

96,321

Government grants

37,059

45,278

Investment income

2,474

6,120

Penalties and fines

  24,714

  20,144

681,097

655,615

Expenses

Protective services

189,216

182,111

Transportation services

208,511

200,463

Environmental services

61,203

54,125

Recreation and cultural services

76,610

65,875

Educational services

90,220

93,633

Urban development services

  33,671

  26,987

659,431

623,194

Annual surplus (deficit)

21,666

  32,421


Additional information:

  • The annual surplus includes $14,718 in amortizationexpense.
  • Tangible capital assets were purchased for $6,450.
  • There were no TCA disposals in the year.

Answer & Explanation Solved by verified expert
4.3 Ratings (843 Votes)

Solution:

Statement of change in net debt

as at March 31, 2016

Particulars March 31, 2016
Annual surplus (deficit) $             21,666
Tangible Capital Assets
Acquisition of asset $              -6,450
Amortization $             14,718
$                8,268
Consumption of Inventory $            4,408.0
$ (25,641 - 21,233)
Prepaid expenses used $                   759
$ (10,301 - 9,542)
$            5,167.0
Change in Net Debt $          35,101.0
Net Debt at the beginning of the year $ -3,88,485.00
Net Debt at the end of the year $ -3,53,384.00
$ (-3,88,485 + 35,101)

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The statement of change in net debt is unique to public sectorfinancial reporting. Assume that you are a financial accountantwith the Municipality of Walton. Prepare the 20X5/X6statement of change in net debt using the informationbelow. (Note: prepare only the current-year column, notthe comparative numbers.)MUNICIPALITY OF WALTONConsolidated statement of financial positionMarch 31, 20X6, with comparative figures for 20X5(in $000s)20X620X5Financial assetsCash95,26387,412Accounts receivable24,81218,776Taxes receivable62,47778,943Investments  59,110  46,545241,662231,676LiabilitiesAccounts payable90,99397,863Deferred revenue11,7359,745Employee future benefits127,571131,552Long-term debt364,747381,001595,046620,161Net debt(353,384)(388,485)Non-financial assetsTangible capital assets356,442364,710Inventory21,23325,641Prepaid expenses    9,542  10,301387,217400,652Accumulated surplus (deficit)$ 33,833$ 12,167MUNICIPALITY OF WALTONConsolidated statement of operationsFor the year ended March 31, 20X6, with comparative figures for20X5(in $000s)20X620X5RevenueTaxation512,098487,752User fees and charges104,75296,321Government grants37,05945,278Investment income2,4746,120Penalties and fines  24,714  20,144681,097655,615ExpensesProtective services189,216182,111Transportation services208,511200,463Environmental services61,20354,125Recreation and cultural services76,61065,875Educational services90,22093,633Urban development services  33,671  26,987659,431623,194Annual surplus (deficit)21,666  32,421Additional information:The annual surplus includes $14,718 in amortizationexpense.Tangible capital assets were purchased for $6,450.There were no TCA disposals in the year.

Other questions asked by students