You own three stocks:
600600
shares of Apple Computer,
10 comma 00010,000
shares of Cisco Systems, and
5 comma 0005,000
shares of Colgate-Palmolive. The current share prices and expected returns of Apple, Cisco, and Colgate-Palmolive are, respectively,
$ 500$500,
$ 20$20,
$ 100$100
and
12 %12%,
10 %10%,
8 %8%.
a. What are the portfolio weights of the three stocks in your portfolio?
b. What is the expected return of your portfolio?
c. Suppose the price of Apple stock goes up by
$ 25$25,
Cisco rises by
$ 5$5,
and Colgate-Palmolive falls by
$ 13$13.
What are the new portfolio weights?
d. Assuming the stocks' expected returns remain the same, what is the expected return of the portfolio at the new prices?
a. What are the portfolio weights of the three stocks in your portfolio?
The portfolio weight of Apple Computer is
nothing%.
(Round to two decimal places.)The portfolio weight of Cisco Systems is
nothing%.
(Round to two decimal places.)The portfolio weight of Colgate-Palmolive is
nothing%.
(Round to two decimal places.)
b. What is the expected return of your portfolio?
The expected return on the portfolio is
nothing%.
(Round to two decimal places.)c. Suppose the price of Apple stock goes up by
$ 25$25,
Cisco rises by
$ 5$5,
and Colgate-Palmolive falls by
$ 13$13.
What are the new portfolio weights?The new portfolio weight of Apple is
nothing%.
(Round to two decimal places.)The new portfolio weight of Cisco is
nothing%.
(Round to two decimal places.)The new portfolio weight of Colgate-Palmolive is
nothing%.
(Round to two decimal places.)
d. Assuming the stocks' expected returns remain the same, what is the expected return of the portfolio at the new
prices?
The new expected return is
nothing%.
(Round to two decimal places.)
Enter your answer in each of the answer boxes.
In: Finance
| Jan 15 Work in Process 168,000 Factory Overhead 168,000 | |||||||||||||||||||||||||||||||||||||||||||
|
Jan 15 Work in Process 168,000 Cash 168,000 Jan 15 Materials 168,000 Work in Process 168,000
|
|||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||
In: Accounting
*** It flagged the word support so job sub = job support
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $22.60 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 12,500 | hundred square feet |
| Travel to jobs | Miles driven | 315,500 | miles |
| Job sup. | Number of jobs | 1,700 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $379,000 which includes the following costs:
| Wages | $ | 150,000 |
| Cleaning supplies | 35,000 | |
| Cleaning equipment depreciation | 19,000 | |
| Vehicle expenses | 36,000 | |
| Office expenses | 61,000 | |
| President’s compensation | 78,000 | |
| Total cost | $ | 379,000 |
Resource consumption is distributed across the activities as follows:
| Distribution of Resource Consumption Across Activities | ||||||||||
| Cleaning Carpets | Travel to Jobs | Job Sup | Other | Total | ||||||
| Wages | 77 | % | 15 | % | 0 | % | 8 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 69 | % | 0 | % | 0 | % | 31 | % | 100 | % |
| Vehicle expenses | 0 | % | 84 | % | 0 | % | 16 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 57 | % | 43 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 33 | % | 67 | % | 100 | % |
Job sup consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.
Required:
1.Prepare the first-stage allocation of costs to the activity cost pools.
|
2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)
|
3. The company recently completed a 200 square foot carpet-cleaning job at the Flying N Ranch—a 52-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system.
Cost of job =
4. The revenue from the Flying Ranch was $45.20 (200 square feet @ $22.60 per hundred square feet). Calculate the customer margin earned on this job.
Customer Margin =
In: Accounting
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $22.40 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 13,000 | hundred square feet |
| Travel to jobs | Miles driven | 218,000 | miles |
| Job support | Number of jobs | 1,600 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $354,000 which includes the following costs:
| Wages | $ | 148,000 |
| Cleaning supplies | 21,000 | |
| Cleaning equipment depreciation | 15,000 | |
| Vehicle expenses | 33,000 | |
| Office expenses | 64,000 | |
| President’s compensation | 73,000 | |
| Total cost | $ | 354,000 |
Resource consumption is distributed across the activities as follows:
| Distribution of Resource Consumption Across Activities | ||||||||||
| Cleaning Carpets | Travel to Jobs | Job Support | Other | Total | ||||||
| Wages | 74 | % | 16 | % | 0 | % | 10 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 72 | % | 0 | % | 0 | % | 28 | % | 100 | % |
| Vehicle expenses | 0 | % | 80 | % | 0 | % | 20 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 64 | % | 36 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 35 | % | 65 | % | 100 | % |
Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.
Required:
1. Prepare the first-stage allocation of costs to the activity cost pools.
|
2. Compute the activity rates for the activity cost pools.
|
3. The company recently completed a 200 square foot carpet-cleaning job at the Flying N Ranch—a 51-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system.
4. The revenue from the Flying N Ranch was $44.80 (200 square feet @ $22.40 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $22.10 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 7,000 | hundred square feet |
| Travel to jobs | Miles driven | 180,500 | miles |
| Job support | Number of jobs | 2,000 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $352,000 which includes the following costs:
| Wages | $ | 140,000 |
| Cleaning supplies | 34,000 | |
| Cleaning equipment depreciation | 16,000 | |
| Vehicle expenses | 35,000 | |
| Office expenses | 56,000 | |
| President’s compensation | 71,000 | |
| Total cost | $ | 352,000 |
Resource consumption is distributed across the activities as follows:
| Distribution of Resource Consumption Across Activities | ||||||||||
| Cleaning Carpets | Travel to Jobs | Job Support | Other | Total | ||||||
| Wages | 75 | % | 14 | % | 0 | % | 11 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 73 | % | 0 | % | 0 | % | 27 | % | 100 | % |
| Vehicle expenses | 0 | % | 78 | % | 0 | % | 22 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 55 | % | 45 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 32 | % | 68 | % | 100 | % |
Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.
Required:
1. Prepare the first-stage allocation of costs to the activity cost pools.
|
2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)
|
3. The company recently completed a 400 square foot carpet-cleaning job at the Flying N Ranch—a 50-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system. (Round your intermediate calculations and final answer to 2 decimal places.)
|
4. The revenue from the Flying N Ranch was $88.40 (4 hundred square feet @ $22.10 per hundred square feet). Calculate the customer margin earned on this job. (Round your intermediate calculations and final answers to 2 decimal places.)
|
In: Accounting
The Following Information Applies to Questions 21-25:
Johnson Corporation plans to obtain financing with a $1,000,000 bond issue that has a term of 10 years. Payments will be made semi-annually.
21. If the bond (payment) rate is stated at 7%, and the bonds call for semi-annual payments, what is the amount of those payments?
|
a. $350,000 |
||
|
b. $700,000 |
||
|
c. $35,000 |
||
|
d. $70,000 |
22. Completely ignore number 21. Assume that the semi-annual cash payments have already been correctly computed to be $45,000. Given this number, and remembering that the face value of the bonds ($1,000,000) will be paid out at the end of the 10 years, what is the total issue price (present value) of the bonds if the market rate for bond issues of similar risk is 8%, compounded semi-annually? Choose from among the following factors in making your computations. (PVS=Present Value Single, and PVA=Present Value Annuity):
PVS: 4% 8% PVA: 4% 8%
10 periods .676 .463 10 periods 8.111 6.710
20 periods .456 .215 20 periods 13.59 9.818
|
a. $456,000 |
||
|
b. $611,550 |
||
|
c. $764,950 |
||
|
d. $1,067,550 |
23. Completely ignore numbers 21 and 22. Assume that the market rate for bond issues of similar risk is 6%, compounded semi-annually, and that the total issue price for these bonds has already been correctly calculated to be $1,149,120. Given this number, and the market rate of interest, how much interest expense will accrue and be recorded at the end of the first 6 month period?
|
a. $60,000.00 |
||
|
b. $68,947.20 |
||
|
c. $30,000.00 |
||
|
d. $34,473.60 |
24. Completely ignore numbers 21 - 23. Assume that the semi-annual cash payments on the bonds are $50,000, and that the accrued interest on the bonds for the first 6 month period is only $48,700. The carrying value of the bonds will change by an amount of:
|
a. cannot be determined from the information given |
||
|
b. $1,300 increase |
||
|
c. $1,300 decrease |
25. Completely ignore numbers 21-24. Assume the total issue price for these bonds has already been correctly calculated to be $1,020,000, and that the semi-annual cash payment made at the end of the first 6 month period exceeds the accrued interest expense for the period by $2,700. What is the new carrying value of the bonds?
|
a. $1,047,000 |
||
|
b. $993,000 |
||
|
c. $1,017, 300 |
||
|
d. $1,022,700 |
In: Accounting
The Marco family—comprising Mrs. Marco aged 40, Mr. Marco, aged 39, and their three young children— relocated to Barcelona in January 2020 when Mrs. Marco received a job offer from an international firm. They rented a three-bedroom condominium in Barcelona for 2.100€ per month, which included parking and fees.
While renting made life easy, the Marco family began weighing the pros and cons of purchasing a flat, in the same building, that became available in June 2020. The idea of home ownership as a form of long-term investment appealed to the couple. The preliminary rental payments could be used for mortgage payments instead.
While searching for the right property they found a nice apartment at one of the best locations of the city. The apartment was owned and had been promoted by a state-owned construction company and was offering two alternatives:
Option I: renting the apartment with a perpetual contract, meaning forever.
The family was very happy living in that area, and they had the chance to live there forever at an offered price of 1,650 EUR the first month, and the rent price will be growing by a 0.125% monthly. This option would prevent the Marco family from applying for a loan, which represented a heavy burden off the family’ budget.
Option II: consisted in acquiring the property with a mortgage scheme for 35 years. The total price of the apartment is 875.000€. The family can pay an initial down payment of 275,000 EUR and the rest (600,000 EUR) to be paid in constant monthly payments with an annual interest rate of a 2.75% compounded monthly.
Mrs. Marc establishes the maximum amount they can pay monthly as 2.250€.
In this case (yearly payments) what is the total amount the Marco family will have paid in total after 35 years? (again, just find how much has Mrs. Marconi paid in total)
1)In this case (yearly payments), how much has the family saved (if any) by paying yearly instead of monthly installments?
2)In case that the Marco family pays the pending amount in yearly payments, the owner can only grant them 2.75% interest during the first 10 years.
3) There is the possibility that, after the first 10 years the interest rate increases to a 3.25% for the remaining 25 years. How much should the Marco family pay per year from year 11 onwards if this occurs?
In: Finance
INSTRUCTIONS FOR TABLE 1 and Two Graphs-21 points
1) Calculate the Total Cost (TC) for each level of output. (3 points)
2) Calculate the Average Fixed Cost (AFC) for each level of output. (3 points)
3) Calculate the Average Variable Cost (AVC) for each level of output. (3 points)
4) Calculate the Average Total Cost (ATC) for each level of output. (3 points)
5) Calculate the Marginal Cost (MC) for each level of output. (3 points)
Using the data from Table 1 draw two graphs:
Draw a graph showing the Total Fixed Cost, Total Variable Cost, and Total Cost curves. (3 points)
Draw a graph showing the Average Fixed Cost, Average Variable Cost, and Average Total Cost curves and Marginal Cost curve. (3 points)
TABLE 1
(1) (2) (3) (4) (5) (6) (7) (8)
Total Total Total Total Average Average Average Marginal
Product Fixed Variable Cost Fixed Variable Total Cost
Cost Cost Cost Cost Cost
(Q) (TFC) (TVC) (TC) (AFC) (AVC) (ATC) (MC)
0 $100 0 $______ ______
1 100 90 ______ ______ ______ ______ ______
2 100 170 ______ ______ ______ ______ ______
3 100 240 ______ ______ ______ ______ ______
4 100 300 ______ ______ ______ ______ ______
5 100 370 ______ ______ ______ ______ ______
6 100 450 ______ ______ ______ ______ ______
7 100 540 ______ ______ ______ ______ ______
8 100 650 ______ ______ ______ ______ ______
9 100 780 ______ ______ ______ ______ ______
10 100 930 ______ ______ ______ ______ ______
In: Economics
Zero Defects & On-target: There are two manufacturing philosophies of manufacturing. Zero-defects is primarily practiced by American manufacturers and on-target is generally adopted by Japanese companies. Taking an example for an assembly, show how you will choose the target dimensions if you want to be close to the ideal by one SD, two SDs, and three SDs for both manufacturing philosophies. You may assume any adequate SD dimension.
Example: Say the dimension and tolerance given to you is 100 mm (+2 mm / -0 mm). This means the dimension will have the lower specification limit (LSL) of 100 mm and the upper specification limit (USL) of 102 mm, with a needed target of 100 mm. Now say you ran the parts on the machine and found the SD for a set of 30 parts to be 0.03 mm.
With this information you can now attempt to find what target you should aim the machine at.
Ideally the target will be 100 mm but because of the variation in the process, it cannot be 100 mm, but we can be as close to it as possible. The distance we can be away from it for 68% of the output to be good will be 1x SD, for 95% it will be 2 x SD and for 99.73% it will be 3 x SD.
Hence the targets will be as follows:
1) 68% will be 100 + 1x SD = 100 + (1 x 0.03) = 100.03 mm
2) 95% will be 100 + 2x SD = 100 + (2 x 0.03) = 100.06 mm
3) 99.73% will be 100 + 3x SD = 100 + (3 x 0.03) = 100.09 mm
In: Statistics and Probability
Prepare trial balance. Unadjusted/adjusting/adjusted trial balances.
| The following transactions occurred during the first twelve months of operations: | |||||||||
| January 1st | Common stock is issued in exchange for cash in the amount of ………….………….……………………… | 295,000 | |||||||
| February 8th | The company purchases and pays for 160 units of gourmet dog food at a price of $25 per unit ………….. | 4,000 | |||||||
| March 1st | The company pays cash for a one-year insurance policy in the amount of ……………….………………………..….. | 9,300 | |||||||
| March 31st | Rent on a retail space for 12 months is paid in the amount of …..……….……………………………………… | 12,480 | |||||||
| April 1st | Grooming and boarding equipment with a useful life of 2 years is purchased for cash in the amount of …… | 18,000 | |||||||
| April 10th | Grooming supplies purchased on account in the amount of …………..…………………………………………… | 1,450 | |||||||
| May 15th | The company purchases and pays for another 370 units of gourmet dog food at a price of $29 per unit ….. | 10,730 | |||||||
| May 30th | Grooming services are performed on account in the amount of …………………………………………………………..………… | 13,625 | |||||||
| June 1st | The company pays for advertisements to be run for the next 12 months in the amount of ………………………. | 864 | |||||||
| June 30th | The company issues a 5-year bond with a face value of $100,000 and a stated annual rate of 6%. | ||||||||
| Interest is due on June 30th each year. The market rate is 8% on the date of issuance ……………………………. | 100,000 | ||||||||
| July 25th | Dog-walking services are performed on account in the amount of …...……………………………..………… | 14,225 | |||||||
| July 31st | 95 units of gourmet dog food are sold for $70 per unit with terms 2/10, n/30. The sale is recorded using | ||||||||
| the gross method in the amount of (see note c for cost flow assumptions) ……………………………………………………………………………………. | 6,650 | ||||||||
| August 2nd | Boarding services are provided on account in the amount of ………………………………………………………………. | 6,280 | |||||||
| August 6th | The company receives full payment from the customer for the July 31st sale ……………………………………… | 6,517 | |||||||
| September 15th | Pet sitting services are performed on account in the amount of ……………………..…………………………….………….. | 6,245 | |||||||
| September 29th | Customer payments are received for services previously provided in the amount of ……………………………….. | 1,250 | |||||||
| October 13th | 100 units of gourmet dog food are sold for $73 per unit with terms 2/10, n/30. The sale is recorded using | ||||||||
| the gross method in the amount of ………………………………………………………………………………………. | 7,300 | ||||||||
| October 29th | The company receives payment for half of the October 13th sale ……………………………………………………… | 3,650 | |||||||
| November 1st | Equipment originally purchased on April 1st for $2400 is sold for $2000 cash | ||||||||
| November 15th | A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation | ||||||||
| December 15th | The bookkeeper is paid $3,500 for the previous month's services | 3,500 | |||||||
| Additional information: | ||||||||
| Grooming supplies on hand at the end of the month are as follows: ……………………………………. | 870 | |||||||
| The year-end balance reported at the end of the year for the Allowance for Doubtful Accounts | ||||||||
| is estimated as 4% of outstanding receivables at the end of the year | ||||||||
| The Company uses a perpetual inventory system and accounts for costs using the First-In-First-Out cost | ||||||||
| flow assumption. On December 31st, a count of ending inventory reveals that there are 335 bags of dog | ||||||||
| food on hand. | ||||||||
| All revenue is recorded in the "Sales Revenue" account and reported net of cash discounts on the income statement. | ||||||||
| The effective interest method is used to amortize bond premiums and discounts | ||||||||
| Adjustments are made at the end of the year for prepaid insurance, rent, advertising, depreciation, and interest expense. | ||||||||
| The bookkeeper is paid a salary of $3,500 on the 15th of every month. | ||||||||
| The company declared dividends of $650 for the year | ||||||||
| Assume selling expenses include advertising and supplies expense. All other expenses, other than depreciation | ||||||||
| and interest expense, are considered general & administrative. | ||||||||
In: Accounting