Docstoc

Mortgage Calculator Amortization Chart - Excel

Document Sample
Mortgage Calculator Amortization Chart - Excel Powered By Docstoc
					Profit & Loss Planner
FAQ's
How do I change the category names?
You can change the default revenue/cost/expense categories on P&L Statement sheet, these names flow through to th
(do not type over names in the other tabs as these sheets are linked to the P&L Statement sheet).

I see ###### instead of numbers, what is wrong?
The cell needs to be widened to allow for this large dollar figure.
To widen a particular column, select the cell with the ###### and select "Column" underneath the "Format" menu.
Select "Height…" and type in a width that fits.

I don't see Column Headers, so how do I adjust the column width?
You may unhide the Column Headers by following these simple step:
Select "Options" underneath the "Tools" menu
On the "View" tab, in the "Windows options" area, check the box next to "Row & column headers"
Click Ok

If you have specific requirements that are not addressed above, contact us at

Overview
Instructions
You may move from worksheet to worksheet by clicking on the white buttons with grey borders as seen here:
You may also use the blue tabs at the bottom of this workbook.

Use the drop down boxes     March           to chart different time periods (Current Month, Prior Month, Yearly, Jan, Fe

P&L Statement
Enter your company name in the cell located at the top left of the sheet (this name will flow through to the other sheets
Select the Current Month, Fiscal Year and when Fiscal Year Begins.
Type in the appropriate revenue/cost/expense names that fit your business (these names will flow through to the other
Enter your company figures on this sheet (these names will flow through to the Detail and Summary sheets)

P&L Detail
Do not enter data on this sheet
The P&L Detail sheet illustrates the sources of revenue/cost/expense via pie charts for the selected period
Use the drop down boxes March              to chart different time periods (Current Month, Prior Month, Yearly, Jan, Fe

P&L Summary
Do not enter data on this sheet
The P&L Summary sheet illustrates revenue/cost/expense trends by month and by quarter
For a quarterly view of the P&L figures you may hide the monthly figure by clicking the negative signs in the grey areas
above the sheets (directly underneath the formula bar)

Personal Financial Planners available at www.simpleplanning.com
    - Budget Planner                  - Mortgage Calculator                        -
    - Investment Calculator           - Tax Calculator                             -
    - Retirement Planner              - 401k Calculator                            -

Business Financial Planners available at www.simpleplanning.com
    - P&L Planner                - Calendar Planner
    - Budget Planner             - Net Worth Calculator

Software License Agreement
Simpleplannings.com grants usage of this financial planning "software" under the following terms and conditions:
After the purchasing and downloading of this software from Simpleplanning.com, the purchaser is granted a "license" t
The "licensee" may make copies of this product in an amount that does not exceed the number of licenses originally p
Simpleplanning.com, or for the purpose of creating a backup copy.
This file or the software contained in this file shall not be transferred to a non-licensee without the written consent from

Limitation of Liability
Simpleplanning.com will not be held liable for damages in the event of, but not limited to inaccurate assumptions, calcu
software, hardware, data and network failure and profit/savings losses as a result of using this software.
&L Statement sheet, these names flow through to the other sheets
 d to the P&L Statement sheet).



 lect "Column" underneath the "Format" menu.




xt to "Row & column headers"


              admin@simpleplanning.com



e buttons with grey borders as seen here:


 riods (Current Month, Prior Month, Yearly, Jan, Feb, etc.)


eet (this name will flow through to the other sheets)

usiness (these names will flow through to the other sheets)
ough to the Detail and Summary sheets)



 e via pie charts for the selected period
 riods (Current Month, Prior Month, Yearly, Jan, Feb, etc.)



y month and by quarter
 ure by clicking the negative signs in the grey areas
             Calendar Planner
             Net Worth Calculator
             Complete Planner




re" under the following terms and conditions:
lanning.com, the purchaser is granted a "license" to use this product.
oes not exceed the number of licenses originally purchased from

to a non-licensee without the written consent from Simpleplanning.com.


of, but not limited to inaccurate assumptions, calculation errors,
es as a result of using this software.
Company Name
                                                                                                Demo: Spreadsheet is password
January // 2010                                                                                   protected in Demo version

Profit & Loss Statement   Jan//10      Feb//10      Mar//10       1Q//10       Apr//10     May//10     Jun//10     2Q//10       Jul//10     Aug//10     Sep//10     3Q//10       Oct//10     Nov//10     Dec//10     4Q//10       YTD Jan         FY

Revenue/ Sales
Application Maintenance     100,000      100,000       100,000      300,000      110,000     110,000     110,000     330,000      120,000     120,000     120,000     360,000      130,000     130,000     130,000     390,000      100,000     1,380,000
Software Licenses           100,000      100,000       100,000      300,000      110,000     110,000     110,000     330,000      120,000     120,000     120,000     360,000      130,000     130,000     130,000     390,000      100,000     1,380,000
Software Customization       50,000       50,000        50,000      150,000       60,000      60,000      60,000     180,000       70,000      70,000      70,000     210,000       80,000      80,000      80,000     240,000       50,000       780,000
Software Support             60,000       60,000        60,000      180,000       70,000      70,000      70,000     210,000       80,000      80,000      80,000     240,000       90,000      90,000      90,000     270,000       60,000       900,000
Services                    100,000
                              Demo:       100,000       100,000
                                      First three revenue           300,000      110,000     110,000     110,000     330,000      120,000     120,000     120,000     360,000      130,000     130,000     130,000     390,000      100,000     1,380,000
Other Sales                                  unlocked
                                  lines are50,000
                             50,000                      50,000     150,000       60,000      60,000      60,000     180,000       70,000      70,000      70,000     210,000       80,000      80,000      80,000     240,000       50,000       780,000
Other Sales                  60,000       60,000        60,000      180,000       70,000      70,000      70,000     210,000       80,000      80,000      80,000     240,000       90,000      90,000      90,000     270,000       60,000       900,000
Other Sales                  10,000       10,000        10,000       30,000       20,000      20,000      20,000      60,000       30,000      30,000      30,000      90,000       40,000      40,000      40,000     120,000       10,000       300,000
Other Sales                   5,000        5,000         5,000       15,000       15,000      15,000      15,000      45,000       25,000      25,000      25,000      75,000       35,000      35,000      35,000     105,000        5,000       240,000
Total Revenue              535,000      535,000       535,000     1,605,000     625,000     625,000     625,000    1,875,000     715,000     715,000     715,000    2,145,000     805,000     805,000     805,000    2,415,000     535,000      8,040,000


Cost of Goods Sold
Salary                       60,000       60,000        60,000      180,000       65,000      65,000      65,000     195,000       70,000      70,000      70,000     210,000       75,000      75,000      75,000     225,000       60,000       810,000
Benefits                     10,000       10,000        10,000       30,000       15,000      15,000      15,000      45,000       20,000      20,000      20,000      60,000       25,000      25,000      25,000      75,000       10,000       210,000
Travel                       10,000       10,000        10,000       30,000       15,000      15,000      15,000      45,000       20,000      20,000      20,000      60,000       25,000      25,000      25,000      75,000       10,000       210,000
Software Development         20,000       20,000        20,000       60,000       25,000      25,000      25,000      75,000       30,000      30,000      30,000      90,000       35,000      35,000      35,000     105,000       20,000       330,000
Contractor cost              30,000
                                Demo:   First three cost 30,000
                                           30,000                    90,000       35,000      35,000      35,000     105,000       40,000      40,000      40,000     120,000       45,000      45,000      45,000     135,000       30,000       450,000
Other Cost of Sales                         unlocked
                                  lines are20,000
                             20,000                      20,000      60,000       20,000      20,000      20,000      60,000       20,000      20,000      20,000      60,000       20,000      20,000      20,000      60,000       20,000       240,000
Other Cost of Sales          10,000       10,000        10,000       30,000       10,000      10,000      10,000      30,000       10,000      10,000      10,000      30,000       10,000      10,000      10,000      30,000       10,000       120,000
Other Cost of Sales          20,000       20,000        20,000       60,000       20,000      20,000      20,000      60,000       20,000      20,000      20,000      60,000       20,000      20,000      20,000      60,000       20,000       240,000
Other Cost of Sales           3,000        3,000         3,000        9,000        3,000       3,000       3,000       9,000        3,000       3,000       3,000       9,000        3,000       3,000       3,000       9,000        3,000        36,000
Total Cost                 183,000      183,000       183,000      549,000      208,000     208,000     208,000     624,000      233,000     233,000     233,000     699,000      258,000     258,000     258,000     774,000      183,000      2,646,000


Gross Profit               352,000      352,000       352,000     1,056,000     417,000     417,000     417,000    1,251,000     482,000     482,000     482,000    1,446,000     547,000     547,000     547,000    1,641,000     352,000      5,394,000


Expenses
Salary expenses               5,000        5,000         5,000       15,000       10,000      10,000      10,000      30,000       15,000      15,000      15,000      45,000       20,000      20,000      20,000      60,000        5,000       150,000
Payroll Taxes                15,000       15,000        15,000       45,000       15,000      15,000      15,000      45,000       15,000      15,000      15,000      45,000       15,000      15,000      15,000      45,000       15,000       180,000
Advertising                  50,000       50,000        50,000      150,000       65,000      65,000      65,000     195,000       80,000      80,000      80,000     240,000       95,000      95,000      95,000     285,000       50,000       870,000
Maintanence                   4,000        4,000         4,000       12,000        4,000       4,000       4,000      12,000        4,000       4,000       4,000      12,000        4,000       4,000       4,000      12,000        4,000        48,000
Accounting/Finance            5,000
                               Demo:   First three expense5,000
                                              5,000                  15,000        5,000       5,000       5,000      15,000        5,000       5,000       5,000      15,000        5,000       5,000       5,000      15,000        5,000        60,000
Travel                                        unlocked
                              4,000lines are 4,000        4,000      12,000        4,000       4,000       4,000      12,000        4,000       4,000       4,000      12,000        4,000       4,000       4,000      12,000        4,000        48,000
Depreciation                                                               0                                                0                                                0                                                0             0           0
Rent/Lease                   10,000       10,000        10,000       30,000       10,000      10,000      10,000      30,000       10,000      10,000      10,000      30,000       10,000      10,000      10,000      30,000       10,000       120,000
Delivery Expenses              500           500           500        1,500         500         500         500        1,500          500        500         500        1,500         500         500         500        1,500          500         6,000
Utilities/Telephone            400           400           400        1,200         400         400         400        1,200          400        400         400        1,200         400         400         400        1,200          400         4,800
Insurance                     1,000        1,000         1,000        3,000        1,000       1,000       1,000       3,000        1,000       1,000       1,000       3,000        1,000       1,000       1,000       3,000        1,000        12,000
Property Taxes                1,500        1,500         1,500        4,500        1,500       1,500       1,500       4,500        1,500       1,500       1,500       4,500        1,500       1,500       1,500       4,500        1,500        18,000
Interest                       500           500           500        1,500         500         500         500        1,500          500        500         500        1,500         500         500         500        1,500          500         6,000
Office Expenses                400           400           400        1,200         400         400         400        1,200          400        400         400        1,200         400         400         400        1,200          400         4,800
Amortization                                                               0                                                0                                                0                                                0             0           0
Vehicle Expenses              1,500        1,500         1,500        4,500        1,500       1,500       1,500       4,500        1,500       1,500       1,500       4,500        1,500       1,500       1,500       4,500        1,500        18,000
Contractor Labor              5,000        5,000         5,000       15,000        5,000       5,000       5,000      15,000        5,000       5,000       5,000      15,000        5,000       5,000       5,000      15,000        5,000        60,000
Bad Debts                     1,000        1,000         1,000        3,000        1,000       1,000       1,000       3,000        1,000       1,000       1,000       3,000        1,000       1,000       1,000       3,000        1,000        12,000
Other expenses                1,000        1,000         1,000        3,000        1,000       1,000       1,000       3,000        1,000       1,000       1,000       3,000        1,000       1,000       1,000       3,000        1,000        12,000
Other expenses                4,000        4,000         4,000       12,000        4,000       4,000       4,000      12,000        4,000       4,000       4,000      12,000        4,000       4,000       4,000      12,000        4,000        48,000
Other expenses                3,000        3,000         3,000        9,000        3,000       3,000       3,000       9,000        3,000       3,000       3,000       9,000        3,000       3,000       3,000       9,000        3,000        36,000
Total Expenses             112,800      112,800       112,800      338,400      132,800     132,800     132,800     398,400      152,800     152,800     152,800     458,400      172,800     172,800     172,800     518,400      112,800      1,713,600


Net Profit                 239,200      239,200       239,200      717,600      284,200     284,200     284,200     852,600      329,200     329,200     329,200     987,600      374,200     374,200     374,200    1,122,600     239,200      3,680,400
  Company Name
                                                                 Demo: Spreadsheet is password
                                          Do not enter category names or data on this sheet (cells reference P&L Statement sheet)
  YTD Jan // 2010                                                   protected in Demo version

  Profit & Loss Detail
  Revenue/ Sales            YTD Jan                                           Revenue/ Sales
4 Application Maintenance     100,000
5 Software Licenses           100,000                                                              Application Maintenance
6 Software Customization       50,000                                                              Software Licenses
7 Software Support             60,000                                                              Software Customization
8 Services                                                                                         Software Support
                              100,000
                                                                                                   Services
9 Other Sales                  50,000
                                                                                                   Other Sales
  Other Sales                  60,000
                                                                                                   Other Sales
  Other Sales                  10,000                                                              Other Sales
  Other Sales                   5,000                                                              Other Sales
  Total Revenue               535,000


  Cost of Goods Sold                                                         Cost of Goods Sold
  Salary                       60,000
  Benefits                     10,000                                                               Salary
  Travel                       10,000                                                               Benefits
  Software Development         20,000                                                               Travel
  Contractor cost                                                                                   Software Development
                               30,000
                                                                                                    Contractor cost
  Other Cost of Sales          20,000
                                                                                                    Other Cost of Sales
  Other Cost of Sales          10,000
                                                                                                    Other Cost of Sales
  Other Cost of Sales          20,000                                                               Other Cost of Sales
  Other Cost of Sales           3,000                                                               Other Cost of Sales
  Total Cost                  183,000


  Gross Profit                352,000


  Expenses                                                                       Expenses
  Salary expenses               5,000                                                                 Salary expenses
  Payroll Taxes                15,000                                                                 Payroll Taxes
  Advertising                  50,000                                                                 Advertising
  Maintanence                   4,000                                                                 Maintanence
  Accounting/Finance            5,000
                                                                                                      Accounting/Finance
  Travel
                                                                                                      Travel
                                4,000
                                                                                                      Depreciation
  Depreciation                        0
                                                                                                      Rent/Lease
  Rent/Lease                   10,000                                                                 Delivery Expenses
  Delivery Expenses               500                                                                 Utilities/Telephone
  Utilities/Telephone             400                                                                 Insurance
  Insurance                     1,000                                                                 Property Taxes
  Property Taxes                1,500                                                                 Interest
  Interest                        500                                                                 Office Expenses
  Office Expenses                 400
                                                                                                      Amortization
  Amortization
                                                                                                      Vehicle Expenses
                                      0
                                                                                                      Contractor Labor
  Vehicle Expenses              1,500
                                                                                                      Bad Debts
  Contractor Labor              5,000                                                                 Other expenses
  Bad Debts                     1,000                                                                 Other expenses
  Other expenses                1,000                                                                 Other expenses
  Other expenses                4,000
  Other expenses                3,000
  Total Expenses              112,800


  Net Profit                  239,200
Company Name
                                                                           Demo: Spreadsheet is password
                                                          Do not enter data on this sheet (cells reference P&L Statement sheet)
January // 2010                                                               protected in Demo version

Profit & Loss Summary                         Jan//10      Feb//10         Mar//10          1Q//10        Apr//10        May//10      Jun//10      2Q//10         3Q//10        4Q//10       YTD Jan           FY

Revenue/ Sales                                  535,000         535,000       535,000       1,605,000       625,000        625,000      625,000     1,875,000      2,145,000    2,415,000      535,000     8,040,000

Cost of Goods Sold                              183,000         183,000       183,000         549,000       208,000        208,000      208,000         624,000     699,000       774,000      183,000     2,646,000

Gross Profit                                    352,000         352,000       352,000       1,056,000       417,000        417,000      417,000     1,251,000      1,446,000    1,641,000      352,000     5,394,000

Expenses                                        112,800         112,800       112,800         338,400       132,800        132,800      132,800         398,400     458,400       518,400      112,800     1,713,600

Net Profit                                      239,200         239,200       239,200         717,600       284,200        284,200      284,200         852,600     987,600     1,122,600      239,200     3,680,400



                                                                          Revenue/ Sales                                                                                                  Revenue/ Sales
      1,000,000                                                                                                                                                   3,000,000

        800,000                                                                                                                                                   2,500,000
                                                                                                                                                                  2,000,000
        600,000
                                                                                                                                                                  1,500,000
        400,000
                                                                                                                                                                  1,000,000
        200,000                                                                                                                                                    500,000
                     0                                                                                                                                                      0
                           Jan-10    Feb-10    Mar-10     Apr-10    May-10      Jun-10        Jul-10     Aug-10   Sep-10     Oct-10    Nov-10     Dec-10                         1Q//10       2Q//10       3Q//10


                                                                          Cost of Goods Sold                                                                                             Cost of Goods Sold
     300,000                                                                                                                                                      1,000,000
     250,000                                                                                                                                                       800,000
     200,000
                                                                                                                                                                   600,000
     150,000
                                                                                                                                                                   400,000
     100,000
      50,000                                                                                                                                                       200,000

             0                                                                                                                                                              0
                         Jan-10    Feb-10    Mar-10    Apr-10     May-10      Jun-10     Jul-10        Aug-10   Sep-10     Oct-10     Nov-10   Dec-10                            1Q//10        2Q//10         3Q//10


                                                                              Expenses                                                                                                      Expenses
       200,000                                                                                                                                                    600,000

       150,000
                                                                                                                                                                  400,000
       100,000
                                                                                                                                                                  200,000
        50,000
                                                                                                                                                                        0
                 0
                                                                                                                                                                                1Q//10       2Q//10        3Q//10
                          Jan-10    Feb-10    Mar-10    Apr-10     May-10     Jun-10        Jul-10     Aug-10   Sep-10    Oct-10     Nov-10    Dec-10


                                                                               Net Profit                                                                                                     Net Profit
     400,000                                                                                                                                                      1,500,000

     300,000
                                                                                                                                                                  1,000,000
     200,000
                                                                                                                                                                   500,000
     100,000
                                                                                                                                                                            0
             0
                                                                                                                                                                                 1Q//10       2Q//10          3Q//10
                         Jan-10    Feb-10    Mar-10    Apr-10     May-10      Jun-10     Jul-10        Aug-10   Sep-10    Oct-10     Nov-10    Dec-10

				
DOCUMENT INFO
Description: Mortgage Calculator Amortization Chart document sample