Can you please Compute Option 1 and show your work on how you computed it.....

Compute the following for the above-referenced investment options: 1.Payback period/method (assume cash inflows occur evenly throughout the year) 2. Accounting rate of return 3.NPV (assume that cash inflows occur at year-end) 4.Internal rate of return (IRR) You may use Excel's built-in functions for NPV and IRR (not required).

The senior VP in charge has asked that you make a recommendation for the purchase of new equipment. Ideally, the company wants to limit its capital investment to $500,000. However, if an asset merits spending more, an investment exceeding this limit may be considered. You assemble a team to help you. Your goal is to determine which option will result in the best investment for the company. To encourage capital investments, the government has exempted taxes on profits from new investments. This legislation is to be in effect for the foreseeable future. The average reported operating income for the company is $1,740,000. The company uses a 10% discount rate in evaluating capital investments. The team is considering the following options Option 1: The asset cost is $300,000. The asset is expected to have an 8-year useful life with no salvage value. Straight-line depreciation is used. The net cash inflow is expected to be $62,000 each year for 8 years. A significant portion of this asset is made from recycled material. When disposed of, certain parts of the asset can be recycled. The delivery time for this asset is 8 weeks.