# Corporate Finance Project Help

Corporate Finance Project

## Project Description

Orange Computers has transformed into one of the largest smartphone companies in the world. Based on recent changes to the federal tax code, building phones in the US has become more attractive. Orange wants to build a single factory in either Pennsylvania, Texas, or North Carolina. Each state is oﬀering incentives to woo Orange. Pennsylvania and Texas have proposed building a new facility, while North Carolina is oﬀering grants to help renovate a recently closed factory.

Build a workbook to calculate the net present value and internal rate of return (rounded to two decimal places) for each location over ten years using the information provided. Determine where Orange should locate their factory and give a brief explanation of why.

Below are the pieces of information necessary to calculate the net present value and internal rate of return:

1. The factories in Pennsylvania and Texas could produce and sell 20 million phones annually, while the North Carolina factory could produce and sell 12 million.
2. Orange can sell all the phones produced at an average of \$400 per phone in 20231. Orange forecasts that they can gradually raise the price of their phones by 2% per year over the next 10 years.

1 Assume upfront investments in land, factory, and equipment are made in 2022.

• A new factory would be 5 million square feet at a cost of \$160/ft2 to build in Pennsylvania or Texas. After grants, Orange would only need to pay \$125/ft2 to renovate the existing 3 million square foot factory in North Carolina.
• Pennsylvania will lease publicly owned land for the factory to Orange tax free, but the local government won’t waive the 1% annual property tax which is calculated on the initial cost of the factory. The land in Texas will cost \$20 million, and the local property tax is 0.5%, calculated based on the initial cost of the factory plus the cost of the land. Since there is an existing factory in North Carolina, there will be no cost in purchasing the land, and the state has agreed to pay the local property tax for 10 years.
• Orange plans to spend \$500 million on equipment for the new factories in Texas or Pennsylvania. Salvage value for the equipment after 10 years is expected to be 10% of the equipment’s purchase price. North Carolina is oﬀering to help pay for the equipment which lowers the cost to \$300 million, but it has added a caveat that forces Orange to sell the equipment to the state for \$1 when Orange disposes of the equipment after 10 years.
• Orange can depreciate 100% of the cost of equipment when it’s put into service for tax purposes.2 (Since salvage value will be taxed as a gain at the end of 10 years, do not subtract it from the equipment’s value for depreciation.) All other depreciation will be on a straight-line basis over 15 years. (Don’t forget that there is no depreciation on land.)
• The federal income tax rate for Orange is 21%. In their pursuit of new manufacturing jobs, all three states have oﬀered diﬀerent incentive packages that result in a state income tax equivalent to 3% for the ﬁrst 10 years. State income tax is not deductible on federal taxes, so the eﬀective tax rate is 24%.
• Orange plans on hiring 8,000 workers in Pennsylvania or Texas with a total annual expense of \$80,000 per worker. The factory in North Carolina would require 5,000 workers at \$90,000 per year. Wage inﬂation is forecasted to be 5% per year in Pennsylvania, 4% in Texas, and 3% in North Carolina over the life of the project.
• For operational expenses, assume that ﬁxed overhead will be 10% of annual sales and cost of goods sold (excluding labor) will be 60% of annual sales at each factory. Orange will also need to maintain a total of 10% of next year’s sales in working capital. In other words, this is the cash that Orange will have to reserve for this project. It cannot be used elsewhere in the company.3

2 The U.S. passed the Tax Cuts and Jobs Act (TCJA) in 2017, which allows companies to depreciate 100% of the equipment cost in the same year that it is put into service. This is also called Bonus Depreciation.

3 The case template has been pre-populated with the required formulas to capture working capital movements from one year to another. Note that working capital is released at the end of the project life (10 years).

1. Orange keeps a stable debt-to-equity ratio of 0.8 and will use the same mix of debt and equity to ﬁnance this project. The average interest rate on its debt is only 3%, but its required rate of return on equity is 35%. Note that interest expense is not included in operating income as the interest rate has already impacted the weighted average cost of capital (WACC). Including interest expense in the operating income will double-count the eﬀect of interest on the project.

## Learning Outcomes

When completed successfully, this project will enable you to:

• Use your knowledge of capital budgeting to project ﬁnancial outcomes and choose how to allocate resources between competing projects.

## Assignment Requirements

• The main component of this case study is the workbook you create with the provided information to calculate your net present values and internal rates of return. A template is provided for the workbook, use the same. When you open the template, you may be prompted to enable or disable macros—please click “enable,” as the macros used in this document help streamline the grading process.
• Once you’ve completed your sheet, complete the sentence in the “Conclusion” box (on the “NC” sheet) with the correct response, as well as a brief rationale for why you chose your answer.
• Be sure to show all the formulas behind your calculations so the grader can root cause any errors.

## Plagiarism Policy

We deﬁne plagiarism as: “Knowingly representing the work of others as one’s own, engaging in any acts of plagiarism, or referencing the works of others without appropriate citation.” This includes both misusing or not using proper citations for the works referenced and submitting someone else’s work as your own.

## Frequently Asked Questions

Below are answers to some of the common questions students ask about the Finance project.

### What tax rate should be used to calculate taxes on salvage value?

Use the eﬀective tax rate.

### Is the interest expense relevant to NPV & IRR calculations?

Yes, it is. However, the after-tax cost of debt (reﬂected in WACC for the case) already factors in interest expense so should not be included again.

### How is the working capital reserved formula set up in the template? Can you describe what it is doing?

As you may recall from your accounting coursework, any project will require a certain amount of working capital (current assets – current liabilities) to get an operation oﬀ the ground and then sustain it through time. For year 0, it’s estimated that 10% of the year 1 sales will be required. However, from year 1 onwards, the working capital requirement is only 10% of the incremental sales from one year to the next. At the end of the project (10 years) the remaining funds are assumed to be available as a cash inﬂow. This is shown as

“working capital returned” line. The worksheet template contains the formulas necessary for these calculations.

Do we apply depreciation for the factory and equipment in the ﬁrst year (2022)? Depreciation should only be applied when the equipment is put into service. That is, when units are produced and sold (2023).

### Should we use the excel NPV formula or calculate NPV by summing all the present values?

Either method will work. If you’re using Excel NPV formula, remember you should only apply it to the cash ﬂows occurring from 1st period, then add the period 0 cash ﬂow to your NPV value. So, the Excel formula would be

=CF0+NPV(rate,CF1:CFn,…)

Alternatively, you can just calculate present values for all cash ﬂows and sum them up. Be sure to point to the cell containing the rate instead of typing in a rounded value into the NPV formula, to ensure all decimals are appropriately captured in your calculation.

### Are we to assume that Orange builds out the infrastructure in 2022 and begins selling in 2023?

Yes, upfront investments in land, PP&E, and plant are made in 2022. Operations (production & selling) will begin in 2023.

### Should I use the bonus depreciation or straight-line depreciation for the equipment cost?

You must use the method that will yield a higher after-tax cash ﬂow in the near-term and NPV. Note that bonus depreciation only applies to the equipment and not the plant(factory).

### How do I apply straight-line depreciation method to plant and/or equipment cost?

You must apply 1/15th of the cost as annual depreciation expense for each of the 10 years.

Should we consider book value of the plant (factory) for salvage value calculations? No, you are only provided information about equipment salvage value so don’t make any assumptions about salvage value for the plant.

# Corporate Finance Project Rubric

Scores 2 and above are considered passing. Students who receive a 1 or 0 will not receive credit for the assignment and must revise and resubmit to receive a passing grade.

*The following list provides examples of minor and major errors.

• Minor errors include, but are not limited to:
• Assuming book value for plant/land when no information is provided in the case prompts
• Incorrect NPV formula
• Incorrect signs for positive and negative cash ﬂows
• Missing or incorrect salvage value and tax calculations
• Incorrect depreciation calculations
• Incorrect tax rate applied for property tax calculations
• Incorrect time bucketing of relevant costs (upfront vs. operating)
• Major errors include, but are not limited to:
• Not showing formulas for all calculations performed
• Incorrect decision criterion applied for location selection
• Incorrect discount rate applied for present value calculations
• Incorrect cash ﬂow range selected for IRR calculations
Universal Assignment (October 1, 2023) Corporate Finance Project Help. Retrieved from https://universalassignment.com/corporate-finance-project-help/.
"Corporate Finance Project Help." Universal Assignment - October 1, 2023, https://universalassignment.com/corporate-finance-project-help/
Universal Assignment July 18, 2023 Corporate Finance Project Help., viewed October 1, 2023,<https://universalassignment.com/corporate-finance-project-help/>
Universal Assignment - Corporate Finance Project Help. [Internet]. [Accessed October 1, 2023]. Available from: https://universalassignment.com/corporate-finance-project-help/
"Corporate Finance Project Help." Universal Assignment - Accessed October 1, 2023. https://universalassignment.com/corporate-finance-project-help/
"Corporate Finance Project Help." Universal Assignment [Online]. Available: https://universalassignment.com/corporate-finance-project-help/. [Accessed: October 1, 2023]

## Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

# Get 90%* Discount on Assignment Help

### Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as \$10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

### Foundations of Communication Assessment 2 Instructions

Discussion task (Total grade – 10%)   Process Work (Steps to complete the task) Answer on the Assessment 2 Submission Document – Do not upload this instruction document. Requirements (important elements to include) lastname_firstname_studentID_COMS_Assess 2_semester_year. Process for Assessment discussion tasks NOTE: If you do not participate in the class discussions then

