Explain how Excel can be used to design a database, including an example of a basic database layout that would be appropriate for, say, a gradebook for a graduating class’s overall GPA. Then, imagine that a business existed that used students’ information to propose specific colleges for them. What columns from the original spreadsheet would be kept? Propose at least four columns that would be added to a database for such a business, explaining how they would collectively help the business’s database function.

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?

In 2015, lori assigned a paid-up whole life insurance policy to an irrevocable life insurance trust (ilit) for the benefit of her three children. the ilit contained a crummey provision for the benefit of each child. at the time of the transfer, the whole life insurance policy was valued at $200,000, and since lori had not made any other taxable gifts during her lifetime, she did not owe any gift tax. lori died in 2016, and the face value of the whole life insurance policy of $2,000,000 was paid to the ilit. regarding this transfer, how much is included in lori’s gross estate at her death?

What is the difference between total utility and marginal utility? a. marginal utility is subject to the law of diminishing marginal utility while total utility is not. b. total utility represents the consumer optimum while marginal utility gives the total utility per dollar spent on the last unit. c. total utility is the total amount of satisfaction derived from consuming a certain amount of a good while marginal utility is the additional satisfaction gained from consuming an additional unit of the good. d. marginal utility represents the consumer optimum while total utility gives the total utility per dollar spent on the last unit.