Question

You own an oll plpeline that wll generate a $2.8 million cash return over the coming year. The pipelines operating costs are negligible, and it is expected to last for a very long time. Unfortunately, the volume of oll shipped declining, and cash flows are expected to decline by 5.5% per year. The discount rate is 12% a. What is the PV of the pipelines cash flows if its cash flows are assumed to last forever? (Do not round intermediate calculations. Round your answer to the nearest whole dollar amount.) Present value b. What is the PV of the cash flows if the pipeline is scrapped after 15 years? (Do not round intermediate calculations. Round your answer to the nearest whole dollar amount.) Present value

0 0
Add a comment Improve this question Transcribed image text
Answer #1

ivem Cash Flow 2J .8 n. Dise Rate R lines Gash Flow ft lost fanever Ke iscovntimg Rate Rete O. 13S 6 Cash Flow Ppeline scnefhed Please Rafer screensh어 et excel Ale atachesdbelow

File Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro 5 EX シTrace Precedents Show Formulas ร์Trace Dependents-1-Error Checking . Define Name· ■ Calculate Now ruse in Formula- Insert Autosum Recently Financial Logical Text Date & Lookup & Math More - Time- Reterence - & Trig - FunctionsManager ECreate from SelectionRemove Arrows-Evaluate Formula Windo Options .. Remove Arrows . Evaluate Formul Window (Dotnaculate Sheet Used Function Library Defined Names Formula Auditing Calculation art B Cash Flow (in mn $ PVE@1 01226 viin mnsi Year 0.71178 ●77979 2.23298 0.5674 1.06908 0.9020 0.45235 1.68285 0.5418 0.38574 Total pv 14.7487999 , Ready ! H1 | sheet1 . Sheet2 、 Sheet3 -2 000-00000000|0000 123456733 10 11 12 13 14 15 1234567 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25·ReFile Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro 5 EX Define Name ▼ Trace Precedents 떫 Trace Dependents ◆ Error Checking . Cakculate Now Use in Formula- Insert Autosum Recently Financial Logical Text Date & Lookup & Math More Used Time Reference-aTrig, Functions-Manager Create from Selection Remove Arrows, QEvaluate Formula window options Function Library Defined Names Formula Auditing Calculation K2 art B Cash Flow (in mn $ Year C5*0.945 8 D8/1.12 D12/112 D13 C13 -C13 *0.945 D15*CIS c17*0 Total PV SUM(E4:E18 , H Sheet1 ( Sheet2 . Sheet3·02 Ready !

"If you have any Query, then please put it in the comment box."

Add a comment
Know the answer?
Add Answer to:
You own an oll plpeline that wll generate a $2.8 million cash return over the coming...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT