Question: Can I have answer for "requirements" 2 and below is table s for project A and B. Please including the "NPV using Excel" and show the NPV formula. NET PRESENT VALUE
PROJECT A					PROJECT B
	Net Cash Flow	Present Value divisor or factor @ 8%	Present Value of Cash Flows (using math)			Net Cash Flow	Present Value divisor or factor @ 8%	Present Value of Cash Flows (using math)
Investment	(350,000)	1.0000	(350,000)		Investment	(350,000)	1.0000	(350,000)
Year 1					Year 1
Year 2					Year 2
Year 3					Year 3
Year 4					Year 3 Salvage
Year 4 Salvage
		NET PRESENT VALUE					NET PRESENT VALUE
		NPV using Excel:				NPV using Excel:

Leeds Company has an opportunity to invest in one or two new projects. Project A requires a $350,000 investment for new machinery with a

four-year life and no salvage value. Project B requires a $350,000 investment for new machinery with a three-year life and a $10,000 salvage value. The two projects yield the following predicted annual results. The company uses straight-line depreciation and cash flows occur evenly throughout each year.

Project A

Sales	$350,000
Expenses:
Direct materials	49,000
Direct labor	70,000
Overhead including depreciation	126,000
Selling & administrative expenses	25,000
Tax rate	30%

Project B

Sales	$280,000
Expenses:
Direct materials	35,000
Direct labor	42,000
Overhead including depreciation	126,000
Selling & administrative expenses	25,000
Tax rate	30%

REQUIREMENTS:

1. In the first table in the working papers, you will use one column to determine net income, and the next column to determine net cash flows. HINT: Think about what on the income statement is never cash...this is the amount not to include in the net cash flows column. Compute each projects annual expected net cash flows (round to nearest dollar)

2. Determine each projects net present value using 8% as the discount rate (this is your interest rate). Assume that cash flows occur at each year-end (round to nearest dollar). Complete with both manual math formulas and using the Excel NPV formula.