Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need help with the excel file. the yellow table

i need help with the excel file. the yellow table and the red boxes. thanks...

80.2K

Verified Solution

Question

Accounting

i need help with the excel file. the yellow table and the red boxes.
thanks image
image
NPV - Investment Analysis Ch 12 Problem \#9: You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck for $60,000. The truck falls into the MACRS 3 3-year class, and it will be sold after three years for $20,000. The use of the truck will require an increase in NWC (spare parts inventory) of $2,000. The truck will have no effect on revenues, but it is expected to save the firm $20,000 per year in before-tax operating costs, mainly labor. The firm's marginal tax rate is 40 percent, an opportunity cost of capital of 8 percent. What will the cash flows for this project be? Ch 12.9 Deliverable (100 total points): Complete the Ch 12 Problem \#9 Excel worksheet and answer the following questions ( 50 points). Q.3 What will the cash flows for this project be? (25 points) Q.4 According to the Management Report, should KADS go forward with the project? (25 points) Explain your answers in detail using the Capital Budgeting key topic and tools in Ch 13 and Ch 13 from the M: Finance textbook readings

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