Penrith City Council (NSW) was formed in 1871. Penrith is a city on the western fringe of the Sydney metropolitan area, in east central New South…

Penrith City Council (NSW) was formed in 1871. Penrith is a city on the western fringe of the Sydney metropolitan area, in east central New South Wales, Australia. Penrith is approximately 54 kilometres by road west of Sydney. The local government boundaries of the City of Penrith cover an area of some 407 square kilometres on the Nepean River flats of the Cumberland Plain.

The council defines its vision to promote the city as “a sustainable and prosperous region with a harmony of urban and rural qualities with a strong commitment to environmental protection and enhancement. It would offer both the cosmopolitan and cultural lifestyles of a mature city and the casual character of a rural community.”

Council’s current financial statements are provided for your further information and analysis. Use MS Excel to complete the following tasks.

From the given financial statements, analyse; Free Cash Flow (FCF) in the current financial year. Operating cash flow trends over the last five years. Investing cash flow trends over the last five years. Total Income trends from Continuing Operations. Net operating profit trends.