Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Within This I have a file that is mostly Completed I am just unsure of how to accomplish the final worksheet the Statement of Cash
Within This I have a file that is mostly Completed I am just unsure of how to accomplish the final worksheet the "Statement of Cash Flows" If I could receive help It would be appreciated. I know that I take the Net income then Adjust with Depreciation so in this case Accumulated depreciation building and furniture-warehouse and accumulated depreciaiton building and furniture-office but then after that I am lost. Thanks, Travis.
Davenport University: ACCT202 Project - Part II Part II Worksheet Completion & Financial Statement Creation a. Within this workbook there is a workbook labeled "Worksheet". The unadjusted trial balance information, as well as the adjustment data, have already been entered into the worksheet. You need to complete the worksheet in its entirety. b. After you've completed the worksheet from requirement "a" you need to create a Multi-Step Income Statement, Statement of Retained Earnings, Classified Balance Sheet and Statement of Cash Flows. These financial statements are being prepared for the fiscal month ending May 31st. Additional information folows: -For the Statement of Retained Earnings, assume a beginning balance in the Retained Earnings account of $366,000. Also assume that $345,500 of dividends were declared. -For the Classified Balance Sheet, assume that the company only has common stock and that the value of common stock at par value equals $30,200. Further assume that the value of paid-in-capital excess of par on the common stock has a value of $1,560,000. -For the Statement of Cash Flow assume that the company purchased equipment with $200,000 cash. The company sold land and received $429,000 in cash. Also assume the following ending balances from the last financial period: Cash: $345,091; A/R: $525,000; Inventory: $836,000; Office Supplies: $5,000; A/P: $675,800. Additionally, the company paid cash dividends during the period of $345,500. Create the Statement of Cash Flow using the Indirect Method. -There are blank workbook forms for each of your financial statements. Build your financial statements within these workbook spaces. Auto Zone Income Statement Revenues: Sales 1067500 Cost of Goods Sold 641700 Gross Profit 425800 Operating Expenses: Wages Expense (Hourly Workers) 10000 Salaries Expense (Exempt Staff) 32100 Marketing Expense 64000 Travel & Entertainment Expense 1250 Bad Debt Expense 2415 Property Tax Expense 1455 Office Maintenance & Repair Expense 0 Legal Expenses 6340 Insurance Expense 3500 Utilities Expense 2000 Office Supplies Expense 735 Telecommunications Expense 754 Depreciation Expense- Equipment and Furniture- Warehouse 775 Depreciation Expense- Equipment and Furniture- Office 825 Operating Income 126149 299651 Other Income (Expenses): Rent Revenue Interest Revenue Net Income 2143 -12200 -10057 289594 Auto Zone Statement of Retained Earnings Retained Earnings, beginning 20500 Add: Net Income 289574 Total 310074 Less: Dividends Retained Earnings, ending 0 310074 Auto Zone Balance Sheet ASSETS Current Assets: Cash 250,000 Accounts Receivable 280,000 Allowance for Doubtful Accounts -14,915 Merchandise Inventory 265,085 740,000 Office Supplies 1,565 Prepaid Insurance 3,500 Total Current Assets 1,260,150 Property, Plant and Equipment: Land 1,628,803 Building 1,000,000 Accumulated Depreciation- Building Equipment and Furniture- Warehouse Accumulated depreciation- Equip. & Furniture- Warehous Equipment and Furniture- Office Accumulated depreciation- Equip. & Furniture- Office -700,000 300,000 7,900 -6,418 1,482 7,421 -2,825 4,596 Total Property, Plant and Equipment 1,934,881 Total Assets 3,195,031 Liabilities and Stockholders' Equity Liabilities Current Liabilities: Accounts Payable 800,000 Interest Payable 2,500 Unearned Rent 5,257 Total Current Liabilities Long Term Liabilities Notes Payable Bonds Payable 807,757 200,000 90,000 Mortage (warehouse) Payable 197,000 Total Long Term Liabilities 487,000 1,294,757 Stockholder's Equity Common Stock Pain In Capital in Excess of Par Total Paid in Capital Retained Earnings Total Paid in Capital and Retained Earnings Less: Treasury Stock 30200 1560000 1,590,200 310074 1,900,274 0 Total Stockholders' Equity 1,900,274 Total Liabilities and Stockholders' Equity 3,195,031 Auto Zone Statement of Cash Flow Net Income AdjustmentsStep 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