Chandigarh Assignment Help

India +917015806060

MENU

Complete the details marked in the coloured text and leave everything else blank. Copy and paste your submission after the first pages as indicated. You are reminded of the University regulations on cheating. Except where the assessment is group-based, the final piece of work which is submitted must be your own work. Close similarity between submissions is likely to lead to an investigation for cheating. You must submit a file in an MSWord or equivalent format as tutors will use MSWord to provide feedback including, where appropriate, annotations in the text.

Student Name   

Pooja

Reasonable Adjustments

 

Student Number

21163830

Check this box [x] if the Faculty has notified you that you are eligible for a Reasonable Adjustment (including additional time) in relation to the marking of this assessment. Please note that action may be taken under the University’s Student Disciplinary Procedure against any student making a false claim for Reasonable Adjustments.

Course and Year   

MSc Management

Module Code   

ACC7032

Module Title   

Managerial Finance

Personal Tutor 

None

First Marker Name:

 

First Marker Signature:

 

Date:

 

Feedback: General comments on the quality of the work, its successes and where it could be improved

 

Provisional Uncapped Mark Marks will be capped if this was a late submission or resit assessment and may be moderated up or down by the examination board.

%

Feed Forward: How to apply the feedback to future submissions

 

Quality and use of Standard English and Academic Conventions

 

Spelling Errors

 

Style is Colloquial

 

Standard is a Cause for Concern

 

Grammatical Errors

 

Inappropriate Structure

If the box above has been ticked you should arrange a consultation with a member of staff from the Centre for Academic Success via Success@bcu.ac.uk 

 

Punctuation Errors

 

Inadequate Referencing

Moderation Comments (Please note that moderation is carried out through ‘sampling’. If this section is left blank, your work is not part of the sample.)

Moderation is done via sampling. Your work was not part of the sample.

Moderator Name:

 

Moderator Signature:

 

Date:

 

Table of Content

Content 

Sub Content  

1

1.1 Business Report for acquisition 

 

1.2 Working Capital Management 

 

1.3 Source of Finance 

2-a

1.i Contribution per product 

 

1.ii Making Product Bass

 

1.iii Making Product Cabinet

 

1.iv Marginal Costing Techniques  

 

1.v Decision Making

2-b

  1. Net Present value 
 
  1. Payback period 
 
  1. Internal Rate of Returns 
 
  1. Suggestion
 
  1. Limitation

3

  1. Revised Statements
 
  1. Effect on Profits
 
  1. Suggestion 

References 

 

Answer  1

A financial services company based in the United Kingdom, Mars Holdings Plc Firm has subsidiaries in a variety of industries, including automobile dealerships and freight transportation, machinery production, as well as equipment leasing and finance, among others. Mars Holdings Plc Firm was founded in the United Kingdom in 1997. The company is presently attempting to acquire other firms to grow its list of subsidiary enterprises. In recent months, the corporation has targeted two businesses, known as WYRE CHILD SERVICES Ltd and BORDER Commercials Ltd, and the company has made takeover approaches to both.

In this instance, the two firms execute their activities in two different industries from one another. The establishment of WYRE CHILD SERVICES Ltd, which operates a hotel and provides care facilities for young people who do not have access to a vehicle at an early age, is the first major step. As a temporary measure, Mars Holdings Plc is open to exploring other options for a franchised hospitality service provider that is not presently active in the company. WYRE CHILD SERVICES Ltd is also looking forward to the acquisition of more properties in a variety of places around the United Kingdom, including London. While BORDER COMMERCIALS Ltd. primarily focuses on the supply of storage facility yards, it also owns a vehicle repair firm, which it uses for its operations. BORDER COMMERCIALS Ltd. has started to outsource many areas of their business to other persons, and they expect to continue to grow their operations in the future.

A variety of ratios for WYRE CHILD SERVICES Ltd. and BORDER Commercials Ltd. have been calculated and are shown in this box, which also contains a comprehensive ratio analysis for both firms. WYRE CHILD SERVICES Ltd.

1.1: Ratio analysis 

Profitability Ratio: 

Analysis: 

We can see that the profitability ratio for WYRE CHILD SERVICES Ltd is much greater than the normal average when measured in terms of investment. Later, the BORDER COMMERCIALS Ltd. was established because of this decision. Even though the profit margin on sales is low, this may be because the profit margin ratios of the two companies are considerably different. For his or her part, the investor cares about his or her profit ratio, which has been calculated depending on the amount of money that has been invested. As a result, it has been suggested to the Board of Directors that investments in WYRE CHILD SERVICES Ltd. be preferred above investments in BORDER COMMERCIALS Ltd. because of this.

Activity Ratio:

Analysis  :  

