Calculate the after-tax cash flows

Assignment Help Corporate Finance
Reference no: EM132125655

Assignment -

Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their first manufacturing facility in Albury Wodonga in 1966. Since then they have expanded their manufacturing footprint to include other sites in regional Australia and New Zealand including a world-leading manufacturing site opened in Bathurst, NSW in 2015.

Saturn Petcare Australia New Zealand manufactures for the Australian and New Zealand domestic markets as well as exporting products to more than 26 countries. Saturn Petcare is part of the larger overall Saturn Group which is globally one of the largest privately held manufacturing companies and operates in a range of different fast moving consumer goods (FMCG) sectors including manufacturing well-known chocolate, confectionary, and food brands as well as pet food and pet care products.

The Saturn Petcare product range has been under significant pressure over the last five years of trading. Almost 80% of Saturn Petcare sales in the Australian pet food market come from sales to the Woolworth and Coles supermarket groups. Because of structural changes in the grocery industry (including the impact of the entry into Australia of global chains such as Aldi) and the increasing development of internal house brands Saturn has driven growth in sales through price discounting. Sales of the once premium dog food brand 'Friend' at full price (without discounting) are now only 30% of total sales, with almost 70% of sales being made with Saturn offering some form of discount to the retailer. Also, both Woolworths and Coles are actively developing and promoting more sophisticated house brands which are given prime shelf position, have similar packaging, and compete directly with Saturn's products. A by-product of constantly being on sale is that householder consumers come to expect discounts and this ultimately damages brand equity. Saturn Petcare is facing a difficult trading time.

Problem: Nathan Quinlivan, the Demand and Strategy Finance director for Saturn Petcare Australia New Zealand, believes that Saturn needs to move away from the discounting model of driving growth and should develop new products in order to retain strong margin after conversion metrics. The company has conducted several rounds of independent research costing $500,000 and believes that a new 'Buddy' wet dog food product can be expected to achieve sales of AUD $20 million in the first year at $1.25 per can (unit sales of 16 million cans). Whilst unit sales are expected to remain at the same level, sales price over the life of the product is expected to increase at the long-term rate of inflation (estimated at 2.35%). Margin after conversion (gross profit) on the product is targeted at 30%. Raw materials and packaging costs vary directly with production and make up 50% of total manufacturing costs. The remaining manufacturing costs in the proposed hi-tech factory (including labour and utilities expenditure) will be 80% fixed costs and 20% variable costs. The budget for the first year of production estimates a gross profit (margin after conversion) of $6 million from the budgeted $20 million in sales. Manufacturing costs of $14 million can be broken up as $7 million raw materials and $7 million in conversion costs. Fixed conversion costs are estimated to be $5.6 million and variable conversion costs are $1.4 million ($0.0875 per unit in the first year).

You have been asked to conduct a capital budgeting analysis of the viability of the proposed new 'Buddy' pet food range. Saturn have a global target return on investment of 20% pa.

If Saturn proceed with this product launch a new manufacturing facility and production line with an annual production capacity of 28 million cans will be constructed at an estimated cost of $20 million. The new 'Buddy' product is being evaluated on the basis that it will have a 10 year product lifecycle. The new production facility will be depreciated on a straight line basis over the 10 year lifecycle to zero. Because of anticipated technology changes the production facility is expected to have a salvage value of $5 million at the end of 10 years. Saturn are an international company and pay Australian tax at the rate of 30% on profits. The capital budgeting analysis should be conducted on an after tax basis.

Prepare an excel spreadsheet calculating whether this product will satisfy the investment parameters set by Saturn Group global.

(i) Required: For the proposed 'Buddy' capital investment calculate the following:

  • After-tax cash flows
  • Payback period).
  • Net present value
  • Profitability index)

Nathan Quinlivan advises you that he is concerned about the increasingly challenging business environment facing Saturn Petcare and would like to conduct some 'what if' analysis of the proposed 'Buddy' product line capital investment. Nathan is particularly concerned that traditional financial analysis does not take into account the operating leverage impact caused by the high fixed cost component in modern automated manufacturing facilities. He asks you to develop spreadsheet analysis which shows the impact of achieving 10% lower and 10% higher than the budgeted sales projections of 16,000,000 units. Nathan asks that this analysis include the leveraging impact of utilising fixed costs by showing manufacturing costs broken down between fixed and variable components.

(ii) Required:

(a) For the proposed 'Buddy' capital investment with sales at 5% higher than estimated calculate the following:

  • After-tax cash flows.
  • Net present value

(b) For the proposed 'Buddy' capital investment with sales at 5% lower than estimated calculate the following:

  • After-tax cash flows
  • Net present value

IMPORTANT: In your analysis remember that Fixed Costs do not vary with increases/decreases in production/sales. Include Fixed and Variable Costs separately to show how operating leverage will impact on costs per unit and enable you to identify any multiplier effect on expected cash flows.

(c) Discuss your findings in the three cash flow analyses developed (above) and make a recommendation to Mr Quinlivan as to whether to proceed with the 'Buddy' proposal. Discuss any other issues or items that you think will (or should) impact on his decision including the impact of spare production capacity at the proposed new factory.

(iii) Required:

Saturn Petcare are planning an upgrade to their Bathurst manufacturing facility which will improve product processing times and deliver savings. Management have been presented with two replacement options. You have been asked to advise, from a financial management point of view, which would be the best Option for the firm to install. Because this is an upgrade for an existing production line expenditure of this type is assessed using a risk adjusted rate of only 6%. Both options have the same cost and will deliver cash flows as detailed in the table below:

Year

Option A

Option B

0

475,000

475,000

1

100,000

80,000

2

100,000

80,000

3

100,000

80,000

4

100,000

80,000

5

100,000

80,000

6

100,000

80,000

7

 

80,000

8

 

80,000

9

 

80,000

Provide a fully worked analysis of which upgrade option should be undertaken.

Explain the criteria on which you have based your decision

Part B - Report

Guidelines: For this assignment, you are encouraged to use the information provided on the firm's corporate websites together with the following sources:

  • OneSource: Global Business Browser
  • Australian Stock Exchange
  • Yahoo Finance
  • Reuters

News sources such as those secured through the Library's ANZ Newsstream and Factiva databases are also likely to be relevant. Show all your calculation on the annexure.

Your report should include:

  • A brief executive summary.
  • Introduction.
  • Body (use appropriate headings and sub-headings as relevant sign-posts).
  • Conclusion.

Required:

AMP Limited is a large financial services company which commenced trading in 1849 as the Australian Mutual Provident Society (AMP). It demutualised and listed on the Australian Stock Exchange (ASX) in 1998. AMP provide a range of financial services to customers in Australia and New Zealand including banking, financial planning, wealth management and superannuation services.

As part of the finance team of AMP Limited you have been tasked with reviewing and preparing a report on the capital structure of the firm and critique whether the firm has been successful in maximising wealth generation for shareholders.

Your report should be approximately 1000 words (in total) and cover the following areas:

Using data from the firm's 2017 financial year annual report and other sources assume that the firm has a Beta of 1.47 (Reuters) and that capital return on the market for 2017 was 8.54%:

  • Categorise the AMP's current capital structure into debt and equity.
  • Calculate the firm's after-tax Weighted Average Cost of Capital.
  • Using the CAPM calculate whether the firm is providing an appropriate return given its risk.
  • Compare the firm's capital structure with at least one other firm operating within a similar industry.

Identify and critically analyse key financial ratios for AMP Limited.

Outline and discuss any significant changes to have occurred to the firm's capital structure during the past three years.

In the 2017 Annual Report (p.24) AMP's Directors identified seven (7) material risks facing the business. Given the impact on the share price of AMP following evidence given to the Financial Services Royal Commission discuss whether you believe this list is adequate or properly represents the risks that AMP were facing at the end of the 2017 calendar year. In your response critically evaluate the extent to which the firm has been successful in managing its risk and maximising wealth for shareholders in the past three years (approx. 450-600 words).

Attachment:- Assignment File.rar

Verified Expert

It is an Australian economy based assignment which ensures two aspects one being the in relation to the royal commission and how the committee helps in identifying fraud and other allied matters and how its impact the financial industry in that economy the other is the fact how the project analysis computation method helps in justifying the products and it benefits. To attain this segment it is essential to have a great knowledge about the fiancial concepts.

Reference no: EM132125655

Questions Cloud

Write the codes for paradise and airspeed : Draw the optimal coding tree and the (weighted) average code length. Show the steps. Write the codes for "paradise" and "airspeed".
Research the concept of compilation with regards to code : Research the concept of compilation with regards to code. Is there a difference in how scripts are compiled vs. how programs are compiled?
Why is the software necessary for the career that you chose : Why is the software necessary for the career that you chose? The Subject is actually Foundations of Information Technology.
Add the code to control the loop : Add the code to control the loop. You may use either a while loop or a do...while loop.
Calculate the after-tax cash flows : For the proposed 'Buddy' capital investment with sales at 5% lower than estimated calculate the after-tax cash flows
How many do you see that are listening : How many do you see that are listening (meaning, there are programs that are waiting for connections from other systems)?
Provide input to thoroughly test the dfa : A run in a setting is a substring of length at least two, as long as possible, and consisting entirely of the same symbol.
Tcp ensures error free transmission-is it true or false : Non-persistent TCP connection takes more time for data transfer (compared to a persistent connection). Is it true or false.
Why is rsa believed to be hard to break : Why is RSA believed to be hard to break? I. E. The complexity of what computational problem leads to the belief that it is secure?

Reviews

urv2125655

10/26/2018 3:39:54 AM

Please change the 5% lower and 5% higher in the question to 10% lower and 10 higher in solution for me. we were just told by the lecture to do so. Thanks. Thanks the solution you have provided is very good , I sent my wishes to the expert when I received the solution from your team but now I have received the gradings as well. I am very much impressed with the work. This is worth buying the assignment, Thanks once more.

urv2125655

10/26/2018 3:35:09 AM

I understand the solution is for the calculation of requirement and amend it according to the following needs: (i) Required: For the proposed ‘Buddy’ capital investment calculate the following: • After-tax cash flows • Payback period). • Net present value • Profitability index) (ii) Required: (a) For the proposed ‘Buddy’ capital investment with sales at 5% higher than estimated calculate the following: • After-tax cash flows. • Net present value (b) For the proposed ‘Buddy’ capital investment with sales at 5% lower than estimated calculate the following: • After-tax cash flows • Net present value NB: please the lecture just told us to can the 5% lower and 5% higher to 10% lower and 10% higher. Please, the solution is in word so please provide the formulas in the calculation the above requirement. Please also indicate the solution to the required number so as to know which solution for what-question number. Please provide the formulas in getting the answer. please the solution in word format only. Thanks

Write a Review

Corporate Finance Questions & Answers

  Compute an effective annualized interest rate cost for usd

Compute an effective annualized interest rate cost (all-in cost) for the USD tranche of the Eurobond. What information would you need to obtain the dollar all-in cost of the yen tranche?

  Determine the profitability of each product line

Assign administrative overhead costs to the two product lines based on ABC, using the cost drivers designated in the data provided above. Determine the profitability of each product line (in dollars and percentages)

  Is there anything unethical in president turnbulls actions

Who are the stakeholders in this situation? Is there anything unethical in president Turnbull's actions? Should you as controller remain silent? Does Perry have any responsibility?

  Eliminates departments with sales dollars that are less

Suresh Co. expects its five departments to yield the following income for next year.

  How much should you place in the retirement fund

How much should you place in the retirement fund each year for the next 20 years to reach your retirement goal, assuming you can earn 12% per year on your retirement fund investment? Show your formulas and input

  How financial forecasting is essential to strategic growth

Prepare a 600 word essay (2-3 pages) in which you explain how financial forecasting is essential to the strategic growth of a firm.

  Explain what is meant by the term distribution policy

What is meant by the term "distribution policy"? How has the mix of dividend payouts and stock repurchases changed over time?

  Question 1a firm is issuing a two-year debt in the amount

question 1a firm is issuing a two-year debt in the amount of 200000. the current market value of the assets is 300000.

  How many procedures are attributed to each payer

How many procedures are attributed to each payer? How much is total net revenue for each payer, and how much is total contractual allowance for each payer?

  Laptop plc is planning on setting up a laptop repair centre

laptop plc. is planning on setting up a laptop repair centre. they estimate thatthe required investment will be

  Difference between the two firms roes

What would be VF's new WACC and its new value of operations - what would the stock price be if VF issued the new debt and immediately used the proceeds to repurchase stock?

  Find the effective annual rate

Determine the total annual cost of each of the three possible financing strategies and Find the effective annual rate under: 1) the line-of-credit agreement and 2) the revolving credit agreement.

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