Create a cash budget for the first six months of 2000 used on the follow hond to their montre projected to be Sweet INCREASE ch month by 145.000 Conctions where to Collected within the Collected month were Uncollectable 15 EN 59 Export month we wted to be INCREASE eth month by Monthly depreciation included the who mu SOOD 2 51.000 This new combi 200 with a cash balance 25 000 The common woman cash balance (gel balance 550.000 The company would like to maintain the minimum cash balance, as stated above. How much would the company need to borrow if they want to maintain the minimum cash balance (target balance) each month? How much surplus would they have over the minimum cash balance each month? Don't assume they will borrow. We only want to Gilculate how much they would need to borrow, or how much of a surplus they would have each month) Prepare a monthly cash budget for the first six months of 2009. Calculate the loan requirement and surplus cash for each month of the six month cash budget using IF functions. (For each month of the cash budget, use a formula to calculate the loan requirement, and the surplus. The last two lines of the cash flow statement should be LOAN REQUIREMENT SURPLUS Place all of the assumptions at the top of the spreadsheet, and use them. (USE ABSOLUTES. THERE SHOULD BE NO NUMBERS TYPED IN ANY FORMULAS OR IN THE CASH BUDGET STATEMENT NUMBERS SHOULD BE TYPED IN THE ASSUMPTIONS AREA ONLY) Create a cash budget for the first six months of 2000 used on the follow hond to their montre projected to be Sweet INCREASE ch month by 145.000 Conctions where to Collected within the Collected month were Uncollectable 15 EN 59 Export month we wted to be INCREASE eth month by Monthly depreciation included the who mu SOOD 2 51.000 This new combi 200 with a cash balance 25 000 The common woman cash balance (gel balance 550.000 The company would like to maintain the minimum cash balance, as stated above. How much would the company need to borrow if they want to maintain the minimum cash balance (target balance) each month? How much surplus would they have over the minimum cash balance each month? Don't assume they will borrow. We only want to Gilculate how much they would need to borrow, or how much of a surplus they would have each month) Prepare a monthly cash budget for the first six months of 2009. Calculate the loan requirement and surplus cash for each month of the six month cash budget using IF functions. (For each month of the cash budget, use a formula to calculate the loan requirement, and the surplus. The last two lines of the cash flow statement should be LOAN REQUIREMENT SURPLUS Place all of the assumptions at the top of the spreadsheet, and use them. (USE ABSOLUTES. THERE SHOULD BE NO NUMBERS TYPED IN ANY FORMULAS OR IN THE CASH BUDGET STATEMENT NUMBERS SHOULD BE TYPED IN THE ASSUMPTIONS AREA ONLY)
