Question

you are tasked with creating a Statement of Cash Flow. The spreadsheet with the information and...

you are tasked with creating a Statement of Cash Flow. The spreadsheet with the information and instructions is here

Date Transaction Description Receipts Payments
1/1/2020 Cash deposit to start business $ 10,000.00
1/1/2020 Three month's rent $    2,400.00
1/1/2020 Cash register paid for $        450.00
1/1/2020 Store furniture paid for $    8,500.00
1/31/2020 Receipts for sales in January 2020 $    6,500.00
2/7/2020 Widgets supplied in January paid for $    4,500.00
2/25/2020 Cash withdrawn for your own expenses $    3,000.00
2/29/2020 Receipts for sales in February 2020 $    9,000.00
3/15/2020 Widgets supplied in February paid for $    6,000.00
3/16/2020 Store utility charges for Jan, Feb, Mar 2020 $        300.00
3/31/2020 Receipts for sales March 2020 $ 12,000.00
3/31/2020 Balance in bank on March 31st 2020 $ 12,350.00
$ 37,500.00 $ 37,500.00
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Date Transaction Description Receipts Payments 1/1/2020 Cash deposit to start business $ 10,000.00 1/1/2020 Three month's...
Date Transaction Description Receipts Payments 1/1/2020 Cash deposit to start business $ 10,000.00 1/1/2020 Three month's rent $   2,400.00 1/1/2020 Cash register paid for $      450.00 1/1/2020 Store furniture paid for $   8,500.00 1/31/2020 Receipts for sales in January 2020 $   6,500.00 2/7/2020 Widgets supplied in January paid for $   4,500.00 2/25/2020 Cash withdrawn for your own expenses $   3,000.00 2/29/2020 Receipts for sales in February 2020 $   9,000.00 3/15/2020 Widgets supplied in February paid for $   6,000.00 3/16/2020 Store...
Balance Sheet Assets: 12/31/19 Current Assets: Cash $               3,000.00 Accounts Receivable             &nb
Balance Sheet Assets: 12/31/19 Current Assets: Cash $               3,000.00 Accounts Receivable                    1,250.00 Prepaid Expenses $                    100.00 Total Current Assets $               4,350.00 Non-Current Assets: Property, Plant, and Equipment Land $            10,000.00 Buildings                 25,000.00 Equipment                 15,000.00 Accumulated Depreciation $          (12,000.00) Total Property, Plant, and Equipment $            38,000.00 Total Assets $            42,350.00 Liabilities: Current Liabilities Accounts Payable $                    100.00 Accrued Expense                         150.00 Salary and Wages Payable                                      -   Notes Payable                                      -   Unearned Revenue $               1,500.00 Total Liabilities $              ...
Company has prepared the following schedules and additional​ information: LOADING... ​(Click the icon to view the...
Company has prepared the following schedules and additional​ information: LOADING... ​(Click the icon to view the cash receipts​ schedule.)                 LOADING... ​(Click the icon to view the cash payments​ schedule.) LOADING... ​(Click the icon to view the additional​ information.) Complete a cash budget for GrahamGraham Company for JanuaryJanuary​, FebruaryFebruary and MarchMarch. ​(Complete all answer boxes. Enter a​ "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during...
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $300,000 $320,000 $290,000 Cash disbursements 280,000 360,000 300,000 The expected cash balance at January 1, 2016, is $82,000. Brewster wants to maintain a cash balance at the end of each month of at least $80,000. Short-term borrowings at 1%...
Mitchell, Inc. needs to develop a cash budget for Q1 2020. Sales in January, February and...
Mitchell, Inc. needs to develop a cash budget for Q1 2020. Sales in January, February and March are expected to be $20,000, $22,500 and $24,650 respectively. 30% of all sales are paid cash. 50% of sales are paid within 1 month and 20% are paid within 2 months. The company spends $14,000 a month to operate the business. Create the cash budget for Q1 2020.
Exercise 9-18 Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The...
Exercise 9-18 Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020...
Jackson Bottle Yard, a recycling glass company, has supplied the following information in relation to their...
Jackson Bottle Yard, a recycling glass company, has supplied the following information in relation to their actual sales in 2019 and planned sales for the first quarter of 2020. Cash Credit Total $ $ $ 2019 Actual Sales for November 25,000 25,000 50,000 December 35,000 40,000 75,000 2020 Estimated Sales for January 15,000 20,000 35,000 February 18,000 30,000 48,000 March 22,000 40,000 62,000 Past records indicate that expected receipts collected from debtors will be:                60 per cent in the...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $200,000 February 240,000 March 340,000 All sales are on account. 50% of sales are expected to be collected in the month of the sale, 46% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $145,000 $180,000 $247,000 Manufacturing costs 61,000 77,000 89,000 Selling and administrative expenses 42,000 49,000 54,000 Capital expenditures _ _ 59,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT