Question

In: Finance

Please answer the following by hand showing all arithmatic and original formulas, please do not use...

Please answer the following by hand showing all arithmatic and original formulas, please do not use a graphic calculator.

The province of Ontario is planning to construct a new hydropower plant to help make energy prices more affordable, as well as to support improved public health and environmental quality. The construction of the hydropower plant will start by the beginning of 2023 and will take 3 years at a cost of $200 million per year. The cost of maintenance and repairs, which is to start after project completion, is expected to be $5 million for the first 6 years, and to increase by $50,000 per year thereafter. The scrap value of the hydropower plant is estimated to be $25 million at the end of its service life. The project is expected to save the province $55 million per year in energy savings. Assume the present to be the end of 2017/beginning of 2018, the life of the project is till the end of year 2060, and the interest rate to be 5%.

a) Draw a cash flow diagram for this project (from present till 2060).

b) What is the Present Worth of the project?

c) What is the Future Worth of the project?

d) Is it a good investment for the province to make?

Solutions

Expert Solution

c)

d) it is a good investment for the province to make as present worth is positive.


Related Solutions

Please explain your answer clearly. Please show all the formulas and calculations (please do not use...
Please explain your answer clearly. Please show all the formulas and calculations (please do not use excel): Anchor Ltd paid $15,000 last quarter for a feasibility study regarding the demand for motorboat replacement parts which would require the purchase of a new metal-shaping machine. Today, they wish to conduct an analysis of the proposed project. The machine costs $250,000 and will operate for five years and tax rules allow the machine to be depreciated to zero over a five-year life....
Please show all work and formulas Please use the following information to answer this question. State    ...
Please show all work and formulas Please use the following information to answer this question. State     Probability       A                     B                      C Boom   .3                     -10%                5%                   0% Normal            .4                     5                      3                      2                      Bust     .3                     10                    -5                     2 Find the expected return and variance of the portfolio if an investor spent $5000 on A, $8000 on B and $7000 on C.
Please show all work and formulas Please use the following information to answer this question. State    ...
Please show all work and formulas Please use the following information to answer this question. State     Probability       A                     B                      C Boom   .3                     -10%                5%                   0% Normal            .4                     5                      3                      2                      Bust     .3                     10                    -5                     2 Find the expected return and variance of the portfolio if an investor spent $5000 on A, $8000 on B and $7000 on C.
Kindly, do not hand write, use excel or word document, please let the work be original...
Kindly, do not hand write, use excel or word document, please let the work be original Capacity Planning Homework Assignment—To be Submitted The Baltimore Manufacturing Company’s management forecasts demand for each quarter as follows: First Quarter Second Quarter Third Quarter Fourth Quarter Average quarterly demand 7000 units 9000 units 10000 units 8000 units Assume that Arundel, Inc. started the First Quarter with 20 workers and 2000 units in inventory. The company wishes to finish the year with an inventory of...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just​ completed, Grips earned $4.25 per share and paid cash dividends of ​$2.55 per share ​(D0=$2.55). Grips' earnings and dividends are expected to grow at 25​% per year for the next 3​ years, after which they are...
Pleas use Excel®—showing all work and formulas (attach excel sheet please) Dwight Donovan, the president of...
Pleas use Excel®—showing all work and formulas (attach excel sheet please) Dwight Donovan, the president of Donovan Enterprises is considering two investment opportunities. Because of limited resources he will be able to only invest in one of them. Project A is to purchase a machine that will enable factory automation; the machine is expected to have a useful life of four years and no salvage value. Project B supports a training program that will improve the skills of employees operating...
please do it step by step with the use of formulas , thank you.. The following...
please do it step by step with the use of formulas , thank you.. The following are monthly percentage price changes for four market indexes. Month DJ SP500 1 0.03 0.02 2 0.07 0.06 3 −0.02 −0.01 4 0.01 0.03 5 0.05 0.04 6 −0.06 −0.04 Russ500 Nicky 0.04 0.04 0.10 −0.02 −0.04 0.07 0.03 0.02 0.11 0.02 −0.08 0.06 (17 points) Compute the following. a. Average monthly rate of return for each index b. Standard deviation for each index...
Please do all parts! Do not use statistics software. I want to see the formulas. study...
Please do all parts! Do not use statistics software. I want to see the formulas. study of the effect of caffeine on muscle metabolism used 24 male volunteers who each underwent arm exercise tests. 12 of the men were randomly selected to take a capsule containing pure caffeine one hour before the test. The other men received a placebo capsule. During each exercise the subject's respiratory exchange ratio (RER) was measured. (RER is the ratio of CO2 produced to O2...
Please post answers in excel showing all formulas used. Refer to the gasoline sales time series...
Please post answers in excel showing all formulas used. Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 21 3 19 4 22 5 18 6 16 7 20 8 19 9 23 10 19 11 16 12 22 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 18 2 21 3...
Please answer full question thoroughly (A- D) showing detailed work. SUBMIT ORIGINAL work and ensure it...
Please answer full question thoroughly (A- D) showing detailed work. SUBMIT ORIGINAL work and ensure it is correct for thumbs up. a) What is the effect of calling MAX-HEAPIFY(A, i) when the element A[I ]is larger than its children? b) What is the effect of calling MAX-HEAPIFY(A, i) for i > A.heap-size/2? c) The code for MAX-HEAPIFYis quite efficient in terms of constant factors, except possibly for the recursive call in line 10, which might cause some compilers to produce...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT