Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What are the INCOME STATEMENT AND CASH FLOW STATMENT FORMULAS BASED ON THESE DIRECTIONS?: OF Scheduled Capital Expenditures These outlays are shown in the Constants

What are the INCOME STATEMENT AND CASH FLOW STATMENT FORMULAS BASED ON THESE DIRECTIONS?: OF Scheduled Capital ExpendituresThese outlays are shown in the Constants section. Theyreduce cash on hand.Repayment to Note Holders$3 billion is owed to noteholders at the end of 2017, with fiveyears remaining on the debt. $600 million must be repaid each year to noteholders. You canhard-code the amount for each year.Net Cash Position (NCP) Before Borrowing from BankThis amount equals cash at thebeginning of the year plus the years net income after income taxes, minus scheduled capital expenditures and minus payments to noteholders.Add: Borrowing from BankAssume that the company can borrow from a bank at the end of theyear to reach the minimum cash needed to start the next year. If the NCP is less than thisminimum amount, the company would borrow enough to start the next year with the minimum.Borrowing increases cash on hand, of course. Borrowing would be under a line of credit. Eachyear the company would need to pay interest on any amounts borrowed under the line of credit,but amounts borrowed would accumulate until a principal repayment schedule was negotiated,which would not happen until 2021.Equals: End-of-the-Year Cash on HandThis amount is the NCP plus any bank borrowing.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Technical Analysis Of Stock Trends

Authors: Robert D. Edwards, John Magee

5th Edition

0910944008, 978-0910944007

More Books

Students also viewed these Finance questions

Question

List the five steps in the decision-making model.

Answered: 1 week ago