Financial Accounting-w/cd-package
3rd Edition
ISBN: 9780131060876
Author: REIMERS
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 5B, Problem 1SEA
Estimate inventory. (LO 9). Fantasy Games, Inc., wants to estimate its ending inventory balance for its quarterly financial statements for the first quarter of the year. Given the following, what is your best estimate?
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
Suppose a company's cost of goods sold for
years 2 and 3 were $283,310 and $299,390
respectively. Also suppose that inventory had
a balance of $34,740 at the end of year 1,
$35,168 at the end of year 2, and $36,356 at
the end of year 3. If the annual growth in total
revenues is 8.42% for the foreseeable future,
calculate the forecasted inventory balance at
the end of year 5. Assume the same inventory
turnover in all future years as that in year 3
calculated using the average asset balances.
Also assume the same gross margin % in all
future years as that in year 3. Note that year 3
is the latest year with reported results, while
years 4 onwards are all forecasted years.
For 2021, Walmart and Target had the following information (all values are in millions of dollars): Assume a 365-day year.
a. What is each company's accounts receivable days?
b. What is each company's inventory turnover?
c. Which company is managing its accounts receivable and inventory more efficiently?
Data table
(Click on the following icon in order to copy its contents into a spreadsheet.)
Walmart
Target
(Income Statement)
Sales
572,762
106,007
Cost of Goods Sold
(Income Statement)
428,997
74,962
Accounts Receivable
(Balance Sheet)
8,279
830
Inventory
(Balance She
56,519
13,902
= X
Obtain Apple's annual report of Fiscal Year 2021 and answer the questions below.
Hint: Go to the company's official website and look for the "Investor Relations" section.
Download the 2021 annual report (also called Form 10-K). Do NOT use quarterly reports or
reports of other years.
Chapter 5B Solutions
Financial Accounting-w/cd-package
Ch. 5B - Suppose Base Company began May with inventory of...Ch. 5B - Estimate inventory. (LO 9). Fantasy Games, Inc.,...Ch. 5B - (Estimate inventory. (LO 9). Knick-Knacks wants to...Ch. 5B - Estimate inventory. (LO 9). The following...Ch. 5B - Estimate inventory. (LO 9). The records of Florida...Ch. 5B - Estimate inventory. (LO 9). Hines Fruit Corp....Ch. 5B - Estimate inventory. (LO 9). Carries Cotton Candy...
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
- Suppose the company has to revise its estimates because of a downturn in the economy. Unit sales for August, September, and October will be half (50%) of the original estimates. Revise the estimates in cells 1311 through 1313. After this is done, check your forecasted balance sheet. It should still balance! What effect will this new state of affairs have on net income and borrowing? Explain why these items changed.arrow_forwardFrom the following hypothetical data for Riffa Co. in 2018 and 2019 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Riffa's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2019. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Cost of Goods Sold Gross Profit Ending Inventory Riffa Co. Required: Calculate the followings for Riffa Co. (consider 3 decimal places) 1. Sales Revenue and Growth Rate for Y+ 1 year. 2. Inventory Turnover for 2019. 3. Forecasted Gross Profit for Y+1. 4. Projected Average Inventory Balance in Year +1 5. Projected Ending Inventory for Year + 1. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac) 2018 48520 30560 6480 2019 56520 36800 8260arrow_forwardThe Quartz Company has been taking a physical inventory every quarter in order to prepare its quarterly financial statement. The management is interested to know if they have some alternative to find an efficient way of determining the cost of ending inventory for its quarterly reports. You have been given the following information abased on which you are supposed to suggest the management something that will fulfil the requirements. The Quartz Company Partial Income Statement For the year ended Dec 31, 2020 Net Sales $655,000 CGS: Beginning Inventory 80000 Purchases, Net 575000 COGAS…arrow_forward
- From the following hypothetical data for Riffa Co. in 2018 and 2019 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Riffa's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2019. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Cost of Goods Sold Gross Profit Ending Inventory Riffa Co. Required: Calculate the followings for Riffa Co. (consider 3 decimal places) 1. Sales Revenue and Growth Rate for Y+ 1 year. 2. Inventory Turnover for 2019. 3. Forecasted Gross Profit for Y+1. 4. Projected Average Inventory Balance in Year +1 5. Projected Ending Inventory for Year + 1. 2018 48520 30560 6480 2019 56520 36800 8260arrow_forwardUse Apple’s financial statements to calculate the following ratios and summary measures for fiscal 2020 and 2019 (round to the nearest tenth). Indicate whether the ratio was more favorable in 2020 or 2019. Apple’s stock price was $115 per share on Sept. 30, 2020, and $55 on Sept. 30, 2019. Fiscal 2020 Fiscal 2019 Is the Ratio more favorable in 2020 or 2019? DAYS RECEIVABLE 21.43 32.16 2020 DAYS INVENTORY 8.79 9.09 2019 RETURN ON ASSETS PROFIT MARGIN % GROSS MARGIN % RETURN ON EQUITY CURRENT RATIO 1.36 1.54 2019 QUICK RATIO EBITDA DEBT-TO-EQUITY RATIO n/a DIVIDEND PAYOUT RATIO n/a PE RATIO n/aarrow_forward10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B Compute the number of days sales in receivables ratios for each company for 2018 and 2019 C. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
- The following table shows a tool and dies company’s quarterly sales for the current year. What sales would you predict for the first quarter of next year? Quarter relatives are SR1= 1.10, SR2 = 0.99, SR3 = 0.90, and SR4 = 1.01.Quarter 1 2 3 4Sales 236.50 227.70 220.50 262.60arrow_forward1.A.) The following table shows the desired ending inventory levels of Red Rose Product of Rose Turkish Delight Company for the following year. The company's sales department manager expects the first quarter's sales to be 10,000 boxes and a 10% increase in each quarter. 31.12.2021 31.03.2022 30.06.2022 30.09.2022 31.12.2022 Desired Ending Inventory balances of Red 600 700 800 900 1000 Rose Prepare a production budget for Red Rose Product Line for 2022.arrow_forwardConsider the following details about a firm from the past year. Assume that this sample time period provides a good estimate for the firm's cycles. What is its Inventory Period? March 1 - Acquire Inventory March 20 - Pay $25,000 for Inventory April 22 - Sell Inventory on Credit May 23 - Collect $40,000 for Sale on Creditarrow_forward
- N1. Account Calculate the following ratios for Lake of Egypt Marina, Inc. as of year-end 2021. (Use sales when computing the inventory turnover and use total stockholders' equity when computing the equity multiplier. Round your answers to 2 decimal places. Use 365 days a year.)arrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. You may use the tables below BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Determine the NLF, NSF and the liquidity ratio…arrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. You may use the tables below BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Decompose the return on equity for the FY 2021…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337794756/9781337794756_smallCoverImage.gif)
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Chapter 6 Merchandise Inventory; Author: Vicki Stewart;https://www.youtube.com/watch?v=DnrcQLD2yKU;License: Standard YouTube License, CC-BY
Accounting for Merchandising Operations Recording Purchases of Merchandise; Author: Socrat Ghadban;https://www.youtube.com/watch?v=iQp5UoYpG20;License: Standard Youtube License