can you show me how to input in the PV formula for excel. everytime i...

90.2K

Verified Solution

Question

Finance

can you show me how to input in the PV formula for excel. everytime i enter in excel it comes up as an error because im placing something wrong image
M P6-44 Modified (use the modified numbers in bold below) A perpetuity pays $10,000 at the end of the Year 1, and the annual cash flows grow at a rate of 5 percent per year indefinitely. What is the present value if the appropriate discount rate is 9 percent? If the appropriate discount ratels 7 percent? Hint: See formula 6-6 on page 173 Perpetuity PMI o 1 2 10,000 5% 9 PV $0.00 Perpetuity PMI 10,000 OX OX PV 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 32 33 34 39 36 37

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