Which of the following is not a formula in Excel?

		Sumproduct
		Sumifs
		Sumproductif
		Sumif

What is the dividend payout ratio?

		EPS/Dividends
		ROE/Dividends
		Dividends/EPS
		Dividends/ROE

Copy of Assume the following cash flows: Year Project A o $150,000 1 8,000 2 30,000 3 45,000 4 55,000 5 85,000 Project B $150,000 80,000 40,000 35,000 25,000 20,000 What is the payback period of Project B assuming WACC is 10%? 2.9 years 4.1 years 5.5 years O 3.5 years What is the correct formula for B8 to find the cost of new common equity using the constant growth dividend discount model? B 1 Next Dividend (D) 2.25 2 Dividend Growth Rate 4.00% 3 Stock Price $35.00 4 Flotation Cost 6.00% 5 Beta 1.15 6 Risk-free Rate 2.50% 7 Expected Market Return 9.00% 8 Cost of New Common Equity ? =B3/B1+B2 =B5+B4*(B6-B5)*(1-B4) =B1/(B3*(1-B4))+B2 =B5+B4*B6 =B1/B3+B2 Use the following table to answer the question. A 1 10 220 3 30 4 40 5 50 B 5.5 12 7.5 4 10 Assume the following formula exists: EAVERAGEIF(A1:A5,">="&30,31:35). What will display once the formula is evaluated? 7.2 7.8 30 0 40 QUESTION 50 Use the following table to answer the question. A B 1 10 5.5 220 12 3 30 7.5 4 40 4 550 10 Assume the following formula exists: =max(B1,B2), what will display once the formula is evaluated? 10 50 150 O 12