Question

In: Economics

A machine costs $35,000 to buy and $5,000 per year to operate and maintain. It will...

A machine costs $35,000 to buy and $5,000 per year to operate and maintain. It will have a salvage value of $8,000 in 9 years. It will generate $10,000 per year in net revenue for the first four years, and then the revenue will fall by $1,000 each year after. If the company purchasing the machine uses a MARR of 7% to make project , find the NPW, NFW, and AW. Is this project worth undertaking if no loss is expected?

Work in Microsoft Excel (show Code)

Solutions

Expert Solution

using Excel

MARR 7%
Year Initial cost Annual revenue Annual cost Salvage value Net Cash flow
0 -35000 -35000
1 10000 -5000 5000
2 10000 -5000 5000
3 10000 -5000 5000
4 10000 -5000 5000
5 9000 -5000 4000
6 8000 -5000 3000
7 7000 -5000 2000
8 6000 -5000 1000
9 5000 -5000 8000 8000
NPW -7033.99
NFW -12,931.71
AW -1,079.62

This project is not worth undertaking as NPV is negative

Showing formula

MARR 0.07
Year Initial cost Annual revenue Annual cost Salvage value Net Cash flow
0 -35000 =B3+C3+D3+E3
1 10000 -5000 =B4+C4+D4+E4
2 10000 -5000 =B5+C5+D5+E5
3 10000 -5000 =B6+C6+D6+E6
4 10000 -5000 =B7+C7+D7+E7
5 =C7-1000 -5000 =B8+C8+D8+E8
6 =C8-1000 -5000 =B9+C9+D9+E9
7 =C9-1000 -5000 =B10+C10+D10+E10
8 =C10-1000 -5000 =B11+C11+D11+E11
9 =C11-1000 -5000 8000 =B12+C12+D12+E12
NPW =NPV(B1,F4:F12)+F3
NFW =FV(B1,9,0,-F13)
AW =PMT(B1,9,-F13)

Rahul Sunny answered 1 year ago
Next > < Previous

Related Solutions

A machine costs $35,000 to buy and $5,000 per year to operate and maintain. It will...
A machine costs $35,000 to buy and $5,000 per year to operate and maintain. It will have a salvage value of $8,000 in 9 years. It will generate $10,000 per year in net revenue for the first four years, and then the revenue will fall by $1,000 each year after. If the company purchasing the machine uses a MARR of 7% to make project , find the NPW, NFW, and AW. Is this project worth undertaking if no loss is...
A machine, costing $30,000 to buy and $2,500 per year to operate, will save mainly labor...
A machine, costing $30,000 to buy and $2,500 per year to operate, will save mainly labor expenses in packaging over seven years. The anticipated salvage value of the machine at the end of seven years is $5,500. 1f a 12% return on investment (rate of return) is desired, what is the minimum required annual savings in labor from this machine? If the service life is just five years, instead of seven years, what is the minimum required annual savings in...
A machine, costing $32,000 to buy and $2,700 per year to operate. will save mainly labor...
A machine, costing $32,000 to buy and $2,700 per year to operate. will save mainly labor expenses in packing over seven years. The anticipated salvage value of the machine at the end of seven years is $4,500. (a) if a 12% return on investment (rate of return) is desired, what is the minimum required annual savings in labor from this machine? (b) The service life us just five years, instead of seven years, what is the minimum required annual savings...
A precision lathe costs $13,500 and will cost $22,000 a year to operate and maintain. If...
A precision lathe costs $13,500 and will cost $22,000 a year to operate and maintain. If the discount rate is 14% and the lathe will last for 5 years, what is the equivalent annual cost of the tool? (Enter your answer as positive value. Round your answer to the nearest cent.        The equivalent annual cost          $  
A polisher has an initial cost of $35,000 and will cost $15,000 per year to operate...
A polisher has an initial cost of $35,000 and will cost $15,000 per year to operate and maintain. If the cost of capital is 8% and the polisher will last for 7 years, what is the equivalent annual cost?
Assume that you will buy and operate a piece of equipment. The machine costs $25,000. You...
Assume that you will buy and operate a piece of equipment. The machine costs $25,000. You estimate that the equipment will generate $10,000 revenue, each year for six years. You also estimate that operating costs for the machine will be $4,500 each year for six years. These estimates are in constant 2019 dollars. The inflation rate for revenues is estimated to be 3.5%. The inflation rate for operating costs is estimated to be 5.0%.   You will depreciate the machine using...
Project 1 Project 2 Initial Year 1 $ 35,000 $ 35,000 Year 2 5,000 16,000 Year...
Project 1 Project 2 Initial Year 1 $ 35,000 $ 35,000 Year 2 5,000 16,000 Year 3 16,000 23,000 Year 4 22,000 12,000 Year 5 (3,600) 11,600 Estimated scrap value 5,000 5,000 Cost of capital 14% Calculate: Payback period Average rate of return on initial investment Net present value
A machine has a 10-year life. It costs $5,000 to install today, and annual maintenance costs...
A machine has a 10-year life. It costs $5,000 to install today, and annual maintenance costs in years 1-10 are $500 per year. If the discount rate is 7%, what is the machine's equivalent annual annuity (EAA)? A project requires an initial investment of $20,000 today (i.e. year 0). Expected future cash flows in years 1-4 are $8000; $2000; $3000 and $6000 respectively. If the discount rate is 8%, what is the NPV? What is the IRR?
Your firm needs a machine which costs $140,000, and requires $35,000 in maintenance for each year...
Your firm needs a machine which costs $140,000, and requires $35,000 in maintenance for each year of its 10 year life. After 5 years, this machine will be replaced. The machine falls into the MACRS 10-year class life category. Assume a tax rate of 40% and a discount rate of 13%. What is the depreciation tax shield for this project in year 10?
4) Machine A costs $35,000, lasts 3 years and has a salvage value of $7,500. Machine...
4) Machine A costs $35,000, lasts 3 years and has a salvage value of $7,500. Machine B costs $25,000, lasts 2 years and has a salvage value of $3,500. The machines can be purchased at the same price with the same salvage value in the future, and are needed for a 6 year project. Which machine would you purchase and why? Provide justification using an Annualized Equivalent Cost analysis. Interest is 10% annual rate, compounded annually. Answer______________________________________
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT