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.

Juan's investment portfolio was valued at $125,640 at the beginning of the year. during the year, juan received $603 in interest income and $298 in dividend income. juan also sold shares of stock and realized $1,459 in capital gains. juan's portfolio is valued at $142,608 at the end of the year. all income and realized gains were reinvested. no funds were contributed or withdrawn during the year. what is the amount of income juan must declare this year for income tax purposes?