Hi, this is my final project, so please make sure you include EQUATIONS and FUNCTIONS to show my work, otherwise it will get rejected! Real apreciated!!!

The problems has 4 pictures, the first 2 are the problem, then the last 2 pictures has empty yellow spaces for the answers.

2 Group Project 2-Financial Condition Analysis John Green, a recent graduate with four years of for-profit health management experience, was recently brought in as assistant to the chairman of the board of Digital Diagnostics, a manufacturer of clinical diagnostic equipment. The company had doubled its plant capacity, opened new sales offices outside its home territory, and launched an expensive advertising campaign. Digital's results were not satisfacto to put it mildly. Its board of directors, which consisted of its president and vice president plus its major stockholders (who were a ocal business people was most upset when directors learned how the expansion 10 was going. Suppliers were being paid late and were unhappy, and the bank was complaining about the cut off ll credit. As a result, Eddie Sanders, Digital's president, was informed that changes would have to be made, and 12 quickly, or he would be fired. Also, at the board's insistence, John Green was brought in and given the job of 3 assistant to Wendy Smith, a retired banker who was Digital's chairwoman and largest stockholder. Sanders 14 agreed to give up a few of his golfing days and help nurse the company back to heal th, with Green's assistance 16 Green began by gathering financial statements and other data, shown below. The data show the dire situation 17 that Digital Diagnostics was in after the expansion program. Thus far, sales have not been up to the 18 forecasted level, costs have been higher than were projected, and a large loss occurred in Year 2,rather than 19 the expected profit. Green examined monthly data for Year 2 (not given in the case and he detected an 20 improving pattern during the year. Monthly sales were rising, costs were falling, and large losses in the ear 21 months had turned to a small profit by December. Thus, the annual data look somewhat worse than final month 22 data. Also, it appears to be taking longer for the advertising program to get the mess across, for the new 23 sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other wor 24 the lags between spending money and deriving benefits were longer thanDigital's managers had anticipated. 25 For these reasons, Green and Sanders see hope for the compan rovided it can survive in the short run. 27 Green must prepare an al nalysis of where the company is now, what it must do to regain its financial health 28 and what actions should be taken. Green requested your group to complete this assigned task for him. 29 Use this Excel Workbook to perform the quantitative parts of the analysis and prepare the report as a Word document. 30 The report shpuld include only the interpretations of the quantitative results. How found these results are to be shown in this Excel Workbook. Submit both files via Blackboard as instructed. Digital Diagnostics Statement of operations 34 Actual YrzActual Yr Projected Net patient service revenue $3,432,000 $5,834,400 $7,035,600 36 Total revenues 32,000 S5834, 400 SS,035.600 $2,864,000 $4,980,000 $5,800,000 41 Supplies $240,000 $620,000 $512,960 42 Insurance and other $50,000 $50,000 $50,000 43 Drugs $50,000 $50,000 $50,000 44 Depreciation $18,900 $116,960 $120,000 Total expense Operating income 48 Provision for income taxes 49 Net income 2 Group Project 2-Financial Condition Analysis John Green, a recent graduate with four years of for-profit health management experience, was recently brought in as assistant to the chairman of the board of Digital Diagnostics, a manufacturer of clinical diagnostic equipment. The company had doubled its plant capacity, opened new sales offices outside its home territory, and launched an expensive advertising campaign. Digital's results were not satisfacto to put it mildly. Its board of directors, which consisted of its president and vice president plus its major stockholders (who were a ocal business people was most upset when directors learned how the expansion 10 was going. Suppliers were being paid late and were unhappy, and the bank was complaining about the cut off ll credit. As a result, Eddie Sanders, Digital's president, was informed that changes would have to be made, and 12 quickly, or he would be fired. Also, at the board's insistence, John Green was brought in and given the job of 3 assistant to Wendy Smith, a retired banker who was Digital's chairwoman and largest stockholder. Sanders 14 agreed to give up a few of his golfing days and help nurse the company back to heal th, with Green's assistance 16 Green began by gathering financial statements and other data, shown below. The data show the dire situation 17 that Digital Diagnostics was in after the expansion program. Thus far, sales have not been up to the 18 forecasted level, costs have been higher than were projected, and a large loss occurred in Year 2,rather than 19 the expected profit. Green examined monthly data for Year 2 (not given in the case and he detected an 20 improving pattern during the year. Monthly sales were rising, costs were falling, and large losses in the ear 21 months had turned to a small profit by December. Thus, the annual data look somewhat worse than final month 22 data. Also, it appears to be taking longer for the advertising program to get the mess across, for the new 23 sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other wor 24 the lags between spending money and deriving benefits were longer thanDigital's managers had anticipated. 25 For these reasons, Green and Sanders see hope for the compan rovided it can survive in the short run. 27 Green must prepare an al nalysis of where the company is now, what it must do to regain its financial health 28 and what actions should be taken. Green requested your group to complete this assigned task for him. 29 Use this Excel Workbook to perform the quantitative parts of the analysis and prepare the report as a Word document. 30 The report shpuld include only the interpretations of the quantitative results. How found these results are to be shown in this Excel Workbook. Submit both files via Blackboard as instructed. Digital Diagnostics Statement of operations 34 Actual YrzActual Yr Projected Net patient service revenue $3,432,000 $5,834,400 $7,035,600 36 Total revenues 32,000 S5834, 400 SS,035.600 $2,864,000 $4,980,000 $5,800,000 41 Supplies $240,000 $620,000 $512,960 42 Insurance and other $50,000 $50,000 $50,000 43 Drugs $50,000 $50,000 $50,000 44 Depreciation $18,900 $116,960 $120,000 Total expense Operating income 48 Provision for income taxes 49 Net income