please diregard the question attached . i figured it out

Create stude for the festix months of 2000 both mit So the first month are to be Sains rected to INCREASE ch months by 145.000 Collection is to be Collected with the Colinded on the det Esbending the month Expenses for the month Espect to INCREASE Moni preceptes the included the may puno SO Th.com 2000 of SO The company to me target BO The company would like to maintain the minimum cash balance stated above. How much would the company need to borrow if they want to maintain the minimum cash bulance (tupet balance) each month? How much surplus would they have over the minimum balance each month (Don't assume they will borrow. We only want to calculate 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 com for each month of the six month cash budget using ir 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 RECUREMENT SURPLUS of the stumption 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 ALEA ONLY) Create a cath budget for the first six months of 2009 based on the howing sumption Sales for the first month and are propted to be Sales projected to INCREASE nach month by $45 000 09 5% Collection of state been projected to be Collected within the month of Gales Collected one months Uncollectable Espenosse paid during the month incurred Expense for the first month and are expected to be Esperes are prejected to INCREASE thony Monthly depreciation expenses not included in the over monthly expense number) This new company will begin January of 2009 with cash balance of $30.000 51.000 525000 The company woke to maintain a minimum cath balance target balance of $50,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 tash balance (turgiet 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 calculate 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 isang 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 cath tow statement should be IOAN 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 stude for the festix months of 2000 both mit So the first month are to be Sains rected to INCREASE ch months by 145.000 Collection is to be Collected with the Colinded on the det Esbending the month Expenses for the month Espect to INCREASE Moni preceptes the included the may puno SO Th.com 2000 of SO The company to me target BO The company would like to maintain the minimum cash balance stated above. How much would the company need to borrow if they want to maintain the minimum cash bulance (tupet balance) each month? How much surplus would they have over the minimum balance each month (Don't assume they will borrow. We only want to calculate 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 com for each month of the six month cash budget using ir 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 RECUREMENT SURPLUS of the stumption 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 ALEA ONLY) Create a cath budget for the first six months of 2009 based on the howing sumption Sales for the first month and are propted to be Sales projected to INCREASE nach month by $45 000 09 5% Collection of state been projected to be Collected within the month of Gales Collected one months Uncollectable Espenosse paid during the month incurred Expense for the first month and are expected to be Esperes are prejected to INCREASE thony Monthly depreciation expenses not included in the over monthly expense number) This new company will begin January of 2009 with cash balance of $30.000 51.000 525000 The company woke to maintain a minimum cath balance target balance of $50,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 tash balance (turgiet 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 calculate 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 isang 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 cath tow statement should be IOAN 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)