Question
1. Find the return rate than one needs in order to quadruple $5,000 in five years using the EXCEL function and verify this answer with
1. Find the return rate than one needs in order to quadruple $5,000 in five years using the EXCEL function and verify this answer with your mathematical derivation. Provide the rate formatted with 3 decimal points If instead of making a single deposit the same person deposits five payments of $2,150 in order to make the same amount as in the previous case, what is this return rate? Use the EXCEL formula only. The WI section should explain the derivation in plain English step by step in the word document use equation editor writing your mathematics. Also explain in plain English the difference between the two cases.
2.
Discuss the meaning of this mathematical expression and verify it using EXCEL FV4PV0=1+r4 i.e. a) Explain what is the meaning of the ratio FV4PV0 b) Explain what is the meaning of the term (1+r) and c) why the term (1+r) it is raised to the forth power i.e. it is multiplied to itself four times. d) Furthermore explain why there is a balance, i.e. the two terms are equal
NOTE non WI sections should provide the written explanation in there Excel sheet, while the WI section in the Word document.
Step 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