Projected Vs. Actual Cost

Document Sample
Projected Vs. Actual Cost Powered By Docstoc
					                                                                             12-Month Cash Flow Statement
                                                                              Start-up and Year 1 - Projected

                                                     Month     Month     Month     Month      Month      Month      Month     Month     Month     Month     Month     Month              % of
                                      Start-Up            1         2         3         4          5          6          7         8         9        10        11        12    TOTAL    total
1. CASH ON HAND (Beg. Of Month)                            -         -         -         -          -          -          -         -         -         -         -         -
2. CASH RECEIPTS
   Cash Sales -                                                                                                                                                                     -   #DIV/0!
   Cash Sales -                                                                                                                                                                     -   #DIV/0!
   Cost of Goods Sold                                                                                                                                                               -   #DIV/0!
   Loan or Other Cash Injection                                                                                                                                                     -   #DIV/0!
3. TOTAL CASH RECEIPTS                           -         -         -         -         -          -           -         -         -         -         -         -         -       -
4. TOTAL CASH AVAILABLE                          -         -         -         -         -          -           -         -         -         -         -         -         -       -
5. CASH PAID OUT
   Wages / Payroll Exp                                                                                                                                                              -   #DIV/0!
   Independent Contractors Exp                                                                                                                                                      -   #DIV/0!
   Office Supplies                                                                                                                                                                  -   #DIV/0!
   Accounting / Legal                                                                                                                                                               -   #DIV/0!
   Advertising / Marketing                                                                                                                                                          -   #DIV/0!
   Auto Expense & Repair                                                                                                                                                            -   #DIV/0!
   Travel / Fuel                                                                                                                                                                    -   #DIV/0!
   Rent                                                                                                                                                                             -   #DIV/0!
   Cellphone                                                                                                                                                                        -   #DIV/0!
   Internet                                                                                                                                                                         -   #DIV/0!
   Utilities
     Electricity                                                                                                                                                                    - #DIV/0!
     Telephone                                                                                                                                                                      - #DIV/0!
     Other                                                                                                                                                                          - #DIV/0!
  Insurance
      Liability / Theft / Fire                                                                                                                                                      -   #DIV/0!
      Auto / E&O                                                                                                                                                                    -   #DIV/0!
      Medical / Life                                                                                                                                                                -   #DIV/0!
   Fees & Licenses                                                                                                                                                                  -   #DIV/0!
   Taxes - Income                                                                                                                                                                   -   #DIV/0!
   Materials / Supplies / Inventory                                                                                                                                                 -   #DIV/0!
   Professional Devel. & Mtgs.                                                                                                                                                      -   #DIV/0!
   Miscellaneous                                                                                                                                                                    -   #DIV/0!
   Subtotal Fixed Costs                          -         -         -         -         -          -           -         -         -         -         -         -         -       -   #DIV/0!
   Loan Repayment                                                                                                                                                                   -   #DIV/0!
   Capital Purchases / Equipment                                                                                                                                                    -   #DIV/0!
   Owner's Withdrawal                                                                                                                                                               -   #DIV/0!
6. TOTAL CASH PAID OUT                           -         -         -         -         -          -           -         -         -         -         -         -         -       -
7. CASH BALANCE                                  -         -         -         -         -          -           -         -         -         -         -         -         -       -
                                                                                                                                                                                    -




   c2a0b31d-a236-4218-916b-66212c3df446.xls                                                  7/20/2011                                                                              1 of 11
                                                                             12-Month Cash Flow Statement
                                                                               Start-up and Year 1 - Actual

                                                     Month     Month     Month     Month     Month     Month      Month     Month     Month     Month     Month     Month              % of
                                      Start-Up            1         2         3         4         5         6          7         8         9        10        11        12    TOTAL    total
1. CASH ON HAND (Beg. Of Month)                            -         -         -         -         -         -          -         -         -         -         -         -
2. CASH RECEIPTS
   Cash Sales -                                                                                                                                                                   -   #DIV/0!
   Cash Sales -                                                                                                                                                                   -   #DIV/0!
   Cost of Goods Sold                                                                                                                                                             -   #DIV/0!
   Loan or Other Cash Injection                                                                                                                                                   -   #DIV/0!
3. TOTAL CASH RECEIPTS                           -         -         -         -         -         -          -         -         -         -         -         -         -       -
4. TOTAL CASH AVAILABLE                          -         -         -         -         -         -          -         -         -         -         -         -         -       -
5. CASH PAID OUT
   Wages / Payroll Exp                                                                                                                                                            -   #DIV/0!
   Independent Contractors Exp                                                                                                                                                    -   #DIV/0!
   Office Supplies                                                                                                                                                                -   #DIV/0!
   Accounting / Legal                                                                                                                                                             -   #DIV/0!
   Advertising / Marketing                                                                                                                                                        -   #DIV/0!
   Auto Expense & Repair                                                                                                                                                          -   #DIV/0!
   Travel / Fuel                                                                                                                                                                  -   #DIV/0!
   Rent                                                                                                                                                                           -   #DIV/0!
   Cellphone                                                                                                                                                                      -   #DIV/0!
   Internet                                                                                                                                                                       -   #DIV/0!
   Utilities
      Electricity                                                                                                                                                                 - #DIV/0!
      Telephone                                                                                                                                                                   - #DIV/0!
      Other                                                                                                                                                                       - #DIV/0!
   Insurance
      Liability / Theft / Fire                                                                                                                                                    -   #DIV/0!
      Auto / E&O                                                                                                                                                                  -   #DIV/0!
      Medical / Life                                                                                                                                                              -   #DIV/0!
   Fees & Licenses                                                                                                                                                                -   #DIV/0!
   Taxes - Income                                                                                                                                                                 -   #DIV/0!
   Materials / Supplies / Inventory                                                                                                                                               -   #DIV/0!
   Professional Devel. & Mtgs.                                                                                                                                                    -   #DIV/0!
   Miscellaneous                                                                                                                                                                  -   #DIV/0!
   Subtotal Fixed Costs                          -         -         -         -         -         -          -         -         -         -         -         -         -       -   #DIV/0!
   Loan Repayment                                                                                                                                                                 -   #DIV/0!
   Capital Purchases / Equipment                                                                                                                                                  -   #DIV/0!
   Owner's Withdrawal                                                                                                                                                             -   #DIV/0!
6. TOTAL CASH PAID OUT                           -         -         -         -         -         -          -         -         -         -         -         -         -       -
7. CASH BALANCE                                  -         -         -         -         -         -          -         -         -         -         -         -         -       -
                                                                                                                                                                                  -
                        Cash Flow Comparison
                  Start-up and 1st Quarter Projected                                                                Start-up and 1st Quarter Actual

                                                Month       Month       Month       1st Qtr                      Month       Month       Month        1st Qtr        % of      Projected
                                Start-Up                1           2           3   Totals        Start-Up               1           2           3    Totals         total    vs. Actual
1. CASH ON HAND (Beg. Of Month)                         -           -           -                                        -           -           -
2. CASH RECEIPTS
   Cash Sales -                            -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Cash Sales -                            -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Cost of Goods Sold                      -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Loan or Other Cash Injection            -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
3. TOTAL CASH RECEIPTS                     -            -           -           -             -              -           -           -           -              -                     $0
4. TOTAL CASH AVAILABLE                    -            -           -           -             -              -           -           -           -              -                     $0
5. CASH PAID OUT
   Wages / Payroll Exp                     -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Independent Contractors Exp             -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Office Supplies                         -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Accounting / Legal                      -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Advertising / Marketing                 -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Auto Expense & Repair                   -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Travel / Fuel                           -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Rent                                    -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Cellphone                               -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Internet                                -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Utilities
      Electricity                          -            -           -           -             -              -           -           -           -              - #DIV/0!             $0
      Telephone                            -            -           -           -             -              -           -           -           -              - #DIV/0!             $0
      Other                                -            -           -           -             -              -           -           -           -              - #DIV/0!             $0
   Insurance
      Liability / Theft / Fire             -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
      Auto / E&O                           -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
      Medical / Life                       -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Fees & Licenses                         -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Taxes - Income                          -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Materials / Supplies / Inventory        -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Professional Devel. & Mtgs.             -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Miscellaneous                           -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Subtotal Fixed Costs                    -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Loan Repayment                          -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Capital Purchases / Equipment           -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
   Owner's Withdrawal                      -            -           -           -             -              -           -           -           -              -   #DIV/0!           $0
