Calculate and present the cash flow spreadsheet

Assignment Help Accounting Basics
Reference no: EM131465314

Burlington Northern Santa Fe Railway (BNSF) Comprehensive Capital Budgeting Decision Project

Investment Opportunities

Payback, Net present value, Cash Flow spreadsheet, internal rate of return and Modified Internal Rate of Return methods Berkshire Hathaway, led by CEO Warren Buffett, purchased the Burlington Northern Santa Fe Railway (BNSF) in 2010.  BNSF will be spending $3.4B on capital improvements in 2017 to improve their infrastructure.  Forecasting demand for rail traffic has become increasingly difficult on BNSF's northern United States rail lines due to the drop in oil prices to $50 a barrel.  In addition, President Trump is rolling bag legislation restricting the use of coal.   Buffett and his management team have brainstormed new ideas and come up with three potential Northern states rail line expansions to carry BNSF freight.  Mr. Buffett would like you to evaluate these three potential capital investments for the railroad.  Each is unique in the state the line will travel over and in the freight to be carried.  Warren Buffett is a master investor.  He is pleased with projects that exceed BNSF's cost of capital.  He requires a five year outlook on his investments. The three rail line capital improvements to be analyzed are mutually exclusive.

1. Invest in a new Minnesota Rail Line - After a two year decrease, there is an increasing demand for Frac Sand freight loads to be moved from Wisconsin and Minnesota to the oil fields of North Dakota.  Drillers have become more efficient with new Apps, such as the iSteer App, in extracting oil from the North Dakota shale underground.  With efficiencies, drillers can now be profitable at $50 a barrel of oil.  With a goal of profitability at $40 a barrel, frac sand demand is sure to increase.  Currently the frac sand can be moved to St. Paul, MN easily, but there is no direct route to the Fargo, ND railroad hub for this sand.  Buffet's team is excited about investing in this line due to the growing number of Frac Sand mines located in Wisconsin and Minnesota and the increased oil extraction efficiencies.   The freight loads are expected to increase each year for the next 10 years before leveling off for another 15 years.  Buffet forecasts Year 1 revenue at $350,000,000.  The 2017 Earnings Before Depreciation and Taxes are forecast at 28% of Revenue each year.   In Years 2 - 5, revenue is forecast to increase by 12% each year.  Competition from the Union Pacific Railroad is a threat to the forecast, but BNSF has many miles of track in the Northern U.S. already, and should be able to withstand a freight price war with Union Pacific.   The St. Paul to Fargo line will require 290 miles of track to be installed.  In addition to the track infrastructure installation - land, locomotives, and sand freight cars will have to be purchased. The projected cost per track mile is estimated to be $1.1M.  This is an all in cost that includes track, land, and trains. Land represents 10% of the investment amount.  The remaining investment amount will be taken over 15 years MACRS.   Buffet notes that the Frac Sand industry is posed for big growth and the government has made it a priority for the U.S. to become more self-reliant.  That is a great $ign.

2. Invest in a new North Dakota Rail Line - The Bakken Oil Shale Fields in North Dakota have provided Burlington Northern Santa Fe Railway with a golden opportunity to cash in by adding a rail line from Jamestown, ND to Minot, ND to move oil from Minot to the new Jamestown refineries.   Buffet estimates that the North Dakota oil fields will produce for the next 75 years.  Making an investment in this line has long term potential for a healthy return. There is some concern that the government may halt drilling in the area due to environmental concerns. This seems unlikely since the United States is seeking oil independence. In fact, there are promising geological explorations continuing in the region that could double the current output of oil.   Buffet's team is excited about investing in this line that will carry the black gold to Jamestown. The oil tanker loads are expected to increase each year for the next 25 years before leveling off for another 50 years.  He forecasts Year 1 oil tanker revenue at $375,000,000.    The 2017 Earnings Before Depreciation and Taxes are forecast at 20% of Revenue each year. In Years 2 - 5, revenue is forecast to increase by 10% each year. Track safety is a major concern with building this line due to carrying a hazardous material.  The Jamestown to Minot line will require 210 miles of track to be installed.  In addition to the track infrastructure installation - land, locomotives, and oil tanker freight cars will have to be purchased. The projected cost per track mile is estimated to be $1.2M.  This is an all in cost that includes track, land, and trains.  Land represents 10% of the investment amount.  The remaining investment amount will be taken over 15 years MACRS.   Buffet believes there are other areas in the northern United States that will open Shale Oil fields in the future.  Establishing this line would give BNSF an established tanker line to be used as an anchor track for short rail line branches.  This project smells of money!

3. Invest in a new Montana Rail Line - Coal is still a heavily used source of energy. With President Trump recently relaxing the coal emissions laws, coal traffic could increase or at least remain level.  Montana coal mines have provided Burlington Northern Santa Fe Railway with a steady cash flow for over 60 years.  The Montana Coal Mining Corporation has requested a new coal freight line to be added from Havre, Montana to Billings, Montana to move mined coal. Buffet estimates that the Havre Coal Mine will produce for the next 25 years.  Making an investment in this is a risk to BNSF.  Coal is considered a dirty source of energy and some major energy companies have shuttered their coal powered energy plants or are considering doing so in the future. Buffet's team is worried about the long-term prospects in investing in the Montana Coal Line.  On the other hand, if this line makes money, BNSF will consider it a viable investment alternative. The coal freight loads are expected to slightly decrease each year for the next 5 years before leveling off for another 20 years. Warren forecasts Year 1 coal hauling revenue at $225,000,000.  The 2017 Earnings Before Depreciation and Taxes are forecast at 33% of Revenue each year.   In Years 2 - 5, revenue is forecast to decrease by 1% each year.  The Havre to Billings route will require 230 miles of track to be installed.  In addition to the track infrastructure installation - land, locomotives, and coal freight cars will have to be purchased. The projected cost per track mile is estimated to be $0.9M.  This is an all in cost that includes track, land, and trains.  Land represents 10% of the investment amount. The remaining investment amount will be taken over 15 years MACRS.  Buffet believes there will always be a steady demand for coal.  Coal is cheap and obtainable within the United States. Establishing this line would be a major help to a loyal customer in Montana Coal Mining Corporation.  Should we help out a friend?

CEO, Warren Buffett wants to know which rail line he should be investing in for the long-term.  He has asked you to analyze the three rail line expansion alternatives identified above. BNSF requires all investments to exceed the Cost of Capital and have a positive Net Present Value. Marketing has adjusted the sales revenue projections for each of the three alternatives presented above to account for risk.

The Revenue for each project are projected as follows:

Minnesota Line    N. Dakota Line Montana Line

Year

     EBDT

      EBDT

     EBDT

 

1............

$350,000,000

$375,000,000

$225,000,000

 

2............

 

 

 

 

3............

 

 

 

 

4............

 

 

 

 

5............

 

 

 

 

Depreciation Expenses are projected as follows:

Minnesota Line    N. Dakota Line    Montana Line

Year

  Deprec.

     Deprec.

   Deprec.

 

1............

$

$

 

2............

 

 

 

 

3............

 

 

 

 

4............

 

 

 

 

5............

 

 

 

 

Tips for presentation:

A. Calculate and present the Cash flow spreadsheet, Net Present Value, Internal Rate of Return, MIRR and payback method calculations for evaluating each investment. Each investment scenario should have it's own PowerPoint slide.

B.  Show one slide that summarizes each:

                                                                   Minnesota Line     North Dakota Line       Montana Line   

Payback Period:               

Net Present Value:

Internal Rate of Return

Modified Internal Rate of Return

C.  Show one slide with your recommendation, noting potential opportunities and risks.  Be clear on your recommendation with written supporting analysis.

Reference no: EM131465314

Questions Cloud

