We must use the PV formula(under functions) in excel. We aren't allowed to hard code...
80.2K
Verified Solution
Link Copied!
Question
Finance
We must use the PV formula(under functions) in excel. We aren't allowed to hard code in the cell. Please assist us identify how to place infinite payments to find perpetuity.
An investment offers $6,100 per year for 15 years, with the first payment occurring one year from now. If the required return is 6 percent, what is the value of the investment? What would the value be if the payments occurred for 40 years? For 75 years? Forever? Payment per year # of years Required rate of return # of years # of years 6,100 15 696 40 75 Complete the following analysis. Do not hard code values in your calculations. Your answers should be positive. Value today with 15 years payments 59,244.72 Value today with 40 years payments S 91,782.41 Value today with 75 years payments S 100,380.67 Value today of perpetuity
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!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.