Question
In: Finance
Fascination Tool and Die began development for a new factory in the area around San Francisco,...
- Fascination Tool and Die began development for a new factory in the area around San Francisco, California. However, recent events have caused the city to shut down all construction, and withdraw building permits. Fascination has already invested $150,000 in the San Francisco building, but Dallas, Texas has offered the company an incentive to bring their factory there, instead. In Dallas, the factory would cost $8 million to build. In San Francisco, the company will incur $1.2 million in additional building costs, and will experience a 1-year delay before they are able to begin selling the product, which will mean only nine years of sales instead of ten. In Dallas, the city is also offering a $500,000 one-time up front cash incentive to convince companies to make the move. The factory in either location will build components for companies in California, so shipping them from Texas will be more costly. If the company abandons the San Francisco deal, they believe they would be able to recoup $340,000 by selling the partially finished building and land to a used car dealership. In Dallas, they will need to purchase land for $750,000 to build on. Regardless of which deal they choose, they believe the salvage value of the factory will decline rapidly, but they should be able to recoup $100,000 at the end of year 10 in either case, after which time, the product line will be obsolete, and no further production will be worthwhile. Over the 10 year period, however, either factory will be able to build 60,000 units per year. The selling price per unit is expected to be $140 each, and production costs at either plant are estimated at $36 per unit. The machinery, which initially cost $3 million, will be depreciated over 7 years, using the straightline method. Delivery cost per unit from Dallas will be $18 per unit more than from San Francisco. However, Fascination is convinced that the delays to construction will cause the company to miss the entire first year of production, while Dallas has smoothed the permitting process to allow speedy construction and eliminate that delay. The company anticipates that either project will require an additional $5 million in working capital to be committed for the life of the project, but that working capital can be recovered after the project is ended. The company's tax rate is 24%.
Given this scenario, determine and map out the relevant cash flows for capital budgeting. Then use Excel to build your spreadsheet for the 10-year calculations, and after developing your estimates of each year's cash flow under the two scenarios, use the NPV method to determine what decision the company should make regarding the factory. Assume a 9% cost of capital. Explain your answer, and turn in the spreadsheet detailing your calculations.
Solutions
Expert Solution
| San Fransico Option |
| Incurred building cost | 1.5 |
| Additional building cost | 1.2 |
| Total building cost | 2.7 |
| Delay in production | 1 year |
| Salvage value of factory | 0.1 |
| No. of units produced | 60000 |
| Selling price / unit | 140 |
| Production costs | 36 |
| Machine cost | 3 |
| Useful life of machine | 7 |
| Working capital requirement | 5 |
| Tax rate | 24% |
| Cost of capital | 9% |
| Building depreciation | |
| Total cost | 2.7 |
| No. of years | 10 |
| Yearly depreciation | 0.27 |
| Machinery depreciation | |
| Machine cost | 3 |
| No. of years | 7 |
| Yearly depreciation | 0.43 |
| Year | 0 | 1 | 2-10 | 10 |
| Initial cashflows | ||||
| Additional building cost | (1.20) | |||
| Machine cost | (3.00) | |||
| Working capital requirement | (5.00) | |||
| Total Initial cashflows | (9.20) | |||
| Operating cashflows | ||||
|
Sales (in Mn) (60000units * selling price)/10^6 |
8.40 | |||
|
Production costs (in Mn) 60000 units* production cost)/10^6 |
(2.16) | |||
| Building depreciation | (0.27) | (0.27) | ||
| Machine depreciation | (0.43) | (0.43) | ||
| Before tax | (0.70) | 5.54 | ||
| Tax @ 24% | 0.17 | (1.33) | ||
| After tax | (0.53) | 4.21 | ||
| Add: Depreciation - Building | 0.27 | 0.27 | ||
| Add: Depreciation - Machine | 0.43 | 0.43 | ||
| Total Operating Cashflows | 0.17 | 4.91 | ||
| Terminal cashflows | ||||
| Salvage value of factory | 0.10 | |||
| Working capital recoup | 5.00 | |||
| Total terminal cashflows | 5.10 | |||
| Total Cashflows | (9.20) | 0.17 | 4.91 | 5.10 |
| PV factor @ 9% | 1.00 | 0.92 | 4.66 | 0.42 |
| PV of cashflows | (9.20) | 0.15 | 22.87 | 2.15 |
| NPV | 15.98 |
| Dallas Option |
| Factory cost | 8.00 |
| Purchase of land | 0.75 |
| Upfront incentive | 0.50 |
| Sale value of San Fransico building | 0.34 |
| Salvage value of factory | 0.10 |
| No. of units produced | 60000 |
| Selling price / unit | 140.00 |
| Production costs | 36.00 |
| Machine cost | 3.00 |
| Useful life of machine | 7 |
| Delivery cost / unit | 18.00 |
| Working capital requirement | 5.00 |
| Tax rate | 24% |
| Cost of capital | 9% |
| Building depreciation | |
| Total cost | 8.75 |
| No. of years | 10.00 |
| Yearly depreciation | 0.88 |
| Machinery depreciation | |
| Machine cost | 3.00 |
| No. of years | 7.00 |
| Yearly depreciation | 0.43 |
| Year | 0 | 1-10 | 10 |
| Initial cashflows | |||
| Building and land cost | (8.75) | ||
| Machine cost | (3.00) | ||
| Working capital requirement | (5.00) | ||
| Salvage value of San Fransico building | 0.34 | ||
| Upfront incentive | 0.50 | ||
| Total Initial cashflows | (15.91) | ||
| Operating cashflows | |||
|
Sales (in Mn) (60000units * selling price)/10^6 |
8.40 | ||
|
Production costs (in Mn) 60000 units* production cost)/10^6 |
(2.16) | ||
| Delviery cost (in Mn) | (1.08) | ||
| Building depreciation | (0.88) | ||
| Machine depreciation | (0.43) | ||
| Before tax | 3.86 | ||
| Tax @ 24% | (0.93) | ||
| After tax | 2.93 | ||
| Add: Depreciation - Building | 0.88 | ||
| Add: Depreciation - Machine | 0.43 | ||
| Total Operating Cashflows | 4.23 | ||
| Terminal cashflows | |||
| Salvage value of factory | 0.10 | ||
| Working capital recoup | 5.00 | ||
| Total terminal cashflows | 5.10 | ||
| Total Cashflows | (15.91) | 4.23 | 5.10 |
| PV factor @ 9% | 1.00 | 6.42 | 0.42 |
| PV of cashflows | (15.91) | 27.18 |
 jeff jeffy answered 2 hours agoRelated SolutionsA survey was conducted in the San Francisco Bay area in which each participating individual was...A survey was conducted in the San Francisco Bay area in which
