Please see the attachment and I need excel format.
1. Arrange the following items in proper balance sheet presentation. Accumulated depreciation $200,000 Retained earnings 110,000 Cash 5,000 Bonds payable 142,000 Accounts receivable 38,000 Plant and equipment?original cost 720,000 Accounts payable 35,000 Allowance for bad debts 6,000 Common stock $1 par, 150,0
Please see the attachment. 2. Evaluate the asset, debt, and equity structure of Lucent Technologies, as well as trends and changes found on the common-size balance sheet. 3. What concerns would investors and creditors have based on only this information? 4. What additional financial and non-financial information would
Exercise 4.1 Table 4.9 is a list of the transactions for the Portland after School Program for the second six months of operations. Prepare the journal entries for each transaction including an identification of the t-accounts that will be debited and credit for each transaction. TABLE 4.9 Journal of the Portland After Schoo
If on the balance sheet, it showed that cash increase $400,000 from the end of last year to the end of this year. How would you interpret that? Now looking at the statement of cash flows, it showed that cash from operations was a ($200,000) and cash from financing was a $600,000. How would you interpret that now?
Please show work to all answers. Please view attachment for full problem. Answer: (a) find all missing numbers among which M = 690; (b) operating accruals = 266; (c) 234; (d) $865. E7.5 Using Accounting Relations Below are financial statements that have been reformulated. Some items are missing; they are indicated b
See attached annual reports containing financial statements for the year 2007 pertaining to: Home Depot(http://www.homedepotar.com/html/pdf/HDAR_2007_10k.pd) a. The Balance Sheet b. The Income Statement c. The Statement of Cash Flows Based on the general organization of Home Depot, I need an opinion on which of the ab
Please see the attached file. 12. The following balance sheet information was provided by Oleg Company: Assuming net credit sales totaled $120,000, what was the company's average days to collect receivables? 18.3 days 21.5 days 60 days 52.1 days 14. The following partial balance she
How is the Statement of Cash Flows interrelated with the income statement and balance sheet? If you were a credit analyst, which financial ratios would be important to your decision making? Why?
Read Scenario One (USAuto). Then review Steps 1, 2, and 3 of the Supplement entitled Sample Problem Solution Worksheet. Which of the USAuto/AutoMex problem statements listed in the supplement resonated best with you? Might you want to modify it? If so, how?
A. E4-1 - Complete the worksheet: The adjusted trial balance columns of the worksheet for Cajun Company are as follows: Cajun Company Worksheet (partial) For the month ended April 30, 2006 Adjusted trial Income Balance
Details: Benjamin O'Henry has owned and operated O'Henry's Data Services since its beginning ten years ago. From all appearances, the business has prospered. In the past few years, you have become friends with O'Henry and his wife. Recently, O'Henry mentioned that he has lost his zest for the business and would consider selling
1.With its shares trading at $75.25 on December 31, 2007, the market capitalization of Mikrotek's common equity was $135.45 billion. Mikrotek listed $25 billion of debt on its most recent balance sheet, and sales for year 2007 were $81 billion. A. How many common shares were outstanding? B. What value was the market placing on Mikrotek's enterprise value? C. Mikrotek listed 150 million shares in treasury stock on its balance sheet. As such, how many shares in total did Mikrotek issue there? D. As of today, January 2, 2008, an analyst forecasts that Mikrotek's stock dividends per share will be $2.09 in 2008, $2.25 in 2009, and expects dividends to grow at a rate of 7% per year indefinitely after that. Investors require a return of at least 10% for Mikrotek's stock. Please value this stock and recommend a "buy" or "sell" decision.
1.With its shares trading at $75.25 on December 31, 2007, the market capitalization of Mikrotek's common equity was $135.45 billion. Mikrotek listed $25 billion of debt on its most recent balance sheet, and sales for year 2007 were $81 billion. A. How many common shares were outstanding? B. What value was the market placing
I have spreadsheets but my calculations are not coming up to the numbers provided. Table 1 Smith Company Balance Sheet Assets: Cash and marketable securities $300,000 Accounts receivable 2,215,000 Inventories 1,8
Please see attachment Problem 3-43.
The Vice President of Operations would like to increase profitability, improve customer service, and expand the business. Even though the external accounting department spends 5 days preparing each quarter's financial statements and disclosures, she does not examine those financial statements issued to the company shareholders.
See attachment for full problems ACC 300 Practice Questions 1). For each of the following accounts, complete the following table. Indicate whether the account is classified as a current asset (CA), noncurrent asset (NCA), current liability (CL), noncurrent liability (NCL), or stockholders' equity (SE), and whether the acc
Which one of the following statements regarding pro-forma financial statements is false? a. Pro-forma financial statements include an income statement, a balance sheet, and a statement of cash flows. b. The pro-forma financial statements complete the master budget for a company. c. Pro-forma financial statements help companies make decisions regarding dividends and management bonus opportunities for the coming year. d. Most companies do not create pro-forma financial statements because of the many assumptions required.
Which one of the following statements regarding pro-forma financial statements is false? a. Pro-forma financial statements include an income statement, a balance sheet, and a statement of cash flows. b. The pro-forma financial statements complete the master budget for a company. c. Pro-forma financial statements help compa
Attached is the balance sheet for Gardner Corporation, for December 31, 2003. If Sales for the year 2004 were $330,000, with cost of goods sold being 60 percent of sales. Selling and administrative expense was $33,000. Depreciation expense was 10 percent of plant and equipment (gross) at the beginning of the year.Interest expens
Company A Balance Sheet 12/31/08 12/31/07 Assets: Current assets: Cash 14,000 12,458 Accounts Rec. 45,489 35,486 Inventory 39,239 32,568 Other 3,400 2,581 Total Current Assets 102,128 83,093 Long term investments 128,580 104,600 Property, plant & equip, net 789,145 771,258
Interrelationships among Financial Statements O'Shea Enterprises started the 2005 accounting period with $30,000 of assets (all cash), $18,000 of liabilities, and $4,000 of common stock. During the year, O'Shea earned cash revenues of $48,000, paid cash expenses of $32,000, and paid a cash dividend to stockholders of $2,000.
FASB Statement No. 131, "Reporting Disaggregated Information about a Business Enterprise" requires the reporting of disaggregated financial data about the different types of business activities in which an enterprise engages. Instructions: Identify 4 of the 6 items of disaggregated information the FASB requires that an ent
An article in Dun's Review made the following comments: "Every other year, say, companies should print the notes in big type and the base figures in smaller ones." Instructions: (a) Are notes considered as part of the financial statements and what basic purpose do they serve? (b) What are the general types of notes?
In its consolidated cash flow statement for the year ended December 31, 20X2, Lamb Corporation reported operating cash inflows of $284,000, cash outflows of $230,000, and $80,000 for investing and financing activities, respectively, and an ending cash balance of $57,000. Lamb purchased 70 percent of Mint Company's common stock o
You will be using financial statements to answer the following questions. 1. Choose any three publicly traded companies as long as you have at least one company that deals with a product and at least one company that deals with a service. 2. Next, go to the web site of each company and find their annual report to sh
Assume that you developed a complete set of personal financial statements for you. Identify three decisions that you will make in the next year in which such financial statements would be useful and describe how you would use those financial statements in those decision.
Explain the "balance sheet approach" to international compensation packages. Why is it so important? Discuss the pros and cons of aligning the expatriate compensation package with the host country colleagues compared to the home country colleagues.
Why has the statement of cash flows become a more popular tool for financial analysis over the last few years?
Why has the statement of cash flows become a more popular tool for financial analysis over the last few years? (300 words)
The following information applies to Questions 1-4 At the beginning of 2006 Smith Co. had the following account balances: Assets $10,000 Liabilities 6,000 Common stock 3,000 Retained Earnings 1,000 During 2006 the following cash events occurred: a. Provided services to customers for $8,000. b
Attached is the two problems that I need help with.