Question

You are forecasting cash flows using regression analysis (sales is the independent variable). After estimating the...

You are forecasting cash flows using regression analysis (sales is the independent variable). After estimating the regression model, you have recorded the following regression equation:
Net Cash Flow = $27,000 + (0.7*Sales). Use this model to:

  1. Forecast net cash flow, assuming the next month’s Sales will equal to $150,000
  2. Evaluate your forecast from part (a), assuming that month has passed, in which the actual net cash flow was $145,000
  3. Determine the impact of an additional $1 in sales on net cash flow.

Homework Answers

Answer #1

a. Net Cash Flow = $27,000 + (0.7*Sales)

Sales = $ 150,000

Net Cash Flow = $27,000 + ( 0.7 * $150,000 )

Net Cash Flow = $27,000 + $105,000

Net Cash Flow = $132,000

b. Net Cash Flow = $27,000 + (0.7*Sales)

$145,000 = $27,000 + (0.7*Sales)

$145,000 - $27,000 = (0.7*Sales)

(0.7*Sales) = $118,000

Sales = $118,000 / 0.7

Sales = $ 168,571.43

c. Net Cash Flow = $27,000 + (0.7*Sales)

Assume Sales be $1

Net Cash Flow = $27,000 + ( 0.7 * $1 )

Net Cash Flow = $27,000 + $0.7

Net Cash Flow = $27,000.7

Which means a additional sale of every dollar will increase net cash flow by 70 cents (or $0.7)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Each of the following scenarios is independent. Assume that all cash flows are after-tax cash flows....
Each of the following scenarios is independent. Assume that all cash flows are after-tax cash flows. Campbell Manufacturing is considering the purchase of a new welding system. The cash benefits will be $480,000 per year. The system costs $2,250,000 and will last 10 years. Evee Cardenas is interested in investing in a women's specialty shop. The cost of the investment is $280,000. She estimates that the return from owning her own shop will be $50,000 per year. She estimates that...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Intel Corporation. INTEL CORPORATION Consolidated Statements of Income Year Ended (In millions) Dec. 25, 2010 Dec. 26, 2009 Dec. 27, 2008 Net revenue $ 43,623 $ 35,127 $ 37,586 Cost of sales 15,132 15,566 16,742 Gross margin 28,491 19,561 20,844 Research and development 6,576 5,653 5,722 Marketing, general and administrative 6,309 7,931 5,452 Restructuring and asset impairment charges -- 231 710 Amortization...
You are trying to calculate the enterprise value of DCB Corp using a free cash flow...
You are trying to calculate the enterprise value of DCB Corp using a free cash flow model. To that end you have put together some forecast for year 1 in the table below. Assume that free cash flows will grow at 1.5% in perpetuity and that the weighted average cost of capital of the firm (WACC) is 8%. Using this information, calculate the enterprise value of the firm. Express your answer in $-millions and round to two decimals (do not...
Your firm would like to evaluate a proposed new operating division. You have forecasted cash flows...
Your firm would like to evaluate a proposed new operating division. You have forecasted cash flows for this division for the next five​ years, and have estimated that the cost of capital is 12%. You would like to estimate a continuation value. You have made the following forecasts for the last year of your​ five year forecasting horizon​ (in millions of​ dollars): Year 5 Revenues ​ 1,200.0 Operating income 100.0 Net income                              50.0 Free cash flows                                                 110.0 Book value...
New-Project Analysis The president of the company you work for has asked you to evaluate the...
New-Project Analysis The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $60,000, and it would cost another $15,000 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $27,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. Use of...
1. Concepts used in cash flow estimation and risk analysis You can come across different situations...
1. Concepts used in cash flow estimation and risk analysis You can come across different situations in your life where the concepts from capital budgeting will help you in evaluating the situation and making calculated decisions. Consider the following situation: The following table contains five definitions or concepts. Identify the term that best corresponds to the concept or definition given. Concept or Definition Term An example of externality that can have a negative effect on a firm Cannibalization/corporate risk/ Exchange...
Statement of Cash Flows Using a Work Sheet—Indirect Method (Appendix) Wabash Corp. just completed another successful...
Statement of Cash Flows Using a Work Sheet—Indirect Method (Appendix) Wabash Corp. just completed another successful year, as indicated by the following income statement: For the Year Ended December 31, 2017 Sales revenue $2,460,000   Cost of goods sold 1,400,000     Gross profit $1,060,000   Operating expenses 460,000     Income before interest and taxes $600,000   Interest expense 100,000     Income before taxes $500,000   Income tax expense 150,000     Net income $350,000   Presented here are comparative balance sheets: December 31 2017 2016 Cash $140,000 $210,000 Accounts receivable...
(a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV,...
(a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period (c) Develop Problem-Solving and Critical Thinking Skills 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $   200,000 2) New equipment cost $ (200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $     (35,000) 10) Operating cost: $ (120,000) 4) Related start up cost $       (5,000)     (60 Percent of...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR and PayBack Period 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $     200,000 2) New equipment cost $          (200,000) 9) Sales increase per year 4% 3) Equipment ship & install cost $            (25,000) 10) Operating cost: $    (120,000) 4) Related start up cost $              (5,000)     (60 Percent of Sales) -60% 5) Inventory increase $             25,000 11) Depreciation (Straight Line)/YR $      (60,000) 6) Accounts Payable...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR and PayBack Period 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $     200,000 2) New equipment cost $          (200,000) 9) Sales increase per year 4% 3) Equipment ship & install cost $            (25,000) 10) Operating cost: $    (120,000) 4) Related start up cost $              (5,000)     (60 Percent of Sales) -60% 5) Inventory increase $             25,000 11) Depreciation (Straight Line)/YR $      (60,000) 6) Accounts Payable...