Answered step by step
Verified Expert Solution
Question
1 Approved Answer
USE DATA ON GROUP 28 (QUESTION 4) TO SOLVE THE QUESTION GUIDELINES: Solve the following 5 questions on this word document (typed not hand written),
USE DATA ON GROUP 28 (QUESTION 4) 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 x2 (%)X1 X2 (%)x1 x2 (%)x1 (%) x2 1 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% $50 2S22,000 5% $22,000 0.50% $12,000 0.50% 82,500 5% 5% S100 3 $24.000 6% $24,000 0.75% $14,000 0.75%$3.000 6% 6% S150 4 $26,000 7% $26,000 1.00% S16,000 1.00% $3,500 7% 7% s2001 5 $30,000 8% $28,000 2.00% $18,000 2.00% $4,000 8% 8% S250 6 $30,0001 9% $30.000 3.00% $10,000 3.00% $4,500 9% 9% S50 7 $20.000 10% $20,000 4.00% $12,000 4.00% $5,000 10% 10% S100 8 $22.000 12% 22,000 0.25% S14,000 0.25%$2,000 12% 12% S150 9 $24,000 15% $24,000 0.50% S16,000 0.50% $2,500 15% 15% $200 10 $26.0001 18% $26.000 0.75% $18,000 0.75% 83.000 18% 18% IS250 11$28.000 20% S28.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% S100 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% $16,000 4.00% $5,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% $2,500 7% 7% $50 17 828,000 8% $28,000 0.75% $12,000 0.75%$3,000 8% 8% $100 18 822,000 9% $30,000 1.00% $14.000 1.00% $3,500 9% 9% S150 19 $25,000 10% $20,000 2.00% S16,000 2.00% $4,000 10% 10% $200 20 $24,000 12% S22,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 x1 x2 %x1 x2 (%)x1 X2 (%)x1 X2 %) 1 (%)2 22 S29,000 18% $26,000 0.25% $12,000 0.25% S2,000 18% 18% $100 23 S26,000 20% $28,000 0.50% $14,000 0.50% $2,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% $22.000 2.00% S12.000 1.00% $4.000 4% 4% S100 26 $24,000 5% $25,000 2.00% $14,000 2.00% $4,500 5% 5% $150 27 326,000 6% $25,000 3.00% S16,000 3.00% 55,000 6% 6% ls200 28 $28,000 7% $30,000 4.00% $18.000 4.00% $2.000 7% 7% 250 29 830,000 8% $22.000 0.75% $15.000 0.25%$2,500 8% 8% S50 30 S20,0001 9% $24,000 1.00% $15,000 0.50% $5,000 9% 9% S100 31 $22.0001 10% $26.000 2.00% $15,000 0.75% $4,500 10% 10% S150 32 $27,000 12% -26,000 3.00% $15.000 1.00% 45,000 12% 12% s200 33 $26,000 15% $25,000 4.00% $15,000 2.00% $3,000 15% 15% 3250 34 $28.000 18% $25,000 0.75% $15.000 3.00% $2,500 18% 18% S50 35 $30,000 20% $25,000 1.00% $15,000 4.00%|S2,000 20% 20% S1001 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 x 1 x2 (%)x1 x2 (%)x1 x2 (%) x 1 x2 (%x1 (%)x2 1 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% $50 2 822,000 5% $22,000 0.50% S12,000 0.50% $2,5005% 5% $100 3 $24.000 6% $24,000 0.75% S14,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 $30,000 9% $30,000 3.00% $10,000 3.00% $4,500 9% 9% S50 7 $20,000 10% $20,000 4.00% $12,000 4.00% 55.000 10% 10% $1001 8 $22,000 12% $22,000 0.25% $14,000 0.25% $2,000 12% 12% $1501 9824,000 15% $24,000 0.50% 816,000 0.50% $2,500 15% 15% $200 10 S26,000 18% $26.000 0.75% $18,000 0.75% $3,000 18% 18% IS250 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% $1001 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% S16,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|S22,000 9% $30,000 1.00% $14,000 1.00% $3,500 9% 9% S150 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% $2501 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% $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% 6% $2001 28/828,000 7% $30,000 4.00% $18,000|4.00% $2,000 7% 7% $2501 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,000 9% 9% $100 31 $22,000 10% $26,000 2.00%|$15,000 0.75% $4,500 10% 10% $1501 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% $2501 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% 82.00025% 25% $150 37 $29.000 9% $22,000 1.00% 12,000 3.00% 52,000 5% 5% $300 38 $26,000 10% $24,000 2.00% S14,000 4.00% $2,500 6% 6% $350 39$20,000 12% $26,000 5.00% S16,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 4: Major overhaul expenses of $x, each are anticipated for a large piece of equipment. The expenses will occur at EOY four and will continue every three years thereafter up to and including year 13. If the interest rate is x,% per year, What is the present equivalent of the overhaul expenses at time 0? What is an annual equivalent expense during only years 5-13? 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 x2 (%)X1 X2 (%)x1 x2 (%)x1 (%) x2 1 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% $50 2S22,000 5% $22,000 0.50% $12,000 0.50% 82,500 5% 5% S100 3 $24.000 6% $24,000 0.75% $14,000 0.75%$3.000 6% 6% S150 4 $26,000 7% $26,000 1.00% S16,000 1.00% $3,500 7% 7% s2001 5 $30,000 8% $28,000 2.00% $18,000 2.00% $4,000 8% 8% S250 6 $30,0001 9% $30.000 3.00% $10,000 3.00% $4,500 9% 9% S50 7 $20.000 10% $20,000 4.00% $12,000 4.00% $5,000 10% 10% S100 8 $22.000 12% 22,000 0.25% S14,000 0.25%$2,000 12% 12% S150 9 $24,000 15% $24,000 0.50% S16,000 0.50% $2,500 15% 15% $200 10 $26.0001 18% $26.000 0.75% $18,000 0.75% 83.000 18% 18% IS250 11$28.000 20% S28.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% S100 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% $16,000 4.00% $5,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% $2,500 7% 7% $50 17 828,000 8% $28,000 0.75% $12,000 0.75%$3,000 8% 8% $100 18 822,000 9% $30,000 1.00% $14.000 1.00% $3,500 9% 9% S150 19 $25,000 10% $20,000 2.00% S16,000 2.00% $4,000 10% 10% $200 20 $24,000 12% S22,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 x1 x2 %x1 x2 (%)x1 X2 (%)x1 X2 %) 1 (%)2 22 S29,000 18% $26,000 0.25% $12,000 0.25% S2,000 18% 18% $100 23 S26,000 20% $28,000 0.50% $14,000 0.50% $2,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% $22.000 2.00% S12.000 1.00% $4.000 4% 4% S100 26 $24,000 5% $25,000 2.00% $14,000 2.00% $4,500 5% 5% $150 27 326,000 6% $25,000 3.00% S16,000 3.00% 55,000 6% 6% ls200 28 $28,000 7% $30,000 4.00% $18.000 4.00% $2.000 7% 7% 250 29 830,000 8% $22.000 0.75% $15.000 0.25%$2,500 8% 8% S50 30 S20,0001 9% $24,000 1.00% $15,000 0.50% $5,000 9% 9% S100 31 $22.0001 10% $26.000 2.00% $15,000 0.75% $4,500 10% 10% S150 32 $27,000 12% -26,000 3.00% $15.000 1.00% 45,000 12% 12% s200 33 $26,000 15% $25,000 4.00% $15,000 2.00% $3,000 15% 15% 3250 34 $28.000 18% $25,000 0.75% $15.000 3.00% $2,500 18% 18% S50 35 $30,000 20% $25,000 1.00% $15,000 4.00%|S2,000 20% 20% S1001 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 x 1 x2 (%)x1 x2 (%)x1 x2 (%) x 1 x2 (%x1 (%)x2 1 $18,000 4% $20,000 0.25% $10,000 0.25% $2,000 4% 4% $50 2 822,000 5% $22,000 0.50% S12,000 0.50% $2,5005% 5% $100 3 $24.000 6% $24,000 0.75% S14,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 $30,000 9% $30,000 3.00% $10,000 3.00% $4,500 9% 9% S50 7 $20,000 10% $20,000 4.00% $12,000 4.00% 55.000 10% 10% $1001 8 $22,000 12% $22,000 0.25% $14,000 0.25% $2,000 12% 12% $1501 9824,000 15% $24,000 0.50% 816,000 0.50% $2,500 15% 15% $200 10 S26,000 18% $26.000 0.75% $18,000 0.75% $3,000 18% 18% IS250 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% $1001 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% S16,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|S22,000 9% $30,000 1.00% $14,000 1.00% $3,500 9% 9% S150 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% $2501 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% $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% 6% $2001 28/828,000 7% $30,000 4.00% $18,000|4.00% $2,000 7% 7% $2501 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,000 9% 9% $100 31 $22,000 10% $26,000 2.00%|$15,000 0.75% $4,500 10% 10% $1501 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% $2501 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% 82.00025% 25% $150 37 $29.000 9% $22,000 1.00% 12,000 3.00% 52,000 5% 5% $300 38 $26,000 10% $24,000 2.00% S14,000 4.00% $2,500 6% 6% $350 39$20,000 12% $26,000 5.00% S16,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 4: Major overhaul expenses of $x, each are anticipated for a large piece of equipment. The expenses will occur at EOY four and will continue every three years thereafter up to and including year 13. If the interest rate is x,% per year, What is the present equivalent of the overhaul expenses at time 0? What is an annual equivalent expense during only years 5-13Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started