Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.
Year Payment x (1 + I )^(N t) = FV
1 100 1.1664 116.64
2 200 1.0800 216.00
3 400 1.0000 400.00
Sum of FV's = 732.64 You just need to sum, I've calculated compounding factors and FVs for you above
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 below:
PV =????
FV of PV =?????
Using Excel formulas/Wizard

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions