Reference no: EM132207846
Assignment -
It is January 1st, 2018. You are a Senior Analyst at Canada Hardware Inc. (CHI), one of the top hardware, sports, and apparel providers in Canada with hundreds of stores across Canada. The CEO of Canada Hardware, Tony Stark, has reached out to you to draft a report to evaluate two investment proposals, building on your analysis.
Purpose - For this case approach, you will demonstrate your ability to develop costing methods and a set of forecasts of future cash flows for two proposed investment projects. You will also be required to identify the cost of financing through the issuance of bonds.
How to Proceed - Building on your analysis and proposal, develop your investment proposal business case draft:
1. Calculate the bond yield to utilize as your required return.
2. Prepare a summary narrative (i.e., a detailed description) of each proposal with detailed elements on the initial investment, as well as the costs/revenues over the life of each of the projects. Identify which revenues and costs are relevant to your analysis, and which costs are irrelevant. Identify the time horizon for each investment.
3. Calculate the after-tax cash flows during the life of each of the projects. Be sure to identify the total costs of ownership and deduct those costs from the benefits to arrive at the net cash inflow per year.
4. Utilizing the after-tax cash flows from Part 4, evaluate each investment proposal utilizing the following criteria (unless directed otherwise):
changes in payments from beginning of period to end;
Payback;
Discounted payback;
NPV;
Profitability index.
5. Clearly indicate whether any of the above criteria support each of the project proposals, and what the company should ultimately decide to do.
Format - Your report narratives may be done in Word or Excel, but calculations and tables of values must be prepared in Excel with the amounts derived from actual formulas that use your variables, rounded to four (4) decimals or lower.
Attachment:- Canada Hardware Case Study.rar