Electronic Point Irish Courier Ltd (EPIC Ltd) is currently suffering cashflow problems and the Finance Director...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Electronic Point Irish Courier Ltd (EPIC Ltd) is currently suffering cashflow problems and the Finance Director wants you to prepare a cash budget based on the following information for the next quarter to 30 June 2019: Balances brought forward from quarter ended 30 March 2019 are as follows: Quarter ended 30 March 2019 € € Non-Current Assets 750,000 Current Assets Inventory Trade receivables 375,000 581,125 75,000 Other receivables 1,031,250 Total Assets 1,781,250 Equity and Liabilities: Ordinary share capital (Nominal value €1) Retained carnings Current Liabilities: 75,000 900,000 Bank overdraft 206,250 Trade payables Тах 375,000 3225,00000 806,250 1,781,250 Additional information: (a) Sales for the next 3 months are forecast as follows: April € May € June € 975,000 1,050,000 1,087,500 10% of the sales are cash sales. The remainder of the sales are on credit and are paid one month after the sale. 5% of the total sales for each month are usually irrecoverable. (b) Purchases for the next three months are forecast as follows: April May € June € 562,500 605,230 626,550 All the purchases are on credit with suppliers allowing one month's credit. Salaries of €172,500 will be paid cach month. The directors will receive a bonus of €120,000 in April. (c) EPIC will undertake an extensive television and radio marketing campaign costing €11,250 which is payable in May. EPIC will make a legal settlement for an ongoing court case in respeet of an unfair dismissal claim for €22,500 in April. The tax liability outstanding is due for payment to the tax authorities in June. (d) (e) (f) (g) EPIC just purchased a packaging machine (in April) for €37,500. This will be paid for in the month of June. (h) An additional 57,000 ordinary shares will be issued in April at a price of €1.20 per share. Requirement (i) Prepare a cash budget for each of the three months April to June 2019 showing the net cash position at the end of each month (use tabular format). List three appropriate actions to deal with any surpluses or deficits arising. (20 Marks) (ii) (3 Marks) Electronic Point Irish Courier Ltd (EPIC Ltd) is currently suffering cashflow problems and the Finance Director wants you to prepare a cash budget based on the following information for the next quarter to 30 June 2019: Balances brought forward from quarter ended 30 March 2019 are as follows: Quarter ended 30 March 2019 € € Non-Current Assets 750,000 Current Assets Inventory Trade receivables 375,000 581,125 75,000 Other receivables 1,031,250 Total Assets 1,781,250 Equity and Liabilities: Ordinary share capital (Nominal value €1) Retained carnings Current Liabilities: 75,000 900,000 Bank overdraft 206,250 Trade payables Тах 375,000 3225,00000 806,250 1,781,250 Additional information: (a) Sales for the next 3 months are forecast as follows: April € May € June € 975,000 1,050,000 1,087,500 10% of the sales are cash sales. The remainder of the sales are on credit and are paid one month after the sale. 5% of the total sales for each month are usually irrecoverable. (b) Purchases for the next three months are forecast as follows: April May € June € 562,500 605,230 626,550 All the purchases are on credit with suppliers allowing one month's credit. Salaries of €172,500 will be paid cach month. The directors will receive a bonus of €120,000 in April. (c) EPIC will undertake an extensive television and radio marketing campaign costing €11,250 which is payable in May. EPIC will make a legal settlement for an ongoing court case in respeet of an unfair dismissal claim for €22,500 in April. The tax liability outstanding is due for payment to the tax authorities in June. (d) (e) (f) (g) EPIC just purchased a packaging machine (in April) for €37,500. This will be paid for in the month of June. (h) An additional 57,000 ordinary shares will be issued in April at a price of €1.20 per share. Requirement (i) Prepare a cash budget for each of the three months April to June 2019 showing the net cash position at the end of each month (use tabular format). List three appropriate actions to deal with any surpluses or deficits arising. (20 Marks) (ii) (3 Marks)
Expert Answer:
Answer rating: 100% (QA)
answers Cash Budget for the months of April May and June Particulars April May June Opening bal of B... View the full answer
Related Book For
Posted Date:
Students also viewed these economics questions
-
You have been asked to prepare a cash budget for Whitborrow plc for the next three months, October, November and December. The managers are concerned that they may not have sufficient cash to pay for...
-
Skulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017, Skulass management accountant gathered the following data to prepare budgets for January...
-
Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and overhead costs for March 2017. Waterways produced 118,500 units in March rather than the...
-
PLEASE, PLEASE use an Excel formula:1. Begin the formula with an = sign.2. Reference cells, instead of entering values.Example: =PV(H8+H9) A company borrowed money from a local bank. The note the...
-
A series of five constant-dollar (or real-dollar) payments (beginning with $5,000 at the end of the first year) are increasing at the rate of 7% per year. Assume that the average general inflation...
-
A retaining wall is shown in Figure 13.37. For each problem, determine the Rankine active force, Pa, per unit length of the wall and the location of the resultant Problem H H (deg) Y2 19.9 k (deg)...
-
Using the information in the Application "Botox and Price Discrimination," determine how much Allergan loses by being a single-price monopoly rather than a perfectly price-discriminating monopoly....
-
1. What type of coaching function was reflected in Rowes meeting with Busche? 2. In terms of effectiveness on a 1-10 scale, with 1 being poor and 10 being excellent, what score would you assign to...
-
Details Email Exercise Purpose: To give students practice writing effective emails Instructions: Write a brief email to a friend or family member about your day. Be sure to include the following:...
-
Using Rhodes Corporation's financial statements (shown below), answer the following questions. a. What is the net operating profit after taxes (NOPAT) for 2012? b. What are the amounts of net...
-
The cost of cheese used by a restaurant, per pizza, is which type of cost?
-
The Topic is: The effect of the corona virus on long-term care facilities. Discuss how this current issue relates to Life Span Psychology. Provide a deeper understanding of the topic in about ONE...
-
SITXINV006 - Receive, store and maintain stock Written Assessment Assessment Questions: 1. Explain the following principles of stock control. Rotation of stock Product life cycle Minimising wastage...
-
The following passage is a blog post written by Mike Hess, the Executive Director and founder of the Blind Institute of Technology in the United States. I have been legally blind since first grade....
-
Explain what the scope triangle is. Why is it important to consider the scope triangle variables in managing a project?
-
Why does using the Charge Description Master create concern when trying to comply with the CMS requirements for price transparency? Question 189 options: Consumers may not have access to the price...
-
A new car sold for $31,000. If the vehicle loses 15% of its value each year, how much will it be worth after 10 years?
-
Big Trucks plc is considering two major projects. The first is to expand production at the Midlands factory. The second is to start production in the Far East. The returns in terms of internal rates...
-
Tesford plc has estimated net cash flows from operations (after interest and taxation) for the next five years as follows: YearNet cash flows 1 ........................... 3,000,000 2...
-
Clipper owns 100 acres of mature woodland and is trying to decide when to harvest the trees. If it harvests immediately the net cash flow, after paying the professional loggers, will be 10,000. If it...
-
Find one solution for each of the difference equations below: (a) \(y(n)+2 y(n-1)+y(n-2)=0, y(0)=1\) and \(y(1)=0\) (b) \(y(n)+y(n-1)+2 y(n-2)=0, y(-1)=1\) and \(y(0)=1\).
-
We define the even and odd parts of a sequence \(x(n), \mathcal{E}\{x(n)\}\) and \(\mathcal{O}\{x(n)\}\) respectively, as \[\begin{aligned}\mathcal{E}\{x(n)\} & =\frac{x(n)+x(-n)}{2}...
-
Find the general solution for the difference equation in Example 1.9 when \(a=b\). Example 1.9. Solve the difference equation y(n) + ay(n 2) = b" sin(n)u(n) assuming that ab and y(n) = 0, for n < 0....
Study smarter with the SolutionInn App