Financial Insights And Business Intelligence Assignment Sample

1: Introduction Of Financial Insights And Business Intelligence

This project will emphasize the commercial and fiscal expertise of the picked company, Amazon Plc. More data for this project will be distributed based on two crucial components, including the study of economic ratios and the simulation of the revenue statement. Ratio calculations according to earnings, liquidity, solvency, as well as effectiveness ratios must be carried out in order to take into account all relevant information about the economic evaluation.

Need a helping hand to polish your assignments? Look no further than New Assignment Help! Our dedicated team offers premium assignment writing services in the UK, tailored to meet your specific requirements. Explore our free assignment samples for inspiration and guidance.

Detailed information about this project will be offered based on an extensive competitive assessment of the designated rivalries, Sainsbury's. On the basis of the statement of income modelling, which, in accordance with certain advised general suppositions may be used to classify nations, further specifics of this project will be explored. The successful completion of this job will also assist with the creation of a pertinent suggestion that will detail different ways in which ratio and financial requirements may be considerably improved in the near and distant destiny.

2: Part A: Ratio Calculations and Ratio Analysis&

2.1 Ratio Analysis

2.1.1 Profitability

Table 1: Computation of Profitability Ratios2.1.2 Liquidity

Table 2: Computation of Liquidity Ratios 2.2.3 Solvency

Table 3: Computation of Solvency Ratios2.2.4 Efficiency

Table 4: Computation of Efficiency Ratios

2.2 Comparative analysis

2.2.1 Profitability

Comparative analysis between Amazon and Sainsbury PLC has to indicate Sainsbury PLC net profitability margin is positive compared to Amazon PLC. The identification of net and gross profit margins has defined the continuous progression of business activity by Amazon PLC providing excellent growth in GP margin compared to NP margin. Sainsbury PLC has been informed about positive growth in net profit margin due to continuous growth in revenue volume (sainsburys.co.uk, 2023). Profitability identified gross profit margin growth of Amazon PLC is higher than Sainsbury PLC which indicates the organization is struggling with managing expenses of operational activities.

2.2.2 Liquidity

Based on the analysis, Amazon PLC's performance in current ratio management is continuously sustainable and has been effective to gain an advantage in future business operations. Sainsbury PLC's performance has been identified as stable in the current ratio due to current assets volume growth being positive. The liquidity ratio of both organizations has presented Information about the continuous progression in business activity with the growth of current assets which has been considered as current liabilities management activities (Jayakrishnan et al. 2018). Additional information has defined positive growth in financial year 2016 by 0.04. Consideration of both prospects to evaluate financial stability for managing debts is defined as Amazon PLC having better financial flexibility.

2.2.3 Solvency

The Solvency ratio of Amazon and Sainsbury PLC has identified continuous progression of business activity based on debt to equity ratio. The debt to equity ratio of Amazon PLC indicates negative growth in the financial year 2016 and 2016 -0.22 and -0.15. Whereas Sainsbury PLC's performance has been continuously progressive due to excessive equity financing has been adopted compared to debt financing. Using debt to total asset ratio defines an organizational approach toward optimization of total assets volume which has been evaluated by Amazon PLC's performance regarding Optimisation is better than Sainsbury PLC due to total assets volume increased by business operations (Boži? and Dimovski, 2019). Performance-wise, Amazon PLC outperforms Sainsbury PLC. Because of efficient management practices, Amazon PLC's performance is superior to Sainsbury PLC, as evidenced by the assets turnover ratio, which also shows that the organization's capacity for total asset optimization is continuously expanding.

2.2.4 Efficiency

Inventory turnover ratio identified continuous growth in Sainsbury PLC compared to Amazon PLC that indicates consumption of inventory holding is being evaluated as growth in profitability volume. Additional information regarding asset turnover ratio provided Information Amazon PLC's performance is higher than Sainsbury PLC's. The assets turnover ratio identified both organizational abilities to optimization of total assets is continuously growing which has provided information regarding Amazon PLC's performance is better than Sainsbury PLC's because of effective management policies.

