Calculate January Net Cash Flow (Labeled Y Below): January $10,000 $4,000 Sales Current Month Collection (40%) Previous Month Collection (60%) Total Cash Receipts Estimated Cash Payments (100%) Net Cash Flow O $17,000 O $1,000 $7,000 O $22,000 O $14,000 $0 X $3,000 Y February $15,000 $6,000 $6,000 $12,000 $15,000 Z March $20,000 $8,000 $9,000 $17,000 $12,000 $5,000

Calculate January Net Cash Flow (Labeled Y Below): January $10,000 $4,000 Sales Current Month Collection (40%) Previous Month Collection (60%) Total Cash Receipts Estimated Cash Payments (100%) Net Cash Flow O $17,000 O $1,000 $7,000 O $22,000 O $14,000 $0 X $3,000 Y February $15,000 $6,000 $6,000 $12,000 $15,000 Z March $20,000 $8,000 $9,000 $17,000 $12,000 $5,000

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

KAYAK COMPANYCash Budget JanuaryFebruaryMarchBeginning cash balance$30,000 $30,000 Add: Cash receipts525,000 400,000 450,000 Total cash available555,000 430,000 Less: Cash payments for All items excluding interest Interest on loan Total cash payments0 0 0 Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan balanceLoan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month$0 $0 $0
Consider the following information for a given company: Month Cash Sales Credit Sales Jan $80.000 $350,000 Feb $60,000 $200,000 Mar $50.000 $145,000 Apr $45,000 $130,000 May $55,000 $170,000 Jun $50,000 $150,000 The firm's collection pattern is as follows: 60% in the month of sale 30% one month following sale 10% two months following sale The accounts receivable balance on 1 Jan is $70,000. Of this amount, $60,000 represents uncollected Dec sales and $10,000 represents uncollected Nov sales. Required: Determine the total cash collected during Jan. (INPUT YOUR ANSWER IN THOUSANDS USING A COMMA SEPARATOR. NO ROUNDING REQUIRED. FOR EXAMPLE: 100,000)
5 At Lyman Company, past experience reveals that 10% of sales are for cash and the remaining 90% are on credit. Lyman Company expects to collect 30% of its credit sales in the month of sale, 50% in the month following sale, and 18% in the second month following sale. Which ONE of the following is part of the cash collections expected to be made in January? O Cash sales from the preceding December O Cash collections of credit sales from the preceding December O Cash collections of credit sales from the preceding September O Cash sales from the preceding November
Schedule of Cash Payments Tadpole Learning Systems Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $184,900 April 172,000 May 156,500 Depreciation, insurance, and property taxes represent $39,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taves for the year will be paid in November. 71% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, Apri, and May. Enter all amounts as positive numbers. TADPOLE LEARNING SYSTEMS INC. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March Apr May March expenses Paid in March Paid in April Apri expenses Paidin April Pad in May May expenses Prepare a…
acc
Forecasted cash receipts and expenditure for the period August to October are as follows: Cash Receipts Expenditure $ $ 60,000 58,000 July August September October 54000 68,000 90,000 30,000 44,000 Additional information provided: ✓ Expenditure for the period July to October includes monthly depreciation of $5,000. ✓ Payment for the cash related expenditure would be 40% in the month of purchase, the balance being paid the following month. The company intends to sell equipment valued at $25,000 in September. Insurance of $25,000 is payable in December. Opening cash balance as at August 1, $18,800. Required: Prepare a monthly Cash Budget for the period August to October 2021.
On July 10, 2020, Bridgeport Music sold CDs to retailers on account and recorded sales revenue of $764.000 (cost $588,280) Bridgeport grants the right to return CDs that do not sell in 3 months following delivery, Past experience indicates that the normal return rate is 15%. By October 11, 2020, retailers returned CDs to Bridgeport and were granted credit of $78,200. Prepare Bridgeport's journal entries to record (a) the sale on July 10, 2020, and (b) $78,200 of returns on October 11, 2020, and on October 31, 2020. Assume that Bridgeport prepares financial statement on October 31, 2020. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No entry for the account titles and enter O for the amounts.) Account Titles and Explanation No. € (b) Date (To record sales) (To record cost of goods sold) (To record sales) (To record cost of goods sold) (To record sales returns) (To record cost of goods returned) Debit…
November December January February March Actual Actual Forecast Forecast Forecast 80 000 150 000 180 000 240 000 300 000 • The cash from sales are received as follows: o 30% in the month of sale o 40% 1 month after sale o 30% 2 months after sale • Purchases are 65% of sales • Cash purchases are made in the following manner: o 20% cash in the month of purchase o 40% 1 month after purchase o 40% 2 months after purchase • Cash dividends of R15 000 was received in January • Rentals of R7 500 are due and paid at the end of each month • The company has 1 salaried employee who is paid each month • Wages incurred and paid equate to 8% of the previous months sales • The company bought a new machine in March for R250 000. Only a deposit of R130 000 was due and payable in March • A provisional tax payment of R30 000 was made at the end the February • R15 000 interest was paid against the company’s bank account in February • Dividends declared at the end of March amounted to R20 000. A 1st payment…
# 2 The table below highlights Deluna Company's expected sales Month RM January 100,000 February 120,000 March 110,000 The collection on sales for Deluna Company is structured in the following manner: • In the month of sale - 30 percent • One-month after-sale - 60 percent • Two months after-sale - 8 percent • Uncollectible bad debt - 2 percent Compute the total cash receipts in March:
Raghubhai
The cash balance at the beginning of September is £ 20,000. ii. Actual sales for July and August and expected sales for September are as follows: July August September Cash sales £ 19,000 £ 29,000 £ 39,000 Sales on account £ 6,000 £ 8,000 £ 9,000 iii. Sales on account are collected over a three-month period as follows: 10% collected in the month of sale, 80% collected in the following sale, and 7% collected in the second month following sale. The remaining 3% is uncollectible.iv. Purchases of inventory will total £ 24,000 for September. 20% of month’s inventory purchases are paid for during the month of purchase. The accounts payable remaining from Augusts’ inventory purchases total £ 15,000, all of which will be paid in September. v. Selling and administrative expenses are budgeted at £ 13,000 for September. Of this amount £ 4,000 is for depreciation. vi. Equipment costing £ 18,000 will be purchased for cash during September, and dividends totalled £3,000 will be paid during the…
Sales $ 950,000 Cost of goods sold 630,000 Utilities expense 4,600 Administrative salaries 190,000 Sales commissions 5% of sales Advertising 38,000 Depreciation on store equipment 68,000 Rent on administration building 78,000 Miscellaneous administrative expenses 28,000 All operating expenses are paid in cash in the month incurred. Compute the total budgeted selling and administrative expenses (excluding interest) amount for January Year 2. $415,500 $454,100 $384,000 $454,000