Assume the following information (numbers in millions). Note: You can copy this table directly into Excel. Data Item 2022 2023 EBIT ($) 13831 8891 Interest Expense ($) 113 -1082 Operating Assets ($) 34985 36920 Operating Liabilities 25,365 25703 ($) Net Fixed Assets ($) 41421 57002 Debt ($) 6942 10548 Tax Rate (%) 8.3% -50.1% What is free cash flow to equity in 2023? IMPORTANT! It will be very easy to goof up this problem given the negative interest expense and negative tax rate. Remember, if you subtract a negative this turns it into a positive. Hint: It will be so amazingly useful to remember the FCFE extra credit problem. To help, please note that the answer ranges between 1.300 and 2,100.

Assume the following information (numbers in millions). Note: You can copy this table directly into Excel. Data Item 2022 2023 EBIT ($) 13831 8891 Interest Expense ($) 113 -1082 Operating Assets ($) 34985 36920 Operating Liabilities 25,365 25703 ($) Net Fixed Assets ($) 41421 57002 Debt ($) 6942 10548 Tax Rate (%) 8.3% -50.1% What is free cash flow to equity in 2023? IMPORTANT! It will be very easy to goof up this problem given the negative interest expense and negative tax rate. Remember, if you subtract a negative this turns it into a positive. Hint: It will be so amazingly useful to remember the FCFE extra credit problem. To help, please note that the answer ranges between 1.300 and 2,100.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...

See similar textbooks

Similar questions

