Target Corporation reported the following on its income statement. For 12 Months Ended ($ millions) Feb....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Target Corporation reported the following on its income statement. For 12 Months Ended ($ millions) Feb. 2, 2019 Feb. 3, 2018 Jan. 28, 2017 Total revenue $75,356 $72,714 $70,271 Cost of sales 53,299 51,125 49,145 The revenue recognition footnote from the 10-K for the year ended February 2, 2019, includes the following. We record almost all retail store revenues at the point of sale. Digital channel sales include shipping revenue and are recorded upon delivery to the guest or upon guest pickup at the store. Total revenues do not include sales tax because we are a pass-through conduit for collecting and remitting sales taxes. Generally, guests may return national brand merchandise within 90 days of purchase and owned and exclusive brands within one year of purchase. Revenues are recognized net of expected returns, which we estimate using historical return patterns as a percentage of sales and our expectations of future returns. Revenue from gift card sales is recognized upon gift card redemption. Our gift cards do not expire. Based on historical redemption rates, a small and relatively stable percentage of gift cards will never be redeemed, referred to as "breakage." Estimated breakage revenue is recognized over time in proportion to actual gift card redemptions. Guests receive a 5 percent discount on virtually all purchases and receive free shipping at Target.com when they use their REDcard. This discount is included as a sales reduction in our Consolidated Statements of Operations and was $953 million, $933 million, and $899 million in the fiscal years ended February 2019, 2018, and 2017 respectively. Required a. Use the financial statement effects template to record retail cash sales of $1,000 in a state with a sales tax rate of 8%. For this question, assume 10% of all merchandise sold is returned within 90 days. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. Balance Sheet Income Transaction Cash Asset Noncash Assets Liabilities Contrib. Capital Earned Capital Revenues + In-store sales 1000 -707 = 1000 Cash COGS 80 b. Use the financial statement effects template to record the following transaction: On March 4, an internet customer places an order for $2,000 and pays online with a credit card (which is equivalent to cash for accounting purposes). The goods are shipped from the warehouse on March 6, and FedEx confirms delivery on March 7. Ignore shipping costs, sales tax, and returns. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. Balance Sheet Transaction Cash Asset Noncash Assets Liabilities Contrib. Capital Earned Capital Revenues + March 4: Online sale 0 = March 7: Goods delivered 0 = c. Use the financial statement effects template to record the gift card activity during the fiscal year ended February 2, 2019. Ignore sales tax and returns. Details are as follows. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. $ millions Gift card liability, February 3, 2018 $727 Gift cards issued during current period but not redeemed 645 Revenue recognized from beginning liability (532) Gift card liability, February 2, 2019 $840 Balance Sheet Transaction Cash Asset Noncash Assets Liabilities Contrib. Capital Earned Capital Revenues %3D + May: Gift card sale 0 = May: Gift card redemption 0 = d. Determine the amount of revenue Target collected from customers who used their loyalty card (REDcard™M) for each of the fiscal years reported above. What proportion of total revenues come from REDcard™M customers each year? Note: Round percentage to one decimal place (for example, enter 6.7% for 6.6555%). Fiscal Year Ended Revenue Collected REDcard transactions to Total sales 2019 $ 0 % 2018 $ 0 % 2017 $ 0 % Does the loyalty program seem to be working? Yes Target Corporation reported the following on its income statement. For 12 Months Ended ($ millions) Feb. 2, 2019 Feb. 3, 2018 Jan. 28, 2017 Total revenue $75,356 $72,714 $70,271 Cost of sales 53,299 51,125 49,145 The revenue recognition footnote from the 10-K for the year ended February 2, 2019, includes the following. We record almost all retail store revenues at the point of sale. Digital channel sales include shipping revenue and are recorded upon delivery to the guest or upon guest pickup at the store. Total revenues do not include sales tax because we are a pass-through conduit for collecting and remitting sales taxes. Generally, guests may return national brand merchandise within 90 days of purchase and owned and exclusive brands within one year of purchase. Revenues are recognized net of expected returns, which we estimate using historical return patterns as a percentage of sales and our expectations of future returns. Revenue from gift card sales is recognized upon gift card redemption. Our gift cards do not expire. Based on historical redemption rates, a small and relatively stable percentage of gift cards will never be redeemed, referred to as "breakage." Estimated breakage revenue is recognized over time in proportion to actual gift card redemptions. Guests receive a 5 percent discount on virtually all purchases and receive free shipping at Target.com when they use their REDcard. This discount is included as a sales reduction in our Consolidated Statements of Operations and was $953 million, $933 million, and $899 million in the fiscal years ended February 2019, 2018, and 2017 respectively. Required a. Use the financial statement effects template to record retail cash sales of $1,000 in a state with a sales tax rate of 8%. For this question, assume 10% of all merchandise sold is returned within 90 days. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. Balance Sheet Income Transaction Cash Asset Noncash Assets Liabilities Contrib. Capital Earned Capital Revenues + In-store sales 1000 -707 = 1000 Cash COGS 80 b. Use the financial statement effects template to record the following transaction: On March 4, an internet customer places an order for $2,000 and pays online with a credit card (which is equivalent to cash for accounting purposes). The goods are shipped from the warehouse on March 6, and FedEx confirms delivery on March 7. Ignore shipping costs, sales tax, and returns. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. Balance Sheet Transaction Cash Asset Noncash Assets Liabilities Contrib. Capital Earned Capital Revenues + March 4: Online sale 0 = March 7: Goods delivered 0 = c. Use the financial statement effects template to record the gift card activity during the fiscal year ended February 2, 2019. Ignore sales tax and returns. Details are as follows. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. $ millions Gift card liability, February 3, 2018 $727 Gift cards issued during current period but not redeemed 645 Revenue recognized from beginning liability (532) Gift card liability, February 2, 2019 $840 Balance Sheet Transaction Cash Asset Noncash Assets Liabilities Contrib. Capital Earned Capital Revenues %3D + May: Gift card sale 0 = May: Gift card redemption 0 = d. Determine the amount of revenue Target collected from customers who used their loyalty card (REDcard™M) for each of the fiscal years reported above. What proportion of total revenues come from REDcard™M customers each year? Note: Round percentage to one decimal place (for example, enter 6.7% for 6.6555%). Fiscal Year Ended Revenue Collected REDcard transactions to Total sales 2019 $ 0 % 2018 $ 0 % 2017 $ 0 % Does the loyalty program seem to be working? Yes
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Dominic (35) has self-only coverage in a high-deductible health plan. During 2021, he contributed $1,500 to an HSA through work, and his employer contributed $1,000 to the account. How much can...
-
Arlington Merchants reported the following on its income statement for the fiscal years ending December 31, 2013 and 2012. 2013 2012 Sales $4,853,100 $4,754,000 Cost of goods sold 3,266,750 3,202,400...
-
On its income statement for a recent year, Time Warner reported a net loss of $4.9 billion from operations. On its statement of cash flows, it reported $5.3 billion of cash flows from operating...
-
Quick Fix-it Corporation was organized in January 2011 to operate several car repair businesses in a large metropolitan area. The charter issued by the state authorized the following capital stock:...
-
Under what circumstances would each of the following inventory cost methods be appropriate? (a) Specific identification (b) Last-in, first-out (c) Average cost (d) First-in, first-out (e) Retail...
-
The accounts and their balances in the ledger of Sunshine Sports Co. on December 31, 2006, are as follows: The data needed for year-end adjustments on December 31 are as follows: Instructions 1....
-
You have your eyes on a new automobile costing \($25\),000. If you wrote a check for the \($25\),000, you could drive off in your new car. However, you dont have it and must finance \($20\),000...
-
In the current year, Harold and Faye form Entity Company by each contributing $50,000 to the company in exchange for a 50% ownership interest. In addition, the company borrows $40,000 from First...
-
When the fictional ancient kingdom was first founded, the nominal income per person was ????0 drachma, and exactly 100 years after its founding, the nominal income per person increased to ????100 =...
-
The Columbia River Crossing (CRC) project is in-tended to improve traffic flow in the I- 5 corridors in the greater Vancouver, Washington, and Portland, Oregon, region. The proposed project is...
-
The coefficient of static friction between the m = 2.75-kg crate and the 35.0 incline of the figure below is 0.325. What minimum force F must be applied to the crate perpendicular to the incline to...
-
Conduct a detailed market analysis, customer analysis, competition analysis and industry analysis of Ralph Lauren. Using your interpretation, analytical skills and knowledge... suggest: (Please be...
-
A walker walks 27 m from the origin towards the east to point a. She then walks from point a, 5 m more towards the west to point b. The walker then walks 10 m due north to point c. The magnitude of...
-
If the marginal costs for the production of a power drills can be modeled by the function C'(x)=45 and the fixed costs are $20000, find the total cost associated with the production of 400 power...
-
Expand on the Strengths and Weaknesses of both Dedicated and Matrix Project Management team Structures and how they support a large project: Strengths and Weaknesses of the Dedicated Project Team...
-
Find the absolute extreme values of the function on the interval. F(x) = 2,0.5 0.5 x 2
-
Consider the following linear optimization problem: minimize x,y,z subject to x+y+z 2x - 3y + 1.5z > 2 x + 2y -z = 3 1 x 4, 1 z 3. y 1.5, a) Use linprog to solve this problem. Make sure to identify...
-
Open Text Corporation provides a suite of business information software products. Exhibit 10-9 contains Note 10 from the companys 2013 annual report detailing long-term debt. Required: a. Open Text...
-
Roxbury, Corp., aggressively acquired other companies. Assume that Roxbury, Corp., purchased Lallor, Inc., for $15 million cash. The market value of Lallors assets is $20 million, and it has...
-
On January 4, 2013, Blano Systems, Inc., paid $254,300 for equipment used in manufacturing automotive supplies. In addition to the basic purchase price, the company paid $1,100 transportation...
-
You are the controller for CrystalClean Services, a company that provides janitorial services to large commercial customers. The company has been very successful during its first two years of...
-
Michael is in his last year of undergraduate studies in human services and economics and is conducting original research for his final research project. As part of his project, he is required to keep...
-
Keza is studying online for a masters degree in Management and wishes to undertake her research project in her home country, Rwanda, where she works as a civil servant. Due to her high pressure job,...
-
You wish to study the reasons why car owners join manufacturer-sponsored owners clubs. You choose to use a qualitative methodology and narrative inquiry research strategy involving unstructured...
Study smarter with the SolutionInn App