Search here for Tutorials

If the Data is different in your question, please send your questions to homeworksolutionsnow@gmail.com. The questions will be answered at the same price.

Coca-cola Company analysis - For this assignment, you will complete the Financial Overview component of your course project.

For this assignment, you will complete the Financial Overview component of your course project. To complete this assignment, use the Financial Analysis Toolkit Excel file, provided in the Resources, to complete a financial analysis of your chosen company over the last two most recent years available in annual reports. Replace the numbers provided in the Excel file with the appropriate numbers for your firm. Then, write a 2–3 page financial analysis of your company, addressing the following elements:
Identify your company, its industry, and analyze the important segments (percentage of sales or subsidiaries) of your company compared to its industry and its overall business.
Perform a complete financial analysis of your chosen company's financial statements—horizontal, vertical (Percentage of Sales and Common-Size), and changes in ratios—for the last two years.
Compare all ratios to industry averages. Evaluate the company's ratios against the industry averages.
Explain the significance of the company's ratios when compared to industry averages.
Analyze the company's cash flows.
Assess the overall financial health of your company based on this financial analysis.
A great way to integrate your completed calculations from your Excel sheet into your written analysis is to paste pieces of the worksheet directly into your Word document. You are also encouraged to create graphs or charts from the data that may illustrate your analyses as well.


Folder Name: Coca-cola company   Price: $150


ED-21 Analyzing the ability to pay liabilities

ED-21 Analyzing the ability to pay liabilities

ED-21 Large Land Photo Shop has asked you to determine whether the company’s ability to pay current liabilities and total liabilities improved or deteriorated during 2015. To answer this question, you gather the following data:

2015                2014
Cash                                        $ 58,000          $ 57,000
Short-term Investments            31,000             0
Net Accounts Receivables       110,000           132,000
Merchandise Inventory            247,000           297,000

Total Assets                             585,000           535,000
Total Current Liabilities           255,000           222,000
Long-term Note Payable          46,000             48,000
Income From Operations         180,000           153,000
Interest Expense                      52,000             39,000

Compute the following ratios for 2015 and 2014, and evaluate the company’s
ability to pay its current liabilities and total liabilities:
a. Current ratio                         d. Debt ratio
b. Cash ratio                            e. Debt to equity ratio
c. Acid-test ratio

TUTORIAL PREVIEW
Req. 1
a.
Current Ratio = Current Assets/ Current Liabilities
2015
2014
Cash
58000
57000
Short-term investments
31000
0
Net receivables
110000
132000



File name: ED-21 Large Land Photo.xlsx  File type: .doc PRICE: $10

ED-20 Computing key ratios

ED-20 Computing key ratios

ED-20  The financial statements of Victor’s Natural Foods include the following items

Current Year                Balance Sheet:
Preceding Year

Cash                                        $ 15,000                      $ 20,000
Short-term Investments             11,000                         27,000
Net Accounts Receivables       54,000                         73,000
Merchandise Inventory            77,000                         69,000
Prepaid Expenses                     15,000                         9,000
Total Current Assets                172,000                                   198,000
Total Current Liabilities          133,000                                   93,000

Income Statement:
Net Credit Sales           $ 462,000
Cost of Goods Sold     315,000

Compute the following ratios for the current year:
a. Current ratio                                                 e. Days’ sales in inventory
b. Cash ratio                                                    f. Days’ sales in receivables
c. Acid-test ratio                                              g. Gross profit percentage
d. Inventory turnover

TUTORIAL PREVIEW
a.        
Current Ratio = Current Assets/ Current Liabilities
Current Assets =
172,000
Current Liabilities =
133,000
Current Ratio = 
1.29



File name: ED-20 Victors Natural Foods.xlsx File type: .doc PRICE: $10

ED-15 Performing Horizontal analysis – income statement

ED-15 Performing Horizontal analysis – income statement

Data for Mariner Designs, Inc. follow:

ED-15 MARINER DESIGNS INC.


MARINER DESIGNS, INC.
Comparative income statement
Years Ended December 31,2015 and 2014

                                                            2015                2014
Net sales Revenue                               $431,000         $372,350
Expenses
Cost of good sold                                200,000           187,550
Selling and Administrative Expenses   99,000             91,050
Other Expense                                     8,350               6,850
Total Expenses                                                307,350                       285,450
Net Income                                          $123,650         $86,900

Requirements
1. Prepare a horizontal analysis of the comparative income statement of Mariner
Design inc round percentage changes to one decimal place
2. Why did 2015 net income increase by a higher percentage than net sales
revenue?

TUTORIAL PREVIEW
Req. 1
Mariner Designs, Inc.
Comparative Income Statement
Years Ended December 31, 2015 and 2014



Increase (Decrease)

2015
2014
Amount
Percentage
Net sales revenue
$431,000
$372,350
$58,650
15.75%



File name: ED-15 MARINER DESIGNS INC.xlsx File type: .doc PRICE: $8

Ken Lumas started his own consulting firm, Lumas Consulting, on June 1, 2014. The trial balance at June 30 is as follows.

Ken Lumas started his own consulting firm, Lumas Consulting, on June 1, 2014. The trial balance at June 30 is as follows.


Complete Financial Accounting problem below:
Ken Lumas started his own consulting firm, Lumas Consulting, on June 1, 2014. The trial balance at June 30 is as follows.
LUMAS CONSULTING
Trial Balance
June 30, 2014
Debit  
Credit  
Cash
$ 6,850     
Accounts Receivable
7,000     
Supplies
2,000     
Prepaid Insurance
2,880     
Equipment
15,000     
Accounts Payable
         $ 4,230     
Unearned Service Revenue
5,200     
Common Stock
22,000     
Service Revenue
8,300     
Salaries and Wages Expense
4,000     
Rent Expense
  2,000     
           
$39,730     4
$39,730     
In addition to those accounts listed on the trial balance, the chart of accounts for Lumas also contains the following accounts: Accumulated Depreciation—Equipment, Salaries and Wages Payable, Depreciation Expense, Insurance Expense, Utilities Expense, and Supplies Expense.


Other data:
1. Supplies on hand at June 30 total $720.
2. A utility bill for $180 has not been recorded and will not be paid until next month.
3. The insurance policy is for a year.
4. Services were performed for $4,100 of unearned service revenue by the end of the month.
5. Salaries of $1,250 are accrued at June 30.
6. The equipment has a 5-year life with no salvage value and is being depreciated at $250 per month for 60 months.
7. Invoices representing $3,900 of services performed during the month have not been recorded as of June 30.

Instructions
(a)Prepare the adjusting entries for the month of June.
(b)Post the adjusting entries to the ledger accounts. Enter the totals from the trial balance as beginning account balances. (Use T-accounts.)
(b) Service rev. $16,300
(c)Prepare an adjusted trial balance at June 30, 2014.
(c) Tot. trial balance   $45,310


TUTORIAL PREVIEW
PART 1

Date
Account Titles
Debit
Credit

2014
Supplies Expense
1,280

1
30-Jun
        Supplies ($2,000 – $720)

1,280








File name: Lumas consulting.xls File type: .doc PRICE: $20

Clark Paints INC Project Part B Capital Budgeting Decision

Capital Budgeting Decision

These instructions can also be downloaded from DocSharing

Due by end of Week 7, midnight, mountain time

Here is Part B:

Clark Paints:  The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the paint cans instead of purchasing them. The equipment needed would cost $200,000, with a disposal value of $40,000, and would be able to produce 5,500,000 cans over the life of the machinery. The production department estimates that approximately 1,100,000 cans would be needed for each of the next 5 years.
The company would hire three new employees. These three individuals would be full-time employees working 2,000 hours per year and earning $12.00 per hour. They would also receive the same benefits as other production employees, 18% of wages in addition to $2,500 of health benefits.
It is estimated that the raw materials will cost 25¢ per can and that other variable costs would be 5¢ per can. Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted.
It is expected that cans would cost 45¢ each if purchased from the current supplier. The company's minimum rate of return (hurdle rate) has been determined to be 12% for all new projects, and the current tax rate of 35% is anticipated to remain unchanged. The pricing for a gallon of paint as well as number of units sold will not be affected by this decision. The unit-of-production depreciation method would be used if the new equipment is purchased.

Required: 

