Indiva is a small business located in London, Ontario that legally grows medical cannabis indoors in a $900$ square meter building. Their annual production in $2023$ is $230$ kilograms. Cannabis production requires a lot of energy in the form of LED lighting which is currently supplied by London Hydro at a cost of $8$ cents per kWh$.$ It takes $2,100$ kWh to produce $1$ kilogram of cannabis. In order to reduce the high cost of electricity, Indiva is considering installing solar panels on the roof of its building at the end of $2023$ at a capital cost of $$275,000$ which could potentially save $100\%$ of existing hydro costs. Given that the cost of hydro is expected to rise by an average of $3\mathrm{.}1\%$ each year over the $20$ year life time of the solar panels $(2024$ to $2043),$ Indiva expects that this would be a good investment. In addition to saving money, the company would also be reducing its carbon emissions. It is also expected that with increased use of solar panels in the future, there will be a thriving recycling industry and Indiva's solar panels will possess value as scrap material at the end of their useful life and could therefore be sold at the end of $2043$ for $$10,000.$

Indiva is planning on expanding its operations in about $5$ years time. Two properties that could be used for the future expansion have come on the market now; property A is listed at $$1,200,000$ and is currently leased to several small businesses bringing in an annual net income of $$190,000$; property B is listed at $$700,000$ and is currently rented to residential tenants for net $$4,200$ per month. Assume that the value of real estate will increase by the rate of inflation of $2\mathrm{.}5\%$ each year and that the lease and rental amounts will not change. At the end of a five year period, which property will generate the highest return on investment?

Indiva has calculated its cost of capital $($return on investment$)$ to be $12\%.$ Task $1.$On the Case $6$ worksheet, calculate the current annual cost of hydro, then calculate the net present value of the investment in solar panels and its profitability index. Properly design a worksheet that allows users to easily change any assumption value. Task$2.$ On the Case $6$ worksheet, develop a data table that displays the profitability index for various combinations of cost per kWh and cost of capital. The cost per kWh should begin at $6$ cents and end at $15$ cents in one cent increments; the cost of capital rates should begin at $10\%$ and end at $14\%$ in half of a percent increments. Task $3.$ On the Task $3$ worksheet, calculate the net present value of each of the $2$ properties. Task $4.$ Word process an evaluation of ALL of the proposed capital investments. Which investment$($s$)$ should be made and why? Under what conditions should the solar panels not be considered? Embed your document into the Task $3$ worksheet. ALL THIS HAS TO BE DONE IN EXCEL.