Financial Analysis and Advice

Section 1: Income Statement Analysis

Section 1:

Income Statement

The following are financial information from Sunshine Coast Ltd for the 12-month reporting period ended 30 June 2021 on a cash basis:

You have also been provided with the following additional information:

• The accounts receivable and accounts payable balances at the start of the reporting period were $24,600 and $14,700 respectively. At the end of the reporting period, accounts receivable was $31 800 and accounts payable was $29,640.
• An advertising invoice of $4,440 had not been paid.
• The business has equipment that cost $60,600. It has a useful life of five years and an expected residual value of $6,600.
• The insurance expense represents the 12-month premium on a policy that was purchased on 30 April 2021.

Required:

1. Prepare the Income Statement for Sunshine Coast Ltd for the year ended 30 June 2021 on an accrual basis.

Angela Joss, the CEO of Sunshine Coast Ltd is confused about cash basis and accrual basis. She is also confused about which basis is more useful to measure financial performance in the Income statement. She is a lawyer by profession and has limited knowledge of accounting.

Required:

Prepare a memo advising Angela on which basis is more useful to measure financial performance and provide reasons. To support your argument, provide two examples from the income statement that you prepared in question 1 above.

Section 2:

Analysis and interpretation of financial statements

Wilson Ltd., a new medium-sized company operating in the agri-food sector, produces quality prepared food products. The following table illustrates the average performance of other companies in the same sector for 2020.

Industry Average Results, 2020

The following information has been extracted from the financial statements for 2020 and 2019 for Wilson Ltd.

 

Calculate the following ratios for Wilson Ltd for the year ended 30 June 2020. (all ratios must be rounded up to 2 decimal places)

1. Return on Equity (ROE)
2. Asset turnover
3. Current ratio
4. Debt to equity ratio

Comment on the company’s profitability and liquidity for the year ended 2020 using the relevant ratios calculated in 1 above and the industry averages given in the question. Also, make recommendations to improve the company’s profitability and liquidity position.  

Section 3:

Cost-volume-profit analysis

Wormy Comp is a manufacturer of plastic worm farms. Data relating to their one product for 2020 is as follows:

 

Required:

Covid-19 has increased the prices of plastic. This increased the variable manufacturing cost to $250 per unit. However, the company has managed to reduce their factory rental by $100,000, which has saved money on fixed manufacturing costs. Calculate the units that would need to be sold in 2021 to achieve the same profit as 2020. Comment on the impact of Covid-19 on the costs for 2020 using the relevant figures you calculated above.   

 

Safety First is a manufacturer of life jackets, life vests and buoyancy aids. They have provided the following information relating to the sales of their products in 2020:

 

Total Fixed costs = $515,000                                                                                                               

1. Calculate the break-even point in total units and units per product for 2020, using the following table:

 Calculate the total profit for 2020. Show all your workings.

Safety First is rearranging its store and wants to ensure that they make the best use of the limited space available to maximise sales possibilities. They have 150 metres of space available, and the 3 products use up space as follows:

 

How should the shelf space (150 metres) be allocated to the 3 products to maximise the profits? Justify your reasons for the space allocation using the relevant figures calculated above.

Section 4: Budgeting

Bitcom Limited had undertaken the following budget planning.  The budget is planned to sell 700 boxes at $700 each. The budget shows that it takes 20 kg of raw material to produce 1 box of the product. Each kg costs $14. The direct labour costs are budgeted at 10 hours per box produced, and the hourly rate for direct labour is $10. Fixed production and fixed administrative expenses are budgeted at 140,000 and 60,000 each. You have also been provided actual income statement information for the month of December 2020 (See the Table below).

Required:

Calculate the budgets alongside the actual results for the month of December 2020, calculate the individual variances, and indicate whether each variance is favourable or unfavourable.

 

 

Based on your answer in required 1. above, briefly explain the possible causes of the variances.