Hello there,

I need help on homework, Balance sheet.

Please see attached for direction.

Thanks,

FIN 615 - Mastery Problem 1 op C This assignment draws on your understanding of Chapters 1 and 2. Create the Balance Sheet, Income Statement and Statement of Retained Earnings for the following company in an Excel workbook, employing three sheets. Use the prescribed GAAP presentation for the financial statements. When possible reference/link data across sheets to make the spreadsheet as dynamic as possible. Demonstrate your ability to apply Excel formatting functions to cells and to the overall report, consistent with the GSMT Expectations for Excel posted under Course Content. Use formulas to perform the calculations (ie SUM, AVG, GEOMEAN, etc) and apply the Outliner feature as appropriate. Company Data: ht ig yr 1) Prepare the company's balance sheet at January 31, 2010. Use an appropriate formula to compute ending retained earnings. 2) From the balance sheet, create a pie chart for Total Assets. Employ best practices in presenting charts. 3) Prepare the company's income statement for the year ended January 31, 2010. 4) Prepare a statement of retained earnings and calculate the company's dividend for the year. Total revenue ........................ Receivables........................... Current liabilities .................. M U Amounts of the assets and liabilities of Dolan Banking Company, as of January 31, 2010, are given as follows. Also included are revenue and expense figures for the year ended on that date (amounts in millions): Investment assets..................... Property and equipment, net .. 151.1 Other expenses....................... Common stock...................... 14.0 Retained earnings, beginning Interest expense............... Salary and other employee expenses.......... Long-term liabilities........... 0.8 Retained earnings, ending ..... $169.6 1.9 U $ 37.8 0.9 6.9 C 8.6 ? 17.7 Cash.......................................... 2.1 2.8 Other assets............................. 14.4