Buy Complete the Analysis Calculation

Buy Complete the Analysis Calculation

Description
tep 4: Complete the Analysis Calculation for Project 5
Your team has provided you with an Excel workbook containing LGI’s financials. You will use the Project 5 Excel workbook to perform advanced capital budgeting techniques to assess the viability of the investment you made in the previous project.

Complete the analysis calculation for the project:

Download the Project 5 Excel Workbook, click the Instructions tab, and read the instructions.
Calculate cost of debt and equity as well as weighted average cost of capital (WACC).
Apply the capital asset pricing model (CAPM).
Develop a capital budget.
If you would like instructor feedback on this step, submit your Excel file to the Assignments folder as a milestone by the end of Week 9. This is optional. If you choose to submit the milestone, you will receive instructor feedback you may use to make corrections before submitting your final Project 5. To distinguish the milestone submission from the file you will submit in Step 5, label your file as follows: P5_milestone_lastname_Calculation_date

You should use the comments your instructor made about your optional milestone submission to revise your calculations as needed. Next, proceed to Step 5, where you will answer questions about your analysis, make recommendations for LGI, and compile and submit your final report.
Project 5: Cost of Capital, Risk/Return, and Capital Budgeting
Step 5: Prepare the Analysis Report for Project 5
A woman displays data in a presentation as participants take notes.PeopleImages / E+ / Getty ImagesYou have developed an in-depth understanding of LGI’s operating efficiency related to costing and how that impacts the bottom line. You feel confident that your investment choices will positively boost LGI’s productivity and improve the company’s operations. Thanks to your efforts, the company will have a plan for financing its investments appropriately. LGI will finally be on a path of a sustainable future. Answer the questions in the Project 5 Questions – Report Template document. Prepare your analysis report including recommendations for how the company can improve its financial situation.Complete the analysis report:
Download the Project 5 Questions – Report Template
Read the instructions.
Answer all the questions.
Include your recommendations.
Submit the analysis report (Word document) and analysis calculation (Excel file) to the dropbox as your final deliverable at the end of Week 10. Label your files as follows:
Project 5: Cost of Capital, Risk/Return, and Capital Budgeting
Step 7: Learning Resource List
LEARNING RESOURCE LIST
Learning Resource List for MBA 620The learning resource list is a complete record of the required and recommended reading for MBA 620. The list is categorized by project and by resource (book).