Final Exam Review

docx

School

York University *

*We aren’t endorsed by this school

Course

2500

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

4

Uploaded by BaronRoseCaterpillar4

Report
ADMS 2500 - Final Exam Review – Fall 2023 PASS Leader: Nam Nguyen Use the following information to prepare the Cash Flow Statement and answer all questions. You are provided the following data and asked to prepare a Cash flow statement in proper format using the Direct Method. Comparative Balance Sheets of XYZ Manufacturing In. as of Dec 31, 2023. 2023 2022 Cash $ 103,680 $ 18,000 Trade/Accounts Receivables 25,200 35,500 Inventory 40,750 48,900 Investment in shares (long-term) 17,500 20,000 Prepaid Expenses 6,750 8,750 Land 80,400 65,000 Equipment 92,450 88,750 Less: Accumulated Dep-Equipment (17,110) (10,650) Total Assets 274,250 Trade/Accounts Payable $ 66,850 Interest Payable Mortgage Payable Income taxes Payable Dividends Payable Long-term Notes Payable Common Shares Retained Earnings Total Liabilities & Shareholders’ Equity The Income Statement of XYZ Manufacturing Inc. for the year ended Dec 31, 2023. Sales Revenue Cost of Goods Sold
Gross Profit Operating Expenses Loss on Sale of investment in shares Gain on sale of machinery Income before income taxes Income tax expense Net Income Additional Information: 1 Used equipment was sold at a loss of $4,750. 2 Equipment that cost $25,000 was purchased 3 During 2023, a part of the share investment was sold for cash. The gain from this sale was $7,800. During 2023, XYZ made a further investment of 4 Dividends were declared and paid during 2023. 5 A proportion of the mortgage was paid during 2023. 6 Additional land was purchased in cash 7 Assume that trade payable is related to purchases of inventory 8 Operating expense includes the depreciation of $15,000 Prepare Cash Flow Statement using the Direct Method (Indicate all cash outflows using a “-“ sign) XYZ Manufacturing Inc. Cash Flow Statement Year Ended Dec 31, 2023 Operating activities: Cash Received from Customers Received gains (incurred losses) for the sale of equipment Cash Payment to suppliers Cash payments for interest Cash payments for income tax Cash payments for depreciation Net cash provided (used) by operating activities Investing activities Sale of Equipment Purchase of Equipment Net cash provided (used) by investing Financing activities
Repayment of Notes Payable Issue of Long-term Debt Issue of Common Shares Repurchase of Stock Payment of cash dividends Net cash provided (used) by financing activities Net Increase (decrease) in Cash Opening Balance of Cash on Jan 1 Ending Balance of Cash on Dec 31 Financial statement Analysis 1) What is the Working Capital at the end of 2023? 2) Return on Common Equity in December 2023 was: 3) The current ratio at December 2023 was: 4) The accounts receivable turnover in December 2023 was: 5) The equity ratio at December 2023 was: 6) The inventory turnover in December 2023 was: 7) Total return on sales in December 2023 was: 8) The quick ratio in December 2023 was: 9) After performing a Liquidity Analysis, you can say that the company’s situation 10) After performing a Liquidity Analysis, you can say that the company’s trend
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Liability: On January 1 st , 2022, York purchased a machine by making 8 payments of $12,500 at the end of the next 8 years, the interest rate is 7%. The accountant took note that the machine has $4,000 of residual value and has 10 years of expected useful life. Determine the impact on the Investment section of the Cash Flow Statement of the sale of the machine that generated a gain of $100.00 and a loss of $200.00 on April 1 st, 2025. Allowance for Doubtful Accounts: YorkU has been in business for 5 years. The university makes all sales on account and does not offer cash discounts. The firm’s credit sales, collections from customers, and write-offs of uncollectible accounts for 4 years are: (the company uses the sales % allowance method at the rate of 0.75%) Year Sales Collections Accounts Written-off 1 $600,000 $540,000 $1,000 2 $480,000 $380,000 $2,000 3 $880,000 $855,000 $1,500 4 $500,000 $495,000 $4,000 5 $745,000 $700,000 $3,250 Inventory: At the end of December 31, 2023, BlueCheese Merchandising showed the following inventory Inventory, Dec 1, 2023: 45 units @ 12= $540 The following transaction took place in December: Transactions Units Unit Cost Total $$ Dec 8, 2023, Purchase 55 $15.00 $825 Dec 12, 2023, Purchase 30 $14.00 $420 Dec 17, 2023, Sales 40 $30.00 $1,200 Dec 22, 2023, Purchase 80 $17.00 $1,360 Dec 25, 2023, Sales 65 $32.00 $2,080 Calculate the inventory turnover rate using both LIFO and FIFO inventory cost flow and both periodic and perpetual inventory systems.