Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The first pic is the question, others are references. Do as much as u can. Ok just create a common size balance sheet 1. You
The first pic is the question, others are references. Do as much as u can.
Ok just create a common size balance sheet
1. You will now use some of the skills you have acquired in this chapter to prenare a business letter to Samuel Lucas, the owner of Sam's Softball City. The purpose of the letter is to provide a summary of the first two months of operation. The steps you should take are outlined below: A. Return to Simply Accounting and load Sam's Softball City 8. B. Choose Reports, Financials, Balance Sheet. Display the balance sheet for May 31. (Do not check the Comparative Balance Sheet option.) C. Export the balance sheet to Microsoft Excel. Use steps similar to the ones you used for the income statement. (See pages 286-287.) D. Use Microsoft Excel to prepare a common-size balance sheet for Sam's Softball City. Balance Sheet File Options Help Comparative Balance Sheet ASSETS As At 5/31/01 As At 4/3001 Change Current Assets Bank AR-Chatham Steelers AR-Infield Flyers AR-Remdal Red Sox Supplies Total Current Assets 11,268.30 5,243.00 0.00 535.00 2,484 00 19,528 30 38,700 25 0.00 221.00 535.00 7 479.00 46935 25 -27 433 95 5,243 00 -221.00 0.00 -4995.00 -2740695 Fixed Assets Equipment Total Fixed Assets 36,991.08 36 991 08 31 996 08 31 996.08 4,995.00 4.995.00 TOTAL ASSETS 56,519.38 78,931.33 -22,411.95 LIABILITIES 0.00 Current Liabilities Bank Loan APCannon Sports AP-Cell Tel AP-Eastern Electric AP-Ewert Equipment AP--Pro Motion Advertising AP-Sandhu Sporting Goods GST Payable GST Recoverable GST Owed Total Current Liabilities 35,000.00 0.00 0.00 1,495.86 12,425.50 1,444.50 0.00 35,000.00 10,844.40 0.00 0.00 23,425.50 1,444.50 2,645,00 -10,844.40 0.00 1,495 86 -11,000.00 0.00 -2,645.00 605.50 2,540.09 3,145.59 -19,647.95 745.50 -427.98 140.00 -2.968.07 31752 50.683.38 -2.828.07 70 331 33 TOTAL LIABILITIES EQUITY 50,683.38 70,331 33 -19,647.95 Samuel Lucas, Capital Opening Capital S. Lucas, Drawings Current Earnings Ending Capital 20,000.00 -6,000.00 -8,164.00 5,836.00 20,000.00 -3,000.00 -8,400.00 8,600.00 0.00 3,000.00 236.00 -2,764.00 TOTAL EQUITY 5,836.00 8,600.00 -2,764.00 LIABILITIES AND EQUITY 56,519.38 78,931.33 -22,411.95 Expenses by Account Other Expenses by Account 4/1/01 - 5/31/01 Expenses 5010 Advertising Expense 5040 Rent Expense 9,000.00 (43.24%) 5040 Rent Expense 5060 Utilities Expense 35070 Wages Expense LOX me Income Statement File Options Help 4M/01 to 5/31/01 REVENUE Rental Revenue 12,650.00 12,650.00 TOTAL REVENUE 12,650.00 EXPENSE Advertising Expense Bank Charges Miscellaneous Expense Rent Expense Telephone Expense Utilities Expense Wages Expense 1,350.00 250.00 48.00 9,000.00 168.00 1,398.00 8,600.00 20,814.00 TOTAL EXPENSE 20,814.00 NET INCOME -8,164.00 FIGURE 8.18 Data for creating a pie chart for Sam's Softball City Expenses by Account Select the expenses to be shown individually on the graph. All other expenses will be put into the category 'Other Expenses'. Start: 4/1/01 Finish: 15/31/01 Select Expenses... 5010 Advertising Expense 5020 Bank Charges 5030 Miscellaneous Expense 5040 Rent Expense 5050 Telephone Expense 5060 Utilities Expense 5070 Wages Expense I Include inactive accounts Select All I OK Cancel Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started