Question: Question # 2 Explain the formula below for specific periods from the 10 th to the 19 th year based on your ID Number (
Question # 2
- Explain the formula below for specific periods from the 10th to the 19th year based on your ID Number ( year 19th ) . What are the specific variables in their specific subscripts? What is the meaning of the addition and the equation?
(I)
Use EXCEL and validate your explanation of my math.
- Why factoring and distributing are equivalent operations? Use (II) as an example for the same specific period you used in 2a. Explain in English and validate in Excel.
(II)
- Why do you substitute and what mathematical formula simplifies the right side of the equation? Explain in English and validate in Excel.
(III)
Question # 3
Now that you know that a Future Value at any period is dependent of the Present Value at the beginning of the period, the Return Rate and the Number of Periods, can you solve it for a) the Present Value at the beginning of the period, b) the Return Rate and c) the Number of Periods? Explain what happens and why, i.e. why do you divide, how and why do you simplify, how roots are related to powers and what do they do, and how powers are related to logarithms. Use the material I had provided to you. I need to explain what I explained to you and understand what you learn mechanically in your algebra. When you have equations, I need you to validate in EXCLEL that indeed, what you calculate are equal in value.

out References Mailings Review View Tell me Aa v A 21 AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBb CcDdEx Normal No Spacing Heading 1 Heading 2 10 11 12 14 15 16 17 2 alphabet, as 1a for FV, 1b for PV etc. Question #2 a) Explain the formula below for specific periods from the 10th to the 19th year based on your ID Number (year 19). What are the specific variables in their specific subscripts? What is the meaning of the addition and the equation? FV; = FV-1 +r FVi-1 (0) Use EXCEL and validate your explanation of my math. b) Why factoring and distributing are equivalent operations? Use (II) as an example for the same specific period you used in 2a. Explain in English and validate in Excel. FV-1 +r FV-1 = FV-1(1+r) c) Why do you substitute and what mathematical formula simplifies the right side of the equation? Explain in English and validate in Excel. FVi-1(1+r) = PV,(1+r)-1(1+r) (111) Question #3 ed States) Focus Question #3 Now that you know that a Future Value at any period is dependent of the Present Value at the beginning of the period, the Return Rate and the Number of Periods, can you solve it for a) the Present Value at the beginning of the period, b) the Return Rate and c) the Number of Periods? Explain what happens and why, i.e. why do you divide, how and why do you simplify, how roots are related to powers and what do they do, and how powers are related to logarithms. Use the material I had provided to you. I need to explain what I explained to you and understand what you learn mechanically in your algebra. When you have equations, I need you to validate in EXCLEL that indeed, what you calculate are equal in value. out References Mailings Review View Tell me Aa v A 21 AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBb CcDdEx Normal No Spacing Heading 1 Heading 2 10 11 12 14 15 16 17 2 alphabet, as 1a for FV, 1b for PV etc. Question #2 a) Explain the formula below for specific periods from the 10th to the 19th year based on your ID Number (year 19). What are the specific variables in their specific subscripts? What is the meaning of the addition and the equation? FV; = FV-1 +r FVi-1 (0) Use EXCEL and validate your explanation of my math. b) Why factoring and distributing are equivalent operations? Use (II) as an example for the same specific period you used in 2a. Explain in English and validate in Excel. FV-1 +r FV-1 = FV-1(1+r) c) Why do you substitute and what mathematical formula simplifies the right side of the equation? Explain in English and validate in Excel. FVi-1(1+r) = PV,(1+r)-1(1+r) (111) Question #3 ed States) Focus Question #3 Now that you know that a Future Value at any period is dependent of the Present Value at the beginning of the period, the Return Rate and the Number of Periods, can you solve it for a) the Present Value at the beginning of the period, b) the Return Rate and c) the Number of Periods? Explain what happens and why, i.e. why do you divide, how and why do you simplify, how roots are related to powers and what do they do, and how powers are related to logarithms. Use the material I had provided to you. I need to explain what I explained to you and understand what you learn mechanically in your algebra. When you have equations, I need you to validate in EXCLEL that indeed, what you calculate are equal in value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
