Our Services

Get 15% Discount on your First Order

Proforma Assignment Submit Here Part 1: WACC Calculation Using concepts learned during the class, estimate the weighted average cost of capital

April 1, 2025

Proforma Assignment

Part 1: WACC Calculation

Using concepts learned during the class, estimate the weighted average cost of capital (WACC) for your company. The process involves several key steps:

Cost of Equity Calculation using CAPM Model:
- Estimate beta for your company using regression analysis. Estimate beta using daily prices for past one year, weekly prices for the past two years, and monthly prices using the past five years. Do you get different beta using three approaches? Why? Which beta is the most appropriate beta for your company? Explain your reasoning in the excel document itself.
- Estimate the cost of equity by employing the Capital Asset Pricing Model (CAPM), factoring in your company’s appropriate beta. Utilize an appropriate risk-free rate and a market risk premium of 6% for your calculation.
Cost of Debt Estimation:
- Estimate the appropriate cost of debt for your company. You can use different approaches to estimate cost of debt.
  - Credit rating and Yield-spreads.
  - If credit rating is missing, find rating of firms in the same industry and similar size.
  - Adjust for expectations of changes in the future interest rates based on your economic analysis.
  - Explain your analysis in the excel document.
Capital Structure Weight Calculation:
- Determine the capital structure weights of equity and debt based on the current market values of equity and debt. This involves calculating the proportion of total capital represented by equity and debt.

By meticulously completing these steps, you’ll arrive at a comprehensive understanding of your company’s WACC, a vital metric used in investment decision-making and capital budgeting.

Part II: Pro-forma statements

Select the appropriate explicit forecast period for your company, ensuring it spans a minimum of 5 years and a maximum of 10 years. Utilize this chosen forecast period to estimate pro forma income statements and balance sheets for your company for the upcoming 5 to 10 years.

Part III: Free cash flow estimation and discounted cash flow valuation

As discussed in class, estimate free cash flow to firm and free cash flow to equity for your company. Using WACC estimates in part-I, estimate fair value of stock using discounted cash flow methodology. Which of the two approaches (FCFE vs FCF) is suitable for your firm? why?

Deliverable: Submit an Excel spreadsheet containing all pertinent details. Format the spreadsheet to enhance clarity and ease of understanding. Explicitly state the basic assumptions underlying your estimates for transparency and coherence. Use your excel to explicitly state your major assumptions and rationale for these assumptions.

This is the assignement given to me. I have completed the first section and a bit of the second section and I want to complete the last section. The company I that I am working on is Oracle Corp for this assignment. I have attached my file and want someone to complete the second section that is pro- forma statements and free cashflow estimation.

>Business & Finance homework help

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

SEE ATTACHMENT 250-300 WORDS ANSWERING THE FOLLOWING QUESTION What is the relationship between planning and control? Give

SEE ATTACHMENT 250-300 WORDS ANSWERING THE FOLLOWING QUESTION What is the relationship between planning and control? Give an example and be creative. Use this as your opportunity to tell one of those funny stories that we all have lurking in our past in which just about everything that could go

The Chosen Business is EGSD (E-GREEN SOCIAL DESIGN) a Business close to Barcelona that is preparing people for the economy 4.0 using industrial 3D

The Chosen Business is EGSD (E-GREEN SOCIAL DESIGN) a Business close to Barcelona that is preparing people for the economy 4.0 using industrial 3D printing in plastics and ceramics, Virtual reality, AI…

Topic: Lululemon 1. Creating scenario (environmental problems- exaggerating about its earth consciousness claims.) 2. Giving

Topic: Lululemon 1. Creating scenario (environmental problems- exaggerating about its earth consciousness claims.) <fake scenario> 2. Giving strategic communication plan

Questions: Research how many people watch the Super Bowl and the respective Commercials. Then, research the expected company Return on Investment for

Questions: Research how many people watch the Super Bowl and the respective Commercials. Then, research the expected company Return on Investment for commercials aired during the game. In your opinion, was there one commercial that stood out as the best or most influential of the bunch? Describe what made it stand out

See attachments, needs to be done in Excel and PPTX 1. Needs to be done in Word and PowerPoint 2. Incremental Analysis and Break-Even Analysis

See attachments, needs to be done in Excel and PPTX 1. Needs to be done in Word and PowerPoint 2. Incremental Analysis and Break-Even Analysis needs to done only Scenario: Your team has been hired to provide financial analysis for a start-up company, Bobble in Style, which produces customized bobble

