Finance Homework

josh
June 29, 2015 0 Comment

Assignment Description:

ABC Corporation has a machine that requires repairs or should be replaced.  ABC has evaluated the two options and calculated the cash flows resulting from each option as follows:

Option A: Repair the Machine

Year Cash Flow
0 -50,000
1 31,500
2 20,100
3 18,900
4 17,100
5 13,700

Option B: Buy a new Machine

Year Cash Flow
0 -400,000
1 91,300
2 155,000
3 127,800
4 126,900
5 125,100

You have recently been hired by ABC Corporation and your first assignment is to help them decide which of these two options should be pursued.  You would like to apply Capital Budgeting and Time Value of Money concepts you have learnt in FIN 301 to analyze the problem and present your recommendation to your boss, Ms. Jane Austen.

Conduct the analysis by calculating the following for each option:

  •  Net Present Value (NPV)
  • Internal Rate of Return (IRR)
  • Profitability Index (PI)
  • Payback Period (PB)
  • Crossover Rate

The company has a Weighted Average Cost of Capital (WACC) (discount Rate) of 12%.  For this analysis, your boss John Doe asked you to calculate NPV at three different discount rates: 12% (the current WACC), 14% and 16%.

Things to turn in:

  • A one-page memo explaining the results of your analysis and your recommendation. The memo should include important results of your analysis such as a summary table or graph. The memo is limited to one page so be very selective on what information to include.
  • An Excel spreadsheet showing calculation of above at the 3 discount rates and graph on NPV Profile. Assume benchmark for payback period. Write =if( ) statements to offer dynamic decisions.
Facebook
Twitter
Google+
  • 100% Original Essays Guaranteed
  • 8 Hrs Delivery Available
  • Original and creative work
  • Timely delivery guaranteed
  • 100% confidentiality guarantee
  • Variety of disciplines, topics, and deadlines
  • Discounts offered on every custom-ordered paper
  • Original papers written from scratch;
  • 100% confidential;
  • 100% plagiarism-free;
  • Fast turn-around time;
  • Direct communication with the writer;
  • Instant email delivery;
  • Free plagiarism reports;
  • 24/7 customer support team.
  • Choose your font
  • 12 point font size
  • Double-sized
  • Over 275 words/page
  • Text aligned left
  • One inch margin

We Accept

myonlinehomeworkhelper

you have a money back guarantee if you are not satisfied with our services