What is the firm's cash flow from operations?

You are in search of a new vehicle. However, you are not sure if you want a fully electric vehicle or a hybrid vehicle compared to a conventional gas-powered vehicle. Since you are learning about Engineering Management, NPV, etc., you want to determine which vehicle investment will have the greatest ROI, so you can make your decision.

In order to simplify the problem, you are considering the gas-powered vehicle as a baseline and comparing both a hybrid and a fully electric vehicle to it. Additionally, you expect to keep the vehicle for six years. Below is some information about each vehicle to help you calculate the incremental ROI. Your response to this question should include incremental ROI for both investing in a hybrid and a fully electric vehicle. Thereafter, based on the calculations you should determine which vehicle would you purchase.

Note: Use only the information provided in this problem and do not include any external information. You are only considering purchasing and not leasing.

Assume following costs for gas-powered vehicle: Purchase price $38,000; Annual gasoline expenses $2,000 for each of 5 years; Annual insurance expenses $1200 for each of 5 years; Annual maintenance $750 for each of 5 years. No other costs will be incurred.

Assume the following for hybrid vehicle: Purchase price $40,000; Annual gasoline expenses $1,200 for each of 5 years; Annual insurance $1400 for each of 5 years; Annual maintenance $600 for each of 5 years.

Assume the following for electric vehicle: Purchase price $48,000; No annual gasoline expenses, but you expect to incur $800 in electric expenses for each of 5 years; Annual insurance expenses $1500 for each of 5 years; Annual maintenance $200 for each of 5 years.

Hint: The question is about incremental ROI. Also, assume you are in a market for and need a vehicle.

You are a Logistics Manager at an e-Commerce retail company. Your company currently uses third-party delivery services to deliver products ordered through your website. While third-party services are reliable, they have limitations that are preventing your company from differentiating from other e-Commerce retailers. Therefore, you are contemplating that your company should start its own delivery service for delivering the most commonly ordered products. You have done all the analyses and are left with calculating the payback period of the investment before you present it to management. Typically, management has funded investments with a payback period between 3 – 4 years.

What is the payback period of this investment based on the information provided below? Will management invest in this project?

Note: Please show all calculations and use only the information provided in this problem. Do not include any external information.

The required investment for the service is $800,000. You are expecting an increase in monthly revenue of $30,000 for the next 5 years that is directly attributable to this service. You are also expecting incremental costs of $175,000 per year for the next five years.

A firm recently paid a dividend of $1.25. It expects to have a dividend growth rate of 15% for the first 3 years followed by a constant rate of 6% thereafter. The firm’s required return is 10%. What is the firm’s stock value TODAY? Please show work in calculator, not Excel.

A Mining firm has to consider investing amongst any of the three mutually exclusive coal mines. Depending on the expected quality of coal extracted every year, the selling price and initial equipment investment per metric ton is shown in the table below. MARR is 10 percent/year.

a) What is the annual worth of each alternative?

b) Determine which alternative should be recommended using incremental analyses?

(Please don't use NPV function)

I want excel soution

Upon graduation, you receive two very different – job offers that will result in two different career trajectories. To keep things simple, let’s assume your salaries are paid once a year at the end of each year.

A. Option A (company A) is a job related to your background. It starts with a decent salary $75,000 per year, and increases by 3% per year after that.

B. Option B (company B) requires some initial learning, so the first 3 years has a low salary that starts at $42,000 and increases by 2% per year. At the end of year 3 (beginning of year 4), the salary increases by a factor of 2 (it doubles), and then it will increase by 6% per year every year after that.

Assume your TVOM is 5%. We want to compare these two options in short term and long term. Assume you quit both jobs after 3 years.

1. What are the present worth of each job?

2. Which offer (A or B) should you choose, if you are going to work for 10 years? 20 years? 30 years?

3. What is the minimum number of years that you become indifferent between the two job offers?

4. Generate a plot that shows the difference in the present worth of the two options (PW(A)-PW(B)) as a function of the number of years you are planning to work [from 3 years to 30 years)].

Now, we want to look into the impact of your time value of money. Suppose you will be working for 20 years.

5. What will be the level of TVOM that makes you indifferent between the two job offers?

Annual Worth Equivalent: 6. Suppose again that your TVOM is 4%, and that you are going to work for 20 years for company B. Company B can pay you using a different payment plan from what was described earlier, in which they pay you equal monthly payments for the duration of your (in this case it will be 240 equal monthly payments). What should be the size of those payments to make you indifferent between the two payment plans? (Note that the original payment plan is still based on annual payments)

With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this causal surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 10,900 in the first year, with growth of 8 percent each year for the next five years. Production of these lamps will require $63,000 in net working capital to start. Total fixed costs are $152,000 per year, variable production costs are $20 per unit, and the units are priced at $63 each. The equipment needed to begin production will cost $620,000. The equipment will be depreciated using the straight-line method over a 5-year life and is not expected to have a salvage value. The tax rate is 24 percent and the required rate of return is 16 percent. What is the NPV of this project?

Quantitative Problem 1: Assume today is December 31, 2013. Barrington Industries expects that its 2014 after-tax operating income [EBIT(1 – T)] will be $430 million and its 2014 depreciation expense will be $60 million. Barrington's 2014 gross capital expenditures are expected to be $100 million and the change in its net operating working capital for 2014 will be $20 million. The firm's free cash flow is expected to grow at a constant rate of 4.5% annually. Assume that its free cash flow occurs at the end of each year. The firm's weighted average cost of capital is 8.4%; the market value of the company's debt is $2.3 billion; and the company has 180 million shares of common stock outstanding. The firm has no preferred stock on its balance sheet and has no plans to use it for future capital budgeting projects. Using the corporate valuation model, what should be the company's stock price today (December 31, 2013)? Round your answer to the nearest cent. Do not round intermediate calculations.
$ per share

Quantitative Problem 2: Hadley Inc. forecasts the year-end free cash flows (in millions) shown below.

The weighted average cost of capital is 12%, and the FCFs are expected to continue growing at a 4% rate after Year 5. The firm has $24 million of market-value debt, but it has no preferred stock or any other outstanding claims. There are 20 million shares outstanding. What is the value of the stock price today (Year 0)? Round your answer to the nearest cent. Do not round intermediate calculations.
$ per share?

Mr. Sam Golff desires to invest a portion of his assets in rental property. He has narrowed his choices down to two apartment complexes, Palmer Heights and Crenshaw Village. After conferring with the present owners, Mr. Golff has developed the following estimates of the cash flows for these properties. Palmer Heights - Yearly After-tax Cash Inflow (in thousands)/Probability: $40/.2, 45/.2, 60/.2, 75/.2, 80/.2; Crenshaw Village - Yearly Aftertax Cash Inflow (in thousands)/Probability: $45/.4, 50/.2, 60/.1, 70/.3. a. Find the expected cash flow from each apartment complex. (Enter your answers in thousands (e.g, $10,000 should be entered as "10").) b. What is the coefficient of variation for each apartment complex? (Do not round intermediate calculations. Round your answers to 3 decimal places.) c. Which apartment complex has more risk?

Treynor Pie Company is a food company specializing in high-calorie snack foods. It is seeking to diversify its food business and lower its risks. It is examining three companies—a gourmet restaurant chain, a baby food company, and a nutritional products firm. Each of these companies can be bought at the same multiple of earnings. The following represents information about all the companies.
  

a-1. Compute the coefficient of variation for each of the four companies. (Enter your answers in millions (e.g., $100,000 should be entered as ".10"). Round your answers to 3 decimal places.)
  

a-2. Which company is the least risky?
  

a-3. Which company is the most risky?
  

b. Which of the acquisition candidates is most likely to reduce Treynor Pie Company's risk?
  

Describe data validation, absolute cell referencing, custom formatting, naming a range in Excel. Why is this important for financial modeling? Use examples.

Mr. Sam Golff desires to invest a portion of his assets in rental property. He has narrowed his choices down to two apartment complexes, Palmer Heights and Crenshaw Village. After conferring with the present owners, Mr. Golff has developed the following estimates of the cash flows for these properties.
    

a. Find the expected cash flow from each apartment complex. (Enter your answers in thousands (e.g, $10,000 should be enter as "10").)
  

  
b. What is the coefficient of variation for each apartment complex? (Do not round intermediate calculations. Round your answers to 3 decimal places.)
  

  
c. Which apartment complex has more risk?
  

Machine A: This project costs $10 million. The expected net cash flows are $4 million per year for 4 years, when is to be replaced. Machine B: It costs $15 million, and has expected cash flows of $3.5 per year for 8 years, when it will be replaced. The cost of capital is 10%. Machine prices are expected to stay steady as production efficiencies are expected to offset inflation. Evaluate these projects. a. Calculate NPV, IRR, Replacement Chain, and Equivalent Annual Annuity. b. Which project should be company accept?

Debby’s Dance Studios is considering the purchase of new sound equipment that will enhance the popularity of its aerobics dancing. The equipment will cost $33,600. Debby is not sure how many members the new equipment will attract, but she estimates that her increased annual cash flows for each of the next five years will have the following probability distribution. Debby’s cost of capital is 11 percent. Use Appendix D for an approximate answer but calculate your final answers using the formula and financial calculator methods.
  

  
a. What is the expected value of the cash flow? The value you compute will apply to each of the five years.
  

  
b. What is the expected net present value? (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places.)
  

  
c. Should Debby buy the new equipment?