Key Financial Ratios and Analysis Guide
Key Financial Ratios and Analysis Guide
Tony Bell
1
Table of Contents
A Note to Instructors ............................................................................................................. 3
Module 1: Introduction to the Financial Statements .............................................................. 4
Module 2: Recording Transactions ....................................................................................... 14
Module 3: Adjusting Entries and Closing Entries ................................................................... 23
Module 4: Cash ................................................................................................................... 32
Module 5: Receivables ......................................................................................................... 37
Module 6: Inventory Purchases, Sales, Returns and Discounts .............................................. 46
Module 7: Cost of Inventory (FIFO, LIFO, Weighted Average, and Specific Identification) ...... 53
Module 8: Property, Plant and Equipment ........................................................................... 60
Module 9: Liabilities ............................................................................................................ 68
Module 10: Equity ............................................................................................................... 74
Module 11: Statement of Cash Flows ................................................................................... 79
Module 12: Ratios and Financial Statement Analysis ............................................................ 88
All Video Links ..................................................................................................................... 96
2
Module 7: Cost of
Inventory (FIFO, LIFO,
Weighted Average, and
Specific Identification)
[Link]
[Link]
entory_template.xlsx
53
7-1A – FIFO, LIFO and Weighted Average Inventory Records
Lakeshore Ltd. uses a perpetual inventory system and reports the following transactions for the
month of January:
Required:
a.) Prepare inventory records using:
i. The FIFO method
ii. The LIFO method
iii. The weighted average method
b.) Under each of the methods you prepared in part a.) above, compute Sales, Cost of
Goods Sold and Gross Profit.
54
7-1B – FIFO, LIFO and Weighted Average Inventory Records
Riverside Inc. uses a perpetual inventory system and reports the following transactions for the
month of July:
Required:
a.) Prepare inventory records using:
i. The FIFO method
ii. The LIFO method
iii. The weighted average method
b.) Under each of the methods you prepared in part a.) above, compute Sales, Cost of
Goods Sold and Gross Profit.
55
7-2A – FIFO, LIFO and Weighted Average Inventory Records and Entries
Aberdeen Auto Mart uses a perpetual inventory system and reports the following transactions for
the month of May for one of its products:
Required:
a.) Prepare inventory records using:
i. The FIFO method
ii. The LIFO method
iii. The weighted average method
b.) Under each of the methods you prepared in part a.) above, compute Sales, Cost of
Goods Sold and Gross Profit.
c.) Prepare journal entries for May 24 and May 31 under all methods.
56
7-2B – FIFO, LIFO and Weighted Average Inventory Records and Entries
Northhills Super Save uses a perpetual inventory system and reports the following transactions
for the month of December for one of its products:
Required:
a.) Prepare inventory records using:
i. The FIFO method
ii. The LIFO method
iii. The weighted average method
b.) Under each of the methods you prepared in part a.) above, compute Sales, Cost of
Goods Sold and Gross Profit.
c.) Prepare journal entries for December 26 and December 31 under all methods.
57
7-3A – Lower of Cost and Net Realizable Value
On May 3, 2024, Smith Computing (a computer retailer) purchases a tablet computer for $300,
and immediately puts the tablet on sale for $449. The tablet received poor reviews in the press,
and it does not sell. On July 1, Smith Computing discounts the tablet to $399. It still doesn’t
sell. On August 15, the tablet gets further discounted to $349, but doesn’t sell. On December 26
(Boxing Day) the tablet gets discounted to $269. The tablet sells on January 8, 2025 for its
discounted price of $269.
Required
Explain the lower of cost and net realizable value rule and record any necessary year-end
adjusting entries.
Required
Record all entries required for the life of the skis.
58
7-4A – Inventory Ratios
Required:
a.) Compute inventory turnover for 2027 and 2028
b.) Compute days sales in inventory for 2027 and 2028
c.) Comment on the results from parts a.) and b.)
The following information relates to Home DIY Stores (in millions of dollars):
Required:
a.) Compute inventory turnover for 2027 and 2028
b.) Compute days sales in inventory for 2027 and 2028
c.) Comment on the results from parts a.) and b.)
59
Module 8: Property,
Plant and Equipment
[Link]
60
8-1A – Asset Cost
Frugal Bakery purchased a large oven on October 31, 2024. Costs related to the acquisition
included the following:
The company paid cash for the oven and all of the related costs.
Required:
The credit for each of the items above should be cash. In each case identify the account to be
debited
61
8-1B – Asset Cost
Island Glass makes specialty doors and windows. On July 17, 2024, the company purchased a
new piece of equipment with the following costs:
The company paid cash for the equipment and all of the related costs.
Required:
The credit for each of the items above should be cash. In each case identify the account to be
debited
62
8-2A – Depreciation – Partial Year, All Methods
On March 31, 2024, Kemp Co. purchased a new vehicle for $25,000. The vehicle had an
expected useful life of five years, and an expected residual value of $5,000. The company
expected that in those five years, the vehicle would be driven for 100,000 kilometers based on
the following schedule:
Required:
Assuming a December 31 fiscal year-end, prepare a depreciation schedule for the life of the asset
using:
a.) Straight-line depreciation
b.) Units-of-production depreciation
c.) Double-declining-balance depreciation
63
8-2B – Depreciation – Partial Year, All Methods
On July 1, 2024, Payton Inc. purchased a new piece of equipment for $500,000. The equipment
had an expected useful life of four years, and an expected residual value of $100,000. The
company expected that in those four years, the machine would produce 40,000 units based on the
following schedule:
Required:
Assuming a December 31 fiscal year-end, prepare a depreciation schedule for the life of the asset
using:
a.) Straight-line depreciation
b.) Units-of-production depreciation
c.) Double-declining-balance depreciation
64
8-3A – Disposing of Depreciable Assets at a Gain or Loss
Bill’s Towing purchased a new tow truck on April 1, 2024 for $110,000 cash. The company
expects to keep the tow truck for 10 years, after which time it plans to sell the truck for $10,000.
The company’s accountant wishes to use straight-line depreciation. Bill’s Towing has a fiscal
year end of December 31. On October 1, 2025, Bill sells the truck for $106,000 cash.
Required:
a.) Record all relevant entries for the truck.
b.) Assume that instead of $106,000, Bill had received $75,000 for the truck – re-record
the sale journal entry given this new sale price.
Gaby’s Family Restaurant purchases a new stove on July 1, 2024. The company pays $8,000
cash. Gaby expects the stove to be useful for 5 years after which time she expects to sell it for
$2,000. The company has a December 31 fiscal-year end and would like to use straight-line
depreciation. On October 31, 2025, Gaby sells the stove for $7,600 cash.
Required:
a.) Record all relevant journal entries for the life of the stove.
b.) Assume that instead of $7,600, Gaby sold the stove for $3,000. Re-record the sale
journal entry given this new sale price.
65
8-4A – Disposing of Depreciable Assets at a Gain or Loss – various depreciation methods
On July 1, 2024, Table Co. purchased a new piece of equipment for $150,000. The equipment
had an expected useful life of five years, and an expected residual value of $30,000. The
company expected that in those five years, the machine would operate for 2,000 hours.
On September 30, 2026, the company sells the equipment for $100,000.
Required:
Fill in the following table:
Accumulated Dep’n
on Date of Sale
Gain/Loss on Sale
66
8-4B – Disposing of Depreciable Assets at a Gain or Loss – various depreciation methods
On April 1, 2024, Stool Co. purchased a new vehicle for $45,000. The vehicle had an expected
useful life of six years, and an expected residual value of $9,000. The company expected that in
those six years, the vehicle would be driven for 150,000 kilometers.
The vehicle was actually driven for the following kilometers each year:
2024 – 10,000 kilometers
2025 – 20,000 kilometers
2026 – 15,000 kilometers
Required:
Fill in the following table:
Accumulated Dep’n
on Date of sale
Gain/Loss on Sale
67
Module 9: Liabilities
[Link]
[Link]
68
9-1A – Short-Term Note Payable
On September 1, 2024, Taylor Inc. borrowed $30,000 and signed a note promising to pay back
the principal plus 6% (annual) interest after nine months. The company’s fiscal-year end is
January 31.
Required:
Assuming the company makes the repayment as agreed, record all journal entries and
adjustments required for the note.
On May 31, 2024, Anderson Co. borrowed $100,000 and signed a note promising to pay back
the principal plus 2.4% (annual) interest after eight months. The company’s fiscal-year end is
November 30.
Required:
Assuming the company makes the repayment as agreed, record all journal entries and
adjustments required for the note.
69
9-2A – Warranties
Long Corporation sells computer systems for $2,000 each. During 2024 the company sells 200
systems to customers. The company provides a 1-year manufacturer’s warranty. The company
has estimated that it will experience warranty claims of approximately $100 per unit.
Required:
a.) Record the year-end adjustment for warranties needed on December 31, 2024.
b.) On January 15, 2025 a warranty claim comes in costing the company $500 cash. Record
the adjustment required for this situation.
c.) What is a contingent liability? Does a warranty fit this definition?
9-2B – Warranties
Short Corporation sells air conditioning units for $1,000 each. During 2024 the company sells
100 systems to customers. The company provides a 1-year manufacturer’s warranty. The
company has estimated that it will experience warranty claims of approximately $100 per unit.
Required:
a.) Record the year-end adjustment for warranties needed on December 31, 2024.
b.) On January 25, 2025 a warranty claim comes in costing the company $200 cash. Record
the adjustment required for this situation.
70
9-3A – Bond Issued at a Discount
On February 1, 2024, Tinger Inc. issues a $100,000 10-year 5% bond. The market rate of interest
is 6%. Because the market rate is higher than the bond rate, the bonds issue at a discount. The
bond quote is: 92.561. The bonds pay interest semi-annually on February 1 and August 1. The
company’s fiscal-year end is September 30.
Required
a.) Prepare a bond amortization schedule for the issuance and the first two interest periods.
b.) Record the journal entry required on:
i. The issuance of the bond. (February 1, 2024)
ii. The first interest payment. (August 1, 2024)
iii. The company’s fiscal year-end. (September 30, 2024)
iv. The second interest payment. (February 1, 2025)
On November 1, 2024, Terry Co. issues a $1,000,000 5-year 3% bond. The market rate of
interest is 5%. Because the market rate is higher than the bond rate, the bonds issue at a
discount. The bond quote is: 91.248. The bonds pay interest semi-annually on May 1 and
November 1. The company’s fiscal-year end is May 31.
Required
a.) Prepare a bond amortization schedule for the issuance and the first two interest periods.
b.) Record the journal entry required on:
i. The issuance of the bond. (November 1, 2024)
ii. The first interest payment. (May 1, 2025)
iii. The company’s fiscal year-end. (May 31, 2025)
iv. The second interest payment. (November 1, 2025)
71
9-4A – Bond Issued at a Premium
On April 30, 2024, Smokey Inc. issues a $10,000,000 10-year 7% bond. The market rate of
interest is 6%. Because the market rate is lower than the bond rate, the bonds issue at a
premium. The bond quote is: 107.439. The bonds pay interest semi-annually on October 31 and
April 30. The company’s fiscal-year end is December 31.
Required
a.) Prepare a bond amortization schedule for the issuance and the first two interest periods.
b.) Record the journal entry required on:
i. The issuance of the bond. (April 30, 2024)
ii. The first interest payment. (October 31, 2024)
iii. The company’s fiscal year-end. (December 31, 2024)
iv. The second interest payment. (April 30, 2025)
On January 31, 2024, Bandit Inc. issues a $100,000 10-year 5% bond. The market rate of interest
is 4.5%. Because the market rate is lower than the bond rate, the bonds issue at a premium. The
bond quote is: 103.991. The bonds pay interest semi-annually on January 31 and July 31. The
company’s fiscal-year end is December 31.
Required
a.) Prepare a bond amortization schedule for the issuance and the first two interest periods.
b.) Record the journal entry required on:
i. The issuance of the bond. (January 31, 2024)
ii. The first interest payment. (July 31, 2024)
iii. The company’s fiscal year-end. (December 31, 2024)
iv. The second interest payment. (July 31, 2025)
72
9-5A – Computing Bond Issue Price
On November 30, 2024, Jones Inc. issues a $5,000,000 20-year 7% bond. The market rate of
interest is 6%.
Required
On July 31, 2024, Birthday Store Co. issues a $1,000,000 10-year 5% bond. The market rate of
interest is 5.5%.
Required
73
Module 10: Equity
Module Introduction Video:
[Link]
74
10-1A – Equity transactions, Statement of Changes in Shareholders’ Equity
The December 31, 2023 shareholders’ equity section of Bossman Inc.’s balance sheet is shown
below:
Required:
a.) Journalize the transactions above.
b.) Assuming net income for the year was $125,000, prepare the statement of changes of
shareholders’ equity for the year ended December 31, 2024.
75
10-1B – Equity transactions, Statement of Changes in Shareholders’ Equity
The December 31, 2023 shareholders’ equity section of Kamala Co.’s balance sheet is shown
below:
Jan 15 Issued 1,000 common shares for a piece of land with a fair value of $16,000.
Mar 21 Issued 100 preferred shares for $3000 cash.
August 1 Declared the regular cash dividend on preferred shares.
August 10 Paid the regular cash dividend on preferred shares.
November 8 Declared and issued a 10% stock dividend on common shares at a time when the
market price was $18 per share.
Required:
a.) Journalize the transactions above.
b.) Assuming net income for the year was $50,000, prepare the statement of changes of
shareholders’ equity for the year ended December 31, 2024.
76
10-2A – Equity section analysis
The December 31, 2024 shareholders’ equity section of Hart Inc.’s balance sheet is shown
below:
Required:
a.) How much were the preferred shares issued for?
b.) How much were the common shares issued for?
c.) What does authorized mean as it relates to common shares?
d.) What does the term “non-cumulative” mean in relation to preferred shares?
e.) What amount must the preferred shareholders receive before common shareholders can
be paid a dividend?
f.) Assume the company declared and paid the preferred dividend and also paid a dividend
of $2 per common share. Journalize the transaction.
77
10-2B – Equity section analysis
The December 31, 2024 shareholders’ equity section of Hart Inc.’s balance sheet is shown
below:
Required:
a.) How much were the preferred shares issued for?
b.) How much were the common shares issued for?
c.) What does authorized mean as it relates to common shares?
d.) What does the term “cumulative” mean in relation to preferred shares?
e.) What amount must the preferred shareholders receive before common shareholders can
be paid a dividend?
f.) Assume the company has not paid any dividends in 2023 or 2024. On January 15, 2025
the company wishes to pay common shareholders a dividend of $1 per share. How much
must they pay preferred shareholders at that time? Record the journal entry for both the
preferred and common dividends.
78
Module 11: Statement of
Cash Flows
[Link]
[Link]
xlsx
79
11-1A – Basic Cash Flow Statement
The financial statements of Bait and Tackle are presented below:
Additional information:
1.) Operating expenses are composed of: Depreciation $12,000; Salaries $50,000; Loss on Sale of Equipment
$9,000; other operating expenses $64,000.
2.) Other operating expenses are cash expenses.
3.) Equipment was purchased during the year for $135,000 cash.
4.) Equipment was sold for cash during the year. The original cost of the equipment was $60,000, and the
accumulated depreciation was $45,000.
5.) Dividends were declared and paid during the year.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor
assigns).
80
11-1B – Basic Cash Flow Statement
Safety First
Balance Sheet
As at December 31
2024 2023
Cash $2,600 $500
Accounts receivable 500 800
Inventory 2,500 2,300
Equipment 21,000 17,000
Accumulated depreciation (3,800) (3,000)
Total assets $22,800 $17,600
Safety First
Income Statement
For the Year Ended December 31, 2024
Sales $51,000
Cost of goods sold 29,000
Gross profit 22,000
Operating expenses 15,000
Operating income 7,000
Interest expense 100
Income before taxes 6,900
Income taxes 2,000
Net income $4,900
Additional information:
1.) Operating expenses are composed of: Depreciation $1,800; Salaries $12,000; Loss on Sale of Equipment
$400; other operating expenses $800.
2.) Other operating expenses are cash expenses.
3.) Equipment was purchased during the year for $7,000 cash.
4.) Equipment was sold for cash during the year. The original cost of the equipment was $3,000, and the
accumulated depreciation was $1,000.
5.) Dividends were declared and paid during the year.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor
assigns).
NOTE: Download the template from [Link]
81
11-2A –Cash Flow Statement
Simmons Inc.
Income Statement
For the Year Ended May 31, 2024
Sales $425,000
Cost of goods sold 186,000
Gross profit 239,000
Operating expenses 188,000
Operating income 51,000
Interest expense 2,000
Income before taxes 49,000
Income taxes 10,000
Net income $39,000
Additional information:
1.) Operating expenses are composed of: Depreciation $21,000; Salaries $134,000; Gain on Sale of Equipment
$6,000; other operating expenses $39,000.
2.) Prepaid insurance is related to the other operating expenses.
3.) Equipment was purchased during the year for $32,000 cash.
4.) Equipment was sold for cash during the year. The original cost of the equipment was $17,000, and the
accumulated depreciation was $9,000.
5.) Dividends were declared and paid during the year.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor
assigns).
NOTE: Download the template from [Link]
82
11-2B –Cash Flow Statement
The financial statements of Kimmel Inc. are presented below:
Kimmel Inc.
Balance Sheet
As at July 31
2024 2023
Cash $104,000 $123,000
Accounts receivable 78,000 84,000
Inventory 409,000 368,000
Prepaid insurance 15,000 12,000
Building and equipment 704,000 684,000
Accumulated depreciation (219,000) (215,000)
Total assets $1,091,000 $1,056,000
Kimmel Inc.
Income Statement
For the Year Ended July 31, 2024
Sales $931,000
Cost of goods sold 483,000
Gross profit 448,000
Operating expenses 268,000
Operating income 180,000
Interest expense 15,000
Income before taxes 165,000
Income taxes 40,000
Net income $125,000
Additional information:
1.) Operating expenses are composed of: Depreciation $35,000; Salaries $155,000; Loss on Sale of Equipment
$4,000; other operating expenses $74,000.
2.) Prepaid insurance is related to the other operating expenses.
3.) Equipment was purchased during the year for $74,000 cash.
4.) Equipment was sold for cash during the year. The original cost of the equipment was $54,000, and the
accumulated depreciation was $31,000.
5.) Dividends were declared and paid during the year.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor
assigns).
NOTE: Download the template from [Link]
83
11-3A –Cash Flow Statement
The financial statements of Vita Cleanse Inc. are presented below:
Vita Cleanse Inc.
Balance Sheet
As at June 30
2024 2023
Cash $326,000 $385,000
Accounts receivable 120,000 148,000
Inventory 1,325,000 1,105,000
Prepaid insurance 15,000 20,000
Building and equipment 1,591,000 1,659,000
Accumulated depreciation (900,000) (942,000)
Total assets $2,275,000 $2,375,000
Additional information:
1.) Operating expenses are composed of: Depreciation $238,000; Salaries $588,000; Loss on Sale of
Equipment $23,000; other operating expenses $76,000.
2.) Prepaid insurance is related to the other operating expenses.
3.) Equipment was purchased during the year for $276,000 cash.
4.) Equipment was sold for cash during the year. The original cost of the equipment was $344,000, and the
accumulated depreciation was $280,000.
5.) Dividends were declared and paid during the year.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor
assigns).
NOTE: Download the template from [Link]
84
11-3B –Cash Flow Statement
The financial statements of CGP Inc. are presented below:
CGP Inc.
Balance Sheet
As at April 30
2024 2023
Cash $58,500 $18,000
Accounts receivable 40,000 32,000
Inventory 41,000 37,000
Prepaid insurance 1,000 1,200
Building and equipment 67,000 88,000
Accumulated depreciation (31,000) (35,000)
Total assets $176,500 $141,200
CGP Inc.
Income Statement
For the Year Ended April 30, 2024
Sales $125,000
Cost of goods sold 48,000
Gross profit 77,000
Operating expenses 58,000
Operating income 19,000
Interest expense 1,500
Income before taxes 17,500
Income taxes 4,500
Net income $13,000
Additional information:
1.) Operating expenses are composed of: Depreciation $8,000; Salaries $41,000; Gain on Sale of Equipment
$7,000; other operating expenses $16,000.
2.) Prepaid insurance is related to the other operating expenses.
3.) Equipment was purchased during the year for $10,000 cash.
4.) Equipment was sold for cash during the year. The original cost of the equipment was $31,000, and the
accumulated depreciation was $12,000.
5.) Dividends were declared and paid during the year.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor
assigns).
85
11-4A –Cash Flow Statement – Challenging Problem
Brady Inc.
Balance Sheet
As at September 30
2024 2023
Cash $600 $2,000
Accounts receivable 14,000 6,000
Inventory 48,000 24,000
Prepaid insurance 1,000 1,500
Building and equipment 45,500 48,000
Accumulated depreciation (9,000) (7,000)
Total assets $100,100 $74,500
Brady Inc.
Income Statement
For the Year Ended September 30, 2024
Sales $108,000
Cost of goods sold 54,000
Gross profit 54,000
Operating expenses 48,000
Operating income 6,000
Interest expense 1,500
Income before taxes 4,500
Income taxes 1,000
Net income $3,500
Additional information:
1.) Operating expenses are composed of: Depreciation $8,000; Salaries $36,000; Loss on Sale of Equipment $1,000; other
operating expenses $3,000.
2.) Prepaid insurance is related to the other operating expenses.
3.) Equipment was purchased during the year for $7,500 cash.
4.) Equipment was sold for cash during the year.
5.) Dividends were declared and paid during the year.
6.) Unearned revenues are collected from customers.
7.) Paid off $2,000 of long-term note and issued a new note for cash.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor assigns).
86
11-4B –Cash Flow Statement – Challenging Problem
Wilson Inc.
Balance Sheet
As at October 31
2024 2023
Cash $821,000 $580,000
Accounts receivable 375,000 350,000
Inventory 850,000 880,000
Prepaid insurance 30,000 38,000
Building and equipment 3,512,000 3,400,000
Accumulated depreciation (1,940,000) (1,800,000)
Total assets $3,648,000 $3,448,000
Wilson Inc.
Income Statement
For the Year Ended October 31, 2024
Sales $1,500,000
Cost of goods sold 580,000
Gross profit 920,000
Operating expenses 680,000
Operating income 240,000
Interest expense 85,000
Income before taxes 155,500
Income taxes 35,000
Net income $120,000
Additional information:
1.) Operating expenses are composed of: Depreciation $200,000; Salaries $420,000; Gain on Sale of Equipment $15,000;
other operating expenses $75,000.
2.) Prepaid insurance is related to the other operating expenses.
3.) Equipment was purchased during the year for $200,000 cash.
4.) Equipment was sold for cash during the year.
5.) Dividends were declared and paid during the year.
6.) Unearned revenues are collected from customers.
7.) Paid off $100,000 of bank loan and signed a new loan for additional cash.
Required:
Prepare a cash flow statement using the direct method or indirect method or both (depending on what your instructor assigns).
87
Module 12: Ratios and
Financial Statement
Analysis
[Link]
88
Common Financial Ratios
Liquidity
Current Ratio Current Assets
Current Liabilities
Acid-Test Ratio Cash + Short-term investments + Net current receivables
Current liabilities
Turnover
Inventory Turnover Cost of goods sold
Average inventory
Days’ sales in inventory 365 days d
Inventory turnover
Accounts receivable Net credit sales d
turnover Average net accounts receivable
Collection period 365 days d
Accounts receivable turnover
Long-Term Debt Paying Ability
Debt ratio Total liabilities
Total assets
Times-interest-earned Income from operations
Interest expense
Profitability
Gross profit percentage Gross profit
Net sales
Return on sales Net income
Net sales
Return on assets Net income + Interest expense
Average total assets
Return on equity Net income – Preferred dividends
Average common shareholders’ equity
Earnings per share Net income – Preferred dividends d
Average number of common shares outstanding
Stock Market Performance
Price/earnings ratio Market price per common share
Earnings per share
Dividend yield Dividends per share
Market price per share
89
12-1A – Horizontal Analysis
Elky Co.
Income Statement
For the years ended December 31
2024 2023
Sales $168,000 $151,000
Cost of goods sold 90,000 78,000
Gross profit 78,000 73,000
Operating expenses 32,000 30,000
Operating income 46,000 43,000
Interest expense 2,000 3,000
Income before taxes 44,000 40,000
Income taxes 11,000 10,000
Net income $33,000 $30,000
Required:
a.) Prepare a horizontal analysis for the company calculating the change and percentage
change of each line item from one year to the next. (Round your answers to the nearest
tenth of a percent, ie 0.13578 13.6%)
b.) Which item/items in your analysis would you wish to investigate? Why?
90
12-1B – Horizontal Analysis
Dwan Inc.
Income Statement
For the years ended July 31
2024 2023
Sales $580,000 $415,000
Cost of goods sold 285,000 205,000
Gross profit 295,000 210,000
Operating expenses 140,000 80,000
Operating income 155,000 130,000
Interest expense 6,000 5,000
Income before taxes 149,000 125,000
Income taxes 24,000 20,000
Net income $125,000 $105,000
Required:
a.) Prepare a horizontal analysis for the company calculating the change and percentage
change of each line item from one year to the next. (Round your answers to the nearest
tenth of a percent, ie 0.13578 13.6%)
b.) Which item/items in your analysis would you wish to investigate? Why?
91
12-2A – Vertical Analysis
Harpreet Gill is concerned about his company’s financial performance and financial position. He has obtained the
financial statements of his largest competitor, Hossain Inc. and notes that the company is over ten times larger than
his, so it is making the numbers difficult to compare.
Below is condensed financial information from Hossain Inc. and Gill Inc.:
Required:
a.) Prepare a vertical analysis for the companies calculating the relative percentages of each item in the
financial statements. (Round your answers to the nearest tenth of a percent, ie 0.13578 13.6%)
b.) Comment on the common-sized income statements of the companies (prepared in part a.).
c.) Comment on the common-sized balance sheets of the companies (prepared in part a.).
92
12-2B – Vertical Analysis
Required:
a.) Prepare a vertical analysis for the companies calculating the relative percentages of each
item in the financial statements. (Round your answers to the nearest tenth of a percent, ie
0.13578 13.6%)
b.) Comment on the common-sized income statements of the companies (prepared in part a.).
c.) Comment on the common-sized balance sheets of the companies (prepared in part a.).
93
12-3A – Ratio Analysis
Squirrel Co.
Income Statement
For the Year Ended November 30
2024 2023
Sales, net $3,600,000 $3,900,000
Cost of goods sold 1,500,000 1,600,000
Gross profit 2,100,000 2,300,000
Operating expenses 1,600,000 2,000,000
Operating income 500,000 300,000
Interest expense 200,000 150,000
Income before taxes 300,000 150,000
Income taxes 85,000 40,000
Net income $215,000 $110,000
Squirrel Co.
Balance Sheet
As at November 30
2024 2023 2022
Cash $150,000 $53,000 $125,000
Accounts receivable, net 140,000 80,000 55,000
Inventory 450,000 350,000 300,000
Prepaid insurance 35,000 20,000 25,000
Total current assets 775,000 503,000 505,000
Property, plant and equipment, net 600,000 550,000 400,000
Total assets $1,375,000 $1,053,000 $905,000
Additional information:
2024 2023 2022
Market price per share $150 $50 $35
Dividends per share $2.00 $1.00 $0.50
Required:
a.) For 2023 and 2024, compute all “Common Financial Ratios” from the beginning of this module. For each
ratio note whether it is getting Better (B) or Worse (W).
b.) Comment on the financial performance and position of the company.
94
12-3B – Ratio Analysis
Moose Co.
Income Statement
For the Year Ended May 31
2024 2023
Sales, net $2,100,000 $1,600,000
Cost of goods sold 900,000 650,000
Gross profit 1,200,000 950,000
Operating expenses 700,000 525,000
Operating income 500,000 425,000
Interest expense 25,000 20,000
Income before taxes 475,000 405,000
Income taxes 120,000 100,000
Net income $355,000 $305,000
Moose Co.
Balance Sheet
As at May 31
2024 2023 2022
Cash $175,000 $220,000 $155,000
Accounts receivable, net 61,000 150,000 100,000
Inventory 525,000 450,000 400,000
Prepaid insurance 40,000 35,000 50,000
Total current assets 801,000 855,000 705,000
Property, plant and equipment, net 950,000 703,000 750,000
Total assets $1,751,000 $1,558,000 $1,455,000
Additional information:
2024 2023 2022
Market price per share $200 $190 $160
Dividends per share $13.00 $12.00 $10.00
Required:
a.) For 2023 and 2024, compute all “Common Financial Ratios” from the beginning of this module. For each
ratio note whether it is getting Better (B) or Worse (W).
b.) Comment on the financial performance and position of the company.
95
York University AP/ADMS 2500 3.00
Introduction to Financial Accounting
Final Exam for Fall 2019
Time: 3 hours Regular Exam ‐ Version A Questions: 50
Instructions:
1. Submit: Both the pink mark sense sheet and the exam paper will be collected in final exams.
Ensure your name is on all documents. Marks will be deducted if you do not turn in this exam
paper. Record your name and ID# here:
3. Exam Aids:
• Only calculators without alphanumeric programmable memories are allowed. It is
strongly suggested you bring a couple of cheap 4 function calculators to the exam in case
one fails. Be prepared to be challenged by invigilators if you bring a “fancy” calculator.
• Compact foreign language/English dictionaries may be used. However, these will be
examined by invigilators. If there are any loose pages or handwriting in the dictionary, it
will be seized and you will be charged with academic dishonesty. No electronic
dictionaries are allowed.
• TURN OFF YOUR PHONE AND PLACE IT AWAY FROM YOU (not in your pocket)
• In 2500, invigilators answer no questions of interpretation. They will pass along
questions regarding possible errors/typos/missing data to the professors. If you believe a
question contains an error and do not receive a response, make a detailed note on the back
of your pink mark sense sheet and submit it with your paper.
Note – there are blank pages for your rough work found at the end of the exam.
DO NOT UNSTAPLE YOUR EXAM BOOKLET.
ADMS 2500 Final Exam, Fall 2019 © York University Page 1 – Reg A
Questions 1- 45 are based on the following information
(Cash flow statement and Financial Statement Analysis questions)
The income statement for the year ended November 30, 2019, LeDark Corp.
contains the following information:
LeDark Corp.
Income Statement
Year Ended November 30, 2019
Revenue $ 250,000
Cost of goods sold $ (135,000)
Office Supplies Expense $ (12,000)
Advertising Expense $ (45,000)
Amortization Expense $ (40,000)
Results of Sale of equipment $ 7,000
Interest Expense $ (3,000)
Income Tax Expense $ (7,000)
Profit $ 15,000
Additional Information:
1 Equipment that cost $50,000 was sold for a certain amount in cash
2 New equipment was purchased during the year for $47,000
3 Dividends declared in 2019 totalled $5,000
Dividends are treated as financing activities
Please prepare both an Indirect and Direct Cash Flow Statement to answer the questions below.
ADMS 2500 Final Exam, Fall 2019 © York University Page 3 – Reg A
This page is left blank for your calculations
ADMS 2500 Final Exam, Fall 2019 © York University Page 4 – Reg A
Choose the best answer for each of the following 50 questions. There is only one best answer
for each question (2 marks each question).
Questions 1-13 are for the Cash Flow statement prepared using the indirect method.
Q1 What is the Total adjustment to reconcile profit to net cash provided by operations?
A) $ 22,000
B) $ 30,000
C) $ 38,000
D) $ 15,500
E) none of the above
Q5 By how much has the change in Interest Payable generated or (used) cash?
A) $ (1,500)
B) $ 3,000
C) $ (3,000)
D) $ 1,500
E) none of the above
Q6 By how much has the change in Office Supplies generated or (used) cash?
A) $ 5,000
B) $ 0
C) $ (5,000)
D) $ (10,000)
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 5 – Reg A
Q7 By how much has the change in Income Tax Payable generated or (used) cash?
A) $ (7,000)
B) $ (6,000)
C) $ 2,000
D) $ 7,000
E) none of the above
Q8 What is the Net Cash provided or (used) by Operations?
A) $ 37,000
B) $ 30,000
C) $ 50,000
D) $ 45,500
E) none of the above
Q9 By how much have the changes in Working Capital generated or (used) cash?
A) $ (5,000)
B) $ 6,500
C) $ (11,000)
D) $ (6,000)
E) none of the above
Q10 By how much has the change in Accounts Payable generated or (used) cash?
A) $ (8,000)
B) $ 8,000
C) $ 10,500
D) $ 9,000
E) none of the above
Q11 By how much has the change in Accounts Receivables generated or (used) cash?
A) $ (8,000)
B) $ (3,500)
C) $ 3,500
D) $ 8,000
E) none of the above
Q12 By how much has the change in Advertising Payable generated or (used) cash?
A) $ 1,500
B) $ (3,500)
C) $ (1,500)
D) $ 3,500
E) none of the above
Q13 By how much has the change in Dividends Payable generated or (used) cash?
A) $ (41,500)
B) $ (6,000)
C) $ 6,000
D) $ 41,500
E) none of the above
This is the end of Indirect Method cash flow statement questions.
ADMS 2500 Final Exam, Fall 2019 © York University Page 6 – Reg A
This page is left blank for your calculations
ADMS 2500 Final Exam, Fall 2019 © York University Page 7 – Reg A
Questions 14-26 are for the Cash Flow statement prepared using the direct method
Q14 What was the total (payment) collection of Cash Dividends?
A) $ (6,000)
B) $ (5,000)
C) $ (11,000)
D) $ (2,500)
E) none of the above
Q15 What was the total Cash collection (payment) from customers?
A) $ 250,000
B) $ (135,000)
C) $ 258,000
D) $ 242,000
E) none of the above
Q16 What is the total Cash collection (payment) to suppliers?
A) $ 135,000
B) $ (144,500)
C) $ 136,500
D) $ (136,500)
E) none of the above
Q17 What is the total Cash (payment) collection for Advertising expenses?
A) $ (40,000)
B) $ 40,000
C) $ (1,500)
D) $ (43,500)
E) none of the above
Q19 What is the total Cash collection (payment) for Income Taxes?
A) $ 13,000
B) $ 7,000
C) $ (13,000)
D) $ (7,000)
E) none of the above
Q20 What is the total cash collection (payment) for rent expense?
A) $ (11,000)
B) $ 12,000
C) $ (12,000)
D) $ 11,000
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 8 – Reg A
Q21 What is the total Cash collection (payment) for Office Supplies Expense?
A) $ (17,000)
B) $ 15,000
C) $ 17,000
D) $ (15,000)
E) none of the above
Q24 What is the net carrying amount for the machinery that was sold?
A) $ 50,000
B) $ 40,000
C) $ 10,000
D) $ 45,000
E) none of the above
Q25 What is the total Cash (payment) collection of long term notes payable?
A) $ (30,000)
B) $ 30,000
C) $ 100,000
D) $ 70,000
E) none of the above
Q26 What is the total Cash (payment) collection of shares issued/bought back?
A) $ (14,000)
B) $ 8,000
C) $ (3,000)
D) $ 3,000
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 9 – Reg A
This page is left blank for your calculations
ADMS 2500 Final Exam, Fall 2019 © York University Page 10 – Reg A
Questions 27-45 are for the Financial Statements Analysis
ADMS 2500 Final Exam, Fall 2019 © York University Page 11 – Reg A
Q33 The working capital turnover at November 2019 was:
A). Equal or below 3.43
B). Between 3.44 and 7.87
C). Between 7.88 and 10.88
D). Equal or above 10.89
E). Not enough data provided to calculate it
Q45 When performing a liquidity analysis, which are the ratios to consider?
A). ROE, ROA and ROS
B). Current ratio, AR turnover and Average collection period
C). Current ratio, Working Capital turnover and Average collection period
D). Current ratio, Quick ratio and Interest Coverage
E). Quick ratio, Working Capital turnover and Average collection period
The remaining questions are independent and unrelated to the previous ones.
ADMS 2500 Final Exam, Fall 2019 © York University Page 13 – Reg A
46) The qualitative characteristic that best refers to the confidence that financial statement users
have that the statements are free of material error or misrepresentation is:
A) objectivity
B) understandability
C) reliability
D) relevance
E) None of the other alternatives are correct
47) A set of rules of professional conduct that governs the behaviour of accountants in the
performance of their work is called
A) generally accepted accounting principles (GAAP)
B) the Accounting Act
C) the Sarbanes-Oxley Act
D) a code of ethics
E) None of the other alternatives are correct
48) Three foundations underpinning financial reporting and transparency are the conceptual
foundations, the technical foundations and
A) the professional foundations
B) the Board of Directors foundations
C) the audit foundations
D) The theoretical foundations
E) None of the other alternatives are correct
50) You are the Chief Financial Officer of XYZ Corporation. You receive shares of XYZ as part of
your compensation each year and you sell these shares and use the proceeds from the sale to pay
for nursing home care for your mother. You have just learned that XYZ Corporation has lost its
major customer and know that sales for the year will be sharply impacted. Because reported net
income will be below the expectations of market analysts, you know that when the news of the
loss of the customer becomes public, the market price of XYZ Corporation shares will drop. If
you sell your shares of XYZ before the news becomes public you are
A) Exercising due care in taking care of your money
B) Contributing to an efficient capital market by acting rationally upon all available information
C) Engaging in insider trading and acting unethically
D) Sending a signal to the market
E) None of the other alternatives are correct
This is the end of the exam – good luck! Have a good Winter Break!
ADMS 2500 Final Exam, Fall 2019 © York University Page 14 – Reg A
York University AP/ADMS 2500 3.00
Introduction to Financial Accounting
Final Exam for Fall 2019
Time: 3 hours Regular Exam ‐ Version B Questions: 50
Instructions:
1. Submit: Both the pink mark sense sheet and the exam paper will be collected in final exams.
Ensure your name is on all documents. Marks will be deducted if you do not turn in this exam
paper. Record your name and ID# here:
3. Exam Aids:
• Only calculators without alphanumeric programmable memories are allowed. It is
strongly suggested you bring a couple of cheap 4 function calculators to the exam in case
one fails. Be prepared to be challenged by invigilators if you bring a “fancy” calculator.
• Compact foreign language/English dictionaries may be used. However, these will be
examined by invigilators. If there are any loose pages or handwriting in the dictionary, it
will be seized and you will be charged with academic dishonesty. No electronic
dictionaries are allowed.
• TURN OFF YOUR PHONE AND PLACE IT AWAY FROM YOU (not in your pocket)
• In 2500, invigilators answer no questions of interpretation. They will pass along
questions regarding possible errors/typos/missing data to the professors. If you believe a
question contains an error and do not receive a response, make a detailed note on the back
of your pink mark sense sheet and submit it with your paper.
Note – there are blank pages for your rough work found at the end of the exam.
DO NOT UNSTAPLE YOUR EXAM BOOKLET.
ADMS 2500 Final Exam, Fall 2019 © York University Page 1 – Reg B
Questions 1- 45 are based on the following information
(Cash flow statement and Financial Statement Analysis questions)
The income statement for the year ended November 30, 2019, LeBlue Corp.
contains the following information:
LeBlue Corp.
Income Statement
Year Ended November 30, 2019
Revenue $ 250,000
Cost of goods sold $ (135,000)
Office Supplies Expense $ (12,000)
Advertising Expense $ (45,000)
Amortization Expense $ (40,000)
Results of Sale of equipment $ 7,000
Interest Expense $ (3,000)
Income Tax Expense $ (7,000)
Profit $ 15,000
LeBlue Corp.
Balance Sheet
As of November 30, 2019
2019 2018
Cash $ 7,000 $ 5,000
Accounts Receivable $ 15,000 $ 7,000
Inventory $ 7,500 $ 12,000
Office Supplies $ 5,000 $ 10,000
Equipment $ 225,000 $ 225,000
Accumulated Depreciation ‐ equipment $(149,000) $ (115,000)
Total Assets $ 110,500 $ 144,000
Additional Information:
1 Equipment that cost $50,000 was sold for a certain amount in cash
2 New equipment was purchased during the year for $50,000
3 Dividends declared in 2019 totalled $7,000
Dividends are treated as financing activities
Please prepare both an Indirect and Direct Cash Flow Statement to answer the questions below.
ADMS 2500 Final Exam, Fall 2019 © York University Page 3 – Reg B
This page is left blank for your calculations
ADMS 2500 Final Exam, Fall 2019 © York University Page 4 – Reg B
Choose the best answer for each of the following 50 questions. There is only one best answer
for each question (2 marks each question).
Questions 1-13 are for the Cash Flow statement prepared using the indirect method.
Q1 What is the Total adjustment to reconcile profit to net cash provided by operations?
A) $ 29,000
B) $ 21,000
C) $ 31,000
D) $ 27,000
E) none of the above
Q4 By how much has the change in Inventory has generated or (used) cash?
A) $ 65,500
B) $ (4,500)
C) $ 4,500
D) $ (65,500)
E) none of the above
Q5 By how much has the change in Interest Payable has generated or (used) cash?
A) $ (7,000)
B) $ 3,000
C) $ (3,000)
D) $ 7,000
E) none of the above
Q6 By how much has the change in Office Supplies has generated or (used) cash?
A) $ 5,000
B) $ 10,000
C) $ (10,000)
D) $ (5,000)
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 5 – Reg B
Q7 By how much has the change in Income Tax Payable has generated or (used) cash?
A) $ (7,000)
B) $ (4,500)
C) $ 4,500
D) $ 7,000
E) none of the above
Q8 What is the Net Cash provided or (used) by Operations?
A) $ 44,000
B) $ 37,000
C) $ 47,000
D) $ 49,500
E) none of the above
Q9 By how much have the changes in Working Capital generated or (used) cash?
A) $ (11,000)
B) $ (3,500)
C) $ (4,000)
D) $ 7,000
E) none of the above
Q10 By how much has the change in Accounts Payable generated or (used) cash?
A) $ (8,000)
B) $ 8,000
C) $ 7,500
D) $ 12,000
E) none of the above
Q11 By how much has the change in Accounts Receivables generated or (used) cash?
A) $ 8,000
B) $ (7,000)
C) $ 7,000
D) $ (8,000)
E) none of the above
Q12 By how much has the change in Advertising Payable generated or (used) cash?
A) $ 7,000
B) $ (7,000)
C) $ 4,000
D) $ (4,000)
E) none of the above
Q13 By how much has the change in Dividends Payable generated or (used) cash?
A) $ (33,500)
B) $ (6,000)
C) $ 6,000
D) $ 33,500
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 7 – Reg B
Questions 14-26 are for the Cash Flow statement prepared using the direct method
Q14 What was the total (payment) collection of Cash Dividends?
A) $ (6,000)
B) $ (7,000)
C) $ (13,000)
D) $ (3,500)
E) none of the above
Q15 What was the total Cash collection (payment) from customers?
A) $ 250,000
B) $ (135,000)
C) $ 242,000
D) $ 258,000
E) none of the above
Q17 What is the total Cash (payment) collection for Advertising expenses?
A) $ (40,000)
B) $ 40,000
C) $ (4,500)
D) $ (38,000)
E) none of the above
Q19 What is the total Cash collection (payment) for Income Taxes?
A) $ 11,500
B) $ 7,000
C) $ (11,500)
D) $ (7,000)
E) none of the above
Q20 What is the total cash collection (payment) for rent expense?
A) $ (13,000)
B) $ 12,000
C) $ (12,000)
D) $ 13,000
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 8 – Reg B
Q21 What is the total Cash collection (payment) for Office Supplies Expense?
A) $ (7,000)
B) $ (5,000)
C) $ 7,000
D) $ 5,000
E) none of the above
Q24 What is the net carrying amount for the machinery that was sold?
A) $ 50,000
B) $ 40,000
C) $ 10,000
D) $ 44,000
E) none of the above
Q25 What is the total Cash (payment) collection of long term notes payable?
A) $ (30,000)
B) $ 30,000
C) $ 100,000
D) $ 70,000
E) none of the above
Q26 What is the total Cash (payment) collection of shares issued/bought back?
A) $ (13,000)
B) $ 13,000
C) $ 0
D) $ 3,000
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 9 – Reg B
This page is left blank for your calculations
ADMS 2500 Final Exam, Fall 2019 © York University Page 10 – Reg B
Questions 27-45 are for the Financial Statements Analysis
ADMS 2500 Final Exam, Fall 2019 © York University Page 11 – Reg B
Q33 The working capital turnover at November 2019 was:
A). Equal or below 10.37
B). Between 10.38 and 11.75
C). Between 11.76 and 12.76
D). Equal or above 12.77
E). Not enough data provided to calculate it
Q43 After performing a Liquidity Analysis, you can say that the company’s trend is:
A) Improving.
B) Stable, without changes.
C) Getting worst.
D) Unable to say, critical data is missing.
E) None of the above
Q44 After performing a Profitability Analysis, you can say that the company’s trend is:
A) Improving.
B) Stable, without changes.
C) Getting worst.
D) Unable to say, critical data is missing.
E) None of the above
Q45 When performing an efficiency analysis, which ratio you would consider?
A). Return on Sales (ROS)
B). Current ratio
C). Average collection period
D). Interest coverage
E). Equity ratio
The remaining questions are independent and unrelated to the previous ones.
ADMS 2500 Final Exam, Fall 2019 © York University Page 13 – Reg B
46) Which of the following is not a desirable attribute of financial statements
A) relevance
B) subjectivity
C) reliability
D) completeness
E) None of the other alternatives are correct
47) The following definition pertains to which desirable attribute of financial statements: statements
should be free of material error and/or fraud and represent what really happened or exists.
A) relevance
B) subjectivity
C) reliability
D) completeness
E) None of the other alternatives are correct
50) You are the Chief Financial Officer of XYZ Corporation. You receive shares of XYZ as part of
your compensation each year and you sell these shares and use the proceeds from the sale to pay
for nursing home care for your mother. You have just learned that XYZ Corporation has lost its
major customer and know that sales for the year will be sharply impacted. Because reported net
income will be below the expectations of market analysts, you know that when the news of the
loss of the customer becomes public, the market price of XYZ Corporation shares will drop. If
you sell your shares of XYZ before the news becomes public you are
A) Sending a signal to the market
B) Engaging in insider trading and acting unethically
C) Exercising due care in taking care of your money
D) Contributing to an efficient capital market by acting rationally upon all available information
E) None of the other alternatives are correct
This is the end of the exam – good luck! Have a good Winter Break!
ADMS 2500 Final Exam, Fall 2019 © York University Page 14 – Reg B
York University AP/ADMS 2500 3.00
Introduction to Financial Accounting
Final Exam for Fall 2019
Time: 3 hours Regular Exam – Alternate Version Questions: 50
Instructions:
1. Submit: Both the pink mark sense sheet and the exam paper will be collected in final exams.
Ensure your name is on all documents. Marks will be deducted if you do not turn in this exam
paper. Record your name and ID# here:
3. Exam Aids:
• Only calculators without alphanumeric programmable memories are allowed. It is
strongly suggested you bring a couple of cheap 4 function calculators to the exam in case
one fails. Be prepared to be challenged by invigilators if you bring a “fancy” calculator.
• Compact foreign language/English dictionaries may be used. However, these will be
examined by invigilators. If there are any loose pages or handwriting in the dictionary, it
will be seized and you will be charged with academic dishonesty. No electronic
dictionaries are allowed.
• TURN OFF YOUR PHONE AND PLACE IT AWAY FROM YOU (not in your pocket)
• In 2500, invigilators answer no questions of interpretation. They will pass along
questions regarding possible errors/typos/missing data to the professors. If you believe a
question contains an error and do not receive a response, make a detailed note on the back
of your pink mark sense sheet and submit it with your paper.
Note – there are blank pages for your rough work found at the end of the exam.
DO NOT UNSTAPLE YOUR EXAM BOOKLET.
ADMS 2500 Final Exam, Fall 2019 © York University Page 1 – Alt Reg
Questions 1- 45 are based on the following information
(Cash flow statement and Financial Statement Analysis questions)
The income statement for the year ended November 30, 2019, LeDuck Corp.
contains the following information:
LeDuck Corp.
Income Statement
Year Ended November 30, 2019
Revenue $ 250,000
Cost of goods sold $ (150,000)
Office Supplies Expense $ (12,000)
Advertising Expense $ (35,000)
Amortization Expense $ (40,000)
Results of Sale of equipment $ 5,000
Interest Expense $ (6,000)
Income Tax Expense $ (8,000)
Profit $ 4,000
LeDuck Corp.
Comparative Balance Sheet as of November 30th
2019 2018
Cash $ ‐ $ 5,000
Accounts Receivable $ 15,000 $ 7,000
Inventory $ 5,500 $ 15,000
Office Supplies $ 8,000 $ 10,000
Equipment $ 225,000 $ 225,000
Accumulated Depreciation ‐ equipment $(149,000) $ (115,000)
Total Assets $ 104,500 $ 147,000
Additional Information:
1 Equipment that cost $50,000 was sold for a certain amount in cash
2 New equipment was purchased during the year for $50,000
3 Dividends declared in 2019 totalled $7,000
Dividends are treated as financing activities
Please prepare both an Indirect and Direct Cash Flow Statement to answer the questions below.
ADMS 2500 Final Exam, Fall 2019 © York University Page 3 – Alt Reg
This page is left blank for your calculations
ADMS 2500 Final Exam, Fall 2019 © York University Page 4 – Alt Reg
Choose the best answer for each of the following 50 questions. There is only one best answer
for each question (2 marks each question).
Questions 1-13 are for the Cash Flow statement prepared using the indirect method.
Q1 What is the Total adjustment to reconcile profit to net cash provided by operations?
A) $ 33,000
B) $ 25,000
C) $ 35,000
D) $ 28,000
E) none of the above
Q5 By how much has the change in Interest Payable generated or (used) cash?
A) $ (7,000)
B) $ 6,000
C) $ (6,000)
D) $ 7,000
E) none of the above
Q6 By how much has the change in Office Supplies generated or (used) cash?
A) $ (2,000)
B) $ 10,000
C) $ (10,000)
D) $ (8,000)
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 5 – Alt Reg
Q7 By how much has the change in Income Tax Payable generated or (used) cash?
A) $ (8,000)
B) $ (4,500)
C) $ 4,500
D) $ 8,000
E) none of the above
Q9 By how much have the changes in Working Capital generated or (used) cash?
A) $ (14,000)
B) $ 1,500
C) $ (2,000)
D) $ 12,000
E) none of the above
Q10 By how much has the change in Accounts Payable generated or (used) cash?
A) $ (8,000)
B) $ 8,000
C) $ 5,500
D) $ 15,000
E) none of the above
Q11 By how much has the change in Accounts Receivables generated or (used) cash?
A) $ 8,000
B) $ (7,000)
C) $ 7,000
D) $ (8,000)
E) none of the above
Q12 By how much has the change in Advertising Payable generated or (used) cash?
A) $ 7,000
B) $ (7,000)
C) $ 1,000
D) $ (1,000)
E) none of the above
Q13 By how much has the change in Dividends Payable generated or (used) cash?
A) $ (42,500)
B) $ (6,000)
C) $ 6,000
D) $ 42,500
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 6 – Alt Reg
This page is left blank for your calculations
ADMS 2500 Final Exam, Fall 2019 © York University Page 7 – Alt Reg
Questions 14-26 are for the Cash Flow statement prepared using the direct method
Q15 What was the total Cash collection (payment) from customers?
A) $ 250,000
B) $ (150,000)
C) $ 242,000
D) $ 240,000
E) none of the above
Q17 What is the total Cash (payment) collection for Advertising expenses?
A) $ (40,000)
B) $ 40,000
C) $ 9,500
D) $ (28,000)
E) none of the above
Q19 What is the total Cash collection (payment) for Income Taxes?
A) $ 12,500
B) $ 8,000
C) $ (12,500)
D) $ (8,000)
E) none of the above
Q20 What is the total cash collection (payment) for rent expense?
A) $ (13,000)
B) $ 12,000
C) $ (12,000)
D) $ 13,000
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 8 – Alt Reg
Q21 What is the total Cash collections (payments) for Office Supplies Expenses?
A) $ (10,000)
B) $ (14,000)
C) $ 14,000
D) $ 10,000
E) none of the above
Q24 What is the net carrying amount for the machinery that was sold?
A) $ 50,000
B) $ 40,000
C) $ 10,000
D) $ 44,000
E) none of the above
Q25 What is the total Cash (payment) collection of long terms notes payable?
A) $ (30,000)
B) $ 30,000
C) $ 100,000
D) $ 70,000
E) none of the above
Q26 What is the total Cash (payment) collection of shares issues/bought back?
A) $ (11,000)
B) $ 15,000
C) $ 2,000
D) $ (2,000)
E) none of the above
ADMS 2500 Final Exam, Fall 2019 © York University Page 10 – Alt Reg
Questions 27-45 are for the Financial Statements Analysis
ADMS 2500 Final Exam, Fall 2019 © York University Page 11 – Alt Reg
Q33 The working capital turnover at November 2019 was:
A). Equal or below 10.25
B). Between 10.26 and 15.51
C). Between 15.52 and 19.02
D). Equal or above 19.03
E). Not enough data provided to calculate it
ADMS 2500 Final Exam, Fall 2019 © York University Page 12 – Alt Reg
Q40 The equity ratio at November 2018 was:
A). Equal or below 0.15
B). Between 0.16 and 0.17
C). Between 0.18 and 0.21
D). Equal or above 0.22
E). Not enough data provided to calculate it
Q42 When performing a liquidity analysis, which ratio you would consider?
A). Return on Sales (ROS)
B). Current ratio
C). Average collection period
D). Working capital turnover
E). Equity ratio
Q43 When performing an analysis on leverage, which ratio you would consider?
A). Return on Sales (ROS)
B). Current ratio
C). Average collection period
D). Working capital turnover
E). Equity ratio
Q44 When performing a profitability analysis, which ratio you would consider?
A). Return on Sales (ROS)
B). Current ratio
C). Average collection period
D). Interest coverage
E). Equity ratio
Q45 When performing an efficiency analysis, which ratio you would consider?
A). Return on Sales (ROS)
B). Current ratio
C). Average collection period
D). Interest coverage
E). Equity ratio
The remaining questions are independent and unrelated to the previous ones.
ADMS 2500 Final Exam, Fall 2019 © York University Page 13 – Alt Reg
46) Which of the following is not a desirable attribute of financial statements
A) relevance
B) subjectivity
C) reliability
D) completeness
E) None of the other alternatives are correct
47) The following definition pertains to which desirable attribute of financial statements: statements
should be free of material error and/or fraud and represent what really happened or exists.
A) relevance
B) subjectivity
C) reliability
D) completeness
E) None of the other alternatives are correct
49) A set of rules of professional conduct that governs the behaviour of accountants in the performance
of their work is called
A) generally accepted accounting principles (GAAP)
B) the Accounting Act
C) the Sarbanes-Oxley Act
D) a code of ethics
E) None of the other alternatives are correct
50) Three foundations underpinning financial reporting and transparency are the conceptual foundations,
the technical foundations and
A) the professional foundations
B) the Board of Directors foundations
C) the audit foundations
D) The theoretical foundations
E) None of the other alternatives are correct
This is the end of the exam – good luck! Have a good Winter Break!
ADMS 2500 Final Exam, Fall 2019 © York University Page 14 – Alt Reg
Complete solutions to exam Version A Regular – Fall 2019
Case: LeDark
ADMS 2500 Final Exam, Fall 2019 © York University Page 16 – Reg A
Solutions for Indirect method
LeDark Corp.
Cash Flow Statement
Year Ended November 30, 2019
Investing activities 83
Sale of Equipment $ 52,000
Purchase of Equipment $ (47,000)
Net cash used by investing $ 5,000
Financing activities
Repayment of notes payable $ (30,000)
Issue/call of common shares $ (3,000)
Payment of cash dividends $ (11,000)
Net cash used by financing activities $ (44,000)
Calculations
Acc deprn on machinery sold Dividends
Accum deprn beg period $ 115,000 Payable 2018 $ 6,000
Depreciation expense period $ 40,000 Payable 2019 $ ‐
Accum deprn period end $ (150,000) $ (6,000)
* Acc Depr of equipment sold $ 5,000 Declared 2019 $ (5,000)
Paid in 2019 $ (11,000)
Carrying amount of machinery sold
cost of equipment $ 50,000
Accumulated deprec. $ (5,000)
* Amount for equipment sold $ 45,000
LeDark Corp.
Cash Flow Statement
Year Ended November 30, 2019
Operating activities
Cash Receipts from Customers #1 $ 258,000
Cash payments
to supplies #2 $ (144,500)
for Office Supplies Expense #6 $ (17,000)
for Advertising Expense #3 $ (43,500)
for Interest #4 $ (3,000)
for Income Tax #5 $ (13,000)
for Prepaid Expenses #7 $ ‐ $ (221,000)
Net Cash provided by operating activities $ 37,000
Investing Activities
Sale of Machine $ 52,000
Purchase of Machine $ (47,000)
Net Cash used for investment activities $ 5,000
Financing Activities
Repayment of note payable $ (30,000)
Issue of Common shares $ (3,000)
Payment of dividends $ (11,000)
Net cash used by financing activities $ (44,000)
Calculations
Customers To Suppliers
#1 Sales $250,000 #2 CoGS $ 135,000
Change in Accounts Receiv $ (8,000) Change in Inventory $ 1,500
$258,000 Change in Accounts P $ (8,000)
$ 144,500
Prepaid Expenses
#7
Change in
$ ‐
ADMS 2500 Final Exam, Fall 2019 © York University Page 18 – Reg A
Chapter ‐ Financial Statement analysis
2019 2018
Return on Equity Net income Average OE
2019 $ 15,000 20500 73% no
Return on common Equity Net income Average Common Eq
2019 $ 15,000 13500 111% no
Current ratio CA CL
2019 $ 32,500 $ 10,500 3.10
$ 36,000 $ 29,000
2018 1.24
Quick ratio QA CL
2019 $ 12,000 $ 10,500 1.14
2018 $ 22,000 $ 29,000 0.76
ADMS 2500 Final Exam, Fall 2019 © York University Page 19 – Reg A
Complete solutions to exam Version B Regular – Fall 2019
Case: LeBlue
ADMS 2500 Final Exam, Fall 2019 © York University Page 16 – Reg B
Solutions for Indirect method
LeBlue Corp.
Cash Flow Statement
Year Ended November 30, 2019
Investing activities 83
Sale of Equipment $ 51,000
Purchase of Equipment $ (50,000)
Net cash used by investing $ 1,000
Financing activities
Repayment of notes payable $ (30,000)
Issue/call of common shares $ ‐
Payment of cash dividends $ (13,000)
Net cash used by financing activities $ (43,000)
Calculations
Acc deprn on machinery sold Dividends
Accum deprn beg period $ 115,000 Payable 2018 $ 6,000
Depreciation expense period $ 40,000 Payable 2019 $ ‐
Accum deprn period end $ (149,000) $ (6,000)
Acc Depr of equipment sold $ 6,000 Declared 2019 $ (7,000)
Paid in 2019 $ (13,000)
Carrying amount of machinery sold
cost of equipment $ 50,000
Accumulated deprec. $ (6,000)
Amount for equipment sold $ 44,000
LeBlue Corp.
Cash Flow Statement
Year Ended November 30, 2019
Operating activities
Cash Receipts from Customers #1 $ 242,000
Cash payments
to supplies #2 $ (138,500)
for Office Supplies Expense #6 $ (7,000)
for Operating expenses #3 $ (38,000)
for Interest #4 $ (3,000)
for Income Tax #5 $ (11,500)
for Prepaid Expenses #7 $ ‐ $ (198,000)
Net Cash provided by operating activities $ 44,000
Investing Activities
Sale of Machine $ 51,000
Purchase of Machine $ (50,000)
Net Cash used for investment activities $ 1,000
Financing Activities
Repayment of note payable $ (30,000)
Issue of Common shares $ ‐
Payment of dividends $ (13,000)
Net cash used by financing activities $ (43,000)
Calculations
Customers To Suppliers
#1 Sales $250,000 #2 CoGS $ 135,000
Change in Accounts Receiv $ 8,000 Change in Inventory $ (4,500)
$242,000 Change in Accounts P $ (8,000)
$ 138,500
Prepaid Expenses
#7
Change in
$ ‐
ADMS 2500 Final Exam, Fall 2019 © York University Page 18 – Reg B
Chapter ‐ Financial Statement analysis
2019 2018
Return on Equity Net income Average OE
2019 $ 15,000 21000 71% no
Return on common Equity Net income Average Common Eq
2019 $ 15,000 15000 100% no
Current ratio CA CL
2019 $ 34,500 $ 15,500 2.23
2018 $ 34,000 $ 27,000 1.26
Quick ratio QA CL
2019 $ 22,000 $ 15,500 1.42
2018 $ 12,000 $ 27,000 0.44
ADMS 2500 Final Exam, Fall 2019 © York University Page 19 – Reg B
Complete solutions to exam Alternate Regular – Fall 2019
Case: LeDuck
ADMS 2500 Final Exam, Fall 2019 © York University Page 16 – Alt Reg
Solutions for Indirect method
LeDuck Corp.
Cash Flow Statement
Year Ended November 30, 2019
Investing activities 83
Sale of Equipment $ 49,000
Purchase of Equipment $ (50,000)
Net cash used by investing $ (1,000)
Financing activities
Repayment of notes payable $ (30,000)
Issue/call of common shares $ 2,000
Payment of cash dividends $ (13,000)
Net cash used by financing activities $ (41,000)
Calculations
Acc deprn on machinery sold Dividends
Accum deprn beg period $ 115,000 Payable 2018 $ 6,000
Depreciation expense period $ 40,000 Payable 2019 $ ‐
Accum deprn period end $ (149,000) $ (6,000)
Acc Depr of equipment sold $ 6,000 Declared 2019 $ (7,000)
Paid in 2019 $ (13,000)
Carrying amount of machinery sold
cost of equipment $ 50,000
Accumulated deprec. $ (6,000)
Amount for equipment sold $ 44,000
LeDuck Corp.
Cash Flow Statement
Year Ended November 30, 2019
Operating activities
Cash Receipts from Customers #1 $ 242,000
Cash payments
to supplies #2 $ (148,500)
for Office Supplies Expense #6 $ (10,000)
for Operating expenses #3 $ (28,000)
for Interest #4 $ (6,000)
for Income Tax #5 $ (12,500)
for Prepaid Expenses #7 $ ‐ $ (205,000)
Net Cash provided by operating activities $ 37,000
Investing Activities
Sale of Machine $ 49,000
Purchase of Machine $ (50,000)
Net Cash used for investment activities $ (1,000)
Financing Activities
Repayment of note payable $ (30,000)
Issue of Common shares $ 2,000
Payment of dividends $ (13,000)
Net cash used by financing activities $ (41,000)
Calculations
Customers To Suppliers
#1 Sales $250,000 #2 CoGS $ 150,000
Change in Accounts Receiv $ 8,000 Change in Inventory $ (9,500)
$242,000 Change in Accounts P $ (8,000)
$ 148,500
Prepaid Expenses
#7
Change in
$ ‐
ADMS 2500 Final Exam, Fall 2019 © York University Page 18 – Alt Reg
Chapter ‐ Financial Statement analysis
2019 2018
Return on Equity Net income Average OE
2019 $ 4,000 19500 21% no
Return on common Equity Net income Average Common Eq
2019 $ 4,000 16000 25% no
Current ratio CA CL
2019 $ 28,500 $ 15,500 1.84
2018 $ 37,000 $ 27,000 1.37
Quick ratio QA CL
2019 $ 15,000 $ 15,500 0.97
2018 $ 12,000 $ 27,000 0.44
ADMS 2500 Final Exam, Fall 2019 © York University Page 19 – Alt Reg