Question 1The management of Target is expecting to commence its operations on June 1, 2022, selling awide range of household items. The company will commence operations with the followingassets:CashInventoryEquipment.LandBuildingsProjected sales for the first four months of 2022 are as follows:JuneJulyAugustSeptember336,000696,0001,200,000Cost of goods soldBad debts744,0004,800,000Thirty per cent of the company's sales will be for cash and the remaining 70 per cent will be oncredit. Sixty-five per cent of the receivables (credit sales) will be collected in the month of thesale and 30 per cent in the following month. The remaining receivables will be deemed bad.Some expenses are expected to vary with the sales in each month as follows:3,360,0006,720,0007,800,0009,600 000Variable selling expensesVariable administration expensesSellingAdministrationDepreciationWages and salariesGeneral expenses65% of sales3% of salesEighty per cent of the merchandise purchased will be paid for in the month in which the purchaseis made and the balance will be paid for in the following month. Seventy-five per cent of thevariable expenses will be paid for in the month in which they were incurred and the balance thefollowing month.4% of sales5% of salesThe ending inventory of each month should be equal to one-fifth of the amount estimated forcost of sales for the coming month. The fixed expenses will be paid for in t month in whichthey are incurred. These expenses for each month are as follows:350,000240.00075,000120,000156,000The company proposes to make an additional investment in equipment of $270,000 in August2022 to handle the increase in sales levels. The company must maintain a bank balance eachmonth of $120 000. The company can borrow any additional funds from the local bank at 5 percent interest per month.(1) Prepare the following schedules for the months of June, July and August, 2022.a) Cash collections scheduleb) Purchases budgetc) Cash disbursement schedule for purchasesd) Cash disbursement schedule for expenses(ii) Use the information from the schedules at (1) above to prepare a cash budget for the monthsof June, July and August, 2022.

Budget : An Estimate is the process of calculation or judgment of the value, number, quantity.It is…

Question 1 The management of Target is expecting to commence its operations on June 1, 2022, selling a wide range of household items. The company will commence operations with the following assets: Cash Inventory Equipment 336,000 696,000 1,200,000 744,000 4,800,000 Land Buildings Projected sales for the first four months of 2022 are as follows: June 3,360,000

Question 1 The management of Target is expecting to commence its operations on June 1, 2022, selling a wide range of household items. The company will commence operations with the following assets: Cash Inventory Equipment 336,000 696,000 1,200,000 744,000 4,800,000 Land Buildings Projected sales for the first four months of 2022 are as follows: June 3,360,000

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter1: Accounting And The Financial Statements

Section: Chapter Questions

Problem 38E: Exercise 1-38 Identifying Current Assets and Liabilities Dunn Sporting Goods sells athletic clothing...

See similar textbooks

Similar questions

