Assignment 3: Excel Problems
At 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 Wednesday, November 9, 2016 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.||
|P10 A 9B:|
|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.||