I need Answers

1 In the cash flow statement, cash and cash equivalents end of period 2017 is NOT equal to: Review Later Cash and cash equivalents on the 2017 balance sheet Cash and cash equivalents on the 2018 balance sheet Cash and cash equivalents beginning of period 2018 Cash and cash equivalents beginning of period 2017 + net cash provided by operating, investing and financing activities + foreign currency effect on cash and cash equivalents 2 If a company has capital leases, as a financial analyst, how would you treat it? Review Later As additional paid-in capital As debt Exclude it from the financial statement As common shares 3 Where can you find a company's stock-based compensation? Review Later On the cash flow statement - financing activities On the cash flow statement - operating activities On the income statement - non-operating expenses On the income statement - operating expenses 4 Which of the following do you NOT include when calculating the closing balance of PP&E? Review Later PP&E acquired under capital or financing leases Changes in working capital PP&E acquired through acquisitions Cash capital expenditures Calculate a company's e-Commerce market share in their country based on the following hypothetic information: First party sales Third party selling commission Third party commission charge Total country eCommerce 10 million 5 million 20% 290 million Review Later 9% 12% 5% 4% 6 Assuming the company will have the same inventory days in 2018 and 2019. What is the forecasted inventory in 2019 based on the information below? 2018 Revenue 2019 Revenue 2018 Cost of sales 2019 Cost of sales 2018 Inventory 6,500 7,600 3,800 4,100 1,500 Review Later 1,618.4 1,944.4 1,528.6 1,753.8 7 Why is accounts payable projected using an assumption based on cost of sales? Select the best answer. Review Later Accounts payable is part of working capital It is a practice mandated by financial institutions Cost of sales typically has payment terms It is an accounting rule under IFRS 8 Which of the following formula is used to calculate Free Cash Flow to Firm (FCFF)? Review Later FCFF = EBIT + Depreciation & Amortization + Net Working Capital adjustment - Cash Capex - Stock Based Compensation + Other Non-Cash Expenses FCFF = EBIT + Depreciation & Amortization + Net Working Capital adjustment + Cash Capex + Stock Based Compensation + Other Non-Cash Expenses FCFF = Net Operating Profit After Tax + Depreciation & Amortization - Tax Expense Interest Expense + Cash Capex FCFF = Net Operating Profit After Tax + Depreciation & Amortization + Net Working Capital adjustment - Cash Capex + Stock Based Compensation + Other Non-Cash Expenses 9 What is the mean 2019E EV/Revenue multiple in the Online Direct Sales comps group in 2019? Review Later 1.1x 1.2x 0.6x 0.8x 10 What is Company Co.'s enterprise value in the Service Package segment based on 2019E total revenue and 2019E mean EV/Revenue multiple? Review Later 110,275 104,184 184,314 191,032 11 What is Company Co.'s total enterprise value calculated based on 2019E revenue and 2019E mean EV/Revenue multiple? Review Later 862,632 802,836 788,531 953,141 12 What is Company Co.'s target price calculated based on 2019E revenue and 2019E mean EV/Revenue multiple? Review Later 1,511 1,266 1,363 1,242 Page 12 of 20 13 Complete Live Case section in the Scenario worksheet. There are 4 scenarios in this model: Consensus, Bull, Bear, and Other. The numbers in the live case should reflect one of the cases based on cell K14, which is dynamically linked to the scenario selected in the dropdown menu at the top of the worksheet. What formula will you use to fill cell G21 (online stores for 2018E)? Review Later =CHOOSE($B$1,G76,G130,G184,G238) =CHOOSE($K$14,G76,G130,G184,G238) =CHOOSE($K$14,G76:Q238) =CHOOSE($B$1,G76:Q238) 14 Link the live case with the Historical Analysis section in the Financial Model worksheet and complete the Valuation section. In the consensus case, what is the EBITDA excluding stockbased compensation (SBC) in 2024? Review Later 162,565 143,079 126,043 112,115 15 In the bull case, what is the free cash flow to the firm (FCFF) if all cash CAPEX in 2027? Review Later 98,662 148,361 114,662 125,384 16 In the consensus case, what is the exit multiple terminal value on Dec 31, 2028? Review Later 2,151,659 1,853,611 2,232,891 1,605,714 Download the file Advanced Modeling - DCF Analysis, complete the Valuation section in the Financial Model worksheet, and answer question 16 - 20. 17 In the consensus case, what is Amazon's enterprise value on the valuation date using the exit multiple terminal value? Review Later 1,378,837 1,029,071 2,088,584 1,414,325 DCF Analysis Download the file Advanced Modeling - DCF Analysis, complete the Valuation section in the Financial Model worksheet, and answer question 16 - 20. 18 What is the expected AMZN value per share in 2028 in the bear case using the exit multiple terminal valuation method? Review Later 3,570 5,038 7,721 4,892 Page 18 of 20 Calculate AMZN's target share price using the consensus case assumptions and exit multiple terminal value, then perform a sensitivity analysis. What will the share price be if the exit multiple is 16.0x and the discount rate is 10.5%? Review Later 2,686 2,717 2,502 2,473 20 What will the internal rate of return (IRR) be if the exit multiple is 10.0x and the purchase price per share is $1,700 in the bull case (given that the terminal value is calculated using the exit multiple method)? Review Later 13.1% 13.5% 15.4% 13.8%