Washington Mill Works is considering purchasing a large resawing band saw for $30,000. The saw has...

Washington Mill Works is considering purchasing a large resawing band saw for $30,000. The saw has a useful life estimated to be seven years, at which point it will have an estimated salvage value of $8,000. Annual income each year for the 7 years is $9000. Annual operating expenses are $3,000. Assume MARR = 7.5% and the planning horizon is 7 years. What is the present worth, annual worth, future worth, internal/external rate of return?

Please answer all parts. Include a cashflow diagram if possible.

Expert Solution

Given:
Minimum Acceptable rate of return	7.50%
Planning period in years	7
BandSaw Cost	$ 30,000
Salvage Value	$ 8,000
Depriciation amount	$ 3,143
Cashflow Diagram

Particulars \| YEARS	YEAR 0	YEAR 1	YEAR 2	YEAR 3	YEAR 4	YEAR 5	YEAR 6	YEAR 7
Revenue	$ -	$ 9,000	$ 9,000	$ 9,000	$ 9,000	$ 9,000	$ 9,000	$ 9,000
Operating Exp.	$ -	$ 3,000	$ 3,000	$ 3,000	$ 3,000	$ 3,000	$ 3,000	$ 3,000
BandSaw Cost	-$ 30,000	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Depreciation	$ -	$ 3,143	$ 3,143	$ 3,143	$ 3,143	$ 3,143	$ 3,143	$ 3,143
Salavage Value	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 8,000
Net Cash flow	-$ 30,000.00	$ 2,857.14	$ 2,857.14	$ 2,857.14	$ 2,857.14	$ 2,857.14	$ 2,857.14	$ 10,857.14

ANSWERS:
(1) Present Worth	-$ 10,044.81		Using NPV formula in excel = (discount rate, Cashflow)+investment = (7.5%, C19:I19)+(-30000)
(2) Annual Worth	-$ 1,896.46		Using formula = annual worth = PV* ( (i(1+i)^n) / ((1+i)^n -1) ) = -10044.81(( 0.075*(1.075^7))/ ((1.075^7)-1))
(3) Future Value	$ 25,106.61		Using FV formula in excel = (rate, nper, PMT) = (7.5%, 7, 2857.14)
(4) IRR	-1.40%		Using IRR formula = ( value, [Guess]) = (B19:I19)

jeff jeffy answered 2 years ago

Crane Lumber, Inc., is considering purchasing a new wood saw that costs $80,000. The saw will...

Crane Lumber, Inc., is considering purchasing a new wood saw that costs $80,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labor needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $2,700 at the end of its five-year life and will be depreciated on a straight-line basis over five years to zero. Crane’s tax...

Crane Lumber, Inc., is considering purchasing a new wood saw that costs $60,000. The saw will...

Crane Lumber, Inc., is considering purchasing a new wood saw that costs $60,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labor needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $3,500 at the end of its five-year life and will be depreciated on a straight-line basis over five years to zero. Crane’s tax...

Crane Lumber, Inc., is considering purchasing a new wood saw that costs $45,000. The saw will...

Crane Lumber, Inc., is considering purchasing a new wood saw that costs $45,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labor needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $1,400 at the end of its five-year life and will be depreciated on a straight-line basis over five years to zero. Crane’s tax...

Snowy Mountain Timber Ltd is considering purchasing a new wood saw that costs $70,000. The saw...

Snowy Mountain Timber Ltd is considering purchasing a new wood saw that costs $70,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labour needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $3,500 at the end of its five-year life and will be depreciated on a straight-line basis over five years to zero. Snowy...

Snowy Mountain Timber Ltd is considering purchasing a new wood saw that costs $50,000. The saw...

Snowy Mountain Timber Ltd is considering purchasing a new wood saw that costs $50,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labour needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $4,000 at the end of its five-year life and will be depreciated on a straight-line basis over five years to zero. Snowy...

What is the project's NPV? Crane Lumber, Inc., is considering purchasing a new wood saw that...

What is the project's NPV? Crane Lumber, Inc., is considering purchasing a new wood saw that costs $60,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labor needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $4,800 at the end of its five-year life and will be depreciated on a straight-line basis over five...

ohnny’s Lunches is considering purchasing a new, energy-efficient grill. The grill will cost $30,000 and will...

ohnny’s Lunches is considering purchasing a new, energy-efficient grill. The grill will cost $30,000 and will be depreciated straight-line over 3 years. It will be sold for scrap metal after 5 years for $7,500. The grill will have no effect on revenues but will save Johnny’s $15,000 in energy expenses. The tax rate is 30%. Required: a. What are the operating cash flows in each year? b. What are the total cash flows in each year? c. Assuming the discount...

The Button Co. is considering the purchase of a new machine for $30,000 that has a...

The Button Co. is considering the purchase of a new machine for $30,000 that has a life of 5 years and would be depreciated on straightline basis to a zero salvage value over its life. The machine is expected to save the firm $12,500 per year in operating costs. Alternatively, the firm can lease the machine for $7,300 annually for 5 years, with the first payment due at the end of the first year. The firm's tax rate is 21...

A purchasing agent for a large manufacturing firm has responsibility for selecting vendors for the materials...

A purchasing agent for a large manufacturing firm has responsibility for selecting vendors for the materials and supplies used by the company. The agent directs a disproportionate number of purchase orders to a supply company owned by the agent’s uncle, which charges above-market prices for its products. The agent’s employer is not aware of the relationship between the agent and the supplier. Required What type of fraud is this? Controls can be implemented to prevent or detect the fraud?

Facebook is considering purchasing a new state-of-the-art server farm (several large computers) that would allow the...

Facebook is considering purchasing a new state-of-the-art server farm (several large computers) that would allow the company to match customers’ pictures to advertisers. The company estimates this new service will generate additional advertising revenues of $6 million at the end of the first year, and of $7 million at the end of the second year. Working capital requirements increase by $3 million at the end of year 1. After 2 years, Facebook expects to sell the servers and generate a...

Question