Sales Purchases December $140,000 $35,000 January 46,000 35,000 February 64,000 35,000 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheed a. Prepare a cash budget for December, January, and February, Use a minus sign to enter negative values for net cash flows, cumulative NCF values, and loans needed, if any. If the answer is zero, enter 'o'. Do not round intermediate calculations, Round your answers to the nearest dollar Collections and Purchases: January February December 5 $ Sales $ $ Purchases $ Sales $ $ $ Purchases $ $ $ Payments for purchases $ s $ Salaries $ $ 5 Rent $ $ $ Taxes $ Total payments $ Cash at start of forecasts $ $ Net cash flow $ $ $ Cumulative NCF 5 $ $ $ $ $ Target cash balance Surplus cash or loans needed $ $ b. Suppose Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company's loan requirements be at the end of December in this case? (Hint: The calculations required to answer this question are minimal.) Use a minus sign to enter a negative value for loan requirements Do not round Intermediate calculations. Round your answer to the nearest dollar Salaries Rent $ $ Taxes 5 Total payments $ $ Cash at start of forecast $ Net cash flow $ $ $ Cumulative NCF $ $ $ Target cash balance Surplus cash or loans needed b. Suppose Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company's loan requirements be at the end of December in this case? (Hint: The calculations required to answer this question are minimal.) Use a minus sign to enter a negative value for loan requirements. Do not round intermediate calculations. Round your answer to the nearest dollar. B D m F G H 1 022 Jx A 1 Cash Budgeting 2 3 Monthly salary 4 Monthly rent 5 December tax payment 6 Current cash on hand, December 1 7 Target cash balance 8 November purchases 9 December sales 10 December purchases 11 January sales 12 January purchases 3 February sales 4 February purchases 5 6 Cash Budget Sales (Collections) $4,100 $2,100 $14,000 $800 $5,500 $150,000 $140,000 $35,000 $46,000 $35,000 $64,000 $35,000 December January February $140,000 $46,000 $64.000 Purchases $35.000 $35,000 $35,000 Formulas WN/A #NIA ANIA Payments: For purchases Salary Rent Sheet1 $4,100 $2.100 $4,100 $2,100 $4,100 $2,100 + E F G H I 3 K 6 Cash Budget 7 Sales Collections) 3 9 Purchases B D December January February $140,000 $46,000 $64,000 $35,000 $35,000 $35,000 Formulas AN/A WNIA ONIA 1 Payments: 2 For purchases 3 Salary Rent 5 Taxes Total payments $4,100 $2,100 $14.000 $4,100 $2,100 $4,100 S2 100 WNIA ANIA #NIA $800 3 Cash at start of forecast 3 Net cash flow 3 Cumulative NCF Target cash balance Surplus cash or loans needed #N/A #N/A ANA WNIA WNA #N/A $5.500 $5.500 $5.500 N/A ONIA INIA Suppose firm sels on credit Number of days customers have to pay Company loan requirements on December 31 30 #N/A Asheet1 Sales Purchases December $140,000 $35,000 January 46,000 35,000 February 64,000 35,000 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheed a. Prepare a cash budget for December, January, and February, Use a minus sign to enter negative values for net cash flows, cumulative NCF values, and loans needed, if any. If the answer is zero, enter 'o'. Do not round intermediate calculations, Round your answers to the nearest dollar Collections and Purchases: January February December 5 $ Sales $ $ Purchases $ Sales $ $ $ Purchases $ $ $ Payments for purchases $ s $ Salaries $ $ 5 Rent $ $ $ Taxes $ Total payments $ Cash at start of forecasts $ $ Net cash flow $ $ $ Cumulative NCF 5 $ $ $ $ $ Target cash balance Surplus cash or loans needed $ $ b. Suppose Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company's loan requirements be at the end of December in this case? (Hint: The calculations required to answer this question are minimal.) Use a minus sign to enter a negative value for loan requirements Do not round Intermediate calculations. Round your answer to the nearest dollar Salaries Rent $ $ Taxes 5 Total payments $ $ Cash at start of forecast $ Net cash flow $ $ $ Cumulative NCF $ $ $ Target cash balance Surplus cash or loans needed b. Suppose Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company's loan requirements be at the end of December in this case? (Hint: The calculations required to answer this question are minimal.) Use a minus sign to enter a negative value for loan requirements. Do not round intermediate calculations. Round your answer to the nearest dollar. B D m F G H 1 022 Jx A 1 Cash Budgeting 2 3 Monthly salary 4 Monthly rent 5 December tax payment 6 Current cash on hand, December 1 7 Target cash balance 8 November purchases 9 December sales 10 December purchases 11 January sales 12 January purchases 3 February sales 4 February purchases 5 6 Cash Budget Sales (Collections) $4,100 $2,100 $14,000 $800 $5,500 $150,000 $140,000 $35,000 $46,000 $35,000 $64,000 $35,000 December January February $140,000 $46,000 $64.000 Purchases $35.000 $35,000 $35,000 Formulas WN/A #NIA ANIA Payments: For purchases Salary Rent Sheet1 $4,100 $2.100 $4,100 $2,100 $4,100 $2,100 + E F G H I 3 K 6 Cash Budget 7 Sales Collections) 3 9 Purchases B D December January February $140,000 $46,000 $64,000 $35,000 $35,000 $35,000 Formulas AN/A WNIA ONIA 1 Payments: 2 For purchases 3 Salary Rent 5 Taxes Total payments $4,100 $2,100 $14.000 $4,100 $2,100 $4,100 S2 100 WNIA ANIA #NIA $800 3 Cash at start of forecast 3 Net cash flow 3 Cumulative NCF Target cash balance Surplus cash or loans needed #N/A #N/A ANA WNIA WNA #N/A $5.500 $5.500 $5.500 N/A ONIA INIA Suppose firm sels on credit Number of days customers have to pay Company loan requirements on December 31 30 #N/A Asheet1