Project #37596 - Accounting (Balance Sheet, etc)

 

 

 

 

 

 

Financial Statement Analysis

 

 

 

 

 

HOS 470

 

 

 

 

 

Assignment Due 8/11-8/12

 

 

 

 

 

 

 

 

 

 

 

Name:_____________________

 

 

 

 

 

 

 

 

 

 

 

From the Balance Sheet and Profit and Loss Statement Provided

 

 

 

 

 

Determine the following:

 

 

 

 

 

 

 

 

 

 

 

1

Working Capital in $

 

 

 

 

 

 

Current Month

 

$

 

 

 

Last Month

 

$

 

 

 

 

 

 

 

 

What are the major account changes that cause the

 

 

 

 

 

difference and what happened to cause the change:

 

 

 

 

 

Account

Amount

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Be sure to use brackets to show increase or decrease

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2

Current Ratio

 

 

 

 

 

 

Current Month

 

 

 

 

 

Last Month

 

 

 

 

Is the current month ratio better or worse than last month?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3

For the current month, calculate the inventory statistics:

 

 

 

 

 

 

Days on Hand

 

 

 

 

 

Number of Turns

 

 

The current month

 

 

 

 

 

 

4

For accounts receivable (City Ledger Account) how many days

 

 

 

 

 

of revenue are owed to the hotel as of the end of the current

 

 

 

 

 

month?

 

 

Days on Hand

 

 

Using the Current Month Data, How many times 

 

 

 

 

 

does the accounts receivable turn over each year.

 

 

 

 

 

 

Turns Annually

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5

Calculate the % change for each of the following accounts:

 

 

 

 

 

 

Account

 

 

% Change

 

 

Prepaid-Other

 

 

 

 

 

Inventory Wine

 

 

 

 

 

Operating Funds

 

 

 

 

 

Fixed Assets-Computers

 

 

 

 

 

Current Year Earnings

 

 

 

 

 

Accrued Incentives

 

 

 

 

 

Sales and Use Tax Payable

 

 

 

 

 

 

 

 

 

6

Compare and comment on both the % Profit/(Loss) 

 

 

 

 

 

Year to Date and $ amount of Profit/(Loss) Vs the 

 

 

 

 

 

Budget year to date.  

 

 

 

 

 

 

 

 

 

 

 

Comments:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7

Was the difference caused by sales volume or expenses?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Which accounts shows the largest variance:

 

 

 

 

 

 

In $

 

 

 

 

 

In %

 

 

 

 

Hint-Don't give me totals-I mean line item accounts

 

 

 

 

 

 

 

 

 

 

 

Which should you pay the most attention to-$ or %

 

 

 

 

 

and why? 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What would happen if you only paid attention to

 

 

 

 

 

% variance? (use the YTD data as an example)

 

 

 

 

 

 

 

 

 

 

8

If you only looked at variance in the total rows

 

 

 

 

 

what is the annual variance to budget for

 

 

 

 

 

Total Indirect Expense?

 

 

 

 

 

 

Dollars

 

$

 

 

 

Expense

 

%

 

 

 

 

 

 

 

 

Given the other variances, would this be large

 

 

 

 

 

enough to cause you to look at the detail?

 

 

 

 

 

 

 

 

 

 

 

Look at variances for the individual accounts under

 

 

 

 

 

Indirect Expenses, are there any areas you would 

 

 

 

 

 

review in detail?  Explain:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Why is it important to look at each line items as well

 

 

 

 

 

as the total lines?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

9

The  % amounts in the section titled "Departmental Profit"

 

 

 

 

 

don't add up to the total line "Gross Operating Income".

 

 

 

 

 

Why is that?   Why is it important when analyzing a statement?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

10

On the balance sheet there are "Deposits" listed as an asset

 

 

 

 

 

and Advance Deposits listed as a liability.  What are these

 

 

 

 

 

accounts?

 

 

 

 

Subject Mathematics
Due By (Pacific Time) 08/11/2014 01:30 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy