You have a corporate client (you pick a corporation for this assignment) who needs to better...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have a corporate client (you pick a corporation for this assignment) who needs to better understand their cost of capital for their company. You being the genius financial analyst you are, immediately think it would be helpful to calculate the Weighted Average Cost of Capital (WACC) for your client. You know that WACC is a firm's cost of capital where debt and equity (the two types of capital) are proportionately weighted based on their size. You tell your client this and show them the below formula and they immediately spit on the ground in disgust because they hate big formulas. Market Cap MarketCap+Debt WACC= Debt MarketCap+Debt Cost of Equity+ Cost of Debt (1-CorpTax Rate) Since your client hates looking at big formulas, you instead propose you build a simple python program to do all the math for them. They liked the idea and stressed the following criteria have to be met with this program: 1. The user can input their own Risk-Free Rate & Expected Market Return 2. The code needs to be easily readable in case they want to make changes 3. The result needs to be listed as a percentage Beyond those 3 criteria, you can take any liberties you want as long as the math works out. Disclaimer: This assignment will not walk you through how to take every step and obtain every variable. This is intentional. We have gone over these concepts in class and there are materials on blackboard to help as well. You are expected to employ a level of problem solving on your own for this assignment. This means if you find any errors when running your program, I expect you to use your materials and search the web to find an answer. Starting Point 1. First, open the DCF Formula Cheat Sheet pdf file attached to the assignment. a. This file breaks down the WACC formula and its contents on page 2 and it can essentially act as your guide to calculating WACC. 2. Next you will open a new file in atom and save it as WACC.py a. Remember the ".py" identifies your file as a python file which is essential to run your program. Steps in Python Once you have your new WACC.py file open, you are ready to start coding. You will need to do the following: 1. Define each variable for your WACC (Market Cap, Cost of Equity, Debt, etc) 2. Utilize the input() function to allow the user to input both the Risk-Free Rate & Expected Market Return 3. Define WACC as a variable by recreating the WACC formula within python (using the variables you just defined). 4. Using the print() function in python, print your WACC a. Make sure you print WACC as a percentage. Hint: there is no percentage datatype in python so the most logical way to do this would be multiplying your WACC by 100, turn it into a string datatype, and add a "%" to that string. You have a corporate client (you pick a corporation for this assignment) who needs to better understand their cost of capital for their company. You being the genius financial analyst you are, immediately think it would be helpful to calculate the Weighted Average Cost of Capital (WACC) for your client. You know that WACC is a firm's cost of capital where debt and equity (the two types of capital) are proportionately weighted based on their size. You tell your client this and show them the below formula and they immediately spit on the ground in disgust because they hate big formulas. Market Cap MarketCap+Debt WACC= Debt MarketCap+Debt Cost of Equity+ Cost of Debt (1-CorpTax Rate) Since your client hates looking at big formulas, you instead propose you build a simple python program to do all the math for them. They liked the idea and stressed the following criteria have to be met with this program: 1. The user can input their own Risk-Free Rate & Expected Market Return 2. The code needs to be easily readable in case they want to make changes 3. The result needs to be listed as a percentage Beyond those 3 criteria, you can take any liberties you want as long as the math works out. Disclaimer: This assignment will not walk you through how to take every step and obtain every variable. This is intentional. We have gone over these concepts in class and there are materials on blackboard to help as well. You are expected to employ a level of problem solving on your own for this assignment. This means if you find any errors when running your program, I expect you to use your materials and search the web to find an answer. Starting Point 1. First, open the DCF Formula Cheat Sheet pdf file attached to the assignment. a. This file breaks down the WACC formula and its contents on page 2 and it can essentially act as your guide to calculating WACC. 2. Next you will open a new file in atom and save it as WACC.py a. Remember the ".py" identifies your file as a python file which is essential to run your program. Steps in Python Once you have your new WACC.py file open, you are ready to start coding. You will need to do the following: 1. Define each variable for your WACC (Market Cap, Cost of Equity, Debt, etc) 2. Utilize the input() function to allow the user to input both the Risk-Free Rate & Expected Market Return 3. Define WACC as a variable by recreating the WACC formula within python (using the variables you just defined). 4. Using the print() function in python, print your WACC a. Make sure you print WACC as a percentage. Hint: there is no percentage datatype in python so the most logical way to do this would be multiplying your WACC by 100, turn it into a string datatype, and add a "%" to that string.
Expert Answer:
Answer rating: 100% (QA)
Step1 Define Variables Start by defining the variables needed for the WACC calculation Market Capita... View the full answer
Related Book For
South Western Federal Taxation 2015 Essentials Of Taxation Individuals And Business Entities
ISBN: 9781285438290
18th Edition
Authors: James Smith, William Raabe, David Maloney, James Young
Posted Date:
Students also viewed these computer network questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
During February, Vargas Company worked on three jobs. Data relating to these three jobs follow: Overhead is assigned on the basis of direct labor hours at a rate of $5.30 per direct labor hour....
-
Draw an AON network using the following data and find the probability of completing the critical path of the operatic project in 44 days, the official openingdate. b-420743342423 3 010531222312...
-
Find a function f satisfying lim x1 (f(x)/x - 1) = 2.
-
A common assumption for biorefinery capacities is \(2000 \mathrm{Mg} /\) day of feedstock input capacity. What is the land area required to grow this quantity of biomass from corn stover with land...
-
Hoschild Bicycle Company manufactures bicycles. The following data for September of the current year are available: Quantity of direct labor used ........ 850 hrs. Actual rate for direct labor...
-
Write functions to perform Depth-First Search (DFS) and Breadth-First Search (BFS) on a graph represented as an adjacency list .
-
Table P-9 contains data on food expenditures, annual income, and family size for a sample of 10 families. a. Construct the correlation matrix for the three variables in Table P-9. Interpret the...
-
An ordinary flashlight is a very complicated instrument if we include the electrochemistry of the battery, the resistance of connections, and the thermodynamics of the bulb. What principles of...
-
Select an information system used by a medium to larger organization. it can be one with which you are personally familiar or one whose organizational structure and information system you have...
-
Which one do you find the most insightful? Why? Under what drcumstanees would its implications not hold?
-
Contact and interview two or three systems analysts, in different organizations if possible, regarding this chapter's subtopic on communication building blocks. a. Describe the nature of each...
-
Select a medium to large organization The organization can be in the public or private sector, and it can be one with which you are personally familiar or one for which information is readily...
-
Who are the industries and firms for which Spotifys new business model is a threat? What is the nature of the threat? How would you go about evaluating it? How can you forecast the impact? What...
-
Sales increased from Year 1 (with sales of 800,000) to Year 2 (with sales of 900,000); The DOL (Degree of Operating Leverage) in Year 1 is 5.0 and EBIT in Year 2 is 81,250. What is the fixed cost? X...
-
On August 31, 2012, the balances of the accounts appearing in the ledger of Wood Interiors Company, a furniture wholesaler, are as follows:Prepare the August 31, 2012, closing entries for Wood...
-
Tom and Gail form Owl Corporation with the following consideration: The installment note has a face amount of $350,000 and was acquired last year from the sale of land held for investment purposes...
-
Platinum, Inc., has determined its taxable income as $215,000 before considering the results of its capital gain or loss transactions. Platinum has a short-term capital loss of $24,000, a long-term...
-
Hyacinth, Inc., is a dealer in securities. The firm has spotted a fast-rising company and would like to buy and hold its stock for investment. The stock is currently selling for $2 per share, and...
-
Determine the differential equations governing the motion of the system by using the equivalent systems method. Use the generalized coordinates shown in Figures P2.52. k FIGURE P 2.52 E x 2k www
-
Determine the differential equations governing the motion of the system by using the equivalent systems method. Use the generalized coordinates shown in Figures P2.53. 2r k ww T m FIGURE P 2.53
-
Determine the differential equations governing the motion of the system by using the equivalent systems method. Use the generalized coordinates shown in Figures P2.54. 3L - C Slender bar of mass m...
Study smarter with the SolutionInn App