A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below:

Option 1

• $75,000 for equipment with useful life of 7 years and no salvage value.
• Maintenance costs are expected to be $2,500 per year and increase by 3% in Year 6 and each year thereafter.
• Materials in Year 1 are estimated to be $20,000 but remain constant at $10,000 per year for the remaining years.
• Labor is estimated to start at $50,000 in Year 1, increasing by 3% each year after.

Revenues are estimated to be:

Year 1Year 2Year 3Year 4Year 5Year 6Year 7-50,000113,000125,000125,000150,000150,000

The company's required rate of returnand cost of capital is 8%.

Management has turned to its finance and accounting department to perform analyses and make a recommendation on which option to choose. They have requested that the three main capital budgeting calculations be done: NPV, IRR, and Payback Period for each option.

My work is below

year 0 1 2 3 4 5 6 7

Purchase price (75,000) - - - - - - -

Revenue 0 50,000 113,000 125,000 125,000 150,000 150,000

Maintenance (2,500) (2,500) (2,500) (2,500) (2,500) (2,650) (2,809)

Materials (20,000) (10,000) (10,000) 10,000 10,000 10,000 10,000

Labor (50,000 (51,500) (53,045) 54,636.35 56,275.44 57,963.7 59,702.6

Cash Flows (-72,500) (-14,000) (47,455) 57,863.65 56,224.56 79,386.3 72,511.6

PV@8% 0.926 0.857 0.794 0.735 0.681 0.630 0.583

PV factors -67,129.6 -12,002.7 37,671.3 42,531.5 3 8,265.49 50,026.8 45,213

Salvage 0