What stands out as unusual in this urinalysis? What might be happening with this patient?
 

Your firm is considering two mutually exclusive projects with cash flows as indicated in the Excel file. Fill out the following excel sheet, please show all the formula or method.

A) What is the NPV and IRR for the two projects, respectively?
B) Calculate the crossover rate.

 

Transcribed Image Text:

Table 2. Urinalysis Results for Case 1 Component Result Reference range Dipstick urinalysis Color Pale yellow Clarity Clear pH 6.5 Specific gravity 1.010 Glucose Negative Negative Blood 1+ Negative Ketones Negative Negative Protein Negative Negative Urobilinogen Negative Negative Bilirubin Negative Negative Leukocyte esterase Negative Negative Nitrite Negative Negative Urine microscopy White blood cells Red blood cells Squamous epithelial cells 7 per high-power field None 0 to 5 per high- power field 0 to 4 per high- power field None 1 per high-power field Table 2. Urinalysis Results for Case 1 Component Result Reference range Dipstick urinalysis Color Pale yellow Clarity Clear pH 6.5 Specific gravity 1.010 Glucose Negative Negative Blood 1+ Negative Ketones Negative Negative Protein Negative Negative Urobilinogen Negative Negative Bilirubin Negative Negative Leukocyte esterase Negative Negative Nitrite Negative Negative Urine microscopy White blood cells Red blood cells Squamous epithelial cells 7 per high-power field None 0 to 5 per high- power field 0 to 4 per high- power field None 1 per high-power field