USE DATA FROM GROUP 28 (QUESTION 3) TO SOLVE THE QUESTION

GUIDELINES: Solve the following 5 questions on this word document (typed not hand written), in the given space underneath each question (you can add more space if needed), write the complete equations used (e.g. P=A(P/A, 12%, 5)+ F(P/F,12%,5)) and substitute the values of the factors to find the final answer. Draw the cash flow diagram when applicable. Each question is stated in terms of variables (x1, x2). Refer to the below table for the values of the variables (x1, x2) for your group. Submit the assignment on the MS-Teams, do not send it by email. Only one of the students in the group should submit it. Don't send multiple files. Assignment due date is Tuesday @ 11:00 pm. Don't wait for the last day to submit your assignment, late assignments will not be accepted. There is no excuse for internet problems. Group Question 1 Question 2 Question 3 Question 4 Question 5 x 1 x2 (%)x1 1x2 (%)X1 x2 (%)x1 x2 (%) x1 (%)2 1 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% S50 2 $22.000 5% S22,000 0.50% $12.000 0.50% $2,500 5% 5% S100 3 $24,000 6% $24,000 0.75% $14.000 0.75% $3,000 6% 6% $150 4 $26.000 7% $26,000 1.00% $16,000 1.00% $3,500 7% 7% s200 5 $30,000 8% $28,000 2.00% $18,000 2.00%$4.000 8% 8% S250 6S30,000 9% $30,000 3.00% $10,000 3.00% $4,500 9% 9% $50 7 $20,000 10% $20,000 4.00% $12.000 4.00% $5,000 10% 10% S100 8 822,000 12% 22,000 0.25% $14,000 0.25% $2,000 12% 12% $150 9 $24.000 15% $24,000 0.50% 816,000 0.50% $2,500 15% 15% $200 10 26.000 18% $26,000 0.75% $18,000 0.75%$3,000 18% 18% S250 11 $28.000 20% $28.000 1.00% $10,000 1.00% 53,500 20% 20% $50 12 $30,000 25% $30,000 2.00% $12,000 2.00% $4,000 25% 25% $100 13 $20,000 4% $20,000 3.00% S14,000 3.00% 54,500 4% 4% 8150 14 $25,000 5% $22.000 4.00% $16,000 4.00% 5.000 5% 5% $200 15 $27.0001 6% $24.000 0.25% $18,000 0.25% $2.000 6% 6% S250 16 830,000 7% $26,000 0.50% $10,000 0.50% 82,500 7% 7% SSO 17 828,000 8% 828,000 0.75% $12,000 0.75% $3,000 8% 8% $100 18 $22,000 9% $30,000 1.00% $14.000 1.00% $3,500 9% 9% SISO 19 $25,000 10% $20,000 2.00% $16,000 2.00% $4,000 10% 10% S200 20 $24,000 12% $22,000 3.00% $18,000 3.00% $4,500 12% 12% $250 21 534,000 15% $24,000 4.00% $10,000 4.00% $5,000 15% 15% $50 Group # Question 1 Question 2 Question 3 Question 4 Question 5 1x 1 x2 (%)x1 x2 (%) x1 x2 (%)x1 x2 %x1 (%) x2 22 s29,000 18% $26.000 0.25% $12,000 0.25% $2.000 18% 18% $100 23 s26,000 20% $28,000 0.50% $14,000 0.50% 82,500 20% 20% S150 24 $20,000 25% S20,000 0.75% $10,000 0.75%$3,500 25% 25% $50 25 $22,000 4% $22.000 2.00% S12.000 1.00%$4.000 4% 4% $100 26 $24.000 5% |$25,000 2.00% $14,000 2.00% $4,5005% 5% S150 27 $26,0001 6% $25,000 3.00% S16,000 3.00% 5.000 6% 6% $200 28 $28.000 7% $30,000 4.00% $18.000 4.00% $2.000 7% 7% S250 29 $30,000 8% $22.000 0.75% $15.000 0.25% $2,500 8% 8% sso 30 520,000 9% $24,000 1.00% $15,000 0.50% 5,000 9% 9% S100 31 $22,000 10% $26,000 2.00% $15,000 0.75% $4,500 10% 10% S150 32 $27.000) 12% s26,000 3.00% $15.000 1.00% $5,000 12% 12% s200 33 $26,000 15% $25,000 4.00% $15.000 2.00%$3,000 15% 15% 3250 34 828,000 18% $25,000 0.75% $15,000 3.00% $2,500 18% 18% $50 35 $30.000 20% $25,000 1.00% $15.000 4.00% $2,000 20% 20% $100 36 $25,000 25% $27,000 2.00% $18,000 1.00 $2,000 25% 25% S150 Group # Question 1 Question 2 Question 3 Question 4 Question 5 X1 X2 (%)x1 X2 (%)x1 x2 (%)x1 x2 (%)x1 ()x2 1 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000| 4% 4% $50 2 $22,000 5% $22,000 0.50% $12,000 0.50% $2,500 5% 5% $100 3 $24,000 6% $24,000 0.75% S14,000 0.75% 83,000 6% 6% S150 4 $26,000 7% $26.000 1.00% $16,000 1.00% $3,500 7% 7% $200 Sl$30,000 8% $28,000 2.00% $18,000 2.00% $4,000 8% 8% $250 6 $30,000 9% $30,000 3.00% $10,000 3.00% $4,5001 9% 9% $50 7 $20.000 10% $20,000 4.00% S12,000 4.00% 55.000 10% 10% $100 8 $22.000 12% $22.000 0.25% $14,000 0.25% $2.0001 12% 12% $150 9 $24,000 15% $24,000 0.50% 816,000 0.50% 82,500 15% 15% $200 10 26,000 18% $26,000 0.75% $18,000 0.75%$3,000 18% 18% $250 11 $28,000 20% $28,000 1.00% $10,000 1.00% $3,500 20% 20% $50 12 $30,000 25% $30,000 2.00% $12,000 2.00% $4.000 25% 25% $100 13 $20,000 4% $20,000 3.00% S14,000 3.00% $4,500 4% 4% $150 14 $25,000 5% $22,000 4.00% $16,000 4.00% $5,000 5% 5% $200 15 $27,000 6% $24,000 0.25% $18,000 0.25% $2,000 6% 6% $250 16]$30,000 7% $26.000 0.50% $10,000 0.50% 82,500 7% 7% $50 17 $28,000 8% $28,000 0.75% $12,000 0.75% $3,000 8% 8% $100 18 $22.000 9% $30,000 1.00% 14,000 1.00% $3,5009% 9% $150 19 $25,000 10% $20,000 2.00% $16,000 2.00% $4,000 10% 10% $200 20 $24,000 12% $22,000 3.00% $18,000 3.00% $4,500 12% 12% $250 21 $34,000 15% $24,000 4.00% $10,000 4.00% 55,000 15% 15% $50 Group # Question 1 Question 2 Question 3 Question 4 Question 5 x 1 x2 %x1 x2 (%)x1 x2 (%)X1 x2 (%)x1 () x2 22 $29,000 18% $26,000 0.25% $12,000 0.25% $2,000 18% 18% $100 23 $26,000 20% $28,000 0.50% $14,000 0.50% $2,500 20% 20% $150 24 $20,000 25% $20,000 0.75% $10,000 0.75% $3,500 25% 25% $50 25 $22,000 4% $22,000 2.00%|S12,000 1.00% $4,000 4% 4% $100 26 $24,000 5% $25,000 2.00%|S14,000 2.00% $4,500 5% 5% $150 27 $26,000 6% $25,000 3.00%|S16,000 3.00% 5,000 6% 6% $200 28 $28,000 7% $30,000 4.00% $18,000 4.00% $2,000 7% 7% $250 29 $30,000 8% $22,000 0.75% $15,000 0.25% $2,5001 8% 8% $50 30 $20,000 9% $24,000 1.00% $15,000 0.50% 85,000 9% 9% $100 31 822,000 10% $26.000 2.00% 15,000 0.75% $4,5001 10% 10% $150 32 $27.000 12% $26,000 3.00% $15,000 1.00% $5,000 12% 12% $200 33 $26,000 15% $25,000 4.00% $15,000 2.00% $3,000 15% 15% $250 34 $28,000 18% $25,000 0.75% $15,000 3.00% $2,500 18% 18% $50 35 $30,000 20% $25,000 1.00% $15,000 4.00% $2,000 20% 20% $100 36 $25,000 25% $27,000 2.00% $18,000 1.00%2,000 25% 25% S150 37 $29,000 9% $22,000 1.00% $12,000 3.00% $2.000 5% 5% $300 38 $26,000 10% $24,000 2.00% $14,000 4.00% S2,500 6% 6% $350 39 $20,000 12% S26,000 5.00% $16,000 5.00% $3,000 7% 7% $300 40 $22,000 15% $28.000 4.00% $18,000 5.00% 53,500 12% 8% $350 Question 3: A father wants to set up a bank account that will pay his daughter $(x1) at the end-of- quarter (EOQ) 4 and $(2xl) at EOQ 8. He will fund this account by making quarterly payments of $A from the present (time zero) through EOQ 7. If the quarterly percentage rate is x2%, what is the value $A that must be deposited into the account