Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual...

Free

50.1K

Verified Solution

Question

Finance

Problem #4

Calculate NPV, Payback, Discounted Payback, IRR and Modified IRRfor the following project

Initial Investment: -100,000

Annual project cash flow 22,000 for 6 years

Cost of capital is 6%

Answer & Explanation Solved by verified expert
3.8 Ratings (565 Votes)

Year Cash flow PVIF @ 6% present value A Cumulative cash flow Discounted Cumulative cash flow
0 -100000     1.0000 (100,000.00) (100,000.00) (100,000.00)
1 22000     0.9434      20,754.72     (78,000.00)     (79,245.28)
2 22000     0.8900      19,579.92     (56,000.00)     (59,665.36)
3 22000     0.8396      18,471.62     (34,000.00)     (41,193.74)
4 22000     0.7921      17,426.06     (12,000.00)     (23,767.68)
5 22000     0.7473      16,439.68      10,000.00       (7,328.00)
6 22000     0.7050      15,509.13      32,000.00         8,181.14
        8,181.14      32,000.00      16,362.27
Ans 1) NPV =         8,181.14
Ans 2) Payback period =                4.55 year
=4+12000/22000
Ans 3) Discounted payback period =
=5+7328/15509.13                4.47 year
Ans 4) IRR = 8.56%
Ans 5) MIRR= 7.40%

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

Transcribed Image Text

Problem #4Calculate NPV, Payback, Discounted Payback, IRR and Modified IRRfor the following projectInitial Investment: -100,000Annual project cash flow 22,000 for 6 yearsCost of capital is 6%

Other questions asked by students