Income statements and balance sheets, Accounting Basics

Assignment Help:

Income Statements and Balance Sheets

Case study

A brief outline of the firm and its industry is given, as well as a few tips for your attention. You are given three years' worth of income statements and balance sheets to examine. You are a financial analyst working for an investment firm. This manufacturer has asked for your firm's help in raising capital for the upcoming season's production requirements. It is your job to analyze the financial statements and comment to the investment brokers on this firm's current financial situation. It is late July, and the firm's financial statements (representing the fiscal year ending June 30) have just been released.

For this project you must recreate the attached financial statements on separate worksheets in an Excel workbook. Then, on another worksheet, you must create formulas to calculate the financial ratios that can be derived from the given financial statements. These ratios are to be calculated using formulas in the cells that are linked to the other worksheets: no credit will be given if the ratios are calculated by hand and entered into the cells. You must determine which ratios can be calculated with the information given, based on the ratios given in your textbook. There is enough data for you to calculate liquidity, asset management, leverage, and profitability ratios. You must calculate the Du Pont ratio analysis separately. All three years' worth of ratios must be calculated, and should be presented in chronological order for you to do trend analysis.  Next, you must write a one-page paper discussing the findings of your ratio analysis. You must include not only the current situation, but also how the ratios have changed over the past three years (trend analysis). Any recommendations you can make as to what the firm can do to correct any problem areas would make you look better in the eyes of your superiors.


Related Discussions:- Income statements and balance sheets

Learning objectives of trial balance, Q. Learning objectives of trial balan...

Q. Learning objectives of trial balance? - The cash basis of accounting know revenues when cash is received and recognizes expenses when cash is paid out. - The accrual basi

Treatment of fire insurance claim received , journal entry fire insurance c...

journal entry fire insurance claim received for previous year is 50% of its original claim

JOURNALS., CALCULATIONS VARIOUS QUESTIONS

CALCULATIONS VARIOUS QUESTIONS

What is depreciation, Q. What is Depreciation? Depreciation -- an expen...

Q. What is Depreciation? Depreciation -- an expense which is supposed to reflect the loss in value of a fixed asset. Forinstance if a machine will entirely wear out after ten y

Career in information systems, Q. Career in information systems? Have y...

Q. Career in information systems? Have you yet heard the sayings knowledge is power or else information is money? When people talk about accounting what they are really talking

Help., How would I do this make it and adjustment account revenue 300.00 of...

How would I do this make it and adjustment account revenue 300.00 of supplies on hand 100.00 of unearned revenue is still unearned at the end of the month Accured salaries are 280

TRADING ACCOUNT, WHO PREPARES A TRADING ACCOUNT AND WHY?

WHO PREPARES A TRADING ACCOUNT AND WHY?

Adjusting entries. you have been retained to examine, Adjusting entries. Yo...

Adjusting entries. You have been retained to examine the records of Kathy's Day Care Center as of December 31, 20X3, the close of the current reporting period. In the course o

Explain about accrual basis and periodicity, Q. Explain about Accrual basis...

Q. Explain about Accrual basis and periodicity? Accrual basis and periodicity demonstrated that financial statements more accurately reflect the financial status and operations

AL MASA a sole trader, AL MASA a sole trader,decided to install a new machi...

AL MASA a sole trader,decided to install a new machine to use

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