This question is your REQUIRED EXCEL question worth 25 points. You must complete this question using EXCEL and show all your work in EXCEL (not just the final answer), as well as submit an EXCEL file to the Canvas exam to earn credit.  IMPORTANT!!! Please download the exam EXCEL file NOW to use and submit for this exam. You may need to “Enable Editing.” Include your NAME in file name when saving it. EXCEL file provided HERE:  PRACTICE EXCEL FILE.xlsx  IMPORTANT!! Upload your EXCEL file to this question when you have completed the exam (but before the time runs out!) InfoTech Inc. is launching a new production line to manufacture their new tech product. Research and development costs for the past 6 years, leading up to production, have been $1.2 million per year. Today, production machinery totaling $4.96 million is being purchased to equip the new line. Operation and maintenance costs will total $87,000 per year, and materials and overhead costs will be $1.96 million annually to produce the tech product. The new production line will operate for 7 years, at which time the equipment will be sold at 19% of purchase price. Revenue from the new tech product is expected to be $3.98 million the first year, increasing by $1.8 million per year for the next 3 years, then decreasing by $0.6 million per year in years 5, 6, and 7.  To finance this new production line, a bank will loan InfoTech Inc. the money at an interest rate of 9.07%, compounded quarterly.    PART A: What is the interest rate per quarter that InfoTech Inc. is paying? What is the nominal annual interest rate? What is the effective annual interest rate? Solve the problem in EXCEL using simple calculations and an EXCEL spreadsheet function.  PART B: Create a cash flow diagram in EXCEL as a stacked column chart to represent the situation above. Make sure to label chart title, point-of-view, interest rate per period, time units, benefits (receipts) and costs (disbursements), axis labels with units, and data labels, as well as list any assumptions you might have (if needed).   Before your exam time runs out, don’t forget to submit your Microsoft Office EXCEL file by uploading it to this question. You should only submit a single EXCEL file (1 file) for the entire exam.  

Power-Sizing Model: where x is the power-sizing exponent. 

Match the classification name with its drug action

Reference Info 2053 Equations   An elephant is running South at a speed of 35.2 mi/h (about 15.7 m/s) and slows down to a speed of just 13.89 mi/h (6.21 m/s). If he travels a distance of 27.6 m during this time, a) what is his acceleration? b) how long did it take him to travel that distance?

In managing obstructive airway disease in mechanically ventilated patients, the AGACNP should optimize the respiratory care by:  

The patient was placed under observation and surgery was scheduled for open reduction and internal fixation (ORIF) of the femur fracture. After three hours in the observation bay, the patient suddenly became dyspneic, anxious, and expressed pleuritic chest pain.  Exam revealed the following: HR: irregular, 135 bpm; BP: 153/91 mm Hg; RR: 24; Temperature: 99.8°F; and a loud P2 component of the second heart sound. In this patient, these signs and symptoms are most likely attributable to which of the following: 

The following two questions are related to the same clinical scenario (patient). A 77-years-old patient with a significant history of COPD was admitted for a workup before an elective laparoscopic cholecystectomy. The nurse practitioner was asked for advice on perioperative management of chronic CO2 retention and severe lung disease.  On room air, the patient’s ABG was as follows: pH: 7.50; PCO2: 56; PO2: 63; HCO3: 48: BE: 22.7. Based on these results, the AGACNP calculated the age adjusted A-a Oxygen Gradient (A-a O2 G) to be:

The following two questions are related to the same clinical scenario (patient). The nurse practitioner is called to the emergency department to review the laboratory results of a morbidly obese 65-years-old patient with a history of hypertension admitted for lethargy, fatigue, and daytime somnolence. Basic chemistry and CBC were unremarkable except for a Hgb of 19 gm/dL.  The arterial blood gases (ABG) in room air resulted in pH: 7.33; PO2: 47; PCO2: 64; HCO3: 29 Based on these results, you determine the patient is exhibiting:

The following two questions are related to the same clinical scenario (patient). A 32-years-old patient was admitted to the emergency department with respiratory distress at rest precipitated by a visit to an art gallery. The patient presented diaphoretic, with non-productive cough, and complaining of chest tightness. On exam, the patient presented with a heart rate of 125 bpm, respiratory rate of 32 breaths per minute, and hyperresonance on auscultation. Chest radiography showed hyperinflation, and the initial ABG values indicated a respiratory alkalosis with mild hypoxemia. The AGACNP accurate diagnostic impression was:

A 19-years-old patient was received in the emergency room with altered cognition, complaining of nausea, vomiting, and headache. The accompanying relative of the patient disclosed a significant history of the patient’s suicide attempts. Results suggestive of carbon monoxide poisoning will be: