Reference no: EM13850488
Mastery Problem 1
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.
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
|
Human resource departments in the public sector
: Analyze the topics discussed in Chapter 1, with the exception of the laws. Select two topics and discuss two positive effects and two challenges the topic poses for human resource departments in the public sector
|
|
What is the annual growth rate of the dividends
: What is the companys cost of capital ko? Provide your answer as a percentage to two decimal places - What is the annual growth rate of the dividends?
|
|
Provide an example of company that has faced ethical problem
: Are there any ethical problems in utilizing Cash flow statement? Please bring an example of the company that has faced ethical problems in using Cash flow statement.
|
|
How can marketing manager know whether demand for a product
: how can the marketing manager know whether demand for a product is elastic or inelastic?
|
|
Income statement and statement of retained earnings
: 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 presenta..
|
|
What is the companys net working capital
: Laurel Electronics reported the following information at its annual meeting: The Company had cash and marketable securities worth $1,235,455, accounts payables worth $4,159,357, inventory of $7,118,000, accounts receivables of $3,453,700, short-term ..
|
|
How much long-term debt does blackwell automotive have
: Tim Dye, the CFO of Blackwell Automotive, Inc., is putting together this year's financial statements. He has gathered the following balance sheet information: The firm had a cash balance of $23,015, accounts payable of $163,257, common stock of $313,..
|
|
Estimate the company wacc
: What do you estimate the company's WACC? Be sure to do all calculations for 3 years, using Excel. Use real numbers from the financials, not reported ratios provided by online and other sources. Show the source of the numbers.
|
|
Calculate the return on the bond
: The price of a bond with 4% annual coupon and $100 face value in year T is $90. Is the yield to maturity greater than, the same, or less than to the annual coupon rate? Explain in one sentence. Calculate the current yield in period T. Calculate the r..
|