Pelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022.(i)Extracts from the sales and purchases budgets are as follows:Month2021 - 2022CashSalesPurchasesOnCashSalesOnPurchasesAccountAccountNovember 2021December 2021January 2022February 2022March 2022$138,100$156,500$170,975$135,740$480,000$600,000$650,000$700,000$25,800$44,625$30,400$345,000$380,000$400,000$480,000$226,420$800,000$55,100$540,000(ii) An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale8% in the second month following the saleThe remaining 2% is expected to be uncollectible(iii) Accounts payable are settled as follows, in accordance with the credit terms 2/30, n60:85% in the month in which the inventory is purchased15% in the following month(iv) The management of Pelican Merchandising has negotiated with a tenant to sublet officespace to her beginning February 1. The rental is expected to be $552,000 per annum. Thefirst month's rent along with one month's safety deposit is expected to be collected onFebruary 1. Thereafter, monthly rental income becomes due at the beginning of eachmonth.(v) Office Furniture & Fixtures, which is estimated to cost $350,000, will be purchased inFebruary. The manager has made arrangement with the suppliers to make a cash deposit of40% upon signing of the agreement in February. The balance will be settled in five (5) equalmonthly instalments beginning March of 2022.(vi) The management of Pelican Merchandising is in the process of upgrading its fleet of motorvehicles. During February the business expects to sell an old delivery motor van that cost$540,000 at a loss of $34,000 to an employee. Accumulated depreciation on this motor vanat that time is expected to be $246,000. The employee will be allowed to pay a depositequal to 60% of the selling price in February; the balance will be settled in two equalamounts in March & April of 2022.(vii) Fixed operating expenses which accrue evenly throughout the year, are estimated to be$2,088,000 per annum, which include depreciation on non-current assets of $42,000 permonth and are expected to be settled monthly.(viii) Other operating expenses which accrue evenly throughout the year are expected to be$696,000 per annum and will be settled monthly.Continued.. Continued..(ix) A long-term bond purchased by Pelican Merchandising 2 years ago, with a face value of$450,000 will mature on January 15, 2022. To meet the financial obligations of thebusiness, management has decided to liquidate the investment upon maturity. On that datesemi-annual interest computed at a rate of 8%% per annum is also expected to becollected.(x)A compensation payment of $355,000 to a former employee for a back injury sustained inan accident in the business storage facility, not covered by insurance, becomes due andpayable on January 25, 2022.(xi) Wages and salaries are expected to be $3,264,000 per annum and will be paid monthly.(xii) The cash balance on March 31, 2022 is expected to be an overdraft of $253,000Required:(b)the same quarter ending March 31, 2022 and has asked you to furnish him with the figuresfor the expected trade receivables and payables to be included in the statement. Is that areasonable request? If yes, what should these amounts be?Another team member who is preparing the Budgeted Balance Sheet for the business for(c) Upon receipt of the budget, the team manager, June Jackson, has now informed you that, inkeeping with industry players, the management of Pelican Merchandising have indicated anindustry requirement to maintain a minimum cash balance of $185,000 each month. Shehas also noted that management is very keen on keeping the gearing ratio of the businessas low as possible and would therefore prefer to cushion any gaps internally using equityfinancing.Based on the budget prepared, will the business be achieving this desired target? Suggestthree (3) internal strategies that may be employed by management to improve theorganization's monthly cash flow and militate against or reduce any possible shortfallreflected in the budget prepared. Each strategy must be fully explained.

Note: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter ending March 31, 2022 and has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be? (b)

Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter ending March 31, 2022 and has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be? (b)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

If you are the Management Accountant of a company, you would be primarily concerned with: a. Reporting of past data b. Providing useful information to external users c. Helping the management in preparing plans and forecasts for future activities of business d. The annual reporting of company’s financial performance
1.Dale, a senior accountant, references the company’s accounting statements as the basis for a summary of his firm’s financial information, products, and growth plans for owners and potential investors. The summary Dale is preparing is called a(n) Multiple Choice budget. schedule. agenda. mission.
The role of a financial statement analyst is to use financial reports prepared by an organisation together with other information, to evaluate the past, present and future performance of an organisation for the purpose of making investment, credit and other decisions. In relation to the above statement, outline FOUR types of economic decisions that a financial analyst could make from the analysis of financial statements of an organisation. (b) The profit after tax of Baragoh Ltd. for the year ended 30 September 2022 was Sh.15 million. As at 1 October 2021, the company had in issue 36 million equity shares and Sh.10 million 8% convertible loan note. The loan note will mature in year 2023 and will be redeemed at par or converted to equity shares on the basis of 25 shares for each Sh.100 of loan note at the loan note holder’s option. On 1 January 2022, Baragoh Ltd. made a fully subscribed rights issue of one new share for every four shares held at a price of Sh.2.80 each. The market…
Hello! I need help with the following accounting principles question. It states that for each box, we can either select the question dislayed as being more likely asked by an external or internal user. Thank you in advance!
What were the industry challenges for Accounting leaders in 2019?
Which statement is correct: Select one: a. Management accounting’s focus and emphasis is on past-oriented reports. b. The purpose of financial information in management accounting is to communicate organization's financial position to investors, banks, regulators, and suppliers. c. All statements are correct. d. Management accounting focuses on measuring, analyzing, and reporting financial and nonfinancial information to help managers estimate future revenue, costs, and other measures to forecast activities and formulate strategies to increase the competitive advantage of the organization. e. In management accounting, rules of measurement reporting require financial statements, e.g. prepared for the budgeting purpose, to be prepared in accordance of GaAAP.
Q1 Describe the role of the following personnel: i. Auditor General ii. Accountant General Q2 Explain any TWO (2) elements of Modified Budgeting System (MBS). Q3. explain the meaning of i. Performance Audit ii. Financial Audit Q4. Explain the following terms: i. Clients’ Charter ii. Total Quality Management Question 4 Performance measures are being actively developed in Malaysia by the government to improve the performance of the public sector. The interest of performance measurement in the public sector can be observed through the introduction of various types of performance measurement initiatives. Required: (a) Explain the following terms: i. Clients’ Charter ii. Total Quality Management (b) Performance measurement initiatives is a waste of time for the government agencies in Malaysia. Provides justification whether you agree or disagree with the statements (c) Explain the relationship of input, process, output and outcome as part of key performance…
Give typing answer with explanation and conclusion
Organizational charts ________. Group of answer choices list the salaries of all employees outline the strategic goals of the organization show the structure of an organization help management measure financial performance
Please answer what you can thanks
Briefly explain the overall objective of a financial manager. Include in your response any one of the three fundamental decisions a financial manager would be faced with. You may want to refer to the fundamental accounting equation in your response.
you are working as a financial adviser either in your own business or as part of a larger organisation. You will be asked by your AFSL to produce a Financial Services Introduction Sheet tailored for a new staff member who is commencing work at your organisation in a financial support role but who has little understanding and/or knowledge of the industry. The Introduction has 3 sections. (a) Present a summary of the key economic and political factors (minimum 2) currently impacting or having the potential to impact on the financial services industry. You should include reference to (as a minimum): * interest rates exchange rates inflation government monetary and fiscal policies (b) Present a summary of financial advisory functions including: the role of the representative/adviser * participants in the advisory services market including those providing advice regarding: o Derivatives o Life Insurance o Securities o Managed Investments * roles played by intermediaries and issuers trustees…