Create the balance sheetincome statement and statement of

Reference no: EM13376821

Create the Balance Sheet,Income Statement and Statement of Retained Earnings for the following company in an Excelworkbook, employing three sheets. Use the prescribed GAAP presentation for the financial statements. When possible reference/link data across sheets to make the spreadsheet as dynamicas possible.

Demonstrate your ability to apply Excel formatting functions to cells and to theoverall 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 theOutliner feature as appropriate.1) Prepare the company's balance sheet at January 31, 2010.

Use an appropriate formula tocompute ending retained earnings.

2) From the balance sheet, create a pie chart for Total Assets. Employ best practices inpresenting 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 theyear.

Company Data:Amounts of the assets and liabilities of DolanBanking Company, as of January 31,2010, are given as follows. Also included are revenue and expense figures for the yearended 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.6Interest expense............... 0.8

Retained earnings, ending ..... ?

Salary and otheremployee expenses.......... 17.7

Cash.......................................... 2.1

Long-termliabilities........... 2.8

Other assets............................. 14.4

Reference no: EM13376821

Questions Cloud

Your cfo in her initial work needs to decide whether to set : your cfo in her initial work needs to decide whether to set up a job order costing system or a process type costing

1 what is a highly compensated employee2 what effect does a : 1. what is a highly compensated employee?2. what effect does a highly compensated employee have on the minimum vesting

1how are general long-term liabilities distinguished from : 1.how are general long-term liabilities distinguished from other long-term liabilities of the government? how does the

Question 1please answer the followingsa what is the maximum : question 1please answer the followingsa. what is the maximum price that you are willing to pay for a machine if it is

Create the balance sheetincome statement and statement of : create the balance sheetincome statement and statement of retained earnings for the following company in an

Beginning raw materials 43raw materials purchases 29raw : beginning raw materials 43raw materials purchases 29raw materials stolen 17. assume that the cost of raw materials

Submit your responses to the following questions in a 1-2 : submit your responses to the following questions in a 1-2 page summary msword document. label each question clearly.

How does the firm use cost-volume-profit analysis to assess : how does the firm use cost-volume-profit analysis to assess performance? how would you use such a system to measure how

Your final portfolio for the class will be to create a : your final portfolio for the class will be to create a marketing plan for the company of your choice. you will need to

User Account

All Pages