McLaughin Company requires a 10% return on any investment project they undertake, and uses that required return as the screening tool for determining whether to enter in to any project. One project currently under consideration by McLaughin Company, which is expected to have a life of five years, would result in the following:

• Initial investment in equipment, required at the beginning of the project: $200,000
• Working capital investment required to be set aside at the beginning of the project: $80,000
• Annual cash inflows (for each of the five year project life): $65,000
• Cost of realignment maintenance on the equipment at the end of year three: $25,000

The working capital investment would be released at the end of the project and would be available for other purposes at that point. Additionally, the equipment that is purchased as part of the initial investment in this project would be sold at the end of the project for $20,000.

Use the information above and the appropriate factor values provided immediately below to populate the spreadsheet at the bottom of the page to determine the NET PRESENT VALUE of this project. Using the two drop-down selection boxes within the spreadsheet, indicate whether this project passes the screening test based on whether the net present value result indicates the project exceeds or does not exceed the required 10% rate of return on the project.

I don't need an explanation, I just need the ASAP answers, please!

Periods 1% 2% 0.9901 0.9804 0.9803 0.9612 0.9706 0.9423 0.9610 0.9238 0.9515 0.9057 0.9420 0.8880 0.9235 0.8535 0.9053 0.8203 0.8874 0.7885 0.8195 0.6730 0.7876 0.6217 TABLE 1 - PRESENT VALUE OF $1 3% 4% 5% 6% 8% 0.9709 0.9615 0.9524 0.9434 0.9259 0.9426 0.9246 0.9070 0.8900 0.8573 0.9151 0.8890 0.8638 0.8396 0.7938 0.8885 0.8548 0.8227 0.7921 0.7350 0.8626 0.8219 0.7835 0.7473 0.6806 0.8375 0.7903 0.7462 0.7050 0.6302 0.7894 0.7307 0.6768 0.6274 0.5403 0.7441 0.6756 0.6139 0.5584 0.4632 0.7014 0.6246 0.5568 0.4970 0.3971 0.5537 0.4564 0.3769 0.3118 0.2145 0.4919 0.3901 0.3101 0.2470 0.1577 10% 0.9091 0.8264 0.7513 0.6830 0.6209 0.5645 0.4665 0.3855 0.3186 0.1486 0.1015 12% 0.8929 0.7972 0.7118 0.6355 0.5674 0.5066 0.4039 0.3220 0.2567 0.1037 0.0659 16% 0.8621 0.7432 0.6407 0.5523 0.4761 0.4104 0.3050 0.2267 0.1685 0.0514 0.0284 20 24 Periods 3 4 1% 0.9901 1.970 2.941 3.902 4.853 5.795 7.652 9.471 11.255 1 8.046 21.243 TABLE 2 - PRESENT VALUE OF AN ORDINARY ANNUITY OF $1 2% 3% 4% 5% 6% 8% 10% 0.9804 0.9709 0.9615 0.9524 0.9434 0.9259 0.9091 1.942 1.913 1.886 1.859 1.833 1.783 1.736 2.884 2.829 2.775 2.723 2.673 2.577 2.487 3.808 3.717 3.630 3.546 3.465 3.312 3.170 4.713 4.580 4.452 4.329 4.212 3.993 3.791 5.601 5.417 5.242 5.076 4.917 4.623 4.355 7.325 7.020 6.733 6.463 6.2105.747 5.335 8.983 8.530 8.111 7.722 7.360 6.710 6.145 10.575 9.954 9.385 8.863 8.384 7.536 6.814 16.351 14.877 13.590 12.462 11.470 9.818 8.514 18.914 16.936 15.247 13.799 12.550 10.5298.985 12% 0.8929 1.690 2.402 3.037 3.605 4.111 4.968 5.650 6.194 7.469 7.784 16% 0.8621 1.605 2.246 2.798 3.274 3.685 4.344 4.833 5.197 5.929 6.073 10 12 20 24 A B More rows have been provided below than necessary, use as few or as many as you need. Enter Outflows/Payments in (Parentheses) Cash Flow Item Description Cash Flow Item Amount Present Value Factor Net Present Value NM + L N 000 10 11 13 17 18 19 This project the project pass the screening decision test, because exceed the required rate of return. 20