Gears Cash Flow Statement January |
|
Cash on Hand (beginning of month) | 67,173.13 |
CASH RECEIVED | |
Cash Sales | 10,288.28 |
Credit Sales Accounts | 53,064.30 |
TOTAL CASH RECEIVED | |
CASH PAID OUT | |
Inventory | 17,340.04 |
Payroll expenses | 10,928.19 |
Supplies (office & oper.) | 3,276.61 |
Repairs & maintenance | 2,149.60 |
Advertising | 566.82 |
Car, delivery & travel | 332.61 |
Accounting & legal | 88.60 |
Rent | 3,063.66 |
Telephone | 161.95 |
Utilities | 369.35 |
Insurance | 1,094.69 |
Taxes (real estate, etc.) | 356.13 |
Miscellaneous | 379.61 |
TOTAL CASH PAID OUT | |
CASH POSITION (END OF MONTH) |
Gears Cash flow statement January |
|
cash received | |
cash on hand | 67173.13 |
cash sales | 10288.28 |
Total cash received | 77461.41 |
Cash paid out | |
Inventory | 17,340.04 |
Payroll expenses | 10,928.19 |
Supplies (office & oper.) | 3,276.61 |
Repairs & maintenance | 2,149.60 |
Advertising | 566.82 |
Car, delivery & travel | 332.61 |
Accounting & legal | 88.60 |
Rent | 3,063.66 |
Telephone | 161.95 |
Utilities | 369.35 |
Insurance | 1,094.69 |
Taxes (real estate, etc.) | 356.13 |
Miscellaneous | 379.61 |
Total cash paid out | 39207.86 |
Cash position at the end of the month | 38253.55 |
Gears Cash Flow Statement January Cash on Hand (beginning of month) 67,173.13 CASH RECEIVED Cash...
Using the AYK2_Data.xlsx data file, complete the cash flow
statement for Gears, using Excel. Be sure to create formulas so the
company can simply input numbers in the future to determine cash
flow.
57% .. AT&T < Back 4:04 PM AYK2_Data_Version_1.xlsx H AYK 2 Cash Flow Gears Cash Flow Statement January Cash on Hand (beginning of month) 18,456 CASH RECEIVED Cash Sales Credit Sales Accounts TOTAL CASH RECEIVED 23,894 36,421 CASH PAID OUT Inventory Payroll expenses Supplies (office & oper.)...
Of the following list, which accounts are Balance Sheet, income statement, etc? Cash on Hand Checking Savings Accounts receivable Warranty Receivable New Motorcycle Inventory New ATV Inventory New Scooter Inventory New Power Equipment Inventory New Other Products Inventory Used Motorcycle, AATV, Scooter I Sublet Repairs-RO's in progress Parts Inventory Accessories Inventory Service Machinery & Equipment Accumulated Depreciation-Service Parts & Accessories Office Equipment & Fixtures Company Vehicles and Rental Units Leasehold Improvements Accounts Payable - Trade Accounts Payable - Sweep Acct...
Create a cash flow with the following information: Sales Projection for the month is $30,000 75 % of sales are expected to be collected in current month and the remaining 25% to be collected in the following month. Cost of Goods equals =45% of sales (Materials) 15% of sales (direct labor) 15% of sales (subcontractors) *Materials and subcontractors and paid in the following month while direct labor is paid in the month worked* The owners deposit $20,000 in the bank...
Please show work
A store accidentally priced an item at $20 instead of $30 and honored the mispricing. Where should the store attribute the $10 difference? SELECT ONLY ONE Returns and Allowances Profit (Loss) Sales Operating Expenses Cost of Goods Sold Mr. Decker invested $20,000 in cash in his new business. How does the company record the investment? SELECT ONLY ONE debit Cash and credit Investments debit Cash and credit Retained Earnings debit Cash and credit Owner's Equity credit Cash...
On January 2, 200XX, Chris Blackwell opened a Hotel called Dolphins Cove. During the first month of operations, the business completed the following transactions. 20XX Jan. 2 Chris issued 25,000 shares of common stocks for cash $50,000. 2 Paid $2,400 in advance for rent. 3 Purchase equipment for $12,000 on account. 5 Paid $1,500 cash for advertising. 11 Received cash for fees earned, $9,750. 17 Purchased office supplies for cash, $1,400. 22 Billed customer for fees earned, $16,390. 27 Paid...
Transactions Concrete Consulting Co. has the following accounts in its ledger: Cash; Accounts Receivable; Supplies; Office Equipment; Accounts Payable; Jason Payne, Capital; Jason Payne, Drawing; Fees Earned; Rent Expense; Advertising Expense; Utilities Expense; Miscellaneous Expense. Oct. 1. Paid rent for the month, $3,100. 3. Paid advertising expense, $2,000. 5. Paid cash for supplies, $860. 6. Purchased office equipment on account, $13,200. 10. Received cash from customers on account, $4,290. 15. Paid creditors on account, $1,260. 27. Paid cash for miscellaneous...
Concrete Consulting Co. has the following accounts in its ledger: Cash; Accounts Receivable; Supplies; Office Equipment; Accounts Payable; Jason Payne, Capital; Jason Payne, Drawing; Fees Earned; Rent Expense; Advertising Expense; Utilities Expense; Miscellaneous Expense. Transactions Oct. 1 3 6 10 15 27 30 31 31 31 Paid rent for the month, $2,300. Paid advertising expense, $700. Paid cash for supplies, $1,250. Purchased office equipment on account, $9,600. Received cash from customers on account, $17,000. Paid creditors on account, $3,180. Paid...
Concrete Consulting Co. has the following accounts in its ledger: Cash; Accounts Receivable; Supplies; Office Equipment; Accounts Payable; Jason Payne, Capital; Jason Payne, Drawing; Fees Earned; Rent Expense; Advertising Expense; Utilities Expense; Miscellaneous Expense. Transactions Oct. 1 Paid rent for the month, $2,200. 3 Paid advertising expense, $550. 5 Paid cash for supplies, $1,200. 6 Purchased office equipment on account, $9,300. 10 Received cash from customers on account, $16,950. 15 Paid creditors on account, $3,000. 27 Paid cash for miscellaneous...
Donut Information Based on the below data, create the profit model for Donuts to Go. Assume that each customer will buy one donut and one cup of coffee Sales estimate range from 200-5000 per week Time period Revenue: Cup of Coffee Revenue: Donut Donut ingredients per donunt) paper products: napkins, plates etc Insurance $4.00 $3.50 $0.60 per donut $5,550.00 month $200.00 Maintenance & Repairs to equipment month Marketing & Promotion: Advertising month Coffee per cup Coffee cups per cup Payroll:...
Gabi Gram started The Gram Co., a new business that began operations on May 1. The Gram Co. completed the following transactions during its first month of operations. May1G. Gram invested $45,000 cash in the company.1The company rented a furnished office and paid $2,100 cash for May’s rent.3The company purchased $5,220 of office equipment on credit.5The company paid $760 cash for this month’s cleaning services.8The company provided consulting services for a client and immediately collected $5,300 cash.12The company provided $3,000 of...