35. Net Present Value Analysis. Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual net cash receipts resulting from this machine are predicted to be $45,000. The companys required rate of return is 15 percent.

Required:

a. Ignoring the time value of money, calculate the net cash inflow or outflow resulting from this investment opportunity.

b. Find the net present value of this investment using the format presented in.

Round to the nearest dollar.

c. Should the company purchase the wood lathe? Explain. Internal Rate of Return Analysis. Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual net cash receipts resulting from this machine are predicted to be $45,000. The companys required rate of return is 15 percent (this is the same data as the previous exercise).

Anonymous

719 answers

Req a. Cash inflows and outflows
Year	Cash Flows
0	-100000	Initial investment
1	25000	Annual cash receipts less Annual maintenance cost
2	25000	Annual cash receipts less Annual maintenance cost
3	25000	Annual cash receipts less Annual maintenance cost
4	25000	Annual cash receipts less Annual maintenance cost
5	30000	Annual cash receipts less Annual maintenance cost + salvage value
Req b:
Year	cashflows	PVF @ 15%	Present value
0	-100000	1	-100000
1	25000	0.869565	21739.13
2	25000	0.756144	18903.59
3	25000	0.657516	16437.91
4	25000	0.571753	14293.83
5	30000	0.497177	14915.3
Net present value			-13710
Req C: No Company should not purchasse the machine, as the NPV of machine is (13710)
IRR:
NPV at 15% = ($13710)
NPV at 9%
Year	cashflows	PVF @ 9%	Present value
0	-100000	1	-100000
1	25000	0.917431	22935.78
2	25000	0.84168	21042
3	25000	0.772183	19304.59
4	25000	0.708425	17710.63
5	30000	0.649931	19497.94
Net present value			491
IRR = Lower rate + (NOV at lower rate/ Difference in NOV) * Difference in Rates
	9% + ( 491 / 14201)*6% = 9.21%

Required:

a. Use trial and error to approximate the internal rate of return for this investment proposal.

b. Should the company purchase the wood lathe? Explain. Payback Period Calculation. Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual net cash receipts resulting from this machine are predicted to be $45,000. The companys required rate of return is 15 percent (this is the same data as the previous exercise). Determine the payback period for this investment using the format shown

in . Net Present Value Analysis and Qualitative Factors, Alternative

Format. Petes Plumbing Supplies would like to expand into a new warehouse at a cost of $500,000. The warehouse is expected to have a life of 20 years, and a salvage value of $100,000. Annual costs for maintenance, insurance, and other cash expenses will total $60,000. Annual net cash receipts resulting from this expansion are predicted to be $115,000. The companys required rate of return is 12 percent.

Required:

a. Find the net present value of this investment using the format presented in.

Round to the nearest dollar.

b. Should the company purchase the new warehouse? Explain.

c. Provide one qualitative factor that might cause the company to reach a different conclusion than the one reached in requirement b. Calculating NPV and IRR Using Excel. Petes Plumbing Supplies would like to expand into a new warehouse at a cost of $500,000. The warehouse is expected to have a life of 20 years, and a salvage value of $100,000. Annual costs for maintenance, insurance, and other cash expenses will total $60,000. Annual net cash receipts resulting from this expansion are predicted to be $115,000. The companys required rate of return is 12 percent.

Required:

a. Use Excel to calculate the net present value and internal rate of return in a format similar to the Computer Application spreadsheet shown in the chapter.

b. Should the company purchase the warehouse? Explain. Net Present Value Analysis with Taxes. Quality Chocolate, Inc., would like to purchase a new machine for $200,000. The machine will have a life of 4 years with no salvage value, and is expected to generate annual cash revenue of $90,000. Annual cash expenses, excluding depreciation, will total $10,000. The company uses the straight-line depreciation method, has a tax rate of 30 percent, and requires a 14 percent rate of return.