Joe operates a business that locates and purchases specialized
assets for clients, among other activities. Joe uses the accrual
method of accounting but he doesn’t keep any significant
inventories of the specialized assets that he sells. Joe reported
the following financial information for his business activities
during year 0.
Determine the effect of each of the following transactions on
the taxable business income. (Select "No Effect" from the
dropdown if no change in the taxable business
income.)
Required:
Joe has signed a contract to sell gadgets to the city. The contract provides that sales of gadgets are dependent upon a test sample of gadgets operating successfully. In December, Joe delivers $13,350 worth of gadgets to the city that will be tested in March. Joe purchased the gadgets especially for this contract and paid $9,450.
Joe paid $275 for entertaining a visiting out-of-town client. The client didn’t discuss business with Joe during this visit, but Joe wants to maintain good relations to encourage additional business next year.
On November 1, Joe paid $590 for premiums providing for $59,000 of “key man” insurance on the life of Joe’s accountant over the next 12 months.
At the end of year 0, Joe’s business reports $11,850 of accounts receivable. Based upon past experience, Joe believes that at least $2,570 of his new receivables will be uncollectible.
In December of year 0, Joe rented equipment to complete a large job. Joe paid $5,850 in December because the rental agency required a minimum rental of three months ($1,950 per month). Joe completed the job before year-end, but he returned the equipment at the end of the lease.
Joe hired a new sales representative as an employee and sent her to Dallas for a week to contact prospective out-of-state clients. Joe ended up reimbursing his employee $490 for airfare, $540 for lodging, $440 for meals, and $340 for entertainment (Joe provided adequate documentation to substantiate the business purpose for the meals and entertainment). Joe requires the employee to account for all expenditures in order to be reimbursed.
Joe uses his BMW (a personal auto) to travel to and from his residence to his factory. However, he switches to a business vehicle if he needs to travel after he reaches the factory. Last month, the business vehicle broke down and he was forced to use the BMW both to travel to and from the factory and to visit work sites. He drove 215 miles visiting work sites and 84 miles driving to and from the factory from his home. Joe uses the standard mileage rate to determine his auto-related business expenses. (Round your answer to whole number. Use standard mileage rate.)
Joe paid a visit to his parents in Dallas over the Christmas holidays. While he was in the city, Joe spent $145 to attend a half-day business symposium. Joe paid $390 for airfare, $126 for meals during the symposium, and $77 on cab fare to the symposium.
In: Accounting
Using the Vehicle Ratings Excel file, create formulas using nested IF, AND, and OR functions to implement the three rating schemes described on the spreadsheet.
| Rating 1 | ||||||||||||||||
| If the vehicle has A/C and a sunroof or it is newer than 2013, then YES, otherwise NO. | ||||||||||||||||
| Rating 2 | ||||||||||||||||
| If the vehicle is Red and does not have high miles, then YES, otherwise if it is a Ford or Chevy, MAYBE, otherwise NO. | ||||||||||||||||
| Rating 3 | ||||||||||||||||
| If the vehicle is older than 2013 and is priced under $15,000 or it is a Honda with a sunroof, then YES, otherwise, if the vehicle is a black Accord or black Corolla, then MAYBE, otherwise NO. |
| Make | Model | Year | Color | A/C | Sunroof | Mileage | High Miles | Price | Rating 1 | Rating 2 | Rating 3 |
| Toyota | Corolla | 2009 | Silver | No | Yes | 73,497 | No | $10,497 | |||
| Chevrolet | Malibu | 2012 | Blue | No | Yes | 84,690 | No | $11,489 | |||
| Ford | Fusion | 2014 | Black | Yes | No | 109,308 | Yes | $11,815 | |||
| Honda | Accord | 2013 | Red | No | No | 85,353 | No | $12,493 | |||
| Ford | Focus | 2014 | Black | Yes | No | 103,742 | Yes | $12,507 | |||
| Toyota | Corolla | 2014 | Black | No | Yes | 109,295 | Yes | $12,593 | |||
| Honda | Civic | 2012 | White | Yes | Yes | 119,522 | Yes | $13,333 | |||
| Chevrolet | Impala | 2013 | Blue | Yes | No | 108,226 | Yes | $13,630 | |||
| Chevrolet | Impala | 2009 | Blue | Yes | Yes | 111,691 | Yes | $13,980 | |||
| Ford | Focus | 2012 | Black | No | Yes | 75,772 | No | $14,251 | |||
| Honda | Accord | 2012 | Silver | Yes | No | 75,220 | No | $14,258 | |||
| Chevrolet | Malibu | 2012 | Blue | No | No | 81,587 | No | $15,246 | |||
| Ford | Fusion | 2010 | Red | No | Yes | 79,049 | No | $15,790 | |||
| Honda | Civic | 2009 | Blue | Yes | No | 88,548 | No | $16,036 | |||
| Toyota | Camry | 2013 | Silver | Yes | Yes | 115,050 | Yes | $16,344 | |||
| Honda | Accord | 2013 | Silver | No | No | 77,072 | No | $16,355 | |||
| Chevrolet | Malibu | 2011 | Blue | No | Yes | 82,792 | No | $16,556 | |||
| Toyota | Camry | 2010 | Red | Yes | Yes | 88,163 | No | $17,248 | |||
| Chevrolet | Silverado | 2009 | White | No | No | 100,179 | Yes | $17,964 | |||
| Toyota | Corolla | 2013 | Blue | Yes | Yes | 117,039 | Yes | $17,965 | |||
| Honda | Civic | 2012 | Red | Yes | No | 73,533 | No | $19,722 | |||
| Honda | Civic | 2011 | White | Yes | No | 88,786 | No | $19,864 | |||
| Chevrolet | Impala | 2011 | Silver | Yes | Yes | 77,060 | No | $20,339 | |||
| Ford | F-150 | 2014 | Red | Yes | No | 105,489 | Yes | $20,380 | |||
| Ford | Fusion | 2013 | Silver | No | No | 109,223 | Yes | $20,532 | |||
| Ford | F-150 | 2012 | Red | No | No | 76,025 | No | $20,659 | |||
| Honda | Accord | 2010 | Blue | Yes | No | 76,701 | No | $21,138 | |||
| Chevrolet | Silverado | 2014 | Silver | Yes | No | 72,319 | No | $21,148 | |||
| Chevrolet | Malibu | 2013 | White | No | No | 117,518 | Yes | $21,183 | |||
| Chevrolet | Silverado | 2009 | Black | No | Yes | 101,839 | Yes | $21,226 | |||
| Chevrolet | Malibu | 2014 | Blue | Yes | No | 80,179 | No | $21,466 | |||
| Toyota | Camry | 2010 | Blue | No | Yes | 74,937 | No | $21,976 | |||
| Ford | F-150 | 2011 | Black | Yes | Yes | 117,249 | Yes | $22,883 | |||
| Ford | Focus | 2014 | Silver | Yes | No | 77,527 | No | $23,235 | |||
| Ford | Fusion | 2011 | White | Yes | Yes | 81,907 | No | $23,835 |
In: Finance
(1) C&A's potato chip filling process has a lower specification limit of 9.5 oz and an upper specification limit of 10.5 oz. The standard deviation is 0.3 oz. and the mean is 10 oz. What is the process capability index (Cp) for the chip filling process?
(a) 0.56
(b) 1.11
(c) 0.33
(d) 3.33
(2) Which of the following represents customer requirement from a process?
(a) Sample size in control charts
(b) USL and LSL
(c) Process standard deviation
(d) UCL and LCL
(3) The mean of a process is 50, and the standard deviation is 2. The company uses statistical control process (SPC) to monitor the process. It uses sample size on 4, and 3 sigma (z=3) control limits. What are the Upper Control Limit (UCL) and Lower Control Limit (LCL)?
(a) LCL=48 and UCL=52
(b) LCL=44 and UCL=56
(c) LCL=47 and UCL=53
(d) LCL=49 and UCL=51
(4) If a company narrows the control limits for a process without making any other changes, which of the following will happen?
(a) The process will generate more products not acceptable by customers
(b) The process will not be stopped even when assignable cause is present
(c) The capability index for the process will reduce to a lower value
(d) The process will be stopped more often suspecting assignable cause
In: Other
Meega Airlines decided to offer direct service from Akron to Clearwater Beach, Florida. Management must decide between full-price service using a company’s new fleet of jet aircraft and a discount-service using smaller capacity commuter planes. Management developed estimates of the contribution to profit for each type of service based upon two possible levels of demand for service on Clearwater Beach: high, moderate, and low. The following table shows the estimated quarterly profits (in thousands of dollars):
|
Service |
Demand for service |
||
|
High |
Medium |
Low |
|
|
Full Price |
900 |
760 |
-430 |
|
Discount |
710 |
650 |
350 |
The prior distribution for the demand is P(High) = 0.3, P(Medium) = 0.5, and P (Low) = 0.2, respectively.
(a) Calculate the expected value of each decision alternative and recommend the best strategy based on the expected value.
(b) Meega Airlines considers market research before making a decision. Market research produces the following posterior distribution of the states of nature. Calculate the expected value of each decision under each market research outcome.
|
Market research outcome |
Posterior probability |
||
|
High |
Medium |
Low |
|
|
Good |
.75 |
.20 |
.05 |
|
Moderate |
.35 |
.50 |
.15 |
|
Poor |
.15 |
.30 |
.55 |
(c) Create a decision tree with the expected value of each decision as a payoff, including branches for each market research outcome and a branch for no market research.
In: Statistics and Probability
Suppose you are the manager of a mutual fund and hold a RM10
million stock portfolio. The
required market risk premium is 6.5% and the risk fee rate is 3%.
Stock A & B are 20% each
of its total portfolio, Stock C and D are 25% and 18% and the
remainder goes to Stock E.
Beta for Stock A, B, C, D and E are 0.75, 1.30, 1.6, 0.5 and 1.2.
The return for stock A and B
are 25% and 18% while Stock C and D are 12% and 30%. Return for
Stock E less 10% than
Stock A.
Randomly you pick two stocks, Stock A & C to look either
both of these are positively or
negatively correlated. Before make any decisions either to remain
holding in the portfolio or
to sell in the market. You are prefer to maintain those stocks that
able to give higher return
and try to minimise the risk.
| State of economy | boom | Normal | Recession |
| Probability | 0.3 | 0.5 | 0.2 |
| Stock A return | 20% | 10% | 7% |
| Stock C return | -15% | 12% | 30% |
Required:
a. Compute the expected return of your portfolio.
b. Compute the portfolio beta.
c. Compute the expected return and standard deviation for Stock A
& Stock C.
d. Compute the covariance and correlation of Stock A &
C.
e. What you find out about your portfolio and from (d). Any
suggestion(s)?
In: Finance
Problem Set 2: Linear Regression Analysis
Research Scenario: A social psychologist is interested in whether the number of days spent in a refugee camp predicts trauma levels in recently resettled refugees. He interviews 17 refugees to determine how many days they spent in a refugee camp before being resettled, then administers the Harvard Trauma Questionnaire Part IV (HTQ Part 4), where a higher score indicates higher levels of trauma (Mollica et al., 1992). He compiles the information in the table below.
Using this table, enter the data into a new SPSS data file and run a linear regression analysis to test whether days in a refugee camp predict HTQ-4 scores. Create a scatterplot with a regression line to show the relationship between the variables.
|
Days Spent in Refugee Camp |
HTQ Part 4 Score |
|
12 |
0.4 |
|
73 |
1.1 |
|
60 |
0.9 |
|
105 |
2.3 |
|
98 |
1.7 |
|
76 |
0.3 |
|
89 |
0.7 |
|
173 |
2.6 |
|
189 |
3.1 |
|
203 |
3.0 |
|
138 |
1.9 |
|
215 |
2.5 |
|
71 |
0.7 |
|
67 |
1.2 |
|
63 |
1.8 |
|
184 |
2.9 |
|
63 |
0.6 |
In: Statistics and Probability
Problem Set 2: Linear Regression Analysis
Research Scenario: A social psychologist is interested in whether the number of days spent in a refugee camp predicts trauma levels in recently resettled refugees. He interviews 17 refugees to determine how many days they spent in a refugee camp before being resettled, then administers the Harvard Trauma Questionnaire Part IV (HTQ Part 4), where a higher score indicates higher levels of trauma (Mollica et al., 1992). He compiles the information in the table below.
Using this table, enter the data into a new SPSS data file and run a linear regression analysis to test whether days in a refugee camp predict HTQ-4 scores. Create a scatterplot with a regression line to show the relationship between the variables.
|
Days Spent in Refugee Camp |
HTQ Part 4 Score |
|
12 |
0.4 |
|
73 |
1.1 |
|
60 |
0.9 |
|
105 |
2.3 |
|
98 |
1.7 |
|
76 |
0.3 |
|
89 |
0.7 |
|
173 |
2.6 |
|
189 |
3.1 |
|
203 |
3.0 |
|
138 |
1.9 |
|
215 |
2.5 |
|
71 |
0.7 |
|
67 |
1.2 |
|
63 |
1.8 |
|
184 |
2.9 |
|
63 |
0.6 |
In: Statistics and Probability
Suppose 1% of the population of Toronto has been infected with SARS-CoV-2 at some point (call the corresponding proportion, 0.01, the prevalence of the virus). There are now antibody tests available for SARS-CoV-2 to detect whether someone has ever been infected. However, like any test, these tests are not perfect and are subject to error at some rate.
Also suppose that, when someone has been infected, the test correctly comes up positive 98% of the time, comes up negative 1.7% of the time, and comes up inconclusive in the remaining 0.3% of cases. Also suppose that when someone has not been infected, the test correctly comes up negative 99% of the time, positive 0.8% of the time, and inconclusive 0.2% of the time.
Let ?D be the event that a randomly selected person in Toronto has truly been infected (?D for disease). Thus, ??Dc is the event that the person has never been infected. Let ++ be the event that a test comes up positive, and – the event it comes up negative. Use ?O for inconclusive.
Draw a probability tree to depict the relationship between these events (see Lecture 7). Use the tree to compute ?(?|+)P(D|+), the probability that someone has been infected conditional on getting a positive test result. What does this result mean in words and why might it be surprising (1-2 sentences)?
In: Statistics and Probability
The sales and finance team of a car company is evaluating a new
proposed luxury model of its
brand that will require an investment of $1Billion in a new machine
for car interior decoration.
Demand for the company’s car is expected to begin at 100,000 units
in year 1, with 10% annual
growth thereafter. Production cost will be $35,000 per unit in the
first year, and increase by a rate
of either 3% or 5% per year as a result of wage increase. Selling
price will start at $37,000 and
increase by 4% of the production cost. The model will be phased out
at the end of year 10. In
addition, 0.3%, 2% and 1.5% of before tax profit per year will be
spent on social corporate
responsibility, commercial (including promotions) and recalls
respectively. Assume taxes will be
30% of yearly profit and that inflation will remain at 0% per year
throughout the 10 year of
production. Also assume interest rate is expected to be 3% per year
in the first 5 years and 5% in
the last 5 years.
a. Based on present worth analysis, is the proposed investment
profitable if production cost
increases by a rate of 3% per year as a result of wage increase?
Justify your answer.
b. Based on present worth analysis, is the proposed investment
profitable if production cost
increases by a rate of 5% per year as a result of wage increase?
Justify your answer.
In: Accounting
RS p.1.c. manufactures domestic food mixers. It is investigating whether or not to accept a three-year contract to make a new model for sale through a supermarket chain. The contract uses skilled labour which cannot be increased above that currently available and RS p.1.c. will receive a fixed price of £42 per mixer for all the mixers it can produce in the three-year period. The following estimates have been made:
Capital investment £50000 payable now, with nil scrap value.
Additional overhead £25000 per annum.
Materials £30 per mixer Labour £6 per hour.
The factory manager knows from experience of similar machines that there will be a learning effect for labour. He estimates that this will take the form:
y = ax-0.3
where y = average labour hours per unit
a = labour hours for first unit
x = cumulative production
He estimates that the first mixer will take 10 hours to produce and that the fixed amount of labour available will enable 5000 mixers to be produced in the first year. Apart from the capital investment, all cash flows can be assumed to arise at year ends. The company has a cost of capital of 15%. You are required
(a) to calculate the NPV of the proposed contract
(b) to state what other factors need to be considered before a final decision is made.
In: Accounting