USE THE DATA IN GROUP 28 (QUESTION 1) 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 # Question 1 Question 2 Question 3 Question 4 Question 5 x 1 x2 (%)x1 JX2 (%)x1 x2 (%)x1 x2 (%) x1 (%) x2 1 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% SSO 2 $22.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% 83,000 6% 6% S150 4 $26.000 7% $26,000 1.00% S16,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 6 830,000 9% $30,000 3.00% $10,000 3.00% $4,500 9% 9% $50 7 $20,000 10% $20,000 4.00% S12.000 4.00% 55,000 10% 10% S100 8 $22,000 12% $22,000 0.25% $14,000 0.25% $2,000 12% 12% S150 9 $24,000 15% $24,000 0.50% $16,000 0.50% 82,500 15% 15% $200 10 526,000 18% $26,000 0.75%$18,000 0.75% 83.000 18% 18% S250 11 $28,000 20% $28,000 1.00% $10,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% $14.000 3.00% $4,500 4% 4% S150 14 $25,000 5% $22,000 4.00% $16,000 4.00% $5,000 5% 5% s200 15 $27,0001 6% $24,000 0.25% $18,000 0.25% $2,000 6% 6% S250 16 $30,000 7% $26,000 0.50% $10,000 0.50% $2,500 7% 7% Isso 17828,000 8% $28,000 0.75% $12,000 0.75% $3,000 8% 8% S100 18 22.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% $2001 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% $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 S29,000 18% $26,000 0.25% $12,000 0.25%$2,000 18% 18% $100 23 526,000 20% 328,000 0.50% S14,000 0.50% $2,500 20% 20% S10 24 $20,000 25% $20,000 0.75% $10,000 0.75% $3,500 25% 25% ISSO 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% S150 27 $26.000 6% $25,000 3.00% $16,000 3.00% $5,000 6% 6% S200 28 $28,000 7% $30,000 4.00% $18,000 4.00% $2,000 7% 7% S250 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% 5,000 9% 9% $100 31 $22.000 10% $26,000 2.00% $15,000 0.75% 84,5001 10% 10% S150 32 $27,000 12% -26,000 3.00% $15,000 1.00 $5,000 12% 12% S200 33 $26.0001 15% $25,000 4.00% $15.000 2.00% $3.0001 15% 15% $250 34 $28,000 18% $25,000 0.75% $15,000 3.00% $2,500 18% 18% ISSO 35 830,000 20% $25,000 1.00% $15,000 4.00% $2.000 20% 20% $100 36 $25,000 25% S27,000 2.00% $18,000 1.00%|S2,000 25% 25% S150 Group #1 Question 1 Question 2 Question 3 Question 4 Question 5 x 1 x2 (%) x 1 x2 (%)x1 JX2 (%)x1 x2 (%)X1 (%)x2 $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% 82.500 5% 5% $100 3 $24.000 6% $24,000 0.75% $14,000 0.75%$3,000 6% 6% $1501 4 $26,000 7% 26,000 1.00% $16,000 1.00% $3,500 7% 7% $2001 5 $30,000 8% $28,000 2.00% $18,000 2.00%$4,000 8% 8% $250 6 830,000 9% $30.000 3.00% $10,000 3.00% 84.5001 9% 9% $50 7 $20,000 10% $20,000 4.00% $12,000| 4.00% $5,000 10% 10% $100 8 $22,000 12% $22,000 0.25% $14,000 0.25% $2,000 12% 12% $150 9 $24,000 15% $24,000 0.50% $16,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,0004% $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% S2,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% S100 18 822,000 9% $30,000 1.00% S14,000 1.00%|$3,500 9% 9% $ 1501 19 $25,000 10% $20,000 2.00% $16,000 2.00% $4,000 10% 10% $2001 20 $24,000 12% $22,000 3.00% $18,000 3.00% $4,500 12% 12% $2501 21S34,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 X1 x2 (%)x1 x2 (%)x1 x2 (%)x1 JX2 %) 1 (%)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%|$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% $1501 27 $26,000 6% $25,000 3.00%|$16,000 3.00% $5,000 6% 6% $2001 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% 85,000 9% 9% $1001 31 $22,000 10% $26,000 2.00% $15,000 0.75% 84,500 10% 10% $150 32 $27,000 12% $26,000 3.00% $15,000 1.00% $5,000 12% 12% $2001 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% S100 36 $25.000 25% $27.000 2.00% S18.000 1.00% 82.000 25% 25% $150 37 29,000 9% $22,000 1.00% $12,000 3.00%. $2,000 5% 5% $300 38 526,000 10% $24,000 2.00% $14,000 4.00% $2,500 6% 6% $350 39 $20,000 12% $26,000 5.00% $16,000 5.00% $3,000 7% 7% $3001 40 $22,000 15% $28,000 4.00% $18,000 5.00% $3,500 12% 8% $350 Question 1: If you borrowed $xl at x2% annual interest. You agreed to repay the loan with five equal annual payments. How much of the total amount repaid is interest? How much of the third annual payment is interest, and how much principal is there? If you decided to pay off your loan after the third payment, how much will you pay