A.
- Why company requires financial plan?
- What is the difference between operating and financial plan?
- What alternatives a company may use to finance its deficit?
- How a company manages its surplus?
B.
Ahmed Ebrahem, the CEO of the BIG Company, is initiating
planning for the company's operations next year, and he wants you
to forecast the firm's additional funds needed (AFN). The firm is
operating at full capacity. Data for use in your
forecast are shown below. Based on the AFN equation, what is the
AFN for the coming year? All dollar values are in
millions.
Last year's sales $350 Last year's accounts payable $40
Sales growth rate 30% Last year's notes payable $50
Last year's total assets $500 Last year's accruals $30
Last year's profit margin 5% Target payout ratio 60%
Required? Compute the AFN and the self-supporting growth rate.
In: Finance
T/F ( Give me all answers, DO NOT GIVE ONLY ONE OR TWO. I NEED ALL)
1 Benefits are extra compensation items that are not paid directly to an employee.
2 On July 1, 2018, Shannon Equipment Dealer issued $590,000 of 6% bonds payable that mature in seven years. These bonds were issued at face value and pay interest each June 30 and December 31. Each semiannual interest payment will be higher than the interest expense.
3 Earnings per share reports the amount of net income (loss) for each share of the company's issued common stock.
4 A trial balance is the list of only a company's asset and liability accounts, along with their account numbers, at a point in time.
5 Checking accounts and money market accounts are examples of cash equivalents.
6 Bad debt expense is a cost to the seller of extending credit.
7 Brooklyn Market recently traded in store fixtures. The exchange had commercial substance. The old fixtures had a cost of $70,000 and accumulated depreciation of $58,000. Brooklyn paid $99,000 for the new store fixtures. These new fixtures had a market value of $133,000. There is a loss of $22,000 on this exchange.
8 Dodgers Corp.'s beginning and ending total assets in the year 2019 were $19,900,000 and $22,100,000, respectively. Its asset turnover ratio for the year was calculated to be 1.8 times. Calculate the amount of net sales for the year 2019. A 53,500,000 B 24,960,000 C 37,800,000 D 43,100,000
In: Accounting
Matthew Sanders is a 69-year-old male who is one day post-op following open radical prostatectomy for treatment of prostate cancer. PMH: presented to PCP two weeks ago with dysuria, hematuria and urinary hesitancy accompanied by back and pelvic discomfort that began six months ago. PSA level was 7.8 ng/mL and DRE showed enlarged prostate: asymmetric, hard and nontender. Biopsy confirmed prostate cancer Stage II, Gleason Score 8, classified as high-risk cancer. Osteoarthritis, Type 2 DM and history of peptic ulcer disease. 0700 Assessment • 130/90 98.8°F- 86-20 pulse oximetry 98% on room air 4/10 incisional pain • HRR, no edema, +2 peripheral pulses, capillary refill < 3 sec, elastic skin turgor, LR infusing at 125 mL/h via right forearm IPID • Abdomen soft, hypoactive bowel sounds x 4 quadrants, 500 mL green liquid emesis – ondansetron given at 2030 with relief of n/v, PO intake ice chips only, abdominal incision dry and intact • CBI infusing – pale pink color with occasional tiny clot, 600 mL urinary output for 11-7 shift, morphine given for bladder spasms at 0415 – pain score 7/10 to 4/10 d.
On first rounds, you discover urine is leaking around the foley catheter tubing. What will you do?
Later in the day, drainage in the foley bag has changed from pale pink to red with multiple clots. What are your next steps?
At the end of your shift, the PCA tells you that Mr. Sanders reports increased cramping and pain in his lower abdomen. What actions will you take?
In: Nursing
A psychologist conducted an experiment analysing the relationship between student scores in an exam and the amount of attention they paid in class. The latter was measured using a type of brain monitor. The Psychologist believed that scores would increase by 1 for every two unit increase in attention. The data are listed in the excel spreadsheet.
Estimate a linear regression between the score (Y) and the measure of attention(X).
(a) Write out the equation for Y in the form , but with coefficients. Show the estimated standard errors in parenthesis below the coefficients. What is the R2 of the regression? Calculate a 99 percent confidence interval for β. [5 pts]
(b) What are the mean and the estimated standard deviation of the estimated residuals? [2 pts]
Hint: the first answer is definitional and the second answer is easily seen from the output.
(c )Test the hypothesis that there is no relationship between the variables at the 90 percent significance level. [3 pts]
(d) Test the hypothesis that the coefficient β=0.5 at the 99% significance level. [3 pts]
(e) The Psychologist concluded from the experiment that test scores increase significantly if students pay attention in class. In one word, how would you describe the results of this experiment based on the data you have? [2 pts]
DATA:
| Regression data for Psychology Experiment | |||
| Attention | Score | ||
| 18 | 80 | ||
| 35 | 90 | ||
| 86 | 80 | ||
| 22 | 50 | ||
| 72 | 76 | ||
| 102 | 74 | ||
| 86 | 75 | ||
| 30 | 80 | ||
| 35 | 85 | ||
| 94 | 82 | ||
| 16 | 80 | ||
| 42 | 41 | ||
| 50 | 50 | ||
| 96 | 96 | ||
| 60 | 80 | ||
| 106 | 70 | ||
| 80 | 65 | ||
| 14 | 14 | ||
| 11 | 14 | ||
| 80 | 85 | ||
| 12 | 14 | ||
| 37 | 43 | ||
| 26 | 80 | ||
| 86 | 70 | ||
| 5 | 20 | ||
| 17 | 20 | ||
| 35 | 80 | ||
| 76 | 68 | ||
| 50 | 70 | ||
| 15 | 16 | ||
| 90 | 86 | ||
| 96 | 80 | ||
| 7 | 16 | ||
| 10 | 14 | ||
| 35 | 65 | ||
| 88 | 88 | ||
| 20 | 32 | ||
| 22 | 70 | ||
| 50 | 65 | ||
| 22 | 62 | ||
| 35 | 50 | ||
| 64 | 92 | ||
| 68 | 84 | ||
| 13 | 15 | ||
| 102 | 102 | ||
| 86 | 85 | ||
| 18 | 24 | ||
| 78 | 64 | ||
| 98 | 78 | ||
| 70 | 80 | ||
| 60 | 70 | ||
| 98 | 98 | ||
| 9 | 14 | ||
| 50 | 90 | ||
| 104 | 72 | ||
| 35 | 45 | ||
| 60 | 60 | ||
| 74 | 72 | ||
| 88 | 88 | ||
| 80 | 95 | ||
| 22 | 58 | ||
| 8 | 14 | ||
| 86 | 110 | ||
| 60 | 75 | ||
| 92 | 84 | ||
| 60 | 100 | ||
| 80 | 75 | ||
| 86 | 95 | ||
| 16 | 18 | ||
| 86 | 90 | ||
| 35 | 75 | ||
| 35 | 60 | ||
| 80 | 60 | ||
| 80 | 70 | ||
| 104 | 104 | ||
| 80 | 100 | ||
| 60 | 90 | ||
| 86 | 100 | ||
| 62 | 96 | ||
| 60 | 65 | ||
| 39 | 41 | ||
| 50 | 80 | ||
| 50 | 75 | ||
| 6 | 18 | ||
| 60 | 95 | ||
| 22 | 54 | ||
| 21 | 40 | ||
| 100 | 100 | ||
| 94 | 94 | ||
| 80 | 90 | ||
| 48 | 41 | ||
| 106 | 106 | ||
| 50 | 43 | ||
| 46 | 41 | ||
| 90 | 90 | ||
| 60 | 85 | ||
| 92 | 92 | ||
| 22 | 80 | ||
| 35 | 70 | ||
| 66 | 88 | ||
| 80 | 60 | ||
| 50 | 60 | ||
| 80 | 80 | ||
| 100 | 76 | ||
| 50 | 45 | ||
| 86 | 65 | ||
| 19 | 28 | ||
| 50 | 85 | ||
| 22 | 75 | ||
| 86 | 105 | ||
In: Statistics and Probability
Scenario Modeler’s prospective stock has a 15% chance of producing a 65% return, a 25% chance of producing a 22% return, a 40% chance of producing a 7% return, and a 20% chance of producing a –24% return. What is the firm’s coefficient of variation of return? Enter your answer rounded to two decimal places. For example, if your answer is 12.345 then enter as 12.35 in the answer box.
In: Finance
A company's 7% coupon rate, semiannual payment, $1,000 par value bond that matures in 25 years sells at a price of $747.72. The company's federal-plus-state tax rate is 40%. What is the firm's after-tax component cost of debt for purposes of calculating the WACC? (Hint: Base your answer on the nominal rate.) Round your answer to two decimal places.
In: Finance
| Day | Date | Weekday | Daily Demand | Weekend |
| 1 | 4/25/2016 | Mon | 297 | 0 |
| 2 | 4/26/2016 | Tue | 293 | 0 |
| 3 | 4/27/2016 | Wed | 327 | 0 |
| 4 | 4/28/2016 | Thu | 315 | 0 |
| 5 | 4/29/2016 | Fri | 348 | 0 |
| 6 | 4/30/2016 | Sat | 447 | 1 |
| 7 | 5/1/2016 | Sun | 431 | 1 |
| 8 | 5/2/2016 | Mon | 283 | 0 |
| 9 | 5/3/2016 | Tue | 326 | 0 |
| 10 | 5/4/2016 | Wed | 317 | 0 |
| 11 | 5/5/2016 | Thu | 345 | 0 |
| 12 | 5/6/2016 | Fri | 355 | 0 |
| 13 | 5/7/2016 | Sat | 428 | 1 |
| 14 | 5/8/2016 | Sun | 454 | 1 |
| 15 | 5/9/2016 | Mon | 305 | 0 |
| 16 | 5/10/2016 | Tue | 310 | 0 |
| 17 | 5/11/2016 | Wed | 350 | 0 |
| 18 | 5/12/2016 | Thu | 308 | 0 |
| 19 | 5/13/2016 | Fri | 366 | 0 |
| 20 | 5/14/2016 | Sat | 460 | 1 |
| 21 | 5/15/2016 | Sun | 427 | 1 |
| 22 | 5/16/2016 | Mon | 291 | 0 |
| 23 | 5/17/2016 | Tue | 325 | 0 |
| 24 | 5/18/2016 | Wed | 354 | 0 |
| 25 | 5/19/2016 | Thu | 322 | 0 |
| 26 | 5/20/2016 | Fri | 405 | 0 |
| 27 | 5/21/2016 | Sat | 442 | 1 |
| 28 | 5/22/2016 | Sun | 454 | 1 |
| 29 | 5/23/2016 | Mon | 318 | 0 |
| 30 | 5/24/2016 | Tue | 298 | 0 |
| 31 | 5/25/2016 | Wed | 355 | 0 |
| 32 | 5/26/2016 | Thu | 355 | 0 |
| 33 | 5/27/2016 | Fri | 374 | 0 |
| 34 | 5/28/2016 | Sat | 447 | 1 |
| 35 | 5/29/2016 | Sun | 463 | 1 |
| 36 | 5/30/2016 | Mon | 291 | 0 |
| 37 | 5/31/2016 | Tue | 319 | 0 |
| 38 | 6/1/2016 | Wed | 333 | 0 |
| 39 | 6/2/2016 | Thu | 339 | 0 |
| 40 | 6/3/2016 | Fri | 416 | 0 |
| 41 | 6/4/2016 | Sat | 475 | 1 |
| 42 | 6/5/2016 | Sun | 459 | 1 |
| 43 | 6/6/2016 | Mon | 319 | 0 |
| 44 | 6/7/2016 | Tue | 326 | 0 |
| 45 | 6/8/2016 | Wed | 356 | 0 |
| 46 | 6/9/2016 | Thu | 340 | 0 |
| 47 | 6/10/2016 | Fri | 395 | 0 |
| 48 | 6/11/2016 | Sat | 465 | 1 |
| 49 | 6/12/2016 | Sun | 453 | 1 |
| 50 | 6/13/2016 | Mon | 307 | 0 |
| 51 | 6/14/2016 | Tue | 324 | 0 |
| 52 | 6/15/2016 | Wed | 350 | 0 |
| 53 | 6/16/2016 | Thu | 348 | 0 |
| 54 | 6/17/2016 | Fri | 384 | 0 |
| 55 | 6/18/2016 | Sat | 474 | 1 |
| 56 | 6/19/2016 | Sun | 485 | 1 |
Eli Orchid has designed a new pharmaceutical product, Orchid Relief, which improves the night sleep. Before initiating mass production of the product, Eli Orchid has been market-testing Orchid Relief in Orange County over the past 8 weeks. The daily demand values are listed above. Eli Orchid plans on using the sales data to predict sales for the upcoming week. An accurate forecast would be helpful in making arrangements for the company’s production processes and designing promotions.
Before a forecasting model is built and a forecast for the next week is generated, the COO of the company has asked the data analyst for an exploratory analysis of the demand.
Specifically, the COO has asked the analyst1:
|
To provide a bar/column chart (with data labels rounded to two decimal points) showing the average demand for each day of the week (Sun., Mon., etc.) |
[ chart ] |
|
To fit a simple linear regression model to the data and to provide its equation (d = a*t + b), along with R2 |
d = R2= |
|
To fit a multiple regression model with a dummy variable representing the weekend, and to provide the regression equation (d = a*t + b*w + c), along with Adjusted R2. |
d = Adjusted R2= |
|
To provide a line graph of the actual demand with a simple regression and multiple a regression overlay. |
[ chart ] |
|
Specifically:
|
In: Statistics and Probability
Exercise 1:
Write an XML document describing the exercises in this document: the root element is <exercises>. The root has an attribute number that has value 1. The root element has three child elements; <date> that contains as text the date of the exercise, and two <item> elements for the first two exercises (1--2). Write some text in the <item> elements.
Exercise 2:
Write an XML document describing a person: name, occupation, address and hobbies. Please do not use your own information, you can use fake data. Decide on suitable element names and nesting. Check your document for well-formedness.
Exercise 3:
Draw a tree that represents the XML document you created in task 2.
Exercise 4:
This is the books.xml file
<?xml version='1.0'?>
<!-- This file represents a fragment of a book store inventory
database -->
<bookstore>
<book genre="autobiography" publicationdate="1981" ISBN="1-861003-11-0">
<title>The Autobiography of Benjamin
Franklin</title>
<author>
<first-name>Benjamin</first-name>
<last-name>Franklin</last-name>
</author>
<price>8.99</price>
</book>
<book genre="novel" publicationdate="1967" ISBN="0-201-63361-2">
<title>The Confidence Man</title>
<author>
<first-name>Herman</first-name>
<last-name>Melville</last-name>
</author>
<price>11.99</price>
</book>
<book genre="philosophy" publicationdate="1991" ISBN="1-861001-57-6">
<title>The Gorgias</title>
<author>
<name>Plato</name>
</author>
<price>9.99</price>
</book>
</bookstore>
Using books.xml as a model, create a small xml file for a student's
program of study form called programOfStudy.xml. It should capture
the following data:
In: Computer Science
Filer Manufacturing has 5 million shares of common stock outstanding. The current share price is $84, and the book value per share is $7. Filer Manufacturing also has two bond issues outstanding. The first bond issue has a face value of $60 million, has a 7 percent coupon, and sells for 94 percent of par. The second issue has a face value of $35 million, has a 8 percent coupon, and sells for 107 percent of par. The first issue matures in 22 years, the second in 4 years. The most recent dividend was $5.6 and the dividend growth rate is 8 percent. Assume that the overall cost of debt is the weighted average of that implied by the two outstanding debt issues. Both bonds make semiannual payments. The tax rate is 35 percent. Required: What is the company's WACC? (Do not round your intermediate calculations.)
In: Finance
Wagner Fabricating Company Managers at Wagner Fabricating Company are reviewing the economic feasibility of manufacturing a part that the company currently purchases from a supplier. Forecasted annual demand for the part is 3200 units. Wagner operates 250 days per year. Wagner’s financial analysts established a cost of capital of 18% for the use of funds for investments within the company. In addition, over the past year $300,000 was the average investment in the company’s inventory. Accounting information shows that a total of $24,000 was spent on taxes and insurance related to the company’s inventory. In addition, an estimated $6,000 was lost due to inventory shrinkage, which included damaged goods as well as pilferage. A remaining $16,000 was spent on warehouse overhead, including utility expenses for heating and lighting.
An analysis of the purchasing operation shows that approximately two hours are required to process and coordinate an order for the part regardless of the quantity ordered. Purchasing salaries average $28 per hour, including employee benefits. In addition, a detailed analysis of 128 orders showed that $2375 was spent on telephone, paper, and postage directly related to the ordering process.
A one-week lead time is required to obtain the part from the supplier. An analysis of demand during the lead time shows it is approximately normally distributed with a mean of 64 units and a standard deviation of 11 units. Service level guidelines indicate that one stock-out per year is acceptable.
Currently, the company has a contract to purchase the part from a supplier at a cost of $18 per unit. However, over the past few months, the company’s production capacity has been expanded. As a result, excess capacity is now available in certain production departments, and the company is considering the alternative of producing the parts itself.
Forecasted utilization of equipment shows that production capacity will be available for the part being considered. The production capacity is available at the rate of 1200 units per month, with up to five months of production time available. Management believes that with a two-week lead time, schedules can be arranged so that the part can be produced whenever needed. The demand during the two-week lead time is approximately normally distributed, with a mean of 128 units and a standard deviation of 24 units. Production costs are expected to be $17 per part.
A concern of management is that setup costs will be substantial. The total cost of labor and lost production time is estimated to be $40 per hour, and a full eight-hour shift will be needed to set up the equipment for producing the part.
Develop a report for management of Wagner Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself. Include the following factors in your report:
1. A development of the inventory policy for the following two alternatives:
a. Annual holding cost
b. Annual ordering cost
c. Annual cost of the units purchased or manufactured
d. Total annual cost of the purchase policy and the total annual cost of the production policy
In: Accounting