6. TOTAL CASH PAID OUT                     -            -           -           -             -              -           -           -           -              -                     $0
7. CASH BALANCE                            -            -           -           -             -              -           -           -           -              -                     $0
                       Cash Flow Comparison
                       2nd Quarter Projected                                                             2nd Quarter Actual

                                      Month       Month       Month       2nd Qtr       Month        Month        Month        2nd Qtr        % of      Projected
                                              4           5           6    Totals                4            5            6    Totals        total    vs. Actual
1. CASH ON HAND (Beg. Of Month)               -           -           -                         -            -            -
2. CASH RECEIPTS
   Cash Sales -                               -           -           -             -           -            -            -              -   #DIV/0!           $0
   Cash Sales -                               -           -           -             -           -            -            -              -   #DIV/0!           $0
   Cost of Goods Sold                         -           -           -             -           -            -            -              -   #DIV/0!           $0
   Loan or Other Cash Injection               -           -           -             -           -            -            -              -   #DIV/0!           $0
3. TOTAL CASH RECEIPTS                        -           -           -             -           -            -            -              -                     $0
4. TOTAL CASH AVAILABLE                       -           -           -             -           -            -            -              -                     $0
5. CASH PAID OUT                              -           -           -
   Wages / Payroll Exp                        -           -           -             -           -            -            -              -   #DIV/0!           $0
   Independent Contractors Exp                -           -           -             -           -            -            -              -   #DIV/0!           $0
   Office Supplies                            -           -           -             -           -            -            -              -   #DIV/0!           $0
   Accounting / Legal                         -           -           -             -           -            -            -              -   #DIV/0!           $0
   Advertising / Marketing                    -           -           -             -           -            -            -              -   #DIV/0!           $0
   Auto Expense & Repair                      -           -           -             -           -            -            -              -   #DIV/0!           $0
   Travel / Fuel                              -           -           -             -           -            -            -              -   #DIV/0!           $0
   Rent                                       -           -           -             -           -            -            -              -   #DIV/0!           $0
   Cellphone                                  -           -           -             -           -            -            -              -   #DIV/0!           $0
   Internet                                   -           -           -             -           -            -            -              -   #DIV/0!           $0
   Utilities                                  -           -           -
      Electricity                             -           -           -             -           -            -            -              - #DIV/0!             $0
      Telephone                               -           -           -             -           -            -            -              - #DIV/0!             $0
      Other                                   -           -           -             -           -            -            -              - #DIV/0!             $0
   Insurance                                  -           -           -
      Liability / Theft / Fire                -           -           -             -           -            -            -              -   #DIV/0!           $0
      Auto / E&O                              -           -           -             -           -            -            -              -   #DIV/0!           $0
      Medical / Life                          -           -           -             -           -            -            -              -   #DIV/0!           $0
   Fees & Licenses                            -           -           -             -           -            -            -              -   #DIV/0!           $0
   Taxes - Income                             -           -           -             -           -            -            -              -   #DIV/0!           $0
   Materials / Supplies / Inventory           -           -           -             -           -            -            -              -   #DIV/0!           $0
   Professional Devel. & Mtgs.                -           -           -             -           -            -            -              -   #DIV/0!           $0
   Miscellaneous                              -           -           -             -           -            -            -              -   #DIV/0!           $0
   Subtotal Fixed Costs                       -           -           -             -           -            -            -              -   #DIV/0!           $0
   Loan Repayment                             -           -           -             -           -            -            -              -   #DIV/0!           $0
   Capital Purchases / Equipment              -           -           -             -           -            -            -              -   #DIV/0!           $0
   Owner's Withdrawal                         -           -           -             -           -            -            -              -   #DIV/0!           $0
