Question: PLEASE EXPLAIN IN EXCEL STEP BY STEP 1. Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent

PLEASE EXPLAIN IN EXCEL STEP BY STEP 1. Eastern Auto Parts

Inc. has 25 percent of its sales paid for in cash and

PLEASE EXPLAIN IN EXCEL STEP BY STEP

1. Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. Assume the following sales: (15 pts] January $5000 February $5000 March $10000 April $15000 May $100000 June $200000 Sale in December of the prior year were $10,000. Complete the table below using the assumptions and instructions in the following steps. (a) Prepare a cash receipt schedule (b) Assume further that the items are sold for $20 each and that a level production schedule will be used over the next 6 months. Generate a monthly production schedule. (c) Assume that at the start of January Eastern Auto Parts had inventory schedule. Assume they started with 0 units. (d) Determine the cash payment schedule. Assume the production cost is $10 per item. (e) Determine the months (if any) for which there the cash balance is below zero (assume we start off with 0 cash). 2. Complete the following table for the financial year ending in Dec 30, 2017 using finan- cial statements from Office Depot (5 points) Ratio Average Inventory Average Receivables Average Payables daily Sales daily COGS daily Purchases Use the information you computed above to complete the table: value (days) DIO DSO DPO CCC If the industry average Cash conversion cycle is 40 days (using a threshold of 2 days) Which of the following is true: (a) The firm has superior cash conversion cycle (b) The firm has inferior cash conversion cycle (c) The firm has an average cash conversion cycle 1. Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. Assume the following sales: (15 pts] January $5000 February $5000 March $10000 April $15000 May $100000 June $200000 Sale in December of the prior year were $10,000. Complete the table below using the assumptions and instructions in the following steps. (a) Prepare a cash receipt schedule (b) Assume further that the items are sold for $20 each and that a level production schedule will be used over the next 6 months. Generate a monthly production schedule. (c) Assume that at the start of January Eastern Auto Parts had inventory schedule. Assume they started with 0 units. (d) Determine the cash payment schedule. Assume the production cost is $10 per item. (e) Determine the months (if any) for which there the cash balance is below zero (assume we start off with 0 cash). 2. Complete the following table for the financial year ending in Dec 30, 2017 using finan- cial statements from Office Depot (5 points) Ratio Average Inventory Average Receivables Average Payables daily Sales daily COGS daily Purchases Use the information you computed above to complete the table: value (days) DIO DSO DPO CCC If the industry average Cash conversion cycle is 40 days (using a threshold of 2 days) Which of the following is true: (a) The firm has superior cash conversion cycle (b) The firm has inferior cash conversion cycle (c) The firm has an average cash conversion cycle

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1- Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. Assume the following sales: January $...

Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. Assume the following sales: January February...

Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. Assume the following sales: $ January February...

4 Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. 0.33 points Assume the following sales:...

Eastern Auto Parts Inc. has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. Assume the following sales: February March...

Eastern Auto Parts, Inc., has 25 percent of its sales paid for in cash and 75 percent on credit. All credit accounts are collected in the following month. Assume the following sales: January $ 67,000...

Two charges, each +4 C, are on the x axis, one at the origin and the other at x = 8 m. Find the electric field on the x axis at (a) x = 2 m, (b) x = 2 m, (c) x = 6 m, and (d) x = 10 m. (e) At what...

Answers to the following questions about JP Morgan chase & co. What notable accounting considerations are there for companies in this industry? What legal or Regulatory matters are of concern?...

involves the basic cross - tabulation within various subgroups of the sample. spurious analysis elaboration analysis marginal tabulation index analysis

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...