Cash Budget

User Generated

wcehqvihf

Business Finance

Description

For this assignment, you will construct a firm's monthly cash budget. Download the Excel template below and complete the included problem.

Cash Budget

Save your assignment as a Microsoft Excel document.

Unformatted Attachment Preview

Cash Budget Sales for Blue Bill Corporation are projected as follows for the months of June through November: June July August September October November $200,000 200,000 200,000 300,000 500,000 200,000 Credit sales account for 70% of the monthy sales and are collected one month after the sale. Other receipts for October are $50,000. Variable disbursements are 60% of sales each month. Fixed disbursements are $10,000 each month. $80,000 should be included in August for taxes. The company is obligated to make a $400,000 debt repayment in November. Beginning cash in June is $50,000. Desired ending cash each month is $10,000. Complete the monthly cash budget for Blue Bill Corporation for June through November. Blue Bill Corporation Cash Budget June Sales Cash sales Collections Other Receipts Total cash receipts Variable disbursements Fixed disbursements Other disbursements Total cash disbursements Net change during the month Beginning cash Ending cash Required cash Excess cash to invest Cash borrowed July August September hrough November: after the sale. ough November. October November
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey, the completed assignment is attached. Please, let me know if you have any questions :)

Cash Budget
Sales for Blue Bill Corporation are projected as follows for the months of June through November:
June
July
August
September
October
November

$200,000
200,000
200,000
300,000
500,000
200,000

Credit sales account for 70% of the monthy sales and are collected one month after the sa...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags