U. JUNE US pruum USING Excel. (5 marks) 4 Duane is considering three different television news stocks to complement his portfolio: Anika Television Company (ABC), Corey Broadcasting System (CBS), and the Naomi Broadcasting Company (NBC). His broker has given him the following information: Dividend Rate Short Term Growth (per $ invested) 0.39 0.26 0.42 ABC CBS NBC Intermediate Growth (per $ invested) 1.59 1.70 1.45 8% Duane's investment requirements are as follows: (1) the investment should yield short term growth of at least $1000 (preferably more); (2) the investment should yield intermediate term growth of at least $6000 (again more is better); and (3) the dividends (dividends represent the amount of company profits that is paid out to shareholders of the company) should be at least $250 per year. Determine the least amount that Duane can invest and how that investment should be distributed between the three stocks. C. Formulate this problem algebraically (5 marks) d. Solve this problem using Excel. (5 marks) U. JUNE US pruum USING Excel. (5 marks) 4 Duane is considering three different television news stocks to complement his portfolio: Anika Television Company (ABC), Corey Broadcasting System (CBS), and the Naomi Broadcasting Company (NBC). His broker has given him the following information: Dividend Rate Short Term Growth (per $ invested) 0.39 0.26 0.42 ABC CBS NBC Intermediate Growth (per $ invested) 1.59 1.70 1.45 8% Duane's investment requirements are as follows: (1) the investment should yield short term growth of at least $1000 (preferably more); (2) the investment should yield intermediate term growth of at least $6000 (again more is better); and (3) the dividends (dividends represent the amount of company profits that is paid out to shareholders of the company) should be at least $250 per year. Determine the least amount that Duane can invest and how that investment should be distributed between the three stocks. C. Formulate this problem algebraically (5 marks) d. Solve this problem using Excel