sql-server find database file size on disk

SELECT 
	DB_NAME(DATABASE_ID) AS DATABASENAME,
       NAME AS LOGICAL_NAME,
       PHYSICAL_NAME,
       FORMAT((SIZE * 8) / 1024 , 'N0') SIZE_MB
FROM SYS.MASTER_FILES
ORDER BY SIZE DESC