短期投融资模型.xlsxVIP

现金预算表

事项 1月 2月 3月 4月 5月 6月 7月 8月 9月 10月 11月 12月

期初现金余额 100,000 95,000 90,000 85,000 80,000 75,000 70,000 65,000 60,000 55,000 50,000 45,000

本期收入 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000

本期支出 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000

期末现金余额 95,000 90,000 85,000 80,000 75,000 70,000 65,000 60,000 55,000 50,000 45,000 40,000

目标现金余额 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000

差额 (85,000) (90,