# _01_Intro_Workbook by liwenting

VIEWS: 3 PAGES: 41

• pg 1
```									      Introduction Excel
Nolan Tomboulian 252-675-0176
TOMBOULIAN@YAHOO.com
HTTP://TOMBOULIAN.info
HTTP://TOMBOULIAN.Wikispaces.com

Objectives
Order of Operations
M&Ms - Autosum and Charting
Picnic
Numbers and Formatting
Formulas
Autofill
Formatting
Budget Example
Checkbook
Insert
Alt-Enter
Format Exercise
Dates
Absolute Vs Relative formulas
Sort
Pie
Format and Print
House Payments
Car Payments
Retirement
Nolan Tomboulian 252-675-0176
TOMBOULIAN@YAHOO.com
HTTP://TOMBOULIAN.info
HTTP://TOMBOULIAN.Wikispaces.com
1.       Recognize the file extension of an Office 2007 created file and how it differentiates from Office 2003
2.       Demonstrate how to open Excel 2007 in either a “Blank” worksheet, a “Template” or a “Recent” worksheet.
3.       Discuss how “Templates” are useful designs for computer users
4.       Identify the BUTTON, NEW from Existing and the SAVE AS ” and identify the menu items and their uses
5.       Explain how the Ribbon replaces the Menu tabs and Tool Bar in Excel 2003
6.       Identify how to “Save” a Workbook
7.       Recognize different formats that a Workbook created in Excel 2007 can be saved in to include Office 2007, Of
8.       Worksheet Protection: Button / Prepare / Mark as Final
9.       Identify the “Ribbon” Tabs and their uses
10.   Recognize “Groups” and their uses
11.   Recognize “Command Buttons” and their uses
12.   Exercise “Minimizing” the ribbon (3 ways)
14.   Using the Ribbon Key Tips (Alt Commands) and <F10>
15.   Locate the “Worksheet” pane in the Workbook screen
16.   Identify and use the “Page Lay-out/View Buttons” area
17.   Locate and use the “Zoom” bar
18.   Recognize and use the “Scroll” bars
19.   Specify the difference between a Column and a Row
20.   Describe a “Cell” and its function. Place holder for: Text, Numbers or formulas
21.   Identify and use keyboard navigation commands: {Home}, {tab}, {Ctrl Home},<Arrows>, etc.
22.   Understand the “Order of Operations” utilized in formulas: (Please Excuse My Dear Aunt Sally)
23.   Identify the “Mathematical Operators” utilized in formulas (+, - *, /, ^)
24.   Identify “Simple and Complex Formulas” and working parameters of these formulas
25.   Discuss and use the AUTOFIL, “Copying”,” Cutting”, “Pasting” and “Paste Special” and the clipboard
26.   Change the “Font” attributes of text.(Font, Color, Size, Format: Bold, Italics, Underline)
27.   Use the ALIGNMENT Command buttons: Left , Center, Right, Full, Top, Middle and Bottom
28.   Locate the Formula and/or Function (F x) Bar
29.   Recognize how to format a column or row using the Format Group
30.   Identify how to “Insert” and “Delete” columns or rows Using the Command button or <Right Click>
31.   Discuss “Styles” and how to utilize them
32.   Identify how to “Format a Cell” using the Format Painter
33.   Use the Sort and Filter Option to ort and limit data
34.   Create a simple Chart
35.   Recognize how to “Print” a Workbook
36.   Describe a “Print Area” and how to select a “Print Area”, Headers and Print Attributes
37.   Recognize how to perform a “Spell Check” (if it is not turned on)
38.   Using the [VIEW] {Freeze Pain} features
39.   OTHER…….

Updated: March 7, 2012
(Portable Document Format)

-        /      *   ^)
CELL                               ROW
<Home>                 Column A
<Enter>                Down a row
<Shift> <Enter>        Up a Row
<Tab>                  To the Right 1 column
<Shift> <Tab>          To the Left 1 column
<Ctrl> <Home>          Cell A1
Arrow Keys:            <Up> <Down> <Left> <Right>
<Shift> <Arrows>       Drag and extend cell selection
<Ctrl> <End>           Last Row and Column of work
COLUMN   <F5> or Name Box:      GOTO Cell

<Ctrl> <Arrows>       Last Non-blank Row or Colum
Page Up / Page Down Move up or down a screen of r
<Ctrl> <Page Up> / <Ctrl> <Page Down> : Prior and N
<Ctrl> <F1>           Turn off the Ribbon
<F2>                  Make the Cell active to be able
ROW
CELL

ht 1 column
1 column

wn> <Left> <Right>
xtend cell selection
nd Column of worksheet data
COLUMN

lank Row or Column of data
down a screen of rows
Down> : Prior and Next Sheet
e Ribbon
Cell active to be able to edit
50    10       5                    PEMDAS
=       A1 + B1 * C1
=       (A1 + B1) * C1
=       A1 / B1 - C1
=       A1 / (B1-C1)
=       A1 / B1*C1
=       A1 / (B1 * C1)
=       A1 / B1 + B1 / C 1 - A1 / C1 + B1
=       B1 ^ 2 + B1 * C1
=       (A1 + B1 * C1) ^ .5
=       A1 + B1 * C1 + A1
=       A1 + B1 ^ 2 + C1 ^2
Please      Excuse      My          Dear     Aunt Sally
Parantheses Exponenets [Multiply or Divide] [Add or Subtra
Aunt Sally
M&M Color Quantity
Red
Yellow
Blue
Green
Orange
Brown

This example will demonstate:
Entering data in a column
Simple Charting (highlighing a range)
Using the AutoSum to find the TOTAL
Typing in the AVERAGE Function
Use the Function Bar to enter the MIN function
Use the AutoSum to find and enter the MAX function
Use of the Absolute Cell Referece in a calculation of Percent of each color
The Picnic for       Planned People 20
Actual People    15
Cost Per
Person
Budget    ?
Actual    ?

item                            cost
hot dogs                                 15
plates                                    3
forks                                  4.25
matches                                0.25
grill
charcoal                               8.75
lighter fluid                          4.15
potato chips                            7.5
katchup                                2.69
relish                                 1.29
Mustard                                1.75
hot dog buns                             18
Shelter permit fee                       25
Trash bags                                3
Napkins                                3.75
TOTAL

This will demonstart the Auto Sum
Absoulte Cell Reference Multiplier
Formatting and Simple Formulas
Format Numbers
Number
Number     Comma      Currancy    Currancy Accounting Accounting
General Comma 2 Decimals           US \$        US \$       US \$       US \$
Raw Numbers Decimal 2 Decimals (Negative) 2 Decimals 0 Decimals 2 Decimals 0 Decimals
No
-4342      -4342.00    -4342      -4342       -4342       -4342      -4342      -4342
-101.67        -101.67 -101.67    -101.67     -101.67     -101.67    -101.67    -101.67
-100.6       -100.60   -100.6     -100.6      -100.6      -100.6     -100.6     -100.6
-100      -100.00      -100       -100        -100        -100       -100       -100
-22.6       -22.60     -22.6      -22.6       -22.6       -22.6      -22.6      -22.6
-22.5       -22.50     -22.5      -22.5       -22.5       -22.5      -22.5      -22.5
-22.4       -22.40     -22.4      -22.4       -22.4       -22.4      -22.4      -22.4
-0.78        -0.78     -0.78      -0.78       -0.78       -0.78      -0.78      -0.78
-0.7       -0.70       -0.7       -0.7        -0.7        -0.7       -0.7       -0.7
-0.5       -0.50       -0.5       -0.5        -0.5        -0.5       -0.5       -0.5
-0.2       -0.20       -0.2       -0.2        -0.2        -0.2       -0.2       -0.2
-0.1       -0.10       -0.1       -0.1        -0.1        -0.1       -0.1       -0.1
0        0.00          0          0           0           0          0          0
0.07         0.07      0.07       0.07        0.07        0.07       0.07       0.07
1        1.00          1          1           1           1          1          1
15.24         15.24    15.24      15.24       15.24       15.24      15.24      15.24
19.9        19.90      19.9       19.9        19.9        19.9       19.9       19.9
20.48         20.48    20.48      20.48       20.48       20.48      20.48      20.48
75.235          75.24  75.235     75.235      75.235      75.235     75.235     75.235
98.56         98.56    98.56      98.56       98.56       98.56      98.56      98.56
100.2        100.20    100.2      100.2       100.2       100.2      100.2      100.2
100.5        100.50    100.5      100.5       100.5       100.5      100.5      100.5
100.8        100.80    100.8      100.8       100.8       100.8      100.8      100.8
1345.21        1345.21 1345.21    1345.21     1345.21     1345.21    1345.21    1345.21
9876       9876.00     9876       9876        9876        9876       9876       9876
99123      99123.00    99123      99123       99123       99123      99123      99123
120456 120456.00       120456     120456      120456      120456     120456     120456
Percent
-4342
-101.67
-100.6
-100
-22.6
-22.5
-22.4
-0.78
-0.7
-0.5
-0.2
-0.1
0
0.07
1
15.24
19.9
20.48
75.235
98.56
100.2
100.5
100.8
1345.21
9876
99123
120456
80               457       785     125       875     552
100               785       254      25       442     254
40               125       256               254    1141
60               254       252            1245.7   25541
20              1164       854                      2365
55                         200                       214
433.5

4                 5        7       16
8                 3        2       11               220

0.1
Yearly Increase                2
5       10
10

1-Feb           2-Feb      3-Feb    4-Feb    5-Feb   6-Feb
1-Feb           8-Feb     15-Feb   22-Feb   29-Feb   7-Mar
January         February     March

WHERE ARE THE FORMULAS
100     110     121     133.1   146.41
200
300
400
500

10       5       15
3       2        4
2       8       10
3       6        9
100

7-Feb   8-Feb   9-Feb   10-Feb   11-Feb

ORMULAS
1              1 Monday         1-Jan   Dept202
2              3                8-Jan

Row 5

January       February
250              225

15-Feb       15-Mar

Exam 1

101 Elm Street
103 Elm Street
Top-Left                        Top-Center                      Top-Right

Center-Left                     Center-Center                   Center-Right

Bottom-Left                     Bottom-Center                   Bottom-Right

This is a long line that contains lots of text and word wrap is NOT turned on

This is a long line that contains lots of text and word wrap is NOT turned on

This is a long line that contains lots of text and cols A-C will be merged

First Line (No Indent)
Indent pressed ONE time
Indent pressed TWO times
Indent pressed THREE times
Turn Text               Turn Text                Turn Text

Turn Text               Turn Text                Turn Text

of text is word wrap is not on
This is a really long linethistext andover the text in D13
ABC Company

First NameLast NameSSN           Address City                   Phone
State Zip Code
Sara      Marshall 111223333               San      TX
222 Nasa Rd Marcos 2108293944.00
####
Joan      Crawford 444556666               Comfort TX 2102222555.00
2454 Painter             ####
Betty     Davis      777889999             Blanco TX 2108295557.00
222 Main St.             ####
Jimmy     Jones      123456789             Bandera TX 2108295935.00
2221 Perdita             ####
Mike      Jones      999999999             San Antonio
100 Gasoline Alley TX 2108297938.00
####
Will      Smith      888888888             San Antonio
120 Elwood Lane TX 2108293956.00
####
Jane      Smith      100000000             Dublin TX 2108294041.00
421 Raglan Rd.           ####
Fred      Flintstone 222222222   72 Par Rd Blanco TX 2108293940.00
####
Fanny     Brice      200000000             San      TX
####
Bill      Board       73409699             San      TX
####
Budget Analysis
Expense Amount
Rent           1000
Electric         215
Water             65
Cell Phone        75
Cable TV          45
Medical Insurance200
Car Insurance    120
Life Insurance    80
HomeOwners        60
Car repairs      125
Car /Gas          90
Food             250
Houshold          45
Entertainmnet     35
2/1/2007 Beginning Balance
505 2/15/2007 Limited
501 2/3/2007 School Cafeteria
507 2/20/2007 Applebee's Restaurant
2/1/2007 Allowance
503 2/9/2007 GAP
502 2/8/2007 School Store
504 2/14/2007 Sears
3/14/2007 Babysitting
506 3/19/2007 School Store
508 3/23/2007 School Cafeteria

FOLOW THE INTRUCTIONS
1) Put your curser in cell C1. Type:   Ima Student . Press <enter>
2) In C2 Type: Check Register <enter>
3) Adjust the Column Size for column C,
4) Center the Data in the column C.

5) Enter the headers for the columns
a) In A5, Type: Check Number
b) In B5, Type: Date
c) In C5, Type: Description
d) in D5, Type: Amount of Check
e) in E5, Type: Deposit
f) in F5, Type: Balance

6) Type the beginning balance in cell F6: 817.5
7) FORMAT the CELLS in columns: D, E and F to be CURRENCY. Have Negative amounts in (
8) Format the Date to be: Month-Day
9) Put your cursor in F7. Type the formula: =F6-D7+E7 <enter>
(Take the Prior Balance, Subtact the Check amount and Add a deposit)
10) Copy the formula in F7 down to F16
11) NOW ENTER     Data to Test your calculations.
tive amounts in (   )

deposit)
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
A100   B100   C100   D100   E100   F100
A101   B101   C101   D101   E101   F101
A102   B102   C102   D102   E102   F102
A103   B103   C103   D103   E103   F103
A104   B104   C104   D104   E104   F104
A105   B105   C105   D105   E105   F105
A106   B106   C106   D106   E106   F106
A107   B107   C107   D107   E107   F107
A108   B108   C108   D108   E108   F108
A109   B109   C109   D109   E109   F109
A110   B110   C110   D110   E110   F110
A111   B111   C111   D111   E111   F111

A115   B115   C115   D115   E115   F115
A116   B116   C116   D116   E116   F116
A117   B117   C117   D117   E117   F117
A118   B118   C118   D118   E118   F118
A119   B119   C119   D119   E119   F119
A120   B120   C120   D120   E120   F120
A121   B121   C121   D121   E121   F121
Last     First       Address Phone          Date      DVDs        Price per DVD
402 Elm
St
Merrill, MI (989) 555-
Dawes    Gregory     48637             3433 3/10/2010         7     \$17.29
1025
Drake Ave

Exeter,  (603) 555-
Garcia   Susan       NH 03833       1091 3/14/2010           25     \$15.79
5 North
Ln
Oswego, (315) 555-
Torbet   Dr. Lilla   NY 13126       7823 3/17/2010           32     \$12.99

24
Mountain
Dr.
Auburn, (207) 555-
Rhoden   Tony        ME 04210      9915 3/24/2010            20     \$15.79
ExerComp
the Intelligent path to Fitness

X310 Yearly Sales Analysis

Units Sold Region    2008 Sales 2009 Sales Increase % Increase
R01            3605       3853        248    0.068793
R02            3966       3842       -124    -0.03127
R03            3760       4035        275    0.073138
R04            3777       4063        286    0.075721
R05            3974       3725       -249    -0.06266
R06            3656       3937        281     0.07686
R07            3554       3875        321    0.090321
R08            3844       3844          0           0
Total:        30136      31174       1038    0.034444

Revenue Region       2008 Sales 2009 Sales Increase % Increase
R01           104364.8    115397.4    11032.6   0.105712
R02           114815.7    115067.9      252.2   0.002197
R03             108852    120848.3   11996.25   0.110207
R04           109344.2    121686.9    12342.7   0.112879
R05           115047.3    111563.8   -3483.55   -0.03028
R06           105841.2    117913.2   12071.95   0.114057
R07           102888.3    116056.3   13167.95   0.127983
R08           111283.8    115127.8       3844   0.034542
Total:        872437.2    933661.3    61224.1   0.070176
Today's Date                     4/4/2012        W ednesday, April 04, 2012

Date of Birth                    4/1/1960                                1

Age                                     52                               2

Date and time            4/4/2012 19:45                               1900

Time                            7:45:58 PM
4
Hour                                 07 PM                               3

Seconds                                     58                   3/10/2012

<F9> is the Recalculate / Refresh Button                            40971
41063
TODAY()

DAY(Number)                    32 Day within the Month

MONTH(number)                  32 Returns the Month Number

YEAR(number)                    1 "number" is Days from Jan-1-1900)

WEEKDAY(Number,Type)           32
Type 1= Sun-1 / Sat=7
Type 2= Mon-1 / Sun=7
Year        Month          Day
DATE(Year,Month,Day)       2012                3         10

DATEValue(DateString)               03-Mar-2012 <-- formatted as TEXT
03-June-2012
Financial Forecast - Get Rich Quick Enterprises
Income                               2003     2004
Units Sold                      75,000   82,500
Selling Price                    \$3.00
Gross Revenue                 \$225,000
Production facility            \$50,000
Cost of Goods Sold
Unit manufacturing cost          \$1.00
Variable manufacturing cost    \$75,000
Unit sales cost                  \$0.20
Variable sales cost            \$15,000
Earnings before taxes             \$60,000      \$0
Income taxes                   \$15,000
Net earnings                      \$45,000      \$0

Initial conditions
Units Sold                      75,000    10.0%
Selling price                     \$3.00    5.0%
Unit manufacturing cost           \$1.00   10.0%
Unit sales cost                   \$0.20    0.0%
Production facility             \$50,000    8.0%
Tax rate                           25%
First year of forecast             2003
es
Professor's Grade Book - Weighted Semester Averages
Soc Sec                                         Test
Name           Num        Test 1                            Average Homework
Adams, John           111223333    80       71       70      84       76         Poor
Barber, Maryann       444556666    96       98       97      90       92         OK
Boone, Dan            777889999    78       81       70      78       75         OK
Borow, Jeff           123456789    65       65       65      60       62        Great
Brown, James          999999999    92       95       79      80       83         OK
Carson, Kit           888888888    90       90       90      70       80         OK
Coulter, Sara         100000000    60       50       40      79       60         OK
Fegin, Richard        222222222    75       70       65      95       79         OK
Ford, Judd            200000000    90       90       80      90       86         Poor
Glassman, Kris        444444444    82       78       62      77       74         OK
Goodman, Neil         555555555    92       88       65      78       78         OK
Milgrom, Marion       666666666    94       92       86      84       86        Great
Moldof, Adam          300000000    92       78       65      82       78         Poor
Smith, Adam           777777777    60       50       65      80       66         Poor
Average
Range (High - Low)

Exam Weights                          18%      20%      20%       40%
0         F                                                       Poor                0
60        D-                                                      OK                  1
63        D                                                       Great               3
67        D+
70        C
77        C+
80        B-
83        B
87        B+
90        A-
93        A

Add Formuals for Average, High (MAX), Low (Min) and Range: High-Low
Weight for the Exams needs to dd up to 100%: Add a formula in G22
The "Semester Average" in Column I is not down well. (Hard coded based on Homework
ges
Semester   Letter
76
93
76
65
84
81
61
80
86
75
79
89
78
66
First Name    Last Name   Address                City              State        Zipcode   Sex   Race       Sales    Date
James         Bond        007 Danger Street      Dublin            NM             88001   M     W      \$     10    Jan-15
Victoria      Bond        99 Smart Drive         Dublin            AZ             70097   F     B      \$       5   Jan-19
Phil          Erupp       100 Gasoline Alley     San Antonio       TX             78202   M     B      \$     12    Feb-05
John          Belushi     120 Elwood Lane        San Antonio       TX             78222   M     W      \$     20    Mar-15
Anne          Frank       897 Atic Place         Freemont          AZ             78012   F     H      \$       8   Mar-12
Walker        Board       2454 Painter           Comfort           TX             78148   M     H      \$     15    Jan-15
Dana          Smith       1218 Lucinda Street    Dublin            NM             88001   F     A      \$       9   Feb-12
Betty         Davis       85 Buggs Bunny Road    Bandera           TX             78109   F     W      \$       7   Jan-09
Kathrine      Lewis       123 Elizabeth Dr       Pheonix           AZ             70098   F     W      \$       3   Feb-19
Barbara       Tintle      123 Northen Parkway    Freemont          AZ             78012   F     B      \$     10    Mar-15
Candy         Cane        123 Sweetgum Rd        Comfort           TX             78148   F     W      \$     12    Mar-10
Anne          Bishop      4 Kings Corner         San Antonio       TX             78222   F     B      \$     15    Jan-15
Cherri        Johnson     1417 Davis Ave         Blanco            NM             88015   F     H      \$     20    Jan-07
Carol         Edwards     215 Elizabeth Ave      Dublin            NM             88001   F     H      \$       5   Feb-02
Judy          Collins     222 Main St.           Blanco            TX             78111   F     A      \$       3   Feb-09
Carl          Sagan       222 Nasa Rd            San Marcos        TX             78222   M     A      \$       1   Mar-15
Andrew        Smith       76 Red Robin Lane      Pheonix           AZ             70098   M     B      \$       8   Jan-15
Jane          Goodall     2221 Perdita           Bandera           TX             78109   F     B      \$     10    Jan-09
Andy          Goodall     218 Bad Avenue         Bandera           AZ             78015   M     W      \$     15    Feb-02
Bill          Board       2454 Painter           Comfort           TX             78148   M     W      \$     20    Mar-20
Vanessa       Morrison    421 Raglan Rd.         Dublin            TX             78112   F     A      \$       5   Mar-15
Bill          Murray      4301 Broadway          San Antonio       TX             78212   M     A      \$       3   Feb-08
Terry         Peak        4301 Broadway          San Antonio       TX             78222   M     B      \$     15    Feb-01
Lucy          Linus       623 Peanut Lane        Bandera           NM             88111   F     H      \$       3   Jan-15
Lucinda       Baca        634 Elmwood Ave        Blanco            NM             88015   F     H      \$       2   Jan-20
Sandy         Batt        6705 Elmwood           Blanco            NM             88015   F     B      \$       5   Feb-15
Bob           Jones       72 Par Rd              Blanco            TX             78109   M     W      \$       8   Mar-18
Bobby         Bishop      769 Paff Ave           San Antonio       NM             88512   M     W      \$       9   Mar-09
Austin        Powers      777 Gold Finger Road   San Marcos        NM             88123   M     B      \$     16    Feb-08
Maria         Baca        786 Gladys Dr          Pheonix           AZ             70098   F     H      \$     12    Jan-15
Bobbie        Jones       888 Birdie Laae        Blanco            TX             78109   F     A      \$       8   Feb-12
Jack          Smith       812 Greenwood          Comfort           NM             88019   M     B      \$       7   Mar-11
Charlie       Brown       876 Peanut Lane        Bandera           NM             88111   M     W      \$     10    Mar-20
David         Davis       879 Looney Tunes       Bandera           TX             78109   M     A      \$     20    Jan-15
Rose          Littleton   945 Elmwood Dr         Freemont          AZ             78012   F     H      \$     15    Feb-12

3:15 PM12/12/2013                                       Instructional Technology 32
My
Investmen
Investment Category
Assets
Cash   ts\$ 6,144
U.S. Stocks 49,001
\$
Non-U.S. Stocks
\$ 8,035
Bonds     \$ 13,077
Other      \$ 2,520
Total Assets
\$ 78,777

Make a Simple Pie, Bar or Column Chart
Calculate Percentage
Fix/add Formulas for totals and add formatting to Column A (merge A6-A19 and A21-34). Make it look good!

ExerComp
the Intelligent path to Fitness

X310 Monthly Sales Analysis

Units Sold in 2008Month           R01      R02      R03      R04      R05       R06       R07
Jan                288      345      326      307      364       310       316
Feb                278      304      294      297      310       278       275
Mar                294      320      297      304      316       291       297
Apr                288      313      300      300      320       284       275
May                284      329      304      297      313       288       275
Jun                313      339      316      315      326       307       288
Jul                313      332      320      310      313       300       304
Aug                294      339      315      339      339       304       307
Sep                284      310      310      304      316       284       281
Oct                284      326      304      297      316       281       281
Nov                339      364      326      320      364       345       294
Dec                346      345      348      387      377       384       361
3,605    3,966    3,760    3,777    3,974     3,656     3,554

Units Sold in 2009 Month          R01      R02      R03      R04      R05       R06       R07
Jan                352      364      345      352      336       361       325
Feb                297      326      310      313      288       300       297
Mar                307      333      326      316      316       316       310
Apr                313      316      329      326      307       304       310
May                310      323      326      326      304       313       313
Jun                313      348      348      320      329       319       336
Jul                323      326      348      329      313       316       326
Aug                323      320      326      355      315       326       325
Sep                300      297      326      326      297       310       307
Oct                300      288      332      313      291       310       313
Nov                355      297      355      384      297       361       329
Dec                360      304      364      403      332       401       384
3,853    3,842    4,035    4,063    3,725     3,937     3,875
Make it look good!

R08       Totals
352    2,608
294    2,330
307    2,426
295    2,375
310    2,400
329    2,533
336    2,528
323    2,560
304    2,393
300    2,389
336    2,688
358    2,906
3,844    30,136

R08       Totals
342    2,777
300    2,431
316    2,540
352    2,557
300    2,515
326    2,639
329    2,610
305    2,595
293    2,456
307    2,454
329    2,707
345    2,893
3,844    31,174
House Repayment Schedule                                    Payment Calculator Using the =PMT Form
Rate:     0.07                                               Amount:    100,000
Rate:      0.07
Amount:    100000                                                 Years:        30

Montly Payment Amount

Payment Date
Payment number    Principle   Interest   Payment   New Balance
100000
culator Using the =PMT Formula

Monthly:
Months
Car Payment Calculator
Yearly       Term
Down                  Amount        Inteerest       in                        Total
Make/Model         Price       Payment   Trade-In     Financed        Rate        Months        PMT         Payments
10%
2008 Acura MDX   \$     2,000 \$       1,000 \$    500 \$          500    0.00833333           12       -\$43.96
\$          -      0.00833333                 #DIV/0!
\$          -      0.00833333                 #DIV/0!
\$          -      0.00833333                 #DIV/0!
\$          -      0.00833333                 #DIV/0!

PMT(rate,Nper,Pv,[Fv],[Type])

Rate: The ANNUAL Rate: Divide by "N" payments per year
Nper: Number of Periods or payments to make
Pv: Present Value: Amount Financed
Fv: Future Value: (zero or amount left at end of term)
Type: 1=Pay at start of term, 0=Pay at end of term
Interest
paid

Type])

yments per year
ake

d of term)
d of term
Retirement
Today's Date               4/4/2012
Bate of Birth
Target Age of Retirement         70

Annual                               Years
Name                           Age     Contribution      Rate of Return   Contributing
Nolan                            52             3000                0.1             1

VF(Rate,Nper,Pv,[Fv],[Type])

Rate: The ANNUAL Rate: Divide by "N" payments per year
Nper: Number of Periods
Pmt: Amount of payment per term
Pv: Present Value of an initial Lump Sum Invested
Type: 1=Pay at start of term, 0=Pay at end of term

Assumes a FIXED RATE over the term
Amount
at
Retirement
(\$3,300.00)

```
To top