Attached are the files for my assignment. The third attachment is my work in progress. Need help with the Worksheet, Owner's Equity Statement. Please check the work I've done for accuracy. Thank you.

Bill?s Lawn Care Module 2 Mini Practice Problem

Bill has asked you to prepare financial statements for his first month of operation. The following information relates to the month of May, 2014. (Round all calculations to the nearest whole dollar)

On May 2, Bill signed a 1 year, 6% note for $3,500 associated with the purchase of a used truck for the business. The interest will be due with the principle of the note.

On May 2, Bill purchased a used truck for $7,000 to use for the lawn care business. He estimates a trade-in value of $500 at the end of the estimated five-year life of the truck.

On May 5, Bill purchased a lawn mower for $300 and an aerator for $500. He estimates $0 salvage value for both pieces of equipment and an estimated two-year life for both.

On May 6, Bill writes a $600 check for a six month insurance policy that expires October 31, 2014.

Bill's Lawn Care Module 2 Mini Practice Problem Bill has asked you to prepare financial statements for his first month of operation. The following information relates to the month of May, 2014. (Round all calculations to the nearest whole dollar) 1. On May 2, Bill signed a 1 year, 6% note for $3,500 associated with the purchase of a used truck for the business. The interest will be due with the principle of the note. 2. On May 2, Bill purchased a used truck for $7,000 to use for the lawn care business. He estimates a trade-in value of $500 at the end of the estimated five-year life of the truck. 3. On May 5, Bill purchased a lawn mower for $300 and an aerator for $500. He estimates $0 salvage value for both pieces of equipment and an estimated two-year life for both. 4. On May 6, Bill writes a $600 check for a six month insurance policy that expires October 31, 2014. Instructions: 1. Using the chart of accounts provided, and the Excel template provided with this assignment, record the adjustments in the Worksheet, calculate the adjusted trial balance and complete the worksheet. 2. Prepare the Income Statement, Statement of Owner's Capital and Balance Sheet for Bill's Lawn Care for May, 2014 3. Prepare journal entries, in good form, to record the May adjusting entries. Explanations are optional. Start with Page 3 of the General Journal for the adjusting entries. 4. Post the journal entries to general ledger accounts. There are already transactions in the ledger for the month, you are adding to those transactions. 5. Prepare and post the closing entries for May, 2014. Start with Page 4 of the General Journal for the closing entries 6. Prepare a post-closing trial balance as of May 31, 2014, for Bill's Lawn Care. Classification ASSETS LIABILITIES OWNER'S EQUITY REVENUES EXPENSES Bill's Lawn Care Chart of Accounts Account Number Account Name 101 Cash 110 Accounts Receivable 120 Supplies 130 Prepaid Insurance 150 Equipment 155 Accumulated Depreciation - Equipment 201 Accounts Payable 220 Notes Payable 225 Interest Payable 301 Owner's Capital 305 310 401 620 630 640 650 660 670 680 Owner's Drawings Income Summary Lawn Service Revenue Supplies Expense Fuel Expense Repair and Maintenance Expense Advertising Expense Insurance Expense Depreciation Expense Interest Expense PK########| Hl9.###.#######mimetypeapplication/vnd.oasis.opendocument.spreadsheetPK##### ###|H################Configurations2/popupmenu/PK########| H################Configurations2/progressbar/PK########| H################Configurations2/menubar/PK########| H################Configurations2/statusbar/PK########| H################Configurations2/toolbar/PK########| H############'###Configurations2/accelerator/current.xml##PK##############PK## ######|H################Configurations2/images/Bitmaps/PK########| H################Configurations2/floater/PK########| H################Configurations2/toolpanel/PK########|H############ ###styles.xml]ks6#vfimY6I&~$D! .#YvA hKJv###.=)C##$#G7###0r"fW  #r *#5##`d.3oF+#1HP 2@#9u8*4/JES2ET#.v-eKe]pG:ka.lZ,]#?$PT! @xnYl=9lfLa7W$#Rk##9s,%#B e*E#####0#]n##uwF3#1p#*#;T&^l#R+#y?] %S#)1 v- n#_#D!).#8l2#s,&a{#y %Mx5_X#LEwc#ga#UD}yL#yE? PZ#8e#`p+a'##bH##(6/PDL{T!#J`-Rc5#ab BR'6o#3x3m0Gj\\`6j.#M#Ar{-#/K6g####FFJ Dc^,sL#FW,85J^+#;##svn"d&TM0#  3K6 q}YLx### %bD]}N   "4 Ju6# 7#[## ]#\\####^##.vYWRJY#8l",c-#r#tUjNU## #) i r# #Y.D#UJX~? Va JH###R ?Wout##Zk[#O^F(OZ=###EbY9#2_9::#! lycU/q#  [ ##Jl[_eUCCx#2[ r}[ W ##*Xl#-#`| X#o+Yj^i#YpD#K{#}o28#Rc%Xnv>#lm#*| Js#$_##sJ^\\QAV+##y.6p##?A5#nP v Ak$###6m^m#F06(ZYIpJ7#6Wt(# D[#?#=#&0 9+~#yM#6_zj|#gOkd  $g(#qtv&t2   y0y23Y~! #Z#N#tv#r>:c*nMhnN*#Nx6#WnC#.#v##`=]jo=*Z =#r#bG0gipBgz#o,~^owz?JJ#h]el 8#Aqpd@#7 mqw#iXf5#, g#VS~glT~MQ#{T 5 S,j&U6#\\67c5 #5 #58oATOR# HO#"##EP$8@Fd#XQH1.##?\\C/)8^)#Vu##,J^#J n####GP#DZHH#M#AMY#5M #(#in3#yddRl.Pr(.?W E#cS.=qp0b3>#TI##_E###t#*:u$e   ##bqiF#Y= %F+ ## ]#$#####G##q # #0#`|1t#\\l##)AvA#cAvP6`q#SX####g#y##>4mKo#\\  !Uiost#| SU##_ 2m/ x?X|5b#{6 YjE|#'##o0$#:$#+D#K#6SV`U/ ?By#_xE|@1aT#w@1$##iM##Tu_d#L>jk^##_(RyF}I#z>$]ZQ,'9Dy#1* *UK#y8mB#H0D# s **n$#PK##Sj###+##PK########|H############ f ###manifest.rdfn f0#~## A2:2#~#~#~#~#~#~#~.A########t I7 #[#?#?#?#?#?#?#?`i#a)/LVAb8T# ZJ{#SWH!A>&[ C##rXvy6t;/6a|VoI1(,76=t=X#oU#;uX3| lIF}%o#6mrQOf}d,v=|p[_~g#["S9QO6#F#o  #Mo?R&? { ##xS?#Wl50ebc/#Mw}xz#rT{ { } I5#cMY59u ?#};##8#C7!m%J##;RR| {u[$####co#C#.:`##@2#.2=G_8? ##0_;9gYLHt#/ # #  # #@###B|O99 pir2)# v#.##yy7!#p#9R4xB5#(#:#Fxm:eCx#)g#6>##h3F #? G!'#G2#_ .8 z#=odK7##QYr#| eN##\\8D#9 C #0Par;"t_VH3##4##45#,#\\l/4_4SO# #b~yyS#H;'56S0loRo6fak#pru2\\ugQ 3 # K##? eX###W#v#[#k0r#h#*%#####}W#"#P##J#45# Ak#4CG7F##  #~S@_w53#@#qgw###>c'fD  5J6#U#_gkM(//5BG)RV "[+gI8Em3#EX## l#1#5k# 0Dr#5Ez##EI# p=dn ##Qx %B7V#PK##8f| ###U##PK########|H################META-INF/manifest.xmlTKn ###fU8YT #P#`X!F:#r @##6####Eu?Rehx#u###u1B#LYLGZ4#`Hy# -:##$esJ#x9# # q #a#9p`5g^b2# # # owyD2b #5g+;#?##PK####"###E###PK########| H################content.xml}rH~#%kU X$Kj*m##+2$F@##}?/# ##@#### -.' {xOx:oNF;7'  3: g;Y#t#]}ssm   ? #&8w>###3w#S0wY#wz#^:#?KG}##O3! ##gg,idsb32#c~ m# wIrx Cc#Y]x2{3{ [~' ,y_T)gV0b#ry#g/# ? #"e#kt#Sox;ORoXfy 3 zG`"Q"6#~#Ytys?M| v@f##&!3,\\/ #?26m{#d`W{i ? 9###6yi#[a|#3 #vF%to OwF0# #yZ#fY#v%xfxjMy#dMb_ ?O 8yzO|cN#x#7]e. /# m#a # ;kB:S2o 0~#-*k#~7G =qhG)# x#?8>q [r#ZPJkZ#jeLSx;''w,B&v  }z#? /;IkQVS'6uOXzeM# _:(qx,aYm3CI#)! tat:##7[9##8*X#l\\iK##8#ca#K[#%A8"###Fu^#w{#lB#+m#WH$s###FmUt@I U#/}q#=fOD#0####8[#o)#a#`Ed#3J###xEJFv]eYR #,m & Lv#h| _##%IJe{'\\K\\0^bP#|#K\\5fyf R$>KR$## k###}_9z^5orlf;;/yH#Nw&it L#k(g#>=:Y#si#{aTGX3#v*_d9;#X3X*#w##*I_z9{ C#>m#W#e+J^efw^ I#D2# z ]eit:S# U=lWLS8 +}\\ 6#XZ##m7no\\o#o0wa}/\\Zw~m#m T#\\~F#mhg%y#fKq^%)$%l#L{}{O##tA#aJ=~-k 3e|Ke ? #ZL#nz1:{.#oN@_k#|pMNN# -I'x^lnX;##GZf"K#v#dgHf#iM%#v#}a}(z#z#Zw&{ ?{^? E*=])S gny #=WCmBB#I AEhd NK"*Z4]P  V=WDt"wrv/T##)UCyZvDi_Fw#q p>#*#[BfnbOM`s mPo_#Vw3 m? _#)T##a=5Fi#zmYab##1#GM!|;>#O\\O-##[ Df7%B#,#+w#(##z8a#@& #Lf#T#2#Q###X I#~V#h#4Y#q##8E,#]#K@/#  @ bp/#Nl13#)#Lu }|#1#SY#\\b! #YPQx#Q~c5Z$#-ZEq#$# #UD AajU@!lmTv#m## h$,#JEl##;Vc[# i ##c# .#c##g3Y#x.7UG bn#j#"####j #4KqX #P`(L###5#(F #P #j#Bp}#>dnDYhc#B]##^0a,IL#####[tJXr##}R'WL# iHy#Q#Dm6\\#Ds6-V#" # Z68N#U+h &`#K+ `#Bm#3l'C##L#x#C#[#^2 4T#mZ-#$LK 3u#;a#c])9t@R#f`##V#?z#7E#[ 7d#& W #Q:#^?_0fpEDs@ }la`#Tfgt'%4#Rbs\\=v# `##cd5#yyA##@)#P%T,R(##C!|6~ O[f#T/*g [.#J ? e $0ByA#di$R##  H# #k##9 #C$b3CHHT775"#| #(/*#m$U[#E#  :& E#9W:#S %j'#B#!;eBvS###ium-,be,W##V-h~###X0"###S####O:#| =1P_T0cc ##]:dg#d#l5V j#[# #~Y##z##i#A ###;f %0[#Z#Ul[b!Rd4gtqx-#wQ:nCR#r`Ey#? ##(,~X!#]# UqrE#*TH[  h#o Z#j##]]z;7x'/N w!pKH#=`m#N#9bp0!4!#C#LRZ#Z@-#s#w#W#% $X#T#/3OVS[N&4#.Q#eRK#2(2#b#X\\pa\\`(0TU _@Y&6:Ta;6T#Add#J`W= nL ZH0#x/HDB#G}O_k:!#lL# @F txq LdG#GQlM#@####2r2#Hjp# K#)f?>v6P)#sX## %].#;[p##UM\\#B)0z 8*#3[#eJcJuC#y^##yl0 #J2 %c#"#e\\`Bpm|#iQW#kt2r#+TOV9V3`+#d+Q~2t ###$##}T#;YqMH## #(40J,{##RXs#Ymm&b"#k[R D*#]Fm]?$#K#W# M# }LP#F#(Y`Q#&U&OHU"T## $#j4~_agCb`{1S#x-7SS#,bWb #;#lk` #~U#H\\zs?cB####Zu/####@ h2KoI2#56J ##*#-! C*: #####L#`#[d5'# P#^ gFK7C*"a #h#,bP3###G##* vo#'[Pi#NzLh##r#~j#K$| #l# 8##UK[## X#05#SU;#&1# xn#o###!  C#=.oix0f##B@J#;| Rr+WfhX3#a?#5bl9urz6LZO{ D>#aP]e^#L^##]:vC(a\\7|e8wK.=2# ##A8(Jv3#d/# *m*#9xB75e#`5SR}C#mEI@V# Bxo###2*,WQ6[ h1"#;9:##w}#D9l}*T3z72LkVEnZ0#E 3? 2T#o,McMeoN^mU^]*7/N?^'~xg##e{hQ| z#Wk;|E+I~WP#GnO$##RJ j#H 2 ###2 2$#Ly 7 >^k_/^c/&Jf5N,4#| ==#6~g#/K&2=!#TN#q3"@*2UO4#QJ###H#B6? r$`w###vN*#"|^e#>##.y -1W##@G{#AC ?#V#Aqe#? nDp]  g ~>=##4#!#b#R Q&\\A&

