Please provide complete and correct answer for both requirements and show all work like explanation , computation , formula with steps. Answer in text. Million thanks ! Elon Co.'s September balance sheet contains the following information:$ 41,100 (dr)138,600 (dr)3,000 (cr)26,950 (dr)CashAccounts receivable.Allowance for doubtful accountsMerchandise inventoryManagement has designated $41,100 as the firm's minimum monthly cash balance. Other Information about the firm and its operationsis as follows:a. Sales revenues of $386,000, $462,000, and $343,500 are expected for October, November, and December, respectively. All goodsare sold on account.b. The collection pattern for accounts receivable is 60% in the month of sale, 39% In the month following the month of sale, and 1%uncollectible, which is set up as an allowance.c. Cost of goods sold is 60% of sales revenues.d. Management's target ending balance of merchandise inventory is 10% of the current month's budgeted cost of goods sold.e. All accounts payable for Inventory are paid in the month of purchase.f. Other monthly expenses are $51,950, which includes $3,800 of depreciation and 45,950 of bad debt expense.g. In the event of a shortfall, the company borrows money. In contrast, in the event of excess cash, the company Invests in short-termInvestments. Borrowings and Investments are assumed to be made at the end of a month in Increments of $6,850.h. Interest on borrowings is 10% per year, payable every quarter, on the accumulated amount of the loan; similarly, Interest earned onInvestments is 8% per year on the accumulated Investments and is received every quarter. Investments can be matured and theprincipal amount redeemed in June or December of a year.Required:1. Prepare a merchandise purchases budget for October and November. Required:1. Prepare a merchandise purchases budget for October and November.Total needsTotal cash availableDeduct Disbursements:Total disbursementsExcess (deficiency) of cashFinancingElon Co.Merchandise Purchases Budget2. Prepare the cash budgets for October and November, including the effects of financing (borrowing or Investing). Interest is earnedor paid quarterly. (Any "Repayments" and "Interest" should be Indicated by a minus sign. Leave no cells blank - be certain to enter"0" wherever required.)InvestmentsBorrowingsRepaymentsInterestTotal financingOctober NovemberElon Co.Cash BudgetDecemberOctober November

A cash budget is a projection of a company's cash flows over a given time frame. The budget in…

Elon Co.'s September balance sheet contains the following information: $ 41,100 (dr) 138,600 (dr) 3,000 (cr) 26,950 (dr) Cash Accounts receivable. Allowance for doubtful accounts Merchandise inventory Management has designated $41,100 as the firm's minimum monthly cash balance. Other Information about the firm and its operations is as follows:

Elon Co.'s September balance sheet contains the following information: $ 41,100 (dr) 138,600 (dr) 3,000 (cr) 26,950 (dr) Cash Accounts receivable. Allowance for doubtful accounts Merchandise inventory Management has designated $41,100 as the firm's minimum monthly cash balance. Other Information about the firm and its operations is as follows:

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

please answer both parts with explantion computation, formula for each number thanks answer in text
The income statement approach to estimating uncollectible accounts expense is used by Burgess Wholesale. On March 31 the firm had accounts receivable in the amovnt of $630,000. The Allowance for Doubtful Accounts had a credit balance of $3,950. The controller estimated that uncollectible accounts expense would amount to one-half of 1% of the $5,200,000 of net sales made during March. This estimate was entered in the accounts by an adjusting entry on March 31. On April 12, an account receivable from Conrad Stern of $3,110 was deter- mined to be worthless and was written off. However, on April 24, Stern won several thousand dollars on a TV game show and immediately paid the $3,110 past-due EXERCISE 8-3 Accounting for Uncollectible Accounts-The "Income State- ment" Method account. INSTRUCTIONS Prepare four journal entries in general journal form to record the above events.
Calvani, Inc., has a cash cycle of 43.5 days, an operating cycle of 63 days, and an inventory period of 27 days. The company reported cost of goods sold in the amount of $342,000, and credit sales were $565,000. Required: What is the company's average balance in accounts payable and accounts receivable?
The following information is taken from Reagan Company's December 31 balance sheet: Cash and cash equivalents $ 8,419 Accounts receivable 70,422 Merchandise inventories 60,362 Prepaid expenses 4,100 Accounts payable $ 14,950 Notes payable 86,638 Other current liabilities 9,500 If net sales for the current year were $612,000, the firm's days' sales uncollected for the year is: (Use 365 days a year.)
Company Abel has total sales of $364,500, of which, $60,500 represent cash sales. Its annual average accounts receivable balance is $74,400. Company Baker has total sales of $367,450, of which, $63,475 represent cash sales. Its annual average accounts receivable balance is $54,500. Which company has the favorable accounts receivable turnover experience?
Valenzuela, Incorporated, has a cash cycle of 41.5 days, an operating cycle of 59.3 days, and an inventory period of 25.6 days. The company reported cost of goods sold in the amount of $465,000, and credit sales were $749,000. What is the company's average balance in accounts payable and accounts receivable? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. Average accounts payable Average accounts receivable
.
d
The following Information is from the annual financial statements of Raheem Company. Net sales Year 3 $ 368,000 Accounts receivable, net (year-end) 36,900 Year 2 $ 299,000 34,700 Year 1 $ 342,000 31,400 (1) Compute its accounts receivable turnover for Year 2 and Year 3. (2) Assuming its competitor has a turnover of 15.4, Is Raheem performing better or worse at collecting receivables than its competitor? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute its accounts receivable turnover for Year 2 and Year 3. Accounts Receivable Turnover Choose Numerator: Choose Denominator: Accounts Receivable Turnover Net sales Average accounts receivable, net = Year 2: $ 299,000 Accounts receivable turnover 0 times Year 3: $ 368.000 0 times Required 2 >>
Selected data from Jordan Company follow: Accounts receivable Allowance for doubtful accounts Net accounts receivable Inventories, lower of cost or market Net credit sales Net cash sales. Balance Sheets As of December 31 Net sales Cost of goods sold Selling, general, and administrative expenses Other expenses Total operating expenses a. Accounts receivable turnover b. Inventory turnover c. Net margin Income Statement For the Years Ended December 31 Year 3 $ 405,000 (20,250) $ 384,750 $ 475,000 times times % Year 2 $ 377,000 (15,080) $ 361,920 $ 433,000 Required a. Compute the accounts receivable turnover for Year 3. b. Compute the inventory turnover for Year 3. c. Compute the net margin for Year 2. Note: For all requirements, round your answers to 2 decimal places. Year 2 $ 1,759,000 Year 3 $ 2,001,000 409,000 2,410,000 308,000 2,067,000 1,598,000 1,426,000 240,600 214,200 22,000 40,000 $ 1,878,600 $ 1,662,200
Mifflin Company reported the following for the current year: Net sales $ 60,000 Cost of goods sold 38,000 Beginning balance in accounts receivable 14,000 Ending balance in accounts receivable 6,000 Compute (a) accounts receivable turnover and (b) days’ sales uncollected. Compute the accounts receivable turnover. Accounts Receivable Turnover Numerator: / Denominator: = Accounts Receivable Turnover / = Accounts receivable turnover / = times Compute the days’ sales uncollected. Days' Sales Uncollected Numerator: / Denominator: × Days = Days' Sales Uncollected / × = Days' sales uncollected / × = days
The general ledger of Hubert Corporation provides the following information: End of Year Beginning of Year Accounts Receivable $ 125,000 $ 94, 000 Inventory 280,000 210,000 Accounts Payable 130,000 65,000 The company's net sales for the year were $2,850,000 and cost of goods sold amounted to $1,650,000. Instructions Calculate the following: a) Cash receipts from customers. b) Cash payments to suppliers.