Fill in the spreadsheet below with the appropriate cell formulas to compute the operating cash flow, for example the formula is provided for the fixed costs in cell B12. (Do not put in the numerical answers, just the Excel cell formulas) B C D E 1 2 Assumptions 3 Price $10 4 Quantity 100,000 5 Fixed Costs 25,000 6 VC Percent 65% 7 Tax Rate 30% 8 Depreciation 10,000 9 10 Sales Revenue (a) 11 Variable Costs (b) 12 Fixed Costs =c5 13 Depreciation (c) 14 Operating Profit (d) 15 Taxes (e) 16 Net Profit (f) 17 Operating CF (g)

On june 3, teal company sold to chester company merchandise having a sale price of $2,600 with terms of 2/10, n/60, f. o.b. shipping point. an invoice totaling $91, terms n/30, was received by chester on june 8 from john booth transport service for the freight cost. on june 12, the company received a check for the balance due from chester company. prepare journal entries on the teal company books to record all the events noted above under each of the following bases. (1) sales and receivables are entered at gross selling price. (2) sales and receivables are entered at net of cash discounts.