6. TOTAL CASH PAID OUT                        -           -           -             -           -            -            -              -                     $0
7. CASH BALANCE                               -           -           -             -           -            -            -              -                     $0
                       Cash Flow Comparison
                        3rd Quarter Projected                                                            3rd Quarter Actual

                                      Month       Month       Month       3rd Qtr       Month        Month        Month        3rd Qtr        % of      Projected
                                              7           8           9    Totals                7            8            9    Totals        total    vs. Actual
1. CASH ON HAND (Beg. Of Month)               -           -           -                         -            -            -
2. CASH RECEIPTS
   Cash Sales -                               -           -           -             -           -            -            -              -   #DIV/0!           $0
   Cash Sales -                               -           -           -             -           -            -            -              -   #DIV/0!           $0
   Cost of Goods Sold                         -           -           -             -           -            -            -              -   #DIV/0!           $0
   Loan or Other Cash Injection               -           -           -             -           -            -            -              -   #DIV/0!           $0
3. TOTAL CASH RECEIPTS                        -           -           -             -           -            -            -              -                     $0
4. TOTAL CASH AVAILABLE                       -           -           -             -           -            -            -              -                     $0
5. CASH PAID OUT
   Wages / Payroll Exp                        -           -           -             -           -            -            -              -   #DIV/0!           $0
   Independent Contractors Exp                -           -           -             -           -            -            -              -   #DIV/0!           $0
   Office Supplies                            -           -           -             -           -            -            -              -   #DIV/0!           $0
   Accounting / Legal                         -           -           -             -           -            -            -              -   #DIV/0!           $0
   Advertising / Marketing                    -           -           -             -           -            -            -              -   #DIV/0!           $0
   Auto Expense & Repair                      -           -           -             -           -            -            -              -   #DIV/0!           $0
   Travel / Fuel                              -           -           -             -           -            -            -              -   #DIV/0!           $0
   Rent                                       -           -           -             -           -            -            -              -   #DIV/0!           $0
   Cellphone                                  -           -           -             -           -            -            -              -   #DIV/0!           $0
   Internet                                   -           -           -             -           -            -            -              -   #DIV/0!           $0
   Utilities
      Electricity                             -           -           -             -           -            -            -              - #DIV/0!             $0
      Telephone                               -           -           -             -           -            -            -              - #DIV/0!             $0
      Other                                   -           -           -             -           -            -            -              - #DIV/0!             $0
   Insurance
      Liability / Theft / Fire                -           -           -             -           -            -            -              -   #DIV/0!           $0
      Auto / E&O                              -           -           -             -           -            -            -              -   #DIV/0!           $0
      Medical / Life                          -           -           -             -           -            -            -              -   #DIV/0!           $0
   Fees & Licenses                            -           -           -             -           -            -            -              -   #DIV/0!           $0
   Taxes - Income                             -           -           -             -           -            -            -              -   #DIV/0!           $0
   Materials / Supplies / Inventory           -           -           -             -           -            -            -              -   #DIV/0!           $0
   Professional Devel. & Mtgs.                -           -           -             -           -            -            -              -   #DIV/0!           $0
   Miscellaneous                              -           -           -             -           -            -            -              -   #DIV/0!           $0
   Subtotal Fixed Costs                       -           -           -             -           -            -            -              -   #DIV/0!           $0
   Loan Repayment                             -           -           -             -           -            -            -              -   #DIV/0!           $0
   Capital Purchases / Equipment              -           -           -             -           -            -            -              -   #DIV/0!           $0
   Owner's Withdrawal                         -           -           -             -           -            -            -              -   #DIV/0!           $0
