please show in excel if possible.

The same bicycle company has another opportunity presentod to expand their current plant to increase production and ultimately be able to reach new markets with their expanded manufacturing capacity. The company has determined the following information and assumptions for this new expansion idea 1) The capital investment for this project will cost the company $500,000. Depreciation will be calculated over a 5 year life with no salvage value 2) The projected annual net income for each of the five years are as follows: Year 1: Year 2: Year 3: Year 4: Year 5: Total 45,000 50,000 58,000 61,000 63,000 277,000 Instructions: Using the template below. a) compute the annual rate of return. b) prepare a table of the net annucal cash flow and cumulative net cash flow. c) compute the payback period. d) compute the NPV using the determined 15% discount rate Slowld the proposable becepand wring this dirontrute? compare the results from Part 1 to determine which project is more appealing