Internal Rate of Return and (c) Discounted Payback Period. Fifteenth Slide and Sixteenth Slide: Discuss the result and effect of your Budgeting and why you would either recommend or not recommend the project.

I need help with formulas in excel ASAP to get my EBIT to Free Cash Flow, Net Present Value, Internal Rate of Return, and Discounted Payback Period using the WACC 5.21% for Pfizer. I will need to import into a PowerPoint.

Eighth Slide: The calculation determining to determine what amount is 18% of the EBIT of the project. When calculating the TAX component of EBIT use 35%.
Ninth Slide: The Hurdle Rate for this project. Include the URL of the website used to obtain the WACC together with a screen shot of the WACC
Tenth Slide: The Calculations that convert the project’s EBIT to free cash flow for the 12 years of the project.
Eleventh Slide through Fourteenth Slides (possibly more will be required for this part): The Capital Budgeting results for the project show: (a) Net Present Value (b) Internal Rate of Return and (c) Discounted Payback Period.
Fifteenth Slide and Sixteenth Slide: Discuss the result and effect of your Budgeting and why you would either recommend or not recommend the project.

Last Completed Projects