Question

Fill in the spreadsheet below with the appropriate cell formulas to compute the operating cash flow,...

  1. 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)
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Answer : Sheets are attached below :-

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Presented below are condensed data from the 2017 and 2018 Johnson Plumbing Corporation’s income statements (in...
Presented below are condensed data from the 2017 and 2018 Johnson Plumbing Corporation’s income statements (in millions): 2017 2018 Revenues $15,060 $12,260 Operational Expenses 9,660 8,120 Operating Income $5,400 $4,140 Required: Analyze Johnson Plumbing’s cost-volume-profit relationships by applying the high-low method of cost estimation to the above information and complete the following: a. Estimate the variable cost ratio. b. Estimate annual fixed costs. c. Compute the contribution margin ratio. d. Compute the annual break-even point in dollars. e. Applying these...
Chapter 13: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and...
Chapter 13: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell C22 enter the formula "= B10". Note: The present value factors could be computed using the built-in Excel function PV, but we recommend using the formulas in Appendix 13B. Verify that your worksheet matches the example in the text. Check your worksheet by changing the discount rate to 10%. The net...
1. Use the data that is posted below to answer the following questions. If your answer...
1. Use the data that is posted below to answer the following questions. If your answer has units to it, then please state those units. Production Options Sugar beets (tons) Wheat  (tons) A 200 0 B 180 20 C 140 40 D 80 60 E 0 80 a) Graph Production Possibilities Frontier (Curve) for Sugar Beets and Wheat. Put sugar beets on the vertical axis and label that axis Sugar Beets and put wheat on the horizontal axis and label that...
In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called...
In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called The Dougie that teaches children how to dance. The fixed cost to produce the doll is $100,000. The variable cost, which includes material, labor, and shipping costs, is $34 per doll. During the holiday selling season, FTC will sell the dolls for $42 each. If FTC overproduces the dolls, the excess dolls will be sold in January through a distributor who has agreed to...
In CVP analysis, the unit contribution margin is: Sales price per unit less cost of goods...
In CVP analysis, the unit contribution margin is: Sales price per unit less cost of goods sold per unit Sales price per unit less FC per unit Sales price per unit less total VC per unit Same as the CM Maroon Company’s CM ratio of 24%.  Total FC are $84,000.  What is Maroon’s B/E point in sales dollars? $20,160 $110,536 $240,000 $350,000       If a firm’s forecasted sales are $250,000 and its B/E sales are $190,000, the margin of safety in dollars is:...
(All answers were generated using 1,000 trials and native Excel functionality.) In preparing for the upcoming...
(All answers were generated using 1,000 trials and native Excel functionality.) In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called The Dougie that teaches children how to dance. The fixed cost to produce the doll is $100,000. The variable cost, which includes material, labor, and shipping costs, is $34 per doll. During the holiday selling season, FTC will sell the dolls for $42 each. If FTC overproduces the dolls, the excess dolls will...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity...
Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company. b. Budgeted unit sales by quarter for 2019 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250. First and second quarter 2020 budgeted sales units is...
Section 2 - CASE ANALYSIS (30 marks) INSTRUCTIONS: 1. Read the case below carefully and answer...
Section 2 - CASE ANALYSIS INSTRUCTIONS: 1. Read the case below carefully and answer ALL the questions which follow. 2. Your answers may be entered using a Microsoft Excel spreadsheet OR may be entered in a table format using Microsoft Word. HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT