Income by juanagao

VIEWS: 0 PAGES: 15

									Do NOT change the BLUE cells (they are already linked to your other spreadsheets).
ONLY CHANGE THE GREEN CELLS!
You will delete ONE of the rows in YELLOW!



          Starting Pay
Annual Gross Pay
                                    $0.00
Federal Income Tax                  $0.00

State Income Tax
                                    $0.00

       FICA Tax                     $0.00
                                    $0.00
Annual Net Pay                      $0.00
Monthly Net Pay                     $0.00
they are already linked to your other spreadsheets).
 S!
s in YELLOW!



            What you need to do:



            (Verify this number with Mrs. Noto first)

            (Look up in table)


            (find your state and income bracket then do Annual Gross Pay x Tax Rate)

            If employed by someone else: Annual Gross Pay x 5.65%
            If self employed: Annual Gross Pay x 15.3%
            (Annual Gross Pay - Federal Income Tax - State Income Tax - FICA Tax)
            (Annual Net Pay ÷ 12)
The formula in this cell is set for people living in Alabama. If you plan to live in a
different state, you must look up the income tax for that state using the hyperlink
and change the formula.


Delete the two cells in a row you do not use!! (For this project, you are only self-
employed or employed by someone else.)
Do NOT change the BLUE cells (they are already linked to your other spreadsheets).
ONLY CHANGE THE GREEN CELLS!


You must use this spreadsheet, however, to get a nice graph to go in your PowerPoint, go to www.mlcalc.com and enter your
APR, and zeros for everything else. Press calculate, then the "Print screen" keyboard button, paste the picture in your Power


                                        Vehicle Payment

Purchase Price                                                                       $0.00

Percent Down Payment                                                                  5.00 %

Down Payment                                                                         $0.00

Loan Term                                                                             5.00 years

Interest Rate (APR)                                                                   6.00 %

Amount Financed                                                                      $0.00

Total Loan Interest                                                                  $0.00

Loan Maturity Value                                                                  $0.00

Monthly Loan Payment                                                                 $0.00

Annual Vehicle Insurance                                                             $0.00

Monthly Vehicle Insurance                                                            $0.00

Annual Vehicle Tag & Tax Fees                                                        $0.00

Monthly Portion of Vehicle Tag & Tax Fees                                            $0.00

Total Monthly Payment (Loan, Insurance, Tag & Tax)                                   $0.00
o to www.mlcalc.com and enter your purchase price, down payment percent, loan term,
ton, paste the picture in your PowerPoint and crop the edges.




           Do not change this cell unless Mrs. Noto tells you to.




           Do not change this cell unless Mrs. Noto tells you to.

           Do not change this cell unless Mrs. Noto tells you to.




           Ask Mrs. Noto for this estimate.


           This cell is set for Auburn/Opelika, AL. Do NOT change this cell unless Mrs.
           Noto tells you to. (15% assessed value at 64 mills)
Do NOT change the BLUE cells (they are already linked to your other spreadsheets).
ONLY CHANGE THE GREEN CELLS!


You must use this spreadsheet, however, to get a nice graph to go in your PowerPoint, go to www.mlcalc.com and enter your
and zeros for everything else. Press calculate, then the "Print screen" keyboard button, paste the picture in your PowerPoint
Renters: Delete the ROWS with PURPLE text



                                               Home Payment

Purchase Price                                                                        $0.00

Percent Down Payment                                                                  10.00 %

Down Payment                                                                          $0.00

Loan Term                                                                             30.00 years

Interest Rate (APR)                                                                    6.25 %

Amount Financed                                                                       $0.00

Total Loan Interest                                                                   $0.00

Loan Maturity Value                                                                   $0.00

Monthly Loan/Rent Payment                                                             $0.00

Annual Home Owner's or Renter's Insurance                                             $0.00

Monthly Home Owner's or Renter's Insurance                                            $0.00

Annual Property Tax                                                                   $0.00

Monthly Portion of Property Tax                                                       $0.00

Total Monthly Payment (Loan/Rent, Insurance, & Tax, if applicable)                    $0.00
to www.mlcalc.com and enter your purchase price, down payment percent, loan term, APR,
 ste the picture in your PowerPoint and crop the edges.




           Do not change this cell unless Mrs. Noto tells you to.




           Do not change this cell unless Mrs. Noto tells you to.

           Do not change this cell unless Mrs. Noto tells you to.




           Ask Mrs. Noto for this estimate.


           This cell is set for Auburn/Opelika, AL. Do NOT change this cell unless Mrs.
           Noto tells you to. (15% assessed value at 64 mills)
