You are considering the following two mutually exclusive projects. Both projects will be depreciated using straight-line depreciation to a zero book value over the life of the project. Neither project has any salvage value. Project A has a required rate of return of 10% and a required payback period of 2 years. Project B has a 13% required rate of return and a required payback period of 2 years. Based on the net present value method of analysis and given the information in the problem, which project should you accept and why? * Need to see work in Excel using formula(s) and/or function(s).

Year	Project A	Project B
0	($75,000)	($70,000)
1	$30,000	$10,000
2	$48,000	$16,000
3	$10,000	$72,000