subject
Business, 21.05.2020 06:04 michael11948

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)

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 14:10
Carey company is borrowing $225,000 for one year at 9.5 percent from second intrastate bank. the bank requires a 15 percent compensating balance. the principal refers to funds the firm can effectively utilize (amount borrowed − compensating balance). a. what is the effective rate of interest? (use a 360-day year. input your answer as a percent rounded to 2 decimal places.) b. what would the effective rate be if carey were required to make 12 equal monthly payments to retire the loan?
Answers: 1
question
Business, 22.06.2019 19:00
The following are budgeted data: january february march sales in units 16,200 22,400 19,200 production in units 19,200 20,200 18,700 one pound of material is required for each finished unit. the inventory of materials at the end of each month should equal 20% of the following month's production needs. purchases of raw materials for february would be budgeted to be:
Answers: 3
question
Business, 22.06.2019 19:20
Sanibel autos inc. merged with its competitor vroom autos inc. this allowed sanibel autos to use its technological competencies along with vroom autos' marketing capabilities to capture a larger market share than what the two entities individually held. what type of integration does this scenario best illustrate? a. vertical b. technological c. horizontal d. perfect
Answers: 2
question
Business, 22.06.2019 23:40
John has been working as a tutor for $300 a semester. when the university raises the price it pays tutors to $400, jasmine enters the market and begins tutoring as well. how much does producer surplus rise as a result of this price increase?
Answers: 1
You know the right answer?
Fill in the spreadsheet below with the appropriate cell formulas to compute the operating cash flow,...
Questions
question
History, 05.05.2020 23:01