Free cash flows (FCF), for this exercise is difference between cash generated from operating income minus...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Free cash flows (FCF), for this exercise is difference between cash generated from operating income minus capital expenses at the end of your company's fiscal or calendar year. The present value of free cash flows is one method of determining a company's value to a potential buyer. Note: For Milestone One, please use the adjusted free cash flows calculated for your selected company on Tab 2 (Selected Co. for Project) of this Excel workbook. Use 5% as the interest rate for these questions. A B C D E 2 1 Milestone One: Time Value of Money (please fill in YELLOW cells) * Dollar amounts are in millions $ 3 4 Question 1. 10 5 Interest Rate 5% 6 7 FCF Years FCF in dollars* $ $ 8 00 9 LO [1 12 23 Pv* $ Total Pv* $ 13 15 *In millions $ EA $ FL G H 8 Year Year Year 2022 2021 2020 $ 10,113.00 $ 11,049.00 $ 4,308.00 M $ 1,853.00 $ 1,791.00 $ 1,484.00 M $ 8,260.00 $ 9,258.00 $ 2,824.00 F $ $ 3.70 $ 1.86% 12.04 $ (4,816.00) $ 2.80 $ 2.25 M 1.08% 7.75 $ 1.40% F 5.49 M 1,437.00 $ 1,972.00 M 699.00 199.24 $ 750.00 778.00 Y 258.48 $ 160.51 Y 20% 20% 20% 5% 5% 5% 9 Most Recent Calendar or Fiscal Year End-Then Two Prior Years 10 Enter Years 11 Net Cash Provided by Operating Activities 12 Capital Expenditures 13 Free Cash Flows 14 Cash Dividends per Share 15 Dividend Yield 16 Diluted Earnings per Common Share 17 Shareholder's Equity 18 Total Common Shares Outstanding 19 Common Stock Closing Price per Share 20 Effective Tax Rate (Use 20%) 21 Weighted Average Cost of Capital (Use 5%) 22 SASSASA SS EA $ D9 Clipboard A 7 Font : Xfx =PV(C5,1,,D7) B C Clipboard E9 A Font Alignment Xfx =PV(C5,2,,E7) B C D E 1 Milestone One: Time Value of Money (please fill in YELLOW cells) * Dollar amounts are in millions $ 2 3 4 Question 1. 10 5 Interest Rate 5% 6 FCF-Years FCF in dollars* 7 8 9 10 Pv* $ $ I F EA $ $ EA $ $ EA 7 N Free cash flows (FCF), for this exercise is difference between cash generated from operating income minus capital expenses at the end of your company's fiscal or calendar year. The present value of free cash flows is one method of determining a company's value to a potential buyer. Note: For Milestone One, please use the adjusted free cash flows calculated for your selected company on Tab 2 (Selected Co. for Project) of this Excel workbook. Use 5% as the interest rate for these questions. A B C D E 2 1 Milestone One: Time Value of Money (please fill in YELLOW cells) * Dollar amounts are in millions $ 3 4 Question 1. 10 5 Interest Rate 5% 6 7 FCF Years FCF in dollars* $ $ 8 00 9 LO [1 12 23 Pv* $ Total Pv* $ 13 15 *In millions $ EA $ FL G H 8 Year Year Year 2022 2021 2020 $ 10,113.00 $ 11,049.00 $ 4,308.00 M $ 1,853.00 $ 1,791.00 $ 1,484.00 M $ 8,260.00 $ 9,258.00 $ 2,824.00 F $ $ 3.70 $ 1.86% 12.04 $ (4,816.00) $ 2.80 $ 2.25 M 1.08% 7.75 $ 1.40% F 5.49 M 1,437.00 $ 1,972.00 M 699.00 199.24 $ 750.00 778.00 Y 258.48 $ 160.51 Y 20% 20% 20% 5% 5% 5% 9 Most Recent Calendar or Fiscal Year End-Then Two Prior Years 10 Enter Years 11 Net Cash Provided by Operating Activities 12 Capital Expenditures 13 Free Cash Flows 14 Cash Dividends per Share 15 Dividend Yield 16 Diluted Earnings per Common Share 17 Shareholder's Equity 18 Total Common Shares Outstanding 19 Common Stock Closing Price per Share 20 Effective Tax Rate (Use 20%) 21 Weighted Average Cost of Capital (Use 5%) 22 SASSASA SS EA $ D9 Clipboard A 7 Font : Xfx =PV(C5,1,,D7) B C Clipboard E9 A Font Alignment Xfx =PV(C5,2,,E7) B C D E 1 Milestone One: Time Value of Money (please fill in YELLOW cells) * Dollar amounts are in millions $ 2 3 4 Question 1. 10 5 Interest Rate 5% 6 FCF-Years FCF in dollars* 7 8 9 10 Pv* $ $ I F EA $ $ EA $ $ EA 7 N
Expert Answer:
Related Book For
Understanding Financial Accounting
ISBN: 978-1118849385
1st Canadian Edition
Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald
Posted Date:
Students also viewed these finance questions
-
If the value of the euro increases relative to the dollar, Disney might attract European families by advertising specially priced tourist packages. In this scenario, what global marketing environment...
-
What variables (i.e., interest rates, inflation, unemployment, and so forth) impact PepsiCo financial decision and strategic objectives. Scenario: You have been hired by a prominent financial...
-
1. Imagine you are visiting a friend who lives in a huge subdivision that only has one entrance and you forgot to bring your phone. You remember that there are four stop signs and at each you take...
-
Figlio (1999) found that legislators are more likely to mirror their constituents preferences during election years than in earlier years of their terms. This is particularly true for relatively...
-
You have just received a letter from a customer who purchased new rims for his car from your tire store several months ago. He paid for the rims when he ordered them because they were a special...
-
Distinguish between these types of user documentation: reference documents, procedures manuals, and tutorials.
-
Comprehensive regression problem in an effort to expend sales programs in the best way to generate sales revenue, the Cordwinn Company has been tracking various costs and sales data. Below is a...
-
Reveen Products sells camping equipment. One of the companys products, a camp lantern, sells for $90 per unit. Variable expenses are $63 per lantern, and fi xed expenses associated with the lantern...
-
5) Change the Cartesian integral 1-52 2 1-2-2 (14x24v2)3 dydx into an equivalent polar integral, then evaluate
-
Bir z -istatisti?i kullanarak iki rneklemortalamas?ndaki fark? test etmek iin hangi ko?ulun kar??lanmas?gerekir??oktan semeli?ki poplasyon standart sapmas? bilinmelidir.Veriler 1 answer
-
Mashu Baker Inc. have generated sales of $500,000 for the current year. If they can grow their sales at a rate of 9.5 percent every year, how long will they take to triple their sales? (Round to the...
-
You do not feel that the current price of XOM is correct. You expect that within the next 6 months, the company's stock price will go either substantially down, or substantially up. Create the...
-
1.What is FASB and what role do they have with financial statements? 2.What is the purpose of this institution in relation to the accounting profession? 3.What has been their trajectory over the...
-
Research the selected forum topic: Internationally integrated capital markets Compile response to the forum topic. Critical exchange forum topic response contributions will be critically graded on...
-
How would you guide learners to self-analyze the results of the assessment and reflect on their learning?
-
Schedule of Activity Costs Quality Control Activities Activity Cost Process audits $50,300 Training of machine operators 28,000 Processing returned products 16,900 Scrap processing (disposal) 25,400...
-
Find the market equilibrium point for the following demand and supply functions. Demand: 2p = - q + 56 Supply: 3p - q = 34
-
A 40 in plasma television uses about \(175 \mathrm{~W}\). How many kilowatt-hours are needed to run the television in a month if the television is on for an average of 3 hours a day?
-
Which of the following is true regarding the accounting cycle? a. The accounts are adjusted after preparing the financial statements. b. Journal entries are made prior to the transaction being...
-
How many pills would be needed for a patient who has been prescribed \(25.5 \mathrm{mg}\) of a drug if each pill contains \(4.25 \mathrm{mg}\).
Study smarter with the SolutionInn App