QHO320 Understanding Finance Assignment Sample

Deepen your finance knowledge with QHO320 Understanding Finance assignment, covering essential concepts and practical financial skills.

  • 72780+ Project Delivered
  • 500+ Experts 24x7 Online Help
  • No AI Generated Content
GET 35% OFF + EXTRA 10% OFF
- +
35% Off
£ 6.69
Estimated Cost
£ 4.35
Prices Starts From
GBP 5.00GBP 9.00
4 Pages 1116 Words

PART A: QHO320 Understanding Finance Assignment

1. Cash Budget

Cash budget of Linda Ltd for the period of 6 months is as follows:

Particulars April (in £) May (in £) June (in £) July (in £) August (in £) Sept (in £)
Beginning cash balance -10000 4990000 3990000 4490000 -25910000 -4305000
Add
Cash sale 73500000 76500000 81000000 83000000 100000000 141000000
Cash collection from debtors 4200000 4200000 4200000 4300000 4305000 4400000
Total cash inflows 77690000 85690000 89190000 91790000 78395000 141095000
Less: cash outflows
Payment to creditors 72000000 80500000 84000000 87000000 82000000 84000000
Loan 30000000
Tax 500000
Overhead 700000 700000 700000 700000 700000 700000
Sum of Cash outflows 72700000 81700000 84700000 117700000 82700000 84700000
Cash balance (closing) 4990000 3990000 4490000 -25910000 -4305000 56395000

2. Issue in cash budget

It has been identified that firm is paying its entire creditor after the one month of purchases. Firm should increase the trade payable time duration which will help in managing high cash balance and thereby facilitates optimum utilization of the business finances.

Whether it's essays, research, or reports, New Assignment Help offers expert-level Assignment Help to support your academic journey.

3. Suitable source of finance

After evaluating the cash budget, it has found that firm is having effective cash balance so that organization could opt for raising finance from debt sources such as debenture or bank loan for the expansion purpose. According to the Cao (2022), it has been identified that debt will help in gaining the tax benefit for the firm which result into high firm’ profitability. However, Debt finance creates the interest obligation which further increases the financial burden. Based on the view point of Lv et al, (2021) issue of share will help in gaining access to the large amount of funds and reduces the financial obligation of the business entity. However, equity source of finance result into the dilution of ownership and leads delay in the decision making process. After evaluating both limitation and advantages, director of Linda ltd is advised to choose debt financing for the expansion plan.

PART B: RATIO ANALYSIS

1. Calculation of Ratios

Ratio analysis of Linda Ltd for the period of 2020 and 2021 is as follows

  1. Gross profit margin
Particulars Formula 2020 2021
Gross Profit 85700000 992600000
Sales revenue 858500000 1988400000
GP ratio Gross profit / sales * 100 10% 50%
  1. Contribution margin
Particulars Formula 2020 2021
Sales revenue 858500000 1988400000
Variable cost 772800000 995800000
Contribution margin (revenue-Variable cost)/ revenue 1.11% 2.00%
  1. Operating profit margin
Particulars Formula 2020 2021
Sales revenue 858500000 1988400000
Earnings before interest and tax or operating profit -900000 18791000
Operating profit margin EBIT / sales 0% 1%
  1. Return on Equity/investment
Particulars Formula 2020 2021
Net income 858500000 1988400000
Shareholder equity 14470000 35140000
ROE Net income/ shareholder equity 59.33% 56.59%
  1. Asset turnover
Particulars Formula 2020 2021
Turnover or sales revenue 858500000 1988400000
Average total assets 179152000 226427500
Total assets turnover ratio (in times) Net sales/ average total asset 4.79 8.78
  1. Liquidity ratio
Particulars Formula 2020 2021
Current assets 163952000 255003000
Current liabilities 115365300 172825600
Inventory 150100000 126500000
Prepaid expenses
Quick assets 13852000 128503000
Liquid ratio Current assets - (stock + prepaid expenses)/ CL 0.12 0.74
  1. Current ratio
Particulars Formula 2020 2021
Current assets 163952000 255003000
Current liabilities 115365300 172825600
Current ratio Current assets / current liabilities 1.42 1.48
  1. Inventory days
Particulars Formula 2020 2021
Cost of goods sold 772800000 995800000
Average Inventory 150100000 201550000
Inventory days (Average inventory/ COGS)*365 1879 1803
  1. Trade receivable days
Particulars Formula 2020 2021
Turnover or sales revenue 858500000 1988400000
Receivables or debtors 10300000 8170000
Receivables or debtors turnover ratio (in days) (Debtors * 365) / Credit sales 4.38 1.50
  1. Trade payable days
Particulars Formula 2020 2021
Cost of goods sold 772800000 995800000
Creditors or payables 53300000 79700000
Creditors turnover ratio (in days) (Creditors * 365) / COGS 25.17 29.21
  1. Gearing ratio
