A. Formulate this problem algebraically

B. Solve this problem using Excel

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: 4. Short Term Growth Intermediate Growth Dividend Rate per $1.00 invested) (per $1.00 invested) 0.39 8% 4% 6% 1.59 ABC CBS NBC 0.261.70 0.42 1.45 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 s6000 (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 in dollars that Duane can invest and how those investment dollars should be distributed between the three stocks. (10 marks)