70.2K

Verified Solution

Link Copied!

FAST answer please

just need option

4G In. : Question 17 2 pts The following case study is associated with more than one question. It is now the beginning of Quarter 1 (Q.1). Imagine you are the finance director for Zip. Trading PLC and have just been presented with your team's credit sales forecast for the next five quarters. Zp. Trading PLC Credit sales Credit purchases Wages, taxes and expenses Interest due on long term debt Capital Expenditure (Capex) Beginning accounts receivable Ending accounts receivable Collections from credit sales Accounts payable coming due Beginning cash balance Change in cash Ending cash balance Assumptions Credit purchases percentage of next period forecast sales Last Q.1 Q2 Q.3 0.4 Q.5 300 5330 9315 355 356 370 148.50 10500 115.50 16.00 16.50 16.50 17.00 17.00 17.00 0.00 0.00 35.00 0.00 0.00 0.00 58333 E83 33 591.67 321 67 14400 73.00 E4567 E7300 11867 45% 25% 45% 45% 45% 45% Wages, taxes and expenses as a percentage of current period sales Days per quarter Receivables collection period days Payables period in days Minimum cash balance slowed Interest rate on short term investments 35% 35% 35% 36% 35% 90 90 90 90 25 25 25 25 25 30 30 30 30 30 20 20 $ $8888 2 88883 35% 90 25 30 20 15% 15% 15% 15% 15% 1.5% 1 : 83 33 591 67 532167 14400 73.00 54567 E73.00 118.67 4G II. Beginning accounts receivable Ending accounts receivable Collections from credit sales Accounts payable coming due Beginning cash balance Change in cash Ending cash balance Assumptions Credit purchases percentage of next period forecast sales Wages, taxes and expenses as a percentage of current period sales Days per quarter Receivables collection period days Payables period in days Minimum cash balance alowed Interest rate on short term investments 45% 45% 45% 45% 45% 45% 95% 35% 35% $8888 35 90 25 30 35% 90 25 30 120 35% 90 25 25 88889 25 30 20 25 620 E20 15% 15% 15% 1.5% 15% 1.5% REQUIRED: Beginning accounts receivable in Zip's forecast balance sheet for Q.4 are forecast at: 83.33 91.67 87.50 98.61 4G lli. : Question 18 2 pts The following case study is associated with more than one question. It is now the beginning of Quarter 1 (Q.1). Imagine you are the finance director for Zip. Trading PLC and have just been presented with your team's credit sales forecast for the next five quarters. 2p. Trading PLC Last 01 02 03 04 05 Credit sales 3006330 095 366 X 320 Credit purchases 54850 Wages, tres and expenses E10500 115.50 Interest dur on long term debit 16.00 6.99 14.12.09 2.9 17.00 Capital Expenditure Capex) 00:00 000 COS.CO 60.00 60.00 60.00 Benning accounts receivable 2800 Ending accounts receivable 8333 167 Collections from credt sales 25 Accounts payable contingue 14400 Beginning cash balance 13.00 Change in cash CA7 Ending cash lance 173.00 Assumptions Credit purchases percentage ned period forecast 48 Wapestanes and expenses percentage of current periode 35% 95% 95% 36% 36% 36% Days per quanto 30 SO 90 90 Receivables collection period days 25 25 25 25 25 25 Payables period in days 30 30 30 30 30 Minimum cash balance slowed E20 20 20 520 620 520 Interest rate on short term Levestments 15% 1% 15% 15% 15% 15% REQUIRED: Zip's accounts payable coming due in 2.4 are maman 4G II. : llave just been presenteu Will your team's credit sales forecast for the next five quarters. Dip. Trading PLC Last 01 02 03 04 0.5 Credits 300 330 355 365 366 370 Credit purchases E548.50 Wages, tanes and expenses 105.00 550 Interest due on long term debt E1600 5.591699 17.09 17.99 $17.00 Capital Expenditure Capex) 20.00 D 0 E35.00 0.00 0.00 50.00 Beginning accounts receivable ER 35 Ending accounts receivable 68333 6912 Collections from credite 32167 Accounts payable coming due 5200 Beginning cash balance 03.00 Change in cash 5567 Ending cash balance 300 18:52 Assumptions Credit purchases percentage of next perlod forecast Wagestoes and expenses a percentage of current period sales 35 35 35 35% 35% 35% Dayo per quanto 90 90 80 90 90 Receivables collection period des 25 25 25 25 25 25 Payables period in daya 30 30 30 30 30 30 Minimum cash balance allowed 520 520 520 E20 Interest rate on short term REQUIRED: Zip's accounts payable coming due in Q.4 are forecast at: 144.00 153.75 162.75 O 165.75 4G In. : Question 17 2 pts The following case study is associated with more than one question. It is now the beginning of Quarter 1 (Q.1). Imagine you are the finance director for Zip. Trading PLC and have just been presented with your team's credit sales forecast for the next five quarters. Zp. Trading PLC Credit sales Credit purchases Wages, taxes and expenses Interest due on long term debt Capital Expenditure (Capex) Beginning accounts receivable Ending accounts receivable Collections from credit sales Accounts payable coming due Beginning cash balance Change in cash Ending cash balance Assumptions Credit purchases percentage of next period forecast sales Last Q.1 Q2 Q.3 0.4 Q.5 300 5330 9315 355 356 370 148.50 10500 115.50 16.00 16.50 16.50 17.00 17.00 17.00 0.00 0.00 35.00 0.00 0.00 0.00 58333 E83 33 591.67 321 67 14400 73.00 E4567 E7300 11867 45% 25% 45% 45% 45% 45% Wages, taxes and expenses as a percentage of current period sales Days per quarter Receivables collection period days Payables period in days Minimum cash balance slowed Interest rate on short term investments 35% 35% 35% 36% 35% 90 90 90 90 25 25 25 25 25 30 30 30 30 30 20 20 $ $8888 2 88883 35% 90 25 30 20 15% 15% 15% 15% 15% 1.5% 1 : 83 33 591 67 532167 14400 73.00 54567 E73.00 118.67 4G II. Beginning accounts receivable Ending accounts receivable Collections from credit sales Accounts payable coming due Beginning cash balance Change in cash Ending cash balance Assumptions Credit purchases percentage of next period forecast sales Wages, taxes and expenses as a percentage of current period sales Days per quarter Receivables collection period days Payables period in days Minimum cash balance alowed Interest rate on short term investments 45% 45% 45% 45% 45% 45% 95% 35% 35% $8888 35 90 25 30 35% 90 25 30 120 35% 90 25 25 88889 25 30 20 25 620 E20 15% 15% 15% 1.5% 15% 1.5% REQUIRED: Beginning accounts receivable in Zip's forecast balance sheet for Q.4 are forecast at: 83.33 91.67 87.50 98.61 4G lli. : Question 18 2 pts The following case study is associated with more than one question. It is now the beginning of Quarter 1 (Q.1). Imagine you are the finance director for Zip. Trading PLC and have just been presented with your team's credit sales forecast for the next five quarters. 2p. Trading PLC Last 01 02 03 04 05 Credit sales 3006330 095 366 X 320 Credit purchases 54850 Wages, tres and expenses E10500 115.50 Interest dur on long term debit 16.00 6.99 14.12.09 2.9 17.00 Capital Expenditure Capex) 00:00 000 COS.CO 60.00 60.00 60.00 Benning accounts receivable 2800 Ending accounts receivable 8333 167 Collections from credt sales 25 Accounts payable contingue 14400 Beginning cash balance 13.00 Change in cash CA7 Ending cash lance 173.00 Assumptions Credit purchases percentage ned period forecast 48 Wapestanes and expenses percentage of current periode 35% 95% 95% 36% 36% 36% Days per quanto 30 SO 90 90 Receivables collection period days 25 25 25 25 25 25 Payables period in days 30 30 30 30 30 Minimum cash balance slowed E20 20 20 520 620 520 Interest rate on short term Levestments 15% 1% 15% 15% 15% 15% REQUIRED: Zip's accounts payable coming due in 2.4 are maman 4G II. : llave just been presenteu Will your team's credit sales forecast for the next five quarters. Dip. Trading PLC Last 01 02 03 04 0.5 Credits 300 330 355 365 366 370 Credit purchases E548.50 Wages, tanes and expenses 105.00 550 Interest due on long term debt E1600 5.591699 17.09 17.99 $17.00 Capital Expenditure Capex) 20.00 D 0 E35.00 0.00 0.00 50.00 Beginning accounts receivable ER 35 Ending accounts receivable 68333 6912 Collections from credite 32167 Accounts payable coming due 5200 Beginning cash balance 03.00 Change in cash 5567 Ending cash balance 300 18:52 Assumptions Credit purchases percentage of next perlod forecast Wagestoes and expenses a percentage of current period sales 35 35 35 35% 35% 35% Dayo per quanto 90 90 80 90 90 Receivables collection period des 25 25 25 25 25 25 Payables period in daya 30 30 30 30 30 30 Minimum cash balance allowed 520 520 520 E20 Interest rate on short term REQUIRED: Zip's accounts payable coming due in Q.4 are forecast at: 144.00 153.75 162.75 O 165.75

Answer & Explanation Solved by verified expert

See Answer