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)

Two products, qi and vh, emerge from a joint process. product qi has been allocated $34,300 of the total joint costs of $55,000. a total of 2,900 units of product qi are produced from the joint process. product qi can be sold at the split-off point for $11 per unit, or it can be processed further for an additional total cost of $10,900 and then sold for $13 per unit. if product qi is processed further and sold, what would be the financial advantage (disadvantage) for the company compared with sale in its unprocessed form directly after the split-off point?

Which of the following is an example of a positive externality? a. promoting generic drugs would benefit people. b. a lower inflation rate would benefit most consumers. c. compulsory flu shots for all students prevents the spread of illness in the general public. d. singapore has adopted a comprehensive savings plan for all workers known as the central provident fund.

Ernesto baca is employed by bigg company. he has a family membership in his company's health insurance program. the annual premium is $5,432. ernesto's employer pays 80% of the total cost. ernesto's contribution is deducted from his paycheck. what is his annual contribution? $1,086.40 $1,125.65 $1,527.98 $1,567.20 save and exit