This week you have a free cash flow (FCF) project. It will take approximately 2 to 3 hours to complete. Go to the Assignments link. Look at week 4 project for directions and to download the template. Email to me the FCF prpoject as an attachment using course email BEFORE Feb. 15th You only have one attempt.
Go to finance.yahoo.com (Links to an external site.) (press CTRL and click) and select a company. After you enter the symbol or company name, you will see data concerning its stock price. Above this stock data, you will see several headings: Summary, Chart Conversations etc. You will also see a link titled Financials. Click on the Financial link and you will see links to Income Statement and Balance Sheet. Type in the balance sheet as indicated in the template. You may enter the income statement amounts directly into the template (the top portion). This project serves two purposes: 1) it familiarizes you with the concept of Free Cash Flow (FCF) and 2) it provides an opportunity to use Excel. Note: When calculating FCF do not type in the numbers but identify the numbers based on their location, e.g. B21 and use “Excelize” (=b4-b5) to make calculations. If an account is blank for all three years, you do not need to waste your time typing in the account name. Do not use a – (dash to represent 0). Type in 0. Excel does not know what a – represents and you will have error messages. Once you calculate FCF for 2019, all you have to do is copy and paste it in the 2018 column to get get FCF for 2018. See the template for more directions. This project is due on or before April 14. NOTE: LOOK AT SOME OF THE EXCEL TUTORIALS TO FAMILIARIZE YOURSELF WITH EXCEL.
Please download and read the Free Cash Flow Lecture Notes and cash flow project template. Read the assigned chapter. Do the homework assignment and complete the quiz.
The project when completed will look something like this click here. Note: I will grade this project based on the excel formulas you use to calculate NOPAT, OCA, OCL, NOWC, TOC, and FCF.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more