The cost of social care for people living with dementia will nearly treble by 2040, a report by the Care Policy and Evaluation Centre (CPEC) has found.