Module Code: QHO320

Module Title: Understanding Finance

Assessment Title: Budget Report

Assessment Scenario

Gaia Ltd is an established vehicle manufacturer operating across the UK and Europe. The directors of Gaia Ltd are considering expanding manufacturing of their new Electric Vehicle (EV), named the Gaia Niche, over the next 12 months.

PART A (35% weighting)                                      

The directors of Gaia Ltd have asked you, as a recently employed assistant management accountant, to prepare and review their cash budget. Their bookkeeper started the cash budget but was unable to complete it due to ill health.

In addition, Gaia Ltd requires you to evaluate the different funding options for its expansion plans.

Estimated sales and purchases for each of the nine months to September are given below:

Trade Receivables: Credit sales are to be collected one month after the date they have been sold.

Trade Payables: Credit purchases are to be paid one month after the date they have been purchased.

Borrowings: The terms of a 5-year loan are coming to an end and Gaia Ltd are due to repay the capital of £10,000,000 on 31^st July.

Current Liabilities: Corporation tax of £500,000 is due to be paid to HMRC in the month of May.

Other overheads: Other overheads will be £9,000,000 per month settled on a monthly basis in the month incurred.

Cash: Gaia Ltd expects to have £10,000overdraft at the beginning of April.

You are required to:

1. Use Excel to prepare a cash budget for the business for the 6-month period from April to September (15% weighting)

NOTE:  To achieve full marks you MUST submit an Excel spreadsheet with your report (not a screenshot) to show your workings and demonstrate your Excel skills, e.g. cell referencing and formula.

2. Examine the cash budget you have prepared and advise the directors of Gaia Ltd of any possible solutions to solve any cash flow problems that might be evident. You should conduct appropriate research using academic sources to generate ideas and discussion. Marks will be awarded depending on the depth of discussion. (10% weighting)
3. Gaia Ltd are listed on the London Stock Exchange and are considering raising finance for the expansion plans through the issue of shares. You have been asked to identify additional suitable sources of finance that may be available to Gaia Ltd. You should consider the advantages and disadvantages of the sources of finance you have identified, including the issue of shares. You should then make a recommendation to the directors of Gaia Ltd of the most appropriate source of finance for the proposed expansion plans. You should conduct appropriate research using academic sources to generate ideas and discussion. Marks will be awarded depending on the depth of discussion. (10% weighting)

PART B (40% weighting)

The Directors of Gaia Ltd are considering expanding manufacturing of their new Electric Vehicle (EV), named the Gaia Niche, over the next 12 months. Gaia Ltd have asked you to calculate and compare ratios for 2019 and 2020 before making a recommendation as to whether to proceed with expansion plans or not.

You are required to:

 

1. Use your Excel skills to calculate the following ratios for both years.

You should then present your calculated ratios within your report in a simple table format for ease of comparison. (15% weighting) 

NOTE:  To achieve full marks you MUST submit an Excel spreadsheet with your report (not a screenshot) to show your workings and demonstrate your Excel skills, e.g. cell referencing and formula.

1. Gross profit margin
2. Operating profit margin
3. Return on capital employed
4. Asset turnover
5. Current ratio
6. Acid test
7. Inventory days
8. Trade receivable days
9. Trade payable days
10. Working capital cycle/operating cycle
11. Gearing
12. Interest cover

 

2. Compare the performance for both years in the 4 key areas of profitability, efficiency, liquidity and gearing using the ratios calculated in part 1 and make a recommendation as to whether Gaia Ltd should proceed with expanding manufacturing of their new EV, Gaia Niche. Marks will be awarded depending on the depth of discussion. (25% weighting)

 

PART C (25% weighting)

Gaia Ltd has experienced fluctuating consumer demands since the beginning of the Covid-19 pandemic but are cautiously optimistic now that restrictions appear to be easing.

Their latest product is a new Electric Vehicle (EV) called the Gaia Niche and have a supply chain through which they import components and EV batteries from Europe. The following information is available for the year ending 31^st Dec 2022.

1. Due to fluctuating and unpredictable consumer demands, you have been asked to use Excel to prepare a flexible sales budget for quantities of 25,000 units and 35,000 units. Sales revenue is fully variable. (10% weighting)

NOTE:  To achieve full marks you MUST submit an Excel spreadsheet with your report (not a screenshot) to show your workings and demonstrate your Excel skills, e.g. cell referencing and formula.

1. Identify and discuss specific issues that could impact both the manufacturing and production of the Gaia Niche EV, and consumer demand for the product. Issues should be in context with the given scenario and current economic climate. You should conduct appropriate research using academic sources to generate ideas and discussion. Marks will be awarded depending on the depth of discussion. (15% weighting)

 

“You can order QHO320 : Understanding Finance Assessment from our service and can get a completely high-quality custom paper. Our service offers any of the QHO320 Academic paper written from scratch, according to all customers’ requirements, expectations and highest standards.”