Long-term planning of municipal finance in a metropolitan region