investment opportunities

Question description

This Assessment includes 6 parts, each related to a different case scenario. For each scenario, you will assume an important role with a fictional company and analyze various aspects of that company using accounting tools and measures. Parts I, II, IV, and V require you to make calculations using spreadsheet software such as Excel. Part III, requires you to analyze various types of centers for a specific company. Part VI requires you to analyze data presented in the accompanying project documents and make decisions based on that data. Access the IG009 Assessment Scenarios document provided with this Assessment and analyze the appropriate scenario for each part.

PART I: PERFORMANCE REPORT AND VARIANCES

Access Part I of the IG009 Assessment Scenarios document. Honey Bear Confections (HBC) is a small organization dedicated to making bear-shaped sweets with honey as a sugar substitute. You have just been promoted to the position of manager of the production department at HBC when your supervisor shows you a static budget report. She tells you to “get it fixed.” You suspect she is alluding to a problem with productivity and efficiency. Review the “HBC Static Budget Report,” and then prepare a performance report using spreadsheet software, such as Excel.

PART II: MAKING INVESTMENT DECISIONS USING NPV, ARR, IRR, AND PAYBACK

Access Part II of the IG009 Assessment Scenarios document. As the new product development manager, you are considering investment proposals for two mutually exclusive investment opportunities. The two proposals must be evaluated using net present value (NPV), accounting rate of return (ARR), internal rate of return (IRR), and payback. Review the cash flow information in the “Investments” section of the Assessment Scenarios document, and then analyze the investment proposals using Excel or another spreadsheet software to calculate NPV, ARR, IRR, and payback. Write a report that presents your findings (1–2 pages).