Please calculate all of the financial statement ratios below, after you have made your financial accounting...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Please calculate all of the financial statement ratios below, after you have made your financial accounting entries: For ratios using average balances, please use the figures on the "Prior Year Balances" tab Receivables Turnover Net Credit Sales Average net Accounts Receivable Inventory Turnover Cost of Goods Sold Average Inventory #DIV/0! #DIV/0! Average Collection Period Days in the Year Receivables Turnover Average Days in Inventory Days in the Year Inventory Turnover #DIV/O! #DIV/0! #DIV/O! #DIV/0! Balances as of 9/30/2023 (in thousands) Cash from Operating Activities Net Income Adjustments to reconcile net income to net cash flows from operating activities: Add back Depreciation Expense Add back Bad Debt Expense Increase in Accounts Receivable Increase in Inventory Increase in Accounts Payable Increase in Contingent Liability Increase in Interest Payable Net Cash Flows from Operating Activities Assets Cash Accounts Receivable, gross less: allowance for bad debt Inventory Property, Plant, and Equipme less: accum depreciation Total Assets Total Liabilities Total Liab & Equity Balances as of 9/30/2023 (in thousands) Owner's Equity Common Stock (400,000 share $16,000 Retained Earnings $43,600 Assets Cash Selected Prior Year Balances as of 12/31/2022 Warning: only use these for calculating ratios on the Ratio Analysis tab. Do not change these numbers Net Income (Loss) $1,500 Accounts Receivable, gross less: allowance for bad debt Inventory Property, Plant, and Equipmen less: accum depreciation $800 $35,000 ($5,000) $72,000 $70,000 ($10,000) Total Assets $162,800 $103,200 $162,800 $2,233 $8,900 $240,933 ($90) ($5,000) ($18,200) $6,000 $1,100 $0 ($5,057) $53,543 $40,000 ($4,910) $90,200 $81,000 ($18,900) 1100 Cash from Investing Activities 40 90 200 Net Cash Flows from Investing Activities Cash from Financing Activities Payment of Cash Dividend, Declared Dec 20: Acquisition of long-term debt Net Cash Flows from Financing Activities Net Increase (Decrease) in Cash Beginning Cash Ending Cash Dividend Declared Dividend per Share $200 $0.50 Liabilities Current Portion of Debt Interest Payable Accounts Payable Dividends Payable Legal Contingency Long-term Portion of Debt Total Liabilities Owner's Equity Common Stock (400,000 shares) Retained Earnings Total Liab & Equity $65,000 $10,000 $11,000 $300 $1,100 $92,000 $179,400 $16,000 $46,133 $241,533 $0 ($200) $58,000 $57,800 $52,743 $800 $53,543 300 1100 Balances as of 9/30/2023 (in thousands) Beginning Retained Earnings CY Net Income Less: Dividends Declared Ending Retained Earnings Balances as of 9/30/2023 (in thousands) Net Sales $150,000 Cost of Goods Sold ($99,500) Gross Profit $50,500 General Operating Expenses ($36,200) Bad Debt Expense $90 Interest Expense ($3,300) ($8,900) $1,000 $3,190 $957 $2,233 Depreciation Expense Contingent Liability Expense Income Before Tax Income Tax Expense (Benefit Net Income (Loss) Earnings (Loss) Per Share $5.58 $43,600 $2,233 $300 $46,133 0 500 90 1100 1000 300 Please calculate all of the financial statement ratios below, after you have made your financial accounting entries: For ratios using average balances, please use the figures on the "Prior Year Balances" tab Receivables Turnover Net Credit Sales Average net Accounts Receivable Inventory Turnover Cost of Goods Sold Average Inventory #DIV/0! #DIV/0! Average Collection Period Days in the Year Receivables Turnover Average Days in Inventory Days in the Year Inventory Turnover #DIV/O! #DIV/0! #DIV/O! #DIV/0! Balances as of 9/30/2023 (in thousands) Cash from Operating Activities Net Income Adjustments to reconcile net income to net cash flows from operating activities: Add back Depreciation Expense Add back Bad Debt Expense Increase in Accounts Receivable Increase in Inventory Increase in Accounts Payable Increase in Contingent Liability Increase in Interest Payable Net Cash Flows from Operating Activities Assets Cash Accounts Receivable, gross less: allowance for bad debt Inventory Property, Plant, and Equipme less: accum depreciation Total Assets Total Liabilities Total Liab & Equity Balances as of 9/30/2023 (in thousands) Owner's Equity Common Stock (400,000 share $16,000 Retained Earnings $43,600 Assets Cash Selected Prior Year Balances as of 12/31/2022 Warning: only use these for calculating ratios on the Ratio Analysis tab. Do not change these numbers Net Income (Loss) $1,500 Accounts Receivable, gross less: allowance for bad debt Inventory Property, Plant, and Equipmen less: accum depreciation $800 $35,000 ($5,000) $72,000 $70,000 ($10,000) Total Assets $162,800 $103,200 $162,800 $2,233 $8,900 $240,933 ($90) ($5,000) ($18,200) $6,000 $1,100 $0 ($5,057) $53,543 $40,000 ($4,910) $90,200 $81,000 ($18,900) 1100 Cash from Investing Activities 40 90 200 Net Cash Flows from Investing Activities Cash from Financing Activities Payment of Cash Dividend, Declared Dec 20: Acquisition of long-term debt Net Cash Flows from Financing Activities Net Increase (Decrease) in Cash Beginning Cash Ending Cash Dividend Declared Dividend per Share $200 $0.50 Liabilities Current Portion of Debt Interest Payable Accounts Payable Dividends Payable Legal Contingency Long-term Portion of Debt Total Liabilities Owner's Equity Common Stock (400,000 shares) Retained Earnings Total Liab & Equity $65,000 $10,000 $11,000 $300 $1,100 $92,000 $179,400 $16,000 $46,133 $241,533 $0 ($200) $58,000 $57,800 $52,743 $800 $53,543 300 1100 Balances as of 9/30/2023 (in thousands) Beginning Retained Earnings CY Net Income Less: Dividends Declared Ending Retained Earnings Balances as of 9/30/2023 (in thousands) Net Sales $150,000 Cost of Goods Sold ($99,500) Gross Profit $50,500 General Operating Expenses ($36,200) Bad Debt Expense $90 Interest Expense ($3,300) ($8,900) $1,000 $3,190 $957 $2,233 Depreciation Expense Contingent Liability Expense Income Before Tax Income Tax Expense (Benefit Net Income (Loss) Earnings (Loss) Per Share $5.58 $43,600 $2,233 $300 $46,133 0 500 90 1100 1000 300
Expert Answer:
Answer rating: 100% (QA)
To calculate the financial ratios shown in the first image youll need to utilize the financial information from the subsequent images Lets walk throug... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
Why is it important to understand resistance within your consulting journey (e.g. initial meetings, contracting, gaining entry, etc.). Describe ways in which you, as a consultant, would deal with...
-
Stores (Wal-Mart) is the largest retailing firm in the world. Building on a base of discount stores, Wal-Mart has expanded into warehouse clubs and Supercenters, which sell traditional discount store...
-
Why do most cities in the United States now have more radios but fewer radio repair shops than they did in 1960?
-
Jemma Burrett is a public practitioner. Four years earlier she had set up a family trust for a major client by the name of Simon Trent. The trust is for the benefit of Simon and his wife Marie. Marie...
-
What are the four types of economies? How do they differ regarding the ownershipand allocation of the factors of production?
-
Robert Carr is the founder of Heartland Payment Systems, Inc. Carr was heavily involved in negotiations with Global Payments, Inc., concerning the acquisition of Heartland by Global. During this...
-
George Johnson recently inherited a large sum of money; he wants to use a portion of this money to set up a trust fund for his two children. The trust fund has two investment options: (1) a bond fund...
-
Question 2 (50 points) When does the complex exponential prefactor for the solutions to the time- independent Schrodinger's equation matter? Let's find out with this example. An electron is confined...
-
An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region as well as...
-
ABC Co., a U.S. firm, formed a German company in 2014 by purchasing the common stock of the newly formed D Inc. The functional currency of D is the euro. During their first three years, D experienced...
-
The vapor pressure of n-pentane is given by In Pbar = 8.630-2819.7/T + (1.855 10)T. Derive an expression for AHvap as a function of temperature and find AHvap at its normal boiling point 36.1 C.
-
Assume that consumers view haircuts as the same among sellers and there are hundreds of barbers in a given market. The current market equilibrium price for a haircut is $15. Bobs Barbershop has a...
-
Explain the main principles of critical thinking and describe how these might apply to individual and work colleagues ideas to assist objective and rationale debate.
-
2. a. What is the area under the normal curve between z = -1.0 and z = -2.0? b.The standard normal probability distribution is unique because it has ________.
-
Remote teams yes, prove to add different issues of their own due to the nature of not being solely located in a FTF format for staff to work through any issues. But, at the same time, are these...
-
Dustin Plastics, Inc., manufactures plastic moldings for car seats. Its costing system uses two cost categories, direct materials and conversion costs. Each product must pass through Department A and...
-
Charles owns an office building and land that are used in his trade or business. The office building and land were acquired in 1978 for $800,000 and $100,000, respectively. During the current year,...
-
Explain the theory behind the dividends valuation approach. Why are dividends value-relevant to common equity shareholders?
-
Alpha Computer Systems (ACS) designs, manufactures, sells, and services networked computer systems; associated peripheral equipment; and related network, communications, and software products....
-
Suppose you are valuing a healthy, growing, profitable firm and you project that the firm will generate negative free cash flows for equity shareholders in each of the next five years. Can you use...
-
Go to https://www.youtube.com/watch?v=Fp9m4GNwGng to view a brief video on the Brazilian Jet manufacturer Embraer and their use of Critical Chain Project Management for maintenance services. How has...
-
It is sometimes argued that state revenue generated by lotteries is different from tax revenue because people choose to buy lottery tickets. Compare three state revenue sources cigarette excise...
-
Suppose that the demand for personalized license plates and the marginal cost of production in a state is as shown in Figure 16.1. If all the profits go to the government and the state wants to...
Study smarter with the SolutionInn App