Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a excel sheet the professor gave me , all he wants is for me to change the numbers on there and make it

This is a excel sheet the professor gave me, all he wants is for me to change the numbers on there and make it work and make sense still. So can you do it for me please.\table[[Project A NPV Calculation,,,],[NPV Calculation,,,],[Description,Data,Factored Value,NPV],[Interest Rate,9%,,],[Investment on Project A,-$100,000.00,1.00,-$100,000.00],[Return on Investment Period 1,$37,000.00,0.92,$33,944.95],[Return on Investment Period 2,$35,000.00,0.84,$29,458.80],[Return on Investment Period 3,$32,000.00,0.77,$24,709.87],[Return on Investment Period 4,$19,613.00,0.71,$13,894.34],[,23613.09,,$2,007.97]]
\table[[MARR],[NPV Calculation],[Description,Data,Factored Value,NPV],[\table[[MARR]],7%,,],[Investment on Project B,-$2,000,000.00,1.00,-$2,000,000.00],[Return on Investment Period 1,$600,000.00,0.93,$560,747.66],[\table[[Return on Investment Period 2]],$500,000.00,0.87,$436,719.36],[Return on Investment Period 3,$400,000.00,0.82,$326,519.15],[Return on Investment Period 4,$300,000.00,0.71,$213,895.85],[Return on Investment Period 5,$290,000.00,0.67,$193,239.24],[Return on Investment Period 6,$255,000.00,0.62,$158,801.18],[Return on Investment Period 7,$189,133.70,0.58,$110,077.54],[Bottom Line,534133.70,,$0.00],[MARR Evaluation],[NPV Calculation],[Description,Data,Factored Value,NPV],[Interest Rate,10%,,],[Investment on Project B,-$18,000,000.00,1.00,-$18,000,000.00],[Return on Investment Period 1,$8,000,000.00,0.91,$7,272,727.27],[Return on Investment Period 2,$7,900,000.00,0.91,$7,181,818.1\epsi ],[Return on Investment Period 3,$2,400,000.00,0.91,$2,181,818.1\epsi ],[Return on Investment Period 4,$1,200,000.00,0.91,$1,090,909.0C],[Return on Investment Period 4,$300,000.00,0.91,$272,727.27],[1,800,000.00,,$0.00]]
image text in transcribed

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

Understanding The Finance Of Welfare

Authors: Howard Glennerster

2nd Edition

1847421091, 978-1847421098

More Books

Students also viewed these Finance questions

Question

Why are some economists against a target of zero inflation?

Answered: 1 week ago