Create the statement of cash flows

Assignment Help Managerial Accounting
Reference no: EM131260729

Excel Workbook Assignment

A. Create the Statement of Cash Flows using the Indirect Method from the information provided. Include the required supplemental information regarding interest and taxes, and include any significant non-cash transactions (40 points-graded for accuracy and format, including Excel spreadsheet links).

B. (1) Calculate the Operating Cash Flows to Net Sales Ratio; the Operating Income to Net Sales Ratio; and the Net Income to Net Sales Ratio;

(2) Calculate the Operating Cash Flow on Total Assets Ratio and the Return on Total Assets Ratio. Be sure to use Average Total Assets in your denominator for these last two ratios (10 points-graded for accuracy and format, including Excel spreadsheet links).

Attachment:- Excel Workbook.rar

Reference no: EM131260729

Tinco has product liability problems and has filed

TinCo has product liability problems and has filed for bankruptcy protection in the state court. Currently, its liabilities are $1 million, and its depreciable assets are valu

The straight-line method of depreciation

A company purchased a truck on March 1, 2007 at a cost of $70,000. The truck had an estimated useful life of 5 years and an estimated salvage value of $10,000. The company use

Identify and discuss the elements of the fraud triangle

Explain why the internal control practice of separation of duties failed to prevent the fraudulent reporting - Identify and discuss the elements of the fraud triangle that m

Record the entry for the conversion of the bonds

The company exercises the call option after the semiannual interest is paid on June 30, 2011. Record the entry to retire the bonds - Record the entry for the conversion of th

General views regarding interperiod income tax allocation

There are 3 general views regarding interperiod income tax allocation: no allocation, partial allocation, and comprehensive allocation. Defend the position of an allocation of

Prepare the appropriate journal entry for each of the items

Prepare the appropriate journal entry for each of the items above (a. through j.). You can assume that all transactions with employees, customers, and suppliers were conduct

Determine the optimal yearly production plan

Determine the optimal yearly production plan for the ore processed by the Luna Mining Company and prepare a budgeted income statement before taxes for LMC for 2015, and determ

Commercial customers

Clean, Inc. cleans and waxes floors for commercial customers. The company is presently operating at less than capacity with equipment and employees idle at times. The company

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd