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

During December of 2018 Payless ShoeSource held a fake advertising campaign by inviting influencers in high fashion to attend the grand opening of

During December of 2018 Payless ShoeSource held a fake advertising campaign by inviting influencers in high fashion to attend the grand opening of “Palessi” – a high end shoe store selling shoes for $200-$650 (shoes from Payless ShoeSource [PSS] shoes that originally sell for $19-$39). Palessi’s grand opening was held

For this assignment, you will participate in a class discussion about the topic of Ethics in Project Management and Society. The assignment consists

For this assignment, you will participate in a class discussion about the topic of Ethics in Project Management and Society. The assignment consists of an initial post and at least two replies to others’. Initial Post Project management principles, performance, and value delivery are essential components of successful project management.

Creating a Measurable Marketing Strategy Across Cultures In your simulation this week, one item that you will be working on

Creating a Measurable Marketing Strategy Across Cultures In your simulation this week, one item that you will be working on is advertising to include ad copy design, and media placement and ad frequency. As you grow past your home headquarters, you will need to create a marketing strategy that: ·

please see attachment for instructions Prompt: Analyze the role of the International Centre for Settlement of Investment Disputes (ICSID) in

please see attachment for instructions Prompt: Analyze the role of the International Centre for Settlement of Investment Disputes (ICSID) in facilitating international business. Discuss the strengths and weaknesses of ICSID as a forum for resolving investment disputes, and consider its impact on the global investment landscape. Potential areas to explore

Due Saturday: 03/30 APA 4 paragraphs 3 sources Top of Form Research the ways compensated absences should be accounted for in governments. Provide

Due Saturday: 03/30 APA 4 paragraphs 3 sources Top of Form Research the ways compensated absences should be accounted for in governments. Provide examples. Bottom of Form

Due Saturday: 03/30 APA 4 paragraphs 3 sources Top of Form What are government bonds and how they are accounted for? Be sure to explain face

Due Saturday: 03/30 APA 4 paragraphs 3 sources Top of Form What are government bonds and how they are accounted for? Be sure to explain face value, premiums and discounts, and issue costs. Provide examples.Bottom of Form

Based on week 1, 2 and 3 that were submitted earlier for PROJ595 · Cover Page: Include your name, the project or company name, and the course name

Based on week 1, 2 and 3 that were submitted earlier for PROJ595 · Cover Page: Include your name, the project or company name, and the course name and number. · Qualitative Risk Analysis: Using a probability and impact matrix or risk register, prioritize the risks for your project. ·

Company Name – GM Motors Part 1: WACC Calculation (In section1 use regression to find BETA) Using concepts learned during the class, estimate the

Company Name – GM Motors Part 1: WACC Calculation (In section1 use regression to find BETA) 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

BUS 210 Module Five Assignment Guidelines and Rubric Overview Imagine that you have been hired as a consultant to investigate the social

BUS 210 Module Five Assignment Guidelines and Rubric Overview Imagine that you have been hired as a consultant to investigate the social responsibility of two companies, TOMS Shoes and Ben & Jerry’s. Your manager finds both of these companies to be inspirational. She would like the SNHU Pet Supply Company

INSTRUCTIONS: Respond to the two following posts for Diamond and Travis.

INSTRUCTIONS: Respond to the two following posts for Diamond and Travis. Led by Love Diamond The segment really brought out a quieter and more reflective side of the journey. Watching Dr. Dave return home and spend time with his family, especially his nieces and nephews reminded me how grounding it

For this skills assessment, we ask you to run a crawl of travelpass.com. You will find that, with the default settings, ScreamingFrog will struggle to

For this skills assessment, we ask you to run a crawl of travelpass.com. You will find that, with the default settings, ScreamingFrog will struggle to complete a crawl. To complete the assessment, we ask that you adjust your settings in ScreamingFrog to allow you to complete a crawl. Be prepared

I need some help! Introduction For decades, daytime wetting and passing bowel movements has been a common problem in early

I need some help! Introduction For decades, daytime wetting and passing bowel movements has been a common problem in early childhood. Today, the need for more structured toilet training before the age of 4 years is a routine practice used to prevent children from having difficulty attaining and maintaining bladder

The current price of ABC stock is $50. The term structure of interest rates (continuously compounded) is flat at 10%. What is the six-month forward

The current price of ABC stock is $50. The term structure of interest rates (continuously compounded) is flat at 10%. What is the six-month forward price of the stock? Denote this as F. The six-month call price at strike F is equal to $8. The six-month put price at strike

This is a women’s gender course Readings/articles to be posted as PDFs to Canvas—Here is an outline of the material we will cover. Module 2:

This is a women’s gender course Readings/articles to be posted as PDFs to Canvas—Here is an outline of the material we will cover. Module 2: Likeability and Success • Acker, J. (1990). Hierarchies, Jobs, Bodies:: A Theory of Gendered Organizations. Gender &Society, 4(2), 139–158. • MacKinnon, Catherine A. 1991. “Reflections

Consider the following crisis scenario and respond to the questions for scenario only. You may consult other sources to obtain more information

Consider the following crisis scenario and respond to the questions for scenario only. You may consult other sources to obtain more information about both the crisis event and the crisis response, but you must reference these. You MUST draw on and cite the theories covered in the unit so

Explain the advantages and disadvantages of bringing in a private management company such as SMG or Global Spectrum to manage a public sport facility

Explain the advantages and disadvantages of bringing in a private management company such as SMG or Global Spectrum to manage a public sport facility. If you were the lead government official in your municipality, would you hire private management or keep the facility under in-house control? Why? As the

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

Go to Personality test based on Jung and Briggs Myers typology (humanmetrics.com)Links to an external site. and take the Myers Briggs

Go to Personality test based on Jung and Briggs Myers typology (humanmetrics.com)Links to an external site. and take the Myers Briggs personality test. Please submit the 4 letters that indicate your MB Personality Type along with a description of each of the letters, using a MS Word document and a memo