The income statement and additional data of Bayleaf Pty Ltd are as follows:

Income statement for the year ended 31 December 2016

Revenue:

Service Revenue R225 000

Dividend Revenue R6 300 (231 300)

Expenses:

Cost of goods sold R100 000

Salary Expense R52 000

Depreciation Expense R23 000

Advertising Expense R2 300

Interest Expense R2 400

Income tax expense R5 000 (R184 700)

Net income R46 600

Additional Data:

a) Acquisition of PPE was R170 000. Of this amount , R140 000 was paid in cash and R30 000 by signing a note payable

b) Proceeds from the sale of land totalled R48 000

c) Proceeds from issuance of shares totalled R31 000

d) Payment of long-term note payable was R16 000

e) Payment of dividends was R10 000

From the Balance Sheet:

Balance sheet as at 31 December

Currents Assets 2016 2015

Cash R32 000 R13 300

Accounts Receivable R41 000 R57 000

Inventory R48 000 R87 000

Prepaid expenses R9 100 R8 200

Current Liabilities

Accounts Payable R32 000 R17 000

Accrued liabilities R14 000 R43 000

Required:

1. Prepare Bayleaf 's statement of cash flow for year ended 31 December 2016, using indirect Method.

2. Evaluate Bayleaf's cash flow for the year ended 31 December 2016, including its free cash flow and cash realization ratio. In your evaluation, review all three categories of cash flows and give the reason for your evaluation.

3. When analyzing the cash flow patterns of the Company, what other three (3) important indicators of the health of the company 's cash flows do you look at?

Answer the following questions:

Q.1) Is collecting cash from customer accounts receivable an expense or a revenue?

Q.2) Is purchasing supplies on account an expense or a revenue?

Q.3) Is cash receipts an expense or a revenue?

Q.4) Are invoices for services on account an expense or a revenue?

Q.5) Is paying for utility bills in the month of May that were received in the month of April an expense or a revenue?

Q.6) Is paying for employee salaries an expense or a revenue?

Q.7) Is purchasing a one-year insurance policy an expense or a revenue?

Q.8) Is paying $100 ( on 10th May) on the account payable that was established when supplies worth $200 were purchased on on 10th April, an expense or a revenue?

Q.9) Is receiving monthly utility bills amounting to $200 in the month of May that are to be paid in June an expense or a revenue?

Q.10) Are invoices for sales on account an expense or a revenue?

A study reports that 36% of companies in Country A have three or more female board directors. Suppose you select a random sample of 100 respondents. Complete parts​ (a) through​ (c) below.

a. What is the probability that the sample will have between 33​% and 43​% of companies in Country A that have three or more female board​ directors?

b. The probability is 70​% that the sample percentage of Country A companies having three or more female board directors will be contained within what symmetrical limits of the population​ percentage?

c. The probability is 99.7​% that the sample percentage of Country A companies having three or more female board directors will be contained within what symmetrical limits of the population​ percentage?

The probability is 99.7​% that the sample percentage will be contained above _____ ​% and below _____ ​%.

Sky Kitchens is the second largest airline caterer in the United States, providing nearly all the meals for passengers of three major airlines and several smaller commuter airlines. As part of a total quality management (TQM) program, its largest airline client, Continental Airlines, has recently met with representatives of Sky Kitchens to discuss a customer satisfaction program that it is planning to implement. Continental plans to interview a sample of its customers four times a year. In the survey, it intends to ask customers to rate the quality of meals provided on a 1–10 scale, where 1 means poor and 10 means excellent. It has just completed a benchmark study of 1,000 customers. In that study, meals received an average rating of 8.7 on the 10-point scale, with a standard deviation of 1.65. Continental has indicated that it wants Sky Kitchens to guarantee a level of satisfaction of 8.5 in the first quarterly survey, to be conducted in three months. For its quarterly surveys, Continental plans to use a sample size of 500. In the new contract with Sky Kitchens, Continental wants to include a clause that will penalize Sky Kitchens $50,000 for each one-tenth of a point it falls below an average of 8.5 on the next survey’s satisfaction scale.

1. What is the 99.74% confidence interval (CI) for the true satisfaction level based on the benchmark survey?

2. What is the 99% confidence interval (CI) for the true satisfaction level based on the benchmark survey?

3. What is the 95.44% CI for the true satisfaction level based on the benchmark survey?

4. What is the 95% CI for the true satisfaction level based on the benchmark survey?

5. As Sky Kitchens, what do you think of Continental’s requirement for a level of satisfaction of 8.5 in the first quarter survey?

6. Assume that the upcoming 1st -quarter satisfaction survey shows anaverage rating of 8.4 on satisfaction with meals. Assume that the population standard deviation is1.65. Compute the 99% CI for the true satisfaction level based on the 1st-quarter survey. As Sky Kitchens, what is the best way to present and interpret the resulting CI?

7. If you were negotiating for Sky Kitchens, how would you respond to Continental regarding the penalty clause? Is there a better or more reasonable way to revise it

Customers drop off their prescriptions either in the drive-through counter or in the front counter of the pharmacy. Customers can request that their prescription be filled immediately. In this case, they have to wait between 15 minutes and one hour depending on the current workload. Most customers are not willing to wait that long, so they opt to nominate a pickup time at a later point during the day. Generally, customers drop their prescriptions in the morning before going to work (or at lunchtime) and they come back to pick up the drugs after work, typically between 5pm and 6pm.When dropping their prescription, a technician asks the customer for the pick-up time and puts the prescription in a box labelled with the hour preceding the pick-up time. For example, if the customer asks to have the prescription be ready at 5pm, the technician will drop it in the box with the label 4pm (there is one box for each hour of the day).

Every hour, one of the pharmacy technicians picks up the prescriptions due to be filled in the current hour. The technician then enters the details of each prescription (e.g. doctor details, patient details and medication details) into the pharmacy system. As soon as the details of a prescription are entered, the pharmacy system performs an automated check called Drug Utilization Review (DUR). This check is meant to determine if the prescription contains any drugs that may be incompatible with other drugs that had been dispensed to the same customer in the past, or drugs that may be inappropriate for the customer taking into account the customer data maintained in the system (e.g. age).

Any alarms raised during the automated DUR are reviewed by a pharmacist who performs a more thorough check. In some cases, the pharmacist even has to call the doctor who issued the prescription in order to confirm it.

After the DUR, the system performs an insurance check in order to determine whether the customer’s insurance policy will pay for part or for the whole cost of the drugs. In most cases, the output of this check is that the insurance company would pay for a certain percentage of the costs, while the customer has to pay for the remaining part (also called the co-payment). The rules for determining how much the insurance company will pay and how much the customer has to pay are very complicated. Every insurance company has different rules. In some cases, the insurance policy does not cover one or several drugs in a prescription, but the drug in question can be replaced by another drug that is covered by the insurance policy. When such cases are detected, the pharmacist generally calls the doctor and/or the patient to determine if it is possible to perform the drug replacement.

Once the prescription passes the insurance check, it is assigned to a technician who collects the drugs from the shelves and puts them in a bag with the prescription stapled to it. After the technician has filled a given prescription, the bag is passed to the pharmacist who double-checks that the prescription has been filled correctly. After this quality check, the pharmacist seals the bag and puts it in the pick-up area. When a customer arrives to pick up a prescription, a technician retrieves the prescription and asks the customer for payment in case the drugs in the prescription are not (fully) covered by the customer’s insurance.

The following issues have been identified for the process:

1. Sometimes, a prescription cannot be filled because one or more drugs in the prescription are not in stock. Customers only learn this when they come to pick up their prescription.

Car Lease

use the information to answer the following questions.

You have decided to acquire a new car that costs $30,000. You are considering whether to lease it for three years or to purchase it and financing the purchase with a three year installment loan. The lease requires no down payment and lasts for three years. Lease payments are $400 monthly starting immediately, whereas the installment loan will require monthly payments starting a month from now at an annual percentage rate (APR) of 8%. The discount rate (APR) is also 8%.

1) If you expect the resale value of the car to be $20,000 three years from now, should you buy or lease it?

2) What is the break-even resale price of the care three years from now, such that you would be indifferent between buying and leasing it?

3. Car lease, Q1-1.

What is the value of the lease payment?

Hint:

• model the lease payment as an annuity due.
• use Excel PV function to calculate the present value.

(A) 12764.72 (B) 12849.82 (C) 13489.90 (D) 12953.80

4. Car lease, Q1-2

What is the present value of the resale value of $20,000 in three years?

(A) 17549.09 (B) 15745.09 (C) 15769.04 (D) 14759.08

5. Car lease: Q1-3

Following the car installment plan, the car would be brought now at $30000, and sold in three years at 20,000.

Estimate the loss in value as measured by the difference in their present values. This is the net cost of purchasing and reselling the car.

Compare the cost with leasing, should you buy or lease?

(A) Lease (B) buy

6. Care lease, Q2

What is the break-even resale price of the care three years from now, such that you would be indifferent between buying and leasing it?

(A) 18357 (B) 22987 (C) 19385 (D) 21785

