| Financial data for Stirling, Inc., for last year are as follows: |
|
Stirling, Inc. Balance Sheet |
||||
|
Beginning Balance |
Ending Balance |
|||
| Assets | ||||
| Cash | $ | 156,000 | $ | 153,000 |
| Accounts receivable | 385,000 | 529,000 | ||
| Inventory | 631,000 | 546,000 | ||
| Plant and equipment, net | 976,000 | 960,000 | ||
| Investment in Brier Company | 456,000 | 480,000 | ||
| Land (undeveloped) | 280,000 | 284,000 | ||
| Total assets | $ | 2,884,000 | $ | 2,952,000 |
| Liabilities and Stockholders' Equity | ||||
| Accounts payable | $ | 432,000 | $ | 390,000 |
| Long-term debt | 1,093,000 | 1,093,000 | ||
| Stockholders' equity | 1,359,000 | 1,469,000 | ||
| Total liabilities and stockholders' equity | $ | 2,884,000 | $ | 2,952,000 |
|
Stirling, Inc. Income Statement |
|||
| Sales | $ | 6,084,000 | |
| Operating expenses | 5,095,520 | ||
| Net operating income | 988,480 | ||
| Interest and taxes: | |||
| Interest expense | $ 181,000 | ||
| Tax expense | 260,000 | 441,000 | |
| Net income | $ | 547,480 | |
| The company paid dividends of $284,480 last year. The "Investment in Brier Company" on the balance sheet represents an investment in the stock of another company. |
| Required: | |
| 1. |
Compute the company’s margin, turnover, and return on investment (ROI) for last year. (Do not round intermediate calculations. Round your Turnover answer to 2 decimal places. Round your Margin and ROI percentage answers to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) |
}""":ontiipcres_dab"t},:{2"_6,"0]:[7"_6,"llnu":51"_l,ul:n6"_2,"{}":32"_e,lsfa":42"_1,:-0"_5,"-1":24"_1,:-1"_3,":05""_0,":_4,"seal:f8"_4,"llnu":37"_],1}20":77"_8,12":34"_[{":23"_e,ru:t5"_4,"1"leit%20Tew"N":mena,"}]seal:f7"_4,":34"_5,"[]":33"_},0""2":c2,"9""7":c1,"0""6":c0{"":19"_},3""2":"3",23:"2","3""2":"1",23:"0"{"":59"_],}]"}:"7""_},N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_","%25":75"_:{0"_3{"":_2{"":20"_,{}}3"_rc1l_el_ce0blta0_:"8"_3,"t"ghRilety%20sseonspre:"7""_},t"ghri:"8"_6,"uetr":43"_",ONTILUSO:"6"_7{"":55"_},2}":53"_2,":21"_e,ru:t3"_6{"":55"_",ICERUM"N":73"_:{9"_2,"}}""":79"_",)~37z("~":75"_:{6"_5,""}:"9"_7,"""":75"_:{0"_3{"":_2{"":20"_,{}}""":_7,""}ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"I"RO:"5"_7{"":30"_:{2""_:{0"_2{",[}]"}:"7""_},N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_",:"5"_7{"":30"_:{2""_:{0"_2{"},"}r21__cllce0_leab_t"0":38"_",ermbNulety%20shtigeRylste%20nspoes"r":_7,""}htig"r":68"_e,ru:t3"_4,"N"IOUTOL"S":76"_:{5"_5,"}}:23"_5,":21"_2,"uetr":63"_:{5"_5,"C"RIMENU:"3"_7{"":29"_},"}:"9"_7,"~"6)(3~z:"5"_7{"":56"_},""":79"_",:"5"_7{"":30"_:{2""_:{0"_2{"},"}:"7""_},N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_",erovrnTu:"5"_7{"":30"_:{2""_:{0"_2{",[}]"}:"7""_},N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_","%25":75"_:{0"_3{"":_2{"":20"_,{}}t"ghRilety%20sseonspre:"7""_",r11__cllce0_leab_t"0":38"_},t"ghri:"8"_6,"uetr":43"_",ONTILUSO:"6"_7{"":55"_},2}":53"_2,":21"_e,ru:t3"_6{"":55"_",ICERUM"N":73"_:{9"_2,"}}""":79"_",)~35z("~":75"_:{6"_5,""}:"9"_7,"""":75"_:{0"_3{"":_2{"":20"_,{}}""":_7,""}ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"n"giar"M":75"_:{0"_3{"":_2{"":20"_[{],}}""":_7,"%3B"neno:%20ayplis%20d)%3B11%2023,16,%2037(1gb%20rr:locod-unrokgac"b":_8,""}_2"0":78"_",1)21,%2063%2017,13b(rg:"9""_",ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"""":75"_:{0"_3{"":_2{"":20"_,{}}""":_7,"%3B"neno:%20ayplis%20d)%3B11%2023,16,%2037(1gb%20rr:locod-unrokgac"b":_8,""}_1"0":78"_",1)21,%2063%2017,13b(rg:"9""_",ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"""":75"_:{0"_3{"":_2{"":20"_,{}}""":_7,"%3B"1)21,%2063%2017,13b(rg:%20orol-cndougrckba:"8""_3,":16"_},0"0_:"8"_7,")"11%2023,16,%2037(1gb"r":_9,"N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_",:"5"_7{"":30"_:{2""_:{0"_2{"[[":13"_e,lsfa":41"_},n"owpDro"d":27"_1,:-5"_2,"{}":75"_e,lsfa":82"_:{8"_2,"""":22"_e,lsfa":35"_e,ru:t6"_3,"{}":55"_",leab%20TedtltiUn:"9"_6,":37"_1,":48"_5{":[5"_6{"
| 2. |
The board of directors of Stirling, Inc., has set a minimum required return of 14%. What was the company’s residual income last year? |
Answer- 1)- Margin – (Net operating income /Sales)*100
= ($988480/$6084000)*100
= 16.25%
Turnover = Sales/ Average operating assets
= $6084000/$2168000
=2.81
Return on investment = Margin*Turnover
= 16.25%*2.81
= 45.66%
Explanation- Calculation of average operating assets = (Opening operating assets+ Closing operating assets)/2
=($156000+$385000+$631000+$976000)+($153000+$529000+$546000+$960000)/2
= ($2148000+$2188000)/2
=$2168000
Operating assets = Cash+ Accounts receivable+ Inventory+ Plant & equipment, net
2)- Residual income for the last year = $684960.
Explanation-
Residual income =Operating income –(Average operating assets*Required rate of return)
= $988480-($2168000*14%)
= $988480-$303520
= $684960
Financial data for Stirling, Inc., for last year are as follows: Stirling, Inc. Balance Sheet Beginning...
Final Project For this assignment, use data from W1 Assignment. Using Minitab. Give instructions on how to insert data into Minitab. This week, you will explore the hypothesis that higher levels of stress are associated with lower levels of confidence. Compute the correlation between the stress score and confidence scores. StressScore Confidence 3 100 5 112 2 125 9 150 7 136 4 107 3 143 1 141 4 134 2 148 5 139 3 117 7 76 8 99...
Question 1: Compute the linear regression
equation (coefficients) between the “year” variable and the
“temperature” variable. In other words, the dependent variable will
be the temperature and the independent variable will be “year”
variable. Write down the equation, the correlation coefficient
R and the standard error.
Question 2.
a. Has the annual temperature trend given by
the regression line increased or decreased? Hint: Which of the
regression line coefficients expresses whether the linear
relationship between temperature and time (in years)...
1. The data set on sheet #1 gives data on GPA category and number of hours studied. Construct comparative box plots of the data first GPA category. Then conduct two-sample t-test on the data for whether GPA category influences the number of hours studied. Be prepared to explain the results of the test and the meaning of the boxplots and how they relate to each other. Then redo the analysis by replacing the ordinal GPA category with a numerical dummy...
Written in expanded form, the usual factorial function is n! = n middot (n - 1) middot (n - 2) ... 3 middot 2 middot 2 middot 1. The difference between elements in the product is always 1. It can be writ in recursive form as n! = n middot (n - 1)! (e.g., 10! = 10 middot 9!, 23! * 23 middot 22!, 4! = 4 3!, etc.). The purpose of this problem is to generalize the factorial function...
Use the Tornadoes Data and your statistical expertise to answer the questions: Is it reasonable to claim that the average number of observed tornadoes per year is different from the average number of tornado related deaths per year? 5. What test/procedure did you perform? a. One-sided t-test b. Two-sided t-test c. Regression d. Confidence interval 6. What is the P-Value/margin of error? a. 0.007034504 b. 0.34922 c. 4.07497E-24 d. 2.03749E-24 e. None of these 7. Statistical Interpretation a. Since P-value...
The index of biotic integrity (IBI) is a measure of the water quality in streams. II and land-use measures for a collection of streams in the Ozark Highland ecoregion of Arkansas were collected as part of a study The data table below gives the data for 11, the percent of the watershed that was forest, and the area of the watershed in square kilometers for streams in the original sample with watershed are less than or equal to 70km? Area...
Write a C program to assign natural numbers 1 to 100 into a one-dimensional integer array. Display all the values in the array on the screen. For each number in the array, determine if the number contains digit 7 or is divisible by 7. Display all those numbers on the screen. Original array: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27...
Financial data for Joel de Paris, Inc., for last year follow: Doel de Paris, Inc. Balance Sheet Beginning Balance Ending Balance Assets Cash Accounts receivable Inventory Plant and equipment, net Investment in Buisson, 5.A. Land (undeveloped) Total assets Liabilities and Stockholders' Equity Accounts payable Long-term debt Stockholders. equity Total liabilities and stockholders' equity 130,000 349,000 570,000 791,000 405,000 247,000 $ 2,492,000 $ 138,000 489,000 472,000 781,000 434 000 247,000 $2,561,000 388,000 1,948,000 1,056,000 $ 2,492,000 $ 338,000 1,948,000 1, 175,000...
Is it reasonable to claim that the average number of observed tornadoes per year is different from the average number of tornado related deaths per year? 5. What test/procedure did you perform? a. One-sided t-test b. Two-sided t-test c. Regression d. Confidence interval 6. What is the P-Value/margin of error? a. 0.007034504 b. 0.34922 c. 4.07497E-24 d. 2.03749E-24 e. None of these 7. Statistical Interpretation a. Since P-value is very small we are confident that the number of tornadoes will...
32 Chapter 2 Summarizing Data: Listing and Grouping 2.3 The following are the grades that 50 students obtained on an accounting test: 73 65 82 70 45 50 70 54 32 75 75 67 65 60 75 87 83 40 72 64 58 75 89 70 73 55 61 78 89 93 43 51 59 38 65 71 75 85 65 85 49 97 55 60 76 75 69 35 45 63 Prepare a stem-and-leaf display of these values. Use...