A new report has laid bare the financial challenges facing Scotland's college sector.