FIN 201 EXCEL TEMPL Insert Page Layout Formulas Data Review View Conditional Formatting. Format as Table . Arial Blu Number Cell Styles Office Update To keep up-to-date with security updates, foxes, and improvements, choose Cheak for Updates A. Financial Markets and Institutions Chapter 8 Problem 8:Using a Spreadsheet to Calculate Stock Returns (LG8-5) At the beginning of the year, you purchased a share of stock for $50. Over the year the dividends paid on the stock were $4.50 per share. Calculate the retum on a stock if the price of the stock at the end of the year is $45, $48, $55 and $60. Chapter 8 Problem 8: Using a Spreadsheet to Calculate Stock Retuns (LG 8-5) Student Name: Course Name: Student ID Course Number: Select the red highlighted items below for tips and suggestions to complete this problem. Price at Price at end of year $45.00 $48.00 $55.00 $60.00 beginning of year Stock Return Dividends $50.00 $50.00 $50.00 $50.00 4.50 4.50 4.50 4.50 Fer help with enterins Menu Instructions Help Topics problem 1 problem 2+ Ready