Use the drop-down menus to complete the steps for adding conditional formatting to a form. 1. Open the form in ___ view.

2. Click the desired field for the conditional formatting.

3. Click the Format tab, then ___ .

4. In the Rules Manager dialog box, click ___ .

5. Select “check values in the current record or use an expression.”

6. Complete the drop-down menus to determine the condition.

7. Make sure to change the formatting using a color or font so you will clearly see the changes made. Click OK.

8. When you are satisfied with your rule, click ___ and then OK.

ANSWERS: Design, Conditional Formatting, New Rule, Apply

Lo.2, 3, 9 lori, who is single, purchased 5-years class property for $200,00 and 7-years class property for $420,000 on may 20, 2018. lori experts the taxable income derived form the business (without regard to the amount expensed under ⧠179) to be about $550,000. lori has determined that she should elect immediate ⧠179 expensing in the amount of $520,000, but she doesn’t know which asset she should completely expense under ⧠179. she does not claim any available additional first-year depreciation. a. determine lori’s total cost recovery deduction if the ⧠179 expense is first taken with respect to the 5-year class asset. b. determine lori’s total cost recovery deduction if the ⧠179 expense is first taken with respect to the 7-year class asset. c. what is your advice for lori? d. assume that lori is in the 24% marginal tax bracket and that she uses ⧠179 on the 7-year asset. determine the present value of the tax savings from the depreciation deductions for both assets. see appendix g for present value factors, and assume a 6% discount rate. e. assume the same facts as in part (d), except that lori decides not to use ⧠179 on either asset. determine the present value of the tax savings under this choice. in addition, determine which option lori should choose. f. present your solution to parts (d) and (e) of the problem in a spreadsheet using appropriate microsoft excel formulas. e-mail your spreadsheet to your instructor with a two-paragraph summary of your findings.

Suppose that xtel currently is selling at $40 per share. you buy 500 shares using $15,000 of your own money, borrowing the remainder of the purchase price from your broker. the rate on the margin loan is 8%. a. what is the percentage increase in the net worth of your brokerage account if the price of xtel immediately changes to (a) $44; (b) $40; (c) $36? (leave no cells blank - be certain to enter "0" wherever required. negative values should be indicated by a minus sign. round your answers to 2 decimal places.) b. if the maintenance margin is 25%, how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.) c. how would your answer to requirement 2 would change if you had financed the initial purchase with only $10,000 of your own money? (round your answer to 2 decimal places.) d. what is the rate of return on your margined position (assuming again that you invest $15,000 of your own money) if xtel is selling after one year at (a) $44; (b) $40; (c) $36? (negative values should be indicated by a minus sign. round your answers to 2 decimal places.) e. continue to assume that a year has passed. how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.)

Down under products, ltd., of australia has budgeted sales of its popular boomerang for the next four months as follows: unit salesapril 74,000may 85,000june 114,000july 92,000the company is now in the process of preparing a production budget for the second quarter. past experience has shown that end-of-month inventory levels must equal 10% of the following month’s unit sales. the inventory at the end of march was 7,400 units.required: prepare a production budget by month and in total, for the second quarter.