5. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good. Enter the performance ratings as follows: a. In cell B12, start to enter a formula using the HLOOKUP function.

The following pertains to smoke, inc.’s investment in debt securities: on december 31, year 3, smoke reclassified a security acquired during the year for $70,000. it had a $50,000 fair value when it was reclassified from trading to available-for-sale. an available-for-sale security costing $75,000, written down to $30,000 in year 2 because of an other-than-temporary impairment of fair value, had a $60,000 fair value on december 31, year 3. what is the net effect of the above items on smoke’s net income for the year ended december 31, year 3?

Our uncle has $300,000 invested at 7.5%, and he now wants to retire. he wants to withdraw $35,000 at the end of each year, starting at the end of this year. he also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. for how many years can he make the $35,000 withdrawals and still have $25,000 left in the end? a. 14.21b. 14.96c. 15.71d. 16.49e. 17.32

Dakota company experienced the following events during 2016. 1. acquired $30,000 cash from the issue of common stock. 2. paid $12,000 cash to purchase land. 3. borrowed $10,000 cash. 4. provided services for $20,000 cash. 5. paid $1,000 cash for utilities expense. 6. paid $15,000 cash for other operating expenses. 7. paid a $2,000 cash dividend to the stockholders. 8. determined that the market value of the land purchased in event 2 is now $12,700