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 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 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.
In: Economics
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 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:
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.
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 .
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
Programming Rules:
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 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; 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 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 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 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