Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Financial Statement Analysis Case (Part Level Submission) Consolidated Natural G

ID: 342194 • Letter: F

Question

Financial Statement Analysis Case (Part Level Submission)

Consolidated Natural Gas Company (CNG), with corporate headquarters in Pittsburgh, Pennsylvania, is one of the largest producers, transporters, distributors, and marketers of natural gas in North America.

Periodically, the company experiences a decrease in the value of its gas- and oil-producing properties, and a special charge to income was recorded in order to reduce the carrying value of those assets.

Assume the following information. In 2016, CNG estimated the cash inflows from its oil- and gas-producing properties to be $375,000 per year. During 2017, the write-downs described above caused the estimate to be decreased to $275,000 per year. Production costs (cash outflows) associated with all these properties were estimated to be $125,000 per year in 2016, but this amount was revised to $155,000 per year in 2017.

(Assume that all cash flows occur at the end of the year.)

Calculate the present value of net cash flows for 2016–2018 (three years), using the 2016 estimates and a 10% discount factor.

Explanation / Answer

Year 2016 = ($375,000-$125,000)*0.90909 = $227,273

Year 2017 = ($275,000-$155,000)*0.82644 = $99,173

Year 2018 = ($275,000-$155,000)*0.75131 = $90,158

Present value of Net Cash Flows = $416,604

By using the 2016 estimates,the present value of net cash flows are as follows:-

Year 2016 = ($375,000-$125,000)*0.90909 = $227,273

Year 2017 = ($375,000-$125,000)*0.82644 = $206,610

Year 2018 = ($375,000-$125,000)*0.75131 = $187,828

Present value of Net Cash Flows = $621,711

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote