Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. what is the present value of an asset that pays th

what is the Present Value of an asset that pays the following cash flows, if...

90.2K

Verified Solution

Question

Finance

image

what is the Present Value of an asset that pays the following cash flows, if you can invest them at a rate of return of 5%? Time Period Cash Flow 0 2 4 75 75 75 75 75 Note: this is an 'ordinary annuity', it is the default assumption for both Excel and your financial calculator. a) Identify the assumptions given in this problem Rate of Return # of years Annual Payment Future Value b) Solve this problem using the "PV" Function in Excel Present Value c) Solve this problem using the "NPV" function in Excel. Present Value d) Solve this problem by hand, as follows PV of cash flow in year 1 PV of cash flow in year 2 PV of cash flow in year 3 PV of cash flow in year 4 PV of cash flow in year 5 PV of Cash Flows (years 1:5) e) Solve this problem using your financial calculator: Present Value g) How much would you be willing to pay for this asset today? Explain your reasoning

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