Questions
Please use the most recent data available for Home Depot. Thank you! *Excel not necessary if...

Please use the most recent data available for Home Depot. Thank you!

*Excel not necessary if you can't attach, a word doc is fine*

Data Case for Chapter 14:

Capital Structure in a Perfect Market You work in the corporate finance division of The Home Depot and your boss has asked you to review the firm’s capital structure. Specifically, your boss is considering changing the firm’s debt level. Your boss remembers something from his MBA program about capital structure being irrelevant, but isn’t quite sure what that means. You know that capital structure is irrelevant under the conditions of perfect markets and will demonstrate this point for your boss by showing that the weighted average cost of capital remains constant under various levels of debt. So, for now, suppose that capital markets are perfect as you prepare responses for your boss. You would like to analyze relatively modest changes to Home Depot’s capital structure. You would like to consider two scenarios: the firm issues $1 billion in new debt to repurchase stock, and the firm issues $1 billion in new stock to repurchase debt. Use Excel to answer the following questions using Eq. 14.5 and Eq. 14.6, and assuming a cost of unlevered equity (rU) of 12%.

1. Obtain the financial information you need for Home Depot.

a. Go to www.nasdaq.com, and under “Quotes and Research” click “Summary Quotes.” Enter Home Depot’s stock symbol (HD) and click “Go Now.” From the Stock Quote & Summary Data page, get the current stock price. Click “Stock Report” in the left column and find the number of shares outstanding.

b. Click “Income Statement” and the annual income statement should appear. Put the cursor in the middle of the statement, right-click your mouse, and select “Export to Microsoft Excel.” (You will not need the income statement until Chapter 15, but collect all of the background data in one step.) On the Web page, click the Balance Sheet tab. Export the balance sheet to Excel as well and then cut and paste the balance sheet to the same worksheet as the income statement.

