Forecast the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Forecast the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements of Victoria Inc. VICTORIA INC. Consolidated Income Statements For Year Ended December 31 ($ millions) 2019 2018 Revenues. $32,376 $30,601 Cost of sales. 17,405 16,534 Gross profit.. 14,971 14,067 Research and development expense. 3,278 3,213 Operating overhead expense.. 7,191 6,679 Total selling and administrative expense 10,469 9,892 Interest expense, net... 19 28 Other (income) expense, net (140) (58) Income before income taxes 4,623 4,205 Income tax expense.. 863 932 Net income... $ 3,760 $ 3,273 VICTORIA INC. Consolidated Balance Sheets December 31 ($ millions) 2019 2018 Current assets Cash and equivalents. $ 3,138 $ 3,852 Short-term investments. 2,319 2,072 Accounts receivable, net. 3,241 3,358 Inventories.... 4,838 4,337 Prepaid expenses and other current assets. 1,489 1,968 Total current assets 15,025 15,587 Property, plant and equipment, net 3,520 3,011 Identifiable intangible assets, net.. 281 281 Goodwill. 131 131 Deferred income taxes and other assets 2,439 2,587 Total assets $21,396 $21,597 December 31 ($ millions) 2019 2018 Current liabilities Current portion of long-term debt $ 44 $ 107 Notes payable... 1 Accounts payable. 2,191 Accrued liabilities 3,037 74 2,131 3,949 Income taxes payable.. 85 71 Total current liabilities.. 5,358 6,332 Long-term debt.. 2,010 1,079 Deferred income taxes and other liabilities. 1,770 1,479 Total liabilities.. 9,138 8,890 Shareholders' equity Class A convertible common stock. 0 0 Class B common stock. 3 3 Capital in excess of stated value 7,786 6,773 Accumulated other comprehensive income. 318 1,246 Retained earnings... 4,151 4,685 Total shareholders' equity 12,258 12,707 Total liabilities and shareholders' equity.. $21,396 $21,597 Required Forecast Victoria's 2020 income statement, balance sheet, and statement of cash flows. • Round the revenue growth rate to the nearest whole percent. ⚫ Round forecasts to $ millions. • Assume no change for interest expense, net, other (income) expense, net, short-term investments, goodwill, notes payable, all classes of common stock, capital in excess of stated value, and accumulated other comprehensive income. For 2019, capital expenditures are $1,143 million, depreciation expense is $649 million, amortization expense is $13 million, and dividends are $1,022 million. Forecast CAPEX as a percentage of revenue. Forecast depreciation and amortization as a percentage of beginning-year PPE, net and beginning-year intangibles, respectively. Forecast dividends as a percentage of net income. ⚫ Footnotes reveal that the current portion of long-term debt due in 2021 is $6 million. Estimate forecast assumptions for all other balance sheet and income statement items as a percentage of Revenues, rounded to three decimal places (for example, Inventories/Revenues is 0.14943 rounded to 0.149 or 14.9%). Assume tax expense is 18.7% of pretax income. What do the forecasts imply about the company's cash balance and related financing needs for the upcom- ing year? Forecast the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements of Victoria Inc. VICTORIA INC. Consolidated Income Statements For Year Ended December 31 ($ millions) 2019 2018 Revenues. $32,376 $30,601 Cost of sales. 17,405 16,534 Gross profit.. 14,971 14,067 Research and development expense. 3,278 3,213 Operating overhead expense.. 7,191 6,679 Total selling and administrative expense 10,469 9,892 Interest expense, net... 19 28 Other (income) expense, net (140) (58) Income before income taxes 4,623 4,205 Income tax expense.. 863 932 Net income... $ 3,760 $ 3,273 VICTORIA INC. Consolidated Balance Sheets December 31 ($ millions) 2019 2018 Current assets Cash and equivalents. $ 3,138 $ 3,852 Short-term investments. 2,319 2,072 Accounts receivable, net. 3,241 3,358 Inventories.... 4,838 4,337 Prepaid expenses and other current assets. 1,489 1,968 Total current assets 15,025 15,587 Property, plant and equipment, net 3,520 3,011 Identifiable intangible assets, net.. 281 281 Goodwill. 131 131 Deferred income taxes and other assets 2,439 2,587 Total assets $21,396 $21,597 December 31 ($ millions) 2019 2018 Current liabilities Current portion of long-term debt $ 44 $ 107 Notes payable... 1 Accounts payable. 2,191 Accrued liabilities 3,037 74 2,131 3,949 Income taxes payable.. 85 71 Total current liabilities.. 5,358 6,332 Long-term debt.. 2,010 1,079 Deferred income taxes and other liabilities. 1,770 1,479 Total liabilities.. 9,138 8,890 Shareholders' equity Class A convertible common stock. 0 0 Class B common stock. 3 3 Capital in excess of stated value 7,786 6,773 Accumulated other comprehensive income. 318 1,246 Retained earnings... 4,151 4,685 Total shareholders' equity 12,258 12,707 Total liabilities and shareholders' equity.. $21,396 $21,597 Required Forecast Victoria's 2020 income statement, balance sheet, and statement of cash flows. • Round the revenue growth rate to the nearest whole percent. ⚫ Round forecasts to $ millions. • Assume no change for interest expense, net, other (income) expense, net, short-term investments, goodwill, notes payable, all classes of common stock, capital in excess of stated value, and accumulated other comprehensive income. For 2019, capital expenditures are $1,143 million, depreciation expense is $649 million, amortization expense is $13 million, and dividends are $1,022 million. Forecast CAPEX as a percentage of revenue. Forecast depreciation and amortization as a percentage of beginning-year PPE, net and beginning-year intangibles, respectively. Forecast dividends as a percentage of net income. ⚫ Footnotes reveal that the current portion of long-term debt due in 2021 is $6 million. Estimate forecast assumptions for all other balance sheet and income statement items as a percentage of Revenues, rounded to three decimal places (for example, Inventories/Revenues is 0.14943 rounded to 0.149 or 14.9%). Assume tax expense is 18.7% of pretax income. What do the forecasts imply about the company's cash balance and related financing needs for the upcom- ing year?
Expert Answer:
Answer rating: 100% (QA)
Here are the forecasts for Victoria Inc for 2020 Income Statement Revenues 33184 2 growth from 2019 ... View the full answer
Related Book For
Financial And Managerial Accounting For MBAs
ISBN: 9781618533593
6th Edition
Authors: Peter D. Easton
Posted Date:
Students also viewed these finance questions
-
Since the early 1990s, woodstove sales have declined from 1,200,000 units per year to approximately 100,000 units per year. The decline has occurred because of (1) stringent new federal EPA...
-
A liquid with a density of 800 kg/m is flowing through a pipe with a diameter of 0.05 m at a velocity of 2 m/s. The pipe is insulated and the temperature of the liquid is 40C. Determine the mass flow...
-
Income Statement Accounts December 31, 20X1 Sales Sales Returns and Allowances Purchases Purchase Returns and Allowance Advertising Sales Salaries Commission Expense Miscellaneous Selling Expense...
-
A device used in radiation therapy for cancer contains 0.50 g of cobalt 60 27 Co (59.933 819 u). The half-life of 60 27 Co is 5.27 yr. Determine the activity of the radioactive material. 20
-
Miller Company acquired an 80 percent interest in Taylor Company on January 1, 2016. Miller paid $664,000 in cash to the owners of Taylor to acquire these shares. In addition, the remaining 20...
-
Why are the attributes of interest important in a sampling plan?
-
During 2014, North Dakota Company issued $1,000,000 in long-term bonds at 96, repaid $150,000 of bonds at face value, paid interest of $80,000, and paid dividends of $50,000. Prepare the cash flows...
-
It is the first week of December and Christmas break is right around the corner when a close colleague of yours approaches you in confidence. Kelley Garcia is also a second year teacher and you were...
-
D) int a, b, c, sum, avg; a=2; b=4; c=6; sum = a+b+c; avg = a + b + c/3; cout <
-
How many times have you heard the phrase"our people are our most important asset"? What does it mean, and do you agree with it? Why or why not?
-
What measures can leaders implement to mitigate the potential pitfalls of over-delegation or micromanagement, striking a delicate balance between empowerment and control to avoid burnout,...
-
Functions hand kare inverse functions, and both are defined for all real numbers. Using this relationship, what is the value of each function composition? (hk)(3) = (koh)(-46) =
-
What strategies and frameworks can be employed to assess the competency and readiness of subordinates for delegated tasks, ensuring alignment between individual skill sets, developmental goals, and...
-
How does Hollywood differ from other film industries in the world?
-
Using the information provided below, calculate the minimum Net Employment Income that Jess would need to report on her 2020 tax return for this job offer. QNX Software Systems Offer & Estimates:...
-
Tiger, Inc. signed a lease for equipment on July 1, 2007.The lease is for 10 years (the useful life of the asset).The first of 10 equal annual payments of $500,000 was made on July 1, 2007.The...
-
Answer the following questions about the Target balance sheet. Target (TGT) a. Briefly describe the types of assets that Target is likely to include in its inventory. b. What kinds of assets would...
-
Explain the concept of liquidity and why it is crucial to company survival.
-
General Mills, Inc. reports the following fiscal year income statements. Forecast General Mills' fiscal year 2014 income statement assuming the following income statement relations (\$ in millions)....
-
(a) Complete a steady-state simulation of the vinyl-chloride process in Figure 2.6. First, create a simulation flowsheet. Assume that: Cooling water is heated from 30 to \(50^{\circ} \mathrm{C}\)...
-
For the monochlorobenzene separation process in Figure 7.14, the results of an ASPEN PLUS simulation are provided in the multimedia modules under ASPEN \( ightarrow\) Principles of Flowsheet...
-
Complete a simulation of the entire process for the hydrodealkylation of toluene in Figure 6.14. Initially, let the purge/recycle ratio be 0.25 ; then, vary this ratio and determine its effect on the...
Study smarter with the SolutionInn App