Home Ltd. runs a chain of garden equipment stores. The business is seasonal in nature regarding...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Home Ltd. runs a chain of garden equipment stores. The business is seasonal in nature regarding the garden tools and equipment. The forecast sales for 2021 are as follows: January February March April May June . . . . £'000 18 18 30 150 240 210 July August September October November December £'000 120 75 75 20 15 90 60% of Home's sales are on cash terms, and 40% are on credit terms. Approximately half the credit sales pay 1 month after sale, and the balance pay during the second month after sale. Home Ltd. purchased goods for resale 3 months prior to sale and pays for them 1 month after purchase. Typically, the goods are sold at a profit mark-up on cost of 50% (selling price is 150% of cost). Wages and administration costs amount to £35,000 per month including depreciation costs of £8,000 per month. A tax payment of £30,000 needs to be made in May 2021. Home needs to buy a new machine in May, which costs £50,000, full amount payable on purchase. One of the owners of the business, Sam will retire in July, and is expecting a retirement lump sum bonus payment of £65,000. Human Resources has advised that this payment should be made in August. The company is also expected to buy back Sam's shares in April 2022, with expected total value of £100,000 payable in April 2022. Cash position in Home Ltd follows the same pattern every year. Required: a) Prepare a monthly cash budget for the 6 months from April to September 2021. Assume an opening cash balance of £27,000 on 1 April 2021. (18 marks) b) Based on the cash budget above, make suggestions to the management team on how they can manage its cash situation from April to September. Your answers must include specific suggestions regarding each month's cash situation. (7 marks) Home Ltd. runs a chain of garden equipment stores. The business is seasonal in nature regarding the garden tools and equipment. The forecast sales for 2021 are as follows: January February March April May June . . . . £'000 18 18 30 150 240 210 July August September October November December £'000 120 75 75 20 15 90 60% of Home's sales are on cash terms, and 40% are on credit terms. Approximately half the credit sales pay 1 month after sale, and the balance pay during the second month after sale. Home Ltd. purchased goods for resale 3 months prior to sale and pays for them 1 month after purchase. Typically, the goods are sold at a profit mark-up on cost of 50% (selling price is 150% of cost). Wages and administration costs amount to £35,000 per month including depreciation costs of £8,000 per month. A tax payment of £30,000 needs to be made in May 2021. Home needs to buy a new machine in May, which costs £50,000, full amount payable on purchase. One of the owners of the business, Sam will retire in July, and is expecting a retirement lump sum bonus payment of £65,000. Human Resources has advised that this payment should be made in August. The company is also expected to buy back Sam's shares in April 2022, with expected total value of £100,000 payable in April 2022. Cash position in Home Ltd follows the same pattern every year. Required: a) Prepare a monthly cash budget for the 6 months from April to September 2021. Assume an opening cash balance of £27,000 on 1 April 2021. (18 marks) b) Based on the cash budget above, make suggestions to the management team on how they can manage its cash situation from April to September. Your answers must include specific suggestions regarding each month's cash situation. (7 marks)
Expert Answer:
Answer rating: 100% (QA)
Lets prepare a monthly cash budget for Home Ltd for the 6 months from April to September 2021 Well start with an opening cash balance of 27000 on 1 Ap... View the full answer
Related Book For
South-Western Federal Taxation 2018 Comprehensive
ISBN: 9781337386005
41st Edition
Authors: David M. Maloney, William H. Hoffman, Jr., William A. Raabe, James C. Young
Posted Date:
Students also viewed these finance questions
-
The vectors form a basis for R if and only if k + 6 -2 -3-0-8 =
-
After graduating from Eastern University in Campus Town, USA with a degree in business, Michael Woods realized that he wanted to remain in Campus Town. After a number of unsuccessful attempts at...
-
You think XYZ stock has potential for an upward move in price. You have no position whatsoever in the stock now. You would like to take the opportunity of any up movement in price but want to...
-
Find the minimum and maximum values of the function subject to the given constraint. f (x, y) = x + y, x + y4 = 1
-
As an adjustable brace BC is used to bring a wall into plumb, the force-couple system shown is exerted on the wall. Replace this force-couple system with an equivalent force-couple system at A...
-
For cases a and b shown in the figure, respond to the following questions and statements concerning the application of the Reynolds transport theorem to the continuity equation. a. What is the value...
-
What measures of location are commonly computed for frequencies?
-
You have a choice of borrowing money from a finance company at 24 percent compounded monthly or borrowing money from a bank at 26 percent compounded annually. Which alternative is the most attractive?
-
Coolbrook Company has the following information available for the past year: sales revenue Cost of goods sold and operating expenses Net operating income Average invested assets The company's hurdle...
-
The Protek Company is a large manufacturer and distributor of electronic components. Because of some successful new products marketed to manufacturers of personal computers, the firm has recently...
-
Determine the number of units of each crib model that should be produced to maximize profitability in the next fiscal year while still meeting sales commitments, assuming that no additional capacity...
-
When f(t) 12-5t-6, evaluate f(-4) f(-4)=
-
Salmone Company reported the following purchases and sales for its only product Salmone uses a periodic inventory system. Determine the cost assigned to cost of goods sold using LIFO Date Activities...
-
discuss the implications of copyright law and intellectual property rights on the collaborative nature of digital media production, as well as the challenges posed by remix culture and fan-generated...
-
Lift the locking lever and pull the toner cartridge out Select Cartridge Access Control (CAC) from the control panel Manually remove the cartridge from the toner motor drive Select Troubleshooting...
-
Under US GAAP, how is Construction in Progress (CIP) typically classified and reported for long-term contracts?
-
A 5000-ton ship rests on launching ways that slope down to the water at an angle of 10. If the coefficient of sliding friction is 0.18, how much force is needed to winch the ship down the ways into...
-
Describe the Operations (+,,*,/) that can cause negligible addition (NA), error magnification (EM), or subtractive cancellation (SC) in calculating ?((x^2)+1) - x . Give the range of where they might...
-
Melaney has had a bad year with her investments. She lent a friend $8,000; the friend did not repay the loan when it was due and then declared bankruptcy. The loan is totally uncollectible. Melaney...
-
Tammy, a resident of Virginia, is considering whether to purchase a North Carolina bond that yields 4.6% before tax. She is in the 35% Federal marginal tax bracket and the 5% state marginal tax...
-
Discuss whether the passive loss rules apply to the following: individuals, closely held C corporations, S corporations, partnerships, and personal service corporations.
-
The percentage of heights between 148 centimeters and 170 centimeters
-
The percentage of heights between 159 centimeters and 165 centimeters
-
In this section, it was noted that the standard deviation of sample means is s/1n. In that expression, what does s represent and what does n represent?
Study smarter with the SolutionInn App