Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please show equations for excel thank you! 0 que

please show equations for excel thank you! 0 Question 1 (30 points): Consider...

90.2K

Verified Solution

Question

Finance

image

please show equations for excel thank you!

0 Question 1 (30 points): Consider an escalation rate of 20% for all costs (including environmental remediation cost) and 15% for all incomes (including salvage value) for a project. At the end of 11th year, the project has a salvage value of $10,000 and an environmental remediation cost of $15,000. Year 1 2 3 4 5 6 7 8 9 10 11 Cost -50,000 -16,000 0 0 0 0 0 0 18,000 19,000 12,000 12,000 11,000 11,000 9.000 9.000 9,000 8,000 7,000 a) Calculate the escalated-dollar cash flow b) Calculate the escalated-dollar IRR c) Calculate the escalated-dollar NPV, using an escalated-dollar minimum rate of return of 12%. 0 0 0 0 Income Question 2 (30 points): Same as question 1, but now consider an inflation rate of 7.5%: a) Calculate the constant-dollar cash flow b) Calculate the constant-dollar IRR c) Calculate the constant-dollar NPV (hint: one needs to calculate constant-dollar min ROR using Fisher's rule)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Physics
1.2K views

4 V2 V3 79 Consider the following statements 2 v A Electron density in XY...

Civil Engineering
1.2K views

Define the horizontal collimation?

Biology
1.2K views

molecule 1 What are the reactants water carbon dioxide 2 What is are the product...

Geometry
1.2K views

O O A B C Question 22 20 72 6 12 16

Geometry
1.2K views

h t 4 9t 2 v 0 t h 0 where v 0 is the...

Basic Math
1.2K views

Rewrite the following rectangular equation in polar form.y=3x

Algebra
1.2K views

X 3 a 3x 4 6x 4x 16x 2 X 3 3 3 3 6...

Accounting
1.2K views

Smith Company manufactures soccer bolls in two sequential processes: Cutting and Stitching. All direct materials...

Accounting
1.2K views

A SINGLE AMOUNT 1. Costs that can A) sunk costs B) opportunity costs C) avoidable...

Accounting
1.2K views

There are many different people/positions that use the information from an Activity Based Costing system....

Accounting
1.2K views

Trade discounts are not subject to HST. options: ...

Accounting
1.2K views

Jones Excavation Company is planning an investment of $125,000 for a bulldozer. The bulldozer is...