Question

In: Accounting

Henri Barrista, café proprietor, is preparing a set of budgets for the next six months (period...

Henri Barrista, café proprietor, is preparing a set of budgets for the next six months (period ended 31

December). Information given is:

$

Expected sales

280,000

Cost of goods sold

36,000

Administration expenses

6,000

Selling expenses

11,000

Sales staff salaries

90,000

Manager’s salary

45,000

Financial expenses

10,000

Depreciation on equipment

12,000

New coffee machine (September)

11,500

Workcover

4% x salaries

Superannuation

9% x salaries

Inventories on hand at start

27,000

Inventories on hand at end

31,500

All sales revenue is cash and all expenses will be paid in the period and GST will need to be added where appropriate.

Prepare the following budgets: sales, cost of goods sold, purchases, cash and income statement.

Solutions

Expert Solution


Related Solutions

Elias Company has prepared a budget for the first six months of 2020. Monthly budgets for...
Elias Company has prepared a budget for the first six months of 2020. Monthly budgets for revenues are provided at left. Experience indicates that Elias will collect 75% of sales in the month of sale, 15% in the month following the sale, and 7.5% in the second month after the sale. The remaining 2.5% of sales are expected to be uncollectible. Prepare a cash collections budget for Elias for the months of March, April, and May 2020. Show your work....
Freewheel is in the process of preparing its master budget for the six months ending December...
Freewheel is in the process of preparing its master budget for the six months ending December 19X2. The balance sheet for the year ended 30 June 19X2 is estimated to be as follows: Cost Deprec prov NBV Fixed assets 140.000 14.000 126.000 Current assets Stock 25.000 Trade debtors 24.600 Bank 3.000 Net current liabilities 52.600 Creditors Amount falling due within one year Trade creditors 25.000 Other creditors 9.000 34.000 Net current assets 18.600 Total assets less current liabilities 144.600 Capital...
A stock price is currently $36. During each three-month period for the next six months it is expected to increase by 9% or decrease by 8%.
Problem 3: Derivatives ValuationA stock price is currently $36. During each three-month period for the next six months it is expected to increase by 9% or decrease by 8%. The risk-free interest rate is 5%. Use a two-step tree to calculate the value of a derivative that pays off (max[(40-ST),0])2 where ST is the stock price in six months.Use risk-neutral valuation.Verify whether both approaches lead to the same result.If the derivative is of American style (ST in the payoff function...
The company provides some details for the period 2020 for preparing necessary budgets: (a) Sales Details...
The company provides some details for the period 2020 for preparing necessary budgets: (a) Sales Details The Company estimates that it can get maximum profits if it charges $ 200 (selling price) for one of its products. The marketing manager of the company had indicated that at $ 200 selling price, the company would be able to sell 1,000 units in the first quarter of 2020. The company also expects that sales would go up by 100 units over previous...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of the trading year. You have been provided with the following information: Trading; January February March Sales in Units 50 000 units 55 000 units 60 000 units Sales are expected to increase to 75 000 units per month from 1 April as the company increases production capacity. The selling price for each unit has been set at N$90.00 per unit. All sales are on...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of the trading year. You have been provided with the following information: Trading; January February March Sales in Units 50 000 units 55 000 units 60 000 units Sales are expected to increase to 75 000 units per month from 1 April as the company increases production capacity. The selling price for each unit has been set at N$90.00 per unit. All sales are on...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. 10% of all sales are for Cash. Credit customers usually pay 20% of their fee in the month that service is provided, 60% the month after, 18% the second month after receiving service. The remaining 2% is written off...
A company is planning to borrow $120 million after three months for a period of six...
A company is planning to borrow $120 million after three months for a period of six months. The quote for the loan is LIBOR. The loan rate, LIBOR, will be determined at the start of loan and stay the same for its duration. Currently LIBOR is 3%. The company is willing to pay 3.25% fixed interest on the loan to avoid variable interest. Part a. Construct a Forward Rate Agreement (FRA) for the company. Part b. Should the company buy...
A company is planning to borrow $120 million after three months for a period of six...
A company is planning to borrow $120 million after three months for a period of six months. The quote for the loan is LIBOR. The loan rate, LIBOR, will be determined at the start of loan and stay the same for its duration. Currently LIBOR is 3%. The company is willing to pay 3.25% fixed interest on the loan to avoid variable interest. Part a. Construct a Forward Rate Agreement (FRA) for the company. Part b. Should the company buy...
ABC is expected to pay a dividend of $1.25 every six months for the next four...
ABC is expected to pay a dividend of $1.25 every six months for the next four years. The current share price is $25.76 and the relevant discount rate is 14% (compounded semi-annually). What do you expect the share price at the end of year 4 to be? a. $28.82 b. $26.74 c. $31.44 d. $25.12 Please don't use the PVA formula.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT