ACCT
245
Assignment 1

This
assignment has a total of 100 marks and contributes 20% to your final grade.
State any assumptions that you have made and remember to show all of your work as
partial marks may be awarded.

Question 1 (20 marks)

Assume
that Queensway Carleton Hospital’s accounting records included the following
journal entries:

a)
DR
Receivable from governments 5,000,000
CR Funding from governments 5,000,000

b)
DR Inventories 100,000
CR Accounts payable and accrued liabilities 100,000

c)
DR
Salaries and benefits 125,000
CR Cash 125,000

d)
DR
Amortization of major equipment 6,237,000
CR Accumulated amortization 6,237,000

e)
DR
Accounts receivable 2,800
CR Preferred accommodations revenue 2,800

f)
DR
Long-term debt 250,000
CR Cash 250,000

g)
DR
Cash 2,500,000
CR Receivable from governments 2,500,000

h)
DR
Medical and surgical supplies expense 160,000
CR Inventories 160,000

i)
DR
Accounts payable and accrued liabilities 80,000
CR Cash 80,000

j)
DR
Prepaid expenses 10,000
CR Cash 10,000

Required:
Explain
the transaction represented by each
of the above journal entries. Do not just say that the account was
increased or decreased—explain the nature of the transaction.
(2 marks each)

Question 2 (55 marks)

For
this question, use the 2015 financial statements of Queensway Carleton Hospital
found athttp://www.qch.on.ca/NewsroomFiles/Audited%20Satements%203-31-15.pdf

a)
Calculate the following ratios for 2015 and 2014
for Queensway:

Current ratio
Quick ratio
Debt-to-total assets
Total assets turnover

Be sure to show all your work. (8 marks)

b)
Based on these ratios, has Queensway’s
performance improved? Fully explain your
answer. (4 marks)

c)
Assume that the average ratios for hospitals
are as follows:

2015 2014

Current ratio 1.45 1.25
Quick
ratio 1.39 1.15
Debt-to-total
asset .68 .73
Total
assets turnover .50 .55

How
has Queensway performed compared to the industry? Fully explain your answer. (4
marks)

d)
Why does Queensway’s current ratio only
differ slightly from its quick ratio? (1
mark)

e)
Why is it not appropriate to calculate an
average collection period for Queensway?
(1 mark)

f)
Why is it not appropriate to calculate
profitability and market-value ratios for Queensway? (2 marks)

g)
Perform a vertical analysis on Queensway’s
statement of financial position and statement of operations for 2015 and 2014. You may find it easier to do this on an Excel
spreadsheet. (10 marks)

h)
Perform a horizontal analysis on Queensway’s
statement of financial position and statement of operations for 2015 and 2014. You may find it easier to do this on an Excel
spreadsheet. (10 marks)

i)
Based on the ratios calculated, the vertical
analysis, and the horizontal analysis, what can you tell about Queensway’s
performance comparing 2015 to 2014? (8
marks)

j)
Overall, did Queensway increase or decrease
its cash flow for 2015? How do you know? (1 mark)

k)
For 2015, what was Queensway’s largest source
of cash inflow? (1 mark)

l)
For 2015, on what did Queensway spend the
largest amount of cash? (1 mark)

m) Queensway’s
Statement of Cash Flow for 2015 shows a decrease in cash held for capital
purposes. What is the nature of this account? How was the amount of the decrease
calculated? (2 marks)

n)
What other information would you require to
do a deeper analysis of Queensway? (2
marks)

Question 3 (15 marks)

Senior
Wishes (SW) is a not-for-profit organization that raises funds to grant wishes
to seniors in nursing homes. One of its current fundraising projects is selling
gourmet snacks. The project has been underway for six months. SW has been quite
successful in selling the snacks to corporations. For the past six months, SW
has had sales of $50,000, but they have only collected $35,000 in cash. For
these sales, SW has paid its supplier $25,000.
The other costs incurred for this project are as follows:

marketing $3,300
utilities 1,200
supplies 1,600
storage 2,400
delivery 1,800
miscellaneous
unpaid bills 2,700

All
expenses have been paid except for the miscellaneous unpaid bills, which will
be paid in the next month.

SW
has provided an initial investment of $25,000 for this project. SW is treating
this investment as an interest-free loan to the project. $5,000 is to be repaid
every six months. No repayments have yet been made. A separate bank account was
established for this project.

Required:

a)
Calculate the balance of the project bank
account. (2 marks)

b)
Prepare a statement of income for this
project. (3 marks)

c)
$15,000 of the sales have yet to be
collected. Explain why this is an issue and what they can do about it, going
forward. (2 marks)

d)
The project manager said that she expected
the project to be self-financing; i.e., that it would generate sufficient cash
flow to allow them to buy more snacks to sell. Are they able to do this?
Explain. (1 mark)

e)
The project manager expects that sales will
increase dramatically in the next six months. Some of their regular customers
have already indicated that they will double or triple their orders for the
upcoming holiday season. Given the project’s current financial situation, can
it handle the additional demand? Explain.
(3 marks)

f)
What suggestions can you make to help improve
the outcome of this project, or do you think that the project should be
terminated? Fully explain your answer.
(4 marks)

Question 4 (10 marks)

The Breakfast Club (BC) is a
not-for-profit organization that provides hot breakfasts to school children. To
finance its efforts, it has a number of on-going fundraisers. One of them is
the lunch package that is sold by volunteers at the local colleges and
university. The package contains a
sandwich, a dessert, and a bottle of water. The package is sold for $7 and
costs BC $5.25 to prepare them. BC’s annual fixed costs for this fundraiser are
$36,000.

This year, BC is selling key chains
at some sports events in a separate fundraiser. The key chains cost BC $3.75
and are sold for $7.50. The sports arena requires BC to rent a table to sell
the key chains. The rental charge is $200 per event. BC has agreed to sell at 75
events for the year.

Required:

a)
What
are the contribution margins for the lunch packages and key chains?
(2 marks)

b)
How
many lunch packages must BC sell to breakeven?
(1 mark)

c)
BC
currently sells 25,000 lunch packages. It believes that if it drops the price
by $.25, sales will increase by 15%. Should it do this? Why or why not? (2 marks)

d)
How
many key chains must BC sell to break even? (1 mark)

e)
One
of BC’s volunteer board members thinks that the price of the key chains is too
low. He suggests that the price be increased to $10. At this price, how many
key chains must be sold to break even? (2 marks)

f)
BC
is thinking of hiring someone to walk around with a sandwich board sign at each
event to advertise the key chains. It would cost BC $75 at each event. BC
believes that this might lead to a 20% increase in sales. Assume that BC will
continue to sell the key chains for $7.50 and that it currently sells 2,500 key
chains per year. Should BC hire someone to walk around with a sandwich board
sign? Fully explain your answer. (2
marks)