GSBS 6130 – Corporate Finance Trimester 1 – 2018 Written Assignment
This is an individual assignment. The assignment is marked out of 25, and counts towards 25% of the total course assessment
Word limit: 2,500 words
Due date: 11:59pm Sunday April 15, 2018
Submission Instructions:
-
Please submit the assignment in a Word document with an assignment cover sheet included via Turnitin by the due date. The assignment should include all the required tables, which can be copied and pasted from Excel. Please format the tables/ calculations in a reader-friendly way.
-
Besides the submission through Turnitin, please submit the Excel file via the Excel drop box in blackboard by the due date as well. The word file should be a stand-alone report; the Excel spreadsheet is only submitted so that your working out can be checked as required.
-
Submission by other means (email/hard copy) or forms (scanned copy) will attract no marks.
Penalties:
-
10% penalty will apply for each day of late submission.
-
Penalties will also apply if academic misconduct (plagiarism, cheating, copying etc.)
is found.
Page 1 of 6
Question 1 (10 marks)
New Economy Transport (A)
The New Economy Transport Company (NETCO) was formed in 1959 to carry cargo and passengers between ports in the Pacific Northwest and Alaska. By 2015 its fleet had grown to four vessels, including a small dry-cargo vessel, the Vital Spark.
The Vital Spark is 25 years old and badly in need of an overhaul. Peter Handy, the finance director, has just been presented with a proposal that would require the following expenditures:
Mr. Handy believes that all these outlays could be depreciated for tax purposes in the seven-year MACRS class.
NETCO’s chief engineer, McPhail, estimates the postoverhaul operating costs as follows:
These costs generally increase with inflation, which is forecasted at 2.5% a year.
The Vital Spark is carried on NETCO’s books at a net depreciated value of only $100,000, but could probably be sold “as is,” along with an extensive inventory of spare parts, for $200,000. The book value of the spare parts inventory is $40,000. Sale of the Vital Spark would generate an immediate tax liability on the difference between sale price and book value.
The chief engineer also suggests installation of a brand-new engine and control system, which would cost an extra $600,000. This additional equipment would not substantially improve the Vital Spark‘s performance, but would result in the following reduced annual fuel, labor, and maintenance costs:
Page 2 of 6
Overhaul of the Vital Spark would take it out of service for several months. The overhauled vessel would resume commercial service next year. Based on past experience, Mr. Handy believes that it would generate revenues of about $1.4 million next year, increasing with inflation thereafter.
But the Vital Spark cannot continue forever. Even if overhauled, its useful life is probably no more than 10 years, 12 years at the most. Its salvage value when finally taken out of service will be trivial.
NETCO is a conservatively financed firm in a mature business. It normally evaluates capital investments using an 11% cost of capital. This is a nominal, not a real, rate. NETCO’s tax rate is 35%.
Required:
Calculate the NPV of the proposed overhaul of the Vital Spark, with and without the new engine and control system. To do the calculation, you will have to prepare a spreadsheet table showing all costs after taxes over the vessel’s remaining economic life. Take special care with your assumptions about depreciation tax shields and inflation.
Mark allocation
Section
Table of inputs/ assumptions Calculating initial investment and sale proceeds of VITAL SPARK Treatment of depreciation Calculating operating cashflows Calculating NPV Quality of presenting the answers Conclusions based on analysis Total
Maximum mark
1 2 1 2 2 1 1 10
Page 3 of 6
Question 2 (10 marks)
New Economy Transport (B)
There is no question that the Vital Spark needs an overhaul soon. However, Mr. Handy feels it unwise to proceed without also considering the purchase of a new vessel. Cohn and Doyle, Inc., a Wisconsin shipyard, has approached NETCO with a design incorporating a Kort nozzle, extensively automated navigation and power control systems, and much more comfortable accommodations for the crew. Estimated annual operating costs of the new vessel are:
The crew would require additional training to handle the new vessel’s more complex and sophisticated equipment. Training would probably cost $50,000 next year.
The estimated operating costs for the new vessel assume that it would be operated in the same way as the Vital Spark. However, the new vessel should be able to handle a larger load on some routes, which could generate additional revenues, net of additional out-of- pocket costs, of as much as $100,000 per year. Moreover, a new vessel would have a useful service life of 20 years or more.
Cohn and Doyle offered the new vessel for a fixed price of $3,000,000, payable half immediately and half on delivery next year.
Mr. Handy stepped out on the foredeck of the Vital Spark as she chugged down the Cook Inlet. “A rusty old tub,” he muttered, “but she’s never let us down. I’ll bet we could keep her going until next year while Cohn and Doyle are building her replacement. We could use up the spare parts to keep her going. We might even be able to sell or scrap her for book value when her replacement arrives.
“But how do I compare the NPV of a new ship with the old Vital Spark? Sure, I could run a 20-year NPV spreadsheet, but I don’t have a clue how the replacement will be used in 2030 or 2035. Maybe I could compare the overall cost of overhauling and operating the Vital Spark to the cost of buying and operating the proposed replacement.”
Required
Calculate and compare the equivalent annual costs of (a) overhauling and operating the Vital Spark for 12 more years, and (b) buying and operating the proposed replacement vessel for 20 years. What should Mr. Handy do if the replacement’s annual costs are the same or lower?
Page 4 of 6
Mark allocation
Section
Calculating net investment Calculating operating cashflows Calculating equivalent annual cost Quality of presenting the answers Conclusions based on analysis Total
Maximum mark
4 2 2 1 1 10
Page 5 of 6
Question 3: (5 Marks)
You are a research analyst in an investment bank. You need to write a research report on the sensitivity of the stock return to the market return. The following model can be used to estimate the sensitivity of the stock return to the market return:
𝑅𝑖,t = α0 + β1𝑅𝑚,𝑡 + 𝜀𝑖,𝑡 (1) Where Ri,t is stock return on the ith institutions; Rm,t is return on the S&P/ASX all
Ordinaries Index (^AORD.AX); and 𝜀𝑖,𝑡 is the random error term at day t. You are required to estimate the market model (equation 1) for a period of January 1, 2010 – December 31, 2017 for the following companies:
Commonwealth Bank of Australia (CBA.AX) Rio Tinto Ltd (RIO.AX) Myer Holdings Ltd (MYR.AX)
Daily adjusted closing stock prices for companies and the All Ordinaries Index are available from: http://au.finance.yahoo.com
Required:
Write a report based on the market model as given in Equation 1 (hints: you should discuss the model, sources of data etc.; the results from the model; and the implications of the findings).
Mark allocation
Section
Writing methodology Presenting and interpreting the results Conclusions based on analysis Total
Maximum mark
2 2 1 5
Page 6 of 6