The Brick Company had cash sales of $221,600 for Year 1, Its first year of operation. On April 2, the company purchased 227 units ofInventory at $190 per unit. On September 1, an additlonal 170 units were purchased for $209 per unit. The company had 49 units onhand at the end of the year. The company's Income tax rate Is 40 percent. All transactions are cash transactlons.Requlreda. The preceding paragraph describes five accounting events: (1) a sales transaction, (2) the first purchase of Inventory, (3) a secondpurchase of Inventory, (4) the recognition of cost of goods sold expense, and (5) the payment of Income tax expense. Show theamounts of each event In horizontal statements models, assuming first a FIFO and then a LIFO cost flow.b. Compute net Income using FIFO.c. Compute net Income using LIFO.e. Which method, FIFO or LIFO, produced the larger amount of assets on the balance sheet?Complete this question by entering your answers in the tabs below.Required ARequired BRequired CRequired EThe preceding paragraph describes five accounting events: (1) a sales transaction, (2) the first purchase of inventory, (3) a second purchase of inventory, (4) the recognition ofcost of goods sold expense, and (5) the payment of income tax expense. Show the amounts of each event in horizontal statements models, assuming first a FIFO and then a LIFOcost flow. (In the Cash Flow column, use the initials OA to designate operating activity, IA for investing activity, FA for financing activity, NC for net change in cash. Enter anydecreases to account balances and cash outflows with a minus sign. Not all cells require input.)Show less ATHE BRICK COMPANYEffect of Events on Financial StatementsPanel 1: FIF0 Cost FlowBalance SheetIncome StatementEvent No.Statement of Cash FlowsRetainedCashInventoryRevenueExpensesNet Income+-Earnings1.2.+3.+=4.+=5.+Balanceol +이=Panel 2: LIFO Cost Flow1.=+2.+3.+%3!4.+=5.=Balance이=+

Fifo Method assumes that units purchased first should be used first to make sales hence item in…

a. The preceding paragraph describes five accounting events: (1) a sales transaction, (2) the first purchase of Inventory. (3) a second purchase of Inventory, (4) the recognition of cost of goods sold expense, and (5) the payment of Income tax expense. Show the amounts of each event in horizontal statements models, assuming first a FIFO and then a LIFO cost flow. b. Compute net Income using FIFO. c. Compute net Income using LIFO. e. Which method, FIFO or LIFO, produced the larger amount of assets on the balance sheet?

a. The preceding paragraph describes five accounting events: (1) a sales transaction, (2) the first purchase of Inventory. (3) a second purchase of Inventory, (4) the recognition of cost of goods sold expense, and (5) the payment of Income tax expense. Show the amounts of each event in horizontal statements models, assuming first a FIFO and then a LIFO cost flow. b. Compute net Income using FIFO. c. Compute net Income using LIFO. e. Which method, FIFO or LIFO, produced the larger amount of assets on the balance sheet?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter7: Inventory Cost Flow Assumptions (fifolifo)

Section: Chapter Questions

Problem 1R: Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500...

See similar textbooks

Similar questions

On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.
Shaquille Corporation began the current year with inventory of 50,000. During the year, its purchases totaled 110,000. Shaquille paid freight charges of 8,500 for those purchases. At the end of the year, Shaquille had inventory of 47,800. Prepare a schedule to determine Shaquille's cost of goods sold for the current year.
Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Reset the purchase prices to their original values (cells C11 through C14). Suppose Del had purchased 250 units on November 20 rather than 150. Enter 250 in cell C14 and alter column G in the Data Section. Explain what happens to net income under each inventory cost flow assumption and why. Also, what management implications might this have for Del?
Brandt Corporation had sales revenue of 500,000 for the current year. For the year, its cost of goods sold was 240,000, its operating expenses were 50,000, its interest revenue was 2,000, and its interest expense was 12,000. Brandts income tax rate is 30%. Prepare Brandts multiple-step income statement for the current year.
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Smoltz Company reported the following information for the current year: cost of goods sold, $252,500; increase in inventory, $21,700; and increase in accounts payable, $12,200. What is the amount of cash paid to suppliers that Smoltz would report on its statement of cash flows under the direct method? a. $218,600 c. $262,000 b. $243,000 d. $286,400
Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Using a pencil, fill in columns F and G in the Data Section of the worksheet printout at the end of this problem.
Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Del has heard that the choice of an inventory cost flow assumption can have a significant effect on net income and taxes. He asks you to show him the differences between the specific identification method and the cost flow assumptions of FIFO, LIFO, and weighted average methods. Review the worksheet FIFOLIFO that follows these requirements. Note that all of the problem data have been entered in the Data Section of the worksheet.
Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Examine your completed worksheet and answer the following questions: a. Which inventory cost flow assumption produces the most net income? b. Which inventory cost flow assumption produces the least net income? c. What caused the difference between your answers to a and b? d. Which inventory cost flow assumption produces the highest ending cash balance? e. Which inventory cost flow assumption produces the lowest ending cash balance? f. Does the assumption that produces the highest net income also produce the highest cash balance? Explain. g. As you recall, Del originally used the specific identification method in his initial calculations when he projected 51,600 net income. According to Dels reckoning, that should have left him cash of 25,800 (50% of 51,600) after paying his investors. Why would he only have 3,800 left? Explain. h. Which inventory cost flow assumption would you suggest Del use? Explain.
Paula has sales that qualify to be reported on the installment basis. In year 2, installment sales were 40,000 with a cost of 30,000. In year 3, installment sales were 50,000 with a cost of 25,000. Collections in year 2 were in the amount of 30,000. Collections in year 3 were 10,000 on the year 2 sales and 30,000 on the year 3 sales. How much deferred gross profit exists as of the end of year 2? a. 2,500 b. 5,000 c. 7,500 d. 10,000