Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please do it in excel.Thanks The condensed comparative statement of financial position and income statement (statements not in proper form) for COSTELLO Inc. as at/
please do it in excel.Thanks
The condensed comparative statement of financial position and income statement (statements not in proper form) for COSTELLO Inc. as at/ for the year ended December 31, 2020, are as follows: COSTELLO INC. Statement of Financial Position December 31, Cash Accounts receivable Interest receivable Notes receivable Inventory Investments - at cost Land Building Accumulated dep-building Equipment Accumulated dep-equip Total assets 2020 21,533 70,267 3,627 45,333 144,160 45,333 25,333 226,667 (108,800) 79,333 (45,333) 507,453 2019 16,667 30,933 1,200 24,667 74,667 21,667 37,333 96,000 (53,333) 59,067 (45,200) 263,667 Accounts payable Accrued liabilities Unearned revenue Income tax payable Dividends payable Loans payable Total liabilities Common shares Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 64,736 11,424 6,667 7.797 10,427 45,333 146,384 108,000 253,069 361,069 507,453 33,067 7,467 8,533 6,667 4,267 33,333 93,333 42,667 127,667 170,333 263,667 COSTELLO INC. Income Statement for the Year Ended December 31, 2020 Sales 812,000 Cost of merchandise sold 351.680 Gross profit 460,320 Salary & admin expense 140,000 Interest expense 5,320 Depreciation expense - building 55,467 Depreciation expense - equipment 27,200 Interest income (8,960) Gain on sale of equipment (3,220) Loss on sale of land 5,600 Income tax expense 51.100 272.507 Net income 187.813 The following is additional information about COSTELLO's transactions during 2020: 1. Land: Land was sold for cash. No land was purchased. 2. Building: No buildings were disposed/sold. A building was purchased for cash. 3. Equipment: Equipment with a cost of $52,000 was sold for cash. Equipment was purchased with a value of $4,667 in exchange for common shares and the remaining equipment was purchased for cash. 4. Investments were purchased for cash Loans were taken out for cash and remaining common shares were issued for cash. 5. The only changes in retained earnings were for net income and dividends. COSTELLO Inc. follows ASPE Required (a) Prepare the entire statement of cash flows in good form for COSTELLO Inc. for the year ended December 31, 2020. Prepare the operating activities section using the indirect method. Ensure you show all your calculations below. (See (b) as well) (b) Provide full calculations for the investing activities section, (c) Calculate for COSTELLO Inc. for the year ending December 31, 2020 (0) Cash received for interest (11) Cash paid for interest (1) Cash paid for income taxes (IV) Cash received from customers 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