Silver Cloud Computing is a company that provides cloud computing services. The company commenced operations on March 1, 2016. It acquired financing from the issuance of common stock for $40,000,000 and issuance of 4% bonds that mature in 2026 for $30,000,000. The income statements and balance sheets for the first two years are provided in a separate Excel spreadsheet. All amounts are in thousands.
Required:
The Chief Executive Officer (CEO) is interested in increasing sales and decreasing expenses. You have been requested to prepare a report that provides analysis of the financial statements and recommendations to improve the financial performance of the company. Your report should include the following items:
Calculate the following ratios and provide an analysis of the company based on the ratios: (Show Work)
Return on Equity=
PPE Turnover=
Total Liabilities to Equity=
Times Interest Earned=
|
SILVER CLOUD COMPUTING |
||||
| Income Statements | ||||
| For the Years Ended February 28, 2018 and 2017 | ||||
| fye 2/28/2018 | fye 2/28/2017 | |||
| (in thousands) | (in thousands) | |||
| Sales | $225,000 | $200,000 | ||
| Sales Discounts | 3,375 | 2,500 | ||
| Net Sales | 221,625 | 197,500 | ||
| Wages and Salaries | 73,500 | 70,000 | ||
| Bad Debt Expense | 2,100 | 2,000 | ||
| Depreciation | 20,000 | 20,000 | ||
| Marketing Expense | 33,750 | 30,000 | ||
| Occupancy Expense | 54,000 | 54,000 | ||
| Research & Development | 22,500 | 20,000 | ||
| Total Expenses | 205,850 | 196,000 | ||
| Income from Operations | 15,775 | 1,500 | ||
| Interest Expense | 1,200 | 1,200 | ||
| Income Before Taxes | 14,575 | 300 | ||
| Income Taxes (40%) | 5,830 | 120 | ||
| Net Income | $8,745 |
$180 |
|
SILVER CLOUD COMPUTING |
|||||||
| Balance Sheets | |||||||
| February 28, 2018 and 2017 and February 29, 2016 | |||||||
| At Inception | |||||||
| Feb 28 2018 | Feb 28 2017 | Feb 29 2016 | |||||
| (in thousands) | (in thousands) | (in thousands) | |||||
| Cash | $55,755 | $22,300.00 | $10,000 | ||||
| Accounts Receivable | 18,000 | 16,000 | - | ||||
| Net Computer Equipment | 20,000 | 40,000 | 60,000 | ||||
| Total Assets | $93,755 | $78,300 | $70,000 | ||||
| Accounts Payable | $9,000 | $8,000 | $- | ||||
| Taxes Payable | 5,830 | 120 | - | ||||
| Long-term Debt | 30,000 | 30,000 | 30,000 | ||||
| Common Stock | 40,000 | 40,000 | 40,000 | ||||
| Retained Earnings | 8,925 | 180 | - | ||||
| Total Liabilities & Stockholders Equity | $93,755 | $78,300 |
$70,000 |
In: Accounting
Silver Cloud Computing is a company that provides cloud computing services. The company commenced operations on March 1, 2016. It acquired financing from the issuance of common stock for $40,000,000 and issuance of 4% bonds that mature in 2026 for $30,000,000. The income statements and balance sheets for the first two years are provided in a separate Excel spreadsheet. All amounts are in thousands.
Required:
The Chief Executive Officer (CEO) is interested in increasing sales and decreasing expenses. You have been requested to prepare a report that provides analysis of the financial statements and recommendations to improve the financial performance of the company. Your report should include the following items:
Calculate the following ratios and provide an analysis of the company based on the ratios: (SHOW ALL WORK)
Financial Leverage
Return on Equity
PPE (property Plant& Equipment) Turnover
Total Liabilities to Equity
Times Interest Earned
| SILVER CLOUD COMPUTING | ||||
| Income Statements | ||||
| For the Years Ended February 28, 2018 and 2017 | ||||
| fye 2/28/2018 | fye 2/28/2017 | |||
| (in thousands) | (in thousands) | |||
| Sales | $225,000 | $200,000 | ||
| Sales Discounts | 3,375 | 2,500 | ||
| Net Sales | 221,625 | 197,500 | ||
| Wages and Salaries | 73,500 | 70,000 | ||
| Bad Debt Expense | 2,100 | 2,000 | ||
| Depreciation | 20,000 | 20,000 | ||
| Marketing Expense | 33,750 | 30,000 | ||
| Occupancy Expense | 54,000 | 54,000 | ||
| Research & Development | 22,500 | 20,000 | ||
| Total Expenses | 205,850 | 196,000 | ||
| Income from Operations | 15,775 | 1,500 | ||
| Interest Expense | 1,200 | 1,200 | ||
| Income Before Taxes | 14,575 | 300 | ||
| Income Taxes (40%) | 5,830 | 120 | ||
| Net Income | $8,745 | $180 |
| SILVER CLOUD COMPUTING | |||||||
| Balance Sheets | |||||||
| February 28, 2018 and 2017 and February 29, 2016 | |||||||
| At Inception | |||||||
| Feb 28 2018 | Feb 28 2017 | Feb 29 2016 | |||||
| (in thousands) | (in thousands) | (in thousands) | |||||
| Cash | $55,755 | $22,300.00 | $10,000 | ||||
| Accounts Receivable | 18,000 | 16,000 | - | ||||
| Net Computer Equipment | 20,000 | 40,000 | 60,000 | ||||
| Total Assets | $93,755 | $78,300 | $70,000 | ||||
| Accounts Payable | $9,000 | $8,000 | $- | ||||
| Taxes Payable | 5,830 | 120 | - | ||||
| Long-term Debt | 30,000 | 30,000 | 30,000 | ||||
| Common Stock | 40,000 | 40,000 | 40,000 | ||||
| Retained Earnings | 8,925 | 180 | - | ||||
| Total Liabilities & Stockholders Equity | $93,755 | $78,300 | $70,000 | ||||
In: Accounting
Silver Cloud Computing is a company that provides cloud computing services. The company commenced operations on March 1, 2016. It acquired financing from the issuance of common stock for $40,000,000 and issuance of 4% bonds that mature in 2026 for $30,000,000. The income statements and balance sheets for the first two years are provided in a separate Excel spreadsheet. All amounts are in thousands.
Required:
The Chief Executive Officer (CEO) is interested in increasing sales and decreasing expenses. You have been requested to prepare a report that provides analysis of the financial statements and recommendations to improve the financial performance of the company. Your report should include the following items:
Prepare common sized financial statements for both years and provide comments on the differences between the years.Are there any areas of concern?
Calculate the following ratios and provide an analysis of the company based on the ratios:
Days Sales Outstanding
Profit Margin
Asset Turnover
Return on Assets
Financial Leverage
Return on Equity
PPE Turnover
Total Liabilities to Equity
Times Interest Earned
| fye 2/28/2018 | fye 2/28/2017 | |||
| (in thousands) | (in thousands) | |||
| Sales | $ 225,000 | $ 200,000 | ||
| Sales Discounts | 3,375 | 2,500 | ||
| Net Sales | 221,625 | 197,500 | ||
| Wages and Salaries | 73,500 | 70,000 | ||
| Bad Debt Expense | 2,100 | 2,000 | ||
| Depreciation | 20,000 | 20,000 | ||
| Marketing Expense | 33,750 | 30,000 | ||
| Occupancy Expense | 54,000 | 54,000 | ||
| Research & Development | 22,500 | 20,000 | ||
| Total Expenses | 205,850 | 196,000 | ||
| Income from Operations | 15,775 | 1,500 | ||
| Interest Expense | 1,200 | 1,200 | ||
| Income Before Taxes | 14,575 | 300 | ||
| Income Taxes (40%) | 5,830 | 120 | ||
| Net Income | $ 8,745 | $ 180 | ||
| SILVER CLOUD COMPUTING | ||||||||
| Balance Sheets | ||||||||
| February 28, 2018 and 2017 and February 29, 2016 | ||||||||
| At Inception | ||||||||
| Feb 28 2018 | Feb 28 2017 | Feb 29 2016 | ||||||
| (in thousands) | (in thousands) | (in thousands) | ||||||
| Cash | $ 55,755 | $ 22,300.00 | $ 10,000 | |||||
| Accounts Receivable | 18,000 | 16,000 | - | |||||
| Net Computer Equipment | 20,000 | 40,000 | 60,000 | |||||
| Total Assets | $ 93,755 | $ 78,300 | $ 70,000 | |||||
| Accounts Payable | $ 9,000 | $ 8,000 | $ - | |||||
| Taxes Payable | 5,830 | 120 | - | |||||
| Long-term Debt | 30,000 | 30,000 | 30,000 | |||||
| Common Stock | 40,000 | 40,000 | 40,000 | |||||
| Retained Earnings | 8,925 | 180 | - | |||||
| Total Liabilities & Stockholders Equity | $ 93,755 | $ 78,300 | $ 70,000 | |||||
In: Accounting
Problems 1–4 pertain to the data set of 85 measurements represented by the following ordered stem and leaf diagram, in which the stems are the digits in the tens place and leaves are the digits in the ones place. For these data Px = 3, 957 and Px 2 = 203, 589.
6 0 0 0 1 1 1 1 2 2 2 3 3 3 4 4 5 5 6 7 7 7 8 8
5 0 0 1 1 1 2 2 3 4 4 5 5 5 6 6 7 8 8 9 9
4 0 1 1 2 2 3 3 4 4 6 6 6 7 7 8 9
3 0 0 1 2 3 4 4 5 6 7 7
2 0 2 3 5 5 5 6 6 7 8
1 6 6 7 8 9
1. The sample mean of this data set is about: (a) 32.2 (b) 41.8 (c) 50.8 (d) 46.6 (e) 39.7
2. The sample standard deviation of this data set is about: (a) 12.4 (b) 228.0 (c) 15.2 (d) 18.3 (e) 230.7
3. The sample median is about: (a) 47.0 (b) 42.5 (c) 50.0 (d) 46.3 (e) 37.5
4. The percentile rank of the measurement 25 is about: (a) 25 (b) 42 (c) 13 (d) 9 (e) 18
In: Statistics and Probability
In C++, create a function exchangesl that takes an argument of an array of integers ( for C++ use implement void exchangesl(vector<int>& a) . Those integers need to be changed so that the smallest and largest values in the array are exchanged. Assume that there is at least one element, if the largest value occurs more than once then exchange the first instance, if the smallest value happens more than once then exchange the last instance.
Use the following file:
Tester.cpp
#include <vector>
#include <iostream>
using namespace std;
void exchangesl(vector<int>&);
void print(vector<int> v)
{
for (int i = 0; i < v.size(); i++)
{
if (i == 0) cout << "["; else cout << ", ";
cout << v[i];
}
cout << "]" << endl;
}
main()
{
vector<int> a = { 1, 9, -1, 4, -1, 6, 11, 8 };
exchangesl(a);
print(a);
cout << "Expected: [1, 9, -1, 4, 11, 6, -1, 8]" << endl;
vector<int> b = { 1, 9, -1, 4, -1, 6, 11, 8, 9, -1 };
exchangesl(b);
print(b);
cout << "Expected: [1, 9, -1, 4, -1, 6, -1, 8, 9, 11]" << endl;
vector<int> c = { 1, 2, 3, 4, 5, 4, 3, 2, 1, 2, 3, 4, 5, 4, 3, 2, 1 };
exchangesl(c);
print(c);
cout << "Expected: [1, 2, 3, 4, 1, 4, 3, 2, 1, 2, 3, 4, 5, 4, 3, 2, 5]" << endl;
}In: Computer Science
a. Use an appropriate test to evaluate whether the number of prey eaten differs among three habitat types. Assume the data are normally distributed.
b. If habitat type affects the number of prey eaten, determine which habitats differ from which others.
c. Evaluate the same hypothesis, but now assume that the data are not distributed normally (You don’t need to determine which habitats differ from which others for this question)
1) State all relevant hypotheses (nulls and alternatives).
2) State which test was used and why you used it.
3) State conclusions after completing your analyses.
| habitat | n eaten |
| 1 | 1 |
| 1 | 2 |
| 1 | 2 |
| 1 | 3 |
| 1 | 3 |
| 1 | 4 |
| 1 | 4 |
| 1 | 4 |
| 1 | 4 |
| 1 | 6 |
| 1 | 2 |
| 1 | 5 |
| 1 | 9 |
| 1 | 7 |
| 1 | 0 |
| 2 | 2 |
| 2 | 0 |
| 2 | 1 |
| 2 | 3 |
| 2 | 3 |
| 2 | 0 |
| 2 | 4 |
| 2 | 0 |
| 2 | 0 |
| 2 | 4 |
| 2 | 0 |
| 2 | 6 |
| 2 | 5 |
| 2 | 1 |
| 2 | 7 |
| 3 | 0 |
| 3 | 0 |
| 3 | 2 |
| 3 | 0 |
| 3 | 0 |
| 3 | 0 |
| 3 | 1 |
| 3 | 0 |
| 3 | 0 |
| 3 | 1 |
| 3 | 0 |
| 3 | 0 |
| 3 | 1 |
| 3 | 0 |
| 3 | 0 |
In: Statistics and Probability
Pacific Healthcare is an investor-owned hospital chain that owns and operates nine hospitals in Washington, Oregon, and Northern California. You are a recent graduate of a prominent healthcare administration program and have just been hired by Washington Medical Center, Pacific’s largest hospital. Like all new management personnel, you must undergo three months of intensive training at the system level before joining the hospital. You begin by examining Pacific’s annual report to get some basic financial data. You search Yahoo! Finance, CNNMoney, Bloomberg, and MSN Money for current market data as well as analysts’ forecasts for Pacific Healthcare and the market. You discover that Pacific’s stock is currently selling for $8 per share, current dividend is $0.48 per share (paid on December 31, 2019), and the beta coefficient is 1.2. In addition, you learn that the yield on long-term Treasury bonds is 5.0 percent and that a market return of 11 percent is expected. Most analysts forecast that Pacific will grow about 10 percent per year for the next five years (2020-2024) and 4 percent per year thereafter (2025 and beyond). Based on these growth forecasts, you assembled the forecast dividends per share, as shown in the below exhibit. -
Historical Year/Dividends per share 2014/$0.215; 2015/$0.324; 2016/$0.353; 2017/$0.362; 2018/$0.391; 2019/$0.480
Forecast Year/Dividend per Share 2020/$0.528; 2021/$0.581; 2022/$0.639; 2023/$0.703; 2024/$0.773; 2025/$0.804; 2026/$0.836
Excel Problem (Answers to highlighted cells): If investors estimate that Pacific Healthcare will grow about 10 percent per year for the next five years (2020-2024), what constant growth rate (2025+) are they using to price the stock? (Hint: what constant growth rate (2025+) produces an actual December 31, 2019 stock price of $8?)
| Year | D(0) | Growth | E(D1) | |||
| 2019 | 0 | $0.48 | ||||
| 2020 | 1 | $0.48 | 10% | $0.53 | ||
| 2021 | 2 | $0.53 | 10% | $0.58 | ||
| 2022 | 3 | $0.58 | 10% | $0.64 | ||
| 2023 | 4 | $0.64 | 10% | $0.70 | ||
| 2024 | 5 | $0.70 | 10% | $0.77 | ||
| 2025 | 6 | $0.77 | $0.77 | |||
| 2020 | 2021 | 2022 | 2023 | 2024 | PV | |
| Year 1-5 dividends | $0.53 | $0.58 | $0.64 | $0.70 | $0.77 | |
| Year 6+ dividends | ||||||
| Actual stock price on December 31, 2019 | ||||||
| Hint: Actual stock price on December 31, 2019 should equal $8 | ||||||
In: Finance
|
1 |
1.100 |
0.9091 |
1.0000 |
0.9091 |
|
. . . |
. . . |
. . . |
. . . |
. . . |
|
6 |
1.7716 |
0.5645 |
7.7156 |
4.3553 |
|
7 |
1.9487 |
0.5132 |
9.4872 |
4.8684 |
|
8 |
2.1436 |
0.4665 |
11.4359 |
5.3349 |
|
9 |
2.3579 |
0.4241 |
13.5795 |
5.7590 |
|
10 |
2.5937 |
0.3855 |
15.9374 |
6.1446 |
|
11 |
2.8531 |
0.3505 |
18.5312 |
6.4951 |
|
12 |
3.1384 |
0.3186 |
21.3843 |
6.8137 |
|
13 |
3.4523 |
0.2897 |
24.5227 |
7.1034 |
|
14 |
3.7975 |
0.2633 |
27.9750 |
7.3667 |
|
15 |
4.1772 |
0.2394 |
31.7725 |
7.6061 |
|
16 |
4.5950 |
0.2176 |
35.9497 |
7.8237 |
Number of full payments:
Amount of last payment: $ (Round to the nearest dollar.)
(Click here to access the PV and FV tables to use with this problem.)
Round your answer to two decimal places.
Initial deposit required: $
In: Accounting
You are the production manager at a parachute manufacturing company. Parachutes are woven in your factory using a synthetic fiber purchased from 1 of 4 different suppliers. The factory uses 2 types of looms, the Athenian and the Spartan. You are concerned about the consistency of parachute strength, so you measure the strength for 5 parachutes made with each of the 4 fiber suppliers, using each of the 2 looms.
Perform an ANOVA with these data for main effects and
interaction effects.
Use Minitab software to find the solution.
| Strength | Supplier | Loom |
| 20.6 | 1 | Athenian |
| 18.0 | 1 | Athenian |
| 19.0 | 1 | Athenian |
| 21.3 | 1 | Athenian |
| 13.2 | 1 | Athenian |
| 18.5 | 1 | Spartan |
| 24.0 | 1 | Spartan |
| 17.2 | 1 | Spartan |
| 19.9 | 1 | Spartan |
| 18.0 | 1 | Spartan |
| 22.6 | 2 | Athenian |
| 24.6 | 2 | Athenian |
| 19.6 | 2 | Athenian |
| 23.8 | 2 | Athenian |
| 27.1 | 2 | Athenian |
| 26.3 | 2 | Spartan |
| 25.3 | 2 | Spartan |
| 24.0 | 2 | Spartan |
| 21.2 | 2 | Spartan |
| 24.5 | 2 | Spartan |
| 27.7 | 3 | Athenian |
| 18.6 | 3 | Athenian |
| 20.8 | 3 | Athenian |
| 25.1 | 3 | Athenian |
| 17.7 | 3 | Athenian |
| 20.6 | 3 | Spartan |
| 25.2 | 3 | Spartan |
| 20.8 | 3 | Spartan |
| 24.7 | 3 | Spartan |
| 22.9 | 3 | Spartan |
| 21.5 | 4 | Athenian |
| 20.0 | 4 | Athenian |
| 21.1 | 4 | Athenian |
| 23.9 | 4 | Athenian |
| 16.0 | 4 | Athenian |
| 25.4 | 4 | Spartan |
| 19.9 | 4 | Spartan |
| 22.6 | 4 | Spartan |
| 17.5 | 4 | Spartan |
| 20.4 | 4 | Spartan |
In: Statistics and Probability
| weight | feed |
| 309 | 1 |
| 229 | 1 |
| 181 | 1 |
| 141 | 1 |
| 260 | 1 |
| 203 | 1 |
| 148 | 1 |
| 169 | 1 |
| 213 | 1 |
| 257 | 1 |
| 244 | 1 |
| 271 | 1 |
| 243 | 3 |
| 230 | 3 |
| 248 | 3 |
| 327 | 3 |
| 329 | 3 |
| 250 | 3 |
| 193 | 3 |
| 271 | 3 |
| 316 | 3 |
| 267 | 3 |
| 199 | 3 |
| 171 | 3 |
| 158 | 3 |
| 248 | 3 |
| 423 | 4 |
| 340 | 4 |
| 392 | 4 |
| 339 | 4 |
| 341 | 4 |
| 226 | 4 |
| 320 | 4 |
| 295 | 4 |
| 334 | 4 |
| 322 | 4 |
| 297 | 4 |
| 318 | 4 |
| 325 | 2 |
| 257 | 2 |
| 303 | 2 |
| 315 | 2 |
| 380 | 2 |
| 153 | 2 |
| 263 | 2 |
| 242 | 2 |
| 206 | 2 |
| 344 | 2 |
| 258 | 2 |
A 1948 study in Biometrika investigated the effects of several different diets on the weight of chickens. In this study, chickens were randomly assigned to one of several different groups, and each group of chickens received a different type of feed. The data provided represent a subset of data from this study and show the weights (in grams) of chickens receiving the sunflower, linseed, soybean, and meatmeal feeds.
Use software to conduct an analysis of variance (ANOVA) ?‑test to test the claim that the mean weights of chickens receiving sunflower, linseed, soybean, and meatmeal are equal. What are the ?‑statistic and ?-value for this test? Please round your ?‑statistic to the nearest two decimal places and your ?-value to the nearest five decimal places.
?‑statistic :
?-value:
In: Statistics and Probability