Treasury Analysis Worksheet
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Treasury Analysis Worksheet as PDF for free.
More details
- Words: 419
- Pages: 5
[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
Cash forecast targets Cash balance — beginning of period Cash flows from operations Cash flows from financing activities Cash flows from investment activities Net cash flow per period Cash balance — end of period
10.0% January $1,200,000 50,000 50,000 (100,000) 0 $1,200,000
February $1,200,000 60,000 50,000 0 110,000 $1,310,000
March $1,310,000 65,000 0 0 65,000 $1,375,000
April $1,375,000 55,000 0 0 55,000 $1,430,000
May $1,430,000 60,000 (200,000) 0 (140,000) $1,290,000
June $1,290,000 65,000 0 0 65,000 $1,355,000
July $1,355,000 50,000 0 0 50,000 $1,405,000
August $1,405,000 55,000 0 180,000 235,000 $1,640,000
September $1,640,000 60,000 0 0 60,000 $1,700,000
October $1,700,000 55,000 75,000 0 130,000 $1,830,000
November $1,830,000 65,000 0 (125,000) (60,000) $1,770,000
December $1,770,000 75,000 0 0 75,000 $1,845,000
Buffer cash Annual cash balance target
Liquidity analysis Forecasted cash balance at period end Other liquid assets Total liquid assets
$64,500 $709,500 January $1,200,000 0 $1,200,000
February $1,310,000 0 $1,310,000
March $1,375,000 50,000 $1,425,000
April $1,430,000 0 $1,430,000
May $1,290,000 0 $1,290,000
June $1,355,000 0 $1,355,000
July $1,405,000 75,000 $1,480,000
Other short-term assets Asset type/description Certificates of deposit Certificates of deposit Certificates of deposit Other short-term assets Total short-term assets
Beginning of year amount $50,000.00 75,000.00 0.00 0.00 $125,000.00
Annual yield 2.12500% 2.00000% 2.25000% 0.00000%
Number of yield months 3 6 6 0
Additions $0.00 0.00 75,000.00 0.00 $75,000.00
Sales/ expirations $50,000.00 75,000.00 0.00 0.00 $125,000.00
Investments summary Asset type/description Stocks Bonds Other investments Total investments
Beginning of year amount $500,000 200,000 0 $700,000
Additions $0 0 75,000 $75,000
Sales $250,000 100,000 0 $350,000
End of year amount $250,000 100,000 75,000 $425,000
Treasury analytics Cash Short-term assets Investments Total
Annual $1,200,000 715,000 (25,000) (45,000) 645,000 $1,845,000
Beginning of Beginning of End of year — End of year — Variance % year — $ year — % $ % $1,200,000 59.3% $1,845,000 78.7% 19.4% 125,000 6.2% 75,000 3.2% -3.0% 700,000 34.6% 425,000 18.1% -16.4% $2,025,000 100.0% $2,345,000 100.0%
End of year Earned income amount $0.00 $265.63 0.00 750.00 75,000.00 843.75 0.00 0.00 $1,859.38 $75,000.00
August $1,640,000 0 $1,640,000
September $1,700,000 0 $1,700,000
October $1,830,000 0 $1,830,000
November $1,770,000 0 $1,770,000
December $1,845,000 0 $1,845,000
Annual $1,845,000 0 $1,845,000
Beginning of Year Cash and Investments Mix
Cash
Short-term assets
Investments
Cash
Short-term assets
Investments
End of Year Cash and Investments Mix
Cash
Investments
Short-term assets
Cash
Short-term assets
Investments
Cash forecast targets Cash balance — beginning of period Cash flows from operations Cash flows from financing activities Cash flows from investment activities Net cash flow per period Cash balance — end of period
10.0% January $1,200,000 50,000 50,000 (100,000) 0 $1,200,000
February $1,200,000 60,000 50,000 0 110,000 $1,310,000
March $1,310,000 65,000 0 0 65,000 $1,375,000
April $1,375,000 55,000 0 0 55,000 $1,430,000
May $1,430,000 60,000 (200,000) 0 (140,000) $1,290,000
June $1,290,000 65,000 0 0 65,000 $1,355,000
July $1,355,000 50,000 0 0 50,000 $1,405,000
August $1,405,000 55,000 0 180,000 235,000 $1,640,000
September $1,640,000 60,000 0 0 60,000 $1,700,000
October $1,700,000 55,000 75,000 0 130,000 $1,830,000
November $1,830,000 65,000 0 (125,000) (60,000) $1,770,000
December $1,770,000 75,000 0 0 75,000 $1,845,000
Buffer cash Annual cash balance target
Liquidity analysis Forecasted cash balance at period end Other liquid assets Total liquid assets
$64,500 $709,500 January $1,200,000 0 $1,200,000
February $1,310,000 0 $1,310,000
March $1,375,000 50,000 $1,425,000
April $1,430,000 0 $1,430,000
May $1,290,000 0 $1,290,000
June $1,355,000 0 $1,355,000
July $1,405,000 75,000 $1,480,000
Other short-term assets Asset type/description Certificates of deposit Certificates of deposit Certificates of deposit Other short-term assets Total short-term assets
Beginning of year amount $50,000.00 75,000.00 0.00 0.00 $125,000.00
Annual yield 2.12500% 2.00000% 2.25000% 0.00000%
Number of yield months 3 6 6 0
Additions $0.00 0.00 75,000.00 0.00 $75,000.00
Sales/ expirations $50,000.00 75,000.00 0.00 0.00 $125,000.00
Investments summary Asset type/description Stocks Bonds Other investments Total investments
Beginning of year amount $500,000 200,000 0 $700,000
Additions $0 0 75,000 $75,000
Sales $250,000 100,000 0 $350,000
End of year amount $250,000 100,000 75,000 $425,000
Treasury analytics Cash Short-term assets Investments Total
Annual $1,200,000 715,000 (25,000) (45,000) 645,000 $1,845,000
Beginning of Beginning of End of year — End of year — Variance % year — $ year — % $ % $1,200,000 59.3% $1,845,000 78.7% 19.4% 125,000 6.2% 75,000 3.2% -3.0% 700,000 34.6% 425,000 18.1% -16.4% $2,025,000 100.0% $2,345,000 100.0%
End of year Earned income amount $0.00 $265.63 0.00 750.00 75,000.00 843.75 0.00 0.00 $1,859.38 $75,000.00
August $1,640,000 0 $1,640,000
September $1,700,000 0 $1,700,000
October $1,830,000 0 $1,830,000
November $1,770,000 0 $1,770,000
December $1,845,000 0 $1,845,000
Annual $1,845,000 0 $1,845,000
Beginning of Year Cash and Investments Mix
Cash
Short-term assets
Investments
Cash
Short-term assets
Investments
End of Year Cash and Investments Mix
Cash
Investments
Short-term assets
Cash
Short-term assets
Investments
Related Documents
Treasury Analysis Worksheet
December 2019 17
Treasury
June 2020 19
Donor Analysis Worksheet
December 2019 35
Dimensional Analysis Worksheet 1
June 2020 21
Loan Analysis Worksheet
December 2019 14
Cartoon Analysis Worksheet
November 2019 13More Documents from "Peter Noirot"
Very Good Presentation
December 2019 17
To Do List
December 2019 15
Swing Trading Calculator
October 2019 20
Cover Letters From Mit
October 2019 16
Cover Letter 5
October 2019 22