Quick search
Join
Home
>
Solution Manual
>
978-1259444951 Chapter 16 Excel
Sidebar
Close
978-1259444951 Chapter 16 Excel
0
Helpful
0
Unhelpful
May 14, 2020
Related documents
Econ 120 Practice Test Answers
Chapter 1 Business And Its Environment
Sociology
Wow My Love
Case Report Laquinta
Article Review: Administrators and Accountability: The Plurality of Value Systems in the Public Domain
FC 42957
FC 62472
FIN 91396
FE 34842
Unlock access to all the studying documents.
View Full Document
Stude
nt Na
me:
Cla
ss
:
a.
Debi
ts Cre
dits
b.
Debi
ts Cre
dits
c.
Debi
ts Cre
dits
d.
Debi
ts Cre
dits
e.
Debi
ts Cre
dits
f.
Debi
ts Cre
dits
g.
Debi
ts Cre
dits
h.
Debi
ts Cre
dits
I.
Debi
ts Cre
dits
j.
Debi
ts Cre
dits
Pro
bl
em 16-37
Mc
Graw-Hi
ll
Inst
ructo
r
Ca
sh
Othe
r Fina
ncing So
urce
s-
Bon
d Pro
cee
d
s
Othe
r Fina
ncing So
urce
s-
Tra
ns
fe
r In-Ge
n
e
ra
l Fund
Pro
pe
rty Ta
x
e
s
Re
ceiv
a
ble
Appro
pr
ia
tion
s
Genera
l Fund
Estim
a
ted
Re
ve
nu
e
s
Estim
a
ted
Othe
r Fina
ncing So
urce
s
(Budge
ta
ry
) Fund Ba
la
nce
Capi
tal
Pro
jects
Fund
Genera
l Fund
Ex
pe
nditur
es
– Co
mputer
Genera
l Fund
Encum
bra
nce
s – C
o
m
pute
r
Encum
bra
nce
s Ou
tstan
ding
Encum
bra
nce
s Ou
tstan
ding
Encum
bra
nce
s – C
o
m
pute
r
Capi
tal
Pro
jects
Fund
Due
f
ro
m
Ge
ne
ra
l Fund
Due
to
Ca
pita
l Pro
jects Fun
d (Spe
cial Ass
e
ss
m
e
nt)
Othe
r Fina
ncing Us
e
s-Tr
a
nsf
e
rs Ou
t-Mo
to
r Po
o
l
Ca
sh
Gra
nt Re
v
e
nue
Co
lle
cted
in Adva
nce
Ex
pe
nditur
es
-Sa
la
rie
s
Ca
sh
Genera
l Fund
Genera
l Fund
Specia
l Rev
enue Fund
Ca
sh
Co
ntribu
ted
Ca
pita
l
Re
ve
n
ue
s-
Pro
pe
rty Ta
x
e
s
Allowa
nce
fo
r U
ncolle
ctible
Ta
x
e
s
Ca
sh
Inte
rnal Serv
ice Fund
Genera
l Jo
urnal
FUND
FINA
N
CI
A
L ST
A
T
EMENTS
Specia
l Rev
enue Fund
Othe
r Fina
ncing Us
e
s-Tr
a
nsf
e
r Out-C
a
pital Pro
je
cts
Vo
uche
rs Pa
ya
ble
Ca
sh
Vo
uche
rs Pa
ya
ble
Gra
nt Re
v
e
nue
Co
lle
cted
in Adva
nce
Genera
l Fund
Genera
l Fund
Re
ve
n
ue
s-
Gra
nt
Stude
nt Na
me:
Cla
ss
:
Pro
bl
em 16-37
Mc
Graw-Hi
ll
Inst
ructo
r
GO
VERNM
ENT-WID
E FINA
N
CIA
L STATEMENTS
Genera
l Jo
urnal
a.
Debi
ts Cre
dits
b.
Debi
ts Cre
dits
c.
Debi
ts Cre
dits
d.
Debi
ts Cre
dits
e.
Debi
ts Cre
dits
f.
Debi
ts Cre
dits
g.
Debi
ts Cre
dits
h.
Debi
ts Cre
dits
Debi
ts Cre
dits
Go
vernmenta
l A
cti
vi
tie
s
j.
Debi
ts Cre
dits
Re
ve
n
ue
Go
vernmenta
l A
cti
vi
tie
s
Ca
sh
Gra
nt Re
v
e
nue
Co
lle
cted
in Adva
nce
Go
vernmenta
l A
cti
vi
tie
s
Vo
uche
rs Pa
ya
ble
Ca
sh
No
entry
Gra
nt Re
v
e
nue
Co
lle
cted
in Adva
nce
No
entry
Ex
pe
ns
e
-Public Saf
e
ty
Ca
sh
Go
vernmenta
l A
cti
vi
tie
s
Pro
pe
rty Ta
x
e
s
Re
ceiv
a
ble
Re
ve
n
ue
s-
Pro
pe
rty Ta
x
e
s
Allowa
nce
fo
r U
ncolle
ctible
Ta
x
e
s
Go
vernmenta
l A
cti
vi
tie
s
Equipmen
t
Vo
uche
rs Pa
ya
ble
Ca
sh
Bo
nds Pa
ya
b
le
No
entry
Go
vernmenta
l A
cti
vi
tie
s
No
entry
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
Giv
en P1
6-37:
A portion of the grant money in (i.) i
s pro
perly sp
ent
No en
try has
prev
ious
ly been reco
rded
Grant money is collected from
state to s
up
plement police salaries
A small
perce
ntage
is es
tim
ated to be u
ncollectibl
e
Mos
t w
il
l
be collected du
ring curren
t period
Prope
rty tax
es
are lev
i
ed
this f
acil
ity
Mone
y is trans
ferred f
rom G
ene
ral f
und to pe
rm
ane
ntly f
i
nance
Motor po
ol created to s
erv
ice gov
ernment v
ehicl
es
City will
be s
econ
darily l
iable f
or m
oney b
orrow
e
d f
or this w
ork
This money is n
ot yet trans
f
erred
partial payment f
or sp
ecial ass
es
s
ments
project
Agree
ment reache
d to trans
fer m
oney from
General Fund
as
Inv
oice f
or com
puter is
paid
Computer is
receiv
ed
Fund b
as
ed fi
nancial s
tatements:
Computer is
ordere
d f
or tax department
A bon
d is iss
ue
d at f
ace v
alue to f
und co
ns
truction of
m
unicipal building .
Defi
cit
is projected
All
m
one
tary outfl
ow
s
are f
or expens
es
an
d f
ix
ed as
s
ets
Funding
is f
rom
prop
erty taxes, trans
fers an
d bon
d proce
eds
Budg
et is pas
s
ed
f
or police, am
bulance
and o
ther ong
oing activ
i
ti
es
Stud
ent Name:
Cla
ss:
a.
Debits Credits
94,000
94,000
«- Corre
ct!
b.
Debits Credits
1,200
1,200
«- Corre
ct!
c.
Debits Credits
11,000,000
11,000,000
«- Corre
ct!
d.
Debits Credits
140,000
140,000
«- Corre
ct!
e.
Debits Credits
94,000
94,000
«- Corre
ct!
96,000
96,000
«- Corre
ct!
f.
Debits Credits
32,000
32,000
«- Corre
ct!
32,000
32,000
«- Corre
ct!
g.
Debits Credits
30,000
30,000
«- Corre
ct!
h.
Debits Credits
5,000
5,000
«- Corre
ct!
5,000
5,000
«- Corre
ct!
General
Fund
Specia
l Revenue Fund
Unea
rned Grant Re
ve
nue
Expe
nditu
res –
Tr
uck
Vouchers o
r Accounts Pay
able
Expe
nditu
res
Cash
Capital Projects Fund
Specia
l Revenue Fund
Problem 16
-38
M
cGra
w
-Hill
Instru
ctor
Unea
rned Grant Re
ve
nue
Rev
e
nues
Cash
Cash
Other Financing Source
s-T
ransf
er
s In
Other Financing Uses-
T
ransf
ers Out
Cash
Encum
brances Outstanding
General
Fund
Encum
brances – T
ruck
General
Fund
General
Fund
Fund Financial Statem
e
nts
CITY OF P
UDDIN
G
Expe
nditu
res
Due to Interna
l Serv
ice
Fund
Other Financing Source
s-Bonds Proce
eds
Capital Projects Fund
General
Fund
General
Journal
Cash
Encum
brances – T
ruck
Cash
Other Financing Uses-
T
ransf
ers Out – Sw
imming
Pool
Encum
brances Outstanding
Stud
ent Name:
Cla
ss:
Problem 16
-38
M
cGra
w
-Hill
Instru
ctor
a.
Debits Credits
–
«- Correc
t!
b.
Debits Credits
–
«- Correc
t!
c.
Debits Credits
11,000,000
11,000,000
«- Corre
ct!
d.
Debits Credits
140,000
140,000
«- Corre
ct!
Debits Credits
140,000
140,000
«- Corre
ct!
e.
Debits Credits
96,000
96,000
«- Corre
ct!
f.
Debits Credits
–
«- Correc
t!
g.
Debits Credits
30,000
30,000
«- Corre
ct!
h.
Debits Credits
5,000
5,000
«- Corre
ct!
5,000
5,000
«- Corre
ct!
No entry
Expe
nditu
res –
Tr
uck
No Entry
Governmental Activities
No Entry
Vouchers o
r Accounts Pay
able
Governmental Activities
T
ransf
ers Out-Sw
imming
Pool
Cash
B
usiness
Type
Act
ivities
Cash
T
ransf
ers In-Ge
nera
l Fund
Cash
Bonds Paya
ble
Governmental Activities
Rev
e
nues
Governmental Activities
Expe
nse-Public Serv
ice
Unea
rned Grant Re
ve
nue
Unea
rned Grant Re
ve
nue
Governmental Activities
Cash
Cash
General
Journal
Government-Wide Fina
ncial S
tatem
ents
CITY OF P
UDDIN
G
a.
94,00
0
$
b.
1,2
00
$
c.
11,00
0,00
0
$
d.
140
,000
$
e.
96,00
0
$
f.
32,00
0
$
g.
30,00
0
$
h.
5,0
00
$
Cas
h re
ceiv
ed
f
rom
State (g.) is expend
ed ap
prop
riately
State gran
t receiv
ed to be s
pen
t to promote recycli
ng
Cas
h tran
sferred from
Genera
l F
und
to Capital Projects fund
Truck orde
red in (a.) receiv
ed at actual cos
t (not yet paid)
Cas
h tran
sferred from
Genera
l F
und
to Enterpris
e Fund for pool
Bond
iss
ued
to build new
road
Giv
en P1
6-38:
Printing wo
rk charg
ed by city print sho
p f
or s
choo
l
s
ystem
Ordere
d new
truck for san
itati
on de
partment-cos
t
CIT
Y OF PUDDING
Stu
den
t Name:
Cla
ss
:
a.
Debit
s Credits
900,0
00
900,0
00
«- Correct!
b.
Debit
s Credits
1,100
,000
1,100
,000
«- Corre
ct!
c.
Debit
s Credits
130,0
00
130,0
00
«- Correct!
Debit
s Credits
2,000
«- Co
rrect!
f.
Debit
s Credits
90,00
0
90,00
0
«- Correct!
g.
Debit
s Credits
Rev
en
u
es
– Pro
perty
T
ax
e
s
All
owan
ce
for Un
coll
ect
ibl
e Cu
r
ren
t T
ax
e
s
Tax
es
Recei
v
abl
e
Gen
eral
Fu
n
d
I
n
ve
nt
ory
of Su
ppl
ies
En
cu
mbran
ces
Ou
ts
tan
di
n
g
Gen
eral Fu
n
d
En
cu
mbran
ces
– Equ
ipmen
t
Ex
pend
itu
res
Con
trol
-M
ach
in
ery
an
d Equ
ipmen
t
Vou
ch
ers
or
Accou
n
ts
Pay
abl
e
Cas
h
Oth
er
Fi
n
an
cin
g Sou
rces
-T
ran
s
fers
In
Problem 16
-39
McGraw-
Hill
I
n
stru
cto
r
Oth
er
Fi
n
an
cin
g
Sou
rces
-Bon
d
s Pr
oceeds
Specia
l Rev
en
u
e
Fu
n
d
Cas
h
Cas
h
Gen
eral
Fu
n
d
Un
av
ai
lab
le
Gran
t Re
ve
n
ue
Gran
t
Recei
va
bl
e
Gen
eral Fu
n
d
Gen
eral Jou
r
n
al
Fu
nd
Fin
anc
ial Sta
temen
ts
Debt
Servi
ce Fu
n
d
Capit
al Projec
ts F
u
n
d
Cas
h
Capit
al Projec
ts F
u
n
d
En
cu
mbran
ces
– W
areh
ous
e
En
cu
mbran
ces
Ou
tstan
din
g
Oth
er
Fi
n
an
cin
g Use
s-
Tran
sfers
Ou
t
Stu
den
t Name:
Cla
ss
:
Problem 16
-39
McGraw-
Hill
I
n
stru
cto
r
Gov
ernmen
t-W
ide F
in
an
cial Stat
emen
ts
Gen
eral Jou
r
n
al
a.
Debit
s Credits
900,0
00
900,0
00
«- Correct!
b.
Debit
s Credits
–
«- Co
rrect!
c.
Debit
s Credits
–
«- Co
rrect!
d.
Debit
s Credits
12,00
0
12,00
0
«- Correct!
e.
Debit
s Credits
2,000
2,000
«- Co
rrect!
f.
Debit
s Credits
90,00
0
90,00
0
«- Correct!
g.
Debi
ts Cred
its
600,0
00
576,0
00
«- Correct!
24,00
0
«- Correct!
All
owan
ce f
or Un
coll
ecti
bl
e Cu
rre
n
t Tax
es
Mach
in
ery
an
d Equ
ipmen
t
Vou
ch
ers
or
Accou
n
ts
Pay
abl
e
Gov
ernmen
tal A
ctiv
ities
Cas
h
Bon
ds
Pay
abl
e
No En
try
Rev
en
u
es
– Pro
perty
Tax
es
Gov
ernmen
tal A
ctiv
ities
Tax
es
Recei
v
abl
e
Gov
ernmen
tal A
ctiv
ities
Gran
t Recei
va
ble
Un
earn
ed Gran
t Reve
n
u
e
Gov
ernmen
tal A
ctiv
ities
No En
try
I
n
ve
nt
ory
of Su
ppl
ies
Cas
h
Gov
ernmen
tal A
ctiv
ities
a.
900
,000
$
b.
1,100
,000
$
c.
130
,000
$
d.
12,00
0
$
11,80
0
$
e.
2,0
00
$
f.
90,00
0
$
g.
600
,000
$
4%
Giv
en P1
6-39:
Trans
fer of
unres
tricted f
unds
made to pay de
bt in (a.)
Con
tract signe
d f
or w
areh
ous
e cons
truction
Bond
s
sold at face v
al
ue to fi
nance
w
areho
us
e con
stru
ction
Local governme
nt transac
tions:
Equipment f
or f
ire depa
rtm
ent rece
iv
ed (cos
t)
Portion an
ti
cipated as
uncollecti
ble
Prope
rty tax
as
se
ss
m
ent m
ailed
State gran
t aw
arde
d to s
upp
lem
ent police sa
laries
Supp
li
es
f
or sch
ool purch
as
ed for cash
Anticipated cos
t
of
f
i
re dep
artment equipment at tim
e of
order
Stu
den
t Name:
Cla
ss
:
a.
Debit
s Credits
834,0
00
540,0
00
«- Correct!
242,0
00
«- Correct!
52,00
0
«- Correct!
8,000
,000
8,000
,000
«- Corre
ct!
d.
Debit
s Credits
8,000
,000
Con
tract
s
Paya
ble
Cas
h
Gen
eral Fu
n
d
En
cu
mbran
ces
– Office Bu
ild
in
g
Ex
pend
itu
res
Con
tract
s
Paya
ble
Cas
h
Oth
er
Fi
n
an
cin
g Use
s
Debit
s Credits
1,000
,000
1,000
,000
«- Corre
ct!
Cas
h
Ex
pend
itu
res
– I
n
tere
st
Ex
pend
itu
res
– Bon
ds
Gen
eral Fu
n
d
Debt
Servi
ce Fu
n
d
800,0
00
768,0
00
«- Correct!
32,00
0
«- Correct!
Con
tri
bu
tion
Rev
en
ue
Cas
h
Rev
en
u
es
Perman
en
t F
u
n
d
I
n
ve
stmen
ts
Specia
l Rev
enu
e Fu
nd
Capit
al Projec
ts F
u
n
d
Capit
al Projec
ts F
u
n
d
En
cu
mbran
ces
– Office Bu
ild
in
g
En
cu
mbran
ces
Ou
tstan
din
g
Problem 16
-42
McGraw-
Hill
I
n
stru
cto
r
Oth
er
Fi
n
an
cin
g Sou
rces
Gen
eral Fu
n
d
Esti
m
ated Rev
enu
es
Cas
h
Esti
m
ated Ot
h
er Fi
nan
cin
g Us
es
-Ope
rati
n
g T
ran
s
fers
Oth
er
Fi
n
an
cin
g Res
ou
rces
Capit
al Projec
ts F
u
n
d
Debt
Servi
ce Fu
n
d
Cas
h
En
cu
mbran
ces
Ou
tstan
din
g
Proper
ty
Tax
es
Recei
v
abl
e
Bu
dgetar
y
Fu
n
d Bal
an
ce
Gen
eral Jou
r
n
al
Rev
en
u
es
– Pro
perty
Tax
es
All
owan
ce f
or Un
coll
ecti
bl
e Ta
x
es
Approp
ri
ati
on
s
Stu
den
t Name:
Cla
ss
:
Problem 16
-42
McGraw-
Hill
I
n
stru
cto
r
CHESTERFI
ELD COUNTY
Gov
ernmen
t-W
ide F
in
an
cial Stat
emen
ts
Gen
eral Jou
r
n
al
a.
Debit
s Credits
–
«- Co
rrect!
b.
Debit
s Credits
–
«- Co
rrect!
c.
Debit
s Credits
8,000
,000
8,000
,000
«- Corre
ct!
d.
Debit
s Credits
8,000
,000
8,000
,000
«- Corre
ct!
e.
Debit
s Credits
–
«- Co
rrect!
g.
Debit
s Credits
800,0
00
768,0
00
«- Correct!
32,00
0
«- Correct!
Rev
en
u
es
– Res
erve
d for Hi
gh
way
Mai
n
ten
ance
Gov
ernmen
tal A
ctiv
ities
I
n
ve
stmen
ts
Gov
ernmen
tal A
ctiv
ities
Cas
h
300,0
00
«- Correct!
Gov
ernmen
tal A
ctiv
ities
Bon
ds
Pay
abl
e
Cas
h
I
n
teres
t Ex
pen
s
e
Gov
ernmen
tal A
ctiv
ities
Rev
en
u
es
-Don
ation
s
Rev
en
u
es
– Pro
perty
Tax
es
Gov
ernmen
tal A
ctiv
ities
Proper
ty
Tax
es
Recei
v
abl
e
Bu
il
di
n
gs
Cas
h
Bon
ds
Pay
abl
e
No En
try
No En
try
Cas
h
All
owan
ce f
or Un
coll
ecti
bl
e Ta
x
es
Gov
ernmen
tal A
ctiv
ities
No En
try
a.
834
,000
$
540
,000
$
242
,000
$
b.
8,000
,000
$
c.
8,000
,000
$
d.
8,000
,000
$
e.
1,000
,000
$
f.
1,000
,000
$
100
,000
$
g.
800
,000
$
90%
6%
h.
120
,000
$
i.
300
,000
$
Prope
rty tax
lev
ies
are as
s
es
s
ed
CHESTERFIELD COUNTY
Anticipated rev
enu
e
Prev
iously unre
s
tri
cted cas
h set as
ide to pa
y bond
s from
(c.)
Inv
oice receiv
ed
and p
aid w
hen
buildi
ng completed
Bond
s
sold at face v
al
ue for cons
truction of
central off
i
ce
Con
tract signe
d f
or centra
l
off
i
ce cons
truction
Inv
estments
are rece
iv
ed b
y county as
don
ation
Cas
h receiv
ed
f
rom
toll
road – res
tricted f
or highw
ay m
aintenan
ce
Remainder e
x
pected
to be un
collecti
ble
Portion as
s
umed collectibl
e in sub
s
equ
ent period
s
Portion as
s
umed collectibl
e in this period
Opera
ti
ng tran
sfers o
ut
Appro
v
ed sp
end
ing
Giv
en P1
6-42:
Portion of payment repres
enti
ng interes
t
Portion of bonds
comes d
ue an
d is paid
Stude
nt Name:
Clas
s:
170
,000
Ex
ces
s (d
efi
ci
ency) o
f
rev
en
ues
ov
er expenditures
Other f
inancing s
ou
rces
(us
es
):
Bond pro
ceed
s
Trans
f
ers
out
Cha
nge
i
n Fund
Balance
Total Other Fi
nan
cing Source
s an
d Us
es
Trans
f
ers
i
n
280
,000
$
Co
rre
ct!
720
,000
$
Taxes rece
iv
ab
le
Total
Fund
Balance
Vouch
ers
paya
ble
Accoun
ts p
ayable
Total
As
se
ts
Due
f
rom
Cap
it
al Projects Fund
CIT
Y OF JENNINGS
Due
to Debt Serv
ice Fund
Con
tracts p
ayable
Total
Liabili
ties
(Condensed)
GENERA
L
FUND
(Condensed)
Problem 16
-43
McGra
w-Hill
Instructor
Statem
ent of Reve
nues, Expenditures, and Other Changes in Fun
d Balance
GENERA
L
FUND
CIT
Y OF JENNINGS
Fund Ba
lance, Ending
Fund Ba
lance, Beginn
ing
720
,000
$
Co
rre
ct!
Total Liabil
iti
es, De
f
erred
Inf
l
ow
s
of
Res
ou
rces
, and Fun
d Balance
s
Debit Cr
edit
90,00
0
$
30,00
0
$
90,00
0
40,00
0
60,00
0
40,00
0
530
,000
170
,000
410
,000
760
,000
300
,000
50,00
0
470
,000
220
,000
180
,000
1,720
,000
$
1,720
,000
$
Other Financing So
urces
-Bon
ds
Procee
ds
Giv
en P1
6-43:
Dec
ember
31, 201
7
T
rial Balanc
e
CIT
Y OF JENNINGS
Totals
Vouch
ers
Payab
le
Taxes Re
ceiv
ab
le
Other Financing Us
es-Tran
sfers
Out
Other Financing So
urces
-Trans
f
ers In
Con
tracts Pa
yable
Cas
h
Accoun
ts Pa
yable
Rev
enu
es
Una
v
ai
lable Rev
enue
s
Inv
estments
Fund Ba
lance-Un
as
s
igned
Expenditures
Due
to Debt Serv
ice Funds
Due
f
rom
Cap
it
al Projects Fund
s