Question: Based on the following data table, please provide the cash flow statement from Day 1 to Day 365 for the company. Please be sure to

 Based on the following data table, please provide the cash flow

Based on the following data table, please provide the cash flow statement from Day 1 to Day 365 for the company. Please be sure to include the year ending cash position. Hint: You need to: 1. Create an income statement 2. Read the Notes carefully Account Notes Day 1 ($000's) Day 365 ($000's) Monthly Sales $0 COGS - % of sales 70% $40,000 Sales, expenses etc. in the Income Statement are the same for all 12 months 70% Company pays all COGS in 60 Days or two months $6,000 Company pays operating expenses during each month 25% Company pays taxes 3 months after they are due $20,000 Paid on day 90 of year one Cash Flow Statement ($000's) Net Profit Accounts Payable Accrued Taxes Depreciation Accounts Receivable Inventory $0 Monthly Operating Expenses Income Tax Liability - % of Income before taxes Capital Investment (PPE) during year Depreciation for total year 25% $0 Cash from Operations PPE $0 $15,000 Included in COGS and Operating Expenses (above) utilized for the Income Statement Calculate Cash $25,000 Cash Used in Investing Bonds Owners Paid in Capital Accounts Receivable $0 Cash from Financing Activities Inventory Accounts Payable Bonds Issued Accrued Taxes Owners Paid-in Capital Retained Earnings Owner's Equity SO $0 $0 $0 Calculate $0 Calculate Calculate Customers pay invoices in 45 days or one and one-half months $35,000 Calculate $30,000 10 year maturity Calculate Calculate Calculate Calculate Ending Cash

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!