We can also see that the total activity ratio of WYRE CHILD SERVICES Ltd. is higher than the overall activity ratio of BORDER COMMERCIALS Ltd. Therefore, it is advised that the Board invest in WYRE CHILD SERVICES Ltd rather than BORDER COMMERCIALS Ltd. because of this.

Liquidity Ratio: 

Analysis :  

The current ratio of WYRE CHILD SERVICES Ltd is lower than the current ratio of BORDER COMMERCIALS Ltd. The current ratio of WYRE CHILD SERVICES Ltd is lower than the current ratio of BORDER COMMERCIALS Ltd. However, as we all know, although an excessive increase in investments in the current ratio increases liquidity, it harms the long-term profitability of the business. According to this metric, WYRE CHILD SERVICES Ltd. outperforms BORDER COMMERCIALS Ltd. in terms of financial performance.

Analysis : 

WYRE CHILD SERVICES Ltd. has a somewhat higher gearing ratio than BORDER COMMERCIALS Limited, suggesting that the firm is more exposed to risk than the latter. Despite this, the interest coverage ratio for WYRE CHILD SERVICES Ltd is much greater than the national average.

All the above analysis shows that the investment in the  WYRE CHILD SERVICES Ltd as their subsidiary firm would result in more profits for Mars Holdings Plc since it is the more profitable investment choice than BORDER COMMERCIALS Ltd. The other parameters are also in the favour of the Wyre Child only. 

Answer: 1.2: Working capital management 

The following table summarises the conclusion, as well as the appraisal of the working capital for WYRE CHILD SERVICES Ltd and BORDER COMMERCIALS Ltd.

 

WYRE CHILD SERVICES LTD.( £ )

BORDER COMMERCIALS LTD. ( £ )

Particulars 

Current Assets 

417030

651435

Current Liabilities 

207224

122944

Liquid Assets 

417030

651435

Working Capital = CA- CL 

209806

528491

Current ratio 

2.01

5.30

Acid test ratio 

2.01

5.30

Analysis: 

This table illustrates that the necessary working capital of BORDER COMMERCIALS Ltd. is £ 528,491, which is much more than the required working capital of WYRE CHILD SERVICES Ltd., which is £ 209,806 (as shown in the previous table). Increased liquidity, however, may result if the parent company puts more working capital behind BORDER COMMERCIALS Ltd., at the expense of a significant reduction in profit margins. WYRE CHILD SERVICES Ltd has a current working capital ratio of 2.01, which is almost the same as the company’s average working capital ratio. Despite this, the current ratio for other firms is 5.30, which is a very high figure. It is thus advised that working capital be assigned to WYRE CHILD SERVICES Ltd rather than BORDER COMMERCIAL LTD because of the above study. As a result of the analysis, we can conclude that the working capital management of Wyre Child Services ltd. is significantly better, and that the company is well-managed when compared to Border Commercials Ltd.

Answer 1.3: Recommended sources of finance 

In the below box, two different finance sources for Mars Holdings Plc and their advantages along with the disadvantages are explained.

Table 3: Advantages and disadvantages of different sources of finance

Financial sources 

Benefit

Limitation

Ordinary Share Capital 

According to the preceding paragraph, it contributes to reducing the overall risk of the business, which increases when a firm invests via loan financing. When we get the finance through the ordinary share capital this will increase the share capital and no fixed commitments will be paid on the ordinary share capital. 

When equity financing is employed, the value of profits per share will decrease because of the financing is done using equity. Although it has the potential to reduce equity, which is associated with financial stability, it is not guaranteed to do so in practice. Because of these conditions, no investor will express an interest in making a financial investment in the company. When the value of the share drops, the increasing number of shares will influence most of the claim, resulting in a reduced playout for most of the claim.

 

Because there are no set obligations for the interest that must be paid under equity finance, the company’s risk has not increased because of the financing. In this case, the firm only pays the dividend when the company makes a profit.

When the ordinary shares are issued, the share capital will have to be shared with the other investors, and the other investors will also have to share with the board of directors if the board of directors determines that it is necessary based on their percentage holding of the company’s share capital.

Debt Finance

As soon as you exclude taxes from the total, you will find that debt financing rates are always cheaper than the expenses connected with equity financing.

If the value of the company’s validity decreases, it can raise the financial risk associated with that decline.

Answer: 2: Part a:

The specifics of the three items have been presented, and it is necessary to analyse those specifics, particularly concerning the two products that are not profitable and are incurring losses. The information has been given by AJ Supplies Ltd, which is responsible for the manufacture of the three goods. The following are the specifics of the computation, summarised as follows:

i: Contribution per unit has been computed following management accounting principles, and the following are the specific details:

Particulars 

Acoustic ( £ m)

Bass ( £ m) 

Clarinet ( £ m) 

Total ( £ m)

