Creating Monthly or Quarterly Income Statement Reports

Add a comparison of quarterly Income Statement reports by adding the quarterly month columns March 2003, June 2003, September 2003, and so on, to the PivotTable report.

^ To create a PivotTable report to compare monthly Income Statement balances figures:

1. Copy worksheet 73 — PivotTable PL Group by clicking the worksheet tab, pressing <Ctrl>, dragging it and then releasing the <Ctrl> key and the mouse.

2. Change the worksheet name to 74 — PivotTable Monthly.

3. Add the months you want to compare or add the quarterly months (March, June, and so on) from PivotTable Field List dialog box to the Data area in the Pivot Table report. (If the PivotTable Field List dialog box is not visible, click the rightmost icon in the PivotTable toolbar.)

PivotTable Field List x

Drag items to the PivotTable report

■ October 2002 F] November 2002

■ g December 2U02 g January 2003

■ g May 2003 „ g June 2003

flfid To

Row Area "

NOTE:

The PivotTable Field List dialog box is new in Excel 2002 and later. In Excel 2000, drag a field from the Fields buttons at the bottom of the PivotTable toolbar; in Excel 97, drag the field in the Layout dialog box in Step 3 of the PivotTable Wizard.

File Edit View Insert Format lools Data Window Help

■A

B

iff

E

n

B

i

I

a.

1

$Sc33fl1 N'jttji.

P

fe

-: esi: is

(All)

M

BS, Pi££:Level 1

4

Data

e

SSsSfe Level m-

BS-;- P^L-Level 3

Q1 2002

Q2 2002

03 2002

Q4 2002

Qr20S3

02 2003

Q3 2003

Q4 2003

y:

Itit '-ipTir

psgil es

135,954

IP»

131,438

B:

♦59®+-

■^¡jr.

145,148

»:

llDi^i^iV W E i'llc

'(B4.063)

(57,030;

(69,213)

(71,300)

(73,563)

£75,738)

(77,913)

(00,000)

3-;

Gross Inc'orne Total

st.09t

61,658

.62.225

62,792

63;359

61,435

,.:05.O6O

1.0

s e s

fotfi}

'^¿sSi

;p,146)

jjjfflSj

ffiflMS

¡9.L0f1;}

(10ffi3J

iffl^SSfi

11

^rketinq

(5-,500)

13,000)

■.(SiiSof

t6;100)

(6;400)

^sso]

12

Research & Development

.{3,366)

<3,564)

(3,762)

13',960)

.£1,719)

_(2-1043)

(2,36?)

(2,691^

13

.''■ifr'tti- :- JJ.Jl-~.

(1,451)

¡1,505)

itiS®^

(1,5®)

(' ,Et3>

(1,640)

«

Operating Expenses Tota

tl-S'.Olffi

(19,615)

GO ,2 ¡2)

(20,009)

(10 957)

(19,590)

(20,413J

(21 136)

15

Other Operating

f*l&n Operating Expenses-;

' Si

:128"

' jif

-w

' 15.6

165

' 174

MS

re-

ssp

'3,034

s£S§

SsSWP

3.63S

qME

17.

Special Gajrt (Loss"1)'

St-

124

(100)

133'

1-39:

139.

142

18

'Other 0|: ?[dtir;t Jr ^c-nt-^'c'i:

3 2Zt

3^45?

3,407

3;SI?'

4,177

4,357'

tat

(2,5SI)

P.69B)

■J

:.f2,964)

¡3,416)

:(3',5H])

20

Income Taxes Tota!

.(2,5521

12,6961

12,0401

■(2,984)

(3,120)

PJ72)

(3,416)

(3560)

21

SrandT-olal

42-i6W

42-^624

42";630

42,406

45,081

44-,96f

44,841

44,72-i:

4. After adding the months you want to compare and analyze, add the calculated Fields and format according to the techniques explained in To format and modify the Field name, page 240.

0 0

Post a comment