ORDERS VS. SHIPMENTS CUSTOMERS IN PAST 6 MONTHS MONTHLY SALES ($) Size # Ordered # Received Customer # # Visits $ Purchases Month $ Sales Extra Small 30 23 1 8 468 Jan 1375 Small 50 54 2 6 384 Feb 1319 Medium 85 92 3 8 463 Mar 1222 Large 95 91 4 2 189 Apr 1328 Extra Large 60 63 5 10 542 May 1493 2X Large 45 42 6 4 299 Jun 1492 7 6 345 Jul 1489 8 2 197 Aug 1354 9 4 293 Sep 1530 10 1 119 Oct 1483 11 3 211 Nov 1450 12 9 479 Dec 1495 13 7 430 Jan 1545 14 7 404 Feb 1454 15 6 359 Mar 1322 16 10 544 Apr 1492 17 9 522 May 1678 18 5 327 Jun 1645 19 6 353 Jul 1580 20 7 405 Aug 1493 21 4 289 Sep 1719 22 7 386 Oct 1573 23 7 403 Nov 1629 24 1 146 Dec 1680 25 7 416 26 9 485 27 3 333 28 7 241 29 2 391 30 6 268 can you show me the formula that will need to be entered in Excel to solve the following Conduct a goodness of fit analysis which assesses orders of a specific item by size and items you received by size. Conduct a hypothesis test with the objective of determining if there is a difference between what you ordered and what you received at the .05 level of significance. Identify the null and alternative hypotheses. Generate a scatter plot, the correlation coefficient, and the linear equation that evaluates whether a relationship exists between the number of times a customer visited the store in the past 6 months and the total amount of money the customer spent. Set up a hypothesis test to evaluate the strength of the relationship between the two variables. Use a level of significance of .05. Use the regression line formula to forecast how much a customer might spend on merchandise if that customer visited the store 13 times in a 6 month period. Consider the average monthly sales of 2014, $1310, as your base to: Calculate indices for each month for the next two years. Graph a time series plot. In the Data Analysis Toolpak, use Excel's Exponential Smoothing option. Apply a damping factor of .5, to your monthly sales data. Create a new time series graph that compares the original and the revised monthly sales data.

The table below shows a dataset representing the ages of employees working for three different districts. Assuming a minimum working age of 18 and a mandatory retirement age of 65:

1. What is the possible age range for each district?
2. What is the possible age range for all districts combined?
3. What is the computed age range for each district?
4. What is the computed age range for all districts combined?
5. What does the computed versus actual age range tell you about the dispersion computed in questions 1-4?
6. What is the standard deviation for age in each district?
7. What does the standard deviation tell you about the dispersion of age in each district?
8. What is the standard deviation of age in all districts combined?
9. What is the variance in age in each district?
10. What is the variance in age when all districts are combined?

An investor is considering buying a rental duplex with land valued at $30,000 and the building valued at $150,000. Straight-line depreciation over 27 ½ years will be taken. The investor will be actively involved in the management of the property. He is in a 30% tax bracket.

Assume potential gross income of $44,000 in year one, vacancy of 12% and Operating expenses equal to 40% of Effective gross income. Gross potential income is expected to increase by 2% each year over the holding period.

A lender will make a 20-year loan equal to 75 percent of the total value of the property at 9 percent interest with monthly payments. Assume that there is 3 percent inflation related to total property value each year the investor owns the property and that there is a 4% commission paid (selling expenses) in the year of sale.

Assume that the investor’s after tax required rate of return is 12% and will hold the property for three years. Use the 25% tax rule where: for capital gain -- (tax rate >25% use marginal tax rate of 15%); for depreciation recapture-(tax rate >25% use marginal tax rate of 25%).

What is the after tax cash flow from sale of the asset in year three.

Please show formulas, I just want to verify that I was doing the work correctly and please show one example of the case rate and ratio of cases, Thank you

1. The population of a state is 2,100,000. In a surveillance project lasting three months, investigators found communicable disease reports documenting one case of anthrax, three cases of mumps, 132 cases of pertussis, 27 cases of tuberculosis, 10 cases of primary and secondary syphilis, and 374 cases of gonorrhea.

Calculate the ratio of cases to population for each disease. Then, calculate the case rate (per 100,000 population per year) for each disease.

Calculate the ratio of cases to population for each disease.

Anthrax- 1 case for 3 months ratio- R=X/Y thus 1/2,586,000

Mumps-    …………………………… ratio- R=X/Y thus 3/2,586,000 reduced to 1/862,000

Calculate the case rate(per 100,000 population per year) for each disease

Anthrax- 1 case per 3 months thus 4 per year ……. [4/2,100,000] * 100,000 = 0.19

Mumps- 3 cases per 3 months thus 12 per year …..[12/2,100,000]* 100,000= 0.57