Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows ($ millions).

a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to one decimal place.

Based on your computations above, select the most appropriate answer.

Times interest earned has steadily increased since 2014.

Times interest earned has steadily decreased since 2014.

Times interest earned has remained the same since 2014.

Times interest earned increased in 2015 but then decreased in 2016.

b. Compute the current ratio for each year and discuss any trend in liquidity. Round answers to one decimal place.

Do you believe the company is sufficiently liquid? Explain.

CVS’s current ratio has increased over the past three years and is greater than 1, indicating CVS is liquid.

CVS’s current ratio has decreased over the past three years and it is currently less than 1 indicating CVS is not liquid.

CVS’s current ratio has increased over the past three years, however, it remains less than 1 indicating CVS is not liquid.

CVS’s current ratio has decreased over the past three years, however, it is greater than 1 indicating CVS is liquid.

c. Compute the total liabilities-to-equity ratio for each year and discuss any trends for each.

Round answers to one decimal place.

Based on your computations above, select the most appropriate answer.

CVS's liabilities to equity ratio has increased since 2014, however, the ratio is relatively low, concluding CVS is solvent.

CVS's liabilities to equity ratio has decreased since 2014, remaining relatively low, concluding CVS is solvent.

CVS's liabilities to equity ratio has increased since 2014, and is relatively high, concluding CVS is insolvent.

CVS's liabilities to equity ratio has decreased since 2014, remaining relatively low, concluding CVS is insolvent.

d. What is your overall assessment of the company’s credit risk from the analyses in (a), (b), and (c)?

CVS is a low credit risk as it has a low level of debt, is liquid and can easily meet its interest expenses.

CVS is a low credit risk as its liabilities to equity ratio, current ratio, and times interest earned ratio have all decreased since 2014.

CVS is a medium to high credit risk as its level of debt has increased and its current ratio and times interest ratio have decreased.

CVS is a medium to high credit risk as its liabilities to equity ratio, current ratio, and times interest earned ratio have all increased since 2014.

Badlands, Inc. manufactures a household fan that sells for $40 per unit. All sales are on account, with 30 percent of sales collected in the month of sale and 70 percent collected in the following month. The data that follow were extracted from the company’s accounting records.

• Badlands maintains a minimum cash balance of $14,000. Total payments in January 20x1 are budgeted at $220,000.
• A schedule of cash collections for January and February of 20x1 revealed the following receipts for the period:

  	Cash Receipts
  	January			February
  From December 31 accounts receivable	$	112,000
  From January sales		94,000		$	150,000
  From February sales					65,400

• March 20x1 sales are expected to total 5,000 units.
• Finished-goods inventories are maintained at 30 percent of the following month’s sales.
• The December 31, 20x0, balance sheet revealed the following selected figures: cash, $24,300; accounts receivable, $112,000; and finished goods, $25,050.

1. Determine the number of units that Badlands sold in December 20x0.

2. Compute the sales revenue for March 20x1.

3. Compute the total sales revenue to be reported on Badlands’ budgeted income statement for the first quarter of 20x1.

4. Determine the accounts receivable balance to be reported on the March 31, 20x1, budgeted balance sheet.

5. Calculate the number of units in the December 31, 20x0, finished-goods inventory.

6. Calculate the number of units of finished goods to be manufactured in January 20x1.

7. Calculate the financing required in January, if any, to maintain the firm’s minimum cash balance.

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records:

• All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

• Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition.

• The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $55,000; accounts receivable, $220,000; and accounts payable, $77,000.

• Mary and Kay, Inc. maintains a $55,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

• Additional data:

1.Prepare a schedule that discloses the firm’s total cash collections for January through March.

2. Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

3. Prepare a schedule that summarizes the firm’s financing cash flows for January through March.

1-. Write the General Ledger and Reporting General Controls used in companies to overcome the threats.

2- Identify the three basic rules that apply to the REA model pattern

Accounting Information System

The following transaction refers to one of the Districts a. The District issues general obligation bonds in the amount of $900,000, receiving cash for the full-face amount of the bonds. The cash will be used to buy capital assets. b. The District buys a prefabricated building for $750, 000, using part of the bond proceeds. The building is delivered and the invoice for the building is approved. c. The invoice approved in b. is paid. d. The General Fund transfers cash of $55,000 to another fund in anticipation of the payment of the first installment of interest ($30,000) and principal ($25,000) on the debt. e. The first installment of debt service on bonds issued in ‘a’ becomes due and payable. f. Debt service on the bonds issued in a. is paid

Required

Prepare entries to record the above transactions related to acquisition of capital assets by a district. Identify the fund(s) used. The District uses encumbrance accounting