6. TOTAL CASH PAID OUT                        -           -           -             -           -            -            -              -                     $0
7. CASH BALANCE                               -           -           -             -           -            -            -              -                     $0
                       Cash Flow Comparison
                        4th Quarter Projected                                                      4th Quarter Actual

                                Month           Month     Month     4th Qtr       Month        Month        Month        4th Qtr        % of      Projected
                                    10               11       12    Totals                10           11           12   Totals         total    vs. Actual
1. CASH ON HAND (Beg. Of Month)       -               -         -                          -            -            -
2. CASH RECEIPTS
   Cash Sales -                       -               -         -             -           -            -            -              -   #DIV/0!           $0
   Cash Sales -                       -               -         -             -           -            -            -              -   #DIV/0!           $0
   Cost of Goods Sold                 -               -         -             -           -            -            -              -   #DIV/0!           $0
   Loan or Other Cash Injection       -               -         -             -           -            -            -              -   #DIV/0!           $0
3. TOTAL CASH RECEIPTS                -               -         -             -           -            -            -              -                     $0
4. TOTAL CASH AVAILABLE                   -           -         -             -           -            -            -              -                     $0
5. CASH PAID OUT
   Wages / Payroll Exp                    -           -         -             -           -            -            -              -   #DIV/0!           $0
   Independent Contractors Exp            -           -         -             -           -            -            -              -   #DIV/0!           $0
   Office Supplies                        -           -         -             -           -            -            -              -   #DIV/0!           $0
   Accounting / Legal                     -           -         -             -           -            -            -              -   #DIV/0!           $0
   Advertising / Marketing                -           -         -             -           -            -            -              -   #DIV/0!           $0
   Auto Expense & Repair                  -           -         -             -           -            -            -              -   #DIV/0!           $0
   Travel / Fuel                          -           -         -             -           -            -            -              -   #DIV/0!           $0
   Rent                                   -           -         -             -           -            -            -              -   #DIV/0!           $0
   Cellphone                              -           -         -             -           -            -            -              -   #DIV/0!           $0
   Internet                               -           -         -             -           -            -            -              -   #DIV/0!           $0
   Utilities
      Electricity                         -           -         -             -           -            -            -              - #DIV/0!             $0
      Telephone                           -           -         -             -           -            -            -              - #DIV/0!             $0
      Other                               -           -         -             -           -            -            -              - #DIV/0!             $0
   Insurance
      Liability / Theft / Fire            -           -         -             -           -            -            -              -   #DIV/0!           $0
      Auto / E&O                          -           -         -             -           -            -            -              -   #DIV/0!           $0
      Medical / Life                      -           -         -             -           -            -            -              -   #DIV/0!           $0
   Fees & Licenses                        -           -         -             -           -            -            -              -   #DIV/0!           $0
   Taxes - Income                         -           -         -             -           -            -            -              -   #DIV/0!           $0
   Materials / Supplies / Inventory       -           -         -             -           -            -            -              -   #DIV/0!           $0
   Professional Devel. & Mtgs.            -           -         -             -           -            -            -              -   #DIV/0!           $0
   Miscellaneous                          -           -         -             -           -            -            -              -   #DIV/0!           $0
   Subtotal Fixed Costs                   -           -         -             -           -            -            -              -   #DIV/0!           $0
   Loan Repayment                         -           -         -             -           -            -            -              -   #DIV/0!           $0
   Capital Purchases / Equipment          -           -         -             -           -            -            -              -   #DIV/0!           $0
   Owner's Withdrawal                     -           -         -             -           -            -            -              -   #DIV/0!           $0
6. TOTAL CASH PAID OUT                    -           -         -             -           -            -            -              -                     $0
7. CASH BALANCE                           -           -         -             -           -            -            -              -                     $0
Summary Comparisons
                                Projected     Actual Difference     Proj.         Act.            Diff.       Proj.     Act.       Diff.                 Act.           Diff.      Proj.          Act.           Diff.
                                 Cost of     Cost of  Projected    1st Qtr       1st Qtr       Projected    2nd Qtr   2nd Qtr   Projected    3rd Qtr   3rd Qtr       Projected    4th Qtr       4th Qtr       Projected
                                Start-Up     Start-Up vs. Actual   Totals        Totals        vs. Actual    Totals    Totals   vs. Actual    Totals    Totals       vs. Actual   Totals        Totals        vs. Actual
