Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help me with the excel portion of this please Use the following information to answer questions 1-6 in an Excel spreadsheet and submit the spreadsheet.
help me with the excel portion of this please
Use the following information to answer questions 1-6 in an Excel spreadsheet and submit the spreadsheet. Be sure to show your work as partial credit will be given if I can figure out where you started to go wrong. Turkey Company is considering a project which will require the purchase of $1.6 million in new equipment. The equipment will be depreciated straight-line to a zero book value over the 5-year life of the project. Turkey Company expects the sell the equipment at the end of the project for $180,000. Annual sales from this project are estimated at $1.3 million, and you will incur $100,000 in fixed costs and variable costs equal to 10% of sales. Net working capital equal to 30 percent of sales will be required to support the project and built up in the beginning. All the net working capital will be sold at the end of the project. The firm has a weighted average cost of capital (WACC) of 12 percent. The tax rate is 30 percent. 1. What is the annual depreciation amount? 2. What is the amount of the net (after-tax) salvage value of the equipment? 3. What is the recovery amount attributable to net working capital at the end of the project? 4. What is the operating cash flow each year? 5. What is the IRR of this project? 6. What is the NPV of this projectStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started