Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Net income, $137,400 PR 4-1A SHOW ME HOW EXCEL TEMPLATE Beacons Company maintains and repairs warning lights, such as there found on radiocomberi Nighthouses,

image text in transcribed
image text in transcribed
1. Net income, $137,400 PR 4-1A SHOW ME HOW EXCEL TEMPLATE Beacons Company maintains and repairs warning lights, such as there found on radiocomberi Nighthouses, Beacons Company prepared the wingend or period preadsheet at December 31, O 1.2.3 20YS, the end of the fiscal year Beacons Company End-of-Period Spreadsheet For the Year Ended December 31, 2015 Unadjusted Adjusted Account Title Trial Balance Adjustments Trial Balance Dr. Dr. CA 8 Cash 10.800 Accounts Receivable 10.000 10 Prepaid Insurance 38,900 9,100 48.000 4,200 11 Supplies 3,150 1.000 2.730 12 Land 2,180 550 98.000 30.000 13 Building 400,000 400.000 14 Accum. Depr. --Building 205,300 12.000 15 Equipment 217.00 101.000 101.000 16 Accum. Dopr. -Equipment 85,100 4,000 89,900 17 Accounts Payable 15,700 15,700 18 Salaries & Wages Payable 5.000 5.000 19 Unearned Rent 2,100 1.000 20 Common Stock 75,000 75,000 21 Retained Earnings 128,100 128,100 22 Dividends 10,000 10,000 23 Fees Earned 363,700 9.100 372,800 24 Rent Revenue 1,100 25 Salaries & Wages Expense 158,100 5,000 163,100 26 Advertising Expense 21,700 21,700 27 Utilities Expense 16,400 16,400 28 Depr. Exp. --Building 12,000 12,000 29 Repairs Expense 8,850 8,850 30 Depr. Exp.-Equipment 4,800 4,800 3,150 3,150 31 Insurance Expense 2,180 2,180 32 Supplies Expense 4,320 33 Misc. Expense 4,320 875.000 875,000 37330 37330 34 905,900 905.900 35 1,100 1,100 ter 4 The Accounting Cycle Instructions 1. Prepare an income statement for the year ended December 31, 2045. 2. Prepare a statement of stockholders' equity for the year ended December 31, 2045. During the year, common stock of $25,000 was issued. 3. Prepare a balance sheet as of December 31, 2045. 4. Based upon the end-of-period spreadsheet, journalize the closing entries. 5. Prepare a post-closing trial balance

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_2

Step: 3

blur-text-image_3

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

Research On Professional Responsibility And Ethics In Accounting Volume 24

Authors: Charles Richard Baker

1st Edition

180071758X, 9781800717589

More Books

Students also viewed these Accounting questions