USE THE DATA IN GROUP 28 (QUESTION 3) IN SOLVING 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 #1 Question 1 Question 2 Question 3 Question 4 Question 5 x 1 x2 (%)x1 x2 (%)x1 1x2 (%) x 1 x2 (%) 1 (%) x2 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% SSO 21822.000 5% $22,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% S150 4|326,0001 79% $26.000 1.00% S16,000 1.00% $3,500 7% 7% ls200 51$30,000 8% 828,000 2.00% $18,000 2.00% $4,000 8% 8% 82501 6 $30,000 9% $30,000 3.00% $10,000 3.00% $4,500 9% 9% $50 |$20,000 10% $20,000 4.00% $12.000 4.00% $5,000 10% 10% S100 S|S22,000 12% $22.000 0.25%$14,000 0.25%$2,000 12% 12% S150 9 $24,000 15% 24,000 0.50% 816,000 0.50% $2,500 15% 15% S200 10 $26.000 18% 26.000 0.75%$18.000 0.75% $3,000 18% 18% |S250 11 $28.000 20% s28.000 1.00% S10,000 1.00 $3,500 20% 20% S50 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% S150 14 $25,000 5% $22,000 4.00% S16,000 4.00% 55.000 5% 5% S200 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% S50 17 $28,000 8% $28,000 0.75% $12,000 0.75% $3,000 8% 8% S100 18 822,000 9% $30,000 1.00% S14,000 1.00% $3,500 9% 9% $150 19 $25,000 10% $20,000 2.00% $16,000 2.00% $4,000 10% 10% S2001 20 $24.000 12% S22,000 3.00% $18,000 3.00% $4,500 12% 12% $250 21 S34,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 x 1 x2 (%)x1 x2 (%) x 1 x2 (%) x 1 x2 (%)x1 (%) x2 22 $29,000 18% $26.000 0.25% S12.000 0.25%$2,000 18% 18% S100 23 s26,000 20% $28.000 0.50% S14,000 0.50% 82,500 20% 20% S150 24 $20,000 25% $20,000 0.75%$10,000 0.75%$3,500 25% 25% $50 25 $22,000 4% 822,000 2.00% S12.000 1.00% $4,000 4% 4% S100 26 $24.000 5% $25,000 2.00%|S14,000 2.00% $4,500 5% 5% S1501 27 $26,000 6% $25,000 3.00% S16,000 3.00% 35,000 6% 6% S200 28 $28,000 7% $30,000 4.00% $18,000 4.00% $2,000 7% 7% 82501 29 30,000 8% 822,000 0.75%$15.000 0.25%$2,500 8% 8% S50 30 $20,000 9% $24,000 1.00% $15,000 0.50% 55,000 9% 9% $100 31 $22,000 10% $26,000 2.00% $15,000 0.75% $4,500 10% 10% SISON 32 27,000 12% -26,000 3.00% $15,000 1.00% 55.000 12% 12% $200 33 526,000 15% $25,000 4.00% $15,000 2.00% $3,000 15% 15% |S250 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% S100 36 S25,000 25% S27,000 2.00% $18,000 1.00 $2,000 25% 25% S150 Group $50 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% S12,000 0.50% $2,500 5% 5% $100 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%|S16,000 1.00% $3,500 7% 7% $200 5 $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,500 9% 9% 7 $20,000 10% $20,000 4.00% $12,000 4.00% $5,000 10% 10% $100 8 822,000 12% $22,000 0.25%$ 14,000 0.25% S2,000 12% 12% $150 9 $24,000 15% $24,000 0.50% 816,000 0.50% $2,500 15% 15% $2001 10 S26,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% S12,000 2.00% $4,000 25% 25% S100 13 $20,000 4% $20,000 3.00% $14,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% $2,500 7% 7% $50 17 $28,000 8% $28,000 0.75% $12,000 0.75% $3.000 8% 8% $100 18 S22,000 9% $30,000 1.00% $14,000 1.00% $3,500 9% 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 S34,000 15% $24,000 4.00% S10,000 4.00% $5,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% S14,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% $12,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% $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,500 8% 8% $50 30 $20,000 9% $24,000 1.00% $15,000 0.50% $5,0009% 9% $100 31 $22,000 10% $26,000 2.00% $15,000 0.75% 84,500 10% 10% $150 32 827,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% $150 37 $29,000 9% S22,000 1.00% $12,000 3.00% $2,000 5% 5% ls3001 38 $26,000 10% $24,000 2.00% S14,000 4.00% $2,500 6% 6% 8350 39 $20,000 12% $26,000 5.00% $16,000 5.00%$3,000 7% 7% $300 40 $22,000 15% $28.000 4.00% $18,000 5.00% $3,500 12% 8% $350 Question 3: A father wants to set up a bank account that will pay his daughter $(xl) 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? 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 #1 Question 1 Question 2 Question 3 Question 4 Question 5 x 1 x2 (%)x1 x2 (%)x1 1x2 (%) x 1 x2 (%) 1 (%) x2 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% SSO 21822.000 5% $22,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% S150 4|326,0001 79% $26.000 1.00% S16,000 1.00% $3,500 7% 7% ls200 51$30,000 8% 828,000 2.00% $18,000 2.00% $4,000 8% 8% 82501 6 $30,000 9% $30,000 3.00% $10,000 3.00% $4,500 9% 9% $50 |$20,000 10% $20,000 4.00% $12.000 4.00% $5,000 10% 10% S100 S|S22,000 12% $22.000 0.25%$14,000 0.25%$2,000 12% 12% S150 9 $24,000 15% 24,000 0.50% 816,000 0.50% $2,500 15% 15% S200 10 $26.000 18% 26.000 0.75%$18.000 0.75% $3,000 18% 18% |S250 11 $28.000 20% s28.000 1.00% S10,000 1.00 $3,500 20% 20% S50 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% S150 14 $25,000 5% $22,000 4.00% S16,000 4.00% 55.000 5% 5% S200 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% S50 17 $28,000 8% $28,000 0.75% $12,000 0.75% $3,000 8% 8% S100 18 822,000 9% $30,000 1.00% S14,000 1.00% $3,500 9% 9% $150 19 $25,000 10% $20,000 2.00% $16,000 2.00% $4,000 10% 10% S2001 20 $24.000 12% S22,000 3.00% $18,000 3.00% $4,500 12% 12% $250 21 S34,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 x 1 x2 (%)x1 x2 (%) x 1 x2 (%) x 1 x2 (%)x1 (%) x2 22 $29,000 18% $26.000 0.25% S12.000 0.25%$2,000 18% 18% S100 23 s26,000 20% $28.000 0.50% S14,000 0.50% 82,500 20% 20% S150 24 $20,000 25% $20,000 0.75%$10,000 0.75%$3,500 25% 25% $50 25 $22,000 4% 822,000 2.00% S12.000 1.00% $4,000 4% 4% S100 26 $24.000 5% $25,000 2.00%|S14,000 2.00% $4,500 5% 5% S1501 27 $26,000 6% $25,000 3.00% S16,000 3.00% 35,000 6% 6% S200 28 $28,000 7% $30,000 4.00% $18,000 4.00% $2,000 7% 7% 82501 29 30,000 8% 822,000 0.75%$15.000 0.25%$2,500 8% 8% S50 30 $20,000 9% $24,000 1.00% $15,000 0.50% 55,000 9% 9% $100 31 $22,000 10% $26,000 2.00% $15,000 0.75% $4,500 10% 10% SISON 32 27,000 12% -26,000 3.00% $15,000 1.00% 55.000 12% 12% $200 33 526,000 15% $25,000 4.00% $15,000 2.00% $3,000 15% 15% |S250 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% S100 36 S25,000 25% S27,000 2.00% $18,000 1.00 $2,000 25% 25% S150 Group $50 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% S12,000 0.50% $2,500 5% 5% $100 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%|S16,000 1.00% $3,500 7% 7% $200 5 $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,500 9% 9% 7 $20,000 10% $20,000 4.00% $12,000 4.00% $5,000 10% 10% $100 8 822,000 12% $22,000 0.25%$ 14,000 0.25% S2,000 12% 12% $150 9 $24,000 15% $24,000 0.50% 816,000 0.50% $2,500 15% 15% $2001 10 S26,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% S12,000 2.00% $4,000 25% 25% S100 13 $20,000 4% $20,000 3.00% $14,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% $2,500 7% 7% $50 17 $28,000 8% $28,000 0.75% $12,000 0.75% $3.000 8% 8% $100 18 S22,000 9% $30,000 1.00% $14,000 1.00% $3,500 9% 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 S34,000 15% $24,000 4.00% S10,000 4.00% $5,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% S14,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% $12,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% $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,500 8% 8% $50 30 $20,000 9% $24,000 1.00% $15,000 0.50% $5,0009% 9% $100 31 $22,000 10% $26,000 2.00% $15,000 0.75% 84,500 10% 10% $150 32 827,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% $150 37 $29,000 9% S22,000 1.00% $12,000 3.00% $2,000 5% 5% ls3001 38 $26,000 10% $24,000 2.00% S14,000 4.00% $2,500 6% 6% 8350 39 $20,000 12% $26,000 5.00% $16,000 5.00%$3,000 7% 7% $300 40 $22,000 15% $28.000 4.00% $18,000 5.00% $3,500 12% 8% $350 Question 3: A father wants to set up a bank account that will pay his daughter $(xl) 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