You are a financial manager that wants to know projected cash flows next year for decision-making...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a financial manager that wants to know projected cash flows next year for decision-making purposes. Below is some financial statement information that is loosely based on Pfizer (symbol: PFE) for the year ended December 31, 2018: Income Statement (in millions $) Year Ended December 31, 2018 Sales 53,700 9,600 Cost of Sales Depreciation 1,500 Amortization 4,900 37,700 Gross Income Selling, General, Administrative Expenses Research and Development Other Expenses Interest Expense 14,400 8,000 2,100 1,300 11,900 Pre-Tax Income Таx 700 Net Income 11,200 Balance Sheet (in millions $) Year Ended December 31, 2018 18,800 Accounts Payable 8,000 Short Term Debt 7,500 Other Current Liabilities Cash 4,700 8,800 18,400 Net Receivables Inventory Other Current Assets Current Assets 15,600 49,900 Current Liabilities 31,900 Net Property, Plant, Equipment Intangible Assets 13,400 Long Term Debt 96,100 63,800 Total Liabilities 95,700 63,700 Total Stockholders' Equity 159,400 Total Liabilities and Equity Total Assets 159,400 Assume the following for the year ended December 31, 2017: (1) net property, plant, and equipment was $13,900M; (2) intangible assets was $116,800M; and (3) long-term debt was $69,700M. Assume the following when constructing the pro-forma income statement in part (a) of this question: (1) pro-forma amortization expense is calculated using the ratio of amortization expense in 2018 to intangible assets in 2017 (similar to how you calculate pro-forma depreciation); and (2) other expenses remain constant. Also assume the following when constructing the pro-forma balance sheet in part (b) of this question: (1) other current assets, intangible assets, and other current liabilities remain constant; and (4) pro-forma short-term debt is calculated using the ratio of short-term debt to COGS in 2018 (similar to how you calculate pro-forma accounts payable). a) Construct a pro-forma income statement for December 31, 2019 based on the optimistic assumption that sales will grow by 5.0 percent next year. Be clear about your work and assumptions. b) Construct a pro-forma balance sheet for December 31, 2019. Assume that the firm will buy another $6,000M in property, plant, and equipment. Also assume that a dividend of $12,000M will be paid out next year. If total assets is greater than total liabilities plus equity, correct this imbalance (i.e. the net funding need) by adding to long-term debt. If total assets is less than total liabilities plus equity, correct this imbalance by retiring long-term debt. Be clear about your work and assumptions and report how much you add to or subtract from long-term debt. c) What is the projected free cash flow (FCF) for December 31, 2019? Use the following equation to solve for FCF: FCF = OCF – Capex – ANWC, where OCF = Net Income + Interest + Depreciation + Amortization. Make sure to show the individual numbers used in this equation. The free cash flows are the cash flows available for distribution to the firm's investors (stockholders and bondholders). d) The free cash flow is the cash available to pay out to your investors (i.e. your bondholders and stockholders). According to your pro-formas, how much do you plan to pay your investors in 2019? (This will be the sum of interest and dividend payments.) By how much does this exceed the free cash flow you calculated in part (c)? e) The present value of all future free cash flows for PFE represents the market value of assets for PFE. Assume that the pro-forma free cash flow in 2019 will grow at 2 percent per year in perpetuity. Assume that the beta of assets for PFE is 0.45. Also assume a risk-free rate of 2.2 percent and a market risk premium of 5.0 percent. What is the market value of PFE assets? You are a financial manager that wants to know projected cash flows next year for decision-making purposes. Below is some financial statement information that is loosely based on Pfizer (symbol: PFE) for the year ended December 31, 2018: Income Statement (in millions $) Year Ended December 31, 2018 Sales 53,700 9,600 Cost of Sales Depreciation 1,500 Amortization 4,900 37,700 Gross Income Selling, General, Administrative Expenses Research and Development Other Expenses Interest Expense 14,400 8,000 2,100 1,300 11,900 Pre-Tax Income Таx 700 Net Income 11,200 Balance Sheet (in millions $) Year Ended December 31, 2018 18,800 Accounts Payable 8,000 Short Term Debt 7,500 Other Current Liabilities Cash 4,700 8,800 18,400 Net Receivables Inventory Other Current Assets Current Assets 15,600 49,900 Current Liabilities 31,900 Net Property, Plant, Equipment Intangible Assets 13,400 Long Term Debt 96,100 63,800 Total Liabilities 95,700 63,700 Total Stockholders' Equity 159,400 Total Liabilities and Equity Total Assets 159,400 Assume the following for the year ended December 31, 2017: (1) net property, plant, and equipment was $13,900M; (2) intangible assets was $116,800M; and (3) long-term debt was $69,700M. Assume the following when constructing the pro-forma income statement in part (a) of this question: (1) pro-forma amortization expense is calculated using the ratio of amortization expense in 2018 to intangible assets in 2017 (similar to how you calculate pro-forma depreciation); and (2) other expenses remain constant. Also assume the following when constructing the pro-forma balance sheet in part (b) of this question: (1) other current assets, intangible assets, and other current liabilities remain constant; and (4) pro-forma short-term debt is calculated using the ratio of short-term debt to COGS in 2018 (similar to how you calculate pro-forma accounts payable). a) Construct a pro-forma income statement for December 31, 2019 based on the optimistic assumption that sales will grow by 5.0 percent next year. Be clear about your work and assumptions. b) Construct a pro-forma balance sheet for December 31, 2019. Assume that the firm will buy another $6,000M in property, plant, and equipment. Also assume that a dividend of $12,000M will be paid out next year. If total assets is greater than total liabilities plus equity, correct this imbalance (i.e. the net funding need) by adding to long-term debt. If total assets is less than total liabilities plus equity, correct this imbalance by retiring long-term debt. Be clear about your work and assumptions and report how much you add to or subtract from long-term debt. c) What is the projected free cash flow (FCF) for December 31, 2019? Use the following equation to solve for FCF: FCF = OCF – Capex – ANWC, where OCF = Net Income + Interest + Depreciation + Amortization. Make sure to show the individual numbers used in this equation. The free cash flows are the cash flows available for distribution to the firm's investors (stockholders and bondholders). d) The free cash flow is the cash available to pay out to your investors (i.e. your bondholders and stockholders). According to your pro-formas, how much do you plan to pay your investors in 2019? (This will be the sum of interest and dividend payments.) By how much does this exceed the free cash flow you calculated in part (c)? e) The present value of all future free cash flows for PFE represents the market value of assets for PFE. Assume that the pro-forma free cash flow in 2019 will grow at 2 percent per year in perpetuity. Assume that the beta of assets for PFE is 0.45. Also assume a risk-free rate of 2.2 percent and a market risk premium of 5.0 percent. What is the market value of PFE assets?
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-0324312140
16th Edition
Authors: James D. Stice, Earl K. Stice, Fred Skousen
Posted Date:
Students also viewed these accounting questions
-
You are a financial analyst employed at Clarington Quarry Works (CQW). CQW has a December 31 year-end. CQW's board of directors is considering a change to the company's executive compensation plan so...
-
You are a financial analyst and have been looking at the financial statements of Denethor Company. The notes to the financial statements reveal that Denethor changed its estimated depreciation lives...
-
You are a financial analyst for the Ajax Company, which uses about $1 million of inventory per month. The purchasing manager has come to you for help with a buying decision. He can get a big discount...
-
Hybrid Corporation began operations in 2018 and during that year purchased equity investments. It owns less than 20% of the voting shares for all companies whose stock it purchased. The year-end cost...
-
Differentiate horizontal from vertical equity.
-
A pump increases the pressure of water from 100 kPa to 3 MPa at a rate of 0.5 m 3 /min. The inlet and outlet diameters are identical and there is no change in elevation across the pump. If the...
-
In Section 5.5, the one-term approximation to the series solution for the temperature distribution was developed for a plane wall of thickness \(2 L\) that is initially at a uniform temperature and...
-
On July 31, 2019, Keeds Company had a cash balance per books of $6,140. The statement from Dakota State Bank on that date showed a balance of $7,690.80. A comparison of the bank statement with the...
-
ASE STUDY APPLICANT TESTING AT THE RCMP Applicants to the Royal Canadian Mounted Police (RCMP) must pass a written examination, an inter- view, and a physical ability test before being accepted for...
-
The Case Study - "Lemonade: Delighting Insurance Customers with AI and Behavioral Economics". 1. How do you explain the phenomenal growth experienced by Lemonade? 2. Does Lemonade create a unique...
-
A computer system has a page size of 1,024 bytes and maintains the page table for each process in main memory. The overhead required for doing a lookup in the page table is 500 ns. To reduce this...
-
When analyzing items on the comparative statements of financial position, what must be done to convert them to the cash basis?
-
BUSINESS IS A CAR WASH. HYBRID CAR WASH... THE CUSTOMER GOES FIRST TO THE TOUCHLESS MACHINE THEN STATTF DO EVERYTHING ELS. THE TOTAL TIME WOULD BE 12 MINUTES Promotion and Distribution Decisions (5%)...
-
Increasing the portion size of a meal in a restaurant gives the perception of value, but what does it do to the nutrient value of most meals?
-
Given that f(x)=x+1 and g(x) = x-x, find (f+g)(-2), if it exists.
-
The Organization of Global Business Global organizations utilize the following organizational structures: Functional Divisional Hybrid Matrix Choose a real-life global organization that utilizes one...
-
Cadence is an engineer with a salary of $165,000 from the firm where she works. She is covered by a retirement plan. Her husband, Oakley, is a writer with no earned income. They have no other sources...
-
Parkin Industries, a U.S. company, acquired a wholly-owned subsidiary, located in Italy, at the beginning of the current year, for 200,000. The subsidiary's functional currency is the euro. The...
-
Energizer Manufacturing Corporation reports taxable income of $829,000 on its income tax return for the year ended December 31, 2008, its first year of operations. Temporary differences between...
-
On January 1, 2008, the company purchased a piece of equipment for $30,000. The equipment has a 5-year useful life and $0 residual value. The company uses straight-line depreciation for financial...
-
On January 1, the lessor company purchased some equipment (for cash) that the company then immediately leased. The lease contract calls for the receipt of $3,000 payments at the end of each year for...
-
What factors is a judge likely to consider when determining best interest?
-
What is the best interest standard?
-
What criticisms are commonly made about the best interest standard?
Study smarter with the SolutionInn App