On the Transactions worksheet, in cell 10, create a formula that will return 0.1 if the customer is a member and they either purchased a promotional item or spent more than $100, otherwise return a blank value Format the cell as Percentage with 0 decimal places. Use the fill handle to copy the formula down through 30.

Melissa is a very generous single woman. before this year, she had given over $11,400,000 in taxable gifts over the years and has completely exhausted her applicable credit amount. in the current year, melissa gave her daughter riley $100,000 and promptly filed her gift tax return. melissa did not make any other gifts this year. how much gift tax must riley pay the irs because of this transaction?

Profits from using currency options and futures.on july 2, the two-month futures rate of the mexican peso contained a 2 percent discount (unannualized). there was a call option on pesos with an exercise price that was equal to the spot rate. there was also a put option on pesos with an exercise price equal to the spot rate. the premium on each of these options was 3 percent of the spot rate at that time. on september 2, the option expired. go to the oanda.com website (or any site that has foreign exchange rate quotations) and determine the direct quote of the mexican peso. you exercised the option on this date if it was feasible to do so. a. what was your net profit per unit if you had purchased the call option? b. what was your net profit per unit if you had purchased the put option? c. what was your net profit per unit if you had purchased a futures contract on july 2 that had a settlement date of september 2? d. what was your net profit per unit if you sold a futures contract on july 2 that had a settlement date of september 2

Match the terms with their correct definition. terms: 1. accounts receivable 2. other receivables 3 debtor 4. notes receivable 5. maturity date 6. creditor definitions: a. the party to a credit transaction who takes on an obligation/payable. b. the party who receives a receivable and will collect cash in the future. c. a written promise to pay a specified amount of money at a particular future date. d. the date when the note receivable is due. e. a miscellaneous category that includes any other type of receivable where there is a right to receive cash in the future. f. the right to receive cash in the future from customers for goods sold or for services performed.