The proposal is for a plant costing $250,000. The plant has an expected useful life of...

The proposal is for a plant costing $250,000. The plant has an expected useful life of 25 years and a set salvage value of $45,000. Annual receipts of $41,000 are expected, annual maintenance taxes, and administrative cost will be $11,000/year. What is the present worth if MARR is 10%?

A. $28,345

B. $15,515

C. $32,705

D. $26,465

PLEASE SOLVE IN EXCEL WITH EXCEL EQUATIONS

Expert Solution

D. $26,465

Working:

Present value of annual operating net cash inflows				$ 2,72,311
Present value of salvage				$ 4,153

Total Present value of cash inflows				$ 2,76,465

Less cost of project				$ 2,50,000

Present worth of project				$ 26,465

Working;

Net Annual operating cash inflow	=	Annual cash inflows - Annual cash outflow
	=	$ 41,000	-	$ 11,000
	=	$ 30,000

Present value of annuity of 1 for 25 years	=	(1-(1+i)^-n)/i		Where,
	=	(1-(1+0.10)^-25)/0.10		i	10%
	=	9.077040018		n	25

Present value of 1 received at the end of year 25	=	(1+i)^-n
	=	(1+0.10)^-25
	=	0.092295998

Present value of annual cash inflows	=	Annual Cash inflows * Present value of annuity of 1 for 25 years
	=	$ 30,000	*	9.077040018
	=	$ 2,72,311.20

Present value of salvage value	=	Salvage Value * Present value of 1
	=	$ 45,000.00	*	0.092295998
	=	$ 4,153.32

ekkarill92 answered 1 year ago

Equipment costing $590,000 with an expected useful life of 10 years and an expected salvage value...

Equipment costing $590,000 with an expected useful life of 10 years and an expected salvage value of $40,000, was purchased at the beginning of the year. Calculate the depreciation expense for the first five years using: (a) Sum-of-the-years' digits method. Do not round until final calculation. Round answers to the nearest whole number. (b) Double-declining balance method (without straight-line switchover). Do not round until final calculation. Round answers to the nearest whole number.

Equipment costing $540,000 with an expected useful life of 10 years and an expected salvage value...

Equipment costing $540,000 with an expected useful life of 10 years and an expected salvage value of $40,000, was purchased at the beginning of the year. Calculate the depreciation expense for the first five years using: (a) Sum-of-the-years' digits method. Do not round until final calculation. Round answers to the nearest whole number. Year 1 $Answer Year 2 $Answer Year 3 $Answer Year 4 $Answer Year 5 $Answer (b) Double-declining balance method (without straight-line switchover). Do not round until final...

Q12) A company has purchased an equipment costing $84,300. The equipment has a useful life of...

Q12) A company has purchased an equipment costing $84,300. The equipment has a useful life of 3 years with a salvage value of $34,100. CCA will be taken using a rate of 30.00%. The tax rate is 29.00%, while the discount rate is 9.00%. Assuming the company takes all available CCA every year and there will be some assets remaining in the CCA class after year 3, what is the EAC of this equipment? 16,741 17,194 17,646 18,099 18,551

Co. is considering purchasing a piece of equipment costing $300,000. It has a useful life of...

Co. is considering purchasing a piece of equipment costing $300,000. It has a useful life of 3 years and will be depreciated straight-line to zero, after which it will be scrapped for $20,000. This piece of equipment will save Teer Co. $125,000 per year in pretax operating costs during its useful life but requires an initial investment in NWC of $50,000. Teer Co. has a 20% tax rate and a required rate of return of 10%. What is the annual...

Rennin Dairy Corporation is considering a plant expansion decision that has an estimated useful life of...

Rennin Dairy Corporation is considering a plant expansion decision that has an estimated useful life of 20 years. This project has an internal rate of return of 15% and a payback period of 9.6 years. How would a decrease in the expected salvage value from this project in 20 years affect the following for this project? Internal Rate of Return Payback Period A) Decrease Decrease B) No effect Decrease C) Decrease No effect D) Increase No effect E) No effect...

XYZ Company is considering purchasing a piece of equipment costing $400,000. It has a useful life...

XYZ Company is considering purchasing a piece of equipment costing $400,000. It has a useful life of 4years and will be depreciated straight-line to zero, after which it will be scrapped for $30,000. This piece of equipment will save $150,000 per year in pretax operating costs during its useful life but requires an initial investment in NWC of $36,000. XYZ Company has a 21% tax rate and a required rate of return of 12% What is the annual Operating Cash...

Bark company is considering investing in a project that costs $70,000, has an expected useful life...

Bark company is considering investing in a project that costs $70,000, has an expected useful life of 3 years, no salvage value, and will increase net annual cash flows by $28,650. What is the internal rate of return?

A processing plant has a first cost of $700,000 and an expected life of 15 years...

A processing plant has a first cost of $700,000 and an expected life of 15 years with no salvage value. Money is borrowed at 5 percent compounded annually, and the first cost is paid off with 15 equal annual payments. The expected annual income is $200,000, and annual operating expenses are $40,000. Corporation income tax is 50 percent of the profits, and the SYD method of depreciation is applicable on the tax life of the facility, which is 11 years...

A firm has decided to acquire as asset costing $150,000 that has an expected life 3...

A firm has decided to acquire as asset costing $150,000 that has an expected life 3 years. Straight line depreciation method is to be applied without residual value. The asset can be purchsed by borrowing or it can be leased. If leasing is used, the lessor requires 10% return, where payment to be made semi-annually at the beginning of each period. If loan, the cost of borrowing is 8% and the loan will be paid semi-annually. If tax rate is...

Moreno Corporation is considering investing in specialized equipment costing $525,000. The equipment has a useful life...

Moreno Corporation is considering investing in specialized equipment costing $525,000. The equipment has a useful life of five years and a residual value of $55,000. Depreciation is calculated using the straight-line method. The expected net cash inflows from the investment are Year 1 $245,000 Year 2 $190,000 Year 3 $152,000 Year 4 $112,000 Year 5 $95,000 $794,000 Moreno Corporation's required rate of return is 14%. The net present value of the Moreno Corporation's investment is closest to Select one: a....

Question