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:
(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
In: Finance
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:
In: Computer Science
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.
In: Statistics and Probability
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:
|
Ages for Employees Working for Three Districts |
|||||||||||
|
District A |
35 |
25 |
44 |
62 |
55 |
22 |
31 |
41 |
36 |
65 |
|
|
District B |
47 |
37 |
25 |
24 |
22 |
31 |
33 |
35 |
27 |
36 |
|
|
District C |
20 |
40 |
40 |
35 |
42 |
47 |
50 |
52 |
54 |
60 |
|
In: Advanced Math
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.
In: Finance
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
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
In: Math
Hydropump, Inc. produces and sells high-quality pumps to business customers. Its marketing research shows a growing market for a similar type of pump aimed at final consumers-for use with jacuzzi-style tubs in home remodeling jobs. Hydropump will have to develop new channels of distribution to reach this target market because most consumers rely on a retailer for advice about the combination of tub, pump, heater, and related plumbing fixtures they need. Hydropump's marketing manager. Robert Black, is trying to decide between intensive and selective distribution. With intensive distribution, he wouid try to sell through all the plumbing supply, bathroom fixture, and hot-tub retailers who will carry the pump. He estimates that about 5,600 suitable retailers would be willing to carry a new pump. With selective distribution, he would focus on about 280 of the best hot-tub dealers (two or three in the hundred largest metropolitan areas).
Intensive distribution would require Hydropump to do more mass selling-primarily advertising in home renovation magazines-to help stimulate consumer familiarity with the brand and convince retailers that Hydropump equipment will sell. The price to the retailer might have to be lower too (to permit a bigger markup) so they will be motivated to sell Hydropump rather than some other brand offering a smaller markup.
With intensive distribution, each Hydropump sales rep could probably handle about 300 retailers effectively. With selective distribution, each sales rep could handle only about 70 retailers because more merchandising help would be necessary. Managing the smaller sales force and fewer retailers—with the selective approach-would require less manager overhead cost.
Going to all suitable and available retailers would make the pump available through about 20 times as many retailers and have the potential of reaching more customers. However, many customers shop at more than one retailer before making a final choice-so selective distribution would reach almost as many potential customers. Further, if Hydropump is using selective distribution, it would get more in-store sales attention for its pump-and a larger share of pump purchases-at each retailer.
Black has decided to use a spreadsheet to analyze the benefits and costs of intensive versus selective distribution.
f. Hydropump's marketing manager thinks that the hot-tub dealers will pay more attention to the company's product if they get a higher than normal level of attention and help from Hydropump sales reps. However, a sales rep would only be able to spend the extra time with each dealer if he is responsible for fewer accounts. If each rep is assigned only 47 dealers, instead of 70, how many more sales reps would be needed, and how much would personal selling costs increase?
number of sales reps needed at 47 dealers per rep _________
personal selling cost for this number of sales reps _________
less, personal selling cost for 4 sales reps $72,000
equals, increase in personal selling cost _________
In: Accounting
1. List the four elements that must be present for a market to exist.
2. What is the market process?
3. What is the difference between demand and want?
4. Briefly explain each of the following:
a) The market-size effect
b) The real income effect
c) The substitution effect
5. Why does a fall in price increase real income?
6. Why is the typical demand curve downward sloping?
7. What are normal goods? Give three specific examples of normal goods.
8. What are inferior goods? Give three specific examples of inferior goods.
9. With the help of an appropriate diagram, explain the difference between a change in demand and a change in quantity demanded.
10. How is an increase in demand illustrated on a graph? How is a decrease in demand illustrated on a graph?
11. What is the difference between supply and quantity supplied?
12. What is a supply schedule?
13. State the law of supply.
14. Explain how price serves as a production motivator.
15. What is a supply curve?
16. Give three examples of production substitutes.
17. What are joint products? Give two examples of joint products.
18. Define each of the following terms:
a) Shortage
b) Surplus
19. What is the effect of a shortage on price? What is the effect of a surplus on price?
20. Define equilibrium price and equilibrium quantity.
In: Economics
According to a social media blog, time spent on a certain social networking website has a mean of 21 minutes per visit. Assume that time spent on the social networking site per visit is normally distributed and that the standard deviation is 3 minutes. Complete parts (a) through (d) below.
a. If you select a random sample of 16 sessions, what is the probability that the sample mean is between 20.5 and 21.5 minutes? nothing (Round to three decimal places as needed.)
b. If you select a random sample of 16 sessions, what is the probability that the sample mean is between 20 and 21 minutes? nothing (Round to three decimal places as needed.) c. If you select a random sample of 100 sessions, what is the probability that the sample mean is between 20.5 and 21.5 minutes? nothing (Round to three decimal places as needed.)
this part fill in blanks where the arrows are
d. Explain the difference in the results of (a) and (c). The sample size in (c) is greater than the sample size in (a), so the standard error of the mean (or the standard deviation of the sampling distribution) in (c) is ▼ greater less than in (a). As the standard error ▼ increases, decreases, values become more concentrated around the mean. Therefore, the probability that the sample mean will fall in a region that includes the population mean will always ▼ decrease increase when the sample size increases.
In: Statistics and Probability
USE R AND SHOW CODES!!
1.a. An investigator is interested in comparing the cardiovascular fitness of elite runners on three different training courses. course one is at, course 2 has graded inclines, and
course three includes steep inclines, Ten runners were involved for each course. Heart rates measured on each course are as the following table
Course 1 Course 2 Course 3
132 135 138
143 148 148
135 138 141
128 131 139
141 141 150
150 156 161
131 134 138
150 156 162
142 145 151
139 165 160
Is there a significant difference in the mean heart rates of runners on three courses? alpha= 0:05
1.b. The following data is collected on the enzyme activity of MPI (mannose-6-phosphate isomerase) and MPI genotypes separated for male and female.
a. Is there any significant difference between male and female?
b. Is there any significant difference between genotypes?
c. Is there any interaction between sex and genotypes?
DATA
Genotype Female Male
FF 2.838 1.884
4.216 2.889
4.198 2.283
4.939 3.486
FS 3.55 2.396
4.556 2.956
3.087 3.105
1.943 2.649
SS 3.620 2.801
3.079 3.421
3.586 4.275
2.669 3.110
In: Statistics and Probability