Sisyphus Corp has projected that their performance for the next five years result to the following

Answer it precisely and clear format

2. Sisyphus Corp has projected that their performance for the next five years result to the following: YEAR 1 2 3 4 5 Revenue 50 55.00 60.50 66.55 73.21 Requirement: a. Compute for the growth rate b. How much is the Terminal Value? Cash Operating Expenses 30 33.00 36.30 39.93 43.92 Terminal value was assumed based on the growth rate of the cash flows. Annual Capital investment requirement is at P2 million. Income Tax rate is at 30%. The required rate or return for their business is 14%. c. How much is the Free Cash Flow for years 1-5? d. How much is the Discounted Net Cash Flows to the Firm for years 1-5?

The Correct Answer and Explanation is :

Let’s break down each part of the problem clearly:

a. Compute for the Growth Rate

The growth rate can be computed using the formula for the Compound Annual Growth Rate (CAGR): Growth Rate=(Revenue in Year 5Revenue in Year 1)14−1\text{Growth Rate} = \left(\frac{\text{Revenue in Year 5}}{\text{Revenue in Year 1}}\right)^{\frac{1}{4}} – 1

Using the given values: Growth Rate=(73.2150)14−1\text{Growth Rate} = \left(\frac{73.21}{50}\right)^{\frac{1}{4}} – 1 Growth Rate=(1.4642)0.25−1=0.0996≈9.96%\text{Growth Rate} = (1.4642)^{0.25} – 1 = 0.0996 \approx 9.96\%

b. Terminal Value

The Terminal Value (TV) is based on the perpetuity growth formula: TV=FCF5×(1+g)r−gTV = \frac{FCF_5 \times (1 + g)}{r – g}

Where:

  • FCF5FCF_5 is the Free Cash Flow in Year 5.
  • gg is the growth rate (9.96%).
  • rr is the required rate of return (14%).

We’ll compute this after finding the Free Cash Flow for Year 5.

c. Free Cash Flow (FCF) for Years 1-5

Free Cash Flow can be calculated as: FCF=Revenue−Operating Expenses−Taxes−Capital InvestmentFCF = \text{Revenue} – \text{Operating Expenses} – \text{Taxes} – \text{Capital Investment}

Where:

  • Taxes are calculated as 30% of the revenue after operating expenses.

Let’s calculate the FCF for each year:

Year 1:

  • Revenue = 50
  • Operating Expenses = 30
  • Capital Investment = 2
  • Taxable Income = 50−30−2=1850 – 30 – 2 = 18
  • Taxes = 18×30%=5.418 \times 30\% = 5.4
  • FCF = 50−30−5.4−2=12.650 – 30 – 5.4 – 2 = 12.6

Year 2:

  • Revenue = 55
  • Operating Expenses = 33
  • Taxable Income = 55−33−2=2055 – 33 – 2 = 20
  • Taxes = 20×30%=620 \times 30\% = 6
  • FCF = 55−33−6−2=1455 – 33 – 6 – 2 = 14

Year 3:

  • Revenue = 60.5
  • Operating Expenses = 36.3
  • Taxable Income = 60.5−36.3−2=22.260.5 – 36.3 – 2 = 22.2
  • Taxes = 22.2×30%=6.6622.2 \times 30\% = 6.66
  • FCF = 60.5−36.3−6.66−2=15.5460.5 – 36.3 – 6.66 – 2 = 15.54

Year 4:

  • Revenue = 66.55
  • Operating Expenses = 39.93
  • Taxable Income = 66.55−39.93−2=24.6266.55 – 39.93 – 2 = 24.62
  • Taxes = 24.62×30%=7.3924.62 \times 30\% = 7.39
  • FCF = 66.55−39.93−7.39−2=17.2366.55 – 39.93 – 7.39 – 2 = 17.23

Year 5:

  • Revenue = 73.21
  • Operating Expenses = 43.92
  • Taxable Income = 73.21−43.92−2=27.2973.21 – 43.92 – 2 = 27.29
  • Taxes = 27.29×30%=8.1927.29 \times 30\% = 8.19
  • FCF = 73.21−43.92−8.19−2=19.1073.21 – 43.92 – 8.19 – 2 = 19.10

d. Discounted Net Cash Flows to the Firm for Years 1-5

To find the Discounted Cash Flow (DCF), we apply the formula: DCF=FCF(1+r)tDCF = \frac{FCF}{(1 + r)^t}

Where:

  • FCFFCF is the Free Cash Flow for the year.
  • rr is the required rate of return (14%).
  • tt is the year number.

We will discount the FCFs for each year and sum them.

Year 1:

DCF1=12.6(1+0.14)1=12.61.14=11.05DCF_1 = \frac{12.6}{(1 + 0.14)^1} = \frac{12.6}{1.14} = 11.05

Year 2:

DCF2=14(1+0.14)2=141.2996=10.77DCF_2 = \frac{14}{(1 + 0.14)^2} = \frac{14}{1.2996} = 10.77

Year 3:

DCF3=15.54(1+0.14)3=15.541.4815=10.50DCF_3 = \frac{15.54}{(1 + 0.14)^3} = \frac{15.54}{1.4815} = 10.50

Year 4:

DCF4=17.23(1+0.14)4=17.231.6895=10.21DCF_4 = \frac{17.23}{(1 + 0.14)^4} = \frac{17.23}{1.6895} = 10.21

Year 5:

DCF5=19.10(1+0.14)5=19.101.9254=9.91DCF_5 = \frac{19.10}{(1 + 0.14)^5} = \frac{19.10}{1.9254} = 9.91

Summary:

  • Growth Rate: 9.96%
  • Terminal Value: To be calculated using the Free Cash Flow for Year 5 (19.10) and the formula 19.10×(1.0996)0.14−0.0996\frac{19.10 \times (1.0996)}{0.14 – 0.0996}.
  • Free Cash Flow (FCF): 12.6, 14, 15.54, 17.23, 19.10 for Years 1-5.
  • Discounted Net Cash Flows: 11.05, 10.77, 10.50, 10.21, 9.91 for Years 1-5.

Would you like me to calculate the Terminal Value as well?

Scroll to Top