Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Construct the cashflow statements (Cashflow from operations, investing, & financing with the following data and verify the change in cash is equal to the sums
Construct the cashflow statements (Cashflow from operations, investing, & financing with the following data and verify the change in cash is equal to the sums of the cash flows for every year. Meaning...
2005-2006 | 2006-2007 | |
Change in cash | 26,886 | (6,180) |
CFO+CFI+CFF | 26,886 | (6,180) |
Below is the data.
2005 | 2006 | 2007 | |
Net sales | - | 4,316,036 | 8,662,734 |
Cost of goods sold | - | 3,332,702 | 5,639,622 |
Gross profit | - | 983,334 | 3,023,112 |
Operating expenses: | |||
Administrative expenses | - | 99,480 | 245,324 |
Amortization | - | 88,888 | 232,104 |
Insurance | - | 70,444 | 43,594 |
Marketing & advertising | - | 147,516 | 250,950 |
Miscellaneous | - | 133,634 | 188,578 |
Rent | - | 654,330 | 519,906 |
Repairs & maintenance | - | 122,922 | 298,442 |
Security | - | 60,944 | 138,058 |
Supplies & expenses | - | 100,022 | 176,530 |
Telephone | - | 118,546 | 142,680 |
Travel & entertainment | - | 81,962 | 65,894 |
Utilities | - | 33,438 | 53,010 |
Vehicle expenses | - | 54,314 | 62,024 |
Wages | - | 793,612 | 921,768 |
Total operating expenses | - | 2,560,052 | 3,338,862 |
Operating income | - | (1,576,718) | (315,750) |
Other income | - | - | 31,884 |
Interest expense | - | 438,316 | 703,256 |
Net income (loss) | - | (2,015,034) | (987,122) |
2006 | 2006 | 2007 | |
Cash | - | 26,886 | 20,706 |
Accounts receivable | - | 25,380 | 11,064 |
Inventory | - | 1,359,144 | 708,984 |
Total current assets | - | 1,411,410 | 740,754 |
Fixed assets | |||
Automobile | - | 85,242 | 117,126 |
Furniture & fixtures | - | 254,904 | 609,928 |
Equipment | - | 194,202 | 429,938 |
Leasehold improvements | - | 293,520 | 662,388 |
- | 827,868 | 1,819,380 | |
Less: Accumulated depreciation | - | 88,888 | 320,992 |
Net fixed assets | - | 738,980 | 1,498,388 |
Total assets | - | 2,150,390 | 2,239,142 |
Accounts payable | - | 391,932 | 1,209,066 |
Bank line of credit | - | 1,518,678 | 1,586,528 |
Current portion due on bank loan | - | 74,388 | 78,784 |
Total current liabilities | - | 1,984,998 | 2,874,378 |
Bank loan | - | 260,426 | 180,920 |
Loan payable | - | 1,200,000 | 800,000 |
Shareholder's loans | - | - | 666,000 |
Total long-term liabilities | - | 1,460,426 | 1,646,920 |
Common stock | - | 720,000 | 720,000 |
Retained earnings | - | (2,015,034) | (3,002,156) |
Total equity | - | (1,295,034) | (2,282,156) |
Total liabilities & equity | - | 2,150,390 | 2,239,142 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started