c. To get the cost of debt for Home Depot, go to FINRA’s Bond Center (http://finra- markets.morningstar.com/BondCenter/). Select the “Corporate” option, enter Home Depot’s symbol, and click “Search.” The next page will contain information for all of Home Depot’s outstanding and recently matured bonds. Select the latest yield on an outstanding bond with the shortest remaining maturity (the maturity date is on the line describing each issue; sometimes the list also contains recently retired bonds, so make sure not to use one of those). For simplicity, since you are just trying to illustrate the main concepts for your boss, you may use the existing yield on the outstanding bond as rD.

2. Compute the market D/E ratio for Home Depot. Approximate the market value of debt by the book value of net debt; include both Long-Term Debt and Short-Term Debt/Current Portion of Long-Term Debt from the balance sheet and subtract any cash holdings. Use the stock price and number of shares outstanding to calculate the market value of equity.

3. Compute the cost of levered equity (rE) for Home Depot using their current market debt-to- equity ratio and Eq. 14.5.

4. Compute the current weighted average cost of capital (WACC) for Home Depot using Eq. 14.6 given their current debt-to-equity ratio.

5. Repeat Steps 3 and 4 for the two scenarios you would like to analyze, issuing $1 billion in debt to repurchase stock, and issuing $1 billion in stock to repurchase debt. (Although you realize that the cost of debt capital rDmay change with changes in leverage, for these modestly small changes you decide to assume that rDremains constant. We will explore the relation between changing leverage and changing rD more fully in Chapter 24.) What is the market D/E ratio in each of these cases?

6. Prepare a written explanation for your boss explaining the relationship between capital structure and the cost of capital in this exercise.

7. What implicit assumptions in this exercise generate the results found in Question 5? How might your results differ in the “real world”?

In: Finance

TWO MEANS – INDEPENDENT SAMPLESChoose a variable from the advising.sav data set to comparegroup...

TWO MEANS – INDEPENDENT SAMPLES

Choose a variable from the advising.sav data set to compare group means. While the choice of which variable to test is up to you, you must remember that it must be a metric variable. The grouping variable, which is used to define the two groups to be compared, must be categorical.   You can look in the “Measure” column of the “Variable View” in the data file for help in determining which is which. The managerial question is whether or not there is a significant difference between the groups for the metric variable you have chosen.

Once you have the results, report your findings using the five step hypothesis testing procedure outlined in class. (See below.)   For Step 4, simply cut and paste the SPSS output into the report. This can be done by clicking on the desired portion of the output which will then be highlighted, and then right clicking on the highlighted portion and copying it to your flash drive. (Note that you may want to drop the results into a word document immediately since if you do not have SPSS on your personal laptop, you will not be able to open any SPSS output.) Then state the answer to the managerial question that was initially posed. For example, is there a significant difference between the two groups defined by the grouping variable (which you must identify in your report) for the metric variable tested? Also, interpret the confidence interval provided for the test. Does it indicate a significant difference or not?   

PAIRED SAMPLE T-TEST

Choose a pair of metric variables and run a paired sample t-test on the pair. Again, these must be metric variables. The managerial question will be “Is there a significant difference between the two variables?” for the pair. Report your findings using the same procedure described above, including an interpretation of the confidence interval.

REPORT(SAMPLE)

Your report will consist of two hypotheses tests, (one for the independent sample test and one for the paired sample test). It will look something like this (for the independent sample test):

1: H0: μ1= μ2

Ha: μ1 ≠ μ2

2: Two group independent sample t-test (note that SPSS does everything as a t-test regardless of sample size).

3: α=.05 → tcrit = ±whatever the appropriate value is

4

Group Statistics

 

status

N

Mean

Std. Deviation

Std. Error Mean

dotest

0

185

1494.071

2249.4948

165.3861

1

50

803.280

1080.0304

152.7394

Independent Samples Test

 

Levene's Test for Equality of Variances

t-test for Equality of Means

F

Sig.

t

df

Sig. (2-tailed)

Mean Difference

Std. Error Difference

95% Confidence Interval of the Difference

Lower

Upper

dotest

Equal variances assumed

13.465

.000

2.104

233

.036

690.7914

328.2585

44.0572

1337.5255

Equal variances not assumed

   

3.068

169.287

.003

690.7914

225.1264

246.3747

1135.2080

5: Make a decision regarding the null hypothesis and interpret the confidence interval.

6: Answer the managerial question.

RESULTS AFTER RUNNING

INDEPENDENT

Group Statistics

 

Gender

N

Mean

Std. Deviation

Std. Error Mean

OverallSatisfaction

Female

131

4.97

1.771

.155

Male

145

4.99

1.488

.124

Independent Samples Test

 

Levene's Test for Equality of Variances

t-test for Equality of Means

F

Sig.

t

df

Sig. (2-tailed)

Mean Difference

Std. Error Difference

95% Confidence Interval of the Difference

Lower

Upper

OverallSatisfaction

Equal variances assumed

5.905

.016

-.120

274

.904

-.024

.196

-.410

.363

Equal variances not assumed

   

-.119

255.054

.905

-.024

.198

-.414

.366

PAIRED

Paired Samples Statistics

 

Mean

N

Std. Deviation

Std. Error Mean

Pair 1

DesiredConvenience

6.20

273

1.175

.071

ActualConvenience

4.55

273

1.636

.099

Paired Samples Correlations

 

N

Correlation

Sig.

Pair 1

DesiredConvenience & ActualConvenience

273

.213

.000

Paired Samples Test

 

Paired Differences

t

df

Sig. (2-tailed)

Mean

Std. Deviation

Std. Error Mean

95% Confidence Interval of the Difference

Lower

Upper

Pair 1

DesiredConvenience - ActualConvenience

1.648

1.799

.109

1.434

1.863

15.140

272

.000

 

In: Statistics and Probability

The ISO 9000 series of quality management systems standard has been widely applied all over the...

The ISO 9000 series of quality management systems standard has been widely applied all over the world since its introduction in 1987. By the end of 2013, ISO 9000 had been adopted by over 1,129,000 facilities in 189 countries. Both academics and practitioners are interested in understanding the relationship between adoption of ISO 9000, and other factors (Christmann & Taylor, 2006; Du, Yin, & Zhang, 2016; Fikru, 2014a, 2014b, 2016; Nakamura, Takahashi, & Vertinsky, 2001; Pekovic, 2010; Wu, Chu, & Liu, 2007).

In 2008, the National Bureau of Statistics of China conducted an Economic Census of the service firms. The descriptions of variables, the coding are shown in the table. The data is available in Moodle.

Table: Variables, their descriptions and coding

No

Variable name

Description of the variable

Coding

1

Year

Year the company certified

2004; 2005; 2006; 2007; 2008

2

Certification

Certification dummy

0= not certified; 1=certified

3

Industry2

Two digit industry code

58= storage and transportation;

60= telecommunication

61=computer service

62=software

74= business services

75= Research and Development

76= specialized technology services

77= technology exchange and promotion

5

Stpyear

Year of the founding of the company

6

I

Employee number

7

I_yjs

Number of employees with master or doctor

8

I_benke

Number of employees with bachelor

9

I_dz

Number of employees with diploma

10

I_gaozhong

Number of employees with high school education

11

I_chuzhong

Number of employees with junior high school or below

12

Revenue

Sales of the company

13

Profit_operation

Profit of the company

14

Ksum

Total asset of the company

15

Equity

Equity of the company

16

Kpaid

Total capital

17

Kstate

Capital from government

18

Koversea

Capital from overseas

19

Kother

Capital from other sources

20

ROS

Return on sales

21

ROA

Return on assets

22

FDIpercent

Percentage of overseas investment in the total investment

23

DFIdummy

Overseas investment dummy

24

agefirm

Age of the company

Required Task

You are expected to work in groups and write a research report. When you work on your report, you need to use the dataset, and other sources such as journal articles. If you use website material, please pay attention to the quality of the material (e.g. government website or industry website etc.). There is no word limit for the report. For the number of references, there should be at least ten academic sources (journal articles, or books). It is encouraged to use more relevant, high quality, and up to date sources in the report.

Students have a high degree of flexibility in doing the research. The important thing is that the research should be well connected with the literature.   

The required structure should be as following.

  1. Executive Summary: Major findings and major recommendations
  2. Introduction: Background (of the case); purpose (of this report); two to three research objectives for a study that you would seek to conduct; and format (of this report).
  3. Write a short literature review of at least ten academic sources relevant to your topic. Any source including books, journal articles are acceptable, as long as they are relevant. You can also use a particular website for some information. If websites are used they will be in addition of the ten academic sources.
  4. Describe the methodology and justify your choice.
  5. Analyses and findings: Run some analysis to turn the data into useful information as follows:
  1. Descriptive statistics: Sample characteristics will be described with descriptive analysis. This will include at least the following analysis: Frequency, percentage; Measures of central tendency; Measures of dispersion (variance, standard deviation)
  2. Inferential statistics: Inferential statistics will be used to analyse relationship between variables. This will include at least the following analysis (Chi-square, Pearson’s r, t-test, ANOVA test).
  1. Discussion and managerial advises: link your findings to extant literature. Advise the management about the usefulness of the findings.
  2. Limitations and directions for future research. Suggestions of how the research can be improved.
  3. Include a correctly constructed reference list of all sources used in the project, not just those used in the literature review section. Appendices also should be attached which will include all the analysis and graphs etc. that are not included in the body of the report.

In: Economics

Income statements and balance sheets follow for The New York Times Company. Refer to these financial...

Income statements and balance sheets follow for The New York Times Company. Refer to these financial statements to answer the requirements.

The New York Times Company

Consolidated Statements of Income

Fiscal year ended

(in thousands)

Dec. 29, 2016

Dec. 30, 2015

Revenues

Circulation

$ 880,543

$ 851,790

Advertising

580,732

638,709

Other

94,067

88,716

Total revenues

1,555,342

1,579,215

Production costs

Wages and benefits

363,051

354,516

Raw materials

72,325

77,176

Other

192,728

186,120

Total production costs

628,104

617,812

Selling, general and administrative costs

721,083

713,837

Depreciation and amortization

61,723

61,597

Total operating costs

1,410,910

1,393,246

Restructuring charge

14,804

0

Multiemployer pension plan withdrawal expense

6,730

9,055

Pension settlement charges

21,294

40,329

Early termination charge

0

0

Operating profit

101,604

136,585

Loss from joint ventures

(36,273)

(783)

Interest expense, net

34,805

39,050

Income from continuing operations before income taxes

30,526

96,752

Income tax expense/(benefit)

4,421

33,910

Income from continuing operations

26,105

62,842

Loss from discontinued operations, net of income taxes

(2,273)

0

Net income

23,832

62,842

Net loss attributable to the noncontrolling interest

5,236

404

Net income attributable to The New York Times Company common stockholders

$29,068

$63,246

Continued next page



The New York Times Company

Consolidated Balance Sheets

As of

(in thousands)

Dec. 29, 2016

Dec. 30, 2015

Cash and cash equivalents

$ 100,692

$ 105,776

Short-term investments

449,535

507,639

Accounts receivable, net

197,355

207,180

Prepaid assets

15,948

19,430

Other current assets

32,648

22,507

Total current assets

796,178

862,532

Long-term marketable securities

187,299

291,136

Investments in joint ventures

15,614

22,815

Property plant and equipment, net

596,743

632,439

Goodwill

134,517

109,085

Deferred income taxes

301,342

309,142

Miscellaneous assets

153,702

190,541

Total assets

$2,185,395

$2,417,690

Accounts payable

$   104,463

$    96,082

Accrued payroll and other related liabilities

96,463

98,256

Unexpired subscriptions

66,686

60,184

Current portion of long-term debt

0

188,377

Accrued expenses and other

131,125

120,686

Total current liabilities

398,737

563,585

Long-term debt and capital lease obligations

246,978

242,851

Pension benefits obligation

558,790

627,697

Postretirement benefits obligation

57,999

62,879

Other

78,647

92,223

Total other liabilities

942,414

1,025,650

Stockholders’ equity

Common stock of $0.10 par value

   Class A common stock

16,921

16,826

   Class B convertible stock

82

82

Additional paid-in capital

149,928

146,348

Retained earnings

1,331,911

1,328,744

Common stock held in treasury, at cost

(171,211)

(156,155)

Accumulated other comprehensive loss, net of tax

(479,816)

(509,094)

Total New York Times Company stockholders’ equity

847,815

826,751

Noncontrolling interest

(3,571)

1,704

Total stockholders’ equity

844,244

828,455

Total liabilities and stockholders’ equity

$2,185,395

$2,417,690

Continued next page

Required:

a. Compute net operating profit after tax (NOPAT) for 2016 and 2015. Compute net operating assets (NOA) for 2016 and 2015. Assume that combined federal and state statutory. Compute return on net operating assets (RNOA) for 2016 and 2015. Net operating assets are $397,299 thousand in 2014.

b. Compute return on common shareholders equity (ROE) for 2016 and 2015. Stockholders’ equity attributable to New York Times Company in 2014 is $726,328 thousand.

c. What is nonoperating return component of ROE for 2016 and 2015?

d.    Comment on the difference between ROE and RNOA. What inference do you draw from this comparison?

Please Show Work - Excel or Word Answer is Prefered.

2016

2015

EBIT

Tax Rate

Taxes

Net Operating Profit After Tax

Net Operating Asset Calculations

2016

2015

2014

Operating Assets

Total Assets (Cash + Short Term Inv. + Marketable Securities)

Operating Liabilities

Total Liabilities (Short Term + Long Term Notes)

NOA

Equity

Net Income

Return on NOA

ROE

In: Accounting

in Java please For this assignment you are to write a class that supports the addition...

in Java please

For this assignment you are to write a class that supports the addition of extra long integers, by using linked-lists. Longer than what is supported by Java's built-in data type, called long.

Your program will take in two strings, consisting of only digits, covert each of them to a linked-list that represents an integer version on that string. Then it will create a third linked-list that represents the sum of both of the linked lists. Lastly, it will print out the result of the sum.

Conceptual Example
For the string: "12", create a list: head->1->2->null
For the string: "34", create a list: head->3->4->null
Add the two lists to create a third list: head->4->6->null
print the resulting linked list as "46"
Where "->" represents a link.

Keep in mind that the conceptual example above is conceptual. It does suggest a certain implementation. However as you read on you will see that you have several options for implementing your solution. You need not use the suggested implementation above.

For this class you are to implement a minimum of three methods. They are:

  1. A method called makeSDList() that takes in a string, consisting only of digits, as an argument, and creates and returns a linked-link representation of the argument string.

    The method has the following header:

    SDList makeSDList(String s) { }

    where s is a string, and SDList is the class name of the linked list.  

  2. A method called addLists() that takes takes two lists, adds them together, and creates and returns a list that represents the sum of both argument lists.

    The method has the following header:

    SDList addLists(SDList c) { }

    wherec  linked-list of type SDList .

  3. A method called displayList() that takes takes a list, prints the value of each digit of the list.  

    The method has the following header:

    void displayList() { }

Programming Notes

  1. You need not add any methods you don't need.
  2. You can add any methods use wish.
  3. You can use any type of linked list like: singly-linked, doubly-linked, circular, etc.
  4. You can choose you own list implementation such-as with or without sentinels, with head and/or tail points, etc.
  5. Do not assume any maximum length for either addend.
  6. You can assume that an each addend is a least one digit long.
  7. You need not test for the null or empty string ("") cases.
  8. The addends need not be the same length.

Programming Rules:

  1. You are not allowed to change the signature of the three methods above.
  2. You are not allowed to use arrays or ArrayLists anywhere in your solution.
  3. You are not allowed to use any Java built-in (ADTs), such as Lists, Sets, Maps, Stacks, Queues, Deques, Trees, Graphs, Heaps, etc. Or make any class that inherits any of those ADTs.
  4. You are to create your own node and list class. For your node and list class you can use the code that was used in the book, video and lecture notes related to the node and lists class examples.
  5. You are only allowed to have one class for your nodes and one class for your lists.
  6. You are not allowed to use Java Generics.
  7. You can use any data type to represent the digits (in the node). However, each node must represent one and only one digit.
  8. If hard-coding detected in any part of your solution your score will be zero for the whole assignment.

Submission Rules:

1. Submit only one Homework5.java file for all test cases. The starter file is names Homework5a.java so you will need rename the file before you begin submitting your solution.

2. Anything submitted to Mimir is considered to be officially submitted to me and is considered to be 100% your work. Even if it is not your last planned submission.

3. Any extra testing code that you wrote and used to do your own testing should be deleted from the file that gets used in the final grading. I emphasize the word deleted. Commenting out code is not sufficient and not considered deleted. It must be completely removed. English comments written to explain your code are perfectly fine.

In: Computer Science

Case Study: Max Client Profile: “Max is a 12-year old boy whose father died about 5...

Case Study: Max

Client Profile: “Max is a 12-year old boy whose father died about 5 years ago. His father experienced periodic episodes of depression during his lifetime. After his father’s death, Max displayed tantrums and became more aggressive toward his toys and people. He took on a serious, almost sad expression. He seemed empty and alone, even when in a room full of people. Max saw a therapist; after a period of play therapy, he stopped being more aggressive than boys his age, began to smile and played with peers.”

            “Max’s mother went to work after his father’s death; she now works two jobs. When she is home, she is authoritarian in her parenting style. Recently, Max’s mother snooped around Max’s room and found some morbid pictures that he had drawn (i.e., pictures of funerals, cemeteries, and people being shot or knifed to death). She also found cigarettes; as a consequence, he cannot have any friends visit and he may not leave the house except to go to school.”

            Max is not turning in schoolwork and is picking fights at school. In the evening, he plays video games and makes excuses for procrastinating with his homework. He lies awake at night worrying about his homework and things such as failing school, disappointing his mother, not having friends, and wondering if everyone hates him. When his mother tells him he is going to fail school, he responds, ‘I don’t care.’”

            The school nurse notices Max’s behavior and becomes concerned, especially since two other students recently attempted suicide. She shares this information with Max’s mother and suggests that a health care provider see Max. His mother takes him to a sliding-fee-scale clinic where a family practice health care provider who volunteers at the clinic sees Max. The health care provider identifies depression as a problem, considers putting Max on medication, but decides instead to have him admitted to a residential treatment center for evaluation and treatment. A clinic social worker finds funding from various sources to cover the cost of treatment at the facility for children and adolescents. The facility has child and adolescent psychiatrists and psychiatric nurses on staff.” [Richardson, B.K. (2007). Case Study Series: Psychiatric Nursing, Clifton Park, NY: Thomson Delmar Learning.]

Case Study: The nurse on the children’s unit of the residential treatment center receives word Max will be admitted for treatment of depression. When Max and his mother arrive, the nurse does an intake interview with Max alone and then with both Max and his mother. Then the nurse interviews his mother and gives her a copy of the parent handbook while someone orients Max to the unit and its rules. Both Max and his mother are asked to sign a form indicating they have read the unit rules and will abide by them. Max’s belongings are inventoried; some are locked up, while he is permitted to keep others. The child psychiatrist prescribes fluoxetine (Prozac) as well as individual and group therapy.

            One night, Max gets irritable with the nurse for not letting him stay up past unit bedtime to watch his favorite television show. Max says, “It doesn’t matter because I am just going to kill myself tonight anyway.” The psychiatrist is notified and writes orders for Max to be placed on 1 to 1 observation within eyesight of an assigned staff member at all times. The following day Max learns he cannot go to the recreation building because a unit rule states, “Anyone who threatens to kill himself or herself cannot leave the unit until he or she no longer wishes to kill himself or herself and 24 hours have passed.” Max tells the nurse, “I was just kidding. I really wasn’t going to kill myself.”

Questions

1. Max’s mother tells you (the nurse) about the 2 other students at Max’s school who attempted suicide recently. How should you respond?

2.What data would you gather on Max and his family prior to writing a nursing care plan?

In: Nursing

Point-of-sale (POS) system is used in Fiesta, a local supermarket. The supermarket maintains no credit sales;...

Point-of-sale (POS) system is used in Fiesta, a local supermarket. The supermarket maintains no credit sales; all transactions are paid using cash or credit/debit cards. The inventories are kept on the supermarket’s shelves. Customers pick the items they wish to buy and carry them to the checkout counter where the transaction begins.

First, the checkout clerk scans the bar codes printed on the items with a scanner. The scanner, which is the primary input device in the POS system, is mounted on the checkout counter. The POS system is connected online to the supermarket’s inventory file from which it retrieves price data. The price for each item is displayed on screen for customer’s checking. The quantity-on- hand figure in the inventory file is reduced in real time to reflect the item being sold. As an inventory item falls to a pre-determined level, it is reordered automatically by the system. When all the items are scanned at the checkout counter, the POS system calculates discounts and total for the sale transaction. A record of the sales transaction is stored in the POS system.

In case of credit card payment, the checkout clerk inserts the credit card into a small machine which is connected to the credit card issuer via electronic connection. Through this process, the clerk can determine whether the credit card is valid or not. When the checking is finished, the machine generates a credit card receipt on which the customer signs if the transaction exceeds certain dollar amounts. In case of signed receipt, the clerk compares the signature to the one signed at the back of the credit card to ensure the two signatures match with each other. The clerk gives the customer a copy of the receipt and secures a second copy in a drawer of the POS system. Similar steps follow for debit card (e.g. Octopus card) transaction, except customer signature is not required. For cash sales, the checkout clerk secures the cash in the drawer. The cash sale is recorded on a two-part paper receipt. One copy is given to the customer as a receipt, the other copy is secured within the POS system. The POS system records the types of payments (e.g. cash, credit card, etc.) made by customers for all sales transactions.

At the end of the checkout clerk’s work shift, a supervisor unlocks the drawer and retrieves all the cash and paper receipts. The drawer is removed and replaced with a new drawer containing a known amount of start-up cash for the next clerk. The supervisor and the checkout clerk take the cash and paper receipts to the treasury department. A cash receipts clerk in the treasury department reconciles the cash and paper receipts against the data stored inside the POS system.

Often, small discrepancies exist because of errors in giving change to customers. The supermarket’s policy specifies that cash shortages below certain small amount is recorded but not deducted from the checkout clerk’s salary. Cash shortages above that small amount, however, should be reviewed for possible disciplinary action.

When the cash and paper receipts have been reconciled to the POS system’s record, the cash receipts clerk prepares a cash reconciliation form and gives one copy to the checkout clerk as a receipt for cash remitted. The cash receipts clerk records the cash received and cash short/over in a cash receipts journal. The cash receipts clerk files the credit/debit card receipts and secures the cash in a safe for deposit at a local bank the next working day. At that time, the cash receipts clerk prepares a three-part deposit slip for the total amount of the cash deposited. One copy is filed, and the other two copies are taken to the bank together with the cash.

Required:

Answer the following questions. Observe the word limit as stated in the answer booklet.

a. What revenue cycle process in a level 0 data flow diagram is discussed most in the case?

b. Identify one automated control used by the supermarket to avoid uncollectible amount.

c. What is the name of the data file that must be kept accurate in order to avoid customer dissatisfaction at the checkout counter?

d. What is the manual control procedure to ensure the data file in part c is accurate?

e. What kind of control measure that is used by the supermarket to ensure their sales data input is accurate?

f. Identify one control weakness at the supermarket.

g. How to correct the control weakness as identified in part f?

In: Accounting

In order to complete your case analysis successfully, you should consider identifying the role you are...

In order to complete your case analysis successfully, you should consider


identifying the role you are playing,


assessing the financial reporting landscape considering the user needs, constraints, and business environment,


identifying the issues,


analyzing the issues (qualitatively and quantitatively), and


providing a recommendation for each issue identified in the case.

You are required to prepare for the case before the class and bring any documents that will support your analysis. An average grade will come from you answering questions with basic coverage and accuracy, showing all your preparation. Additional points come from including greater detail, astute and informed commentary where appropriate, and connections to readings and other content.

Respond in a single Word doc (or comparable text editor).

Investment Decisions for Big Spenders Inc.

Background

You are an Analyst for the professional service firm, FINACC LLP. Your firm specializes in providing a wide variety of internal business solutions for different clients. It is your first day on the job and a Manager in the Consulting area asks you for some help with an investment decision for one of your large clients, Big Spenders Inc. Ready to make an impression on your first day, you start reading the background information provided by the Manager.

Additional Information

Big Spenders Inc. has been working on diversifying its portfolio of investments and requires accounting advice for a decision between two car cleaning and detailing companies. Your responsibility is to perform a comparative analysis of the profitability of two potential equity investments. Your engagement manager on this job has given you a brief background on the operations of the two companies:

Auto Wash Bot Ltd. (AWBL) has recently completed the research and development of a new touch screen app for all mobile devices. This new technology is both more user friendly than the current technology on the market. Auto Wash Bot Ltd has just signed a major contract to provide the Auto Wash Bot terminal to a major producer of mobile devices. The founder of the business would like to sell a 50% interest in the business for $100,000 in order to finance further expansion of operations.

Popeye’s Muscle Wash Ltd (PMWL) is a self-service, coin operated car wash located in a busy residential area. The company provides all of the services of a typical car wash, including soap, wax, vacuuming as well as pressure washing. PMWL has been long established and enjoys the loyalty and repeat business of many local residents. The current owner is getting up in age and would like to sell 100% ownership interest in the business for $100,000 to pursue retirement. The current year’s income statement is consistent with prior years.

One of the first tasks in the analysis of the potential equity acquisition is an assessment of each company’s current and future profitability. Your manager has provided you with copies of each company’s income statement (see below). Next, you are to calculate the expected return on the investment for each company. You have been asked to discuss any other issues that you believe are relevant to the investment decision.

The Consulting Manager would like you to prepare the report and have it on his desk for review first thing tomorrow morning. Once reviewed, this report will be submitted to Big Spenders Inc. in order to support their decision.

Auto Wash Bot Ltd.

Income Statement

For the Year Ended December 31, 2015


Revenue
$375,000
Cost of Goods Sold
86,250
     Gross Profit
288,750
Other Expenses

   Advertising
35,400
   Office Expense
22,750
   Research
195,000
   Wages and Salaries
40,000
      Total Other Expenses
293,150
Income Before Taxes
(4,400)
   Income Tax
0
Net Income
$(4,400)


Popeye’s Muscle Wash Ltd

Income Statement

For the Year Ended December 31, 2015


Revenue
$375,000
Cost of Goods Sold
163,125
     Gross Profit
211,875
Other Expenses

   Advertising
5,200
   Office Expense
17,400
   Repairs and Maintenance
85,000
   Wages and Salaries
50,000
      Total Other Expenses
157,600
Income Before Taxes
54,275
   Income Tax*
8,413
Net Income
$45,862

                                            

*Tax rate of 15.5% used.

Note to students: Issues are hidden within the case. It is your responsibility to read the case facts and identify the critical issues required for discussion and analysis.

In: Accounting

Task Internal Audit Must Embrace Change or Sink Like a Stone On March 21, 2019 By...

Task
Internal Audit Must Embrace Change or Sink Like a Stone
On March 21, 2019 By Jason Mefford
Here’s a list of the internal audit challenges that present threats to the profession or cause
sleepless nights for some CAEs. While it’s hardly a comprehensive list, it includes some of the
changes and trends that we internal auditors simply can’t ignore.
Speed of Technology: Changing business models from technological advances are disrupting
traditional organizations and just may be the existential threat to internal audit. Deeper knowledge
and skills related to new technology used throughout the organization are needed, as well as
understanding and adoption of technology tools for performing audits, such as robotic process
automation (RPA), artificial intelligence (AI), and advanced analytics. As Karl Stingily, CAE of
Caesars Entertainment said, “every auditor needs to have a basic understanding of IT, as it is
embedded in every audit that we perform.”
Cybersecurity: Cybersecurity is a critical issue for nearly all boards and senior managers, and,
whether you know it or not, they are looking to internal audit to make sure everything is “OK.”
Since cybersecurity is such a broad topic, and little direction is given on what internal audit is
expected to do, scoping engagements is difficult.
Downgrades to the CAE Position: Some organizations are pushing down the CAE position from
vice-president to director or from director to manager, leaving internal audit to report lower in the
organizational hierarchy. This is bad news if internal audit is to maintain influence in the
organization. This harsh reality increases the need for internal audit to demonstrate value to senior
management and the board, audit what matters most, and simply make the case for internal audit
by achieving more “wins.”
More Specialization: Increased technical and business skills are needed in internal audit, leading
to the death of the general auditor. Internal audit departments will likely see more experienced,
technically savvy auditors making up most of the department.
Serving Two Masters: Internal audit has always had some challenge serving both the board and
senior management—two groups that are not always aligned—and pull internal audit in different
directions. The challenges around independence are real.
Talent Acquisition: Finding enough people to fill open positions and finding people with the
right skills is a challenge in the current tight job market and could be for some time. CAEs will
need to be more creative, looking for candidates with non-traditional audit backgrounds and
relying more on “guest auditors” to fill the gaps.
Talent Development: Training current employees in technical and soft-skills is a constant
challenge for CAEs. And soft-skills, such as communication and emotional intelligence, are more
important than ever. Auditors who can do the work, but have difficulty communicating the
results, will find themselves out of a job.
Constant Justification: Nobody seems to care that last year you saved the organization millions
of dollars. The “what have you done for me lately?” mentality requires CAEs to constantly justify
their value to the organization, some of which is cost and risk avoidance that is difficult to
calculate and quantify to the chief financial officer. Yet CAEs will need to prove return on
investment to the organization or risk getting outsourced.
Sarbanes-Oxley: Immediately after the passage of the Sarbanes-Oxley Act (SOX) internal audit
spent an inordinate amount of time doing lower-level work around SOX compliance. Over time,
some of that work transitioned to others in the organization, but new requirements from the
PCAOB, which have led to shifting expectations of the board and senior management, means
internal audit is being pulled back, kicking and screaming, into SOX compliance work.
Jason Mefford, 21 March 2019, Internal Audit Must Embrace Change or Sink Like a Stone,
Internal Audit 360, viewed 23 March 2019, â€čhttps://internalaudit360.com/internal-audit-must-
embrace-change-or-sink-like-a-stone/â€ș
..........................................
1. Above article is about the changes and trends that are challenges encountered by internal auditors. You are required to critically evaluate the challenges faced by internal auditors.(Word limit – 700 words) and please support your answer by quoting practical instances. Please

In: Accounting

CVP and Break-Even Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship...

CVP and Break-Even Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship between price, costs, and break-even points in terms of units and dollars. Use the results to answer questions about your findings. Scenario: Phonetronix is a small manufacturer of telephone and communications devices. Recently, company management decided to investigate the profitability of cellular phone production. They have three different proposals to evaluate. Under all the proposals, the fixed costs for the new phone would be $110,000. Under proposal A, the selling price of the new phone would be $99 and the variable cost per unit would be $55. Under proposal B, the selling price of the phone would be $129 and the variable cost would remain the same. Under proposal C, the selling price would be $99 and the variable cost would be $49. When you have completed your spreadsheet, answer the following questions: 1. What are the break-even points in units and dollars under proposal A? 2. How did the increased selling price under proposal B impact the break-even points in units and dollars compared to the break-even points calculated under proposal A? 3. Why did the change in variable cost under proposal C not impact the break-even points in units and dollars as significantly as proposal B did? Step-by-Step: 1. Open a new Excel spreadsheet. 2. In column A, create a bold-faced heading that contains the following: Row 1: Chapter 2 Decision Guideline Row 2: Phonetronix Row 3: Cost-Volume-Profit (CVP) Analysis Row 4: Today’s Date 3. Merge and center the four heading rows across columns A through D. 4. In Row 7, create the following bold-faced, right-justified column headings: Column B: Proposal A Column C: Proposal B Column D: Proposal C Note: Adjust cell widths when necessary as you work. 5. In Column A, create the following row headings: Row 8: Selling price Row 9: Variable cost Row 10: Contribution margin Row 11: Contribution margin ratio Skip a row Row 13: Fixed cost Skip a row Row 15: Break-even in units Skip a row Row 17: Break-even in dollars 6. Use the scenario data to fill in the selling price, variable cost, and fixed cost amounts for the three proposals. 7. Use the appropriate formulas from this chapter to calculate contribution margin, contribution margin ratio, break-even in units, and break-even in dollars. 8. Format all amounts as: Number tab: Category: Currency Decimal places: 0 Symbol: None Negative numbers: Red with parenthesis 9. Change the format of the selling price, contribution margin, fixed cost, and break-even in dollars amounts to display a dollar symbol. 10. Change the format of both contribution margin headings to display as indented: Alignment tab: Horizontal: Left (Indent) Indent: 1 11. Change the format of the contribution margin amount cells to display a top border, using the default line style. Border tab: Icon: Top Border 12. Change the format of the contribution margin ratio amounts to display as a percentagewith two decimal places. Number tab: Category: Percentage Decimal places: 2 13. Change the format of all break-even headings and amounts to display as bold-faced. 14. Activate the ability to use heading names in formulas under Tools ? Options: Calculation tab: Check the box: Accept labels in formulas 15. Replace the cell-based formulas with “word-based” equivalents for each formula used in Proposal A. Example: Contribution margin for proposal B would be: = (‘Selling price’ ‘Proposal B’) - (‘Variable cost’ ‘Proposal B’) Note: The tic marks used in the example help avoid naming errors caused by data having similar titles (i.e., “contribution margin” and “contribution margin ratio”). The parentheses help clarify group. 16. Save your work to a disk, and print a copy for your files.

In: Accounting