Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 - A A 29 Wrap Text Accounting Paste B IU a. Av Margo & Conte $ % ) Conditional Formatting Rocover Unstved Workbooks. We were able to save changes to one or more files. Do you want to recover them? G44 x fe D G H 9 You we given the data for a company for 12 months. The company uses short-term loans and marketable securities Investments to bring the cash balance to the desired level at the end of each month. Short-term loans will be paid down or paid off with any excess balances and marketable securities will be used only when the loan balance is zero. Marketable securities will be sold first to supply any needed cash Infusions before loans are used. The company had no marketable securities and no short-term loans at the beginning of January The company expects to make an outlay for new capital equipment in May, June, July, of August. Create a drop-down list in Cell L24 for the user to select the month of the outlay. Use this and other input information to complete the Cash Budget. Then complete the section that gives the balance of short-term loans at the end of each month in Row 52 and the balance of marketable securities at the end of each month in Row S. The formulas should show positive balances when marketable securities are being used, and it should show zero when marketable securities are not being used. Format the range 143:43 (net cash flow) so that all values less than zero display as red numbers instead of black numbers for any values of the inputs. Name the input cells for collections Collecto, Collect1, and Collect 2. Then create and save three scenarios using the Scenario Manager that show the company's monthly net cash flow for April - December while changing the collection rates. The GOOD scenario will use Collecto Sox, Collection, and Collect2 - 20%, the NORMAL scenario will use the base case collection rates given here, and the BAD scenario will use Collecto, Collect1 - 10%, and Collect2.60. Save a summary of the scenarios on a separate tabbed page. 10 11 -12 13 14 15 16 17 11 19 INPUTS 20 Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 - A A 29 Wrap Text Accounting Paste B IU a. Av Margo & Conte $ % ) Conditional Formatting Rocover Unstved Workbooks. We were able to save changes to one or more files. Do you want to recover them? G44 x fe D G H 9 You we given the data for a company for 12 months. The company uses short-term loans and marketable securities Investments to bring the cash balance to the desired level at the end of each month. Short-term loans will be paid down or paid off with any excess balances and marketable securities will be used only when the loan balance is zero. Marketable securities will be sold first to supply any needed cash Infusions before loans are used. The company had no marketable securities and no short-term loans at the beginning of January The company expects to make an outlay for new capital equipment in May, June, July, of August. Create a drop-down list in Cell L24 for the user to select the month of the outlay. Use this and other input information to complete the Cash Budget. Then complete the section that gives the balance of short-term loans at the end of each month in Row 52 and the balance of marketable securities at the end of each month in Row S. The formulas should show positive balances when marketable securities are being used, and it should show zero when marketable securities are not being used. Format the range 143:43 (net cash flow) so that all values less than zero display as red numbers instead of black numbers for any values of the inputs. Name the input cells for collections Collecto, Collect1, and Collect 2. Then create and save three scenarios using the Scenario Manager that show the company's monthly net cash flow for April - December while changing the collection rates. The GOOD scenario will use Collecto Sox, Collection, and Collect2 - 20%, the NORMAL scenario will use the base case collection rates given here, and the BAD scenario will use Collecto, Collect1 - 10%, and Collect2.60. Save a summary of the scenarios on a separate tabbed page. 10 11 -12 13 14 15 16 17 11 19 INPUTS 20