Evaluate loyalty programs as a viable promotional tool : The purpose of this assignment is for you to evaluate frequency/loyalty programs as a viable promotional tool within an advertising program.
Importance of innovation in change management : Discuss the importance of innovation in change management, with respect to Business Process Reengineering.
Logistics management to compete in the marketplace : Describe different way in which an organization may choose a supply chain and logistics management to compete in the marketplace?
Marketing strategies used at each stage : Describe the six buyer-readiness stages along with the marketing strategies used at each stage. 300-500 OWN WORDS
Calculate and present the cash flow spreadsheet : Calculate and present the Cash flow spreadsheet, Net Present Value, Internal Rate of Return, MIRR and payback method calculations for evaluating each investment
You may model and existing small business : You may model and existing small business or create one for a business you would like to start or own in the future.
Discuss the various factors a shipper : Discuss the various factors a shipper(beneficial cargo owner-bco) would consider in chosing one supply chain over another. Explain in detail.
Write a formal letter asking companies : Write a Formal Letter asking companies to accept student interns. Portfolios are a series of tasks or communications compiled into one file.
Recipient of a 360-degree assessment : If you were a recipient of a 360-degree assessment, what kind of steps would you like to see taken to ensure you could trust the process?

Reviews

len1465314

4/17/2017 6:22:43 AM

The project should include: Cover page, Introduction Summary of Investment opportunities that will be analyzed, Supporting documentation showing your calculations for payback, net present value, cash flow statements, Internal Rate of Return and MIRR. This could be a summary page of each individual investment analyzed or contain all supporting documentation. Note risks and opportunities associated with each investment. These could be noted from the text below or researched by you and included in the report. Conclusion – give your recommendation to the management team. Attach appendix back up where appropriate.

len1465314

4/17/2017 6:22:32 AM

Need a power point completed on a capital budgeting analysis. Project must be submitted using a color Powerpoint presentation to support your position on what the company should do. You can also use excel spreadsheets to paste into the PowerPoint showing Payback method, Net Present Value method, 5 year cash flow schedule, Internal Rate of Return and Modified Internal Rate of Return calculations. Rank the proposals in order of preference. IRR should be calculated with a calculator or excel. The type of PowerPoint presentation is up to you. It should be professional, creative, personalized and created by you. ANYONE caught copying a project from any source will be given an F for the course. This is your opportunity to create a document that you can use as a template at your future employer.

Write a Review

Accounting Basics Questions & Answers

  Discuss about variable overhead spending variance

This problem belongs to Basic Accounting and it discuss about calculation of variable overhead spending variance, fixed overhead budget variance, variable overhead efficiency variance, fixed overhead volume variance

  Willing to pay for this investment

Flaherty is considering an investment that, if paid for immediately, is expected to return $140,000 five years from now. If Flaherty demands a 9% return, how much is she willing to pay for this investment?

  Teletub toys ltd manufactures and distributes a popular

teletub toys ltd manufactures and distributes a popular childrens character to toy retailers. this product requires

  Voorhees company has stockholders equity of 395900 and net

voorhees company has stockholders equity of 395900 and net income of 66900. it has a payout ratio of 12 and a return on

  Many states pension plans have assumed they will earn 8

in recent years there has been a lot of media coverage about the funding status of pension plans for state employees.

  Melchor inc offers a two-year warranty against failure of

melchor inc. offers a two-year warranty against failure of its products. the estimated liability is 2 in the year of

  Question regarding mortgage calculations

Mr. and Ms.Ostedt have just purchased an $80,000 home and made a 25% down payment. The balance can be amortized at 10% for 25 years.

  Do you believe that there are too many lawsuits in the

do you believe that there are too many lawsuits in the united states? if so do you place more blame for the problem on

  The types of decision are that should be transfered to the

the types of decision are that should be transfered to the new divisional managing directors if such reogranization is

  Is the increase in earnings per share from a favorable trend

Is the increase in earnings per share from $7.21 to $8.28 a favorable trend?

  Amortization expense for the patent

On February 2, 2011, it was determined that the patent's useful life would expire at the end of 2013. How much would Lexicon record as amortization expense for this patent for the year ending December 31, 2011?

  Discussing the operating budget and variance analysis

ACC 202: Final Project Budget Variance Report. In your opening paragraph, very briefly introduce the purpose of your paper. Recall that you will be discussing the operating budget and variance analysis as explained in your rubric instructions. Thre..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd