Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Do not know how to answer this question. Save . Off) H K v v CA_Computerized_Excel_Workbook(2) (1).xisx - Excel Home Insert Draw Page Layout Search

Do not know how to answer this question.

image text in transcribed
Save . Off) H K v v CA_Computerized_Excel_Workbook(2) (1).xisx - Excel Home Insert Draw Page Layout Search Formulas Data Review View Help Geneva 10 AA General BIDA Insert ard $ % 9 Conditional Format as Cell Delete Font Alignment Formatting Table Styles Format Number D . X fx 1973715.17 Styles Cells Do Costs of Goods Sold B EXPENSES 11,557,835.23 11,557,835.23 10 repairs and maintenance 11,557,835.23 00 Sales commissions expense 00 FICA tax expense 1,973,715.17 771,665.60 1,973.715.17 00 Medicare tax expense 244,654.68 1,973,715.17 00 FUTA expense 771,665.60 00 SUTA 57,217.61 771,665.60 244,654.68 57,217.61 244.654.68 00 Utilities expense 22,176.00 7,392.00 57.217.61 Irrigation & waste disposal expense 325,954.67 22,176.00 7,392.00 00 Landscaping expense 230,910.91 325,954.67 22,176.00 00 Advertising expense 42,475.69 230.910.91 325,954.67 230.910.91 00 Marketing expense. 295,944.33 00 Festivals & competitions expense 192,865.67 295.944.33 142,475.69 00 Telephone expense 238,654.75 295,944.33 192,865.67 00 Internet & computer expense 37.584.73 238,654.75 00 Postage & shipping expense 00 Legal & accounting fees 14.475.00 37.584.73 100 Other consulting fees 35,117.66 14,475.00 office supplies expense 12,500.00 88,425.50 35.117.66 88,425.50 00 Data processing expense 58,689.68 00 Depreciation expense 9.743.89 12 500.00 100 Travel ar 200 828 1 9,743 58,689.68 9.743.89 Other insurance expense 1,200,828.16 169,405.86 1,200,828.16 00 Medica 169,405.86 192.154.80 115,058.55 workmen's compensation insurance 00 Other employee benefits expense 75,643.90 139,750.00 192 154.80 Dues & subscriptions expense 10 Federal income tax expense 32,076.00 155,146.90 175,643.90 139,750.00 187.222.90 175,643.90 187,222.90 10 Property tax expense 857.595.76 19,875.00 857.595.76 Repairs and maintenance 71.974.93 19 875.00 le expense 71.974.93 000 Lease expense 0 Bad debt expense 113,607.56 10,989.33 81,493.45 Miscellaneous expense 26,665.63 0.00 124.596 89 000 Interest expense 359.969.78 26,665.63 359,969.78 26,665.63 Sub-totals 359,969.78 Net Income (Loss) 166,136.23 166,136.23 166,136.23 20.404. 145.98 22,370,058 19 55,281,828 73 55,453,070 43 TOTALS 52,560,702 98 52,560,702.98 77,717,981.72 77,717,981.72 66, 136.23 75,685,974.71 77,823, 128.62 22 370,058.19 22 370.058 19 56,281,828.73 57.418,982.64 Income Statement Y-E Worksheet Balance Sheet Sales Commissions Payroll Journal What ... +4 Average: 252,007.97 Count: 33 Sum: 8,316,262.92 Type here to search O e X B DELL F6 F7 F8 F10 F11 F3 F4 X @ # O 2 3 4 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing The Art and Science of Assurance Engagements

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Joanne C. Jones

13th Canadian edition

133405508, 978-0133405507

Students also viewed these Accounting questions

Question

Would you investigate to learn more about this Club? How?

Answered: 1 week ago

Question

1

Answered: 1 week ago