Particulars Formula 2020 2021
Total debt 164682000 238563000
Total equity 14470000 35140000
Gearing ratio Total debt/ total equity 11.38 6.79

2. Evaluation of Firm’s performance:

Below is the evaluation of firm’s performance based on the above ratio analysis:

Profitability: It has been determined that firm’s profits have increased in year 2021 as compared to the previous year. Linda Ltd is able to attain the ideal ratio that indicates the firm’s efficiency in maintaining long term stability within the industry. Further, it has been identified that operating ratio of firm is 1% and in the year of 2020 firm was unable to earn any operating profit which indicates the firm’s inefficiency in managing the operational cost. It has further depicted that firm is having effective profits to cover its fixed cost. Additionally, the return for shareholder has increased which indicate the adequate profitability position of Linda ltd.

Liquidity: The current ratio of the organization is effective which indicate that Linda ltd will be able to pay off all its liabilities by selling its assets (Bertoldi et al, 2021). However, the firm is not having adequate amount of liquid assets that will create issue in paying off short term liabilities.

Efficiency: It has further determined that firm’s asset turnover ratio has increased which indicate that Linda ltd is making optimum utilization of firm’s resources (Sasongko, Ilmiyono and Tiaranti, 2021). The debtor’s receivable time is reducing and creditors payable time duration get increased which denotes effective cash flow of the Linda Ltd. From the above analysis, it has concluded that firm should initiate the expansion as firm is having effective liquidity, profitability and efficiency position.

PART 3

NOTES: Issues impacting manufacturing of Linda David

As the Linda Ltd is planning to source raw material from other part of the Europe, company will face issue in effectively managing the supply chain. Firm will not be able to manage all the activity of supply chain which increases risk of mishappening. Further prices of goods and services in Europe are increasing which create issue in managing overall cost of production.

Issue impacting consumer demand

From the pestle analysis, it has identified that there is increase in the inflation rate within the country. This results in increasing the cost of production and makes the product expensive for the customer. Further, inflation causes reduction in purchasing power of customer leading to fall in demand (Lubis et al, 2022). There is increase in the number of organizations providing Heavy electric equipment that result in reducing demand.

Impact of flexible budget

Flexible budget refers to the budget in which amount are changed based on revenue, cost and due to any expected event (Johansson-Berg and Wennblom, 2023). As it has identified that there is inflation in the country, flexible budget will aids in adjusting the cost according to the current economic situation. This budget will also help in effectively allocating necessary resources results in adequately managing supply chain (Impact of Flexible budget, 2024). This budget assists in effectively managing cash flow as firm is provided with opportunity to allocate resources based on the company’s funds

REFERENCES

Books and Journals

  • Cao, L., 2022. Ai in finance: challenges, techniques, and opportunities. ACM Computing Surveys (CSUR), 55(3), pp.1-38.
  • Lv, C., Bian, B., Lee, C.C. and He, Z., 2021. Regional gap and the trend of green finance development in China. Energy Economics, 102, p.105476.
  • Bertoldi, P., Economidou, M., Palermo, V., Boza‐Kiss, B. and Todeschi, V., 2021. How to finance energy renovation of residential buildings: Review of current and emerging financing instruments in the EU. Wiley Interdisciplinary Reviews: Energy and Environment, 10(1), p.e384.
  • Sasongko, H., Ilmiyono, A.F. and Tiaranti, A., 2021. Financial ratios and financial distress in retail trade sector companies. JIAFE (Jurnal Ilmiah Akuntansi Fakultas Ekonomi), 7(1), pp.63-72.
  • Lubis, S.S., Maherza, W., Ziwiana, N.D. and Muda, I., 2022. Flexible Budget and Overhead Analysis in Pharmacy Issuers. Journal of Pharmaceutical Negative Results, pp.2931-2936.
  • Johansson-Berg, T. and Wennblom, G., 2023. If managers feel safe, budget control becomes enabling. Evidence from a large local government organization in Sweden. Journal of Public Budgeting, Accounting & Financial Management, 35(6), pp.154-179.

Online

  • Impact of Flexible budget. 2024. Online available through;< https://www.prophix.com/blog/flexible-budget-everything-you-need-to-know/#:~:text=Because%20flexible%20budgets%20allow%20companies,more%20flexible%20with%20their%20spending.>
Author Bio
author-image
Jack Roberts   rating 9 years | PhD

Greetings Students. I have obtained my PhD in finance from a reputed university in the UK. I worked as a finance professor for a few years and worked as a writer. I have been associated with New Assignment Help for 9 years, assisting students with their academic papers. Hire me for your finance paper and get the best results.

Seasonal Offer
scan qr code from mobile

Get Extra 10% OFF on WhatsApp Order

Get best price for your work

×
Securing Higher Grades Costing Your Pocket? Book Your Assignment At The Lowest Price Now!
X