The Cash Budget for Bithlo Barbecues from June-September 2005 is shown below.

40% (B7) of the sales are for cash, 45% (B8) are collected in the following month and 15% (B9) are collected two months after the sale. Inventory purchases (Row 11) are equal to 50% (B11) of the following months sales. 60% (B13) of these purchases are paid for in the month following the purchase and the remainder (B14) is paid two months after the purchase. The firm has a minimum cash requirement of $15,000 (B33) and has to borrow funds (Row 30) if cash is below the minimum requirement.

FINA 350: Financial Analyticu \& Madels Midterm Exam Spring 2023 s0 points a. (2 points) Write down the formula for cell F8. (Use Cell References) b. (2 points) Write down the formula for cell G11, (Use Cell References) c. (2 points) Write down the formula for cell F29. (Use Cell Reterences) d. (3 points) Write down the formula for cell E30. (Use Cell References)