Exercise 1-39 Current Assets and Current Liabilities Hanson Construction has an operating cycle of '5' months. On December 31. 2019, Hanson has the following assets and liabilities: A note receivable in the amount of $1500 10 be collected in 6 months Cash totaling $1,380 Accounts payable totaling $2,100, all of which will be paid within 2 months Accounts receivable totaling $12,000, including an account for $7,000 that will be paid in 2 months and an account for $5,000 that will be paid in 18 months Construction supplies coming $6,200, all of which will be used in construction within the next 12 months Construction equipment costing $60,000 on which depreciation of $22,400 has accumulated A note payable to the bank in the amount of $6,800 is to be paid within the next year Required: Calculate the amounts of current assets and current liabilities reported on Hansons balance sheet at December 31, 2019. CONCEPTUAL CONNECTION Comment on Hansons liquidity.
Exercise 1-50 Statement of Cash Flows OBJECTIVE o Walters Inc. began operations on January I. 2019. The following information relates to Walters cash flows during 2019. Required: 1. Calculate the cash provided/fused for each cash flow category. 2. CONCEPTUAL CONNECTION Comment on Walters creditworthiness.
Exercise 1-38 Identifying Current Assets and Liabilities Dunn Sporting Goods sells athletic clothing and footwear 10 retail customers. Dunns accountant indicates that the firms operating cycle averages 6 months. At December 31, 2019, Dunn has the following assets and liabilities: Prepaid rent in the amount of 58,500. Dunns rent is $500 per month. A $9,700 account payable due in 45 days. Inventory in the amount of $46,230. Dunn expects to sell $38,000 of the inventory within 3 months. The remainder will be placed in storage until September 2020. The items placed in storage should be sold by November 2020. An investment in marketable securities in the amount of $1,900. Dunn expects to sell $700 of the marketable securities in 6 months. The remainder are not expected to be sold until 2022. Cash in the amount of $1,050. An equipment loan in the amount of $60,000 due in March 2024. Interest of $4,500 is due in March 2020 ($3,750 of the interest relates to 2019. with the remainder relating to the first 3 months of 2020). An account receivable from a local university in the amount of $2,850. The university has promised to pay the full amount in 3 months. Store equipment at a cost of $9,200. Accumulated depreciation has been recorded on the store equipment in the amount of 51,250. Required: Prepare the current asset and current liability portions of Dunns December 31, 20191 balance-sheet. Compute Dunns working capital and current ratio at December 31, 2019. CONCEPTUAL CONNECTION As in investor or creditor. what do these ratios tell you about Dunns liquidity?
Cornerstone Exercise 1-18 Balance Sheet An analysis of the transactions of Cavernous Homes Inc. yields the following totals at December 31, 2019: cash, $3,200; accounts receivable, $4,500; notes payable, $5,000; supplies, $8,100; common stock, $7,000; and retained earnings, 9,800. Required: Prepare a balance sheet for Cavernous Homes Inc. at December 31 , 2019.
(Appendix 21.1) Visual Inspection The following changes in account balances were taken from Walson Companys adjusted trial balance at the end of 2019: In addition, the following information was obtained from the companys records: Land was sold, at cost, for 1,900. Dividends of 4,000 were declared and paid. Equipment was purchased for 10,400. Common stock was issued for 9,000. Beginning cash balance was 17,000. Required: Using visual inspection and the direct method, prepare Walsons 2019 statement of cash flows. (A separate schedule reconciling net income to cash provided by operating activities is not necessary.)
Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
Return on assets ExxonMobil Corporation (XOM) explores, produces, and distributes oil and natural gas. The Coca-Cola Company (KO) produces and distributes soft drink beverages, including Coke. Wal-Mart Stores, Inc.., (WMT) operates retail stores and supermarkets. The following data (in millions) were taken from recent financial statements of each company: Compute the return on assets for each company using the preceding data, and rank the companies’ return on assets from highest to lowest. Round the return on assets to one decimal place.
(Appendix 21.1) Operating Cash Flows The following is accounting information taken from Woodrail Companys adjusted trial balance for 2019: In addition, the following changes occurred in selected accounts during 2019: Required: Using the direct method, prepare the cash flows from operating activities section of the 2019 statement of cash flows for Woodrail.
Required: Solutions and explanation The beginning cash balance of Arizona Corp. is P700,000. It foresees the following cashflows for the month: (A) Collections from customers - P1,000,000, (B) Payments to suppliers - P550,000, (C) Other operating cash expenses - P50,000, (D) Payments to creditors - P50,000 and (E) collection of a receivable from an officer - P80,000. If Arizona needs to have a month-end balance of P1,000,000, how much should it borrow or (invest)? * (P130,000) P110,000 (P110,000) P130,000
Problem 2-24 Calculating Cash Flow Use the following information for Ingersoll, Inc., (assume the tax rate is 21 percent): 2019 2020 Sales $ 11,573 $ 15,832 Depreciation 1,661 1,736 Cost of goods sold 3,979 4,707 Other expenses 946 824 Interest 776 926 Cash 6,067 6,466 Accounts receivable 8,034 9,427 Long-term debt 20,320 24,636 Net fixed assets 50,888 54,273 Accounts payable 5,555 5,791 Inventory 14,283 15,288 Dividends 1,411 1,618 For 2020, calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Cash flow from assets Cash flow to creditors Cash flow to stockholders
B. Application and Creation1. Case A – Algeria Co.Below are the cash transactions of Alderia Co. for December 31, 2015.Cash payment to suppliers of goods and services(25,000)Cash receipts from rendering of services 50,000Payment to owners (5,000)Proceeds from bank loans 25,000Proceeds from cash investment of owners 115,000Payment for acquisition of equipment 100,000Cash at the beginning of the year 1,000,000Instructions: Prepare the statement of cash flow using the indirect method.After which, answer the following questions. How much is cash flow from operating activities? How much is cash flow from investing activities? How much is cash flow from financing activities? How much is the net increase or decrease in cash for the year? How much is cash as at December 31, 2015?
Effect of transactions on cash flows The financial year for Gamma Limited ends on 30 June 2019. Management has asked you what effect each of the following June transactions will have on net profit before tax, cash flow from operations, cash flow from investing and cash flow from financing for the year ended 30 June 2019: 1. Sent invoices for $40 000 to customers during June for work carried out in June; $19 000 of this had been collected by year-end. 2. Borrowed $300 000 from the bank on 10 June, with principal and interest repayable in six months. Accrued interest at 30 June is $2500. 3. Paid salaries for the month of $80 000, with $5000 in wages owing at year-end. 4. Received $30 000 deposit on a job that will be carried out in July 2019. 5. Paid accounts payable of $35 000 which was outstanding at 31 May 2019. 6. Sold old equipment for $20 000. The equipment originally cost $300 000 with accumulated depreciation at the time of sale of $250 000. 7. Purchased new equipment on 20 June…