PAPER 65

S T m Computer Disk Duplicators, Inc. has been considering several capital investment proposals for the year beginning in 2022. For each investment proposal, the relevant cash flows and other relevant financial data are summarized in the table below. New assets will be depreciated under the MACRS system rather than being fully expensed right away. In the case of a replacement decision, the total installed cost of the equipment will be partially offset by the sale of existing equipment. The firm is subject to a 40 percent tax rate on ordinary income and on long-term capital gains. The firm's cost of capital is 15 percent. Type of Capital Budgeting Decision OA. $34,400 OB. $66,400 1 Expansion OC. $80,000 OD. $13,600 Type of Project Cost of new asset Installation costs MACRS (new asset) Original cost of old asset Purchase date (old asset) Sale proceeds (old asset) MACRS (old asset) Annual net profits before depreciation & taxes (old) Annual net profits before depreciation & taxes (new)…

Solve the question by using calculator

Assume that Monsanto Corporation is considering the replacement of some ofits older and outdated carpet-manu facturing equipment. Its objective is to improve the efficiency of operations in terms of both speed and reduction in the number of defects. The company's finance department has compiled pertinent data to conduct a marginal cost-benefit analysis for the proposed equipment replacement. The cash outlay for new equipment would be approximately $600,000. The net book value of the old equipment and its potential net selling price add up to $250,000. The total benefits over the life of the new equipment (measured in today's dollars) would be $900,000. The sum of benefits from the remaining life of the old equipment (measured in today's dollars) would be $300,000. To Do Create a spreadsheet to conduct a marginal cost-benefit analysis for Monsanto Corporation, and determine the following: a. The marginal benefits of the proposed new equipment. b. The marg inal costs of the proposed new…

Sandhill Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows. The company's cost of capital is 6%. Option A Option B Initial cost $170,000 $274,000 Annual cash inflows $72,200 $82,200 Annual cash outflows $31,400 $26,700 Cost to rebuild (end of year 4) $50,100 $0 Salvage value $0 $8,200 Estimated useful life 7 years 7 years Click here to view PV table. (a) * Your answer is incorrect. Compute the (1) net present value, (2) profitability index, and (3) internal rate of return for each option. (Hint: To solve for internal rate of return, experiment with alternative discount…

Blossom Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows. The company's cost of capital is 5%. Option A Option B Initial cost $183,000 $281,000 Annual cash inflows $70,000 $80,000 Annual cash outflows $28,000 $25,000 Cost to rebuild (end of year 4) $48,000 $0 Salvage value $0 $7,000 Estimated useful life 7 years 7 years

Swifty Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows. The company's cost of capital is 6%. Option A Option B Initial cost $171,000 $269,000 Annual cash inflows $70,500 $81,500 Annual cash outflows $29,600 $27,000 Cost to rebuild (end of year 4) $48,900 $0 Salvage value $0 $7,100 Estimated useful life 7 years 7 years Click here to view PV table. (a) Compute the (1) net present value, (2) profitability index, and (3) internal rate of return for each option. (Hint: To solve for internal rate of return, experiment with alternative discount rates to arrive at a net…

Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows. The company's cost of capital is 7%. Initial cost Annual cash inflows Annual cash outflows Cost to rebuild (end of year 4) Salvage value Estimated useful life Option A $155,000 $70,700 $32,000 $48,300 $0 7 years Option B $262,000 $80,400 $25,700 $0 $8,100 7 years

Assume that Rolando Corporation is considering the renovation and/or replacement of some of its older and outdated carpet-manufacturing equipment. Its objective is to improve the efficiency of operations in terms of both speed and reduction in the number of defects. The company’s finance department has compiled pertinent data that will allow it to conduct a marginal cost–benefit analysis for the proposed equipment replacement. The cash outlay for new equipment would be approximately $600,000. The net book value of the old equipment and its potential net selling price add up to $250,000. The total benefits from the new equipment (measured in today’s dollars) would be $900,000. The benefits of the old equipment over a similar period of time (measured in today’s dollars) would be $300,000. TO DO Create a spreadsheet to conduct a marginal cost–benefit analysis for Rolando Corporation, and determine the following:   a. The marginal (added) benefits of the proposed new equipment. * b. The…

Carla Vista Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows. The company's cost of capital is 5%. Option A Option B Initial cost $194,000 $291,000 Annual cash inflows $72,600 $82,000 Annual cash outflows $28,100 $25,100 Cost to rebuild (end of year 4) $51,200 $0 Salvage value $0 $9,000 Estimated useful life 7 years 7 years Click here to view the factor table. (a) Your answer is partially correct. Compute the (1) net present value, (2) profitability index, and (3) internal rate of return for each option. (Hint: To solve for internal rate of return, experiment with…

Carla Vista Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows. The company's cost of capital is 5%. Initial cost Annual cash inflows Annual cash outflows Cost to rebuild (end of year 4) Salvage value Estimated useful life Option A $194,000 $72,600 $28,100 $51,200 $0 7 years Option B $291,000 $82,000 $25,100 $0 $9,000 7 years

Show excel calculations.

Please show the solution on excel spreadsheet and please indicate the formulas used. Thank you.

At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. The company will need to do replacement analysis to determine which option is the best financial decision for the company. Price Co. is considering replacing an existing piece of equipment. The project involves the following: • The new equipment will have a cost of $1,800,000, and it will be depreciated on a straight-line basis over a period of six years (years 1–6). • The old machine is also being depreciated on a straight-line basis. It has a book value of $200,000 (at year 0) and four more years of depreciation left ($50,000 per year). • The new equipment will have a salvage value of $0 at the end of the project's life (year 6). The old machine has a current salvage value (at year 0) of $300,000. • Replacing the old machine will require an investment in net operating working capital (NOWC) of $50,000 that will be recovered at the end…

Hearne Company has a number of potential capital investments. Because these projects vary in nature, initial investment, and time horizon, management is finding it difficult to compare them. Assume straight line depreciation method is used. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) (Use appropriate factor(s) from the tables provided.) Project 1: Retooling Manufacturing Facility This project would require an initial investment of $4,930,000. It would generate $937,000 in additional net cash flow each year. The new machinery has a useful life of eight years and a salvage value of $1,880,000. Project 2: Purchase Patent for New Product The patent would cost $3,680,000, which would be fully amortized over five years. Production of this product would generate $607,200 additional annual net income for Hearne. Project 3: Purchase a New Fleet of Delivery Trucks Hearne could purchase 25 new delivery trucks at a cost of $145,400 each. The…

