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

  1. 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.

  1. 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)

  1. 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.

Question # 2 Explain the formula below for specific periods from the
10th to the 19th year based on your ID Number ( year

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!