Finance Chapter 10 Assignment

FIN 201 Fundamentals of Financial Management Excel Spreadsheet Problem #4 - Chapter 10 Background The spreadsheet problems in FIN 201 are designed to help you develop your Excel expertise. Key learning outcomes for this problem are: Instructions This exercise is based on the data in Problem 10-21 (pag 363 of the text). Question a: Cost of Debt (Page 341);Ccost of Preferred Stock (Page 342); Cost of Common Stock from Retained Earning (Page 343-344); Cost of new Common Stock (page 349) Question b: Cost of Common Stock from CAPM approach (Page 344) Question d: Make sure to get the market value weights instead of the book value weights (can be referred to page 338) Grading Academic Integrity Start with the accompanying spreadsheet and work individually to complete this assignment. Copying any part of your spreadsheet from another student, or allowing any part of your spreadsheet to be copied by another student, will result in an academic integrity violation. · Constructing appropriate Excel formulas

FIN 201 Fundamentals of Financial ManagementExcel Spreadsheet Problem #4 - Chapter 10BackgroundThe spreadsheet problems in FIN 201 are designed to help you develop yoInstructionsThis exercise is based on the data in Problem 10-21 (pag 366-367 of the teQuestion a:Cost of Debt (Page 345);Cost of Preferred Stock (Page 346);Question b: Cost of Common Stock from CAPM approach (Page 348) Question d: Make sure to get the market value weights instead of the GradingAcademic IntegrityStart with the accompanying spreadsheet and work individually to compleCopying any part of your spreadsheet from another stu· Constructing appropriate Excel formulas· Understanding and appropriately applying functions to solve probleo 34Points - Appropriate formulas (including cell references) or functiono 33 Points - cell addresses used within calculationso 33 Points - properly formatting of answers to an appropriate number of d

0 thoughts on “Finance Chapter 10 Assignment

Leave a Reply

Your email address will not be published. Required fields are marked *