Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fill in the yellow boxes and can you show me the steps Find the PV and the FV of an investment that makes the following
fill in the yellow boxes and can you show me the steps
Find the PV and the FV of an investment that makes the following end-of-year payments. The interest rate is 8%. To find the PV, use the NPV function: PV = Excel does not have a function for the sum of the future values for a set of uneven payments. Therefore, we must find this FV by some other method. Probably the easiest procedure is to simply compound each payment, then sum them, as is done below. Note that since the payments are received at the end of each year, the first payment is compounded for 2 years, the second for 1 year, and the third for 0 years. An alternative procedure for finding the FV would be to find the PV of the series using the NPV function, then compound that amount for 3 years at 8%, as is done belowStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started