80.2K

Verified Solution

Link Copied!

ILLUSTRATION The following is the financial statement of XYZ Company Limited. The company is seeking to make projections on its financing needs for the upcoming year. They have tasked you, as the Finance Officer, to make the relevant estimations and determine any additional funding needs. Statement of Profit or Loss for the Year Ending 31st October, 2021 GH?000 Notes A B GH2000 2,500 (1.250) 1.250 Sales Cost of Sales Gross Profit Expenses: Administrative Sales and Marketing General Earnings before Interest and Tax Interest Earnings before tax 25 130 15 D E (170) 1,080 (400) 680 (170) 510 (25) 485 Tax F Earnings after tax Dividends Retained Earnings G Statement of Financial Position As At 31st October, 2021 Non-Current Assets Property Plant and Machinery Vans Notes H H H GH'000 40,000 35,000 25,000 100,000 Current Assets Inventory Accounts Receivables Cash and Cash Equivalent H H H 15,000 35,000 70,000 120,000 220,000 Total Assets EQUITY + LIABILITIES Opening Equity Retained Earnings 173,000 25,485 155,485 LONG-TERM LIABILITIES Loan 2.000 I CURRENT LIABILITIES Accounts Payable TOTAL LIABILITIES Equity + Total Liabilities 19.515 64,515 220,000 Notes: A. XYZ Company Limited is targeting a sales growth of 25% to meet growing demand and increase its market share. B. Cost of sales ratio remains unchanged. C. Sales and marketing expenditure is expected to increase in proportion with sales increase. D. Profit margin remains unchanged. E. Interest on loan is 20%. The loan has a maturity period of ten (10) years. F. Corporate tax rate is 25%. G. Dividend pay-out ratio remains unchanged. H. Asset to sales ratios remain unchanged. I. Spontaneous liabilities ratio remain unchanged. J. XYZ Company Limited is currently operating at full capacity. Requirements: 1. Compute the self-supporting growth rate of XYZ Company Limited. 2. Using the relevant sales target, are there any additional funding needs for XYZ Company Limited? Use both formula approach and the pro-forma financial statement approach. 3. If there is the need for additional funds, discuss some of the sources of funds and their implications for the company. ILLUSTRATION The following is the financial statement of XYZ Company Limited. The company is seeking to make projections on its financing needs for the upcoming year. They have tasked you, as the Finance Officer, to make the relevant estimations and determine any additional funding needs. Statement of Profit or Loss for the Year Ending 31st October, 2021 GH?000 Notes A B GH2000 2,500 (1.250) 1.250 Sales Cost of Sales Gross Profit Expenses: Administrative Sales and Marketing General Earnings before Interest and Tax Interest Earnings before tax 25 130 15 D E (170) 1,080 (400) 680 (170) 510 (25) 485 Tax F Earnings after tax Dividends Retained Earnings G Statement of Financial Position As At 31st October, 2021 Non-Current Assets Property Plant and Machinery Vans Notes H H H GH'000 40,000 35,000 25,000 100,000 Current Assets Inventory Accounts Receivables Cash and Cash Equivalent H H H 15,000 35,000 70,000 120,000 220,000 Total Assets EQUITY + LIABILITIES Opening Equity Retained Earnings 173,000 25,485 155,485 LONG-TERM LIABILITIES Loan 2.000 I CURRENT LIABILITIES Accounts Payable TOTAL LIABILITIES Equity + Total Liabilities 19.515 64,515 220,000 Notes: A. XYZ Company Limited is targeting a sales growth of 25% to meet growing demand and increase its market share. B. Cost of sales ratio remains unchanged. C. Sales and marketing expenditure is expected to increase in proportion with sales increase. D. Profit margin remains unchanged. E. Interest on loan is 20%. The loan has a maturity period of ten (10) years. F. Corporate tax rate is 25%. G. Dividend pay-out ratio remains unchanged. H. Asset to sales ratios remain unchanged. I. Spontaneous liabilities ratio remain unchanged. J. XYZ Company Limited is currently operating at full capacity. Requirements: 1. Compute the self-supporting growth rate of XYZ Company Limited. 2. Using the relevant sales target, are there any additional funding needs for XYZ Company Limited? Use both formula approach and the pro-forma financial statement approach. 3. If there is the need for additional funds, discuss some of the sources of funds and their implications for the company

Answer & Explanation Solved by verified expert

See Answer