Question

In: Accounting

In December 20.8, Finch Limited was planning its financial needs for the coming year. As a...

In December 20.8, Finch Limited was planning its financial needs for the coming year.

As a first indication, the firm’s management required a pro forma Statement of Financial Position as at 31 December 20.9 to gauge the financial needs at that time.

Estimated financial condition as at 31 December 20.8 was reflected in this Statement of Financial Position :

ASSETS

R

Non-current assets

   451 800

Property, plant and equipment

   843 000

Accumulated depreciation

  (434 600)

Other non-current assets

      43 400

Current assets

2 982 400

Inventories

1 825 400

Accounts receivable

   722 400

Cash and cash equivalents

   434 600

Total assets

3 434 200

EQUITY AND LIABILITIES

Equity

   992 800

Ordinary share capital

   624 000

Retained income

   368 800

Non-current liabilities

   240 000

Mortgage bond

   240 000

Current liabilities

2 201 400

Accounts payable

    612 300

Other current liabilities

1 589 100

Total equity and liabilities

3 434 200

Additional information

Note : Please show all workings

Operations for the following year were projected using the following working assumptions to plan the financial results:

  • Sales (all credit) were forecast at R20 900 000, with a gross margin of 8.2%.

  • Purchases (all credit) are expected to total R19 450 000.

  • Accounts receivable would be based on a collection period of 12 days, while 24 days accounts payable

    would be outstanding.

  • Depreciation is expected to be R62 800 for the year.

  • A mortgage loan repayment of R20 000 is expected to be made.

  • Other current liabilities will be allowed to fluctuate with seasonal needs.

  • Capital expenditures were scheduled at R42 000 for a delivery van and R72 000 for warehouse

    improvements.

  • Profit after tax is expected at a level of 0.19% of sales.

  • Dividends for the year were scheduled at R25 000.

  • Cash balances are desired to be no less than R300 000.

Solutions

Expert Solution

Assets Amount working
Non current assets
Property Plant & Equipment 843000 no change
Acc dep -497400 434600+62800
Delivery Van 42000 New purchase
Other non current assets 115400 43400+72000
Current assets
Inventories 2089200 calculation shown below
Accounts receivable 687123 20900000X12/365
Cash and cash equivalents 300000 Given
Total assets 3579323
EQUITY AND LIABILITIES
Ordinary share capital 624000 no change
Retained Income 383510 368800 + 14710
Non-current liabilities
Mortgage bond 220000 240000 - 20000
Current liabilities
Accounts payable 1278904 19450000 X 24/365
Other current liabilities 1072909 bal figure
Total equity and liabilities 3579323
Sales 20900000
Profit after tax 39710
Dividends paid -25000
Balance carried to retained income 14710
Gross margin 1713800
Purchases 19450000
Opening stock 1825400
Less:
Sales 20900000
Closing stock 2089200

Please Like the solution if satisfied with the answer and if any query please mention it in comments...thanks


Related Solutions

Cure Limited prepares its financial statements to 31 December each year. The company is involved in...
Cure Limited prepares its financial statements to 31 December each year. The company is involved in the pharmaceuticals industry and its operations are divided into two cash generating units, ‘EU’ and ‘Non EU’. Two issues need to be resolved before the financial statements for the year ended 31 December 2018 can be finalised. Issue 1: The following information is available in relation to the two cash generating units. EU Non EU £’000 £’000 Goodwill - 4,800 Other intangible assets 6,000...
Swan Limited prepares its financial statements to 31 December each year, and the following issues need...
Swan Limited prepares its financial statements to 31 December each year, and the following issues need to be resolved before the financial statements for the year ended 31 December 2013 can be finalised. Issue 1: Swan Limited acquired a new property on 1 January 2007 for £2,400,000. On this date, the property had an estimated useful economic life of 50 years with no residual value. The directors of Swan Limited decided to apply the cost model to measure the property...
Jones Limited has a year-end of 31 December. When preparing its financial statements for 2012, the...
Jones Limited has a year-end of 31 December. When preparing its financial statements for 2012, the accountants estimated that the income tax payable would be £62,000. The liability was settled in 2013 at £65,000. Assume this company pays its tax liabilities on time. Jones bought a piece of machinery for £50,000 on 1 January 2013 which has a useful life of two years and will be scrapped at the end of its life. A first year allowance of 100% is...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the...
WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the purchase of additional trucks, of which three sizes are available. A large truck costs $150,000 and will return the equivalent of $15,000 per year to profit. A medium-sized truck costs $90,000 and will return the equivalent of $12,000 per year. A small truck costs $50,000 and will return the equivalent of $9,000 per year. WeHaul has maintenance capacity to service either four large trucks,...
The financial year end of Diary Manufacturing Limited is 31 December. At 31 December 2012, the...
The financial year end of Diary Manufacturing Limited is 31 December. At 31 December 2012, the following balances are available: Item € Land and building at cost 286000 Plant and machinery at cost 210000 Accumulated depreciation on plant and machinery 46000 Purchase of raw material 260200 Sales 635000 Factory rates expenses 6000 Factory heats and light 13000 Account receivables 74400 Account payable 61800 Wages 126000 Direct expenses 18200 Selling expenses 22000 Administration and general expenses 46000 Bank 49000 General reserve...
Finch Company began its operations on March 31 of the current year. Finch has the following...
Finch Company began its operations on March 31 of the current year. Finch has the following projected costs: April May June Manufacturing costs* $155,900 $198,700 $206,800 Insurance expense** 990 990 990 Depreciation expense 2,110 2,110 2,110 Property tax expense*** 600 600 600 *Of the manufacturing costs, three-fourths are paid for in the month they are incurred; one-fourth is paid in the following month. **Insurance expense is $990 a month; however, the insurance is paid four times yearly in the first...
Finch Company began its operations on March 31 of the current year.  Finch has the following projected...
Finch Company began its operations on March 31 of the current year.  Finch has the following projected costs: April May June Manufacturing costs (1) $156,800 $195,200 $217,600 Insurance expense (2) 1,000 1,000 1,000 Depreciation expense 2,000 2,000 2,000 Property tax expense (3) 500 500 500 ​ (1) Of the manufacturing costs, three-fourths are paid for in the month they are incurred; one-fourth is paid in the following month. (2) Insurance expense is $1,000 a month; however, the insurance is paid four...
(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year....
(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 65%, which the firm's investment bankers have recommended. Based on the AFN equation, by how much would the AFN for the coming year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT