Please calculate dollars invested for each year for each investment, also calculate ending balance at year 5, show answers please as this is due tonight and wanna make sure it is correct. poking Glasslomework iesWeek 4: Modeling 202310 BAD305-US IntrodNew Exercise Bank Content Qu. 07-10Al Ferris has $20,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years.After consulting with his financial advisor, he has been offered four types of fixed-income investments, which we will label asinvestments A, B, C, and D. Investments A and B are available at the beginning of each of the next five years (call them years 1 to 5).Each dollar invested in A at the beginning of a year returns $1.40 (a profit of $0.40) two years later (in time for immediatereinvestment). Each dollar invested in B at the beginning of a year returns $1.70 three years later. Investments C and D will each beavailable at one time in the future. Each dollar invested in C at the beginning of year 2 returns $1.90 at the end of year 5. Each dollarinvested in D at the beginning of year 5 returns $1.30 at the end of year 5.Click here for the Excel Data FileFormulate and solve a linear programming model for this problem on a spreadsheet.a. Which investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?b. Determine the ending balance at the end of year 5.Complete this question by entering your answers in the tabs below.Required A Required BDollars investedWhich investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?Note: Leave no cells blank. Enter zero (0) whenever required.Year 1Investment AYear 3Year 2Year 4€Year 1Required AInvestment BYear 2SavedYear 3Required BInvestment CYear 2Investment DYear 5 poking Glasslomework iesWeek 4: Modeling 202310 BAD305-US IntrodNew Exercise Bank Content Qu. 07-10Al Ferris has $20,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years.After consulting with his financial advisor, he has been offered four types of fixed-income investments, which we will label asinvestments A, B, C, and D. Investments A and B are available at the beginning of each of the next five years (call them years 1 to 5).Each dollar invested in A at the beginning of a year returns $1.40 (a profit of $0.40) two years later (in time for immediatereinvestment). Each dollar invested in B at the beginning of a year returns $1.70 three years later. Investments C and D will each beavailable at one time in the future. Each dollar invested in C at the beginning of year 2 returns $1.90 at the end of year 5. Each dollarinvested in D at the beginning of year 5 returns $1.30 at the end of year 5.Click here for the Excel Data FileFormulate and solve a linear programming model for this problem on a spreadsheet.a. Which investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?b. Determine the ending balance at the end of year 5.Complete this question by entering your answers in the tabs below.Required A Required BDollars investedWhich investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?Note: Leave no cells blank. Enter zero (0) whenever required.Year 1Investment AYear 3Year 2Year 4€Year 1Required AInvestment BYear 2SavedYear 3Required BInvestment CYear 2Investment DYear 5

Question

Please calculate dollars invested for each year for each investment, also calculate ending balance at year 5, show answers please as this is due tonight and wanna make sure it is correct. poking Glasslomework iesWeek 4: Modeling 202310 BAD305-US IntrodNew Exercise Bank Content Qu. 07-10Al Ferris has $20,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years.After consulting with his financial advisor, he has been offered four types of fixed-income investments, which we will label asinvestments A, B, C, and D. Investments A and B are available at the beginning of each of the next five years (call them years 1 to 5).Each dollar invested in A at the beginning of a year returns $1.40 (a profit of $0.40) two years later (in time for immediatereinvestment). Each dollar invested in B at the beginning of a year returns $1.70 three years later. Investments C and D will each beavailable at one time in the future. Each dollar invested in C at the beginning of year 2 returns $1.90 at the end of year 5. Each dollarinvested in D at the beginning of year 5 returns $1.30 at the end of year 5.Click here for the Excel Data FileFormulate and solve a linear programming model for this problem on a spreadsheet.a. Which investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?b. Determine the ending balance at the end of year 5.Complete this question by entering your answers in the tabs below.Required A Required BDollars investedWhich investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?Note: Leave no cells blank. Enter zero (0) whenever required.Year 1Investment AYear 3Year 2Year 4€Year 1Required AInvestment BYear 2SavedYear 3Required BInvestment CYear 2>Investment DYear 5 poking Glasslomework iesWeek 4: Modeling 202310 BAD305-US IntrodNew Exercise Bank Content Qu. 07-10Al Ferris has $20,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years.After consulting with his financial advisor, he has been offered four types of fixed-income investments, which we will label asinvestments A, B, C, and D. Investments A and B are available at the beginning of each of the next five years (call them years 1 to 5).Each dollar invested in A at the beginning of a year returns $1.40 (a profit of $0.40) two years later (in time for immediatereinvestment). Each dollar invested in B at the beginning of a year returns $1.70 three years later. Investments C and D will each beavailable at one time in the future. Each dollar invested in C at the beginning of year 2 returns $1.90 at the end of year 5. Each dollarinvested in D at the beginning of year 5 returns $1.30 at the end of year 5.Click here for the Excel Data FileFormulate and solve a linear programming model for this problem on a spreadsheet.a. Which investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?b. Determine the ending balance at the end of year 5.Complete this question by entering your answers in the tabs below.Required A Required BDollars investedWhich investment plan maximizes the amount of money that can be accumulated by the beginning of year 6?Note: Leave no cells blank. Enter zero (0) whenever required.Year 1Investment AYear 3Year 2Year 4€Year 1Required AInvestment BYear 2SavedYear 3Required BInvestment CYear 2>Investment DYear 5

Accepted Answer

Decision variableLet At, Bt, Ct, and Dt be the amount invested in investment A, B, C, and D,…