I need help with this question. Don't use any AI. It's strictly prohibited...

Hearne Company has a number of potential capital investments. Because these projects vary in nature, initial investment, and time horizon, management is finding it difficult to compare them. Assume straight line depreciation method is used. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) Note: Use appropriate factor(s) from the tables provided. Project 1: Retooling Manufacturing Facility This project would require an initial investment of $4,960,000. It would generate $964,000 in additional net cash flow each year. The new machinery has a useful life of eight years and a salvage value of $1,910,000. Project 2: Purchase Patent for New Product The patent would cost $3,785,000, which would be fully amortized over five years. Production of this product would generate $681,300 additional annual net income for Hearne. Project 3: Purchase a New Fleet of Delivery Trucks Hearne could purchase 25 new delivery trucks at a cost of $156,800 each.…

Hearne Company has a number of potential capital investments. Because these projects vary in nature, initial investment, and time horizon, management is finding it difficult to compare them. Assume straight line depreciation method is used. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) Note: Use appropriate factor(s) from the tables provided. Project 1: Retooling Manufacturing Facility This project would require an initial investment of $5,050,000. It would generate $1,045,000 in additional net cash flow each year. The new machinery has a useful life of eight years and a salvage value of $2,000,000. Project 2: Purchase Patent for New Product The patent would cost $4,100,000, which would be fully amortized over five years. Production of this product would generate $922,500 additional annual net income for Hearne. Project 3: Purchase a New Fleet of Delivery Trucks Hearne could purchase 25 new delivery trucks at a cost of $191,000…

Cullumber Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows. The company's cost of capital is 5%. Initial cost Annual cash inflows Annual cash outflows Cost to rebuild (end of year 4) Salvage value Estimated useful life Click here to view the factor table Your answer is partially correct Option A Option B Option A $170,000 $70,200 $30,700 $49,000 $ Compute the (1) net present value. (2) profitability index, and (3) internal rate of return for each option. (Hint: To solve for internal rate of return, experiment with alternative discount rates to arrive at a net present…