Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use the following information to complete the calculation of NPV, IRR and Payback, while all other info stays the same. Microsoft, 1160000 increases by 1%

use the following information to complete the calculation of NPV, IRR and Payback, while all other info stays the same.

Microsoft,image text in transcribed

1160000 increases by 1% each year

Clipboard Alignment fe NPV(0.2, C17: F17)+B17 B19 Cash Flows 13 2132444.6 2194352.6 2239743 2231680.576 14 Operating Cash Flow 15 Changes in NWC 1150000 350000 15000 15150 1545451.5 16 Net Capital Spending 1310000 545270 17 Cash Flow From Ass (2,460,000) 1.782.445 2,179,353 2.224.593 4.322.402 18 Net value T$3.910.682 19 Present 20 IRR 79.86% 1.31 -1+(ABS(B17-c17)D17 21 Payback Period 1150000 1500000 1515000 1530150 1545451.5 23 24 Change in NWC 1150000 15301.5 350000 15000 15150 25

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

Banking And Finance

Authors: Brian Duignan

1st Edition

1615308946, 978-1615308941

More Books

Students also viewed these Finance questions

Question

Does it avoid using personal pronouns (such as I and me)?

Answered: 1 week ago

Question

Does it clearly identify what you have done and accomplished?

Answered: 1 week ago