Excel File Edit View Insert Format Tools Data Window Help Mon Apr 11 6:48 PM o a AutoSave OFF FEE FIN 350 Exam 3 Q AARC ... Page Layout Formulas Data Home Insert Draw Review View Developer Tell me e Share Comments Calibri (Body) v 11 VA ~ A General Conditional Formatting Format as Table Cell Styles Insert v 5 Delete v Y O @ AY CG , LEN Paste B I U v A $ - % ) 49 Sensitivity Format Sort & Filter Find & Select Analyze Data A1 X fx Using the inputs below, find the required return on a firm's stock, also known as the cost of equity J K A B B D E F G H I 1 Using the inputs below, find the required return on a firm's stock, also known as the cost of equity 2 (Your answer should be with three significant digits right of decimal.) 3 RF- 2.000% 4 rm= 10.000% 5 RPM= 8.000% 6 b;= 1.780 The beta should contain the three digits in your KU email address. 7 Find the required return using the above values for the Capital Asset Pricing Model. 8 Either build a formula in Excel or type in what you find with your calculator. 9 Note: there are five tabs to complete! 10 11 12 13 14 Bond Valuation Part 1 Ch. 7 Bond Valuation Part 2 Ch.7 Cost of Equity Ch. 8 Stock Valuation Part 1 Ch.9 Stock Valuation Part 2 Ch.9 + Ready IT 1 TI 206% APR 11 P w