Question

Given the cash flow below, calculate the External Rate of Return when MARR = 12%. Ans...

Given the cash flow below, calculate the External Rate of Return when MARR = 12%. Ans xx.x%

Year Cash Flow
0 $-190,000
1 $-40,000
2 $76,000
3 $107,000
4 $123,000
5 $140,000

Please answer using excel and have formulas posted.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given the cash flow in the spreadsheet below, what is the internal rate of return? Please...
Given the cash flow in the spreadsheet below, what is the internal rate of return? Please give answer as a decimal not as a percent. For example write 0.153 not 15.3%. Year Cash Flow 0 -6306 1 1366 2 1556 3 984 4 1100 5 856 6 1526 7 1097 8 1469 0.115459
A project has the following cash flows. What is the internal rate of return? THE ANSWER...
A project has the following cash flows. What is the internal rate of return? THE ANSWER IS 21.32% PLEASE SHOW WORK WITHOUT USING EXCEL YEAR 0 1 2 3 NET INCOME -$390,000 $168,000 $190,000 $218,600
Determine the best alternative using the annual cash flow analysis from the data given in table...
Determine the best alternative using the annual cash flow analysis from the data given in table below. A. B. C. Initial cost: $1500. $1000. $1200 Annual benefit: $800. $250. $300 Salvage value: $500. $0. $600 Life in years: 2 years. Infinity. 4 years MARR = 10% Please don't use excel and show all work.
The cash flow diagram below has an internal rate of return of 30%. What is the...
The cash flow diagram below has an internal rate of return of 30%. What is the value of Y if perpetual service is assumed? Year 0 is $1000000 Year 1 is $500000 Year 2 is $500000 Year 3 is $Y Year 4 is $Y Year 5 is $Y Year 6 is $Y Year ∞ is $Y
Calculate geometric average rate of return of the stock given below by using its historical return...
Calculate geometric average rate of return of the stock given below by using its historical return series Year stock price(TL) Return(%) 2014 200 2015 300 2016 420 2017 336
Determine the number of possible rate of return (i*) values for the cash flow below according...
Determine the number of possible rate of return (i*) values for the cash flow below according to the rule of signs (Descartes’ rule). Year Annual Revenues, $ Annual Costs,$ 0 $0 -$500 1 $350 -$500 2 $250 -$300 3 $450 -$350 4 $150 -$100 5 $350 -$150 Four One Three Two
Calculate the present value of the following cash flows given a discount rate of 12%: Year...
Calculate the present value of the following cash flows given a discount rate of 12%: Year 1 Year 2 Year 3 Year 4 Cash Flows $1,500 $8,500 $12,500 $11,000 Calculate the internal rate of return for a project that has upfront costs of $7 million and cash flows of $2.5 million per year for each of the next four years. The risk adjusted project discount rate is 12%.
Calculate the Present Value of the cash flow shown below. Interest rate is: 6.50% per year,...
Calculate the Present Value of the cash flow shown below. Interest rate is: 6.50% per year, compounded annually $0 $0 $745 $0 $3,140 $0 $4,000 $0 $0 $2,275 $0 year 0 1 2 3 4 5 6 7 8 9 10 $0 $0 -$4,470 $0 $0 $0 $0 -$3,020 -$3,020 $0 $0
Given the following project information, calculate the after-tax operating cash flow (ATOCF) using the four approaches...
Given the following project information, calculate the after-tax operating cash flow (ATOCF) using the four approaches of calculating operating cash flow.                                                                      Project cost = $950,000 Project life = five years Projected number of units sold per year = 10,000 Projected price per unit = $200 Projected variable cost per unit = 150 Fixed costs per year = $150,000 Required rate of return = 15% Marginal tax rate = 35% Depreciation = Straight-line to zero over five years (ignore...
Year 0 1 2 3 4 5 6 Cash Flow -110000 30000 40000 20000 80000 20000...
Year 0 1 2 3 4 5 6 Cash Flow -110000 30000 40000 20000 80000 20000 20000 Given the cash flows in the table above, calculate the payback period assuming the cash flows in years 1 to 4 occur evenly throughout the year. The required rate of return is 12%. Answer in years accurate to two decimal places Kindly please help to explain and answer.