80.2K

Verified Solution

Link Copied!

I have problems with the end of this Excel exercices, if anyone can help me to finish it it will be nice.

Congratulations on your internship assignment in the Corporate Finance department of CorpFinCo. The CFO has placed you on an inter-departmental team of executives from around the company. Your team's task is to analyze potential areas of new investment - product areas, mergers and acquisitions, etc. In this case, you'll be analyzing the possibility of expanding your product line into a radical new area. It's a potentially game-changing move for a company as established as CorpFinCo. Your job on the inter-departmental team is to talk to your colleagues, gather the project information they have developed, and to interact with your own Finance Department. Ultimately, you will use all these inputs to construct a pro-forma discounted cash flow model (DCF) as the basis for the team's recommendation to senior management. Marketing Your colleagues in the Marketing Department have done extensive consumer and competitor research. In addition, they've worked closely with the sales team to incorporate their reactions and recommendations. Based on this process, Marketing has provided you with the following estimates: Engineering The Engineering Department has gone through very intense prototyping exercises, as well as working with vendors and factory floor workers to get very precise cost estimates for the new product line. They provide their estimates below: 1 Calculate WACC (after- tax, of course) by calculating necessary components and using relevant capital structure information. Which Beta are you using and why? from the "WACC tab. In this cell, type "=" and then naivgate to the WACC tab and link to your answer for WACC. NPV Long Form Annual Cas (1239241)$(1231848)$ (1 228 104) \$ (1 216 524) (1206317)$(1187561)$ (1169316)$ (1 164 790) Discount each CF as a FV : CFn/(1+WACC )n Make a recommendation on whether the company should pursue this project

Answer & Explanation Solved by verified expert

See Answer