Why is it not appropriate to calculate profitability and market-value ratios for Queensway?

SKU: wufo122 Category:

How many key chains must BC sell to break even?

 

Order Now

Question 1 

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

a)DR Receivable from governments CR Funding from governments5,000,0005,000,000
b)DR Inventories CR Accounts payable and accrued liabilities100,000100,000
c)DR Salaries and benefits CR Cash125,000125,000
d)DR Amortization of major equipment CR Accumulated amortization6,237,0006,237,000
e)DR Accounts receivable CR Preferred accommodations revenue2,8002,800
f)DR Long-term debt CRCash250,000250,000
g)DR Cash CR Receivable from governments2,500,0002,500,000
h)DR Medical and surgical supplies expense CR Inventories160,000160,000
i)DR Accounts payable and accrued liabilities CR Cash80,00080,000
j)DR Prepaid expenses CR Cash10,00010,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.

 

Question 2 

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

 

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

 

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

2015   2014
Current ratio1.45
  1. 25
Quick ratio1.391.15
Debt-to-total asset  .68.73
Total assets turnover  .50  .55

 

How has Queensway performed compared to the industry?  Fully explain your answer

 

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

 

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

 

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

 

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.

 

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

 

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?

 

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

 

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

 

i)For 2015, on what did Queensway spend the largest amount of cash?

 

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?

 

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

 

Question 3

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

 

b)Prepare a statement of income for this project.

 

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.

 

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.

 

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.

 

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.

 

Question 4  

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?

 

b)How many lunch packages must BC sell to break even?

 

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?

 

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

 

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?

 

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.

 

 
 

Writing your homework and assignments all on your own is a difficult task. So, Assignments4u has made it easy for students by helping them in writing their assignments. Assignments4u will assist you in completing your tasks, and you can approach us with all your assignment, homework, and essay writing requirements.

We have over 4350+ experienced writers working as experts in different streams of study. Get all your academic doubts clarified and take pride in learning subjects like history, math’s or law. Our assignment help and essay help is available in countries like USA, Australia, New Zealand, Singapore and many more. Get accounting assignment help, corporate nursing assignment help, marketing assignment help or else statistics assignment help in exchange for a nominal price.

Reviews

There are no reviews yet.

Be the first to review “Why is it not appropriate to calculate profitability and market-value ratios for Queensway?”

Your email address will not be published. Required fields are marked *

Sorry no more offers available

When assignments gets tough, get tougher

Want a fresh solution like this one? 
We are available 24/7
ORDER NOW
0 Shares
+1
Share
Tweet
Pin
Call Back