To add or delete cells, highlight both the label and amount cells, then right click and select insert or delete.
KEEP THE ORANGE CELLS TOGETHER.
Do NOT change the BLUE cells (they are already linked to your other spreadsheets).
ONLY CHANGE THE GREEN CELLS!

                                 Income
Monthly Net Pay                                                     $0.00
Roommate                                                            $0.00
Total Monthly Income                                                $0.00

                  Monthly Fixed Expenses
Mortgage/Rent Payment                                               $0.00
Vehicle Payment                                                     $0.00
Student Loan Payment                                                $0.00
Savings/Emergency Fund                                              $0.00

Monthly Fixed Expenses Total                                        $0.00




Total Monthly Expenses                                              $0.00
Remaining Money to Savings Account                                  $0.00


           Name of Partner:
           Partner Comments:
then right click and select insert or delete.

her spreadsheets).



              If you do not have any roommates, then delete the roommate
                   and amount cells. Roommates cover their portion of rent,
                              water, and electricity. Number of Roommates:




                                   Monthly Living Expenses
             Electricity                                                      $0.00
             Water, Sewer, Garbage                                            $0.00
             Groceries                                                        $0.00
             Gasoline                                                         $0.00
             Telephone, Cable, Internet, Cell phone                           $0.00
             Medical/Dental                                                   $0.00
             Clothing                                                         $0.00
             Pet                                                              $0.00
             Gifts                                                            $0.00
             Entertainment                                                    $0.00

             Monthly Living Expenses Total                                    $0.00
                        Annual Expenses
Home Owner/Renter's Insurance             $0.00
Vehicle Insurance                         $0.00
Property Taxes                            $0.00
Vehicle Registration & Tag Fees           $0.00
Health and Dental Insurance               $0.00
Life Insurance                            $0.00
Home Security Fee                         $0.00
Professional Organization Membership      $0.00
Professional License / Insurance          $0.00
Gym Membership                            $0.00
Home Owner's Association Fee              $0.00
Charity Donations                         $0.00

Annual Living Expenses Total              $0.00
Monthly Portion of Annual Expenses        $0.00
To add or delete cells, highlight both the label and amount cells, then right click and select insert or delete.
KEEP THE ORANGE CELLS TOGETHER.
Do NOT change the BLUE cells (they are already linked to your other spreadsheets).
ONLY CHANGE THE GREEN CELLS!

                                 Income
Monthly Net Pay                                                     $0.00
Roommate                                                            $0.00
Total Monthly Income                                                $0.00

                  Monthly Fixed Expenses
Mortgage/Rent Payment                                               $0.00
Vehicle Payment                                                     $0.00
Student Loan Payment                                                $0.00
Savings/Emergency Fund                                              $0.00

Monthly Fixed Expenses Total                                        $0.00




Total Monthly Expenses                                              $0.00
Remaining Money to Savings Account                                  $0.00


           What did you change and why?
then right click and select insert or delete.

her spreadsheets).



              If you do not have any roommates, then delete the roommate
                   and amount cells. Roommates cover their portion of rent,
                              water, and electricity. Number of Roommates:




                                   Monthly Living Expenses
             Electricity                                                      $0.00
             Water, Sewer, Garbage                                            $0.00
             Groceries                                                        $0.00
             Gasoline                                                         $0.00
             Telephone, Cable, Internet, Cell phone                           $0.00
             Medical/Dental                                                   $0.00
             Clothing                                                         $0.00
             Pet                                                              $0.00
             Gifts                                                            $0.00
             Entertainment                                                    $0.00

             Monthly Living Expenses Total                                    $0.00
                        Annual Expenses
Home Owner/Renter's Insurance             $0.00
Vehicle Insurance                         $0.00
Property Taxes                            $0.00
Vehicle Registration & Tag Fees           $0.00
Health and Dental Insurance               $0.00
Life Insurance                            $0.00
Home Security Fee                         $0.00
Professional Organization Membership      $0.00
Professional License / Insurance          $0.00
Gym Membership                            $0.00
Home Owner's Association Fee              $0.00
Charity Donations                         $0.00

Annual Living Expenses Total              $0.00
Monthly Portion of Annual Expenses        $0.00
Monthly Net Income                   $0.00
Total Monthly Expenses               $0.00
Remaining Money                      $0.00




                     $1.00
                     $0.90
                     $0.80
                     $0.70
                     $0.60
                     $0.50
                     $0.40
                     $0.30
                     $0.20
                     $0.10
                     $0.00
                             Monthly Net Income   Total Monthly Expenses   Remaining Money
aining Money

								
To top