Can you pllease provide an excel sheet analysis with formulas in a tabular format to understand what needs to be done without just explaining rather give the values and the forumals for the three questions. This has been answered by many people onyl if you think you can provide me what i asked for reply ple ase with excel sheets for each problem or excel tables with formuls and analyis. Gold Corp FNCE $623$ Summer $2023$ As a financial analyst of Gold Corp, you have been asked to evaluate two capital Investment alternatives submitted by the production department of the firm. Before beginning your analysis, you note that company policy has set the cost of capital at $15\%$ for all proposed projects. Gold Corp pays BC general corporate income tax rate. The proposed Capital project calls for developing new computer software to facilitate partial automation of production in the company$$s plant. Alternative A has initial software development costs projected add $$184,000,$ while Alternative B would cost at $$320,000.$ Software development costs would be capitalized and qualify for a capital cost allowance $($CCA$)$ rate of $30\%.$ In addition, IT would hire a software consultant under either alternative to assist in making the decision whether to invest in the project for a fee of $$35,000,$ and this cost would be expensed when is in incurred.

year alternative a alternative b

$180000120000$

$280000130000$

$360000105000$

$45000090000$

$53000050000$

To recover its cost, the company$$s IT department will charge the production department for the use of the computer time at the rate of a $$450$ per hour and estimate that it would take $180$ hours to of computer time per year to run the new software under either alternative. The company owns all its computers and does not currently operate them at capacity. The information technology $($IT$)$ plan calls for this excess capacity to continue in the future. For security reasons, it is company policy not to rent excess computing capacity to outside users. If the new partial automation of production is put in place, expected savings in production cost $($before tax$)$ are projected as follows, As the capital budgeting analyst, you are required to answer the following in your memo to the production department a$)$ calculate the net present value of each of the alternatives. Which option would you recommend, and why? Show you calculations