Complete a Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years
Fantastic news! We've Found the answer you've been seeking!
Question:
Complete a Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years (2020 & 2021), assuming a 10% growth rate in sales and Cost of Goods Sold (COGS) for each of the next two years.
Transcribed Image Text:
(Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets. Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other Equity: Commitments and contingencies Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity $ As of January 31, 2019 7,722 6,283 44,269 3,623 61,897 185,810 (81,493) 104,317 12,760 (5,682) 7,078 31,181 14,822 219,295 5,225 47,060 22,159 428 1,876 729 77,477 43,520 6,683 11,981 288 2,965 80,785 (11,542) 72,496 7,138 79,634 219,295 S $ 2018 6,756 5,614 43,783 3,511 59,664 185,154 (77,479) 107,675 12,703 (5,560) 7,143 18,242 11,798 204,522 5,257 46,092 22,122 645 3,738 667 78,521 30,045 6,780 8,354 295 2,648 85,107 (10,181) 77,869 2,953 80,822 204.522 (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets. Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other Equity: Commitments and contingencies Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity $ As of January 31, 2019 7,722 6,283 44,269 3,623 61,897 185,810 (81,493) 104,317 12,760 (5,682) 7,078 31,181 14,822 219,295 5,225 47,060 22,159 428 1,876 729 77,477 43,520 6,683 11,981 288 2,965 80,785 (11,542) 72,496 7,138 79,634 219,295 S $ 2018 6,756 5,614 43,783 3,511 59,664 185,154 (77,479) 107,675 12,703 (5,560) 7,143 18,242 11,798 204,522 5,257 46,092 22,122 645 3,738 667 78,521 30,045 6,780 8,354 295 2,648 85,107 (10,181) 77,869 2,953 80,822 204.522
Expert Answer:
Answer rating: 100% (QA)
It appears that you have shared financial documents of Walmart Inc and have requested a completion of Pro Forma financial statements for the next two ... View the full answer
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Olds
Posted Date:
Students also viewed these accounting questions
-
The 2009 balance sheet and income statement for the Woods Company are shown here: Woods Company: Income Statement for the Year Ending December 31, 2009 ($ thousands)...
-
A comparative balance sheet and income statement for Eaton Company follow: During 2008, the company sold some equipment for $18 that had cost $30 and on which there was accumulated depreciation of...
-
The balance sheet and income statement for the J. P. Robard Mfg. Company are as follows: BALANCE SHEET. $ 000. Cash................ $ 500 Accounts receivable........... 2,000...
-
More sophisticated computer-assisted instruction systems monitor the students performance over a period of time. The decision to begin a new topic is often based on the students success with previous...
-
A planar vector field is a function which assigns a vector R2. Explain why the set of all planar vector fields forms a vector space. VI (x, y) ) to each point U2(x, y)
-
Consider the RL circuit shown in Figure 6.25, in which \(R=35 \Omega\) and \(L=10 \mathrm{H}\). When the switch is closed at 0 seconds, the circuit is driven by a 6 V DC voltage source. Assume that...
-
Web-based exercise. Go to the Bureau of Labor Statistics Web site and find the most recent index number for the cost of college tuition. You can find this by conducting a public-data query. Go to the...
-
Carmen Company is a manufacturer that completed numerous transactions during the month, some of which are shown below: a. Raw materials used in production as direct materials, $56,000. b. Paid direct...
-
Please show in excel spreadsheet if possible. The development and construction of the project will take 3 years, and the project will operate for 3 0 years. The riskless rate is 5 % ; the rate of...
-
A fraction nonconforming control chart with n = 400 has the following parameters: UCL = 0.0962; Center line = 0.0500; LCL = 0.0038. (a) Find the width of the control limits in standard deviation...
-
9 of 60. A manager deep-dives a defect by asking several questions. What technique/tool utilizes repeated questions to help identify the true root cause of a problem? Pareto Chart O Run Chart Control...
-
Piperel Lake Resort's four employees are paid monthly. Assume an income tax rate of 20%. Required: Complete the payroll register below for the month ended January 31, 2021. (Do not round intermediate...
-
4. [Communication network 1] Consider the communication network shown in the figure below and suppose that each link can fail with probability p. Assume that failures of different links are...
-
The 60 deg strain gauge rosette is mounted on the bracket. The following readings are obtained for each gauge a = 100 106, b = 250 106, and c = 150 106. Determine: (a) the strains x, y, and xy for...
-
Assume the ledge has the dimensions shown and is attached to the building with a series of equally spaved pins around the circumference of the building. Design the pins so that the ledge can support...
-
Describe in detail about the arterial supply and venous drainage of heart with its Applied Anatomy?
-
I need help with the spreadsheets. Using the presidents new assumptions, prepare a cash budget for April, May, and June, and for the quarter in total. April $ 490,000 343,000 147,000 May $1,020,000...
-
The following information is available for Partin Company: Sales $598,000 Sales Returns and Allowances 20,000 Cost of Goods Sold 398,000 Selling Expense 69,000 Administrative Expense 25,000 Interest...
-
Rankin Industries produces two surge protectors: K2761 with six outlets and D3354 with eight outlets and two telephone line connections. Because of these product differences, the company plans to use...
-
Lehigh Manufacturing Corporation was started with the issuance of common stock for $60,000. It purchased $14,000 of raw materials and worked on three job orders during 2019 for which data follow....
-
Rockeagle Corporation began fiscal year 2018 with the following balances in its inventory accounts: Raw Materials ........................................$30,000 Work in...
-
Lyndon Company has forecast earnings of $2 million, $4 million, and $6 million, respectively, at the end of the next three years. What is the anticipated accumulated value of these earnings at the...
-
Obama Ltd has made an investment that is expected to generate a cash flow of $20,000 each year for the next five years. If Obama uses a discount rate of 5% on this investment, the present value of...
-
Bill has funded a retirement investment with $250,000 earning a return of 5.75%. What is the value of the payment that Bill can receive in perpetuity (to the nearest dollar)? a. $12,150 b. $13,250 c....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App