CASE #2: BILL HERNANDEZ Last year, Bill Hernandez won a local 50/50 lottery worth $200,000! While he initially spent some money on a new vehicle and a family trip, Bill decided he wanted to invest some of the other money into the bond market, while putting the rest ($100,000) in short-term (1 year) GIC. Bill enlisted the services of a local investor group, Insider Trading Inc., to invest in various bonds and has been utilizing their services for the last year. However, in talking with some of his friends, Bill is starting to question whether he is getting good investment advice. His two most recent investments are as follows: . A $20,000 face value bond, paying interest semi-annually at 8% and maturing in 10 years, with a yield to maturity of 9%. He paid $19,854.22. . A $10,000 face value bond, paying interest annually at 10% and maturing in 5 years that cost $9,200. He was told this would get him a rate of return of, at least, 13% One of Bill's closest friends has told him about a company he has recently invested in. After being mostly self-funded, that company is looking to raise capital for an expansion opportunity and will be issuing a number of both preferred and common shares in the coming weeks. The company's financial statements over the last two years can be found in Exhibit 1 & 2, but Bill doesn't know how to interpret them. He is curious about the company's recent performance and their current financial situation. After a good first few years, the company is expected to have a steady growth of 7% over the next several years with this expansion opportunity, according to Bill's friend. The preferred shares will pay a dividend of $5 and the required rate of return is 13%. The price of these shares is expected to be $38.50 per share. The common shareholders were paid out a dividend of $3 per share, last year, and expected to be priced at $50 per share. CASE ANALYSIS His GIC investment is set to mature soon, and Bill will have another $100,000 he is looking to invest. He is wondering if he should continue to invest with Insider Trading Inc. or if he should consider investing in the business his friend has told him about? Bill has asked to meet you for coffee. As a Cambrian College business student, he wants your advice as to what he should do!EXHIBIT 1 Balance Sheet 2021 2020 Assets Cash $2,000,000 $1,500,000 Accounts Receivable $2,250,000 $2,400,000 Inventory $1,050,000 $1, 100,000 Property & Equipment $1,600,000 $2,000,000 $6,900,000 $7,000,000 Liabilities Accounts Payable $2,500,000 $2,500,000 Long Term Debt $1,200,000 400,000 Shareholder Equity Preferred S 50,000 50.000 Common Stock 50.000 50,000 Retained Earnings 3,100,000 3,000,000 $6,900,000 $7,000,000 EXHIBIT 2 Income Statement 2021 2020 Sales $5,300,000 $4,800,000 Cost of Sales $3,657,000 $3,552,000 Gross Margin $1,643,000 $1,248,000 Operating Expenses $636,000 $624,000 Operating Margin $1,007,000 $624,000 Interest Expense $45,000 $50,000 Amortization $400,000 $400,000 Net Income Before Taxes $562,000 $174,000 Taxes @ 15% $84,300 $26,100 Net Income $477,700 $147,900