Step 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 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 , 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