1. CASH ON HAND (Beg. Of Month)
2. CASH RECEIPTS
   Cash Sales -                          -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Cash Sales -                          -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Cost of Goods Sold                    -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Loan or Other Cash Injection          -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
3. TOTAL CASH RECEIPTS                   -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
4. TOTAL CASH AVAILABLE                  -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
5. CASH PAID OUT
   Wages / Payroll Exp                   -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Independent Contractors Exp           -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Office Supplies                       -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Accounting / Legal                    -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Advertising / Marketing               -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Auto Expense & Repair                 -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Travel / Fuel                         -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Rent                                  -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Cellphone                             -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Internet                              -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Utilities
      Electricity                        -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
      Telephone                          -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
      Other                              -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Insurance
      Liability / Theft / Fire           -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
      Auto / E&O                         -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
      Medical / Life                     -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Fees & Licenses                       -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Taxes - Income                        -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Materials / Supplies / Inventory      -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Professional Devel. & Mtgs.           -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Miscellaneous                         -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Subtotal Fixed Costs                  -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Loan Repayment                        -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Capital Purchases / Equipment         -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
   Owner's Withdrawal                    -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
6. TOTAL CASH PAID OUT                   -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
7. CASH BALANCE                          -          -        $0              -             -          $0          -         -          $0          -             -          $0              -             -          $0
                                                       PAYMENTS
                                                                                YEAR 1
LOAN AMORTIZATION SCHEDULE                             INTEREST                 3,928.47
                                                       PRINCIPLE                8,381.45
                                                       TOTAL                   12,309.92
LOAN AMOUNT       50,000.00                            TO DATE INT              3,928.47
ANNUAL INTEREST RATE8.50%                              TO DATE PRIN             8,381.45
TERM OF LOAN           5.00
MONTHLY PAYMENT  ($1,025.83)


                         1             2           3           4           5           6
BALANCE DUE      50,000.00     49,328.34   48,651.92   47,970.71   47,284.68   46,593.79
INTEREST PAYMENT    354.17        349.41      344.62      339.79      334.93      330.04
PRINCIPLE PAYMENT 671.66          676.42      681.21      686.03      690.89      695.79
TOTAL PAYMENT     1,025.83      1,025.83    1,025.83    1,025.83    1,025.83    1,025.83

                        13            14          15          16          17          18
BALANCE DUE      41,618.55     40,887.52   40,151.31   39,409.89   38,663.22   37,911.25
INTEREST PAYMENT    294.80        289.62      284.41      279.15      273.86      268.54
PRINCIPLE PAYMENT 731.03          736.21      741.42      746.67      751.96      757.29
TOTAL PAYMENT    $1,025.83     $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

                        25            26          27          28          29          30
BALANCE DUE      32,496.25     31,700.60   30,899.32   30,092.37   29,279.70   28,461.27
INTEREST PAYMENT    230.18        224.55      218.87      213.15      207.40      201.60
PRINCIPLE PAYMENT 795.64          801.28      806.96      812.67      818.43      824.23
TOTAL PAYMENT    $1,025.83     $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

                        37            38          39          40          41          42
BALANCE DUE      22,567.62     21,701.65   20,829.54   19,951.26   19,066.76   18,175.99
INTEREST PAYMENT    159.85        153.72      147.54      141.32      135.06      128.75
PRINCIPLE PAYMENT 865.97          872.11      878.28      884.51      890.77      897.08
TOTAL PAYMENT    $1,025.83     $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

                        49            50          51          52          53          54
