A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments and at least 40% of the total annual return should be tax free. Formulate an LP model for this problem. Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution

What are the forecasted levels of the line of credit and special dividends? (hints: create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) now assume that the growth in sales is only 3%. what are the forecasted levels of the line of credit and special dividends?

Suppose you win a small lottery and have the choice of two ways to be paid: you can accept the money in a lump sum or in a series of payments over time. if you pick the lump sum, you get $2,950 today. if you pick payments over time, you get three payments: $1,000 today, $1,000 1 year from today, and $1,000 2 years from today. 1) at an interest rate of 6% per year, the winner would be better off accepting the (lump sum / payments over time), since it has the greater present value. 2) at an interest rate of 9% per year, the winner would be better off accepting the (lump sum / payments over time), since it has the greater present value. 3) years after you win the lottery, a friend in another country calls to ask your advice. by wild coincidence, she has just won another lottery with the same payout schemes. she must make a quick decision about whether to collect her money under the lump sum or the payments over time. what is the best advice to give your friend? a) the lump sum is always better. b) the payments over time are always better. c) it will depend on the interest rate; advise her to get a calculator. d) none of these answers is good advice.

Nell and kirby are in the process of negotiating their divorce agreement. what should be the tax consequences to nell and kirby if the following, considered individually, became part of the agreement? a. in consideration for her one-half interest in their personal residence, kirby will transfer to nell stock with a value of $200,000 and $50,000 of cash. kirby's cost of the stock was $150,000, and the value of the personal residence is $500,000. they purchased the residence three years ago for $300,000.nell's basis for the stock is $ xkirby's basis in the house is $ xb. nell will receive $1,000 per month for 120 months. if she dies before receiving all 120 payments, the remaining payments will be made to her estate.the payments (qualify, do not qualify) as alimony and are (included in, excluded from) nell's gross income as they are received.c. nell is to have custody of their 12-year-old son, bobby. she is to receive $1,200 per month until bobby (1) dies or (2) attains age 21 (whichever occurs first). after either of these events occurs, nell will receive only $300 per month for the remainder of her life.$ x per month is alimony that is (included in, excluded from) nell's gross income, and the remaining $ x per month is considered (child support, property settlement) and is (nontaxable, taxable) to nell.