Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please show how you got answers in excel 1. what i

Please show how you got answers in Excel 1. What is the payback period of...

70.2K

Verified Solution

Question

Finance

Please show how you got answers in Excel

1. What is the payback period of the project? If the cut-off payback period is 3 years, should we accept or reject the project? Why?

2. What is the profitability index of the project? Should the project be accepted? Why?

3. What is the internal rate of return (IRR) of the project? Should the project be accepted? Why?

4. What is the net present value (NPV) of the project? Should the project be accepted? Why?

image

($200,0o0) ($25,00a) $260,000) Increase in accounts payable $ 200,000 $200,000 200,000 200,000 228,000 800(28,000) 44,000 63,200 480 (16,800) 26,400 37,920 $79,68D $ 91,200 $ 62,40054,720 Taxes on operating income After-tax operating income Terminal Year Cash Flows Changes in net working capital Total termination cash flow 260,000 $62,400 Required return (used as the discount ra 10% Present value of cash infows Present value of cash outflows Internal rate of return (IR

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