each participating individual was classified according to the type
of vehicle used most often and city of residence. A subset of the
resulting data are given in the accompanying table. Do the data
provide convincing evidence of an association between city of
residence and vehicle type? Use a significance level of 0.05. You
may assume that it is reasonable to regard the sample as a random
sample of...
Taxi Dancing around the Question of Regulation Uber is a ridesharing service introduced in San Francisco...Taxi Dancing around the Question of Regulation
Uber is a ridesharing service introduced in San Francisco in
2009 and quickly expanded to 140 U.S. cities and 40 foreign
countries. Customers “e-hail” a ride through an app on their
smartphone and a ride is there within minutes. The service is
cheaper than a typical taxi and there is no cash involved as the
charges come straight from the customer’s credit card. The service
has its detractors, including cab services and some...
Question 5 An urban planner is researching commute times in the San Francisco Bay Area to...Question 5
An urban planner is researching commute times in the San
Francisco Bay Area to find out if commute times have increased. In
which of the following situations could the urban planner use a
hypothesis test for a population mean? Check all that apply.
The urban planner asks a simple random sample of 110 commuters
in the San Francisco Bay Area if they believe their commute time
has increased in the past year. The urban planner will compute the...
Total mercury (Hg) concentrations in the San Francisco Bay Area are reported to be 1.25 ng/L...Total mercury (Hg) concentrations in the San Francisco Bay Area
are reported to be 1.25 ng/L in water, 8 mg/L in rain, 2.1 mg/m3 in
air, and 250 ng in 1 g of dry sediment. Report all these
concentrations in ppt. Assume the air temperature is 20○C,
atmospheric pressure is 1 atm, and Hg in air is in gaseous form.
[Note: MWHg = 200 g/mole
DistCo, a large warehouse service company in the San Francisco Bay Area, stores pharmaceutical products for...DistCo, a large warehouse service company in the San Francisco
Bay Area, stores pharmaceutical products for customers while they
are in transit to local retailers. DistCo can store a maximum of
280,000 cases of products at its present facility. Because their
business has been growing, the company's management wonders if they
should acquire other warehouses in 2001.
The materials specialist has accumulated the following inventory
data: Inventory (thousand Year Quarter Period of cases)
Inventory (thousand
Year
Quarter Period of...
Brothers Anthony and Christopher Gaber began operations of thier tool and die shop (A & C...Brothers Anthony and Christopher Gaber began operations of thier
tool and die shop (A & C Tools Inc.) on January 1, 2016. The
company's fiscal year ends on December 31. The trial balance on
January 1, 2017, was as follows:
Account No.
Account Titles
Debit
Credit
01
Cash
$3,000
02
Account receivable
5,000
03
Service supplies inventory
12,000
04
Land
05
Equipment
60,000
06
Accumulated depreciation (equipment)
$6,000
07
Other assets (not detailed, to simplify)
4,000
11
Account payable
5,000...
Brothers Mike and Tim Hargen began operations of their tool and die shop (H & H...Brothers Mike and Tim Hargen began operations of their tool and
die shop (H & H Tool, Inc.) on January 1, 2016. The annual
reporting period ends December 31. The trial balance on January 1,
2017, follows:
Account Titles
Debit
Credit
Cash
12,000
Accounts receivable
11,000
Supplies
26,000
Land
Equipment
93,000
Accumulated depreciation (on equipment)
12,000
Other assets (not detailed to simplify)
7,000
Accounts payable
Wages payable
Interest payable
Income taxes payable
Long-term notes payable
Common stock (6,000 shares, $.50...
Suppose the straight-line distance between New York and San Francisco is 4.1 × 106 m (neglecting...Suppose the straight-line distance between New York and San
Francisco is 4.1 × 106 m (neglecting the curvature of the earth). A
UFO is flying between these two cities at a speed of 0.68c relative
to the earth. What do the voyagers aboard the UFO measure for this
distance?
The total energy of an object is 7.86 × 1012 J, and
its kinetic energy is 6.00 × 1012 J. What is the mass
m of the object?
A radar antenna...
3. Tom’s Tool & Die uses a predetermined factory overhead rate based on machine-hours. For August, Tom’s...3. Tom’s Tool & Die uses a predetermined factory
overhead rate based on machine-hours. For August, Tom’s budgeted
overhead was $150,500 based on a budgeted volume of 43,000
machine-hours. Actual overhead amounted to $143,000 with actual
machine-hours totaling 40,500.
Required:
What was over- or underapplied manufacturing overhead in August?
(Do not round intermediate calculations.)
4. Marine Components produces parts for airplanes and ships. The
parts are produced to specification by their customers, who pay
either a fixed price (the price...
Two options are considered to power a new factory located in a rural area, a small-scale...Two options are considered to power a new factory located in a
rural area, a small-scale solar farm, or a new power-line.
Solar cells will cost $16,600 to install. Annual costs for
inspection are expected to be $2,400.
A new power line will cost $31,000 to install, with power costs
expected to be $1,000 per year.
Assume mutually exclusive projects, and both projects have a
useful life of 5 years with no salvage value. At an interest rate
of 10%...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|