Assignment 3: Excel ProblemsAt the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook. Complete problems P9-28A (p. 517), P10-A-9B (p. 586), and P11-29A (p. 631) in your textbook. Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes. By Week 4, Day 7 deliver your assignment to the M4: Assignment 3 Dropbox.Create the file with the following name: LastnameFirstInitial_M4A3.Excel.xls. Assignment 3 Grading Criteria
Preparation of depreciation schedule for each depreciation method showing asset, depreciation expense, accumulate depreciation and asset book value.
Present value of Plan A
Present value of Plan B
Plan selected based on least cost
Assess the total market value of the common stock.
Compute the book value per share of the common stock.
Accuracy and timeliness.