Intermediate Accounting
9th Edition
ISBN: 9781259722660
Author: J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 3, Problem 3.18E
Calculating ratios; solve for unknowns
• LO3–8
The current asset section of the Excalibur Tire Company’s
Inventories | $ 840,000 |
Total assets | $2,800,000 |
2.25 | |
Acid-test ratio | 1.2 |
Debt to equity ratio | 1.8 |
Required:
Determine the following 2018 balance sheet items:
1. Current assets
2. Shareholders’ equity
3. Long-term assets
4. Long-term liabilities
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
24
range the following items in proper balance sheet presentation: (Be sure to list the assets in order of their liquidity. Input all
swers as positive values.)
Accumulated amortization
Retained earnings
Cash
Bonds payable
Accounts receivable
Plant and equipment-original cost
Accounts payable
Allowance for bad debts
Common stock, 100,000 shares outstanding
Inventory
Preferred stock, 1,000 shares outstanding
Marketable securities
Investments
Notes payable
$230,000
195,300
12,000
136,000
51,500
700,000
42,000
5,200
172,000
73,000
60,000
20,000
22,000
38,000
Help
Save & Exit
Submit
PROBLEM 8:Tomas Co. has the following balance sheet as of December 31, 2021.Current assets 180,000.00Fixed assets 120,000.00Total assets 300,000.00Accounts payable 40,000.00Accrued liabilities 20,000.00Notes payable 50,000.00Other Long-term debt 75,000.00Total Equity 115,000.00Total liabilities and equity 300,000.00 In 2021, Tomas Co. reported sales of P1,500,0000, net income of P30,000, and dividends of P18,000. The company expected its sales to increase by 20% by next year and its retention ratio will remain at 40%. Assume that Tomas Co. is operating at full capacity and it uses the AFN approach in determining the amount of external financing needed.How much is the sales for 2022?
Using Problem 8, how much is the increase in retained earnings for the purpose of computing the AFN?
Using Problem 8, how much external funds needed for the year 2022?
Balance Sheet for Bearcat Hathaway, 2022
2021
2022
Cash
Accounts
Receivable
Inventory
Current Assets
Accum.Depreciation
Net Fixed Assets
Gross Fixed Assets $16,251,665 $20,567,330
Less
$7,460,897 $10,117,819
Total Assets
O 11.58%
O 44.90%
O 8.37%
$5,268,485 $10,268,485
O 4.35%
$2,574,230 $2,314,672
O 6.02%
$529,062 $696,685
$8,371,777 $13,279,842
Total Liabilities
and Equity
What is the common size value for 2022 Notes Payable?
$8,790,768 $10,449,511
$17,162,545 $23,729,353
Current
Liabilities
2021
Accounts
Payable
Notes Payable $1,033,110 $1,987,233
2022
$1,673,992 $2,438,271
$2,707,102 $4,425,504
Long Term Debt $9,242,830 $11,468,302
Total Liabilities $11,949,932 $15,893,806
Common Stock
($0.50 par)
$1,300,000 $1,600,000
Capital Surplus $1,148,120 $1,800,969
Retained
$2,764,493 $4,434,578
Earnings
$17,162,545 $23,729,353
Chapter 3 Solutions
Intermediate Accounting
Ch. 3 - Prob. 3.1QCh. 3 - Prob. 3.2QCh. 3 - Define current assets and list the typical asset...Ch. 3 - Prob. 3.4QCh. 3 - Prob. 3.5QCh. 3 - Prob. 3.6QCh. 3 - Describe the common characteristics of assets...Ch. 3 - Prob. 3.8QCh. 3 - Prob. 3.9QCh. 3 - Define the terms paid-in-capital and retained...
Ch. 3 - Disclosure notes are an integral part of the...Ch. 3 - A summary of the companys significant accounting...Ch. 3 - Define a subsequent event.Ch. 3 - Prob. 3.14QCh. 3 - Prob. 3.15QCh. 3 - Prob. 3.16QCh. 3 - Prob. 3.17QCh. 3 - Show the calculation of the following solvency...Ch. 3 - Prob. 3.19QCh. 3 - Prob. 3.20QCh. 3 - (Based on Appendix 3) Segment reporting...Ch. 3 - Prob. 3.22QCh. 3 - Prob. 3.23QCh. 3 - Current versus long-term classification LO32,...Ch. 3 - Balance sheet classification LO32, LO33 The trial...Ch. 3 - Prob. 3.3BECh. 3 - Balance sheet classification LO32, LO33 Refer to...Ch. 3 - Balance sheet classification LO32, LO33 The...Ch. 3 - Balance sheet classification LO32, LO33 You have...Ch. 3 - Balance sheet preparation; missing elements LO32,...Ch. 3 - Financial statement disclosures LO34 For each of...Ch. 3 - Calculating ratios LO38 Refer to the trial...Ch. 3 - Prob. 3.10BECh. 3 - Calculating ratios; solving for unknowns LO38 The...Ch. 3 - Balance sheet; missing elements LO32, LO33, LO38...Ch. 3 - Balance sheet classification LO32, LO33 The...Ch. 3 - Balance sheet classification LO32, LO33 The...Ch. 3 - Balance sheet preparation LO32, LO33 The...Ch. 3 - Balance sheet preparation LO32, LO33 The...Ch. 3 - Balance sheet; Current versus long-term...Ch. 3 - Prob. 3.7ECh. 3 - Prob. 3.8ECh. 3 - Balance sheet preparation LO32, LO33 The...Ch. 3 - Financial statement disclosures LO34 The...Ch. 3 - Prob. 3.11ECh. 3 - Prob. 3.12ECh. 3 - Prob. 3.13ECh. 3 - FASB codification research LO32, LO34 Access the...Ch. 3 - Prob. 3.15ECh. 3 - Prob. 3.16ECh. 3 - Prob. 3.17ECh. 3 - Calculating ratios; solve for unknowns LO38 The...Ch. 3 - Prob. 3.19ECh. 3 - Effect of management decisions on ratios LO38...Ch. 3 - Prob. 3.21ECh. 3 - Prob. 3.22ECh. 3 - Balance sheet preparation LO32, LO33 Presented...Ch. 3 - Balance sheet preparation; missing elements LO32,...Ch. 3 - Balance sheet preparation LO32, LO33 The...Ch. 3 - Balance sheet preparation LO32, LO33 The...Ch. 3 - Balance sheet preparation LO32, LO33 The...Ch. 3 - Prob. 3.6PCh. 3 - Balance sheet preparation; errors LO32, LO33 The...Ch. 3 - Balance sheet; errors; missing amounts LO32, LO33...Ch. 3 - Balance sheet preparation LO32 , LO33 Presented...Ch. 3 - Prob. 3.10PCh. 3 - Communication Case 31 Current versus long-term...Ch. 3 - Analysis Case 32 Current versus long- term...Ch. 3 - Prob. 3.4BYPCh. 3 - Judgment Case 35 Balance sheet; errors LO32...Ch. 3 - Prob. 3.6BYPCh. 3 - Real World Case 37 Balance sheet and significant...Ch. 3 - Judgment Case 38 Post fiscal year-end e vents ...Ch. 3 - Prob. 3.9BYPCh. 3 - Prob. 3.10BYPCh. 3 - Prob. 3.11BYPCh. 3 - Analysis Case 314 Balance sheet information LO32...Ch. 3 - Prob. 3.15BYPCh. 3 - Ethics Case 316 Segment reporting Appendix 3 You...Ch. 3 - Prob. 1CCTC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Calculate the average life, average age, and asset turnover ratios for Exxon Mobil. Discuss what each ratio tells you in the context of your chosen company. Calculate the accounts receivable turnover ratio and convert that ratio into days. Discuss what each ratio tells you in the context of your chosen company. Assets Fiscal year is January-December. All values USD millions. 2018 2019 Cash & Short Term Investments 3.04B 3.09B Cash Only 3.04B 3.09B Short-Term Investments - - Total Accounts Receivable 24.7B 26.97B Accounts Receivables, Net 19.64B 21.1B Accounts Receivables, Gross 20.04B 21.51B Bad Debt/Doubtful Accounts (400M) (405M) Other Receivables 5.06B 5.87B Inventories 18.96B 18.53B Finished Goods 14.8B 14.01B Work in Progress - - Raw Materials 4.16B 4.52B Progress Payments & Other - - Other Current Assets 1.27B 1.47B…arrow_forwardProblem 19: Laiho Industries’s 2017 and 2018 balance sheets (in thousands of dollars are shown). Please show all work, INCLUDING FORMULAS AND HOW YOU GOT EACH PIECE OF THE FORMULA. A, B, C ARE COMPLETE. PLEASE ANSWER D, E, F. a. Sales for 2018 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 11% of net fixed assets, interest was $8,575,000, the corporate tax rate was 40%, and Laiho pays 40% of its net income as dividends. Given this information, construct the firm’s 2018 income statement. b. Construct the statement of stockholders’ equity for the year ending December 31, 2018, and the 2018 statement of cash flows. c. Calculate 2017 and 2018 net operating working capital (NWOC) and 2018 free cash flow (FCF). Assume the firm has no excess cash. d. If Laiho increased its dividend payout ratio, what effect would this have on corporate taxes paid? What effect would this have on taxes paid by the company’s shareholders? (Answer part D in full,…arrow_forwardQuestion 6 (this question has 2 parts) Gordon Industries Ltd has provided you with the following information: 2019 2020 2021 Debt to Equity 10.5% 23.4% 36.2% Gross Profit margin 30.2% 36.5% 35.3% Net profit margin 19.5% 17.6% 13% Return on Equity 15.1% 17.5% 16.2% Asset Turnover (times) 0.71 0.82 1.41 Return on Assets 13.8% 14.4% 18.3% Interest coverage ratio 4 times 3 times 2.5 times a) Advise Gordon Industries of the relationship between Return on Assets, Asset Turnover and Net Profit Margin. Comment on the profitability position of Gordon and any advice you consider relevant. b) Advise the shareholders of Gordon Industries on the financial structure of the company.arrow_forward
- Consider this simplified balance sheet for Geomorph Trading: Current assets Long-term assets $ 245 Current liabilities Long-term debt 630 Other liabilities Equity $ 875 Required: a. What is the company's debt-equity ratio? (Hint: debt = Current liabilities, Long-term debt, and Other liabilities) Note: Round your answer to 2 decimal places. b. What is the ratio of total long-term debt to total long-term capital? Note: Round your answer to 2 decimal places. c. What is its net working capital? d. What is its current ratio? Note: Round your answer to 2 decimal places. $ 170 215 140 350 $ 875 a Debt-equity ratio b. Long-term debt-to-capital ratio c. Net working capital d. Current ratioarrow_forwardQuestion 1 The following information represent Mooncake Corporation Details Sales Cash Inventory Current liabilities Asset turnover Current ratio Debt to asset ratio Receivables turnover Calculate the following items: a. Accounts receivables b. Fixed asset c. Long Term Debt d. Debt to Asset Ratio RM 3,549,000 179,000 911,000 788,000 1.40 2.95 times 40% 7 timesarrow_forwardQuestion 10 of 25 Based on the following data, what is the amount of working capital? Accounts payable Accounts receivable Cash Intangible assets Inventory Long-term investments Long-term liabilities Short-term investments Notes payable (short-term) Property, plant, and equipment Prepaid insurance $404240 O $411680 > O $458800 $79360 141360 86800 124000 171120 198400 248000 99200 69440 1661600 2480arrow_forward
- 24. Condensed financial data of Sheffield Company for 2020 and 2019 are presented below. SHEFFIELD COMPANYCOMPARATIVE BALANCE SHEETAS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $1,800 $1,130 Receivables 1,770 1,320 Inventory 1,560 1,890 Plant assets 1,900 1,700 Accumulated depreciation (1,220 ) (1,180 ) Long-term investments (held-to-maturity) 1,300 1,430 $7,110 $6,290 Accounts payable $1,220 $890 Accrued liabilities 190 250 Bonds payable 1,410 1,520 Common stock 1,870 1,730 Retained earnings 2,420 1,900 $7,110 $6,290 SHEFFIELD COMPANYINCOME STATEMENTFOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,860 Cost of goods sold 4,710 Gross margin 2,150 Selling and administrative expenses 920 Income…arrow_forwardQ.6 Analysis of Financial Statement: Cash $77.500; Receivable $336.000; Inventory $241,500: Fixed Asset $292.500 Account Payable $129,000; Note Payable $84,000: Other current liabilities $117.000; Long term Debt $256,500; Common equity $361,000 Compute i. Working capital ii. Current ratio iii. Quick ratio iv. Receivable turnover, where credit sales were Rs.1600,000 v. Inventory turnover where cost of goods sold Rs 1300,000 END OF EXAM PAPER FUUASarrow_forwardrq a Problem 11-12 (Algo) Effect of transactions on liquidity measures LO 1 Selected balance sheet accounts for Tibbetts Company on September 30, 2019, are as follows: Cash $ 48,000 Marketable securities 135,000 Accounts receivable, net 165,000 Inventory 187,500 Prepaid expenses 21,000 Total current assets $ 556,500 Accounts payable $ 108,000 Other accrued liabilities 26,400 Short-term debt 48,000 Total current liabilities $ 182,400 Required: Calculate the working capital, current ratio, and acid-test ratio for Tibbetts Company as of September 30, 2019. Summarized here are the transactions/events that took place during the fiscal year ended September 30, 2020. Prepare journal entries for the below transactions and Indicate the effect of each item on Tibbetts Company's working capital, current ratio, and acid-test ratio. Use + for increase, − for decrease, and (NE) for no effect. Credit sales for the year…arrow_forward
- QUESTION 9 On Dec. 31, 2021, Windsor Mold Co. has disclosed some of the company's financial data: Current Assets: $60 million Long-Term Assets: $140 million Total Net Worth: $125 million Total Long-Term Liabilities: $30 million Calculate the company's Current Ratio =? Current Ratio = 1.50 Current Ratio = 1.25 Current Ratio = 1.67 Current Ratio = 1.33 O Current Ratio = 1.10arrow_forward27 Assume that the Accounts receivables, notes receivables, cash balance and inventory of the company is OMR 500, OMR 700,OMR 600 and OMR 700 respectively. The equity and total liabilities are OMR 2000 and OMR7000 respectively. From the following given options identify the fixed assets of the company. a. OMR 2500 b. None of the given options c. OMR 9000 d. OMR 6500 Clear my choicearrow_forwardQUESTION ONE: The balance sheets of Choolwe & Co Ltd for the years ended 2017, 2018 and 2019 are as follows: Choolwe & Co Ltd Balance sheets at 31 December 2017 2018 2019 K000 K000 K000 Non-current assets Plant and equipment 13,200 16,110 16,410 Current assets Inventory 2,190 2,280 2,490 Trade debtors 2, 040 2,100 2,430 Short-term investments 4,200 1,800 1,290 Cash at bank and in hand…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License