Question: Solve the NPV and would you accept the project why or why not? Show work on excel screenshot please! -thank You The BJR golf company

Solve the NPV and would you accept the project why or why not? Show work on excel screenshot please!
-thank You
The BJR golf company is thinking of opening a new production facility. Key data are shown below. BJR already owns a building that is suitable for this purpose. There is, however, a developer who has offered $250,000 for the building which would net BJR $175,000 after taxes if BIR decides not to use the existing building for the production facility. The production equipment necessary for the project would be fully depreciated on a straight line basis by the end of the project's 4 year life (ie book value will equal O), The working capital investment that BJR must make in the first year of the project is expected to be recouped in year 5. Revenues and operating expenses will be constant over the life of the project. Model the opportunity as if the existing building would be used for the new facility. What is this project's NPV? Round to whole dollars please. Would you accept this project, why or why not? WACC 12% Production Equipment Cost $ 135,000 Straight Line Depreciation Each Year 25% (included in Operating Expenses) Annual Revenue $ 250,000 Annual COGS $ 70,000 Annual Operating Expenses $ 70,000 Tax Rate 22% Days of Accounts Receivable Outstanding 42 days Inventory Turnover 4 x Accounts Payable Days Outstanding 30 days YEAR 2 Fill In your Model and Calculate NPV The BJR golf company is thinking of opening a new production facility. Key data are shown below. BJR already owns a building that is suitable for this purpose. There is, however, a developer who has offered $250,000 for the building which would net BJR $175,000 after taxes if BIR decides not to use the existing building for the production facility. The production equipment necessary for the project would be fully depreciated on a straight line basis by the end of the project's 4 year life (ie book value will equal O), The working capital investment that BJR must make in the first year of the project is expected to be recouped in year 5. Revenues and operating expenses will be constant over the life of the project. Model the opportunity as if the existing building would be used for the new facility. What is this project's NPV? Round to whole dollars please. Would you accept this project, why or why not? WACC 12% Production Equipment Cost $ 135,000 Straight Line Depreciation Each Year 25% (included in Operating Expenses) Annual Revenue $ 250,000 Annual COGS $ 70,000 Annual Operating Expenses $ 70,000 Tax Rate 22% Days of Accounts Receivable Outstanding 42 days Inventory Turnover 4 x Accounts Payable Days Outstanding 30 days YEAR 2 Fill In your Model and Calculate NPV
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
