Tempura, Inc., is considering two projects. Project A requires an investment of $44,000. Estimated annual receipts for 20 years are $23,000; estimated annual costs are $12,500. An alternative project, B, requires an investment of $77,000, has annual receipts for 20 years of $33,000, and has annual costs of $18,000. Assume both projects have a zero salvage value and that MARR is 13.0 %/year.
Present worth of A = -44000 + (23000 - 12500)*(P/A, 13%,20)
= -44000 + 10500 * 7.024752
= 29759.90
Present worth of B = -77000 + (33000 - 18000)*(P/A, 13%,20)
= -77000 + 15000 * 7.024752
= 28371.27
As Present worth of A is more it should be selected
Tempura, Inc., is considering two projects. Project A requires an investment of $44,000. Estimated annual receipts...
Show me step by step on how to solve this problem in Excel, thanks. Tempura, Inc., is considering two projects. Project A requires an investment of $50,000. Estimated annual receipts for 20 years are $20,000; estimated annual costs are $12,500. An alternative project, B, requires an investment of $75,000, has annual receipts for 20 years of $28,000, and has annual costs of $18,000. Assume both projects have zero salvage value and that MARR is 12 percent/year. a. What is the...
Cochrane, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.1 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $2,150,000 in annual sales, with costs of $1,140,000. Assume the tax rate is 35 percent and the required return on the project is 14 percent. WHAT IS THE PROJECTS NPV?
Yokam Company is considering two alternative projects. Project 1 requires an initial investment of $590,000 and has a present value of cash flows of $1,850,000. Project 2 requires an initial investment of $5 million and has a present value of cash flows of $7 million. 1. Compute the profitability index for each project. Profitability Index Choose Denominator: Choose Numerator: = = Profitability Index Profitability index Project 1 Project 2
Yokam Company is considering two alternative projects. Project 1 requires an initial investment of $450,000 and has a present value of cash flows of $1,600,000. Project 2 requires an initial investment of $4 million and has a present value of cash flows of $6 million. 1. Compute the profitability index for each project. Profitability Index | Choose Denominator: Choose Numerator = Profitability Index Profitability index Project 1 Project 2
Cochrane, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $1,860,000. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $1,950,000 in annual sales, with costs of $1,060,000. The project requires an initial investment in net working capital of $150,000, and the fixed asset will have a market value of $175,000 at the end of...
Yokam Company is considering two alternative projects Project 1 requires an initial investment of 5510,000 and has a present value of cash flows of $1,200,000. Project 2 requires an initial Investment of $4 million and has a present value of cash flows of $7 milion 1. Compute the profitability Index for each project. Profitability Index Choose Denominator Choose Numerator: - Profitability Index Profitability index Project 1 Project 2 2. Based on the profitability Index, which project should the company prefer?...
1) Cochrane, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2,370,000. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $2,240,000 in annual sales, with costs of $1,230,000. Required: If the tax rate is 35 percent, what is the OCF for this project? (Do not round intermediate calculations. Enter your answer in dollars, not...
Brisk inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $1,740,757. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will be worthless. The project is estimated to generate $2,205,200 in annual sales, with costs of $1,676,180. If the tax rate is 0.33 , what is the OCF for this project?
Spokane, Inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $2.8 million. The fixed asset falls into the 3-year MACRS class (0.3333, 0.4445, 0.1481, 0.0741) and will have a market value of $214,200 after 3 years. The project requires an initial investment in net working capital of $306,000. The project is estimated to generate $2,448,000 in annual sales, with costs of $979,200. The tax rate is 34 percent and the required return on...
H. Cochran, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $3,100,000. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $3,370,000 in annual sales, with costs of $2,390,000. If the tax rate is 24 percent, what is the OCF for this project?