20. The directors of Lunar Plc are considering investment in new equipment to increase the firm's flexibility. The finance director has asked you to evaluate how much cash the company will have available at the end of March 2020. You have been provided with the following information: а) The sales forecast for the period from November 2019 to March 2020: Nov-19 Dec-19 Jan-20 Mar-20 Feb-20 240 Sales (Unit) Unit price 210 250 190 220 £175 £180 £200 £205 £210 b) 40% of customers pay in the month of sale, the rest pay in the following month. c) Purchases are 65% of the previous month's sales revenue. All purchases are on credit and are paid for in the month following the purchase. Wages of £8,500 are paid monthly. The sales team earn commission of 3% of monthly sales revenue and this is paid in the month following the sale. Charges for light and heat are £750 per month and are paid every 2 months starting from January 2020. Advertising cost is paid at £2,500 per month. At the end of December 2019 Meridian plc has a bank balance of £46,000. d) e) f) Required (a) Prepare a cash budget for each month from January 2020 to March 2020. (b) Advise managers on the actions that can be taken to avoid a cash deficit situation.

20. The directors of Lunar Plc are considering investment in new equipment to increase the firm's flexibility. The finance director has asked you to evaluate how much cash the company will have available at the end of March 2020. You have been provided with the following information: а) The sales forecast for the period from November 2019 to March 2020: Nov-19 Dec-19 Jan-20 Mar-20 Feb-20 240 Sales (Unit) Unit price 210 250 190 220 £175 £180 £200 £205 £210 b) 40% of customers pay in the month of sale, the rest pay in the following month. c) Purchases are 65% of the previous month's sales revenue. All purchases are on credit and are paid for in the month following the purchase. Wages of £8,500 are paid monthly. The sales team earn commission of 3% of monthly sales revenue and this is paid in the month following the sale. Charges for light and heat are £750 per month and are paid every 2 months starting from January 2020. Advertising cost is paid at £2,500 per month. At the end of December 2019 Meridian plc has a bank balance of £46,000. d) e) f) Required (a) Prepare a cash budget for each month from January 2020 to March 2020. (b) Advise managers on the actions that can be taken to avoid a cash deficit situation.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 19EA: Redbird Company is considering a project with an initial investment of $265,000 in new equipment...

See similar textbooks

Similar questions

