[Company Name]
	Treasury Analysis Worksheet
	[Date]
	Model key
	Bold numbers in white cells are entered by user.
	Italicized numbers in gray cells are calculations that should not be altered.
	Annual cash buffer percentage	10.0%
	Cash forecast targets	January	February	March	April	May	June	July	August	September	October	November	December	Annual
	Cash balance — beginning of period	$1,200,000	$1,200,000	$1,310,000	$1,375,000	$1,430,000	$1,290,000	$1,355,000	$1,405,000	$1,640,000	$1,700,000	$1,830,000	$1,770,000	$1,200,000
	Cash flows from operations	50,000	60,000	65,000	55,000	60,000	65,000	50,000	55,000	60,000	55,000	65,000	75,000	715,000
	Cash flows from financing activities	50,000	50,000	0	0	(200,000)	0	0	0	0	75,000	0	0	(25,000)
	Cash flows from investment activities	(100,000)	0	0	0	0	0	0	180,000	0	0	(125,000)	0	(45,000)
	Net cash flow per period	0	110,000	65,000	55,000	(140,000)	65,000	50,000	235,000	60,000	130,000	(60,000)	75,000	645,000
	Cash balance — end of period	$1,200,000	$1,310,000	$1,375,000	$1,430,000	$1,290,000	$1,355,000	$1,405,000	$1,640,000	$1,700,000	$1,830,000	$1,770,000	$1,845,000	$1,845,000
	Buffer cash													$64,500
	Annual cash balance target													$709,500
	Liquidity analysis	January	February	March	April	May	June	July	August	September	October	November	December	Annual
	Forecasted cash balance at period end	$1,200,000	$1,310,000	$1,375,000	$1,430,000	$1,290,000	$1,355,000	$1,405,000	$1,640,000	$1,700,000	$1,830,000	$1,770,000	$1,845,000	$1,845,000
	Other liquid assets	0	0	50,000	0	0	0	75,000	0	0	0	0	0	0
	Total liquid assets	$1,200,000	$1,310,000	$1,425,000	$1,430,000	$1,290,000	$1,355,000	$1,480,000	$1,640,000	$1,700,000	$1,830,000	$1,770,000	$1,845,000	$1,845,000
	Other short-term assets
	Asset type/description	Beginning of year amount	Annual yield	Number of yield months	Additions	Sales/ expirations	End of year amount	Earned income
	Certificates of deposit	$50,000.00	2.12500%	3	$0.00	$50,000.00	$0.00	$265.63
	Certificates of deposit	75,000.00	2.00000%	6	0.00	75,000.00	0.00	750.00
	Certificates of deposit	0.00	2.25000%	6	75,000.00	0.00	75,000.00	843.75
	Other short-term assets	0.00	0.00000%	0	0.00	0.00	0.00	0.00
	Total short-term assets	$125,000.00			$75,000.00	$125,000.00	$75,000.00	$1,859.38
	Investments summary
	Asset type/description		Beginning of year amount	Additions	Sales	End of year amount
	Stocks		$500,000	$0	$250,000	$250,000
	Bonds		200,000	0	100,000	100,000
	Other investments		0	75,000	0	75,000
	Total investments		$700,000	$75,000	$350,000	$425,000
	Treasury analytics
		Beginning of year — $	Beginning of year — %	End of year — $	End of year — %	Variance %
	Cash	$1,200,000	59.3%	$1,845,000	78.7%	19.4%
	Short-term assets	125,000	6.2%	75,000	3.2%	-3.0%
	Investments	700,000	34.6%	425,000	18.1%	-16.4%
	Total	$2,025,000	100.0%	$2,345,000	100.0%