can you show me how to input in the PV formula for excel. everytime i...
90.2K
Verified Solution
Link Copied!
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
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!