Page Layout Formulas Data Review View Tell me fx E.-9.2.A.0.9.0 v v Define Name Insert Function Text AutoSum Recently Financial Logical Used Ax & fx Date & Lookup & Math & Time Reference Trig More Functions Create from Select B19 B D H 1 Problem 4. The following is a cash forecast for January - March. The company has a policy which mandates that it can never have below 2 $600 in cash at the end of the month. If the company would have less than $600, must borrow on a line of credit. Use the IF function 3 to compute bomowing needed for each month Also put an appropriate formula in the total borowing needed coll. Note that 4 as you do this the amounts in ending cash will automatically adjust. Complete all other cols that are highlighted 5 Note: When you enter the IF formula, put the fomula in cel b21 and copy to c21 and 21 0 7 January February March Total 20 pont 8 9 Beg Cash $2,000 $0 $0 $650 10 11 Sales 15,000 12 000 8,000 35,000 12 13 Expenses 14 Cost of Sales 12.000 6,600 6,000 24,600 15 Miscellaneous 4.987 5.236 5.498 15.721 16 17 Total Expen 16.987 11.498 40,321 19 Income 20 21 Bonowing Needed 22 Ending Cash 24 26 27 38 20 30 33 34 35 3 41 Problem 2 Problema Problem 4 Problem Problem Problem 7 PA MacBook SC F2 000 000 F4 F3 FS F6