c. Cash Holdings . I. C. II. First, calculate each com pa ny's \"average total assets" for each year of data available. (note: this is done by taking the current year total assets plus the prior year total assets divided by 2). Use a \"nested if" conditional statement. Use the average total assets just calculated and the cash to calculate cash holdings as a percentage of average total assets