Balance sheet and income statement, Financial Accounting

Assignment Help:

1) The detailed information is on the second tab marked "Financials". Enter summarized Balance Sheet and Income Statement information for Cummins into the template on the "Summary" tab for years 2008 to 2010. Use the field "All Other Items" for tying out the various financial sections. Be sure to balance.

2) Calculate the most recent two year CAGR (ie from 2008 to 2010) for all lines Remember that CAGR is the compound annual growth rate (ie that the growth from 2008 to 2010 would be the ((2010 figure/2008 figure) ^0.5)-1

3) Forecast next two years (2011 and 2012) Balance Sheet and Income Statement by using 1.05X (i.e. 105%) of the calculated CAGR for each line in #2 (in other words, if the CAGR is 10%, 105% of CAGR would be 10.5% as your growth rates. Remember growth rates can be negative as well). Do not forecast the total lines, such as Total Assets or Net Income - calculate them from their forecasted component lines. Plug cash to make balance sheet balance after forecasting all other lines.

4) Calculate common sized income statement and common sized balance sheet where indicated

5) Calculate the following ratios for all 5 years: (be sure to use averages where applicable )

a. Cash ratio

b. Quick ratio

c. Current ratio

d. Debt to Equity

e. Days Receivables

f. Days Inventory

g. Days Payable

h. Net working capital

6) Calculate cash conversion cycle for 2008-2012 (discussed in class but also see pages 800-804 - also known as simply the Cash Cycle)

7) Using 2008 as baseline, how much additional cash is being used/has been freed up by 2010 (i.e. the difference in net working capital)

8) Using a cost of funds of 10%, what is the additional cost/benefit in 2010 versus 2008 from to the change in net working capital (ie, if you say that funding working capital costs them 10%, how much more are they paying in costs due to the additional working capital, or saving if there is less working capital)

9) Using 2010 interest expense and both ST and LT debt levels, what is the company's actual interest expense rate as a %? (note, this may be a low interest rate - big companies typically can take advantage of very low rates or have special financing on certain items).

10) If the company wanted to pay off all its Short-term and Long-term debt over a ten year period by making equal quarterly payments  at its current interest rate calculated in #9, what would be the size of those payments?


Related Discussions:- Balance sheet and income statement

Determine the contribution margin, You were recently hired by E&T Boats, In...

You were recently hired by E&T Boats, Inc. to assist the company with its financial planning and to evaluate the company's performance.  E&T Boats, Inc. builds and sells boats to o

Find out the current dividend per share, Find out the Current dividend per ...

Find out the Current dividend per share:   Data Stock price = $ 65 Return = 11% Dividend Yield =  11/ 2 = 5.5 % (given) Formula: Dividend in one year = divid

Investment with ex. div. quotation-executorship laws, Investment with ex. d...

Investment with ex. div. quotation Investment with ex. div. quotation will be debited to the investment account at its ex. div. value. The full impending dividend will also

Objectives of time value of money, After going through this section, you mu...

After going through this section, you must be capable to: -          Identify the time value of money; -          Know what gives money its time value; -          Identify

Lack of assets available to offer as collateral or security, Q. Lack of ass...

Q. Lack of assets available to offer as collateral or security? If SMEs wish to access bank finance for instance, then banks will wish to address the information problem referr

Termination of appointments-trust laws, TERMINATION OF APPOINTMENTS A tru...

TERMINATION OF APPOINTMENTS A trustee may cease to hold office in the following ways: (a) Disclaimer : At any time before acceptance of the trusts. (b) Retirement : Eith

Total prime cost, Interstate Manufacturing produces brass fasteners and in...

Interstate Manufacturing produces brass fasteners and incurred the following costs for the year just ended: Materials and supplies used Brass

Prepare journal entries to record liquidation transaction, Terry Marks is a...

Terry Marks is a well-known architect. He wants to start his own business and convinces Rob Norris, his cousin and a civil engineer, to contribute capital. Together, they form a pa

Flexibility in debt finance, Q. Flexibility in Debt finance? Debt finan...

Q. Flexibility in Debt finance? Debt finance is more elastic than equity in that various amounts can be borrowed at a fixed or floating interest rate and for a range of maturit

As an expense and an asset-survivorship policy, As an expense and an asset ...

As an expense and an asset This approach tries to resolve the differences between the two methods by ensuring that we show an asset that may materialize or crystallize and at t

Write Your Message!

Captcha
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