Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how to calculate NPV and what information is used to do so? Net Present Value (NPV) Calculator Building begin{tabular}{|l|l|} hline Initial Investment & hline
how to calculate NPV and what information is used to do so?
Net Present Value (NPV) Calculator Building \begin{tabular}{|l|l|} \hline Initial Investment & \\ \hline Annual Cash Inflows & \\ \hline Discount Rate & \\ \hline Number of Years & \\ \hline Salvage Value & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Year & 1 & 2 & 3 & 4 & 5 & 6 & 7 & \multicolumn{1}{l|}{8} & \multicolumn{1}{l|}{9} & 10 \\ \hline Cash Flows & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Year & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 & 19 & 20 \\ \hline Cash Flows & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Equipment \begin{tabular}{|l|l|} \hline Initial Investment & \\ \hline Annual Cash Inflows & \\ \hline Discount Rate & \\ \hline Number of Years & \\ \hline Salvage Value & \\ \hline \end{tabular} NPV= \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Year & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 \\ \hline Cash Flows & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Year & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 & 19 & 20 \\ \hline Cash Flows & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Bonds \begin{tabular}{|l|l|l|} \hline Initial Investment & \\ \hline Annual Cash Inflows & \\ \hline Discount Rate & \\ \hline Number of Years & & \\ \hline Principal Returned & & \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r|r|r|r|r|r|r|} \hline Year & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 \\ \hline Cash Flows & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} 8 Income Statement Exchange rate used is that of the Year End reported date As Reported Quarterly Income Statement Report Date Currency Audit Status Consolidated Services revenues Products revenues Total revenues Cost of services (exclusive of depreciation \& amortization) Cost of products (exclusive of depreciation \& amortization) Selling, general, administrative \& other expenses Depreciation \& amortization Total costs \& expenses Restructuring \& impairment charges Restructuring \& impairment charges DraftKings, Inc. gain (loss) German free-to-air (FTA) television network gain (loss) Other income (expense) Other income (expense), net Other income Interest expense Interest \& investment income Net periodic pension \& postretirement benefit costs (other than 07/01/2023 07/02/2022 3rd Quarter USD Unaudited Yes 20008000000 2322000000 3rd Quarter USD Unaudited Yes 19461000000 2043000000 21504000000 12404000000 1278000000 4100000000 1290000000 19072000000 Interest income, investment income \& other interest income (e Interest income (expense), net Equity in the income (loss) of investees Income from continuing operations before income taxes Income taxes from continuing operations Net income (loss) from continuing operations Income (loss) from discontinued operations, net Net income (loss) Net income (loss) from continuing operations attributable to no Less: net income from continuing operations attributable to non Less: net income from discontinued operations attributable ton Net income (loss) attributable to The Walt Disnev Combanv ( Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Earnings (loss) per share - continuing operations - basic Earnings (loss) per share - discontinued operations - basic Net earnings (loss) per share - basic Earnings (loss) per share - continuing operations - diluted Earnings (loss) per share - discontinued operations - diluted Net earnings (loss) per share - diluted 2650000000 90000000 101000000 11000000 503000000 111000000 87000000 305000000 191000000 134000000 19000000 153000000 153000000 307000000 460000000 1829000000 1829000000 1781000000 0.25 0.25 0.25 0.25 42000000 -136000000 136000000 136000000 380000000 7000000 13000000 360000000 225000000 2119000000 617000000 1502000000 1502000000 93000000 1409000000 1823000000 1825000000 1781000000 0.77 0.77 0.77 0.77 0.77 Cash Flows Exchange rate used is that of the Year End reported date As Reported Quarterly Cash Flow Report Date Currency Audit Status Consolidated Net income (loss) Net income (loss) from continuing operations Depreciation \& amortization Impairment of produced \& licensed content costs 07/01/2023 07/02/2022 3rd Quarter USD USD Net loss (gain) on investments Goodwill \& intangible asset impairment Net loss (gain) on acquisitions \& investments Loss (gain) on acquisition 8 Net loss (gain) on investments \& disposition of businesses Deferred income taxes Equity in the loss (income) of investees Cash distributions received from equity investees Net change in produced \& licensed content costs \& advances Net change in operating lease right of use assets / liabilities Equity-based compensation Pension \& postretirement medical benefit cost amortization Other adjustments, net Receivables Inventories Other assets Accounts payable \& other accrued liabilities Accounts payable \& other liabilities Income taxes 3 Net cash flows from operations - continuing operations Net cash flows from operating activities 5 Investments in parks, resorts \& other property Acquisitions 7 Proceeds from sales of investments Other investing activities, net Net cash flows from imvesting activities - continuing operations Net cash flows from investing activities Commercial paper borrowings (payments), net Borrowings Reduction of borrowings Contributions from or sale of noncontrolling interest Sale of noncontrolling interest Acquisition of redeemable noncontrolling interest Dividends 8 Proceeds from exercise of stock options Acquisition of noncontrolling \& redeemable noncontrolling inter Contributions from or sales of noncontrolling interests Other financing activities, net 2 Net cash flows from financing activities - continuing operations 3 Net cash flows from financing activities 4 Net cash flows from operating activities - discontinued operatic 5 Net cash flows from investing activities - discontinued operatic 6 Net cash flows from financing activities - discontinued operatic Cash flows from operations - discontinued operations 8 Impact of exchange rates on cash, cash equivalents \& restricte 9 Change in cash, cash equivalents \& restricted cash Cash, cash equivalents & restricted cash, beginning of period 184000000 Yes Unaudited Yes 3299000000 3846000000 3846000000 779000000 899000000 555000000 531000000 1861000000 861000000 3000000 166000000 744000000 120000000 64000000 1609000000 949000000 5064000000 3595000000 605000000 674000000 575000000 .4306000000 723000000 465000000 492000000 506000000 259000000 684000000 892000000 15000000 3478000000 3478000000 3795000000 458000000 122000000 77000000 3872000000 3872000000 275000000 152000000 1400000000 719000000 .900000000 1 Cash, cash equivalents \& restricted cash, end of period 3259000000 40000000 70000000 140000000 100000000 737000000 824000000 2247000000 2247000000 8000000 12000000 4000000 354000000 2999000000 16003000000 13004000000 Balance Sheet Exchange rate used is that of the Year End reported date As Reported Quarterly Balance Sheet Report Date Currency Audit Status Consolidated Cash \& cash equivalents Receivables, net Inventories Content advances Licensed content costs & advances Other current assets Assets held for sale Total current assets Produced \& licensed content costs 2 Investments 3 Parks, resorts \& other property - attractions, buildinas \& equipr Parks, resorts \& other property - accumulated depreciation - a Parks, resorts \& other property before projects in progress \& li Parks, resorts \& other property - projects in progress Parks, resorts \& other property - land Parks, resorts \& other property, net Intangible assets, net Goodwill Noncurrent assets held for sale Other assets Total assets Accounts payable \& other accrued liabilities Current portion of borrowings Deferred revenue & other current liabilities Liabilities held for sale Total current liabilities Commercial paper borrowings U.S. \& European medium-term notes U.S. dollar denominated notes Asia International Theme Parks borrowings Asia Theme Parks borrowings Foreign currency denominated debt \& other borrowings Total borrowings before current portion Less: current portion of borrowings Borrowings Deferred income taxes Noncurrent liabilities held for sale Other long-term liabilities Redeemable noncontrolling interests Common stock Retained earnings (accumulated deficit) Market value adjustments for investments Market value adjustments for hedges Market value adjustments 7 Unrecognized pension \& postretirement medical expense Foreign currency translation \& other accumulated comprehens Accumulated other comprehensive income (loss) Shareholders' equity sub-total Treasury stock, at cost Total Disney (Wait) Co. shareholders' equity Noncontrolling interests Total equity 07/01/2023 3rd Quarter USD Unaudited Yes 11458000000 13112000000 1900000000 2369000000 1335000000 30174000000 34607000000 3062000000 69819000000 42112000000 27707000000 5689000000 1181000000 34577000000 13478000000 77881000000 10004000000 203783000000.00 19115000000 2645000000 6474000000 28234000000 44544000000 7304000000 12759000000 8886000000 $ 57,136,000,000.00 45794000000 11000000 2811000000 1613000000 4413000000 907,000,000.00 97,610,000,000.00 4446000000 $ 102,056,000,000.00 07/02/2022 3rd Quarter USD Unaudited Yes 12959000000 13685000000 1590000000 1902000000 1286000000 31422000000 34077000000 3236000000 65599000000 39089000000 26510000000 5956000000 1117000000 33583000000 15334000000 77945000000 8477000000 204074000000.00 20858000000 5580000000 4266000000 30704000000 30704000000 \begin{tabular}{r} . \\ 46022000000 \\ 8034000000 \\ \hline- \\ 13456000000 \\ 9425000000 \\ 56087000000 \\ 43462000000 \end{tabular} 396000000 4979000000 1559000000 6142000000 907000000 92500000000 3933000000 3933000000 96433000000 18Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started