Question: what do you mesn by excel file ? please clarify. Prepare a cash budget for Data Logic using the following assumptions. 3. Collections on total

 what do you mesn by excel file ? please clarify. Prepare
what do you mesn by excel file ? please clarify.

Prepare a cash budget for Data Logic using the following assumptions. 3. Collections on total sales have been projected to be: 20% collected during the month of sale 60% collected one month after sale 20% collected two months after sale All expenses are paid during the month incurred, except rent and labor. Rent and labor will be paid the following month. Cash on hand on July 1,2012 is projected to be $25,000. A minimum cash balance of $25,000 should be maintained through the cash budget penod Prepare a monthly cash budget for the last six morths of 2012 . How much money will Data Logic need to borrow (or how much will it have available to invest) each month? Use the IF function to calculate the loan requirement and surplus for each month Save Excel file as cashflow1 3. Prepare a monthly cash budget for the last six months of 2012. Change the following 9 assumptions: 0 1 Collections on sales have been projected to be 35% collected duang the month of sale 55% collected one month after sale 5% collected two months atter sale 5% will be uncollectable How much money will Data Logic need to borow (or how much will it have araiable to imest) 48 each month? Use the ff function to calculate the loan requirement and surplus for esch month 49 Save Excel file as cashflow2 50

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!