1. Based on the above information and using Excel, calculate the following items for this proposed equipment purchase.
·         Annual cash flows over the expected life of the equipment
·         Payback period
·         Annual rate of return
·         Net present value
·         Internal rate of return


2. Would you recommend the acceptance of this proposal? Why or why not. Prepare a short double-spaced Word paper elaborating and supporting your answer.


File name: Clark Paints Inc. Project Part B.xls File type: .doc PRICE: $20

ACC557 Homework 5 E13-3 E13-4 P13-3A P13-7A

ACC557 Homework 5

Due Week 9 and worth 50 points

Directions: Answer the following questions on a separate Microsoft Word or Excel document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link in Blackboard.

Exercises
E13-3.Cushenberry Corporation had the following transactions.

1. Sold land (cost $12,000) for $15,000.
2. Issued common stock at par for $20,000.
3. Recorded depreciation on buildings for $17,000.
4. Paid salaries of $9,000.
5. Issued 1,000 shares of $1 par value common stock for equipment worth $8,000.
6. Sold equipment (cost $10,000, accumulated depreciation $7,000) for $1,200.

Instructions
For each transaction above, (a) prepare the journal entry, and (b) indicate how it would affect the statement of cash flows using the indirect method.

E13-4.Gutierrez Company reported net income of $225,000 for 2015. Gutierrez also reported depreciation expense of $45,000 and a loss of $5,000 on the disposal of equipment. The comparative balance sheet shows a decrease in accounts receivable of $15,000 for the year, a $17,000 increase in accounts payable, and a $4,000 decrease in prepaid expenses.

Instructions
Prepare the operating activities section of the statement of cash flows for 2015. Use the indirect method.


Problems
P13-3A.The income statement of Whitlock Company is presented here.
Whitlock Company
Income Statement
For the Year Ended November 30, 2015

Sales revenue

$7,700,000
Cost of goods sold


   Beginning Inventory
$1,900,000

   Purchases
4,400,000

   Goods available for sale
6,300,000

   Ending inventory
1,400,000

Total cost of goods sold

4,900,000
Gross profit

2,800,000
Operating expenses

1,150,000
Net income

$1,650,000

Additional information:
Accounts receivable increased $200,000 during the year, and inventory decreased $500,000.
Prepaid expenses increased $150,000 during the year.
Accounts payable to suppliers of merchandise decreased $340,000 during the year.
Accrued expenses payable decreased $100,000 during the year.
Operating expenses include depreciation expense of $70,000.

Instructions
Prepare the operating activities section of the statement of cash flows for the year ended November 30, 2015, for Whitlock Company, using the indirect method.


P13-7A.Presented below are the financial statements of Nosker Company.
NOSKER COMPANY
Comparative balance Sheet
December 31
Assets
2015
2014
Cash
$38,000
$20,000
Accounts receivable
30,000
14,000
Inventory
27,000
20,000
Equipment
60,000
78,000
Accumulated depreciation – equipment
(29,000)
$108,000
Total
$126,000
$108,000
Liabilities and Stockholders Equity


Accounts payable
$24,000
$15,000
Income taxes payable
7,000
8,000
Bonds payable
27,000
33,300
Common stock
18,000
14,000
Retained earnings
50,000
38,000
Total
$126,000
$108,000


NOSKER COMPANY
Income Statement
For the year Ended December 31, 2015-12-03

Sales revenue                           $242,000
Cost of goods sold                   175,000
Gross profit                             67,000
Operating expenses                  24,000
Income from operation                        43,000
Intrest expense                         3,000
Income before income taxes    40,000
Income tax expense                 8,000
Net income                              $32,000

Additional data:
Dividends declared and paid were $20,000.
During the year equipment was sold for $8,500 cash. This equipment cost $18,000 originally and had a book value of $8,500 at the time of sale.
All depreciation expense, $14,500, is in the operating expenses.
All sales and purchases are on account.

Instructions
Prepare a statement of cash flows using the indirect method.
Compute free cash flow.



TUTORIAL PREVIEW
1. (a)
Cash...............................................................             15,000
Land ......................................................                                 12,000
Gain on Disposal ..............................                                        3,000

(b) The cash receipt ($15,000) is reported in the investing section. The gain ($3,000) is deducted from net income in the operating section.


File name: ACC557 Homework 5.doc File type: .doc PRICE: $20