Accounting/Excel

E.' Formatting: 1. Format the statement using standard accounting conventions and make it look nice. 2. Center the titles with the Center Across Selection.

a. Think: Would Merge and Center work better for this operation? b. Think Is Merge and Center the same as Center Across Selection?

3. Use the Decrease Decimal button, ofl one row at a time, and decrease decimals to none on each row.

VII. Perform an analysis to determine what the maximum dividend rate is that would achieve a retained earnings amount equal to no less than $1"500 at the end of 1998. Refine your answer only to the nearest whole percent. Perform this step using "trial-and-e1Tor". Do not use Goal Seek or Solver or any other Excel capability. A. Think could you devise an easier way to perform this analysis? B. Note: you must do your analysis on the Retained Earnings model you built in the above

step and not some other made up model. You may not add any extra information to your

workbook. Also, do not go back and re-set your numbers to reflect the initial data in the above step.

VItr. Print out the workbook. D( Print out the formulas for the retained earnings statement. X. Save this workbook as HWI.XLSM and use it to begin assignment #2.

eeee Ge Gee e F e

L_I

68 HOMEWORK