In comparison to Amazon PLC, Sainsbury PLC's inventory turnover ratio showed consistent growth, indicating that the consumption of inventory holdings is being interpreted as an increase in profitability volume. Additional details about the asset turnover ratio are provided to define better future opportunities for Amazon PLC. As a result, the main counsel offered for the improvement in revenue statement modelling may be taken into consideration with regard to observing worldwide economic parameters such as inflation and GDP. Since it often needs to take into account the inclusion of multiple accounting elements, creating the statement of earnings modelling is regarded as a difficult task.

3: Part B: Income Statement Modelling

3.1: Generic Assumptions

Charges and other charges are predicted to rise in 2017 at a pace of 6% compared with 2016. When contrasted with the costs and liabilities incurred in the course of 2017, it will be expected that costs as well as appropriate expenses would increase by 5% in 2018. Compared to the gross sales obtained for the year 2017, selling profits in 2018 is expected to go up at an annualized rate of 5% and the sales revenues are forecast to rise 6% larger in 2017 than they did in 2016.

3.2: The Modelling

Table 5: Preparation and Presentation of Income Statement Modelling

3.3: Improvements Advised

Several further changes might be accentuated: sticking to the sincere growth index in the not-too-distant future. As per the narration and explanation of (Jail and Hwang, 2019), since it often needs to take into account the addition of multiple revenue statement elements, producing an income statement simulation can be seen as a difficult task. In this way, more accurate quantitative translations that provide estimations of net profits that come in close to reality could potentially be made attainable through the financial statement model. As a result, the main recommendations offered for enhancing the quality of income account forecasting may be taken into consideration with regard to detecting worldwide economic parameters such as hyperinflation and GDP.

4: Conclusion and Recommendations

4.1: Conclusion

Based on the above discussion it can be concluded that the majority of company associations work to enhance the budgets of specific businesses and foster solid partnerships that are beneficial to the growth of their operations. Likewise, the solvency ratio of a business organization's net revenue is a helpful finance matrix that effectively identifies its overall debt through the course of a fiscal year. A large number of company groups strive for the greatest future needs and are successfully contrasting by ratio-based methodologies, in order to find ways to increase sustainable business performance.

4.2: Recommendations

Many company organizations have to figure out how they satisfy all of the debt commitments of the business in order to assess or enhance the economic condition of the organization. This is required to identify the monetary framework of the business. The ratios of finances must be compared to the business's historic fiscal health in order to manage the company's short-term and long-term debt responsibilities.

References

• Ahmad, S., Miskon, S., Alabdan, R. and Tlili, I., 2020. Towards sustainable textile and apparel industry: Exploring the role of business intelligence systems in the era of industry 4.0. Sustainability, 12(7), p.2632.
• Boži?, K. and Dimovski, V., 2019. Business intelligence and analytics for value creation: The role of absorptive capacity. International journal of information management, 46, pp.93-103.
• Boži?, K. and Dimovski, V., 2019. Business intelligence and analytics use, innovation ambidexterity, and firm performance: A dynamic capabilities perspective. The Journal of Strategic Information Systems, 28(4), p.101578.
• Hu, Y., Xu, A., Hong, Y., Gal, D., Sinha, V. and Akkiraju, R., 2019. Generating business intelligence through social media analytics: Measuring brand personality with consumer-, employee-, and firm-generated content. Journal of Management Information Systems, 36(3), pp.893-930.
• Jalil, N.A. and Hwang, H.J., 2019. Technological-centric business intelligence: Critical success factors. International Journal of Innovation, Creativity and Change, 5(2), p.1499.
• Jayakrishnan, M., Mohamad, A., Azmi, F. and Abdullah, A., 2018. Implementation of business intelligence framework for Malaysian halal food manufacturing industry towards initiate strategic financial performance management. Management Science Letters, 8(10), pp.1059-1076.

Website

• sainsburys.co.uk, 2023, Competetor. Available at: https://about.sainsburys.co.uk/investors/results-reports-and-presentations/results-reports-and-presentations/2022 [Accessed on: 20th April, 2023]