THE TRAVEL PHOTOGRAPH ANNUAL BUDGET: May June July August Sales 200 1,000 2,000 2,500 Cost of goods sold Supplies 40 200 400 500 Gross profit mar
Fin-Acc-BossTHE TRAVEL PHOTOGRAPH
ANNUAL BUDGET:
May June July August
Sales 200 1,000 2,000 2,500
Cost of goods sold
Supplies 40 200 400 500
Gross profit margin 160 800 1,600 2,000
Prepare the cash flow budget considering the following elements:
1- The photograph is always paid 30 days after the sale
2- The photograph has to pay his supplies cash on delivery
3- At the beginning of June the bank account amounts to ($1,000); this means that he is using the line of credit
THE FISHING POND - Seasonal business
August September October November December January February
Sales 75,000 45,000 20,000 5,000 -
Cost of goods sold
Supplies 15,000 9,000 4,000 1,000 -
Guides 22,500 13,500 6,000 1,500 -
Total Cost of good sold 37,500 22,500 10,000 2,500 -
Gross profit margin 37,500 22,500 10,000 2,500 -
Operational Expenses 8,000 8,000 8,000 8,000 8,000 8,000 8,000
Net profit 29,500 14,500 2,000 (5,500) (8,000) (8,000) (8,000)
Prepare the cash flow budget for September to December considering the following elements:
1- Sales receipts
a- On average, 20% of the sales are received 30 days before the sales as deposits
b- On average, 80% of the sales are received on delivery
2- The pond pays its supplies 30 days later
3- The guides are paid the day of the sales
4- The operational expenses are paid in the same month as the purchase
5- The pond will purchase $5,000 worth of equipement in September
6- The pond will contract a loan of $4,000 in September to pay for the equipment
7- The pond will start reimbursing the loan in September at the amount of $115 per month
8- At the beginning of September the bank account amounts to $40, 000
9- What is going to happen in January and February
THE COUNTRY FESTIVAL
The Festival takes place in August; it is in operation only from May to September
May June July August September TOTAL
REVENUES
Sales -
Stand rentals 5,000 10,000 20,000 35,000
Entrance fees 50,000 50,000
Grant from the municipality 80,000 80,000
TOTAL REVENUES 85,000 10,000 20,000 50,000 - 165,000
-
Cost of goods sold -
Cost of stands 3,000 6,000 12,000 - 21,000
Other supplies 1,000 5,000 14,000 35,000 - 55,000
Manpower 10,000 10,000 18,000 25,000 7,000 70,000
Total Cost of good sold 14,000 21,000 44,000 60,000 7,000 146,000
-
Gross profit margin 71,000 (11,000) (24,000) (10,000) (7,000) 19,000
-
Administration costs 4,000 4,000 4,000 6,000 1,000 19,000
-
Net profit 67,000 (15,000) (28,000) (16,000) (8,000) -
Prepare the cash flow budget for April to September considering the following elements:
1- Stand receipts
a- On average, 80% of the stand sales are received 30 days before the sales as deposits
b- On average, 20% of the stand sales are received in August
2- Half of the grant is received in May and the rest in September after the final reports
3- The entrance fees are cash of course
4- The costs of stands
a- A deposit of $5,000 is paid in May for the stands reservation
b- The final payment is done in July
5- The other supplies are paid 30 days after the purchase
6- The manpower is paid in the current month
7- The administration expenses are paid 30 days after the purchase
8- At the beginning of April the bank account amounts to $0
9- What is going to happen in October
9 years ago
Purchase the answer to view it

- cash_budget__nobodybutsheila_.xlsx