Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Alice is a sole trader planning to start a wholesale business selling fireworks. As this is a highly seasonal business, Alice is concerned about
Alice is a sole trader planning to start a wholesale business selling fireworks. As this is a highly seasonal business, Alice is concerned about whether she will have enough cash during the first six months of trading. She has provided you with the following information: Sales Forecast Month Boxes July Aug 400 800 Sept Oct 720 1600 Nov Dec 2000 1200 The average price for a box of fireworks is 12.50. Timing of receipts and payments (i) Three-quarters of customers will pay in cash in the same month the sale is made. (ii) Alice's best customers, account for the remaining 25% of sales, will be offered a 30-day credit period. 5% of these credit customers will never pay. (iii) Purchases are 5,000 a month from July to September, then 15,000 a month from October. Purchases will be paid two months after the supplies are received. (iv) General running costs are estimated to be 25% of sales value and are paid for in the month of sale. (v) A garage to store the fireworks will be rented from July. The rent of 12,000 will be paid in two instalments in July and October. (vi) Alice is going pay a security guard 1000 per month. (vii) Alice is planning to draw 1500 per month from the business. (viii) Alice has a starting capital of 2000. Required Prepare a Budget Extract for Alice for the months and elements shown below The opening cash balance for October is 562.50 Enter your answer to 2 decimal places with no sign. Do not put a - (minus) sign under payments. If you have negative cashflow under NETCASHFLOW please put a minus sign. Hint: For easy input type the first value then use the tab button on your keyboard to skip to the next value.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started