Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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 the capital budgeting and Time Value of Money concepts you have learnt in FIN 301 to analyze the solution and present it to your boss in three days. Conduct the analysis and calculate Payback period for each option, IRR of each option and NPV for each option at three WACC points of 10%, 12%, 15%, and 17% Write a memo to your boss, explaining the results of your analysis, your decision and include a table and a chart showing your analysis. Please include excel functions

image text in transcribedimage text in transcribed

Excel+and+writing+assignment++Fin301+(6) (1) -Excel Help Tell me what you want to do pital Budgeting Assignment WRITING PART: Submission format: Word Document 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 the capital budgeting and Time Value of Money concepts you have learnt in FIN 301 to analyze the solution and present it to your boss in three days. Conduct the analysis and calculate Payback period for each option, IRR of each option and NPV for each option at three WACC points of 10%, 12%, 15%, and 17% Write a memo to your boss, explaining the results of your analysis, your decision and include a table and a chart showing your analysis O/ 12 ause reak prt s Sys 7 8 9 File Home Insert Draw Page Layout Formulas Data Review Vie 400500 B22 FIN 301- 5 EXCEL PART: Submission format: Excel File ABC Corporation has a machine that requires repairs or should be replaced. 8 ABC has evaluated the two options and calculated the cash flows resulting 9 from each option as follows: 11 Option A: Repair the Machine 12 Year Cash Flovw O $66,000.00 1 $18,500.00 2 $35,100.00 14 3 $18,500.00 16 17 18 $17,800.00 $12,700.00 Option B: Buy a new Machine 21 Year Cash Flow 23 24 25 26 27 O$400,500.00 1 $55,300.00 2 $133,000.00 3 $119,800.00 4 $127900.00 S S134,100.00 29 30 31 32 Sheet1 Sheet2 Sheet3 0 Type here to search esc f4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Management Of Business Finance

Authors: John Freear

1st Edition

0273014315, 978-0273014317

More Books

Students also viewed these Finance questions