I need help with part of a project. I have attached the prompt with the full details of the project.

The company we chose is BestBuy.

For my part, I need todetermine/calculatethe cost of debt, cost of preferred stock, and cost of common equity for Best Buy (BBY). I also need to show the work with Excel calculation backups.

Any help would be greatly appreciated.

Thanks!

FINU 607 Team project Assigned Class 3- Due at Midnight on Wednesday Week 8 150 Points Topic: Cost of Capital, Capital Structure, and Capital Budgeting Analysis In this project, you are supposed to be a financial manager working for a big corporation and you have to apply the knowledge obtained from the our Finance 607 course to determine the cost of debt, cost of preferred stock, cost of common equity, capital structure, and the weighted average cost of capital (WACC) for a publicly-traded company of your choice. A. Choosing a Company and Team: Please form your own teams and then choose a publically US traded company. (hint: try finance.yahoo.com ) . B. Obtain approval from the instructor for your specific stock, before working on this project- post on the Team Discussion board and email the instructor to verify that you were awarded that company/stock to analyze. Be sure to thoroughly understand the company. The purpose of this assignment is for the team to utilize many of the concepts presented in the text to analysis the company you pick. Group Discussion Threads for each Team will be reviewed for individual participation. What to include in the PowerPoint: 1. Business Overview and Strategy: Briefly describe the company, its Mission, Vision, location and products, give a little bit about it 's industry, and discuss its strategy for success. Refer especially to business description and risk factors of your company. MAXIMIUM of 2 slides. 2. Then determine the cost of debt, cost of preferred stock, cost of common equity, capital structure, and the weighted average cost of capital (WACC) for your assigned publicly-traded company (see above). 3. Develop this (item #2) into a PowerPoint where you explain how you calculated those numbers (if you want to include an Excel spreadsheet along with the PowerPoint , that is fine. ) and what was your reasoning. 4. Include in the Appendix to the PowerPoint , the financial statements you used or other documents to get those numbers. 5. You will use the WACC as the discount rate to conduct capital budgeting analysis for a project that the firm is considering and then decide whether it should be accepted or not which is \" Building a new Building\" for $1 million. If you do not have a number you need, research it and state your assumptions that you used to get the missing number. Teams are to prepare a Power Point presentation consisting of a minimum of 10 but no more that 20 slides (or other media) . An Excel spreadsheet might also be plus to help the instructor understanf your numbers. See Presentation Guidelines (next). This will be uploaded to Blackboard. Deliverables: Power Point: Any citations must use APA. No more than 4 bullets per page. Should be color coordinated, creative, professional and easy to read. Give details of the Company, explain how you go the requested numbers. Include an appendix of the financial data you used such as the 10-K or other financials. Please remember to include as your last page all APA references you used. Presentation Guidelines (for Individual and Team Presentations) Be sure you have an introduction, an analysis and a conclusion even though this is a presentation and not a paper. The following describes how presentations will be graded. The questions and comments below are designed for you to read and consider before you finalize your presentation. Use APA in your Power Points and cite your sources and Wikipedia is still not a source. You need to compare and contrast your research to the three texts in the course and have at least three citations. Remember: This is designed to be a team project. Any member who does not contribute to the project is to not have their name on the Power Point or the Handout, nor are they to present. Each team member will evaluate their other team members at the end by emailing their team members participation to the instructor. . Your presentations will answer the following issues (not necessarily in this order). Does your presentation answer each of the questions assigned with your company? (Your audience will be checking of a list!) Does your handout look professional (is it one page, APA, referenced, and interesting to the eye?) Does each member of your team have a part in the presentation? Is each of you listening when your team mates are presenting (if in class)? Are you using active listening when other teams are presenting (if in class)? Think deeply about not giving a book report - but offering new and interesting information on how your assigned company connects with the material we have covered in class (discussions and the three texts). Does your presentation have a clear beginning, middle and end? Introduction (10%) Does the introduction explain what the presentation is about? Does it give a quick overview of your main points? It is creative? Is it interesting? Do you have a hypothesis? Analysis (50%) Does the presentation have three to five main points that are supported by references in the text with page numbers of analyzing all of the questions that were given to you with the organization? Does the analyses connect to your introduction and conclusion and the \"heart of you hypothesis? Conclusion (20%) Is the conclusion a clear and concise recap of the analysis? The conclusion can not bring in any new ideas! Does the conclusion tie into the first two or three sentences in thought? Do you explain one more time your hypothesis? Process, Punctuation and Grammar (20%) Are all of the words on the Power Point spelled correctly? Are the correct words used? Is the wording smooth to read and flow from point to point? Is proper grammar used? Does the handout follow APA Guidelines? Is the presentation and the handout interesting? Did you leave room for questions? Did you know your audience? Did you keep your audience entertained? Evaluation Criteria for: Presentations Elements of PowerPoint PresentationTeam Project, 150 points WD Dev NSW \"A\" 150 to135 Points \"B\" 134 to 120 Points \"C or lower\" 119 to 105 Points or lower Introduction (10%) Provides an interesting introduction to the work. Clearly states the purpose of the work. Provides a somewhat clear introduction to the work. Somewhat explains the three to five main points of analysis Provides no clear direction for the paper. Does not explain the three to five main points of analysis to follow. Analysis (50%) Clearly and fully states the problem and the recommendation. Makes a clear recommendation for the future. Connects to concepts presented in the texts and class discussion. Energizes the audience. Somewhat describes the problem and the recommendation. Makes an unclear recommendation. (Or may leave one or two of these out). And somewhat connects this to the research, and the texts. Somewhat engages the audience. Provides no real clarity or recommendation. Does not make a clear recommendation or show how this connects to the research, text. Does not engage the audience. Conclusion (20%) Connects to the introduction in an interesting way. Is short and encompasses all of the main points in the paper. Brings in new ideas that are not highlighted in the Power Point. Somewhat connects with the introduction and the analysis sections of the paper. Brings in new ideas that are not highlighted in the Power Point. Does not connect with the introduction and analysis sections of the paper. Grammar, Speech Patterns, Punctuation and APA (20%) Clearly uses proper grammar, APA for in text citations and for all references. The paper Has more than three errors in APA, grammar and or punctuation. Has too many \"um's\" or Has more than four errors in APA, grammar and or punctuation. is interesting and easy to read. N S W = Needs Significant Work \"ah's\" D = Developing Is riddled with \"Um's\" and \"ah's\" or speech patterns that are distracting. WD = Well Developed