The following items were excerpted from Poeltl, Inc.'s balance sheets: December 31, 2023December 31, 2022Cash$86,300$59,000Accounts receivable65,60070,600Inventory157,000150.300Property and equipment794,500745,400Accumulated depreciation(184,000)(168,200)Accounts payable61,00050,600Wages payable20,40023,000 Poeltl's 2023 income statement showed net income of $463,000, depreciation expense of $57,000, and a gain on disposal of equipment of $16,000. On Poeltl's 2023 statement of cash flows, how much is Net Cash Provided by Operating Activities?
On August 1, 2020, the business accounts of Peter and Senen appear below:Assets Peter SenenCash P11,000 P22,354Accounts receivable 84,536 217,890Inventories 100,035 240,102Land 603,000 428,267Buildings 200,345 384,789Other Assets 22,000 23,600Total P1,020,916 P1,317,002Liabilities and CapitalAccounts payable P178,940 P243,650Notes payable 200,000 345,000Peter, Capital 641,976Senen, Capital 728,352Total P1,020,916 P1,317,002Peter and Senen agreed to form a partnership contributing their respective assets and liabilitiessubject to the following adjustments:Accounts receivable of P20,000 and P35,000 are uncollectible in Peter and Senen’s respectivebooks.Inventories of P5,500 and P6,700 are worthless in Peter and Senen’s respective booksOther Assets of P2,200 and P3,600 in Peter and Senen’s books are written off.After five days Ethel was offered to join Peter and Senen and will contribute for a 20% interestin the firm. They also agreed to divide profits and losses in the ratio of 4:4:2…
Use the table for the questions below. Consider the following balance sheets: PharmPic DosageDoc Reported Dec. 31, 2020 2021 2020 2021 Assets Cash 224,224 200,400 301,540 230,876 Accounts Receivable 129,000 118,125 130,316 110,345 Inventories 154,890 171,147 184,717 186,000 Total Current Assets 508,114 489,672 616,573 527,221 Net Property Plant & Equipt. 421,162 431,795 456,462 460,000 Patents and Trademarks 212,770 210,110 201,348 199,990 Total Assets 1,142,046 1,131,577 1,274,383 1,187,211 Liabilities and Stockholders' Equity: Short Term Borrowings (Bank) 257,000 264,023 302,453 270,000 Accounts Payable 212,900 209,000 267,004 225,000 Current Portion of LTD (Interest Bearing Debt) 39,532 29,081 32,611 46,048 Total Current Liabilities 509,432 502,104 602,068…
The accounting records of Nettle Distribution show the following assets and liabilities as of December 31,2018 and 2019.December 31 2018 2019Cash . . . . . . . . . . . . . . . . . . . . . . . . $ 64,300 $ 15,640Accounts receivable . . . . . . . . . . . 26,240 19,100Office supplies . . . . . . . . . . . . . . . . 3,160 1,960Office equipment . . . . . . . . . . . . . . 44,000 44,000Trucks . . . . . . . . . . . . . . . . . . . . . . . 148,000 157,000December 31 2018 2019Building . . . . . . . . . . . . . . . . . . . . . $ 0 $80,000Land . . . . . . . . . . . . . . . . . . . . . . . . 0 60,000Accounts payable . . . . . . . . . . . . . 3,500 33,500Note payable . . . . . . . . . . . . . . . . . 0 40,000Required1. Prepare balance sheets for the business as of December 31, 2018 and 2019. Hint: Report only total equityon the balance sheet and remember that total equity equals the difference between assets and liabilities.2. Compute net income for 2019 by comparing total equity amounts for these…
Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280; forecasted net income (cell D95), $40,200; total assets (cell D105), $507,600.
They have provided you with the following financial information: Q&A Aviation Balance Sheet (000s) Assets 20X1 20X2 Liabilities and Equity 20X1 20X2 Cash 1067 440 Accounts Payable 654 889 Accounts Receivable 823 708 Notes Payable 2300 2030 Inventory 1296 1038 Accruals 267 275 Total Current Assets 3186 2186 Total Current Liabilities 3221 3194 Plant, Property and Eq. 21663 23804 Long Term Debt 6477 5044 Accumulated Dep’n (6314) (7682) Fixed Assets (Net) 15349 16122 Common Stock 350 350 Retained Earnings 8487 9720 Total Equity 8837 10070 Total Assets 18535 18308 Total Liabilities and Equity 18535 18308 Q&A Aviation Income Statement (000s) 20X1 20X2 Sales 28934 30499 Cost of Goods Sold 19978 22225 Gross Profit 8956 8274 Expenses 3612…
I was given only this document for an assignment: What is the Fiscal Year End Date?Amazon: December 31st, 2019Walmart: January 31st, 2020Financial Statements data:Amazon:Net Sales: $280,522,000,000Basic net income per common share: $23.46Total current assets: $96,334,000,000Retained earnings: $31,220,000,000Net cash provided by operating activities: $38,514,000,000Inventory LIFOWalmart:Net Sales: $519,926,000,000Basic net income per common share: $5.22Total current assets: $61,806,000,000Retained earnings: $83,943,000,000Net cash provided by operating activities: $25,255,000,000Inventory: FIFO ANSWER THE FOLLOWING QUESTIONS:What are 3 differences between accounting policies from each company and why do you think they are different? I'm not sure exactly what the 3 differences are. I believe (1) is the fiscal year versus the calendar year ending maybe due to Walmart having more seasonal sales like Christmas, and (2) is the FIFO vs LIFO method - but I'm not sure why they would choose…
In cell D22, by using cell references, calculate the total long-term assets for year 2014 Use the relevant cells from the given data in the balance sheet. In call D23, by using a cell reference, calculate the total assets for year 2014. Refer to the relevant cell from the given data in the balance sheet. Note: The total assets must equal the total liabilities and owners' equity." in cell D18, by using cell references, calculate the total current assets for year 2014. Use the relevant cells in the balance sheet. In cell D16, by using cell references, calculate the accounts receivable for year 2014. Use the relevant cells in the balance sheet, in cell H14, by using cell references, calculate the accounts payable for year 2014. Use the relevant cells from the given cata in the balance sheet. In cell H22, by using cell references, calculate the total owners' equity for year 2014. Use the relevant cells from the given data in the balance sheet. In cell H18, by using cell references,…
On May 1, 20x1, the statement of financial position of Juan and Pablo appear below:Juan PabloCash 22,000 44,708Accounts receivable 469,072 1,135,780Inventories 240,070 520,204Land 1,206,000Building 856,534Furniture and fixtures 100,690 69,578Other assets 4,000 7,200Total assets 2,041,832 2,634,004Accounts payable 357,880 487,300Notes payable 400,000 690,000Juan, Capital 1,283,952Pablo, Capital 1,456,704Total liabilities and equity 2,041,832 2,634,004Juan and Pablo agreed to form a partnership contributing their respective assets and equities subject to thefollowing adjustments:a. Accounts receivable of P40,000 in Juan’s books and P70,000 in Pablo’s books are uncollectible.b. Inventories of P11,000 and P13,400 are worthless in Juan’s and Pablo’s respective books.c. Other assets of P4,000 and P7,200 in Juan’s and Pablo’s respective books are to be written off. 3. Prepare journal entry to record Pedro’s admission. 4. During the first year of operations, the partnership earned P650,000.…
On May 1, 20x1, the statement of financial position of Juan and Pablo appear below:Juan PabloCash 22,000 44,708Accounts receivable 469,072 1,135,780Inventories 240,070 520,204Land 1,206,000Building 856,534Furniture and fixtures 100,690 69,578Other assets 4,000 7,200Total assets 2,041,832 2,634,004Accounts payable 357,880 487,300Notes payable 400,000 690,000Juan, Capital 1,283,952Pablo, Capital 1,456,704Total liabilities and equity 2,041,832 2,634,004Juan and Pablo agreed to form a partnership contributing their respective assets and equities subject to thefollowing adjustments:a. Accounts receivable of P40,000 in Juan’s books and P70,000 in Pablo’s books are uncollectible.b. Inventories of P11,000 and P13,400 are worthless in Juan’s and Pablo’s respective books.c. Other assets of P4,000 and P7,200 in Juan’s and Pablo’s respective books are to be written off.Required:1. What are the adjusted capital balances of the partners after formation? 2. Pedro offered to join for a 20% interest in…
Comparative balance sheets for 2024 and 2023, a statement of income for 2024, and additional information from the accounting records of Red, Incorporated, are provided below: RED, INCORPORATED Comparative Balance Sheets December 31, 2024 and 2023 ($ in millions) 2024 2023 Assets Cash $ 29 $ 114 Accounts receivable 188 137 Prepaid insurance 14 6 Inventory 252 180 Buildings and equipment 453 355 Less: Accumulated depreciation (124) (245) $ 812 $ 547 Liabilities Accounts payable $ 95 $ 110 Accrued liabilities 13 20 Notes payable 25 0 Bonds payable 162 0 Shareholders’ Equity Common stock 405 405 Retained earnings 112 12 $ 812 $ 547 RED, INCORPORATED Statement of Income For Year Ended December 31, 2024 ($ in millions) Revenues Sales revenue $ 2,030 Expenses Cost of goods sold $ 1,430 Depreciation expense 41 Operating expenses 434 1,905 Net income $ 125 Additional information from the…
you need to use the 10-k form of the Apple inc. in order to be able to answer the question link to form:https://www.sec.gov/ix?doc=/Archives/edgar/data/320193/000032019320000096/aapl-20200926.htm#ief781ab58e4f4fcaa872ddbd30da40e1_163 Question: On which financial statement do you find current liabilities? List the page number from the most recent Form 10-K where you found current liabilities for your company. List each of the specific current liabilities the company has. Locate information about the company's contingent liabilities in the notes to the financial statements. (Hint: Do a keyword search for “contingencies”). List the page number where you find the note about contingencies. Summarize each of the company's contingent liabilities disclosed in the notes.