Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


JWI 530 Strayer University Cash Flow Statement Calculation Worksheet

JWI 530 Strayer University Cash Flow Statement Calculation Worksheet

I’m working on a finance report and need support to help me study.

  • The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed in the amount of $35,000 per year starting in year 0 and through all years of the project to support production as raw materials will be required in year o and all years to run the new equipment and produce components to replace those purchased from the vendor..
  • The current spending on this component (i.e. annual spend pool) is $1,200,000. The estimated cash flow savings of bringing the process in-house is 20% or annual savings of $240,000. This includes the additional labor and overhead costs required.
  • Finally, the equipment required is anticipated to have a somewhat short useful life, as a new wave of technology is on the horizon. Therefore, it is anticipated that the equipment will be sold after the end of the project (the last year of generated cash flow) for $50,000. (i.e. the terminal value).

As part of your research, you have sought input from a number of stakeholders. Each has raised important points to consider in your analysis and recommendation. Some of the points and assumptions are purely financial. Others touch on additional concerns and opportunities.

  1. Andrew, your colleague from Accounting, recommends using the base assumptions above: 5-year project life, flat annual savings, and 10% discount rate. Andrew does not feel the equipment will have any terminal value due to advancements in technology.
  2. Stanley from Sales is convinced that this capability would create a new revenue stream that could significantly offset operating expenses. He recommends savings that grow each year: 5-year project lif e, 10% discount rate, and a 10% annual savings growth in years 2 through 5. In other words, instead of assuming savings stay flat, assume that they will grow by 10%% in year 2, and then grow another10%overyear2inyear3,andsoon. Stanleyfeelsthatthestatedterminalvalueis reasonable and used it in his calculations.
  3. Eva from Engineering believes we use a higher Discount Rate because of the risk of this type of project. As such, she is recommending a 5-year project life and flat annual savings. Eva suggests that even though the equipment is brand new, the updated production process could have a negative impact on other parts of the overall manufacturing costs. She argues that, while it is difficult to quantify the potential negative impacts, to account for the risk, a 12% discount rate should be used. Being an engineer, Eva feels that the stated terminal value is low based on her experience, and is recommending a $75,000 terminal value,
  4. Paul, the Product Manager, is convinced the new capability will allow better control of quality and on-time delivery, and that it will last longer than 5 years. He recommends using a 7 Year Equipment Life (which means a 7-year project and that savings will continue for 7 years), flat annual savings, and 10% discount rate. In other words, assume that the machine will last 2 more years and deliver 2 more years of savings. Paul also feels the equipment will have an estimated terminal value of $25,000 at the end of its 7- year useful life as it will be utilized longer thus having less value at the end of the project and savings.
  5. Olivia, the head of Operations, is concerned that instead of stabilizing the supply chain, it will just add another process to be managed, and will distract from the core competencies the company currently has. She f eels the company should focus on improving communication and supply chain management with its current vendor, and she feels confident he can negotiate a discount of 4% off of the annual outsourcing cost of $1,200,000 if she lets it be known they are considering taking over this step of the process. As there is little risk associated with Olivia’s proposal due to no upfront capital requirements, a lower risk-free discount rate of 7% would be appropriate. Oliva feels that any price reductions from the current vendor will last for five years. (NOTE: because there is no “investment”, the Payback and IRRmetricsarenotmeaningful. SimplyprovidetheNPVoftheSavingscashflows).

PART A: Data Calculations

Using the data presented above (and ignoring the extraneous information), for this profit and supply chain improvement project, calculate each of the following (where applicable):

  • Nominal Payback
  • Discounted Payback
  • Net Present Value
  • Internal Rate of Return#1: Andrew
    #2: Stanley
    #3: Eva
    #4: Paul
    #5: Olivia N/A N/A N/ASubmission RequirementsPresent your calculations and results either in an Excel Spreadsheet or in Word (using tables and headers to organizetheinformationinawaythatisclearandeasytoread). Besuretoshowyourdetailedcalculations. If you get something wrong, you may still be able to get partial credit.

page3image620252944 page3image620253232


Nominal Payback

Discounted Payback

Net Present Value

Internal Rate of Return

page3image620273744 page3image620274032 page3image620274320 page3image620274608 page3image620275024 page3image620275312 page3image620275600page3image620275888 page3image620276176 page3image620276464 page3image620276752 page3image620277040 page3image620277584 page3image620277776page3image620278064 page3image620278352 page3image620278640

JWI 530: Financial Management I

Assignment 2

Part B: Recommendations

Af ter completing the calculations for all scenarios, create a brief memo to the CEO outlining your committee’s recommendations. You may organize the memo as you see fit, but it must include the following:

  • A clear opening statement of your recommendation for or against the project.
  • A brief synopsis of the processes and factors that led to your recommendations.

o What informationdid you gather, and how did you get it? o From whom did you seek input, and why?

• A summary of the strategic benefits and risks in pursuing (or not pursuing) this project, including: o Highlights of the main data points that support your position
o Acknowledgement of the data points that oppose your argument
o Identification of open/unresolved items

  • An identification of the scenario that, from a purely financial perspective, represents the most accurate estimate of the anticipated results and your rationale as to why.
  • An identification of non-financial elements that need to be considered for the recommended scenario.
  • Any assumptions in project economics can have a significant impact on the result. Identify 3 financial elements/assumptions in your analysis that would make this project financially unattractive. Be as transparent and candid with your BOD as possible. What would have to be true for this to be a bad investment?
  • A summary restating your recommendation and key action items.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Fox Writers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Fox Writers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Fox Writers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Fox Writers, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.