Sales 

360.00

240.00

180.00

780.00

COS – Cost of Sales 

       

Cost of Material

-120.00

-80.00

-80.00

-280.00

Cost of Labour 

-120.00

-120.00

-120.00

-360.00

Variable cost total 

-240.00

-200.00

-200.00

-640.00

Total contribution per product 

120.00

40.00

-20.00

140.00

Less: Gross Fixed Overheads 

-60.00

-60.00

-60.00

-180.00

Profits / – Loss 

60.00

-20.00

-80.00

-40.00

It has been estimated here what the Contribution per unit is, and we can see from the results of the computation that the Acoustic and Bass have a positive contribution, whilst the Clarinet has a negative contribution.

  1. According to management accounting tools and the notion of marginal costs, it has been indicated that we should continue producing the items that provide a positive contribution per unit of production. However, we should not continue to manufacture a product that does not make a good contribution. According to the results of these calculations, it has been advised that the corporation should continue to manufacture the two goods known as the Acoustic and the Bass, respectively.

iii. According to the detailed calculations and management accounting concepts, as well as the marginal costing, the product Clarinet is generating a negative contribution, and as a result, it has been recommended that the company discontinue the production of the product Clarinet to avoid further financial loss.

According to the marginal costing method, the variable costs include the cost of materials and the cost of labour. Furthermore, these expenses will be included in the computation of the contribution. Once the contribution has been computed, the overhead costs will be deducted from the contribution amount and reimbursed. The gift will be used to cover the costs of running the business. The notion of marginal costs is explained in more detail below. These expenses have been categorized as fixed and will be utilized as period costs in addition to being handled as a fixed expenditure. Thus, the donation will be utilized to cover the costs of operating the business.

  1. According to the calculations, the Bass will have to be constructed. If we stop producing the Bass, our losses will grow, and our earnings will decrease, depending on the situation. However, the product Clarinet will be phased out of production since the cessation of Clarinet manufacturing will raise the contribution, or, to put it another way, the contribution will not be reduced as a result of this. As a result, discontinuing the product Clarinet will boost the earnings of the corporation.

As a result, the continued production of the product Bass and the discontinuation of the production of the product Clarinet will improve the company’s earnings.

Answer Part 2(b) 

  1. The cash flow statements, as well as the calculation of the net present value, have been completed, and the details have been summarised in the following way: 

Particulars / Year 

0

1

2

3

 

Amount ( £ )

Amount ( £ )

Amount ( £ )

Amount ( £ )

Investment Cost 

       

Cost of Land 

-4000.00

     

Cost od Building  

-7900.00

     

Cost of F & E 

-1830.00

     

Gross Sales Revenue  

 

28600.00

29172.00

29755.44

Less:  

       

Cost of Product acoustic  

 

-7900.00

-8058.00

-8219.16

Bass Stock Sold  

 

-5660.00

-5773.20

-5888.66

Cost of Staff 

 

-1180.00

-1203.60

-1227.67

Cost of Heating & Lighting  

 

-1676.00

-1709.52

-1743.71

Overhead’s cost 

 

-6424.00

-6552.48

-6683.53

Inflows of Cash 

 

5760.00

5875.20

5992.70

FCF = Free cash Flows  

-13730.00

5760.00

5875.20

5992.70

Present  Value@ 12% 

1.00

0.89

0.80

0.71

Present Value  

-13730.00

5143.10

4683.71

4265.61

Net Present Value  

362.42

     

The NPV has been calculated and it is positive. 

  1. Several factors have been considered in determining the payback time and discounting payback period, with the following results:

PBP = Payback Periods  

Amount ( £ )

Amount ( £ )

Amount ( £ )

Amount ( £ )

Particulars / Year 

0

1

2

3

FCF = Free cash Flows  

-13730.00

5760.00

5875.20

5992.70

Cash flows cumulative  

-13730.00

-7970.00

-2094.80

3897.90

PBP = Pay Back Periods  

2 Years  

0.35

2.35 Years 

 

The Discounted payback period has been as follows: 

(iii ) Computed using the Excel formula, the internal rate of return has been described in detail below. The internal rate of return has been calculated using the following parameters:

(iv) In light of the calculations, it seems that the project has a 12 percent positive net present value (NPV). Nonetheless, it has been recommended that we include an additional 5% to account for inflation in our proposals. Additionally, we can observe that the project payback time is nearing the end. Even though the additional 5 percent coverage isn’t needed in this case, the project won’t be chosen because of the low IRR (only 13.52 percent) if it has been evaluated. The idea is thus doomed to failure, as I have calculated and determined via research.

  1. We’ve reviewed the limitations of the project assessment approaches stated above, and they are as follows: when we speak about the payback period, we don’t consider how much money is worth over time. In addition, we have seen that the fact that there is no tax has been taken into consideration. If the tax had been taken into consideration, the feasibility of the project would have been jeopardized. The third constraint of this project is that we need to add 5 percent to the cost of capital, while inflation has only grown by 2 percent because of the project’s implementation. As a result, we must recognize that there are certain concerns, such as the fact that the government is advising us to add 5 percent, even though the inflation rate has only grown by 2 percent. There are several limits linked with this project that has been identified, and these are the same restrictions that have been identified as the limitations of the PBB, NPV, and IRR.