INFO ATTACHED Overview: For this assignment, you will prepare a written document which describes total product offering.

INFO ATTACHED Overview: For this assignment, you will prepare a written document which describes total product offering. Please follow the instructions below and prepare your document. Be sure to save in .doc or .docx format, and to follow APA guidelines. Instructions: In Module 2, learned about PRODUCT decisions. 1. In

Please see attachment for instructions. Pre-simulation Reflections (5 points) This is a separate reflection assignment,

Please see attachment for instructions. Pre-simulation Reflections (5 points) This is a separate reflection assignment, not part of today’s midterm. These questions are designed to help you explore your own perspectives. There are no ‘right’ or ‘wrong’ answers and you do not need to align with any specific viewpoint. Instead,

See attached Assignment Instructions: Please respond to each of the mini case studies with a

See attached Assignment Instructions: Please respond to each of the mini case studies with a 2-3 page explanation for each mini case study. You should use at least 4-5 resources in each case to support your position. Please make sure to review the associated rubric before you begin this assignment

task is to develop three newsworthy story ideas for student media (e.g. Honi Soit, Salience) in response to the BRIEF provided and using the story

task is to develop three newsworthy story ideas for student media (e.g. Honi Soit, Salience) in response to the BRIEF provided and using the story idea template provided. Your responses should be direct and concise: 1. A news story idea based on first-hand observation (An event you attended, something

SEE ATTACHMENT 250-300 WORD ANSWERING THE FOLLOWING QUESTIONS Tell me a little about an organization that you research. Pick

SEE ATTACHMENT 250-300 WORD ANSWERING THE FOLLOWING QUESTIONS Tell me a little about an organization that you research. Pick any organization that is a publicly trade company (Example, AMZN, NVDA, KO etc). What is its organizational structure? (You will have to do research for this weeks board). What are the

See attached PRESENTATION Comprise a presentation using PowerPoint presentation software that includes 16-20 (do not

See attached PRESENTATION Comprise a presentation using PowerPoint presentation software that includes 16-20 (do not exceed 20), include audio and, ALL of the following points: · Examine how key managers act to enhance efficiency and effectiveness in an organization. · Examine management of human capital and how it supports strategic

1). Self- Reflection. Practice involves self-reflection and checking for bias to ensure your design and topic will withstand robust scrutiny from

1). Self- Reflection. Practice involves self-reflection and checking for bias to ensure your design and topic will withstand robust scrutiny from peers and academics. A strong research effort minimizes bias and presents alternative and opposing perspectives, including issues concerning methodology. Bias creates errors in research and can take the

please see attached Doctoral_ Research .Topic Please provide some information about your doctoral research interests. Be concise and limit your

please see attached Doctoral_ Research .Topic Please provide some information about your doctoral research interests. Be concise and limit your responses to the space provided. This information will be used to help select an appropriate chair for your committee who can best guide you in your doctoral research journey. Name:

5.2 Assignment: Capstone Completion/Comprehensive Report Getting Started You have your Synthesis Paper and now you are in

5.2 Assignment: Capstone Completion/Comprehensive Report Getting Started You have your Synthesis Paper and now you are in the final stages of completing your Capstone Project. There is much to rejoice about and look forward to as you come to the end of implementing the major projects in this course. Upon

3.2 Discussion: Capstone Project Implementation Getting Started You are in the midst of your Capstone Project implementation.

3.2 Discussion: Capstone Project Implementation Getting Started You are in the midst of your Capstone Project implementation. Stay focused, enjoy the process, anticipate roadblocks, share your successes and failures, and support and pray for one another through the next few weeks. Upon successful completion of this discussion, you will be

First, read the case Money and Credit on the American Frontier . Additional

First, read the case Money and Credit on the American Frontier . Additional readings (not required, but recommended by the case study’s author) · Michener, R. (2011, January 13). Money in the American colonies. Retrieved from · Schweikart, L. (2001, January 1). The non-existent frontier bank robbery. Retrieved from

Your resources will be chosen from course resources as well as outside resources in support of your topic. Your literature review will provide: A

Your resources will be chosen from course resources as well as outside resources in support of your topic. Your literature review will provide: A minimum of three resources.

I need to wite a report for my International Marketing class about the United Arab Emirates, I attached all the instructions. I also provided 10

I need to wite a report for my International Marketing class about the United Arab Emirates, I attached all the instructions. I also provided 10 resources from the William Carey Library, but you can find different ones that adjust better to the report, the only requierements is that the have