Final Exam Review
docx
keyboard_arrow_up
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
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.
Related Documents
Related Questions
PLEASE SHOW APPRIPRAITE FORMULA THAT NEEDS TO BE INSERTED
COMPLETE THE STATEMENT OF CASHFLOWS(INDERECT METHOD) BY REFEREING TO THE TWO IMAGES PRESENTED
arrow_forward
help
arrow_forward
need
arrow_forward
Accounting Question
arrow_forward
Use the following excerpts from Algona Company's financial statements and complete the worksheet below to determine cash
received from customers in 2018.
Dec. 31, 2018
$ 85,000
Dec. 31, 2017
$105,000
From Balance Sheets
Accounts Receivable
From Income Statement:
2018
Sales
700,000
PLEASE NOTE: You are to follow the format shown in the textbook.
Cash Collected from Sales Revenue
| Select ]
[ Select )
| Select
[ Select
[ Select ]
[ Select )
[ Select )
[ Select
[ Select]
[ Select )
>
>
>
>
>
>
>
>
arrow_forward
Use the following excerpts from
Brownstone Company's financial
statements and complete the
worksheet below to determine cash
received from customers in 2018.
From Balance Sheets
Accounts Receivable
Dec. 31, 2018
$ 25,000
Dec. 31, 2017
$20,000
2018
220,000
From Income Statement:
Sales
PLEASE NOTE: You are to follow
the format shown in the textbook.
Cash Collected from
Sales Revenue
[ Select ]
[ Select ]
[ Select ]
[ Select ]
[ Select ]
[ Select ]
[ Select ]
[ Select ]
[ Select ]
[ Select ]
arrow_forward
Cash and accounts receivable for Adams Company are as follows:
Prior
Current Year
Year
Cash
$41,208
$30,300
Accounts receivable (net)
26,313
53,700
What are the amounts and percentages of increase or decrease that would be shown with horizontal analysis?
Account
Dollar Change
Percent Change
Cash
Accounts Receivable
ems
(Previous
Next
to search
a.
53°F Sunny
3:28 PM
(中岁
12/14/2021
arrow_forward
How does Accounts Receivable impact Declan's Designs 2022 Statement of Cash Flows?
arrow_forward
Complete the attached excel sheet using the data
arrow_forward
Kimmel, Financial Accounting, 8e
Help I System Announcements
he cash register tape indicates cash sales are $2,000 and sales taxes are $155. What journal entry is needed to record this informati
ractice Question 19
000'
155
O Cash
Sales Tax Expense
1,155
Sales
Cash
000
0000
Sales
D Cash
2,155
000
155
Sales
Sales Taxes Payable
D Cash
2,155
Sales
2,155
ick if you would like to Show Work for this question: Open Show Work
arrow_forward
Current Attempt in Progress
The cash register tape for Marin Industries reported sales of $8,795.50. Record the journal entry that would be necessary for each of
the following situations. (a) Sales per cash register tape exceeds cash on hand by $64.96. (b) Cash on hand exceeds cash reported by
cash register tape by $36.24. (Round answers to 2 decimal places, e.g. 52.75. Credit account titles are automatically indented when amount is
entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. List all debit entries
before credit entries.)
Transactions Account Titles and Explanation
Debit
Credit
(a)
(b)
arrow_forward
Instructions:
Use the below bank account receipts and payments summary to create a
statement of cash flows. Use the direct method and follow the format in your
textbook, chapter 6.
Transaction Description
Date
1/1/20 Cash deposit to start business
1/1/20 Three month's rent
1/1/20 Cash register paid for
1/1/20 Store furniture paid for
1/31/20 Receipts for sales in January 2020
2/7/20 Widgets supplied in January paid for
2/25/20 Cash withdrawn for your own expenses
2/29/20 Receipts for sales in February 2020
3/15/20 Widgets supplied in February paid for
3/16/20 Store utility charges for Jan, Feb, Mar 2020
3/31/20 Receipts for sales March 2020
3/31/20 Balance in bank on March 31st 2020
Receipts
10,000
6,500
9,000
12,000
37,500
Payments
2,400
450
8,500
4,500
3,000
6,000
300
12,350
37,500
arrow_forward
Complete the statement of cash flows for Year 2021 using the indirect method by filing in the spaces.
arrow_forward
Directions: Read each senterce carefully and determine whether the statement is TRUE or FALS E. Write
your answers on the space provided before each number.
1. At the beginning of the day, you have P200 cash in your pocket. At the end of the day,
you have P50 left. If you make a horizontal analysis of your cash, you would conclude that your cash has
decreased by 80% during the day.
2. In 2019, Entity A reported sales of P100 and profit of P20. In a vertical analysis, a
financial statement user would conclude that Entity A was able to generate 20% profit from every peso of
its sales during the period.
3. Entity A reported irventory balances of P100 and P50 in 2019 and 2018, respectively.
In a horizontal analysis, a financial statement user would conclude that Entity A's inventory has increased
by 50% from2018 to 2019.
4. An analysis of the intenelationships of infomation in a single period, expressed as
parcentages of a common denomirator, is called horizortal analysis.
5. A comparison…
arrow_forward
Computing cash flow items—direct method
Consider the following facts:
Beginning and ending Accounts Receivable are $24,000 and $20,000, respectively. Credit sales for the period total of $68,000.
The cost of goods sold is $77,000.
Beginning Merchandise Inventory balance is $29,000, and ending Merchandise Inventory balance is $26,000.
Beginning and ending Accounts Payable are $12,000 and $16,000, respectively
Requirements
Compute cash collections from customers.
Compute cash payments for merchandise inventory.
arrow_forward
Calculate cash balances based on the information provided in the chart below and show me how you did it
Pro Forma Cash Flow
Cash Received
Cash from Operations
Cash Sales
$24,198
$100,099
$122,460
Cash from Receivables
$46,108
$217,218
$342,905
Subtotal Cash from Operations
$70,306
$317,317
$465,366
Additional Cash Received
Sales Tax, VAT, HST/GST Received
$0
$0
$0
New Current Borrowing
$0
$0
$0
New Other Liabilities (interest-free)
$0
$0
$0
New Long-term Liabilities
$0
$40,000
$0
Sales of Other Current Assets
$0
$0
$0
Sales of Long-term Assets
$0
$0
$0
New Investment Received
$0
$0
$0
Subtotal Cash Received
$70,306
$357,317
$465,366
Expenditures
Year 1
Year 2
Year 3
Expenditures from Operations
Cash Spending
$167,000
$225,200
$229,200
Bill Payments
$75,294
$124,114
$152,785
Subtotal Spent on Operations
$242,294
$349,314
$381,985
Additional Cash Spent
Sales Tax,…
arrow_forward
please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste
arrow_forward
Cash Flow from Operating Activities:
$Cash Collected from CustomersCash Payments:
$To Suppliers of Inventory
To Vendors for Operating Expenses
I just need the anwser for "To Vendors for operating expenses" and explaination please? I already had a tutor do the rest of the problem expect for this section. Please read problem below:
se the following excerpts from Victrolia Company’s financial information.
2018 Income Statment
Balance Sheets
Sales
$455,000
Cost of Goods Sold
(221,500)
Operating Expenses, other thanDepreciation Expense
(58,600)
Depreciation Expense
(20,000)
Gain on Sale of Plant Assets
23,500
Net Income
$178,400
Dec. 31,2018
Cash
$329,450
Accounts Receivable
39,750
Inventory
31,000
Accounts Payable
17,550
Accured Liabilities
3,500
Dec. 31, 2017
Cash
$133,500
Accounts Receivable
36,500
Inventory
35,000
Accounts Payable
19,550
Accured Liabilities…
arrow_forward
I need answer of this question solution general accounting
arrow_forward
Classifying inflows and outflows of cash Classify each of the following items as an inflow (1) or an outflow (O) of cash, or neither (N).
Item
Change ($)
+ 1,680
Cash Balance
Accounts payable
+930
+ 1,130
Notes payable
Long-term debt
Inventory
Fixed assets
(Select from the drop-down menu.)
Item
Cash Balance
Change ($)
- 310
- 1,200
+ 1,570
+ 1,000
+ 130
+ 500
Change ($)
- 310
Item
Accounts receivable
Net profits
Depreciation
Repurchase of stock
Cash dividends
Sale of stock
Classification (1/0)
+940
+ 900
+ 900
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Related Questions
- Accounting Questionarrow_forwardUse the following excerpts from Algona Company's financial statements and complete the worksheet below to determine cash received from customers in 2018. Dec. 31, 2018 $ 85,000 Dec. 31, 2017 $105,000 From Balance Sheets Accounts Receivable From Income Statement: 2018 Sales 700,000 PLEASE NOTE: You are to follow the format shown in the textbook. Cash Collected from Sales Revenue | Select ] [ Select ) | Select [ Select [ Select ] [ Select ) [ Select ) [ Select [ Select] [ Select ) > > > > > > > >arrow_forwardUse the following excerpts from Brownstone Company's financial statements and complete the worksheet below to determine cash received from customers in 2018. From Balance Sheets Accounts Receivable Dec. 31, 2018 $ 25,000 Dec. 31, 2017 $20,000 2018 220,000 From Income Statement: Sales PLEASE NOTE: You are to follow the format shown in the textbook. Cash Collected from Sales Revenue [ Select ] [ Select ] [ Select ] [ Select ] [ Select ] [ Select ] [ Select ] [ Select ] [ Select ] [ Select ]arrow_forward
- Cash and accounts receivable for Adams Company are as follows: Prior Current Year Year Cash $41,208 $30,300 Accounts receivable (net) 26,313 53,700 What are the amounts and percentages of increase or decrease that would be shown with horizontal analysis? Account Dollar Change Percent Change Cash Accounts Receivable ems (Previous Next to search a. 53°F Sunny 3:28 PM (中岁 12/14/2021arrow_forwardHow does Accounts Receivable impact Declan's Designs 2022 Statement of Cash Flows?arrow_forwardComplete the attached excel sheet using the dataarrow_forward
- Kimmel, Financial Accounting, 8e Help I System Announcements he cash register tape indicates cash sales are $2,000 and sales taxes are $155. What journal entry is needed to record this informati ractice Question 19 000' 155 O Cash Sales Tax Expense 1,155 Sales Cash 000 0000 Sales D Cash 2,155 000 155 Sales Sales Taxes Payable D Cash 2,155 Sales 2,155 ick if you would like to Show Work for this question: Open Show Workarrow_forwardCurrent Attempt in Progress The cash register tape for Marin Industries reported sales of $8,795.50. Record the journal entry that would be necessary for each of the following situations. (a) Sales per cash register tape exceeds cash on hand by $64.96. (b) Cash on hand exceeds cash reported by cash register tape by $36.24. (Round answers to 2 decimal places, e.g. 52.75. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. List all debit entries before credit entries.) Transactions Account Titles and Explanation Debit Credit (a) (b)arrow_forwardInstructions: Use the below bank account receipts and payments summary to create a statement of cash flows. Use the direct method and follow the format in your textbook, chapter 6. Transaction Description Date 1/1/20 Cash deposit to start business 1/1/20 Three month's rent 1/1/20 Cash register paid for 1/1/20 Store furniture paid for 1/31/20 Receipts for sales in January 2020 2/7/20 Widgets supplied in January paid for 2/25/20 Cash withdrawn for your own expenses 2/29/20 Receipts for sales in February 2020 3/15/20 Widgets supplied in February paid for 3/16/20 Store utility charges for Jan, Feb, Mar 2020 3/31/20 Receipts for sales March 2020 3/31/20 Balance in bank on March 31st 2020 Receipts 10,000 6,500 9,000 12,000 37,500 Payments 2,400 450 8,500 4,500 3,000 6,000 300 12,350 37,500arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning