About assignment 1 , question 1-9, i don't know how to solve

CNE: Impacts on the Balance Sheet and Income Statement As the rst quarter came to a close profits were at a record high. CNE declared a cash and stock dividend in the month of March. The cash dividend was set at 5.50 cents per share and the stock dividend was set at 5% of total outstanding stock with a par value of $2 per share. Total outstanding stock at the end of March was 200,000 shares. The dividends were distributed in April. The stock was trading at $8 per share at the time the dividends were declared and distributed. Additional Assumptions: 1. Purchases for capital equipment and installation were paid for in cash in January. The capital equipment was installed on Januaryr 315'. Start depreciating the equipment in February. 2. All units are manufactured in the same month of the raw material purchase. 3. Direct Labor is paid for in cash at the end of each month. Questions for Integrative Assignment #2. Assuming CNE Inc. could receive 1/15 n/30 terms from its suppliers for its accounts payable (A/P), how much cash would CNE Inc. pay to its suppliers from January through April? 2. Again, assuming 1/15, n/30 terms from Its suppliers, and CNE Inc. adopting a policy of paying its suppliers early based on these terms, what would CNE Inc.'s accounts payable (A/P) ending balance be at the end of March if the beginning A/P balance was zero at the beginning of January? 3. Based on the assumptions given in questions 1 and 2 regarding A/P terms and policies, what is the dollar amount adjustment (If none input 0}, CNE Inc. needs to make to inventory in the month of April? 4. In the month of April, what will be CNE Inc. interest payment on its $750,000 loan? 5. In the month of April what will be the remaining balance on CNE Inc.'s loan? 6. Given CNE Inc.'s stock and cash dividend declaration, what is the dollar amount impact to its balance sheet account "Cash Dividend Payable" (If none enter 0), in the month of March? 7. Given CNE Inc.'s stock and cash dividend declaration, what is the dollar amount impact to its balance sheet account "Additions to Paid in Capital", (if none enter 0), In the month of March? 8. Given CNE Inc.'s stock and cash dividend declaration, what is the dollar amount impact to CNE Inc.'s overall shareholder equity? CNE: Impacts on the Balance Sheet and Income Statement CNE Inc. sells computer network equipment. The early part otthe year turned out to be highly profitable for CNE with record breaking sales from January through March. Exhibit A on page 3 shows the breakout of the number of units sold to CNE' s primary customers including when each customer purchased product, when the order was shipped, the number of units purchased and the price per unit. To help expedite sales CNE offered 1/10, n/30 credit terms to all of its customers. Integrative Design took advantage of these credit terms with Integrative Design paying within 10 days after the ship date of its product. Acore paid for its purchase 35 days after the ship date of its product. While Xplex paid 50% ofthe order amount at the time it order its product and planned on paying the remaining 50% of its order 45 days after the ship date of its product. Unfortunately, on April 10th Xplex declared bankruptcy and did not pay the remaining accounts receivable balance. To generate more operating cash flow, the company decided to rely more heavily on accounts payable. In January, all purchases for raw materials were switched from a cash basis to accounts payable with n/30 terms. Exhibit B on page 3 shows the schedule of the company' s raw material purchases by month and when CNE paid for each purchase. To remain competitive CNE expanded its output by auto mating its production process. On January 152 CNE spent $1,000,000 for new robotic equipment and spent another $200,000 to have the equipment installed. The robotic equipment has a useful life up to 10 years. The salvage value of this equipment is estimated at $100,000. As a result of automating its production process, CNE was able to reduce its direct labor cost down to 57'5 dollars per unit. CNE nanced this new equipment purchase through a combination of debt and equity. On January lst, CNE received a $750,000 loan from a commercial bank at 6% interest. Starting on February 15: principal and interest payments of 11,055 are to be paid on a monthly basis over 7 yea rs. Also, in January CNE issued $750,000 of common stock. In this offering, 100,000 shares were issued at a par value of $3 per share. Exhibit A - Sales Schedule Total Purcashed Company Order Date Shipped Date Units Price Amount Integrative Design January 15th February 15th 200 $ 950 $ 190,000 Xplex February 15st March 1st 275| $ 950 261,250 Acore March 1st April 1st 325 $ 950 $ 308,750 Exhibit B - Raw Material Purchase Schedule Total Units Purchased Date Received Cost Per Unit Purchased Amount Date Paid January 1st 280 225 $ 63,000 January 9th February 1st 313 275 $ 86,075 February 14th March 1st 290 350 $ 101,500 April 3rd April 1st un 320 250 $ 80,000 April 13thQuestions for Integrative Assignment #1. 1. How much revenue did CNE Inc. record in the month of March? 2. For the month of March how much additional accounts receivable did CNE Inc. add to its balance sheet? 3. Assuming that the accounts receivable balance was zero at the end of January what was the ending accounts receivable balance at the end of April? 4. How much did CNE Inc. record to its cash account in February for the sale of its product? 5. Using the First In First Out (FIFO) method, how much Cost of Goods Sold did CNE Inc. record in the month of March? 6. Again, assuming FIFO, if the inventory balance at the end of January was $79,875 what was the ending inventory balance at the end of April? 7. What is the total depreciable amount of CNE Inc's. new capital equipment at the time of its purchase on January lst? 8. What will be the depreciation expense that CNE Inc. will record for all of year 2 using the "Double Declining" method? 9. Again, using the "Double Declining" method, what will be the ending depreciable balance amount of this capital equipment at the end of year 3