Blog

Persian Wars

In the hr-diagram, match each letter to the type of star.hrdiagramlabel.png

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.  

Aspects of Example Cash Flow Diagram (CFD) with end-of-period cash flow convention:

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?

ARDS usually presents with severe dyspnea and respiratory distress, tachycardia, and rales and wheezes on auscultation. The clinical hallmark of this condition is:

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:

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). A 56 year-old patient was admitted to the emergency department, confused and with respiratory distress.   The respiratory rate was 20 breaths per minute. The O2 saturation via pulse oximetry on oxygen at 2L/min via nasal cannula was 91%. An arterial blood gas was obtained and resulted as: 7.34/44/68/20/89%. The AGACNP calculates the expected A-a gradient to be 16.5, given the patient’s age.  The AGACNP then calculates the A-a gradient to be 79.7, based on the clinical data.  Considering the above, the AGACNP concludes that:

A 32-years-old patient was admitted to an urgent care facility with tachypnea, complaining of light-headedness. The patient disclosed a positive history of anxiety with panic attacks. Arterial blood gas was obtained with the following results: pH: 7.44 | PaCO2: 28 | HCO3: 20. The AGACNP interprets these results as: