Photo AI

Using the data in Extract F, calculate the difference in the payback period compared to the Chief Executive’s target - Edexcel - A-Level Business - Question 2 - 2022 - Paper 2

Question icon

Question 2

Using-the-data-in-Extract-F,-calculate-the-difference-in-the-payback-period-compared-to-the-Chief-Executive’s-target-Edexcel-A-Level Business-Question 2-2022-Paper 2.png

Using the data in Extract F, calculate the difference in the payback period compared to the Chief Executive’s target. You are advised to show your working.

Worked Solution & Example Answer:Using the data in Extract F, calculate the difference in the payback period compared to the Chief Executive’s target - Edexcel - A-Level Business - Question 2 - 2022 - Paper 2

Step 1

Calculation of Total Cash-Flow for 3 Years

96%

114 rated

Answer

The net cash-flow for each year is as follows:

  • Year 1: £200,000
  • Year 2: £200,000
  • Year 3: £200,000

To calculate the total cash-flow for the first 3 years, we sum these values:

200,000+200,000+200,000=600,000200,000 + 200,000 + 200,000 = 600,000

Thus, the total cash-flow for 3 years is £600,000.

Step 2

Calculation of Payback Period

99%

104 rated

Answer

The initial investment for the new bathroom division is £700,000. To find the payback period, we need to determine how long it will take to recuperate this investment:

After 3 years, the cash received is £600,000. Therefore, the remaining amount to recover is:

700,000600,000=100,000700,000 - 600,000 = 100,000

Now, we need to calculate how long it will take to recover this remaining amount using the cash-flow from Year 4, which is £200,000. Thus, the payback period beyond the third year can be calculated as follows:

Additional time required=100,000200,000×12months=6months\text{Additional time required} = \frac{100,000}{200,000} \times 12 months = 6 months

This means the total payback period is 3 years and 6 months.

Step 3

Difference in Payback Period

96%

101 rated

Answer

The Chief Executive’s target was a payback period of 3 years. Based on our calculations, the project will take 3 years and 6 months to pay back the investment. Therefore, the difference is:

3 years 6 months - 3 years = 6 months longer than the target.

Join the A-Level students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;