1. Strategic leaders at the organization would like a oneword status regarding the finances of the institution. For earnings between $0 and $7,999,999, the status is Concern. For earnings between $8 million and $12,999,999, the status is Viable. For earnings between $13 million and $17,999,999, the status is Comfortable. For all earnings at $18 million and above, the status is Ideal. Construct a VLOOKUP table in E19:F24. Then, use a VLOOKUP formula to display the financial status of the university in row 16, based on net earnings or losses in row 14 and the lookup table in E19:F23

A B D E F G 2010 2011 2012 2013 2014 2015 $ 42,225,000.00 $ 38,825,000.00 $ 36,623,400.00 $ 41,175,400.00 $ 48,850,525.00 $ 47,323,450.00 $ 2,385,725.00$ 2,105,525.00 $ 1,195,325.00 $ 2,180,900.00$ 3,175,000.00 $ 3,805,705.00 $ 5,550,605.00$ 6,680,205.00$ 7,755,220.00 $ 6,805,580.00 $ 5,525,805.00$ 6,680,702.00 $ 50,161,330.00 $ 47,610,730.00 $ 45,573,945.00 $ 50,161,880.00 $ 57,551,330.00 $ 57,809,857.00 $ 25,558,000.00 $ 26,690,800.00 $ 30,054,580.00 $ 32,450,805.00 $ 29,965,405.00$ 33,405,600.00 $ 1,789,060.00 $ 1,868,356.00 $ 2,103,820.60 $ 2,271,556.35 $ 2,097,578.35 $ 2,338,392.00 bonus paid bonus not paid bonus not paid bonus paid bonus paid bonus paid $ 27,347,060.00 $ 28,559,156.00 $ 32,158,400.60 $ 34,722,361.35 $ 32,062,983.35 $ 35,743,992.00 1 2 Revenues 3 Tuition 4 Fees 5 Donations 6 Total Revenues 7 8 Expenses 9 Salaries 0 Health Insurance 1 Bonuses -2 Total Expenses 3 4 Net Earnings (losses) -5 6 Status -7 -8 Assumptions -9 Health Insurance Percentage Co Dental Insurance Percentage -1 Bonus Trigger 22 Bonus Payout -3 -4 $ 19,603,330.00 $ 19,051,574.00 $ 13,415,544.40 $ 10,439,518.65 $ 20,488,346.65 $ 17,065,865.00 Earnings Status 7% 5% $ 48,000,000.00 $ 5,000,000.00 A B D E F G 2010 2011 2012 2013 2014 2015 $ 42,225,000.00 $ 38,825,000.00 $ 36,623,400.00 $ 41,175,400.00 $ 48,850,525.00 $ 47,323,450.00 $ 2,385,725.00$ 2,105,525.00 $ 1,195,325.00 $ 2,180,900.00$ 3,175,000.00 $ 3,805,705.00 $ 5,550,605.00$ 6,680,205.00$ 7,755,220.00 $ 6,805,580.00 $ 5,525,805.00$ 6,680,702.00 $ 50,161,330.00 $ 47,610,730.00 $ 45,573,945.00 $ 50,161,880.00 $ 57,551,330.00 $ 57,809,857.00 $ 25,558,000.00 $ 26,690,800.00 $ 30,054,580.00 $ 32,450,805.00 $ 29,965,405.00$ 33,405,600.00 $ 1,789,060.00 $ 1,868,356.00 $ 2,103,820.60 $ 2,271,556.35 $ 2,097,578.35 $ 2,338,392.00 bonus paid bonus not paid bonus not paid bonus paid bonus paid bonus paid $ 27,347,060.00 $ 28,559,156.00 $ 32,158,400.60 $ 34,722,361.35 $ 32,062,983.35 $ 35,743,992.00 1 2 Revenues 3 Tuition 4 Fees 5 Donations 6 Total Revenues 7 8 Expenses 9 Salaries 0 Health Insurance 1 Bonuses -2 Total Expenses 3 4 Net Earnings (losses) -5 6 Status -7 -8 Assumptions -9 Health Insurance Percentage Co Dental Insurance Percentage -1 Bonus Trigger 22 Bonus Payout -3 -4 $ 19,603,330.00 $ 19,051,574.00 $ 13,415,544.40 $ 10,439,518.65 $ 20,488,346.65 $ 17,065,865.00 Earnings Status 7% 5% $ 48,000,000.00 $ 5,000,000.00