##~=\\z^#,%_7E4;at#Kx#L\\#g#6bst#?_ow K,^#R

%#K&c$Yxdb[:#3G#3=e[#4~LP _m#eoT~t6U|.1GpolbvO#%##Spl ##_i#P##~#h#x ?#X`fYT&;4i&M 2 #l,%7iV##6# ,hd=2LV$#0###BSx #6 bd0'K###* #4 G ##}~####?IJjP#loFWC[R#e#g##;d\\_#~u#)6*@a~rA# #w7HN* *%r`Z%cg7[E#M4[[## [a=El6Zn#6.b/+ W#1#2#S(o f=~  pPJ0XC#wT0rf9q ;#{#  ##,###g- ##t#KT#oC#4 V j%WP+%VV]2]%JDT0Uxm@%STw#{C %P%"*#wC_I#U2RJJ('#+)Z`# w4/}i]iFER _ 62G ,RR#J#3i  #9I&R#Ra##B)3| +%JiHY)7Yz*##IJiFdO(#"lkYF{#L#JiJ8#JYG)I){RE'#I#OB)[##V WL#s$#HZ_R qJ)H\\`#2Jry q4*H9]:}'# #\\#U#M###^&[NPx#\\ (y9#V1O9hsH8eQ m4 TQ8#`,-##*Z#)W!###N#Ikq#6#e1?]@z 5I>u ? _#XT?#/#2?A&~*Q)*`#k#;y jv%#x#t##uAjs*Tj#88:Jq)1dW:#Yxdb[:ZG#8g9D<.p uo>[#P#GC#^O)(#G###8#p4h0%#Tk;T#yB##Mz#|M)uuS[J=m-jS(_##?*&*)#]#d#J# ###XL#XLQ>#,&XL`1bj#S###5 NWW#hxg#o#'% [O$##0#!_.#X300&'#[  ##s#|))`a" K#$ OC#;ZG#d# #0+uaVZ##rJJYY##f#1##fY# RWf#QA-^e#U#*X#XV*###l#*r*#}XAJ)H@J#RuS@J+2! "tL##&e##`R$Iq ?vSRP#:"eI @H##"#H#RVS@HQ#Fu@#:]I*ykb#2uATjJ{? `S&MQM"#Ll+]#JP#P##B#1##BP#R#BL8%"za KO?# #I4h3g#0 G##K#c#c####1##c#R5iP ? CU %^`*##atsK## D-M'21Cls#iLMJuP#? L)u=unod#IkV#Ei^? ^#/p56v4"q9KxIy.7#"o 7#cXc}5`#\\>q#rO3L =

<>