Answer 3: a; 

 Revised budgeted Income statements 

Revised Budget Proposals 

Amount ( £ )

Gross Sales 

1110000

Less: 

 

Material cost reduced by 8% 

-418600

 

Labour cost reduced by 2%

-212160

Overhead variable reduced by 2%

-159120

Fixed Overheads (add: 20000)

-160000

Total Costs 

-949880

Net Profits  

160120

Revised Balance sheet

Revised Comprehensive Budgeted Net Assets 

   

Particulars 

Amount (£)

Amount (£)

NCA

 

              375,000 

WC

   

Account Receivables = 64 Days = 1110,000*64/360

          197,333 

 

Ending Inventory = 110,000 + 40,000

              150,000 

 

Account Payables = (50000 + 25000)

–                75,000 

 

NWC = Total Current Assets – Total Current Liability  

 

            272,333 

Net assets

 

                647,333 

Working Notes: 

Working:

     

Sales Budget revised 

     

Budget Proposal revised

Quantity  

Rates 

Total 

Gross sales 

10000

£                           30 

£                300,000 

Existing Sales 

22500

£                           36 

£                810,000 

Sales Total 

   

£             1,110,000 

       

Budget of Material cost

     

Material cost reduced by 8% 

32500

£                     12.88 

-£                418,600 

     
       

Labour Cost budget 

     

Labour cost reduced by 2%

32500

-£                  6.5280 

-£                212,160 

       

Variable Overhead budget 

     

Variable Overheads inc.by 2%

32500

-£                    4.896 

-£                159,120 

       

Fixed Overhead Budget 

     

Fixed Overheads (add: 20000)

(140,000 + 20,000) 

-£                160,000 

  1. the effect on profit of the changes resulting from the proposal. The Contribution per unit and the total contribution has been calculated as follows: 

Particulars 

Contribution per unit (£)  

Total Contribution (£)

Net Profits (£)

Budget Old

                                    10.80 

        270,000

        130,000

Budgeted revised

                                    9.85 

        320,120

                160,120 

c. Due to the improved total profits, it has been recommended to the management that the new plan, which would boost both sales and total profits, should be implemented. The preceding calculation was performed for this reason, and the overall contribution, as well as the earnings, have grown as a result. As a result, it is preferable that the newly amended plan has been beneficial to the firm, and this will result in increased corporate earnings.

Further calculations may be necessary for this purpose, which will be done from the perspective of the qualitative elements. Because we are offering the same items at a different price or a lower price than our competitors, there is a possibility that this may cause problems in the market. As a result, we must guarantee that the product is offered under a new brand name and in different packaging and that it has been sold in a completely different market. Because of this, product differentiation must have been completed, in addition to market differentiation, which is necessary. The difference pricing will cause issues in the future if it is not addressed immediately.

Also necessary is the exploration of different markets to increase sales at a higher profit margin. This is one of the other things that must be done. The management team must also strive to bring the variable costs down as much as possible. As a result, these are the extra conditions that will be required before the bids may be accepted.

Reference list

Albanese, C., Crépey, S., Hoskinson, R. and Saadeddine, B., 2021. XVA analysis from the balance sheet. Quantitative finance21(1), pp.99-123.

Husain, T. and Sunardi, N., 2020. Firm’s Value Prediction Based on Profitability Ratios and Dividend Policy. Finance & Economics Review2(2), pp.13-26.

Myšková, R. and Hájek, P., 2017. Comprehensive assessment of firm financial performance using financial ratios and linguistic analysis of annual reports. Journal of International Studies, 10(4), pp. 15-30. 

Simamora, R.A. and Hendarjatno, H., 2019. The effects of audit client tenure, audit lag, opinion shopping, liquidity ratio, and leverage to the going concern audit opinion. Asian Journal of Accounting Research.4(1),PP. 13-40. 

Suzuki, D., 2019. Stock and flow in accounting. Balance sheet and income statement approaches. AMIS IAAER 2019, p.354.

Horal, L., Shyiko, V. and Yaroshenko, O., 2019, September. Modeling break-even zone using the integral methods. In 6th International Conference on Strategies, Models and Technologies of Economic Systems Management (SMTESM 2019) (pp. 172-176). Atlantis Press.