BALANCE DUE      11,761.40     10,818.88    9,869.69    8,913.77    7,951.08    6,981.58
INTEREST PAYMENT     83.31         76.63       69.91       63.14       56.32       49.45
PRINCIPLE PAYMENT 942.52          949.19      955.92      962.69      969.51      976.37
TOTAL PAYMENT    $1,025.83     $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

                        61            62         63         64         65         66
BALANCE DUE           0.00     (1,025.83) (2,058.92) (3,099.33) (4,147.11) (5,202.31)
INTEREST PAYMENT      0.00         (7.27)    (14.58)    (21.95)    (29.38)    (36.85)
PRINCIPLE PAYMENT 1,025.83      1,033.09   1,040.41   1,047.78   1,055.20   1,062.68
TOTAL PAYMENT    $1,025.83     $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                        73        74        75        76        77        78
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT    (90.67)   (98.58)  (106.55)  (114.57)  (122.65)  (130.78)
PRINCIPLE PAYMENT 1,116.50  1,124.41  1,132.37  1,140.39  1,148.47  1,156.61
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83
                        85        86        87        88        89        90
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (189.36)    (197.97)  (206.64)  (215.37)  (224.16)  (233.01)
PRINCIPLE PAYMENT 1,215.19  1,223.80  1,232.46  1,241.19  1,249.99  1,258.84
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                        97        98        99       100       101       102
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (296.77)    (306.14)  (315.58)  (325.08)  (334.65)  (344.28)
PRINCIPLE PAYMENT 1,322.60  1,331.97  1,341.40  1,350.91  1,360.47  1,370.11
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                       109       110       111       112       113       114
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (413.68)    (423.88)  (434.14)  (444.49)  (454.90)  (465.39)
PRINCIPLE PAYMENT 1,439.51  1,449.70  1,459.97  1,470.31  1,480.73  1,491.22
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                       121       122       123       124       125       126
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (540.92)    (552.02)  (563.19)  (574.45)  (585.78)  (597.20)
PRINCIPLE PAYMENT 1,566.75  1,577.84  1,589.02  1,600.28  1,611.61  1,623.03
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                       133       134       135       136       137       138
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (679.41)    (691.48)  (703.65)  (715.90)  (728.24)  (740.66)
PRINCIPLE PAYMENT 1,705.23  1,717.31  1,729.47  1,741.73  1,754.06  1,766.49
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                       145       146       147       148       149       150
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (830.13)    (843.28)  (856.52)  (869.85)  (883.28)  (896.80)
PRINCIPLE PAYMENT 1,855.96  1,869.10  1,882.34  1,895.68  1,909.11  1,922.63
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                       157       158       159        160        161        162
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (994.18) (1,008.49) (1,022.90) (1,037.41) (1,052.03) (1,066.74)
PRINCIPLE PAYMENT 2,020.01  2,034.32  2,048.73   2,063.24   2,077.85   2,092.57
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

                       169        170        171        172        173        174
BALANCE DUE       ######## ######## ######## ######## ######## ########
INTEREST PAYMENT (1,172.73) (1,188.31) (1,203.99) (1,219.78) (1,235.69) (1,251.71)
PRINCIPLE PAYMENT 2,198.56   2,214.13   2,229.82   2,245.61   2,261.52   2,277.54
TOTAL PAYMENT    $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83
 YEAR 2      YEAR 3      YEAR 4      YEAR 5
 3,187.62    2,381.29    1,503.69      548.52
 9,122.30    9,928.63   10,806.23   11,761.40
12,309.92   12,309.92   12,309.92   12,309.92
 7,116.09    9,497.38   11,001.07   11,549.59
17,503.75   27,432.38   38,238.60   50,000.00




        7           8           9          10          11          12
45,898.00   45,197.28   44,491.60   43,780.93   43,065.21   42,344.43
   325.11      320.15      315.15      310.11      305.05      299.94
   700.72      705.68      710.68      715.71      720.78      725.89
 1,025.83    1,025.83    1,025.83    1,025.83    1,025.83    1,025.83

       19          20          21          22          23          24
