Docstoc

Copy of final spreadsheet -- evening

Document Sample
Copy of final spreadsheet -- evening Powered By Docstoc
					                       Adrian Magopet




                               Actual Cash Flows
Cash inflows
Base salary per year           75000             Other cash inflow - %
Salary Increase                   4%             Other cash inflow
Salary per month                6500             beginning cash

Cash outflows
House price                  500000              car price
Down payment                  1500%              loan periods
mortgage periods                 180             loan rate
rates                             5%             down payment
mortgage payment           #REF!     per month   car payment per month

utilities   maximum         $180.00              minimum
phone       maximum            $60               minimum
credit cars                     300              credit card increase


            maximum
entertainment - minimum           450             minimum
Cash position for entertainment spending decision point
                        20%
                       1250
                      20000


                       18000
                          36
                        9.0%
                         15%
payment per month   #REF!

                     $30.00
                          25
                        -2%


                        250
                       7000
Adrian Magopet




                                    Mar           Apr         May         June          July
Cash - beginning                          20000
Cash inflows
           salary
           other
Actual total cash inflows



Cash outflows
           mortgage                  #REF!
           car loan                     492
           credit cards
           utilities                         32         120         104           131           176
           phone                             43          26          51            37            27
           entertainment                    394         361         317           408           443
           tuition                         1950                                                1950
           vacation                                                              2200
           petty cash                       200         200         200           200           200
Actual total cash outflows




Actual net cash flows - recurring
Cash flows - non-recurring
           down payment
           others                   -7500000              0           0             0             0
Total non-recurring                 -7500000              0           0             0             0
Actual Cash net flows per month
Actual Cash position - ending
Aug




            create a column chart here




       76
       48
      323


      200




        0
        0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:4/12/2012
language:English
pages:4