San Jose State University

BUS 220H

1. Balance Sheet Analysis
a. Prepare a cash lead sheet:
i. What general ledger accounts are listed?
Pety Cash, Operatng Bank Account
ii. What other informaton is listed? – Other informaton listed are current and
prior year amounts, Change in $ and %.
iii. What is the amount of the beginning balance for cash? - $4,439,538
iv. What is the amount of the ending value for cash? - $4,154,727
Where else can you fnd this informaton, other than in the lead sheet? – When
you move your mouse over the cash account, you will see the ending and
beginning balances.
b. What are the total assets for the hotel in the current year? - $18,494,703
c. Which liability account class had a decrease from the prior year? (Remember that
liabilites are credit accounts, a decrease would result in fewer credits.) - Accounts
Payable & Accrued Payroll
d. How many specifc general ledger accounts combine to make the total plant, property
and equipment (PPE) account classifcaton shown in this tab? - 5 accounts
e. What is the value of the Buildings and Building Improvements account (GL Acct # 16200)
in the current year? - $32,139,467
f. What color is the bar that shows the inventory ending balance amount in the balance
sheet compositon view? - Purple
2. Income Statement Analysis
a. What was the percentage increase in travel expenses (excluding mileage)? - 245.1%
increase
b. Did total revenue increase or decrease from the previous year and by how much? -
Decrease in total revenue by $112,002
c. How much did the company pay for overtme expenses in the current year? - $130,038
d. What color is the bar representng Sales – Hotel? - Green
3. Monthly Account Actvity Analysis
a. For which month is there the largest difference in net revenue (all revenue accounts)
between FY15 and FY16? - April
b. In FY16, which month has the highest revenue (all revenue accounts)? – October
$1,223,017
c. In FY16, which month has the lowest revenue (all revenue accounts)? - January
$318,315
d. Where did you fnd the answer to the previous questons? - I fltered the informaton to
only 2016 and revenue accounts only. Then I looked at the ending balances for 2016 in
the monthly actvity analysis.
e. Which month of each FY shows the largest amount of cash actvity and how much was
it? – FY16, March $1,016,811; FY15, October $1,223,017