Assignment Task

Write a 2500-word report based on the financial scenario and information provided. Conduct a strategic financial analysis using the information provided and the appropriate techniques, tools, and frameworks. Make decisions and recommendations based on the analysis, considering all relevant implications, challenges, and limitations.

Task

This assessment continues from the financial review of TPG undertaken in the First Assessment. Please note that the following case is fictitious and for study purposes only.

At a TPG Board meeting recently held in late May 2024, one of the strategic considerations for revenue growth is the expansion of its 5G network coverage. As the Chief Financial Analyst of the company, you are delegated the task of evaluating the company`s investment proposal to expand its 5G network, which is expected to enhance service quality, increase customer satisfaction, and attract new customers in underserved areas.

You have collected the following information from various departments regarding this new project. The engineering department has estimated that expanding the 5G network will require an initial investment of $1,500,000,000. This includes purchasing spectrum licenses, upgrading existing infrastructure, and installing new 5G towers, with an annual fixed cost of $200,000,000 for staffing, operation, and maintenance. The finance department has forecasted the following three scenarios on market demand and pricing based on historical data:

These estimates reflect all associated revenues/costs and are assumed to be constant for the project`s life (10 years). Ignore the change in working capital. TPG will need to raise additional finance in the form of debt and/or equity to finance the proposed project.

Procedure

As the Chief Financial Analyst of the company, you are required to prepare a report addressing the following questions:

1. Explain the usefulness of cash and accounting break-even points in financial decision making. Calculate the cash and accounting break-even points for the 5G expansion project under each scenario. Considering the number of subscribers over time, which year can the project break even? What do these points reveal about the project`s financial viability? Elaborate your answer by talking to specific numbers in your results and consider the difference between cash and accounting break-even points.

2. Compare and discuss the advantages and disadvantages of the Payback period, Internal Rate of Return (IRR), and Net Present Value (NPV) as investment appraisal tools. Under the pessimistic, normal, and optimistic scenarios, calculate the free cash flows to be generated by the project with the help of the free cash flow template (.xlsx); compute the Payback period, IRR, and NPV. Evaluate the financial attractiveness of the project based on these calculations.

3. Use a payback cut-off period of 6 years to evaluate the payback period and 11% as the discount rate to calculate NPV. Reflecting on this capital budgeting process, what other factors should the company consider when evaluating this project?

4. Using TPG`s debt ratio and ROE ratio and its trend over time from your first assessment, advise how TPG should finance the chosen project (debt versus equity financing). Support your discussion using the finance theories or principles covered in the subject.

5. The current credit policy of TPG is 45 days. The marketing manager of TPG has looked at competitors` credit policies and has determined that the industry standard credit policy is 60 days. He proposed to change the credit policy in line with the industry standard. Discuss the implications of the proposed credit policy on TPG`s working capital cycles (Note: no calculations required).

6. Considering your analysis and findings from the previous questions, provide a set of recommendations to TPG`s board regarding the financial viability of the 5G expansion and the implications of the credit policy change. Include limitations of the analyses conducted.