# 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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews