Spartan Sprockets Inc Cash Flow Analysis Paper Please answer according to the yellow sheet.(See attachment)
Your firm has been hired as a finance consultant by Spartan Sprockets, Inc., who have decided to invest in a new sprocket manufacturing system. The company has narrowed the available options down to 3: your job is to analyze the financial data for each system, and make a recommendation to Spartan Sprockets as to which system they should purchase.
The data that is common to each system is as follows:
Whichever of the new systems the company will purchase will require the construction of a new factory to house it.
Anticipating that a new factory would be needed someday, the company spent $5,000,000 to acquire the necessary land in 2015.
The factory will cost the company $10,000,000 to construct.
The total amount of the Initial Investment (dont include Net Working Capital in your Depreciation calculation) will be depreciated straight line to zero through the life of each project (pay attention to the life span of each individual project).
Last year, the finance committee of Spartan Sprockets spent $50,000 on a fact-finding tour of Oshkosh, Wisconsin to look at a similar manufacturing system to those they are considering buying.
The company will need to spend $500,000 on infrastructure improvements in order to build the factory.
Over the past 2 years, the company has spent $150,000 on research and development to see whether a new system was needed.
The companys Tax Rate is 21%.
The company has assigned a required rate of Return for all of the systems of 10%.
Task 1: Discounted Cash Flow Analysis and NPV calculation (60 points)
The data for each of the 3 systems the company is considering buying is given below. You will need to fill in the data on the answer sheet for each of the 2 scenarios given for each of the 3 systems, and compute each scenarios Net Present Value. Remember, the company will only be able to purchase one of these systems. Add the common data above to each scenarios specific data below.
Purchase Price: $4,500,000
After-tax Salvage Value: $2,000,000
Net Working Capital Needed: $750,000. 50% of this will be recovered in the terminal year of the project.
Annual Sales attributed to this system: $20,000,000
Total Costs: 80% of Sales
This project is to be evaluated using a 5-year time frame
Alternate Scenario: Assume Total Costs have risen to 80.25% of Sales
There is a 50% chance that the base case will be accurate, and a 50% chance that the Alternate Scenario will occur.
Purchase Price: $3,500,000
Salvage Value: $0
Net Working Capital Needed: $550,000. 40% of this will be recovered in the terminal year of the project.
Annual Sales attributed to this system: $22,000,000
Total Costs: 78% of Sales
This project is to be evaluated using a 4-year time frame
Alternate Scenario: Assume Total Costs have risen to 78.15% of Sales
There is a 75% chance that the base case will be accurate, and a 25% chance that the Alternate Scenario will occur.
Purchase Price: $4,500,000
After-tax Salvage Value: $3,750,000
The company already has all of the Net Working Capital on hand it will need for the project.
Annual Sales attributed to this system: $15,930,000
Total Costs: 75% of Sales
This project is to be evaluated using a 4-year time frame
Alternate Scenario: Assume Total Costs have risen to 75.05% of Sales
There is a 80% chance that the base case will be accurate, and a 20% chance that the Alternate Scenario will occur.
Task 2: Payback Period Evaluation (15 points)
Using the BASE CASES only; using the data given above, and the Operating Cash Flow you calculated for each system, determine whether each system passes the payback period test, and show what the net payback is for each scenario at the end of its lifespan.
Task 2a: (5 points)
Just using the Payback Period Method, which system would you choose, and why?
Task 3: Internal Rate of Return (18 points)
Calculate the Internal Rate of Return for both the base case and Alternate Scenario for each system.
Task 3a: (3 points)
Circle the answer on the answer sheet next to your answer regarding the IRRs you calculated
Conclusion: (20 bonus points)
Using whichever method you think is appropriate, present your recommendation as to which system you recommend Spartan Sprockets to purchase, and why. Write at least 2-3 sentences, but no more than a short paragraph.
Part 1: You will get 10 points for each correct NPV for the base cases and scenarios (6 Models x 10 points each). Partial credit will be awarded if you get the wrong NPV but made an honest effort.
Part 2: You will get 5 points for each correct payback period calculation. Again partial credit may be awarded.
Part 2a: The correct answer gains 5 points. An incorrect answer with a persuasive reason will get 4 points. All other answers get 0 points.
Part 3: You will get 6 points for each correct IRR (6 x 3 scenarios). Partial credit may be awarded.
Part 3a: There is one correct answer, which gets 3 points. Wrong answers get 0.
Conclusion: The conclusion is an extra credit section; you will not be penalized for not writing a conclusion, but in order to get any of these extra credit points, you will need to write something meaningful. Simply summarizing the data for each of the scenarios will not earn any points. I expect you to clearly state your recommendation for which system should be purchased. Saying something like I would purchase System X under the base scenario, but System Y if the Alternate scenario occurs is NOT making a recommendation! We dont know which scenario will occur; we only have probabilities assigned to each. Pick a system, and defend your choice. One sentence as to which methodology you used, and 1-2 sentences as to why you made the choice you did with a logical reason will earn 20 points, even if your choice is different than mine.
Our Unique Features
Custom Papers Means Custom Papers
This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.
Qualified and Experienced Essay Writers
Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Assuarance
We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.
100% Originality & Confidentiality
Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.
While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.
Any Kind of Essay Writing!
Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, homeworkmarketpro.com has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.
Quality Check and Editing Support
Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
Prices and Discounts
We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.