Calculate January Net Cash Flow (Labeled Y Below):January$10,000$4,000SalesCurrent MonthCollection (40%)Previous MonthCollection (60%)Total Cash ReceiptsEstimated CashPayments (100%)Net Cash FlowO $17,000O $1,000$7,000O $22,000O $14,000$0X$3,000YFebruary$15,000$6,000$6,000$12,000$15,000ZMarch$20,000$8,000$9,000$17,000$12,000$5,000PEPawan das LIELASER 71956 FRENTEBATHARK FOpracoVer PSeher von NSuSEPAREPANEVF BYSTOLEN LETTEE478FMeASPER2FuldePEVESA20CHRICSU BAGHE1250TPARFSE1620

The objective of the question is to calculate the net cash flow for the month of January. Net cash…

Answered: Calculate January Net Cash Flow…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter16: Working Capital Policy And Short-term Financing

Section: Chapter Questions

Problem 12P

See similar textbooks

Similar questions

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 $22,000 $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 February Net Cash Flow (Labeled Z Below): January February March Sales $10,000 $15,000 $20,000 Current Month Collection (40%) $4,000 $6,000 $8,000 Previous Month Collection (60%) $0 $6,000 $9,000 Total Cash Receipts X $12,000 $17,000 Estimated Cash Payments (100%) $3,000 $15,000 $12,000 Net Cash Flow Y Z $5,000 Group of answer choices $54,000 $27,000 $15,000 $3,000 ($3,000)
Prepare a cash Collection Schedule for Producers Inc. For the months of March, April and May 2022 using the ff. data: Jan Feb Mar Apr P78,300 May P83,000 Sales P75,300 P82,100 P88,000 Cash Basis 30% Credit Basis 70% (50% collected in month of Sales, 30% in month after sale and 20% 2 mos after sale)
27 Calculate the Cumulative loan balance for the month of July. The desired minimum required cash balance is $75,000. Balance at the begining of January is $80,000. (Just write the numbers. Do not use any punctuation marks or $ sign) June August Cash Budget Total cash receipts Total cash payments Net cash flow Beginning cash balance Cumulative cash balance Monthly loan or (repayment) Cumulative loan balance Ending cash balance Numeric Response July $165,600 $270,800 $305,200 246,000 268,000 295.300 -80,400 80,000 -400 75,400 75,400 $75,000 2,800 75,000 77,800 ? $75,000 9,900 75,000 84,900 -9,900 62,700 $75,000
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.
From the following data, Forecast the cash position at the end October, November and December 2020 Month Sales(RO) Purchases (RO) Salaries Miscellancot August 60,000 42,000 5,000 3,500 September 65,000 50,000 6,000 4,000 October 40,000 52,000 4,000 3,000 November 58,000 53,000 5,000 6,000 December 44,000 40,000 4,000 3,000 Additional Information 1. Sales: 10% realized in the month of sales, balance realised equally in two subsequent months. 2. Purchases are paid in the month following the month of supply. 3. 10% of the wages are paid in the following month. 4. Miscellaneous expenses paid a month in arrears. 5. Rent of RO 500 per month paid quarterly in advance due in October. 6. First Instalment of Income Tax of RO 15,000 due on or before 15 December. 7. Income from Investment RO 3,000 received quarterly in October 2020 and Janu: 2021. 8. Cash in hand RO 3,000 on 1" October 2020.
# 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:
Data regarding a company's monthly sales for the last six months of the year and its projected collection patterns are shown below:Forecasated sales:July = P775,000August = P750,000September = P825,000October = P800,000November = P850,000December = P900,000Types of sales:Cash sales = 20%Credit sales = 80%Collection pattern for credit sales:In the month of sale = 40%In the first month following the sale = 57%Uncollectible = 3% The cost of merchandise averages 40% of its selling price. The company's policy is to maintain an inventory equal to 25% of the next month's forecasted sales. The inventory balance at cost is P80,000 as of June 30. How much is the total cash receipts that would be budgeted for the month of September?
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
Given: Cash Receipts for September =PHP 305,450; October = PHP 85,405; and November =PHP 375,195. Cash Disbursements for September =PHP 215,485; October = PHP 250,265; and November = PHP 310,525. Beginning Cash Balance (September) = PHP 35,975. Minimum Monthly Cash Balance Needed = PHP 34,425. The ending cash for September is PHP O 160,365 O 125,940 O 89,965 O 91,515
Serendipity, Inc. prepared cash estimates for the 3rd quarter of 2021 (3-months). The following estimates were developed for certain items: July August September Cash sales P 60,000 P 80,000 P 150,000 Credit sales 30,000 60,000 90,000 Purchases 60,000 55,000 75,000 Payroll 40,000 50,000 60,000 Other expenses 20,000 25,000 30,000 In June, credit sales totaled P50,000 and purchases totaled P60,000. May credit sales were P70,000. Accounts receivable collections amount to 50% in the month after the…
Cost of goods sold = 100,000 Merch at Beginning = 50,000Merch at End = 45,000 Acct Payable Beginning = 30,000Acct Payable End = 40,000 What is Cash paid for merch this year?

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS