# Question: Nextron Distribution is performing an analysis of the cash flows

Nextron Distribution is performing an analysis of the cash flows it hopes to earn from a major expansion of the firm’s operations into a new product line. The estimates needed for computing the annual free cash flow for the first year of operations are found below:

a. Construct a spreadsheet model for the year 1 free cash flow. What is your estimate of the expected cash flow?

b. Utilize the probability distributions and associated parameter estimates to construct a simulation model for the investment opportunity where free cash flow is the fore-cast variable in the model. 1. What is the expected free cash flow? 2. What is the probability that the free cash flow will drop below $ 500,000?

a. Construct a spreadsheet model for the year 1 free cash flow. What is your estimate of the expected cash flow?

b. Utilize the probability distributions and associated parameter estimates to construct a simulation model for the investment opportunity where free cash flow is the fore-cast variable in the model. 1. What is the expected free cash flow? 2. What is the probability that the free cash flow will drop below $ 500,000?

**View Solution:**## Answer to relevant Questions

The Clayton Manufacturing Company is considering an investment in a new automated inventory system for its warehouse that will provide cash savings to the firm over the next five years. The firm’s CFO anticipates ...Decision Tree and Breakeven Sensitivity Analysis Reevaluate the Earthilizer decision tree analysis found in Table 3-7, Where the abandonment value is only $ 350,000. What is the expected NPV of the project under these ...This problem is based on the appendix to this chapter. The Eastman Kodak Corporation had an issue of convertible bonds outstanding in spring 2005 that had a coupon rate of interest and sold for $ 1,277.20 per bond. The ...Lampkin Manufacturing Company has two projects. The first, project A, involves the construction of an addition to the firm’s primary manufacturing facility. The plant expansion will add fixed operating costs equal to $ ...Hildebrand Corp. had the following current asset and current liability account balances for 2012 through 2015: a. Compute Hildebrand’s operating net working capital for 2012 to 2015. b. What are the annual changes in ...Post your question