You have been hired as a financial consultant by PJ corporation. PJ is considering investing...
50.1K
Verified Solution
Link Copied!
Question
Accounting
You have been hired as a financial consultant by PJ corporation. PJ is considering investing in a new machine to produce dog biscuits. PJ has provided you with the following information: Full price of machine is $100,000. The machine will not require any modification or increase in net working capital. PJ has a 30% marginal tax rate. The machine falls into the MACRS 3-year class. PJ will use the machine for 4 years and then plans to sell it for $15,000 at the end of year 4. The machine is expected to increase earnings before depreciation by $35,000 a year for the life of the machine. PJ has a WACC of 12%. You have been hired by PJ to create a spreadsheet that can be used by the PJ managers to assist them in making the investment decision and will calculate the NPV of the project. The spreadsheet should be set up to allow for sensitivity analysis to be conducted. The cells to input the full price, tax rate, increased earnings, sale price in year 4, and WACC should be easily identified and allow the PJ managers to change their values. Please explain your recommendation and attach the spreadsheet showing the calculations.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!