Minicase In March 2020, the management team of Londonderry Air (LA) met to discuss a proposal to purchase five shorthaul aircraft at a total cost of $25 million. There was general enthusiasm for the investment and the new aircraft were expected to generate an annual cash flow of $4 million for 20 years. The focus of the meeting was on how to finance the purchase. LA had $20 million in cash and marketable securities (see table), but Ed Johnson the chief financial officer pointed out that the company needed at least $10 million in cash to meet normal outflow and as a contingency reserve. This meant that there would be a cash defficiency of $15 million, which the firm would need to cover either by the sale of common stock or by additional borrowing. while admitting that the arguments were finely balanced, mR. Johnson recommended an issue of stock. He pointed out that the airline industry was subject to wide swings in profits and the firm should be careful to avoid the risk of excessive…
Kako Ltd is considering introducing a new product unto the market. This will require the injection of capital to the tune of GH¢20,000 for the purchase of the equipment for production. The cost of the building that Kako Ltd intends to use for the project is GH¢30,000. The Production and Marketing department has presented the information in the table below: 2019 Variable cost per unit of the product GH¢2 Selling price per unit GH¢6 Quantity 4000 units per annum Again the following information should be taken not of: • Feasibility studies cost the company GH¢2000 • Test marketing expenses amounts to GH¢3000 • Variable cost will increase by 5% per annum • Selling price will increase by 10% per annum • Marketing expense will be 5% of sales revenue per year • An initial working capital investment of GH¢2000 will be made. Subsequently, net working capital at the end of each year will be equal to 10 percent of sales for that year. In the final…
Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product. It will require the company to buy a new equipment that will generate the same revenue for the company each year. The table below shows the initial and annual costs for each option. Cost Option A Option B Initial Investment 1,400,000 1,500,000 Year 1 35000 25000 Year 2 35000 25000 Year 3 35000 25000 Year 4 35000 25000 Year 5 25000 Required: Perform capital budgeting technique based on EquivalentAnnual Cost (EAC) to advise the Company Management which option should be chosen if therelevant discount rate is 9%?
Consider a project with an initial investment (today, t = 0) of $200,975. This project will generate cash flows of $49,500 per year for the next 8 years, at which time (end of Year 8) the company will pay $50,000 to another for clean-up and disposal. What is the Profitability Index (PI) of the project if shareholders demand a 16.295% return? Answer with a number rounded to three decimal places, e.g., 4.0877% should be entered as 4.088.
Sunland, Inc. management is considering purchasing a new machine at a cost of $4,390,000. They expect this equipment to produce cash flows of $845,890, $819,250, $917,830, $1,103,400, $1,093,260, and $1,306,800 over the next six years. If the appropriate discount rate is 15 percent, what is the NPV of this investment? (Enter negative amounts using negative sign e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.) The NPV is $enter the NPV in dollars rounded to 0 decimal places
Data are as follows: In year 2020, sales are 150,000 units with Selling price per unit of 10 and VC per unit iof 6.50 per unit. Fixed cost is 155,000 and Interest cost is 90,000. Q3. Assume that the company expects to have sales increase by 20%, what will be the resulting change in EBIT in year 2021? choices: • 33.33% • 26.45% • 25% • 28.38%
Sons Inc. management is considering purchasing a new machine at a cost of $4,390,000. They expect this equipment to produce cash flows of $845,890, $819,250, $917,830, $1,103,400, $1,093,260, and $1,306,800 over the next six years. If the appropriate discount rate is 15 percent, what is the NPV of this investment? (Enter negative amounts using negative sign e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.) The NPV is $
SUPERIOR Company Limited is considering the following projects for inclusion in its capital budget for year 2021.The projects have equal risks and the capital outlay required is as follows: Project Investment required Project Investment Requirement Return $000 $000 1 24,000 5520 2 9600 3072 3 7000 980 4 4800 864 5 3200 640 6 1400 392 As the Divisional Manager, you are to decide which of the projects to accept. The company has a cost of capital of 15% with $60million available to the division for investment purposes.Required: Compute the total investment, total return on capital invested and residual income on each of the following assumptions, indicating the preferred project: The Company has a rule that all projects promising at least 20% or more should be accepted. The divisional manager is evaluated on his ability to maximise his return on capital investment. The divisional manager is expected to maximise residual income as computed by using…
Suppose that the date is 1 January 2022, and you are considering making an investment in General Electric (NYSE: GE). You are given the following information and assumptions to assist you with your valuation analysis: FY2022 revenue (i.e., for the 12-month period from 1 January 2022 to 31 December 2022) is forecast to be $80 billion, compared to actual FY2021 revenue of $75 billion. EBIT, depreciation & amortization (D&A) and capital expenditure dedicated solely for new investments/projects (i.e., growth capital expenditure) is expected to remain fixed (as a percentage of total revenues) at 15%, 5% and 3% respectively. The level of operating working capital needed for GE’s ordinary business operations historically as well as in the future is equal to 1% of total revenues. GE currently has $75 billion in debt outstanding, $40 billion in cash on hand and 9 billion shares outstanding. Assume that GE faces an effective corporate tax rate of 25%. Assume that GE’s long-term…
Lipsion Ltd company is thinking about investing in one of two potential new productsfor sale. The projections are as follows: year revenue/ product s revenue/ product v0 (150,000) outlay (150000) outlay1 14000 150002 24000 253333 44000 520004 84000 63333 Calculate the IRR for Product V only using 1% and 17% to 2 d.p.
Tyler, Inc., is considering switching to a new production technology. The cost of the required equipment will be $3,764,394 . The discount rate is 13.01 percent. The cash flows that the firm expects the new technology to generate are as follows. Years CF 0 $(3,764,394) 1–2 0 3–5 $878,248 6–9 $1,534,992 Compute the payback and discounted payback periods for the project. (Round answers to 2 decimal places, e.g. 15.25.) The payback for the project is ............ years, and the discounted payback period is........... years. What is the NPV for the project? Should the firm go ahead with the project? (Round answer to 2 decimal places, e.g. 15.25.) The NPV of the project is $ , and using the NPV rule the project should be rejected/ accepted . What is the IRR, and what would be the decision based on the IRR? (Round answer to 2 decimal places, e.g. 15.25.) The IRR of the project is %, and using the IRR rule the…
Assume that a company plans to introduce a new product to the market at a target selling price of $20 per unit. It is investing $4,000,000 to purchase the equipment needed to produce and sell 250,000 units per year. Assuming the company’s required rate of return on all investments is 16.50%, what is the new product’s target cost per unit? Multiple Choice $21.84 $22.84 $18.36 $17.36