This week you will determine the profitability of a project by determining it’s NPV and IRR. Calculate the IRR and NPV as you did last week in your spreadsheet with new numbers. You do not need to turn in the spreadsheet, though you can include a screenshot in your PPT. You must include the updated results of last week’s IP. If you did not have them correct, refer to your feedback. You must come to the correct conclusion in slide #8.Apix is considering coffee packaging as an additional diversification to its product line. Here’s information regarding the coffee packaging project:Initial investment outlay of $40 million, consisting of $35 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal yearProject and equipment life: 5 yearsSales: $27 million per year for five yearsAssume gross margin of 50% (exclusive of depreciation)Depreciation: Straight-line for tax purposesSelling, general, and administrative expenses: 10% of salesTax rate: 35%Assume a WACC of 10%.Week 5 Individual Project assignment:Should the coffee packaging project be accepted? Why or why not? Compute the project’s IRR and NPV.In addition, answer the following questions:— Do you believe that there was sufficient financial information to make a solid decision on what to do?— Was there further financial information that you required that was not provided to you?— What financial figure do you believe was the determinant to your decision and why?— How would you be able to apply this particular financial information to other situations?— Discuss risk methodologies used in capital budgeting.Individual Project assignment due WednesdaySubmit a PowerPoint presentation of 6-12 slides.Speaker notes of 150 words minimum per slideOrganize your slides as follows:Slide 1: Titles.Slide 2: Overview of Apix. Summary of company's assets, total profit, cash flow from operating activities, cash flow from investing and financing.Slide 3: Summary of last week’s expansion project. Provide previous spreadsheet results. Discuss them.Slide 4: Provide your new NPV and IRR calculations and results for the coffee packaging project. Discuss what has changed.Slide 5: Do you believe that there was sufficient financial information to make a solid decision on what to do? Was there further financial information that you required that was not provided to you? What financial figure do you believe was the determinant to your decision and why?Slide 6: How would you be able to apply this particular financial information to other situations? Discuss risk methodologies that are used in evaluating capital budgeting.Slide 7: What is the biggest risk for the company, and what can be done to minimize the risk?Slide 8: Summary: Make a recommendation. Should the coffee packaging project be accepted as an additional diversification to its product line? Why or why not?Slide 9: References.ATTACHMENTS20201104134508npv_irr_assignment__1__unit_5_corrected_formula.xls

CompetenciesConstruct a framework for identifying, evaluating, and categorizing risk and risk management tools.Appraise the relationship between a heightened regulatory environment and corporate governance.Evaluate the components of operational risk and the application of corresponding risk management plans.Evaluate the principles of risk and reward in the investment sector and its applications to the broader area of risk management.ScenarioLTD Acceptance is a private property and auto insurance carrier that specializes in sports cars and motorcycles. This organization is owned by LTD Capital, a large equity group with over 15 holdings. LTD Acceptance is the parent company's single largest holding as it drives 70% of total revenue. Due to the inherent risk involved in that segment of the market, many of LTD Acceptance's competitors do not offer policies for sports cars or motorcycles. This market segment is underserved which is why the organization has 20,000 active policies for a sports car or a motorcycle.LTD is headquartered in Houston, TX. LTD does not sell insurance directly to the public. Instead, it uses third-party agents to sell its policies. LTD handles all customer service needs including claims intake, policy services, and general questions. The company operates in four states: California, Texas, Louisiana, and Florida. Currently, LTD does not have an active system in place to ensure that its agents are in fact using LTD guidelines to screen potential policyholders. However, no evidence of negligence has emerged so far as the organization has yet to have a year in which it was not profitable. LTD has also had the good fortune of not suffering losses because of natural disasters or catastrophic events.InstructionsYou have been hired for the role of Senior Risk Analyst. This means that you are responsible for overseeing and managing the organization's all risk management activities. Before you can design a plan to manage risks, your first task is to identify the primary risk exposures the organization should acknowledge. The organization is also concerned about threats to its operational efficacy. Therefore, you need to also identify operational risk exposures and explain why operational losses must be categorized. The board is also seeking your input on the relationship between risk and reward and how it pertains to the company's investment portfolio. Your supervisor has asked you to create a PowerPoint presentation of your report. Remember your audience when crafting your presentation, and include the following slides:Title slideEvaluate the significance of identifying risks and address the ramifications of failing to do so.Identify two insurance regulations and analyze their roles in managing risks within the insurance industry.Identify the market, business, and compliance risks LTD encounters.Explain why the operational losses cannot be broadly managed. Why do they have to be categorized?Examine the relationship between risk and reward and how it pertains to investing.Explain why effective financial management correlates with risk management.Your conclusion slide should include at least three risk management activities relevant to insurance (and your rationale for choosing them specifically) and how they link to enhanced organizational effectiveness.FFCBA01234Not SubmittedNo PassCompetenceProficiencyMasteryNot SubmittedAt least one slide requirement is missing.All required slides are included.All required slides are included along with any supporting explanations or examples.All required slides are included along with any supporting explanations or examples and are professionally presented.Not SubmittedInaccurate discussion on the importance of identifying risks is included OR no discussion on the importance of identifying risks is included OR appropriate consequences of failing to identify risks are not included.Accurate discussion on the importance of identifying risks is included AND appropriate consequences of failing to identify each risk mentioned are included.Accurate discussion that utilizes specific examples of the importance of identifying risks is included AND appropriate consequences of failing to identify each risk mentioned are included.Thorough and accurate discussion that utilizes specific examples of the importance of identifying risks is included AND appropriate consequences of failing to identify each risk mentioned are fully explained.Not SubmittedLess than two insurance regulations are accurately analyzed in their role in managing risk in the insurance industry.Two insurance regulations are accurately analyzed in their role in managing risk in the insurance industry.Two insurance regulations are thoroughly and accurately analyzed in their role in managing risk in the insurance industry.More than two insurance regulations are thoroughly and accurately analyzed in their role in managing risk in the insurance industry.Not SubmittedNo valid risks are identified for at least one area (market, compliance, and business).At least one valid risk is identified for each area (market, compliance, and business).At least one valid risk is identified and explained for each area (market, compliance, and business).More than one valid risk is identified and explained for each area (market, compliance, and business).Not SubmittedInaccurate discussion of why operational losses must be categorized is included OR no discussion of why operational losses must be categorized is included.Accurate discussion of why operational losses must be categorized is included.Accurate discussion that utilizes specific examples of why operational losses must be categorized is included.Thorough and accurate discussion that utilizes specific examples of why operational losses must be categorized is included.Not SubmittedInaccurate discussion of how the relationship between risk and reward relates to investing is included OR no discussion of how the relationship between risk and reward relates to investing is included.Accurate discussion of how the relationship between risk and reward relates to investing.Accurate discussion that utilizes specific examples of how the relationship between risk and reward relates to investing.Thorough and accurate discussion that utilizes specific examples of how the relationship between risk and reward relates to investingNot SubmittedInaccurate discussion that utilizes specific examples to explain how effective financial management correlates with risk management OR no discussion to explain how effective financial management correlates with risk management.Accurate discussion that utilizes specific examples to explain how effective financial management correlates with risk management.Accurate discussion that utilizes specific examples to explain how effective financial management correlates with risk management.Thorough and accurate discussion that utilizes specific examples to explain how effective financial management correlates with risk management.Not SubmittedConclusion slide(s) does not summarize at least three pertinent risk management activities OR does not describe how at least one affects organizational effectiveness.Conclusion slide(s) summarizes at least three pertinent risk management activities AND describes how each affects organizational effectiveness.Conclusion slide(s) thoroughly summarizes the details of at least three pertinent risk management activities AND describes how each affects organizational effectiveness.Conclusion slide(s) thoroughly summarizes the details of more than three pertinent risk management activities AND provides deep and meaningful insight on the how each affects organizational effectiveness.