Investment Decision- Financial perspective


Case study; Finance

Investment Decision- Financial perspective

Academic level: Master’s
Subject or discipline: Finance
Title: Investment Decision- Financial perspective
Formatting Style: APA
 

 

Paper details

Mr Murray wants to see some type of risk analysis on the project as it may look profitable, but he worries that there is a chance it might turn out to be a loser. You met with the marketing and production managers to get a feel for the uncertainties which may impact the cash flow estimates. After several rounds of discussions, they conclude that revenue at the end of the first year could vary by ±25%, and variable costs by ±35% from the initial projections.There are some calculations must be done by using excel. But the final assignment must be word document format. All other excel file should be place at appendix of word document like JPEG of the screenshots as a prove of calculations. Example file and the lecturer’s notes will be provided.
After reviewing the data provided, you realise that the revenue and cost figures have not been adjusted for inflation which is expected to average 5% per year over the next 4 to 6 years. Inflation impacts the firm’s revenues and costs at varying degrees. For both chip crushers, the sales revenues are expected to increase by 5% per year after Year 1. However, variable costs, salaries and marketing costs are expected to increase by only 3% p.a. after Year 1, because half of the costs are fixed by long-term contracts.Document Formatting
1. Your discussions should not exceed 1000 words for the entire executive summary. It needs to be readable. Use 12pt. Times New Roman font with 1.5 pt paragraph spacing.
2. Only accepts the submission of one document. Copy all Excel tables and paste them as a picture (JPEG) in your Word document.

Assignment Instructions
Neways Tractor Corporation owns and operates a transmission and axle plant. The company manufactures more than half of the transmissions and axles used in tractors and harvesting equipment servicing Australia’s agricultural industry. Extensive machining is performed on steel parts for the final assembly of transmissions and axles, so a very large amount of steel shavings and bulky steel scrap is generated at this plant. The unprocessed steep scrap is sold as a by-product of the manufacturing operation to various firms involved in the recycling process.
The executive committee wants to evaluate whether to process the scrap into different grades and types of usable steel. Using different models of chip crushers, the scrap can be grinded and compressed into either rough or fine scrap. Neways has to decide whether to invest in the high-cost chip crusher (HCC) to produce fine scrap, or the low-cost chip crusher (LCC) to produce rough scrap.
You have gathered the relevant purchase prices and operating costs of the two chip crushes from the supplier, along with information on marketing and staff costs. Key estimates of financial data (before-tax) for the two machines are summarised below:

LCC HCC
Machine cost $400,000 $480,000
Life (years) 4 6
Depreciation Straight-line over 4 years over 6 years
Salvage value – end of useful life $80,000 $48,000
Annual interest expense on loan $48,000 $48,000
Annual revenue from scrap sales $450,000 $500,000
Annual operating costs:
– Variable costs $50,000 $150,000
– Salaries $80,000 $110,000
– Marketing $45,000 $60,000

The calculation for annual operating costs comprise of the following items:
– Variable costs are direct operating expenses incurred in the production of the rough or fine scrap.
– Salaries for the LCC machine comprise of employing two new operators at a salary of $40,000 per annum
each.
– For the HCC machine, the company will only need to employ one new machine operator with a salary of
$40,000 per annum. The second operator who earns $70,000 per annum will be transferred to this division
from the axle assembly plant.
– Marketing costs are paid at the start of each year.
Neways is a private company, soundly financed and consistently profitable. Cash on hand is not sufficient to buy the chip crusher. However Mr Jack Murray the CEO, is confident that the cost of the chip crusher could be financed with medium-term debt. The company currently has an existing mortgage with $1 million outstanding. This is financed at a rate of 10% per annum. If the firm chooses either machine, it will arrange to borrow $400,000 at a fixed rate of 12% per annum, payable over 4 years. The firm’s has $3 million worth of issued shares, and investors expected to earn a 19% per annum rate of return. Should the firm choose to proceed with either machine and the firm commits to the new loan, this is expected to impact the company’s average cost of capital.

The company’s accountant Mr Peter Smith, pointed out to you that the revenue figures do not take into consideration the impact of this project on current sales of unprocessed scrap. The current unprocessed scrap generates a before-tax net income of $50,000 per year.
Production for the rough or fine scrap would be set up in an unused section of Neway’s main plant. This section has been unused for years and consequently had suffered some deterioration. Last year as part of a routine facility improvement program, Neways spent $75,000 to rehabilitate the very same section of the plant. Mr Smith believes this outlay which has already been paid and expensed for tax purposes in last year’s income statement, should be charged to this steel scrap project. He argues that if the rehabilitation had not taken place, the firm would have to spend the money to repurpose the site for the steel scrap project anyway.

Your task is to prepare an investment recommendation in the form of an executive summary to Mr Murray and the executive committee of Neways Tractor Corporation, indicating whether the firm should invest in the LCC or the HCC. Your recommendation should address the issues from Questions 1 to 8. Your executive summary should start by outlining your recommendation. You should also discuss the assumptions you have made, and justify your choice based on sound investment selection criterions. The committee would also like to be informed on key areas of concern impacting the feasibility of the project. Your workings and calculations must be attached at the back of your recommendation as supporting material.

Address the following when putting together your analyses and Executive Summary.

1. Estimate the appropriate Weighted Average Cost of Capital (WACC) applicable as the project’s required rate of return.

2. Discuss if the following should or should not be included in your incremental cash flow calculations:
· The yearly interest expense on the $400,000 loan.
· Salaries of the machine operators.
· The $75,000 spent to rehabilitate the plant.
· Unprocessed scrap income of $50,000 per year.

3. Prepare the incremental cash flow tables for the 4-year LCC and the 6-year HCC. Assume these are the
base case scenarios for each.

4. Which machine is recommended based on the Net Present Value, Internal Rate of Return, Profitability Index, and Payback Period criterions?

5. How would your recommendation change when the difference in project lifespans are taken into consideration?
Page 4 of 6

6. Rework your analyses from Questions 3, 4 and 5 for both machines, taking into consideration the possible variations in revenue and variable costs estimates at the end of Year 1. Report the results of your sensitivity analysis and discuss how this will impact the choice between LCC and HCC.

7. Determine the minimum level of revenues and maximum level of variable costs in order to breakeven, for the machine recommended in Question 6.

Marking Guide

Question 1 WACC calculation
4 marks

Question 2
Discussions – Explanations are clear, with reasoning, and based on correct financial principles
8 marks

Question 3
Incremental cash flow tables (base case) for LCC and HCC
14 marks

Question 4
NPV, IRR, PI and Payback Periods calculations
Discussion – comparisons of LCC and HCC, and investment recommendation.
4 marks 4 marks

Question 5
Unequal lives analysis
Discussions – comparisons of LCC and HCC, and investment recommendation.
2 marks 2 marks

Question 6
Sensitivity analysis
Discussions – comparisons of LCC and HCC, and investment recommendation.
8 marks 3 marks

Question 7
Breakeven analysis
Discussions – clear and relevant suggestions to management.
4 marks 2 marks

Quality of document presentation Language, grammar and spelling
5 marks

 

Neways Tractor Corporation
Neways has to decide whether to invest in the high-cost chip crusher (HCC) to produce fine scrap, or the low-cost chip crusher (LCC) to produce rough scrap.
LCC HCC
Machine cost $400,000 $480,000
Life (years) 4 6
Depreciation Straight-line over 4 years Straight-line over 6 years
Salvage value – end of useful life $80,000 $48,000
Annual interest expense on loan $48,000 $48,000
Annual revenue from scrap sales $450,000 $500,000
Annual operating costs:
– Variable costs $50,000 $150,000
– Salaries $80,000 $110,000
– Marketing $45,000 $60,000
Variable costs are direct operating expenses incurred in the production of the rough or fine scrap.
existing mortgage $1 million
financed at a rate each year 10%
if buy borrow $400,000 payable over 4 years
fixed rate each year 12%
value worth of shares $3 million Should the firm choose to proceed with either machine and the firm commits to the new loan, this is expected to impact the company’s average cost of capital.
investors expected to earn each year 19%
income current unprocessed scrap each year $50,000
expense rehabilitate plant $75,000
revenue at the end of the first year ±25%
variable costs ±35%
Inflation each year 5% revenue and cost
sales revenue 5% increase
variable costs 3% increase
salaries 3% increase
marketing cost 3% increase
notes
Did you notice that there’s no mention of a tax rate for Neways Tractor Corporation?
You still need to evaluate if the investment is worthwhile on a after-tax basis.
Since it’s an Australian company, use the statutory rate of 30%.
 “we recommend the board chooses….the analysis was conducted and the results indicate….the firm need to consider key risk factors such as.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: