The attached document describes a problem in which I need answered in an excel format. The company I am comparing against is Pfizer.

The Company that I am currently using for this assignment is Pfizer. I need the below example answered in an excel format. Please help!! Part VI: Capital Budgeting Analysis, Capital Structure Analysis and Funding Growth Strategies, and Bibliography and Data Capital Budgeting Analysis (30 points): You have been asked to evaluate a potential acquisition of a smaller privately owned competitor. The acquisition candidate produces an EBITDA of 10% of your current EBITDA and is offered to your firm at a price of multiple of 8 times EBITDA. Assume the following: Current debt costs you 8% and you can raise additional debt at this rate today. The loan is to be amortized over 7 years. o Current return on equity is 15% o o Current WACC is 10% o Tax rate is 30% (constant) 80% of the purchase price is considered depreciable assets - to be depreciated over ten years on a straight-line basis with no residual values. o Residual value for this operation is to be 2x current EBITDA in year ten. o Create an after-tax cash flow analysis to answer the following: o Economic analysis: is this a fundamentally sound investment? Using the tax cash flows and no debt (pure equity), is the prospect a positive NPV using ROE as the hurdle rate? o Using the after tax cash flows and the firm's WACC, is this project desirable? Explain how you came to this conclusion. o Capital Structure Analysis and Funding Growth Strategies (80 points): Imagine your firm has some attractive investment opportunities that it is considering. The capital budgeting process has been completed and found that these projects have a positive NPV and are desirable. The firm must raise financing for the projects in the amount equal to 5% of the current level of its total assets. As you know, these funds can come from a number of sources: operations, short-term debt, long-term debt (new bond issues), or equity (new stock issues). Your task is to decide where funds for these projects should come from based on your knowledge of the firm and your knowledge of the current state of the economy (i.e., level of interest rates, state of the stock market, future prospects for the economy/firm). This section is worth 80 points. Your analysis should answer the following questions: 1. 2. o o o o o How much must your firm raise for the investments to be undertaken? U2. How will you determine where the funds should come from? Provide analysis for the following areas: Current capital structure of the firm, specifically, you must cite how some of the ratios you calculated in Part II will influence your decision. Federal Reserve policy and interest rates, meaning what are current borrowing interest rates and what direction do you believe these will trend in the near future? Stock price and state of the stock market, meaning are current stock prices high? Low? How could a firm's financing choice(s) be impacted? Working capital policy Profit/loss situation and operating cash flows