In an effort to increase the number of shoppers coming into its stores and the length of time those shoppers stay, Kohl’s (KSS (Links to an external site.)) is adding a small café (Kohl’s Café) to each of two of its department stores in the Milwaukee, Wisconsin area. Each café will sell Caribou Coffee items including lattes, cappuccinos, and other coffee items. Granola bars, chips, cookies, and other grab-and-go snacks will also be available. These cafés are experimental at this point; Kohl’s has no plans to add the cafés to other stores.
Questions
In: Accounting
Using the following information prepare all appropriate journal entries for years 1 and 2.
You are only required to create entries within the subaccount of “Education and training” you do not have to make any entries for corresponding accounts in other funds.
County regulations require all appropriations lapse at year end.
Year 1:
Year 2:
Please do not “combine” ANY entries unless absolutely required.
( this will require 16 entries if done correctly.)
In: Accounting
|
|
|
In: Accounting
Compute, Disaggregate, and Interpret ROE and
RNOA
Headquartered in Calgary, Alberta, Husky Energy Inc. is a publicly
traded, integrated energy company. Selected fiscal year balance
sheet and income statement information for Husky Energy follow
(Canadian $ millions).
C$ millions | 2018 | 2017 |
---|---|---|
Revenues, net | $40,054 | |
Net income attributable to Husky | 2,623 | |
Pretax NNE | 425 | |
Operating assets | 58,016 | $54,400 |
Operating liabilities | 17,755 | 17,136 |
Equity attributable to Husky shareholders | 35,284 | 32,321 |
Tax rate | 20.00% |
a. Compute the 2018 return on equity (ROE) and the 2018
return on net operating assets (RNOA).
Note: Round percentages to two decimal places (for
example, enter 6.66% for 6.6555%).
2018 Return on equity: Answer%
2018 Return on net operating assets: Answer%
b. Disaggregate RNOA into net operating profit margin
(NOPM) and net operating asset turnover (NOAT).
Note: For NOPM and RNOA, round percentages to two
decimal places (for example, enter 6.66% for 6.6555%).
Note: For NOAT, round amount to three decimal
places (for example, enter 6.776 for 6.77555).
NOPM | x | NOAT | = | RNOA |
Answer | x | Answer | = | Answer |
c. Compute the percentage of RNOA to ROE, and compute
Husky’s nonoperating return for 2018.
Note: Round percentages to two decimal places (for
example, enter 6.66% for 6.6555%).
Percentage of RNOA to ROE: Answer%
Nonoperating return: Answer%
In: Accounting
Eye Trendy Corporation is a distributor of frames for sunglasses. The company’s controller is currently preparing a budget for the third quarter of the year. The following information is from company’s financial records: Projected Sales July 3,120 units August 2,000 units September 2,640 units October 3,000 units • Selling price is RM25 per unit • Collections from customers are normally 70 per cent in the month of sale, 20 per cent in the month following sale, and 9 per cent in the second month following the sale. The balance is expected to be uncollectible. Projected Purchases • Purchase price is RM18 per unit. • All frames purchases are on account. 70 per cent of the frames purchased are paid for in the month of purchase; the remaining 30 per cent are paid for in the month after acquisition. • Inventory of frames on 1st July is 1,200 units. The frames inventory at the end of each month equals 20 per cent of sales anticipated for the following month. • The company purchases the frames as needed in multiple quantities of 1,000 units per shipment. Operating Expenses • General and administrative expenses are projected to be RM33,000 for the quarter. The breakdown of these expenses is presented in the following schedule. All cash expenditures will be paid uniformly throughout the quarter: Promotion RM9,000 Insurance RM12,000 Utilities RM7,500 Depreciation RM4,500 Total RM33,000 Other information • Cash proceeds from sale of old equipment amounted to RM5,000 in the month of August. • Purchase of new equipment amounted to RM50,000 is to be made in the month of September. • Eye Trendy is expected to maintain a minimum cash balance of RM20,000 at all times. If the cash balance is less than RM20,000 at the end of each month, the company borrows amounts necessary to maintain this balance. All amounts are repaid out of the subsequent positive cash flow. • The company’s cash balance on 1st July is RM22,000. Required: a. Prepare the following schedules: (i) Expected cash collections for the sales of frames during the third quarter. Show computations by month and in total for the quarter. (ii) Expected Cash disbursements for the purchases of frames during the third quarter. Show computations by month and in total for the quarter. (iii) Expected Cash balance on 30th September. Show computations by month and in total for the quarter. b. Refer to your answer in requirement (a). Prepare a schedule that shows whether or not the company meets the minimum cash requirement and compute the amount of borrowing required, if any, to maintain the firm’s minimum cash balance. c. How can a company’s board of directors use the different types of budget to influence the future direction of the firm? You only answer point a.Please answer point b and c.
The answer for A is too long to be update here.You can check in search.
In: Accounting
Below is the assignment that I need to do and having a hard time finding the correct ratios like Gross Margin, EBITD, Price to cash flow etc.. from SEC EDGAR. I am comparing CVS Health and Walgreens 2018. Below is the question similar to mine that I found on the website. I am trying to figure out where can I find those ratios?
MBA 520 Module Two Activity Guidelines and Rubric
Overview: For this task, you will analyze the financial health of
two competitors in the same industry based on their ratios, using
the provided Excel spreadsheet template. Then, you will complete
your analysis by writing a short synopsis of your findings in the
space below the analysis.
Prompt: Follow the steps below to analyze the financial health of
two competitors. Use the Module Two Activity Template to complete
this task.
Select two companies operating in the same industry (for example,
Macy’s and Dillard’s). The companies have to be in the same
business for the ratios to be valuable to your analysis. Then,
complete the template, providing the following:
? Ratio Research: Use the template to analyze the selected ratios
(profitability, financial strength, valuation, management
effectiveness, dividends, and efficiency) for both of the
competitors. To complete this part, you can reference the
Morningstar website in the Module Two resources to obtain the
ratios. You can also use the SEC EDGAR Company Filings resource
from Module One to obtain the ratio from annual reports. Please
note: The ratios have to be from the same time period (the same
year for both competitors). For training on how to use Excel, visit
the Hoonuit training site or search YouTube to find appropriate
Excel training videos.
? Industry Ratios: To analyze ratios for the companies, you also
need to obtain the ratios for the industry that the competitors
operate in. Industry values for the ratios can be found in the
index column. If no index value is available, put the five-year
averages for both companies in the industry column and use these
figures for the industry comparison of your ratio analysis.
? Ratio Analysis: Compare the two companies based on their ratios.
Use the last column in the template to write in detail how each
company is doing based on the ratios. Compare the company ratios to
the industry and each other.
? Summary: This short write-up should be done directly in your
Excel spreadsheet.
o What is a ratio analysis? Briefly explain in about one paragraph.
Please quote your resource.
o Referring to the ratio analysis, in which company would you be
willing to invest and why?
Note: This is a theoretical exercise. You should not be investing
according to this analysis.
RATIOS | RETAIL | WALMART | TARGET | ANALYSIS |
Profitability Ratios (%) | ||||
Gross Margin | 25.37 | 25.82 | ||
EBITD Margin | 9.31 | 8.19 | ||
Operating Margin | 3.28 | 5.16 | ||
Pretax Margin | 2.18 | 5.07 | ||
Effective Tax Rate | 20.28 | 22.65 | ||
Financial Strength | ||||
Quick Ratio | 0.2 | 0.3 | ||
Current Ratio | 0.76 | 0.95 | ||
LT Debt to Equity | 0.46 | 96.65 | ||
Total Debt to Equity | 0.58 | 98.96 | ||
Interest Coverage | 12.35 | |||
Valuation Ratios | ||||
P/E Ratio | 26.94 | 14.71 | ||
Price to Sales (P/S) | 0.52 | 0.6 | ||
Price to Book (P/B) | 3.25 | 3.89 | ||
Price to Tangible Book | 4.19 | 3.89 | ||
Price to Cash Flow | 11.32 | |||
Price to Free Cash Flow | 9.26 | 7.07 | ||
Management Effectiveness (%) | 4.82 | 7.62 | ||
Return On Assets | 8.41 | 11.81 | ||
Return On Investment | 12.66 | 26.35 | ||
Return On Equity | ||||
Dividends | ||||
Dividend Yield | 2.5 | 3.09 | ||
Payout Ratio | 46.62 | |||
Efficiency | ||||
Revenue/Employee | 227,429 | 208,345 | ||
Net Income/Employee | 4,783 | 8,487 | ||
Receivable Turnover | 90.45 | 85.67 | ||
Inventory Turnover | 8.26 | 5.71 |
Asset Turnover | 2.46 | 1.88 |
Summary
Referring to your ratio analysis above, in which company would you be willing to invest, and why?
In: Accounting
Industry Segment |
External Customers |
Intersegment Sales |
Assets |
A |
80,000.00 |
310,000.00 |
|
B |
240,000.00 |
720,000.00 |
|
C |
20,000.00 |
20,000.00 |
120,000.00 |
D |
220,000.00 |
160,000.00 |
980,000.00 |
E |
20,000.00 |
75,000.00 |
270,000.00 |
Total |
580,000.00 |
255,000.00 |
2,400,000.00 |
1. Which of the operating segments would be considered reporting segments under the "revenue" test?
2. Which of the operating segments would be considered reporting segments under the "asset" test?
In: Accounting
Waterways Continuing Problem 12
At the end of June the manager of the B.C. manufacturing plant was provided with the following variance analysis report:
Budget | Actual | Variance | Favourable (F)/ Unfavourable (U) |
|||||
Production in units | 334,000 | 349,000 | 15,000 | F | ||||
Production costs: | ||||||||
Direct material | $694,720 | $707,184 | $(12,464) | U | ||||
Direct labour | 1,586,500 | 1,623,380 | (36,880) | U | ||||
Variable overhead costs | 133,600 | 138,869 | (5,269) | U | ||||
Fixed overhead costs | 200,400 | 195,845 | 4,555 | F | ||||
Total production costs | $2,615,220 | $2,665,278 | $(50,058) | U |
The manager immediately called the production supervisor, demanding
an explanation for the large unfavourable variance for the quarter.
The production supervisor was puzzled. He thought the cost-cutting
measures they had incorporated were beginning to work. He certainly
wasn’t expecting such a large discrepancy.
The standard rates the plant was using with its normal costing
system are summarized below.
Volume | Cost | |||||
Direct material | 1.30 | kg per unit | $1.60 | per kg | ||
Direct labour | 0.25 | hour per unit | $19.00 | per hour | ||
Predetermined overhead rate: | ||||||
Variable | 0.25 | hour per unit | $1.60 | per hour | ||
Fixed | 0.25 | hour per unit | $2.40 | per hour |
Other relevant information:
1. | A total of 461,000 kg of direct materials were purchased during the quarter at a cost of $1.80 per kilogram. | |
2. | A total of 441,990 kg of direct materials were used in production to manufacture 349,000 units. | |
3. | Payroll recorded 86,350 direct labour hours at an average cost of $18.80 per hour. |
Calculate the following production variances.
Material price variance | $ |
Neither favourable nor unfavourable/ Unfavourable/ Favourable |
|
Material quantity variance | $ |
Unfavourable/ Neither favourable nor unfavourable/ Favourable |
|
Labour price variance | $ |
Favourable/ Unfavourable/ Neither favourable nor unfavourable |
|
Labour efficiency variance | $ |
Neither favourable nor unfavourable/ Favourable/ Unfavourable |
|
Variable overhead variance | $ |
Favourable/ Neither favourable nor unfavourable/ Unfavourable |
In: Accounting
Lakeview Company completed the following two transactions. The annual accounting period ends December 31. |
a. |
On December 31, calculated the payroll, which indicates gross earnings for wages ($104,000), payroll deductions for income tax ($10,400), payroll deductions for FICA ($7,800), payroll deductions for American Cancer Society ($3,900), employer contributions for FICA (matching), and state and federal unemployment taxes ($780). Employees were paid in cash, but payments for the corresponding payroll deductions have not yet been made and employer taxes have not yet been recorded. |
b. |
Collected rent revenue of $6,450 on December 10 for office space that Lakeview rented to another business. The rent collected was for 30 days from December 12 to January 10 and was credited in full to Unearned Rent Revenue. |
Required: |
1& 2. | Complete the required journal entries for the above transactions as shown below: |
(i) Prepare the entries required on December 31 to record payroll. |
|
(ii) Prepare the journal entry for the collection of rent on December 10. | |
(iii) Prepare the adjusting journal entry on December 31. | |
(Do not round intermediate calculations. If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) |
3. |
Show how any liabilities related to these items should be reported on the company’s balance sheet at December 31. |
In: Accounting
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of earrings, but all are sold for the same price—$17 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):
January (actual) | 22,600 | June (budget) | 52,600 |
February (actual) | 28,600 | July (budget) | 32,600 |
March (actual) | 42,600 | August (budget) | 30,600 |
April (budget) | 67,600 | September (budget) | 27,600 |
May (budget) | 102,600 | ||
The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month.
Suppliers are paid $5.30 for a pair of earrings. One-half of a month’s purchases is paid for in the month of purchase; the other half is paid for in the following month. All sales are on credit. Only 20% of a month’s sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.
Monthly operating expenses for the company are given below:
Variable: | |||
Sales commissions | 4 | % of sales | |
Fixed: | |||
Advertising | $ | 330,000 | |
Rent | $ | 31,000 | |
Salaries | $ | 132,000 | |
Utilities | $ | 13,500 | |
Insurance | $ | 4,300 | |
Depreciation | $ | 27,000 | |
Insurance is paid on an annual basis, in November of each year.
The company plans to purchase $22,500 in new equipment during May and $53,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $24,750 each quarter, payable in the first month of the following quarter.
The company’s balance sheet as of March 31 is given below:
Assets | ||
Cash | $ | 87,000 |
Accounts receivable ($48,620 February sales; $579,360 March sales) | 627,980 | |
Inventory | 143,312 | |
Prepaid insurance | 27,500 | |
Property and equipment (net) | 1,080,000 | |
Total assets | $ | 1,965,792 |
Liabilities and Stockholders’ Equity | ||
Accounts payable | $ | 113,000 |
Dividends payable | 24,750 | |
Common stock | 1,060,000 | |
Retained earnings | 768,042 | |
Total liabilities and stockholders’ equity | $ | 1,965,792 |
The company maintains a minimum cash balance of $63,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month.
The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $63,000 in cash.
Required:
Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules:
1. a. A sales budget, by month and in total.
b. A schedule of expected cash collections, by month and in total.
c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total.
d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.
2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $63,000.
3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach.
4. A budgeted balance sheet as of June 30.
In: Accounting
Eagle Company | |||
Comparative Income Statements (000's omitted) | |||
For the Years Ended December 31, 20x8 and 20x7 | |||
20x8 | 20x7 | ||
Net Sales | $ 820 | $ 550 | |
Cost of Goods Sold | 374 | 278 | |
Gross Profit | 446 | 272 | |
Operating Expenses | 120 | 112 | |
Operating Income | 326 | 160 | |
Interest Expense | 34 | 16 | |
Income Before Income Taxes | 292 | 144 | |
Income Taxes | 37 | 30 | |
Net Income | $ 255 | $ 114 | |
Earnings Per Share | $ 10.20 | $ 4.56 | |
Eagle Company | |||
Comparative Balance Sheets (000's omitted) | |||
December 31, 20x8 and 20x7 | |||
Assets: | 12/31/20x8 | 12/31/20x7 | |
Current Assets | $ 134 | $ 130 | |
Property, Plant, and Equipment (net) | 840 | 510 | |
Total Assets | $ 974 | $ 640 | 600 |
Liabilities and Stockholders' Equity: | |||
Current Liabilities | 67 | 64 | |
Long-Term Liabilities | 260 | 85 | |
Total Liabilities | 327 | 149 | |
Stockholders' Equity | 647 | 491 | 500 |
Total Liabilities and Stockholders' Equity | $ 974 | $ 640 | |
Common Stock: | 20x8 | 20x7 | |
Market Price Per Share at 12/31 | $ 64.00 | $ 28.40 | |
Cash Dividends Per Share | $ 4.00 | $ 5.25 |
Debt Ratio: _____ (20x8) and ______ (20x7)
Times Interest Earned Ratio: _____ (20x8) and ______ (20x7)
Net Profit Margin Ratio: _____ (20x8) and ______ (20x7)
Gross Profit Ratio: _____ (20x8) and ______ (20x7)
Asset Turnover: _____ (20x8) and ______ (20x7)
Return on Assets: _____ (20x8) and ______ (20x7)
Return on Equity: _____ (20x8) and ______ (20x7)
Price/Earnings Ratio: _____ (20x8) and ______ (20x7)
Dividend Yield Ratio: _____ (20x8) and ______ (20x7)
In: Accounting
Woh Che Co. has four departments: materials, personnel, manufacturing, and packaging. In a recent month, the four departments incurred three shared indirect expenses. The amounts of these indirect expenses and the bases used to allocate them follow Indirect Expense Cost Allocation Base Supervision $ 84,500 Number of employees Utilities 70,000 Square feet occupied Insurance 32,500 Value of assets in use Total $ 187,000 Departmental data for the company’s recent reporting period follow Department Employees Square Feet Asset Values Materials 40 39,000 $ 12,000 Personnel 10 19,500 1,600 Manufacturing 84 107,250 47,200 Packaging 66 29,250 19,200 Total 200 195,000 $ 80,000 1. Use this information to allocate each of the three indirect expenses across the four departments. 2. Prepare a summary table that reports the indirect expenses assigned to each of the four departments.
In: Accounting
Jack Hammer Company completed the following transactions. The annual accounting period ends December 31. |
Apr. 30 |
Received $660,000 from Commerce Bank after signing a 12-month, 8.5 percent, promissory note. |
June 6 |
Purchased merchandise on account at a cost of $80,000. (Assume a perpetual inventory system.) |
July 15 | Paid for the June 6 purchase. |
Aug. 31 |
Signed a contract to provide security service to a small apartment complex and collected six months’ fees in advance amounting to $26,500. (Use an account called Unearned Revenue.) |
Dec. 31 |
Determined salary and wages of $45,000 were earned but not yet paid as of December 31 (ignore payroll taxes). |
Dec. 31 | Adjusted the accounts at year-end, relating to interest. |
Dec. 31 | Adjusted the accounts at year-end, relating to security service. |
Required: | |
1. |
For each listed transaction and related adjusting entry, indicate the accounts, amounts, and effects on the accounting equation. (Do not round intermediate calculations. Enter any decreases to account balances with a minus sign. Enter your answers in transaction order provided in the problem statement.) |
2. |
For each item, indicate whether the debt-to-assets ratio is increased or decreased or there is no change. (Assume Jack Hammer’s debt-to-assets ratio is less than 1.0.) (Enter your answers in transaction order provided in the problem statement.) |
In: Accounting
Price Increasing Rate: | |||
10% | |||
In: Accounting
Company Delta is trying to decide which of the two IT
systems to install. Syske 10 million euro and will increase
operating profits by 5 million euro per year. Its useful life is
five years. Because of rapid technological change, it will have no
salvage walue of this time. System 2 costs 15 million euro and will
increase operating profits by 8 million euro per year. Its useful
life also 5 years, it also will have no salvage value. For tax
purposes the company can depreciate either computer system on a
straight-line basis.
a) Suppose the company's tax rate is 40% and its cost of capital
for either IT system is 10 per cent.
Which system should it buy?
b) If no depreciation is allowed, which IT system is a better
choice?
In: Accounting