Question

In: Finance

Machine F costs $1,480,000, has a life of 8 years and will return a benefit of...

Machine F costs $1,480,000, has a life of 8 years and will return a benefit of $875,500 in the first year, and increasing by 6% for the life of the machine. The first year costs for Machine F is $545,000, increasing by an inflation rate of 3% per year. The salvage value at the end of life of the machine is 12% of the original investment cost. If MARR is 10%, what is the NPW for the machine? Please show all work ....with excel functions..explaining which excel functions were used and why

                               

$980,457

                               

$1,012,544

                               

$1,031,391

                               

$1,234,764

Solutions

Expert Solution

Answer: NPW = $1031391
Calculations:
0 1 2 3 4 5 6 7 8
Annual benefit (with 6% increase from Year 2 875500 928030 983712 1042735 1105299 1171616 1241913 1316428
Annual costs (with 3% increase from Year 2) 545000 561350 578191 595536 613402 631804 650759 670281
Net annual benefit 330500 366680 405521 447198 491896 539812 591155 646147
Initial cost of the machine 1480000
Salvage value (1480000*12%) -177600
Annual project cash flows -1480000 330500 366680 405521 447198 491896 539812 591155 823747
PVIF at 10% 1 0.90909 0.82645 0.75131 0.68301 0.62092 0.56447 0.51316 0.46651
PV at 10% -1480000 300455 303041 304674 305442 305429 304710 303356 384284
NPW 1031391
Answer: NPW = $1031391
Calculations:
0 1 2 3 4 5 6 7 8
Annual benefit (with 6% increase from Year 2 875500 928030 983712 1042735 1105299 1171616 1241913 1316428
Annual costs (with 3% increase from Year 2) 545000 561350 578191 595536 613402 631804 650759 670281
Net annual benefit 330500 366680 405521 447198 491896 539812 591155 646147
Initial cost of the machine 1480000
Salvage value (1480000*12%) -177600
Annual project cash flows -1480000 330500 366680 405521 447198 491896 539812 591155 823747
PVIF at 10% 1 0.90909 0.82645 0.75131 0.68301 0.62092 0.56447 0.51316 0.46651
PV at 10% -1480000 300455 303041 304674 305442 305429 304710 303356 384284
NPW 1031391

Related Solutions

PROBLEM A machine that costs $ 40,000 has a useful life of 8 years and it...
PROBLEM A machine that costs $ 40,000 has a useful life of 8 years and it is estimated that the residual value at the end of its useful life is $ 5,000. This machine, which will be used to make pieces of complex geometry and will have an annual operation and maintenance cost of $ 8,000. The operator of this machine receives $ 15.00 per hour and the machine consumes power at a rate of $ 1.15 per hour. It...
What is the ATCF rate of return for machine that costs 300,000, lasts for 8 years,...
What is the ATCF rate of return for machine that costs 300,000, lasts for 8 years, has zero salvage value, and is classified as 5 year MACRS property? The machine will be purchased with a 20.0% down payment and a four year loan for the remaining amount at an annual interest rate of 11.50%. The machine produces net revenues after deducting direct and indirect expenses but not depreciation of 46,000 in year 1, 120,000 in years 2 to 6, 60,000...
We are evaluating a project that costs $848,000, has a life of 8 years, and has...
We are evaluating a project that costs $848,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 45,000 units per year. Price per unit is $40, variable cost per unit is $20, and fixed costs are $625,000 per year. The tax rate is 24 percent and we require a return of 14 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $832,000, has a life of 8 years, and has...
We are evaluating a project that costs $832,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 40,000 units per year. Price per unit is $40, variable cost per unit is $17, and fixed costs are $700,000 per year. The tax rate is 23 percent and we require a return of 13 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $832,000, has a life of 8 years, and has...
We are evaluating a project that costs $832,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 40,000 units per year. Price per unit is $40, variable cost per unit is $17, and fixed costs are $700,000 per year. The tax rate is 23 percent and we require a return of 13 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $832,000, has a life of 8 years, and has...
We are evaluating a project that costs $832,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 40,000 units per year. Price per unit is $40, variable cost per unit is $15, and fixed costs are $700,000 per year. The tax rate is 23 percent and we require a return of 13 percent on this project.     a. Calculate the accounting...
We are evaluating a project that costs $800,000, has a life of 8 years, and has...
We are evaluating a project that costs $800,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 60,000 units per year. Price per unit is $40, variable cost per unit is $20, and fixed costs are $800,000 per year. The tax rate is 21 percent and we require a return of 11 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $800,000, has a life of 8 years, and has...
We are evaluating a project that costs $800,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 60,000 units per year. Price per unit is $40, variable cost per unit is $20, and fixed costs are $800,000 per year. The tax rate is 21 percent and we require a return of 11 percent on this project.     a. Calculate the accounting...
1.A company buys a machine for $75,000 that has an expected life of 8 years and...
1.A company buys a machine for $75,000 that has an expected life of 8 years and no salvage value. The company uses straight-line depreciation. The company anticipates a yearly net income of $3,600 after taxes of 24%, with the cash flows to be received evenly throughout each year. What is the accounting rate of return? 2.If Management was not concerned with the time value of money, from which two capital budgeting methods should they choose? 3. Vextra Corporation is considering...
Your Company purchased a machine with an estimated useful life of 8 years. The machine will...
Your Company purchased a machine with an estimated useful life of 8 years. The machine will generate cash inflows of $96,000 each year. The salvage value at the end of the project is $80,000. Your Company's discount rate is 6%. The net present value of the investment is ($7,500). What is the purchase price of the machine?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT