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 | |||
Homework Answers
Answer #1
Not the answer you're looking for?
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.
ADVERTISEMENT
Active Questions
asked 29 minutes ago
asked 29 minutes ago
asked 49 minutes ago
asked 51 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago