1. If the present worth of a project that yields 120,000 in regular cash flow over...

1. If the present worth of a project that yields 120,000 in regular cash flow over 40 periods was calculated to be 1.5 million, what interest rate was used? Report in percentage format with 3 digits after decimal point.

Solutions

Expert Solution

Present Value = Future value/ ((1+r)^t)
where r is the interest rate and t is the time period
sum of present values = 1500000
Use excel to find r that is the interest rate.

r	0.0755
t	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40
cash flow	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000	120000
present value	111576	103743.4	96460.61	89689.08	83392.92	77538.74	72095.53	67034.43	62328.62	57953.16	53884.85	50102.14	46584.97	43314.71	40274.02	37446.79	34818.03	32373.81	30101.17	27988.07	26023.31	24196.48	22497.89	20918.54	19450.06	18084.66	16815.12	15634.7	14537.15	13516.64	12567.77	11685.52	10865.2	10102.46	9393.268	8733.862	8120.746	7550.67	7020.614	6527.767
sum of present values	1502943

The interest rate that was used was equal to 7.550% approximately.

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

Q) Determine the present worth of a geometric gradient series with a cash flow of $38,537...

Q) Determine the present worth of a geometric gradient series with a cash flow of $38,537 in year 1 and increases of 11% each year begining of year 4 through year 11. The interest rate is 16% per year. Q) The capital cost (CC), now, when a family want to have $6,004, per year, starting in year 26 and continuing forever, is close to. Assume rate of return13% Q) Alternative X has a first cost of $20000, an operating cost of...

In an arithmetic gradient series cash flow shown below, determine the present worth in year 0...

In an arithmetic gradient series cash flow shown below, determine the present worth in year 0 for i =8% per year, A1=50 , and A2=170. Year 0 1 2 3 4 5 6 7 8 Cash Flow, $ - A1 50 70 90 A2 130 150 170

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero...

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero at MARR = 7%. The study period needs to be exactly 18 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).

How is the net present value (NPV) calculated for a project with a conventional cash flow...

How is the net present value (NPV) calculated for a project with a conventional cash flow pattern, and what are the acceptance criteria for NPV, how are they related to the firm’s market value with explanation of the similarities and differences between NPV, PI, and EVA. PLEASE MINIMUM 350 WORDS.

Find the present worth of the following project, using i = 10%/year. Cash Flows Initial cost...

Find the present worth of the following project, using i = 10%/year. Cash Flows Initial cost $20000 Annual benefit for years 1 ~ 10 $6000 Annual benefit for years 11 ~ 20 $8000

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1)...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project: Sales revenues $10 million Operating costs (excluding depreciation) 7 million Depreciation 2 million Interest expense 2 million The company has a 40% tax rate, and its WACC is 11%. Write out your answers completely. For example, 13 million should be entered as 13,000,000. What is the project's cash flow...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1)...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project: Sales revenues $25 million Operating costs (excluding depreciation) 17.5 million Depreciation 5 million Interest expense 5 million The company has a 40% tax rate, and its WACC is 13%. Write out your answers completely. For example, 13 million should be entered as 13,000,000. What is the project's cash flow...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1)...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project: Sales revenues $15 million Operating costs (excluding depreciation) 10.5 million Depreciation 3 million Interest expense 3 million The company has a 40% tax rate, and its WACC is 14%. Write out your answers completely. For example, 13 million should be entered as 13,000,000. What is the project's cash flow...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1)...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project: Sales revenues $10 million Operating costs (excluding depreciation) 7 million Depreciation 2 million Interest expense 2 million The company has a 40% tax rate, and its WACC is 12%. Write out your answers completely. For example, 13 million should be entered as 13,000,000. What is the project's cash flow...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1)...

PROJECT CASH FLOW Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project: Sales revenues $5 million Operating costs (excluding depreciation) 3.5 million Depreciation 1 million Interest expense 1 million The company has a 40% tax rate, and its WACC is 10%. Write out your answers completely. For example, 13 million should be entered as 13,000,000. What is the project's cash flow...

Subjects