Western State University (WSU) is preparing its master budget for the upcoming academic year. Currently, 16,500 students are enrolled on campus; however, the admissions office is forecasting a 8 percent growth in the student body despite a tuition hike to $85 per credit hour. The following additional information has been gathered from an examination of university records and conversations with university officials:

• WSU is planning to award 200 tuition-free scholarships.
• The average class has 20 students, and the typical student takes 15 credit hours each semester. Each class is three credit hours.
• WSU’s faculty members are evaluated on the basis of teaching, research, and university and community service. Each faculty member teaches five classes during the academic year.

1.Prepare a tuition revenue budget for the upcoming academic year.

2.Determine the number of faculty members needed to cover classes.

3. Assume there is a shortage of full-time faculty members. Select at least five actions that WSU might take to accommodate the growing student body by selecting an "X" next to the action.

4.You have been requested by the university’s administrative vice president (AVP) to construct budgets for other areas of operation (e.g., the library, grounds, dormitories, and maintenance). The AVP noted: “The most important resource of the university is its faculty. Now that you know the number of faculty needed, you can prepare the other budgets. Faculty members are indeed the key driver—without them we don’t operate.” Are faculty members a key driver in preparing budgets? Yes or No?

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records:

• All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

• Seventy percent of the merchandise purchases are paid for in the month of purchase; the remaining 30 percent are paid for in the month after acquisition.

• The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $75,000; accounts receivable, $195,000; and accounts payable, $72,000.

• Mary and Kay, Inc. maintains a $75,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 8 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

• Additional data:

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records:

• All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

• Seventy percent of the merchandise purchases are paid for in the month of purchase; the remaining 30 percent are paid for in the month after acquisition.

• The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $75,000; accounts receivable, $195,000; and accounts payable, $72,000.

• Mary and Kay, Inc. maintains a $75,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 8 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

• Additional data:

1. Prepare a schedule that discloses the firm’s total cash collections for January through March.

2. Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

3.Prepare a schedule that summarizes the firm’s financing cash flows for January through March.

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records:

• All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

• Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition.

• The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $80,000; accounts receivable, $260,000; and accounts payable, $85,000.

• Mary and Kay, Inc. maintains a $80,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

• Additional data:

1. Prepare a schedule that discloses the firm’s total cash collections for January through March.

2. Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

3. Prepare a schedule that summarizes the firm’s financing cash flows for January through March.

Learning Outcome:

• identify and illustrate how the principles of internal control are used to manage and control a firm's resources and minimize risk.

Ebeneezer Company  

Edward Ebeneezer founded Ebeneezer Company, a rapidly growing start-up business, in 2018. Edward hired a record keeper seven months ago.   The record keeper, Wanda Wonderful, left town after the company’s manager discovered that $65,000 had disappeared over the past five months. An audit disclosed that Wanda had written and signed several checks made payable to her husband, Robbing Ron. Wanda recorded the checks as salaries expense.   Robbing, who cashed the checks but never worked for the company, left town with Wanda. As a result, the Ebeneezer Company incurred an uninsured loss of $65,000.

1. Evaluate Ebeneezer Company’s internal control system by listing one principle of internal control that appears to have been ignored.
2. Recommend to Edward how to avoid such a loss in the future with an explanation of the process to mitigate the internal control that was ignored.
3. This first post must include a minimum of 100 words.

Lasko Trial Balance as of 12/31/17 each account has a normal balance.

Use this financial information to answer the questions below.

1) What is the gross profit for Lasko for the year ended 12/31/17?

• $67,600

• $72,400

• $92,600

• $140,000

• 2) Using the Lasko Trial Balance as given above, then the most likely total for owner equity at 12/31/2017?

• $151,500

• $126,500

• $121,500

• $80,000

• 3) Using the Lasko Trial Balance as given above and that Lasko had a gross profit ratio (gross margin ratio) for 2016 of 50%, you can determine that for Lasko which of the following is true?

• Their ability to generate profit from sales is worse than for the year 2016.

• Their ability to generate profit from sales is better than for the year 2016.

• Their ability to generate profit from sales is unchanged compared to the year 2016.

• Can’t determine the gross profit ratio (gross margin ratio)in 2017 – not enough information.

• 4) Using the Lasko Trial Balance as given above and that Lasko had a current ratio for 2016 of 1.5:1; you can determine that for Lasko which of the following is true?

• Their ability to pay short term obligations is worse than at the end of 2016.

• Their ability to pay short term obligations is better than at the end of 2016.

• Their ability to pay short term obligations is unchanged compared to the end of 2016.

• 5) Assuming that the only depreciable asset is the office equipment, the information shown in the trial balance indicates that the office equipment has been used by Lasko for how many years?

• 5 Years

• 4 Years

• 3 Years

• 2 Years

• 6) Looking at the Lasko Trial Balance for accuracy and based on what accounts are already listed, which of the following accounts should be included but are not?

• Supplies expense

• Interest expense

• Allowance for Doubtful Accounts

• All of the above accounts would be expected.

Isabella traveled to a neighboring state to investigate the purchase of an interior design firm. Her expenses included travel, legal, accounting, and miscellaneous expenses. The total was $51,000. She incurred the expenses in January and February of 2018. In each of the following scenarios, what can Isabella deduct in 2018?

In your computations, round the per-month amount to the nearest dollar. If an amount is zero, enter "0".

a. Isabella was in the interior design business and did not acquire the interior design firm.
$

b. Isabella was in the interior design business. She acquired the interior design firm and began operating it on August 1, 2018.
$

c. Isabella did not acquire the interior design firm and was not in the interior design business.
$

d. Isabella acquired the interior design firm but was not in the interior design business when she acquired it. Operations began on May 1, 2018.
$

11. What do you need to ensure when preparing and distributing reports that document accounts receivable, debt recovery type and cause, and debt recovery plans?

12. What types of accounting documentation will need to be filed, according to the organisational policies and procedures? List 4 examples

13. What documentation would you require to identify, investigate and rectify creditor invoice discrepancies?

1. One way of accessing financial information about a company is to look it up at the company's website. Access the most recent annual report of a company of your choice from the company's website and address the following points. a. Review the company's footnotes (notes accompanying the financial statements) to discover how it applies the revenue recognition principle and when it recognizes revenue. Report what you discover. b. Based on your observation of the financial statements, what amount should be credited to Income Summary to summarize its revenues earned? c. Based on your observation of the financial statements, what amount should be debited to Income Summary to summarize its expenses incurred? d. What is the balance of its Income Summary account before it's closed?

Executives of the Carrot Watch, Inc. (which produces Apple Watch knock-offs) produced the latest watch which is now ready for distribution. Carrot Watch sells to a wholesaler who then sells to retailers and ultimately end consumers. The following cost information is needed to answer the questions below for Carrot Watch, Inc.:

Calculate the following:

1. Unit Gross Profit Margin in both dollars and percent

2. Assume there were 12,000 watches sold. What is the TOTAL Gross Profit margin in dollars.

3. Manufacturer Margin (as a % of Selling Price)

Question 4 Budgeting – To be done on Excel. Email your answer to tutor.

Hudson Holdings Ltd is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet at June 30^th is shown below:

Hudson Holdings Ltd managers have made the following additional assumptions and estimates:

• Estimated sales for July, August, September, and October will be $252,000, $276,000, $264,000, and $288,000, respectively.

• All sales are on credit and all credit sales debts are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July.

• Each month’s ending inventory must equal 30% of the cost of the next month’s sales. The cost of goods sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July.

• Monthly selling and administrative expenses are always $72,000. Each month $6,000 of this total amount is depreciation expense and the remaining $66,000 relates to expenses that are paid in the month they are incurred.

• The company does not plan to borrow money or pay or declare dividends during the quarter ended September 30. The company does not plan to issue any shares or repurchase its own shares during the quarter ended September 30.

REQUIRED

1. Prepare a schedule of expected cash collections for July, August, and September. Also calculate total cash collections for the quarter ended September 30.

(b)

i           Prepare a merchandise purchases budget for July, August and September and also calculate total merchandise purchases for the quarter ended September 30.                                                                                    

ii          Prepare a schedule of expected cash disbursements for merchandise purchases for July, August, and September. Also calculate total cash disbursements for merchandise purchases for the quarter ended September 30.                                                                                                           

(c) Prepare an income statement for the quarter ended September 30. (Use the absorption format)                                                                                              

(d) Prepare a balance sheet as at September 30.                                              

Question 4 To be done on Excel.

………………REFER TO THE DATA IN QUESTION 4 ABOVE………………………………..

Hudson Holdings Ltd is considering making the following changes to the assumptions underlying its master budget.

1. Each month’s credit sales are collected 45% in the month of sale and 55% in the month following the sale.

2. Each month’s ending inventory must equal 20% of the cost of next month’s sales.

3. The company pays for 30% of its merchandise purchases in the month of the purchase and the remaining 70% in the month following the purchase.

All other information from question 4 above that is not mentioned remains the same.

REQUIRED:

Using the new assumptions described above, complete the following requirements:

a.

Prepare a schedule of expected cash flows for July, August, and September. Also calculate total cash collections for the quarter ended September 30.                                 

b.

1. Prepare a merchandise purchases budget for July, August, and September. Also calculate total merchandise purchases for the quarter ended September 30.             

2. Prepare a schedule of expected cash disbursements for merchandise purchases for July, August and September. Also calculate total cash disbursements for the quarter ended September 30.

c.

Prepare an income statement for the quarter ended September 30. (Use the absorption format)

d.

Prepare a balance sheet as at September 30.