### Assessment Two Dos and Don’ts (Internal)

Do: Read the assessment instructions carefully Read the marking rubric carefully Understand the question – break it down Conduct research – record the reference details Read the topic materials about communication theories, forms and factors and refer to them Contribute to the discussions in class or no marks for the

### Unpacking the Question: Assessment Two

Studying at university requires you to become familiar with strategies to un-pack or breakdown a variety of assessment questions/tasks throughout your studies.  Task Example of integrating the discussion, research and theories. In the group discussion my group members (name them) stated that an advertisement for a beauty product would most

### MGMT0001 Introduction to Commerce Assessment

MGMT0001 Introduction to Commerce Assessment 2 (worth 30%) Due date:                  2:00pm (AWST) Friday 15th September 2023 Submission:              Via Turnitin assessment submission link (see ‘Assessment 2’ folder in ‘Assessments’ section of Blackboard). Additional Instructions: Part A (42 marks) Nathan is a well-known chef with years of experience cooking various cuisines. After

### ACCT5011: Accounting Systems in the Digital Age

Practical Assignment Guide, Semester 2, 2023 Due Date for Submission: Monday 11th September 2023 at 5.00 PM Please note that the Folio Assignment for ACCT5011 Accounting Systems in the Digital Age is an individual assessment task worth 30% of your total marks in the unit. Please refer to the online

### EC229- Review session

Assume two cities, A and B, that can’t trade between them. Each city produces its own coconuts for its local market. If suddenly trade is possible then: D) As we saw in class, the new price will be somewhere between the original price 𝑃_𝐴,𝑃_𝐵. Hence it is impossible for consumers

### Computing Theory COSC

Computing Theory COSC 1107/1105 Assignment 1: Fundamentals Assessment Type Individual assignment. Submit online via Canvas → As- signments → Assignment 1. Marks awarded for meeting re- quirements as closely as possible. Clarifications/updates may be made via announcements/relevant discussion forums. Due Date Week 6, Sunday 27th August 2023, 11:59pm Marks 125

### BE279 Applied Statistics and Forecasting

Strategy, Operations, & Entrepreneurship Group Essex Business School Module Code BE279 Module Title Applied Statistics and Forecasting Assessment Type Individual Report (2,000 word) Academic Year 2022/23, Spring Term Submission Deadline Refer to FASER Task Specific Guidance Please note that: Module Learning Outcomes On successful completion of the module, students will

### Learning Design Tool: Little Learners Level 1 sounds

Learning Design Tool: Little Learners Level 1 sounds. Prepared by Sara Hart Date 30th August, 2023 (feel free to leave this date as it is the AT2 due date) Brief description of Learning Design   Chooseit Maker: Create, edit and play personalised learning activities that can be used in your

### HUMN1041 PEOPLE, PLACE AND SOCIAL DIFFERENCE ASSIGNMENT

HUMN1041 PEOPLE, PLACE AND SOCIAL DIFFERENCE ASSIGNMENT 1 TEMPLATE This assignment is made up of three (3) parts, plus a reference list and appendix. Marks are allocated for each section, as follows: – 1 mark Please ensure that you provide your answers in this template, and provide a Reference list

### Model 3 Launch in Australia

Client Information Company Name Tesla Contact Name   Email   Phone Number   Address Level 14, 15 Blue St. North Sydney, NSW 2060 Australia Ad link & image Project Information Project Title Model 3 Launch in Australia Project Description (100 words) Highlight the uniqueness of the car. Show the superior

### MKT10009 Marketing and the Consumer Experience

School of Business, Law and Entrepreneurship Assessment Task – Assignment 2  MKT10009 Marketing and the Consumer Experience Semester 2, 2023. Assessment Type Analytical Report Associated Unit Learning Outcomes (ULO’s) 2, 3, 4 Group or Individual task Individual Value (%) 25% Due Date Monday 20th September at 10:00 AET – Enterthis

### ASSIGNMENT – 1st Evaluation

ASSIGNMENT – 1st Evaluation Date of Submission- 4TH SEP 2023 25 MARKS COMPARATIVE PUBLIC LAW Q. You are the new Central Minister for Urban Development who is keen to make major Indian cities as smart cities. You visit different countries like USA, UK, European Countries, Japan and other developed countries

### Corporate & Financial Due Diligence Report

[Name of the company] Note: Students should keep in mind that application of legal provisions (including Securities Regulations) and analysis of the same is important. Merely putting the facts and figures won’t fetch even a decent mark. Note: Students should only mention the broad area of business. This part should

### ECON1000 S2 2023 – Marking Guidance and FAQs on GTP

Students will be marked on the extent to which they specifically answer the question and provide clear, logical, well-reasoned and sufficient explanations. Here is a summary breakdown of how marks are allocated in this GTP: Part 1 [15 marks] §  Providing relevant observations from the information provided in the articles

### ECON1000 S2 2023 – GTP Brief

ECON1000 S2 2023 – GTP Brief A.  Context and Overview The Game Theory Presentation (GTP) is worth 30% of the final mark. GTP is a ‘take-home’ exercise with a set of tasks to do. The GTP is based on Lecture Topics: L1 and L2. You will have twenty (21) days

### Order #35042 Human Rights Research Essay

Draft due 26th Aug 2,500 words (excluding references and bibliography) Instructions: Structure: Title – The Tigray War: A Critical Analysis of What the Future Holds for Human Rights in the Region What can be done to ensure human rights violations will cease and be prosecuted? Expand on different actors and

### PMC1000: Applied Pathology

Assessment Task Sheet: Poster Presentation Date: Thursday 31st August 2023 | Weighting: 30% Assessment Task 2 You are required to develop a handout style resource (pamphlet or brochure) on a selected pathological condition which is aimed at first year student paramedics. You will need to use high quality peer reviewed

### Identify a current and topical public health ethical issue

Task Details You are required to identify a current and topical public health ethical issue in the workplace (if you work within a public health setting) or in a selected community and a plan of action to address the issue and submit it in Moodle as a Power Point presentation. The

### Detailed Information: Reflective Assignment

Indigenous Peoples, Law and Justice Detailed Information: Reflective Assignment Due Date:                   Tuesday 5th September 2023 at 4:00 pm (AWST). Marks:                       30% of the total marks for this unit. Assignment:              The assignment will comprise two questions. Students must answer all parts of both questions. Examinable topics: The cultural immersion exercise and/or

### Indigenous Peoples, Law and Justice

Indigenous Peoples, Law and Justice Reflective Assignment Questions Instructions: The assignment comprises two questions. Students must answer all parts of both questions. Question 1: The proposed Referendum Question is asking Australians whether the Voice should be established. What is meant by the Voice? In May 2019, Professor Anne Twomey, an

### Cultural immersion activity

Context of Carrolup To support fellow Australian and truth telling. Third space = a spiritual an mental place, meeting point of many cultures all over the world to communicate and feel safe to merge thought and aspects of everyone’s individual culture to create a sense of what they want the

### High-Fidelity Mockup Design for a Employer / Company  Review Platform

Demo Task: High-Fidelity Mockup Design for a Employer / Company  Review Platform Project Overview: You are tasked with designing high-fidelity mockups for a  Employer / Company  review platform that serves both employers and employees/users. The platform’s goal is to provide a space where employees can share their experiences and opinions

### IMPLEMENT AND MONITOR ENVIRONMENTALLY SUSTAINABLE WORK PRACTICES

ASSESSMENT COVER SHEET (Please ensure this cover sheet is completed and attached on top of each assessment) QUALIFICATION CODE AND TITLE:  Certificate IV in Commercial Cookery UNIT CODE: BSBSUS401               TITLE: IMPLEMENT AND MONITOR ENVIRONMENTALLY SUSTAINABLE WORK PRACTICES               Student Number   Student Name   Assessor Name   Assessment Name and

### Data Analysis and Findings

Qualitative data analysis technique called thematic analysis includes reading the data collection and looking for patterns in the meaning of the data to determine the theme. Making sense of the data is an active reflexive process in which the researcher’s personal experience is important. On Instagram, though, any company can

### PHE5STL: Systems Thinking and Leadership

Assessment 2: Complex problem briefing paper instructions and submission link PHE5STL: Systems Thinking and Leadership Assessment 2: Complex, or messy, problem briefing paper Assignment type Briefing paper/policy advising paper Weighting 20% Word count / length 1,500 words Note: The word count does not included references however does include in-text citations

### Assessment 1 Week-6: UML Modelling for a shopping mall

Assessment 1(    ) Information and Rubric Subject Code  ICT505 Subject Name  Software Development Assessment Number and Title  Assessment 1 Week-6: UML Modelling for a shopping mall Assessment Type Lab Activity Length / Duration  45 Minutes Weighting %  10% Total Marks  100 Submission Online Submission Due Date Week-6 (Sunday 23:59) Mode

### The Geopolitical, Economic and Legal Environment

Faculty of Business and Law Assignment Brief Mode E and R Regulations Module Title: The Geopolitical, Economic and Legal Environment     Assignment Number 2 Module Code: 7010SSL   Assignment Title Macro Analysis Report Module Leader: Dr. Bentil Oduro   Assignment Credits 10           Release Date:

### Paragraph Template: TEEL Structure

With this example from the discussion board, you can see Courtney answered the question with all four elements very clearly. This gives a coherent answer using different kinds of information and academic integrity. Bias is a natural behaviour of tendency to be in favour or against something in particular. From