Explore BrainMass
Share

Explore BrainMass

    Amounts of the Assets and Liabilities of Dolan Banking Co.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    See the attachment.
    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.
    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.
    Company Data:
    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):
    Total revenue
    ........................ $ 37.8 Investment assets..................... $169.6
    Receivables........................... 0.9 Property and equipment, net .. 1.9
    Current liabilities
    .................. 151.1 Other expenses....................... 6.9
    Common stock...................... 14.0 Retained earnings, beginning 8.6
    Interest expense............... 0.8 Retained earnings, ending ..... ?
    Salary and other
    employee expenses.......... 17.7 Cash.......................................... 2.1
    Long-term
    liabilities........... 2.8 Other assets............................. 14.4.

    © BrainMass Inc. brainmass.com October 10, 2019, 4:19 am ad1c9bdddf
    https://brainmass.com/economics/banking/amounts-assets-and-liabilities-dolan-banking-455533

    Attachments

    Solution Summary

    The solution discusses questions regarding the amounts of the assets and liabilities of Dolan Banking Co.

    $2.19