Question
You are the newly appointed Chief Financial Officer (CFO) of Redbull Racing Enterprises, a professional V8 Racing team, competing in the Australian Super Car series.
You are the newly appointed Chief Financial Officer (CFO) of Redbull Racing Enterprises, a professional V8 Racing team, competing in the Australian Super Car series. The Head of Telemetry came to you to ask for approval to proceed with a Telemetry project that could improve the quality of data being captured and analysed during and after a race. If implemented, this new project could potentially assist drivers to increase the performance of their cars and ultimately lead to valuable racing wins. By using the below information set out in the Project Outline and your knowledge of project evaluation techniques, you need to make a decision to approve or reject this new project. You are requested to compile a spreadsheet in Microsoft Excel (DO NOT USE NOTES) indicating all cash flows over the time period of the project. All assumptions, formulas and calculations should be clearly shown. All calculations should be rounded to 2 decimal places.
Project Briefing: RedBull Racing Enterprises Telemetry Department is looking at a new Telemetry project with the initial pilot project expected to be for five years. You have been briefed by the previous CFO, that the company's expected marginal tax rate is 30% over the life of the project and tax is paid at the end of the year in which the cash flows occur. Tax depreciation is straight line over 4 years. Expected inflation rate over the next five years is 7% and the company's cost of capital is 12%. It is further assumed that there will be a growth of 2.5% after the initial pilot project is implemented. It was also communicated that Working Capital requirements are 10% of Gross Profit and is assumed to be needed at the start of the year. A new datacenter which consists of servers and networking equipment will be built on a new property. The property will be a non-depreciable capital requirement with estimated cost of $400,000 and is expected to maintain its value in real terms (i.e. to increase in value with inflation). The servers and networking equipment for the datacenter is needed immediately if the project is given approval to proceed. The cost for this new datacenter is estimated to be $850,000 including freight and installation for the servers and networking equipment. Salvage value is expected to be $75,000 at the end of Year 5. The company plans to borrow the $850,000 for the hardware platform from Westpac Bank at an interest rate of 8% per annum. It will use retained earnings to fund the purchase of the property, although to afford this, it will reduce its dividend payments by $70,000 per year for the five years. The RedBull Telemetry Department employs 5 engineers at a cost of $50,000 per engineer per year. It is estimated that this new project will make use of one engineer to design the Telemetry system in the first year on a full time bases and only half of his time will be required for the remainder of the project. 3 To promote the new product to new potential customers, the company will spend $80,000 on direct marketing in the second year of the pilot project. Real gains are subject to capital gains tax at the marginal rate. Gross Profit (assume at end of year) from operations for Year 1 is estimated at $350,000 and will grow by 10% for Year 2 and Year 3 respectively. From Year 4 it is expected that the Gross Profit will decrease by 20% until completion of the pilot project. Make a recommendation and motivate if the company should undertake this project.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started