Write the equation you would use in excel to find the present value of the following...
Write the equation you would use in excel to find the present value of the following cash flows assuming the required return was 10%/year and the long term perpetual growth rate in cash inflows post 68 months is 3%/year:
| A | B | C | D | E | F | G | |
| 1 | Time 0 | 8 Months | 20 Months | 32 Months | 44 Months | 56 Months | 68 Months |
| 2 | -$200 m | $40 m | $80 m | $120 m | $140 m | $180 m |
Homework Answers
Monthly ROR=10%/12=0.833%
Monthly Growth Rate=3%/12=0.25%
Terminal Cash Flow=180*(1+0.25%)/(0.833%-0.25%)=30951.97
So the Present Value of all the cash flow=
-200/(1+0.833%)^8 + 40/(1+0.833%)^20 + 80/(1+0.833%)^32 + 120/(1+0.833%)^44 + 140/(1+0.833%)^56 + 180/(1+0.833%)^68 + 30951.97/(1+0.833%)^69=$17644.11
Add Answer to:
Write the equation you would use in excel to find the present value of the following...
Write the equation you would use in excel to find the present value of the following...
Write the equation you would use in excel to find the present value of the following cash flows assuming the required return was 10%/year and the long term perpetual growth rate in cash inflows post 68 months is 3%/year: A B C D E F G 1 Time 0 8 Months 20 Months 32 Months 44 Months 56 Months 68 Months 2 -$200 m $40 m $80 m $120 m $140 m $180 m
NEED EXCEL SOLUTION:IN EXCEL FORMULA PLEASE We previously used the net present value function to find...
NEED EXCEL SOLUTION:IN EXCEL FORMULA PLEASE We previously used the net present value function to find the present value of unequal cash flows. Now, you know exactly what net present value means: The present value of all outflows, plus the present value of all inflows. Unfortunately, as we will see, computer programmers don't understand net present value. Suppose we have a project with the following cash flows and required return. What is the NPV of the project? t Cash flow...
1. based on the table graph the concentration (number of molecules) of both molecules A and...
1.
based on the table graph the concentration (number of molecules) of
both molecules A and B vs time. You shoild have two separate curves
(A and B).
2. all three trials started at different amounts. How did the
final ratios of A and B compare?
3. Did the reactions ever stop?
U Table 1: Trial 1 Trial 2 Trial 3 Time A Time A B Time А B 0 (Initial) 20 40 60 80 100 120 140 160 160...
Please use Excel to solve! Ne Present Value and Other Capital Budgeting Measures 5. Consider a...
Please use Excel to solve!
Ne Present Value and Other Capital Budgeting Measures 5. Consider a project that has the following cash flows: initial cash flow (t-0) --$100,000; cash flows years 1 to 5 (t-1-5) - $10,000 per year, cash flows years 6 to 10 (t-6-10) - $20,000 per year. If the required return on the project is 6%, calculate the following: a. Internal Rate of Return (IRR)? b. Net Present Value (NPV)? c. Profitability index (PI)? d. Payback period?
1.Payments are not equal, they change from period to period. Find the present value of the...
1.Payments are not equal, they change from period to period. Find the present value of the payment in each period and sum them to find the present value of all the cash flows. What is the present value of an investment that pays $200 in year 1, $300 in year 2, and $400 in year 3? Assume a rate of return of 12%. ($702.44) 2.You are buying a new car and will have a 12,500 loan with equal payments for...
what is the Present Value of an asset that pays the following cash flows, if you...
what is the Present Value of an asset that pays the following cash flows, if you can invest them at a rate of return of 5%? Time Period Cash Flow 0 2 4 75 75 75 75 75 Note: this is an 'ordinary annuity', it is the default assumption for both Excel and your financial calculator. a) Identify the assumptions given in this problem Rate of Return # of years Annual Payment Future Value b) Solve this problem using the...
Use Excel to calculate the expected present value of the following cash flows using a 5%...
Use Excel to calculate the expected present value of the
following cash flows using a 5% discount rate? Be prepared to
explain how you calculated your answer.
Year 1 Cash Flow Estimates $ 1,500 $ 2,000 $ 2,500 Probabiltiy of Estimate 10% 50% 40% Total Year 2 $ $ $ 3,300 3,600 4,000 15% 40% 45%
The following is data from a force sensor. The value in the first column is the...
The following is data from a force sensor. The value in the first column is the raw reading from the arduino and the value in the second column is that applied force. The last three readings (300-400 N) are all "0". Why do you think this is? Raw Reading Newtons 1023 0 512 10 345 20 255 30 204 40 179 50 146 60 127 70 113 80 102 90 93 100 85 110 78 120 73 130 68 140...
Procedure Use the following sets of data and work with each one. The equation for a...
Procedure Use the following sets of data and work with each one. The equation for a linear graph is y mx+b, where m is the slope and b is the y-intercept. DATA SET 1: Fahrenheit-vs- Celsius Fahrenheit Celsius 32 68 104 140 176 0 20 40 60 80 1. Using Data Set 1 above, graph Fahrenheit (y) -vs- Celsius (x), using the scatterplot function in excel, or another graphing software. Make sure you label the axes. Fahrenheit should be on...
Net Present Value Method Annuity E &T Excavation Company is planning an investment of $386,700 for a bulldoze...
Net Present Value Method Annuity E &T Excavation Company is planning an investment of $386,700 for a bulldozer. The bulldozer is expected to operate for 2,000 hours per year for five years. Customers will be charged $120 per hour for bulldozer work. The bulldozer operator costs $26 per hour in wages and benefits. The bulldozer is expected to require annual maintenance costing $20,000. The bulldozer uses fuel that is expected to cost $34 per hour of bulldozer operation. Present Value...
1.
based on the table graph the concentration (number of molecules) of
both molecules A and B vs time. You shoild have two separate curves
(A and B).
2. all three trials started at different amounts. How did the
final ratios of A and B compare?
3. Did the reactions ever stop?
U Table 1: Trial 1 Trial 2 Trial 3 Time A Time A B Time А B 0 (Initial) 20 40 60 80 100 120 140 160 160...
Please use Excel to solve!
Ne Present Value and Other Capital Budgeting Measures 5. Consider a project that has the following cash flows: initial cash flow (t-0) --$100,000; cash flows years 1 to 5 (t-1-5) - $10,000 per year, cash flows years 6 to 10 (t-6-10) - $20,000 per year. If the required return on the project is 6%, calculate the following: a. Internal Rate of Return (IRR)? b. Net Present Value (NPV)? c. Profitability index (PI)? d. Payback period?
what is the Present Value of an asset that pays the following cash flows, if you can invest them at a rate of return of 5%? Time Period Cash Flow 0 2 4 75 75 75 75 75 Note: this is an 'ordinary annuity', it is the default assumption for both Excel and your financial calculator. a) Identify the assumptions given in this problem Rate of Return # of years Annual Payment Future Value b) Solve this problem using the...
Use Excel to calculate the expected present value of the
following cash flows using a 5% discount rate? Be prepared to
explain how you calculated your answer.
Year 1 Cash Flow Estimates $ 1,500 $ 2,000 $ 2,500 Probabiltiy of Estimate 10% 50% 40% Total Year 2 $ $ $ 3,300 3,600 4,000 15% 40% 45%
Procedure Use the following sets of data and work with each one. The equation for a linear graph is y mx+b, where m is the slope and b is the y-intercept. DATA SET 1: Fahrenheit-vs- Celsius Fahrenheit Celsius 32 68 104 140 176 0 20 40 60 80 1. Using Data Set 1 above, graph Fahrenheit (y) -vs- Celsius (x), using the scatterplot function in excel, or another graphing software. Make sure you label the axes. Fahrenheit should be on...
Net Present Value Method Annuity E &T Excavation Company is planning an investment of $386,700 for a bulldozer. The bulldozer is expected to operate for 2,000 hours per year for five years. Customers will be charged $120 per hour for bulldozer work. The bulldozer operator costs $26 per hour in wages and benefits. The bulldozer is expected to require annual maintenance costing $20,000. The bulldozer uses fuel that is expected to cost $34 per hour of bulldozer operation. Present Value...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago