The Brick Company had cash sales of $226,200 for Year 1, its first year of operation. On April 2, the company purchased 164 units of inventory at $175 per unit. On September 1, an additional 123 units were purchased for $193 per unit. The company had 68 units on hand at the end of the year. The company's income tax rate is 40 percent. All transactions are cash transactions Required a. The preceding paragraph describes five accounting events: (1) a sales transaction, (2) the first purchase of inventory, a second purchase of inventory, (4) the recognition of cost of goods sold expense, and (5) the payment of income tax expense. Record the amounts of each event in horizontal statements models like the following ones, assuming first a FIFO and then a LIFO cost flow b. Compute net income using FIFO. c. Compute net income using LIFO.

The Brick Company had cash sales of $226,200 for Year 1, its first year of operation. On April 2, the company purchased 164 units of inventory at $175 per unit. On September 1, an additional 123 units were purchased for $193 per unit. The company had 68 units on hand at the end of the year. The company's income tax rate is 40 percent. All transactions are cash transactions Required a. The preceding paragraph describes five accounting events: (1) a sales transaction, (2) the first purchase of inventory, a second purchase of inventory, (4) the recognition of cost of goods sold expense, and (5) the payment of income tax expense. Record the amounts of each event in horizontal statements models like the following ones, assuming first a FIFO and then a LIFO cost flow b. Compute net income using FIFO. c. Compute net income using LIFO.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...

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.
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.
Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Refer to the information for Juroe Company on the previous page. Also, assume that Juroes total assets at the beginning of last year equaled 17,350,000 and that the tax rate applicable to Juroe is 40%. Required: Note: Round answers to two decimal places. 1. Calculate the average total assets. 2. Calculate the return on assets.
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.
Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
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?
Polo Ralph Lauren Corporation designs, markets, and distributes a variety of apparel, home decor, accessory, and fragrance products. The companys products include such brands as Polo by Ralph Lauren, Ralph Lauren Purple Label, Ralph Lauren, Polo Jeans Co., and Chaps. Polo Ralph Lauren reported the following (in thousands) for two recent years: Assume that accounts receivable (in millions) were 486,200 at the beginning of Year 1. a. Compute the accounts receivable turnover for Year 2 and Year 1. Round to one decimal place. b. Compute the days sales in receivables for Year 2 and Year 1. Use 365 days and round to one decimal place. c. What conclusions can be drawn from these analyses regarding Ralph Laurens efficiency in collecting receivables?
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?
Logo Gear purchased $2,250 worth of merchandise during the month, and its monthly income statement shows cost of goods sold of $2,000. What was the beginning inventory if the ending inventory was $1,000?
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.