A YEARS 1 2 3 B DEPOSITS@THE BEGGING OF A YEAR $100 $100 $150 $25 0...

Transcribed Image Text:

A YEARS 1 2 3 B DEPOSITS@THE BEGGING OF A YEAR $100 $100 $150 $25 0 $25 0 $20 0 $10 4 $200 5 $400 $50 You should evaluate the value if these financial flows at the beginning of the first year (indicated as 0) as well as the future value at the end of the 5th year using the EXCEL formulas PV, FV & NPV as well as the appropriate mathematical formulas for the return (discount) rate you decide. Use the FORMULATEXT function to indicate the formulas you use. Mark with a background color the cells you use to drag and have all evaluations. Explain the difference of the return rate from the discount rate, and the functions you use. 0 A YEARS 1 2 3 B DEPOSITS@THE BEGGING OF A YEAR $100 $100 $150 $25 0 $25 0 $20 0 $10 4 $200 5 $400 $50 You should evaluate the value if these financial flows at the beginning of the first year (indicated as 0) as well as the future value at the end of the 5th year using the EXCEL formulas PV, FV & NPV as well as the appropriate mathematical formulas for the return (discount) rate you decide. Use the FORMULATEXT function to indicate the formulas you use. Mark with a background color the cells you use to drag and have all evaluations. Explain the difference of the return rate from the discount rate, and the functions you use. 0

Answer rating: 100% (QA)

For this problem I will calculate the present value future value and net present value using Excel f... View the full answer