50.1K

Verified Solution

Link Copied!

Solid Footing ACP. I'm having trouble getting my Income Sheet & SEquity page to balance along with my balance sheet. I managed to have my preclosing sheet to balance properly. Can someone please help me with this?

Lenny's Lawn Service, Inc. - General Ledger CAUTIO Enter amounts into t typing in the amounts Do NOT copy cells fro Journal into the accou Account # 100 Cash Journal Page # Debit Credit Balance Beginning Balance 38,250.00 35,000.00 80,050.00 1 1 1 1 1 1 1 45,900.00 500.00 6,000.00 6,500.00 3,500.00 2019 Month-Day 7-1 7-1 7-1 7-1 7-1 7-7 7-10 7-12 7-14 7-15 7-19 7-20 7-21 7-23 7-25 7-27 7-27 7-28 7,500.00 38,250.00 Dr 73,250.00 Dr 153,300.00 DE 107,400.00 DI 106,900.00 Dr 100,900.00 Dr 107,400.00 DI 110,900.00 DI 103,400.00 Dr 106,095.00 Dr 85,095.00 Dr 115,095.00 Dr 108,245.00 Dr 130,745.00 Dr 131,245.00 Dr 135,045.00 Dr 133,865.00 Dr 128,565.00 Dr 106,065.00 DI 2,695.00 2 2 2 2 2 2 2 21,000.00 30,000.00 6,850.00 22,500.00 500.00 3,800.00 1,180.00 5,300.00 22,500.00 7-31 Account # 105 Accounts Receivable GL Rev-Exp Trial Bu GL Liab-Equity GL Assets Journal A Directions Trans Chart Accts Account # 105 Accounts Receivable Journal Page # Debit Credit Balance Beginning Balance 33,500.00 2,695.00 1 1 2019 Month-Day 7-1 7-3 7-12 7-15 7-20 7-25 7-31 3,500.00 2,695.00 30,000.00 33,500.00 Dr 36,195.00 Dr 32,695.00 Dr 30,000.00 DI 0.00 Dr 2,800.00 Dr 22,100.00 Dr 2 2 2 3 2,800.00 19,300.00 Account # 110 Supplies Journal Credit Balance 2019 Month-Day Page 7-1 Beginning Balance Debit 4,375.00 21,000.00 4,375.00 Dr 25,375.00 DI 21,400.00 Dr 2 7-19 7-31 3 3,975.00 Account # 150 Equipment Credit Balance Journal Page 2019 Month-Day 7-1 7-1 Beginning Balance Debit 48,000.00 45,900.00 48,000.00 Dr 93,900.00 Dr 1 GL Rev-Exp Trans Directions Chart Accts GL Assets GL Liab-Equity Journal Account # 155 Accumulated Depreciation Journal Page # Debit 2019 Month-Day 7-1 7-31 7-31 Beginning Balance Credit 18,000.00 1,000.00 765.00 Balance 18,000.00 CM 19,000.00 CM 19,765.00 Cr 3 3 Account # 200 Accounts Payable Journal Page # Debit Credit Balance Beginning Balance 2019 Month-Day 7-1 7-15 7-17 7-27 2 0.00 1,180.00 645.00 0.00 Cr 1,180.00 Cr 1,825.00 Cr 645.00 Cr 2 3 1,180.00 Account # 205 Wages Payable Journal Debit Credit Balance Page # 2019 Month-Day 7-1 7-31 Beginning Balance 0.00 2,575.00 0.00 Cr 2,575.00 Cr 3 Account # 210 Interest Payable Journal Pago # Debit Credit Balance 2019 Month-Day 7-1 7-31 Beginning Balance 0.00 785.00 3 0.00 Cr 785.00 Cr Account 215 Directions Unearned Revenue Trans Chart Accts Journal GL Assets GL Liab-Equity GL Rev-E Account # 215 Unearned Revenue Journal Page # Debit 2019 Month-Day 7-1 7-23 7-31 Beginning Balance Credit 8,000.00 22,500.00 Balance 8,000.00 Cr 30,500.00 Cr 22,500.00 Cr 2 3 8,000.00 Account # 220 Dividends Payable Journal Page Debit Balance 2019 Month-Day 7-1 7-5 7-31 Beginning Balance Credit 0.00 22,500.00 1 0.00 C 22,500.00 Cr 0.00 Cr 22,500.00 Account # 250 Note Payable Journal Debit Credit Balance Page 2019 Month-Day 7-1 7-1 Beginning Balance 0.00 35,000.00 0.00 Cr 35,000.00 Cr 1 Directions Trans Chart Accts Journal GL Assets AGL Liab-Equity GL Rev.Exp Account # 300 Common Stock Journal Page # Debit Credit Balance 2019 Month-Day 7-1 7-1 Beginning Balance 50,000.00 80,050.00 1 50,000.00 Cr 130,050.00 C Account # 305 Retained Earnings Journal Page # Debit Credit 2019 Month-Day 7-1 7-5 Beginning Balance 48,125.00 Balance 48,125.00 C 25,625.00 C 1 22,500.00 Directions Trans Chart Accts Journal GL Assets GL Liab-Equity GL Rev-Exp Tri Account # 400 Service Revenue Do NOT copy Journal into th Journal Page # Debit Balance Beginning Balance 2019 Month-Day 7-1 7-3 7-10 7-25 7-27 7-31 7-31 Credit 0.00 2,695.00 6,500.00 3,300.00 3,800.00 19,300.00 8,000.00 0.00 CE 2,695.00 Cr 9,195.00 C 12,495.00 Cr 16,295.00 C 35,595.00 Cr 43,595.00 C Account # 500 Supplies Expense Journal Page # Debit Credit Balance 2019 Month-Day 7-1 7-15 7-31 Beginning Balance GON 0.00) 1,180.00 3,975.00 0.00 Dr 1,180.00 Dr 5,155.00 Dr Account # 520 Depreciation Expense Journal Page # Debit Credit 2019 Month-Day 7-1 7-31 7-31 Beginning Balance Balance 0.00 Dr 1,000.00 Dr 1,765.00 Dr 0.00 1,000.00 765.000 3 3 Account # 550 Interest Expense Journal Page Debit Credit Balance 2019 Month-Day 7-1 7-31 Beginning Balance 0.00 785.00 0.00 Dr 785.00 Dr 4 Lenny's - July 31, 2019 Pre-Closing Trial Balance Account Account Name Debit Credit 106,065.00 22,100.00 21,400.00 93,900.00 CAUTION Enter amounts into the Pre-Closing Trial typing in the amounts. Do NOT copy cells from the General Led 100 105 110 150 155 200 205 210 215 220 250 300 305 400 500 505 510 515 520 550 Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Wages Payable Interest Payable Uneamed Revenue Dividends Payable Note Payable Common Stock Retained Earnings Service Revenue Supplies Expense Mower Repair Expense Wages Expense Truck Rental Expense Depreciation Expense Interest Expense Totals 19,765.00 645.00 2,575.00 785.00 22,500.00 0.00 35,000.00 130,050.00 25,625.00 43,595.00 5,155.00 645.00 28,225.00 500.00 1,765.00 785.00 280,540.00 280,540.00 CAUTION Enter amounts into the Financial Statements by typing in the amounts. Do NOT copy cells from the General Ledger or Pre-Closing Trial Balance. Lenny's Lawn Service, Inc. Income Statement for the Month Ended July 31, 2019 Service Revenue $43,595.00 Operating Expenses: Supplies (3,975.00) Mower Repair (645.00) Wages (25,650.00) Truck Rental (500.00) Depreciation (1.765.00) Total Operating Expenses (32,535.00) Income from Operations 11,060.00 Interest Expense (785.00) Net Income $10,275.00 Note the new line item on Lenny's Income Statement Income from Operations. This is Lenny's income from the normal operations of the lawn mowing business. Interest Expense, which is not a cost of operating the business but rather a cost of financing the business, is shown below Income from Operations. Interest Expense is subtracted from Income from Operations to arrive at Net Income. Lenny's Lawn Service, Inc. Statement of Stockholders' Equity for the Month Ended July 31, 2019 This is the first time you have prepared a formal S Stockholders' Equity for Lenny's. This statement caused the change in Common Stock and in Retair from July 1, 2019 to July 31, 2019. Note that the R column on the statement looks different than the c have been doing each month to determine the Retal amount needed for the Balance Shoot. Beginning starting amount. In previous Retained Earnings ca used Current Balance as the starting amount. Begin is the starting point for this calculation, because Div. as a line item (a deduction) in the Retained Earnings The Ending Balance in the Retained Earnings colur needed for the Balance Sheet Common Stock $50,000.00 80,050.00 Beginning Balance July 1, 2019 Issue Common Stock Net Income Dividends Ending Balance July 31, 2019 Retained Eamings Total $48,125.00 $98,125.00 80,050.00 0.00 (22,500.00) 4 (22,500.00) $25,625.00 - $155,675.00 $130,050.00 GL Assets GL Liab-Equity GL Rev.Exp Journal Directions Trans Chart Accts D16 Jx as of July 31, 2019 Assets Current Assets: Cash $106,065.00 Accounts Receivable 22,100.00 Supplies 21,400.00 Total Current Assets 149,565.00 Property & Equipment: Equipment 93,900.00 Accumulated Depreciation (19,765.00) Property & Equipment, net 74,135.00 Total Assets $223,700.00 Note the following three new sub-totals appea Lenny's Balance Sheet: Total Current Assets is a total of those assets which will turn into cash during the next 12 mo be consumed during the next 12 months. The comparison of Total Current Assets to Total Cu Liabilities gives some indication of Lenny's liqui that is, its ability to pay its bills in the short-term Property & Equipment, net is the amount of F Asset cost, which remains to be depreciated in accounting periods Total Current Liabilities is a total of those liabilities that will require payment in the next 12 months. In the case of Unearned Revenue, this current liability will be "paid-off" by Lenny's delive mowing services to the university. Liabilities & Stockholders' Equity Current Liabilities: Accounts Payable $645.00 Wages Payable 2,575.00 Interest Payable 785.00 Uneamed Revenue 22,500.00 Total Current Liabilities 26,505.00 Long-Term Liabilities: Note Payable 35,000.00 Total Liabilities 61,505.00 Stockholders' Equity: Common Stock 130,050.00 Retained Earnings 35,350.00 Total Stockholders' Equity 165,400.00 Total Liabilities & Stockholders' Equity $226,905.00 GL Assets GL Directions Trans Chart Accts Journal GL Liab-Equity Megan Ramsey Lenny's - July 31, 2019 Post-Closing Trial Balance Account # Account Name Credit Debit 106,065.00 22,100.00 21,400.00 93,900.00 CAUTION Enter amounts into the Post-C typing in the amounts. Do NOT copy cells from the Ge 100 105 110 150 155 200 205 210 215 220 250 300 Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Wages Payable Interest Payable Uneamed Revenue Dividends Payable Note Payable Common Stock Retained Earnings Service Revenue Supplies Expense Mower Repair Expense Wages Expense Truck Rental Expense Depreciation Expense Interest Expense Totals 19,765.00 645.00 2,575.00 785.00 22,500.00 0.00 35,000.00 130,050.00 35,350.00 43,595.00 305 400 500 505 510 515 520 550 0.00 0.00 0.00 0.00 0.00 0.00 243,465.00 290,265.00

Answer & Explanation Solved by verified expert

See Answer