Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Understand how to use Excel spreadsheet Net Income c Add back Depreciation $60,000 Total Operating Cash Flow $75,800 Terminal: 1) Salvage value (after tax)

image text in transcribed
image text in transcribed
1. Understand how to use Excel spreadsheet Net Income c Add back Depreciation $60,000 Total Operating Cash Flow $75,800 Terminal: 1) Salvage value (after tax) Salvage Value Before Tax (1-T) Total \begin{tabular}{l|l|} \hline$ & 11,850 \\ \hline$ & 11,850 \end{tabular} Project Net Cash Flows (240,000)$ 75,800$ IRR=42.5% Payback = ? NPV=[$162.997) Q\#1 Would you accept the project based on NPV, IRR? Would you accept the project based on Payback rule if project cut-off is 3 years? Q\#2 How would you explain to your CEO what NPV means? Q\#3 What are advantages and disadvantages of using only Payback method? QH4 What are advantages and disadvantages of using NPV versus IRR? QA5 Explain the difference between independent projects and mutually exclusive projects. When you are confronted with Mutually Exclusive Projects and have coflicts with NPV and IRR results, which criterion would you use (NPV or IRR) and why? 1. Understand how to use Excel spreadsheet Net Income c Add back Depreciation $60,000 Total Operating Cash Flow $75,800 Terminal: 1) Salvage value (after tax) Salvage Value Before Tax (1-T) Total \begin{tabular}{l|l|} \hline$ & 11,850 \\ \hline$ & 11,850 \end{tabular} Project Net Cash Flows (240,000)$ 75,800$ IRR=42.5% Payback = ? NPV=[$162.997) Q\#1 Would you accept the project based on NPV, IRR? Would you accept the project based on Payback rule if project cut-off is 3 years? Q\#2 How would you explain to your CEO what NPV means? Q\#3 What are advantages and disadvantages of using only Payback method? QH4 What are advantages and disadvantages of using NPV versus IRR? QA5 Explain the difference between independent projects and mutually exclusive projects. When you are confronted with Mutually Exclusive Projects and have coflicts with NPV and IRR results, which criterion would you use (NPV or IRR) and why

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

Financial Markets And Institutions

Authors: Anthony Saunders, Marcia Cornett

7th Edition

1259919714, 978-1259919718

More Books

Students also viewed these Finance questions

Question

7 Explain the equity theory of motivation.

Answered: 1 week ago