08 Jul [Excel]Accounting For Liabilities, Equity And Expense
As 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?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.