Question 1 (0.125 points) Use below case to answer questions 1-8. The Itsar Products Company has made the following monthly estimates of cash receipts and cash disbursements when preparing cash budgets for the next twelve months. Itsar Products has beginning cash on hand of $10,000 and wants to maintain this minimum cash level throughout the next year. Cash Cash 2 Month Receipts Disbursements January $100,000 $100,000 no February $110,000 $90,000 March $110,000 $80,000 $100,000 April $150,000 May $120,000 $180,000 June $160,000 $180,000 July $180,000 $200,000 $250,000 August $180,000 September $150.000 October $110.000 $250,000 $200,000 $140,000 $100,000 November $100,000 December $100,000 Will Itsar Products have a cash need during the next year? Type in Yes No Question 2 (0.125 points) If Itsar Products has a cash need, indicate the month when the need will begin? Question 3 (0.125 points) What is the net amount of cash needed in the above month? No commas, no decimal places. Question 4 (0.125 points) Determine the month when the maximum need will occur? Question 5 (0.125 points) Determine the amount when the maximum need will occur Question 6 (0.125 points) Which month of the next year the cumulative cash need (if any) can be repaid? Question 7 (0.125 points) What is the cash surplus amount in the above month? Question 8 (0.125 points) What is the cash need/surplus by the next year end? Use bracket for negative values. no commas, no decimal places. CASTILLO PRODUCTS COMPANY INCOME STATEMENT 2018 2019 5900 DOO $1.200.000 Cost of yoods sold 200.000 Gross profit so 800.000 Marketing 90.000 130.000 General and administrative 250.000 250.000 Depreciation 0000 0.00 EBIT 20.000 1000 Invest 45.000 . Earnings before taxes 5.000 100.000 Income taxes 2 2500 Net Income 365.000 375.000 BALANCE SHEET 2018 2019 Cash $ 50.000 3 20.000 Account 200.000 200.000 Inventories 300.000 Tocuments 650.000 300,000 450.000 540.000 Acordated depreciation 100.00 - 100.000 Nettet 51.000.00 1.200.000 AL path 5 130.000 $160.000 Accra Sa. 000 70.000 Baron 70,000 330.000 Lorem 200.000 200.000 SLOGO Question 10 (0.25 points) Calculate the sale-to-cash conversion period for 2019. Round by one decimal place. Question 11 (0.25 points) Calculate the purchase-to-payment conversion period for 2019. Round by one decimal place. I Question 12 (0.25 points) Determine the length of the Castillo Product's cash conversion cycle for 2019. Round by one decimal place. Question 1 (0.125 points) Use below case to answer questions 1-8. The Itsar Products Company has made the following monthly estimates of cash receipts and cash disbursements when preparing cash budgets for the next twelve months. Itsar Products has beginning cash on hand of $10,000 and wants to maintain this minimum cash level throughout the next year. Cash Cash 2 Month Receipts Disbursements January $100,000 $100,000 no February $110,000 $90,000 March $110,000 $80,000 $100,000 April $150,000 May $120,000 $180,000 June $160,000 $180,000 July $180,000 $200,000 $250,000 August $180,000 September $150.000 October $110.000 $250,000 $200,000 $140,000 $100,000 November $100,000 December $100,000 Will Itsar Products have a cash need during the next year? Type in Yes No Question 2 (0.125 points) If Itsar Products has a cash need, indicate the month when the need will begin? Question 3 (0.125 points) What is the net amount of cash needed in the above month? No commas, no decimal places. Question 4 (0.125 points) Determine the month when the maximum need will occur? Question 5 (0.125 points) Determine the amount when the maximum need will occur Question 6 (0.125 points) Which month of the next year the cumulative cash need (if any) can be repaid? Question 7 (0.125 points) What is the cash surplus amount in the above month? Question 8 (0.125 points) What is the cash need/surplus by the next year end? Use bracket for negative values. no commas, no decimal places. CASTILLO PRODUCTS COMPANY INCOME STATEMENT 2018 2019 5900 DOO $1.200.000 Cost of yoods sold 200.000 Gross profit so 800.000 Marketing 90.000 130.000 General and administrative 250.000 250.000 Depreciation 0000 0.00 EBIT 20.000 1000 Invest 45.000 . Earnings before taxes 5.000 100.000 Income taxes 2 2500 Net Income 365.000 375.000 BALANCE SHEET 2018 2019 Cash $ 50.000 3 20.000 Account 200.000 200.000 Inventories 300.000 Tocuments 650.000 300,000 450.000 540.000 Acordated depreciation 100.00 - 100.000 Nettet 51.000.00 1.200.000 AL path 5 130.000 $160.000 Accra Sa. 000 70.000 Baron 70,000 330.000 Lorem 200.000 200.000 SLOGO Question 10 (0.25 points) Calculate the sale-to-cash conversion period for 2019. Round by one decimal place. Question 11 (0.25 points) Calculate the purchase-to-payment conversion period for 2019. Round by one decimal place. I Question 12 (0.25 points) Determine the length of the Castillo Product's cash conversion cycle for 2019. Round by one decimal place
