Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need the excel equations please we are eval

i need the excel equations please We are evaluating a...

80.2K

Verified Solution

Question

Accounting

i need the excel equations please
image
We are evaluating a project that costs $845,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 51,000 units per year. Price per unit is $53, variable cost per unit is $27, and fixed costs are $950,000 per year. The tax rate is 22 percent, and we require a return of 10 percent on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within 10 percent. Calculate the best-case and worst-case NPV figures. (Use cells A6 to 817 from the given information to complete this question. You must use the built-in Excel function to answer this question. The OCF must be calculated using the depreciation tax shield approach.)

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!
Become a Member

Other questions asked by students