Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

Pro Forma Analysis

 

Proforma Assignment

Submit Here

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:

  1. 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. 
  2. 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.
  3. 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. 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Order Now

Related Questions

ACC 5301 IV A

2 Management Applications of Accounting ACC 5301 Unit IV Assignment This assignment measures your mastery of ULOs 1.1, 1.2, and 5.1. Assignment Objective: For this assignment, you will research and compare international and U.S. accounting standards. This will enable you to see how the different reporting methods affect business and

HRM 6303 V DB

2 Training and Development HRM 6303 Unit V DB Initial post to be a minimum of 500 words in length and at least one supporting reference. How has culture influenced your experience in a learning environment? Can you share any examples?

truckers of europe 3 mod ios

 The MOD version removes all limits, allowing you to instantly upgrade your garage, buy top-tier European trucks, and customize them easily. Whether you want to drive across highways, transport cargo, or explore new routes, the MOD gives you everything from the start. The physics in the game feels real, with

Healthcare Outreach Activities

Discuss one of the public healthcare agencies or organizations in your community and their community outreach efforts. Consider questions such as: How do they reach people? Whom do they partner with? Who funds them? What programs do they provide and whom do they serve? Support your response with at least

Current Event

Instructions attched 1. Select a Recent Event: ○ Choose a current event (within the last 12 months) that relates to strategic management. This could be a major corporate decision, a significant shift in market dynamics, a merger or acquisition, a strategic partnership, etc. 2. Research the Event: ○ Gather information

econ

Instructions and reading attached.  Answer the following questions. 1. What issue or issues were in conflict in the 2022 nationwide rail negotiations? Ultimately, Congress and President Biden imposed a contract settlement on the unions rather than allow the workers to strike. What factors led to this outcome, from your perspective?

wk3 – DLF

>> Your company is planning to undergo a major transformation by moving to a digitized based operation using artificial intelligence or AI and automation to improve service. The transformation has three parts, people, process, and technology. You have been hired as the new division manager to oversee the people part

Mis3

Welcome to week three. This week, your goal is to step outside the building, figuratively or literally, and talk to real users. You’ll use what you learn to synthesize key patterns and insights that will guide your product. Customer discovery is not about confirming your idea. It’s about challenging it.

Im working on a question for BUSN665

quality management plan for BUSN665 attached Hide Assignment Information Turnitin™ This assignment will be submitted to Turnitin™. Instructions Objectives: LO1: The student will understand the role and content of the quality management plan for a project. LO2: The student will be able to develop a Quality Management Plan for a

B1301_2

Need Help with a question. Industry News Post Assignments Instructions and Grading Criteria [Fall 2025] The purpose of these assignments is for each student to write a two-paragraph post discussing a piece of international news regarding their chosen industry – this MUST be one of the eight industries you picked

B1301_1

Need help with a question. Business Principle in a Global Economy Fall 2025 Company Choice Essay plus Bonus Video Presentation with Written Summary Option Assignment Instructions Professor: Assignment Due: 4 pm (CST), Saturday, November 15 (via Turn it in link on CANVAS) Requirements: See format section. Special Notes: Please see

2-1 Discussion: Effective Communications

**** I am looking for someone to help with this class every week***** This is a new assignment   Reflect on your work experience or research recent news articles about organizational communication. Identify a situation where you think an organization or brand may have miscommunicated a message to its employees or

HUM 102 MODULE 4

SEE ATTACHMENTS Unit Resources [Insert Unit Title]8.html Introduction The resources in this module explore how the humanities influence the development of empathy. Required Resources Reading: Catching Feelings for a Triceratops: How Live Theater in Museums Evokes Empathy in Visitors This resource demonstrates how a live performance can transform an audience

IDS -104 MODULE 4

PLEASE SEE ATTACHMENTS Module Four Journal Guidelines and Rubric.html IDS 104 Module Four Journal Guidelines and Rubric Overview In both personal development and professional settings, feedback plays a crucial role in shaping how we perceive ourselves and how we grow. When used effectively, feedback can strengthen a growth mindset, which

Business Finance – Economics HOMEWORK

see attached 7 pages. The questions should be written succinctly, using the proper terminology, appropriate for a graduate level class, and showing all work for questions that call for calculation. And use reference: Brickley, J. A., Smith, C. W., & Zimmerman, J. L. (2021). Managerial economics and organizational architecture (7th