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

Determine the specific citation for accounting, Determine the specific cita...

Determine the specific citation for accounting for each of the following items: 1. Accounts receivables from related parties should be shown separately from trade receivables. 2. T

Illustrate periodic inventory procedure, Q. Illustrate Periodic inventory p...

Q. Illustrate Periodic inventory procedure? Companies by means of periodic inventory procedure make no entries to the Merchandise Inventory account nor do they maintain unit re

Balance sheet, 1.A business man strated business with 100million on the ba...

1.A business man strated business with 100million on the bank account obtained as a retirement package, 2.He used part of the money and bought a building worth 60 million, 3.He let

cash flow statement, Calculate, CPA, is compiling a cash flow statement fo...

Calculate, CPA, is compiling a cash flow statement for his client, Happy Hal Printing. Over the course of the year Happy Hal acquired new equipment by putting down half of the purc

What is sales discounts account, Q. What is Sales Discounts account? Th...

Q. What is Sales Discounts account? The Sales Discounts account is the contra revenue account to the Sales account. In the income statement the seller deducts this contra reven

Illustrate about the matching principle, Illustrate about the matching prin...

Illustrate about the matching principle  This principle requires that expenses and revenue be recorded in accounting period in which they occur. For a net income figure to be a

Suspense account, The book of Deven Verma could not be tallied. The account...

The book of Deven Verma could not be tallied. The account transferred the difference of Rs. 1.270 in the suspense account on the debit side. the following mistakes were found later

Ledger, Ledger is said to be the principal book entry and the transactions ...

Ledger is said to be the principal book entry and the transactions can even be directly entered into the ledger account.” Elaborate and explain why journal is necessary.

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