Answer full question. Answer required a,b,c and e 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) therecognition of cost of goods sold expense, and (5) the payment of income tax expense, Show the amounts of each event in horizontal statements models like thefollowing ones, assuming first a FIFO and then a LIFO cost 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 and NA to indicate the element is not affected by the event. Round your final answers to the nearest whole dollaramount. Enter any decreases to account balances and cash outflow with a minus sign.)Show less ApokTHE BRICK COMPANYEffect of Events on Financial StatementsintPanel 1: FIFO Cost FlowBalance SheetIncome StatementCash FlowsEventRetainedEarningsPrintNo.CashInventoryRevenueExpensesNet Income%3D1.2.erences3.4.=5.+Bal.Panel 2: LIFO Cost Flow1.+.=2.%3D3.%3D%3D4.%3D5.Bal.Required ARequired B Check my wcThe Brick Company had cash sales of $220,600 for Year 1, its first year of operation. On April 2, the company purchased 185 units ofinventory at $160 per unit. On September 1, an additional 139 units were purchased for $176 per unit. The company had 35 units onhand at the end of the year. The company's income tax rate is 40 percent. All transactions are cash transactions.Requireda. 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 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.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) therecognition of cost of goods sold expense, and (5) the payment of income tax expense. Show the amounts of each event in horizontal statements models like thefollowing ones, assuming first a FIFO and then a LIFO cost 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 and NA to indicate the element is not affected by the event. Round your final answers to the nearest whole dollaramount. Enter any decreases to account balances and cash outflow with a minus sign.)Show lessTHE BRICK COMPANY

Answer to Question: Panel 1 : FIFO Cost flow Event No. Cash + Inventory = Retained earnings…

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 like the following ones, assuming first a FIFO and then a LIFO cost 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 and NA to indicate the element is not affected by the event. Round your final answers to the nearest whole dollar mount Ente to account balances and cash outflow with a minUs sian

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 like the following ones, assuming first a FIFO and then a LIFO cost 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 and NA to indicate the element is not affected by the event. Round your final answers to the nearest whole dollar mount Ente to account balances and cash outflow with a minUs sian

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

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?
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?
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?
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?
My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
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.
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.
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.
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
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?