Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash Flow Analysis Use the CF analysis-thin slab Excel spreadsheet provided as a template to calculate the cash flows Nucor could expect if it adopted

  1. Cash Flow Analysis

Use the"CF analysis-thin slab"Excel spreadsheet provided as a template to calculate the cash flows Nucor could expect if it adopted SMS's CSP process. Most of the critical data is already in the spreadsheet, drawn primarily from Exhibits 12A and 12B. Please adhere to the following assumptions and conventions:

  • Use 6.45% as the growth rate for the price of steel, not the historical 6.84%
  • Assume the entire $280 million construction cost is incurred in 1986
  • Depreciate the factory equally over 10 years (1989-1998). The spreadsheet says 12 years, which includes the two years the factory is under construction (1987, 1988). I want you to start in 1989, when the plant comes on line, and assume it loses all value over the next 10 years.
  • Note that in applying its investment criterion, Nucor ignored start-up expenses and working capital costs. Thus, in figuring the assets of the minimill in 1989 or later, those expenses need to beaddedto the asset base before calculating ROA.

  1. By Nucor's own investment criterion (i.e., 25% return on assets at five years), what will CEO Ken Iverson think about this investment?
  2. As a consultant using more traditional investment criteria (such as NPV or IRR), what do you think about this investment from this part of the analysis?

Exhibit 12B
ModernizedUnmodernized
Thin-slab MinimillIntegrated MillIntegrated Mill
HRCRHRCRHRCR
Operating assumptions
Labor / hour$20.00$20.00$23.50$23.50$23.50$23.50
Scrap / ton$90.00$90.00$80.00$80.00$80.00$80.00
Man hours / ton1.752.652.854.503.905.85
Capacity Utilization90.00%90.00%90.00%90.00%75.00%75.00%
Operation costs / ton
Labor$35.00$53.00$67.00$105.50$91.50$141.00
Ore0051545256
Coal003537.53840.5
Energy24389239.525
Scrap10010213.59.519.515.5
Materials and supplies5672.5719372.595.5
Maintenance & repairs1017.51526.51729.5
Total costs / ton$225.00$283.00$261.50$349.00$300.00$403.00
Revenue / ton$306.50$390.50$326.00$454.50$325.00$453.00
image text in transcribedimage text in transcribedimage text in transcribed
\fModernized integrated millUnmodemized integrated m

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Clinical Work And General Management Of A Standard Minimal Resource Facility

Authors: Musa Touray, Aisha Touray

1st Edition

3030710319, 978-3030710316

More Books

Students also viewed these General Management questions