[excel]Accounting for Liabilities, Equity and Expense

Accounting for Liabilities, Equity and ExpenseAs the first half of 2012 came to a close CNE was in position to be a leader in the sale of high end computer networking equipment for broadcast media companies.  As demand was forecasted to increase to 12,500 units per year over the next 7 years the company invested $600,000 in new equipment to increase the capacity of its manufacturing facility.   It financed this new equipment purchase through a combination of debt and equity.  In April, CNE received a $300,000 loan from a commercial bank at 7% interest.  Starting on May 1st principal and interest payments of 3,500 are to be paid on a monthly basis over 10 years.  Also in April, CNE issued $300,000 of common stock to a private venture capital firm.  50,000 shares were issued at a par value of $3 per share.  To support sales growth, CNE extended generous accounts receivable terms to its customers.  As a result, CNE’s cash cycle lengthen where inventory and A/R days outstanding reached a combined 90 days in the first half of 2012.  To generate more operating cash flow, the company decided to rely more heavily on accounts payable.  In June of 2012 all purchases for raw materials were switched  from a cash basis to A/P with 2/10, n/30 terms.  Based on early payment discounts from its suppliers CNE adopted a policy of paying within the 10 day window.   Figure 1 on the following page shows the schedule of the company’s raw material purchases by month and when CNE paid for each purchase. As the second quarter of 2012 came to a close profits were at a record high.  CNE declared a cash and stock dividend at the end of June.  The cash dividend was set at $.25 cents per share and the stock dividend was set at 10% of total outstanding stock with a par value of $3 per share.  Total outstanding stock at the end of June was 100,000 shares.  The dividends were distributed in September.   The stock was trading at $6 per share at the time the dividends were declared and distributed.          Assumptions: 1. For this exercise ignore calculating and journalizing the current portion of long-term debt.2. CNE has a fiscal year end on September 30th. 3. Do not worry about journalizing accounting entries for fixed assets or depreciation expense on fixed assets. You will need to account for Cash and Inventory.4. Beginning balance is given in “Begin Balance” file.Your Task:  · Based on the information provided create CNE’s general journal for the months of April through September as it impacts expense, liabilities and equity. · Conduct schedule for principle and interest calculation. · Using the new journal entries to update the ledger and trial balance from part I. Then use the adjusted trial balance to conduct balance sheet and income statement. Using the ratios we learned from this class, and evaluate the financial performance of CNE. Do you think the company is doing well?