37,153.97   36,391.31   35,623.26   34,849.76   34,070.79   33,286.30
   263.17      257.77      252.33      246.85      241.33      235.78
   762.65      768.05      773.50      778.97      784.49      790.05
$1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

       31          32          33          34          35          36
27,637.04   26,806.98   25,971.03   25,129.17   24,281.34   23,427.51
   195.76      189.88      183.96      178.00      171.99      165.94
   830.06      835.94      841.87      847.83      853.83      859.88
$1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

       43          44          45          46          47          48
17,278.91   16,375.47   15,465.64   14,549.36   13,626.59   12,697.29
   122.39      115.99      109.55      103.06       96.52       89.94
   903.43      909.83      916.28      922.77      929.30      935.89
$1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

       55          56          57          58          59          60
 6,005.20    5,021.91    4,031.66    3,034.39    2,030.06    1,018.61
    42.54       35.57       28.56       21.49       14.38        7.22
   983.29      990.25      997.27    1,004.33    1,011.45    1,018.61
$1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83   $1,025.83

       67         68         69         70        71        72
(6,264.99) (7,335.19) (8,412.98) (9,498.39) ######## ########
   (44.38)    (51.96)    (59.59)    (67.28)   (75.02)   (82.82)
 1,070.20   1,077.78   1,085.42   1,093.11  1,100.85  1,108.65
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

       79        80        81        82        83        84
 ######## ######## ######## ######## ######## ########
  (138.97)  (147.22)  (155.53)  (163.90)  (172.33)  (180.82)
 1,164.80  1,173.05  1,181.36  1,189.73  1,198.15  1,206.64
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83
       91        92        93        94        95        96
 ######## ######## ######## ######## ######## ########
  (241.93)  (250.91)  (259.95)  (269.06)  (278.23)  (287.47)
 1,267.76  1,276.74  1,285.78  1,294.89  1,304.06  1,313.30
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

      103       104       105       106       107       108
 ######## ######## ######## ######## ######## ########
  (353.99)  (363.76)  (373.61)  (383.52)  (393.50)  (403.55)
 1,379.82  1,389.59  1,399.43  1,409.35  1,419.33  1,429.38
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

      115       116       117       118       119       120
 ######## ######## ######## ######## ######## ########
  (475.95)  (486.59)  (497.30)  (508.09)  (518.96)  (529.90)
 1,501.78  1,512.42  1,523.13  1,533.92  1,544.78  1,555.73
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

      127       128       129       130       131       132
 ######## ######## ######## ######## ######## ########
  (608.70)  (620.27)  (631.93)  (643.68)  (655.50)  (667.41)
 1,634.52  1,646.10  1,657.76  1,669.50  1,681.33  1,693.24
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

      139       140       141       142       143       144
 ######## ######## ######## ######## ######## ########
  (753.17)  (765.77)  (778.46)  (791.25)  (804.12)  (817.08)
 1,779.00  1,791.60  1,804.29  1,817.07  1,829.94  1,842.90
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

      151       152       153       154       155       156
 ######## ######## ######## ######## ######## ########
  (910.42)  (924.14)  (937.95)  (951.86)  (965.87)  (979.97)
 1,936.25  1,949.96  1,963.77  1,977.68  1,991.69  2,005.80
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

      163        164        165        166        167        168
 ######## ######## ######## ######## ######## ########
(1,081.57) (1,096.49) (1,111.53) (1,126.67) (1,141.91) (1,157.27)
 2,107.39   2,122.32   2,137.35   2,152.49   2,167.74   2,183.10
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

      175        176        177        178        179        180
 ######## ######## ######## ######## ######## ########
(1,267.84) (1,284.09) (1,300.45) (1,316.93) (1,333.52) (1,350.23)
 2,293.67   2,309.91   2,326.28   2,342.75   2,359.35   2,376.06
$1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83 $1,025.83

				
DOCUMENT INFO
Description: Projected Vs. Actual Cost document sample