ABY cash flow: ABY firm spends $200 to produce goods in period 1. In period 2, it sells half of those goods for $150, but doesn't collect payment until one period later. In period 3, it sells the other half of the goods for $150, and collects on these sales in period 4. Construct tables that depict the derivation of the profits and cash flows for the firm for periods 1 through 4. Ignore taxes. Profits Period 1 Period 2 Period 3 Period 4 Sales ?? ?? ?? ?? Cost of goods sold ?? ?? ?? ?? Profit ?? ?? ?? ?? Cash flows Period 1 Period 2 Period 3 Period 4 Sales ?? ?? ?? ?? less: cost of good sold ??

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding