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 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
Get step-by-step solutions from verified subject matter experts
