Reference no: EM13170831
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
|
Give proper iupac names for compound
: Provide proper IUPAC names for each compound below or draw structures corresponding to the lowest energy conformation. A. cis-1-fluoro-2-methylcyclopropane
|
|
State benzene is a trace component of gasloine
: Benzene is a trace component of gasloine. What is the mole ratio of benzene to n-octant in the vapor above a solution of 40.0% benzene and 60.0% n-octane by the mass
|
|
Non-personnel enter public buildings
: Before non-personnel enter public buildings in the State of Setonia, security officers routinely require them to walk through a metal detector. In addition, all bags, including women's purses, are subject to an external scan designed to detect the pr..
|
|
State what is the molar mass of the protein
: aqueous solution has an osmotic pressure of 6.35 torr at 23.1 C. What is the molar mass of the protein.
|
|
Create a pie chart for total assets
: Create the Balance Sheet,Income Statement and Statement of Retained Earnings for the following company in an Excelworkbook, employing three sheets.
|
|
State a mixture of table salt and ice is used to chill
: A mixture of table salt and ice is used to chill the contents of hand-operated ice-cream makers. What is the melting point of mixture of 2.00 lb of NaCl and 12.00 lbs of ice if exactly half of the ice melts?
|
|
Identify the gas
: To identify a diatomic gas x2 a research carried out the following experiment: She weighed an empty 1 L bulb, then filled it with the gas at 1.10 atm and 23.0 C and weighed it again. The difference in mass was 1.27 g. Identify the gas.
|
|
What is the number of moles of air
: At 0.0C, if the volume of air is 1.8 mL and the pressure of the atmosphere that day is 665 mmHg, what is the number of moles of air?
|
|
State what indicator wouldyou use for titration
: plot the titration point. make sure there is enough data. F. what indicator wouldyou use for this titration. what color change would you observe.
|