Senior Analyst at Canada Hardware Inc

t is January 1st, 2018. You are a Senior Analyst at Canada Hardware Inc. (CHI), one of the tophardware, sports, and apparel providers in Canada with hundreds of stores across Canada. TheCEO of Canada Hardware, Tony Stark, has reached out to you to draft a report to evaluate twoinvestment proposals, building on your analysis from Assignment 1.PurposeFor this case approach, you will demonstrate your ability to develop costing methods and a set offorecasts of future cash flows for two proposed investment projects. You will also be required toidentify the cost of financing through the issuance of bonds.How to ProceedBuilding on your analysis and proposal from Assignment 1, develop your investment proposalbusiness 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 detailedelements on the initial investment, as well as the costs/revenues over the life of each of theprojects. Identify which revenues and costs are relevant to your analysis, and which costs areirrelevant. 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 identifythe total costs of ownership and deduct those costs from the benefits to arrive at the net cashinflow per year.4.Utilizing the after-tax cash flows from Part 4, evaluate each investment proposal utilizing thefollowing 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, andwhat the company should ultimately decide to do.Format Your report narratives may be done in Word or Excel, but calculations and tables of values mustbe prepared in Excel with the amounts derived from actual formulas that use your variables,rounded to four (4) decimals or lower.The Excel tab worksheet must be print and presentation ready, formatted to print in 2 to 3 pageswithout page fragmentation of equations or tables between pages.It is permissible to break your report down using the questions listed above as headings