Question: please calculate the numbers and write down the formula functions that were used (first column a, second b......) Year 3 Year 4 Year 5 Year

please calculate the numbers and write down the formula functions that were used (first column a, second b......)

Year 3 Year 4 Year 5 Year 6 1 2 3 Year 1, Amazon invests into a facility in the US that costs $20M. 4 Year 2. The facility generates $100M in sales per year for 5 Years 5 The profitability of the operations are 10% 6 For purposes of this exercise cathprofit Year 1 Year 2 $20.000.000 Investment Sales Earnings from Operations Cash from Operations $100,000,000 100.000.000.0 $100,000,000 100,000,000.0 $100.000.000 100,000,000 0 $100.000.000 100,000,000.0 $100,000,000 100,000,0000 8 What is the Net Present Value of the cash flows assuming the discount rate is 8? 9 What is the Internal Rate of Return of the investment? 10 11 You may use excel formulas for NPV and All Cash Transactions Net Present Value Internal Rate of Return 24

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I would like a complete solution to all the data received 12 SCM332- Labo2 Writing Formulas and Functions Sum(), Max(). Min(). Average). Count(). Sumif(). Countif(). Nowe). Today(). Year(), Month()....

Additional questions attached in the word document. 1.Let's look at another colleague of Gloria's, Brock Taylor. Brock earns $11,500 per pay period, and has earned $80,500 up to this point. The OASDI...

Publication 15 In this step, you will use the Wage Bracket Method to calculate withholding. In this method, you do not need to calculate withholding allowances, but there are fairly-low limits as to...

Submit Filename: Exercise1_4M.java (Ninth Edition Page 31 1.4 Modified; 10th Edition Page 30 1.4) Submit Filename: Population.java (Ninth Edition Page 32 1.11 Modified; 10th Edition Page 31 1.11)...

Let me know if there's any information I forgot to put in here. The excel sheet Part 2 asks for is the first image. OPERATING INCOME Factory Utilities FIXED COSTS Plant Mantainence Supervisor...

Kindly please show all formulas. Thank you. in Write the Excel formula for each cell marked with column B of the spreadsheet below, and label each formula clearly. List all the constraints in terms...

This assignment is based on a short case on Jupiter Gourmet Seafood (JGS) and involves estimating CLV for two customer segments. Please read the case and associated notes carefully.Jupiter Gourmet...

What is the proabability of a team 1 player Probability of a player not being on team 2 Probability of a team 3 player and travels over 20 miles Probability of a team 1 player or travels over 20...

A thermoelectric refrigerator removes heat from a refrigerated space at 5C at a rate of 130 W and rejects it to an environment at 20C. Determine the maximum coefficient of performance this...

In the rail generator rhe mgnetic field is stationary in time. And induced current flows in the rail generator loop because

A populor, local coffeeshop in one of the suburbs or New York City (NYC) estimates they use 3,100 pounds of coffee ann have to determine how many pounds to order each time in order to minimize their...

3. What are the different dimensions of culture (according to Hofstede et al.) and how might an understanding of these enable a manager or employee to better understand national culture?

2. How might an employer assist a family with special needs when relocating their family overseas for an international assignment?

4. What are the key issues associated with managing an international assignment?