Treasury Analysis

Document Sample
Treasury Analysis Powered By Docstoc
					[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
                                               Beginning of                      Number of                       Sales/       End of year    Earned
           Asset type/description                               Annual yield                    Additions
                                               year amount                      yield months                   expirations      amount       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
                                                                Beginning of                                  End of year
                    Asset type/description                                       Additions       Sales
                                                                year amount                                     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     Beginning of    End of year    End of year
                                                                                                              Variance %
                                                year — $         year — %           —$            —%
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%
          Beginning of Year Cash and Investments Mix




       700,000, 35%

                                           $1,200,000, 59%




125,000, 6%




              Cash     Short-term assets     Investments
             End of Year Cash and Investments Mix




               425,000, 18%
75,000, 3%


                                            $1,845,000, 79%




             Cash       Short-term assets          Investments

				
DOCUMENT INFO