Following are dated August 31, 2018
1.When the corporation was formed on September 1, 2017, common shares were sold to the sole shareholder, Uncle Bob, for $10,000 cash.
2.Uncle Bob added up all of the invoices the company issued to its customers and the total came to $229,400. All of these were issued on credit.
3.The company received $190,000 cash from customers when they paid their invoices.
4.The company rents a small repair shop for $3,500 per month. The shop was rented for the full year and all rent was paid in cash. In addition, the landlord required the company to pay one month's rent in advance.
5.Salaries to employees totalled $120,000 for the year and were paid in cash.
6.Uncle Bob determined from a review of numerous invoices that the office expenses for the year were $36,400. Of these, all were paid except $4,000 that was still owing.
7.In late August, a new customer approached the company and signed a contract for service to be done to its computers starting in October 2018. The customer paid the company $2,000 in advance to secure the service.
8.Uncle Bob estimated that, given the net income earned by the company this year, income tax
expense should be $6,200 but this would not have to be paid for another two months.
9.The company declared and paid $1,000 of dividends to shareholders at the end of the year.
Question:
a) Prepare an equation analysis of the effects of the above transactions on the expanded accounting equation.
b) Prepare an income statement, statement of changes in equity, and statement of financial position for the year.
In: Accounting
McHale Company does business in two customer segments, Retail and Wholesale. The following annual revenue information was determined from the accounting system's invoice information:
| 20Y5 | 20Y4 | ||
| Retail | $281,820 | $268,400 | |
| Wholesale | 147,576 | 171,600 | |
| Total revenue | $429,396 | $440,000 |
Prepare a horizontal analysis of the segments. Round percentages to one decimal place. Enter negative values as negative numbers.
| McHale Company | ||||
| Horizontal Analysis | ||||
| For the Years 20Y4 and 20Y5 | ||||
| 20Y5 | 20Y4 | Difference - Amount | Difference - Percent | |
| Retail | $281,820 | $268,400 | $ | % |
| Wholesale | 147,576 | 171,600 | % | |
| Total revenue | $429,396 | $440,000 | $ | % |
Prepare a vertical analysis of the segments. If required, round percentages to one decimal place.
| McHale Company | ||||
| Vertical Analysis | ||||
| For the Years 20Y4 and 20Y5 | ||||
| 20Y5 Amount | 20Y5 Percent | 20Y4 Amount | 20Y4 Percent | |
| Retail | $281,820 | % | $268,400 | % |
| Wholesale | 147,576 | % | 171,600 | % |
| Total revenue | $429,396 | % | $440,000 | % |
In: Accounting
on may 15 2006 you obtained an 82000, 15 year home loan at 5.1% compounded monthly,with the first payment due on june 15th 2006. The size of the monthly payment is $652.73
A. Find the balance due on the loan on December 15, 2011.
B. How much interest will be paid on the loan during 2012?
C. If you refinanced the loan on December 15, 2011 at 7.2% interest what will the size of the new payment if the term of the loan remains the same?
D. If you refinanced the loan on December 15, 2011 at 7.2% interest what will the term of the loan if the payment size remains the same?
E. If the original payment is rounded to $700 (and there is no change in the original interest rate), What will the size of the 162nd payment if it is increased from $700 to pay off the balance?
In: Accounting
In an effort to compare vegetation growth in an area a cluster sample was done in 2006 at 8 locations each 1 square foot and mapped with GPS coordiantes.
The next year the researchers came back to the same area to see if vegetation had increased. They used the coordinates and mapped the same square foot units. The data is in the table below. Test to see if vegetation has increased in 2007 from the year previous.
| 2006 | 2007 | |
| Location A | 124 | 132 |
| Location B | 35 | 56 |
| Location C | 21 | 12 |
| Location D | 245 | 270 |
| Location E | 151 | 180 |
| Location F | 78 | 81 |
| Location G | 95 | 11 |
| Location H | 82 | 96 |
Complete all 8 steps of a hypothesis test. You may skip making a histogram.
In: Statistics and Probability
The Seneca Children's Fund is a local charity that runs summer camps for disadvantaged children. The fund's board of directors has been working very hard in recent years to decr4ease the amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentages of the money the fund has raised that was spent on administrative and fund-raising expenses for 2006-2012.
Year Expense (%)
2006 13.7
2007 13.9
2008 14.8
2009 14.6
2010 14.9
2011 15.1
2012 15.6
a. Construct a time series plot. What kind of relationship exists in the data?
b. Develop a linear trend equation for these data.
c. Forecast the percentage of administrative expenses for 2013.
d. Using a smoothing constant of .2 forecast a value for 2013.
In: Math
Customers at the local Subway store order an ice tea with their meal 75% of the time. Use the Binomial distribution to find the answer to the following. __________
Find the probability that among the next 8 customers, at least 3 will order ice tea with their meal: Of the next 8 customers, how many do you expect to order ice tea with their meal? __________
What is the standard deviation of the number of customers that order ice tea among the next 8 customers? (to two places after the decimal) _______
In: Math
Using the Adjusted present value (APV) approach:
BTR Warehousing, which is considering the acquisition of Globo-Chem Co., estimates that acquiring Globo-Chem will result in an incremental value for the firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company:
|
Data Collected (in millions of dollars) |
|||
|---|---|---|---|
| Year 1 | Year 2 | Year 3 | |
| EBIT | $11.0 | $13.2 | $16.5 |
| Interest expense | 3.0 | 3.3 | 3.6 |
| Debt | 34.1 | 40.3 | 43.4 |
| Total net operating capital | 105.1 | 107.1 | 109.1 |
Globo-Chem Co. is a publicly traded company, and its market-determined pre-merger beta is 1.60. You also have the following information about the company and the projected statements:
| • | Globo-Chem currently has a $16.00 million market value of equity and $10.40 million in debt. |
| • | The risk-free rate is 5%, there is a 7.10% market risk premium, and the Capital Asset Pricing Model produces a pre-merger required rate of return on equity rsLsL of 16.36%. |
| • | Globo-Chem’s cost of debt is 7.00% at a tax rate of 30%. |
| • | The projections assume that the company will have a post-horizon growth rate of 4.00%. |
| • | Current total net operating capital is $102.0, and the sum of existing debt and debt required to maintain a constant capital structure at the time of acquisition is $31 million. |
| • | The firm does not have any nonoperating assets such as marketable securities. |
Given this information, use the adjusted present value (APV) approach to calculate the following values involved in merger analysis. (Note: Only round intermediate calculations when entering them as a final answer.)
|
Value |
|
|---|---|
| Unlevered cost of equity | 12.67% (other choices: 9.2%, 14.16%, 10.69%) |
| Horizon value of unlevered cash flows | (110.5, 114.56, 53.06, 86.85) |
| Horizon value of tax shield | (12.96, 12.46, 11.88, 20.76) |
| Unlevered value of operations | (95.47, 96.55, 61.40, 90.85) |
| Value of tax shield | (50.60, 11.40, 15.62, 61.58) |
| Value of operations | Value of operations: (157.05, 112, 106.47, 107.95)
Thus, the total value of Globo-Chem’s equity is (146.65, 86.15, 51, 97.55). Suppose BTR Warehousing plans to use more debt in the first few years of the acquisition of Globo-Chem Co. Assuming that using more debt will not lead to an increase in bankruptcy costs for BTR Warehousing, the interest tax shields and the value of the tax shield in the analysis, will (decrease/increase) , leading to a (higher/lower) value of operations of the acquired firm. The APV approach is considered useful for valuing acquisition targets, because the method involves finding the values of the unlevered firm and the interest tax shield separately and then summing those values. Why is it difficult to value certain types of acquisitions using the corporate valuation model? A) The acquiring firm usually assumes the debt of the target firm. Thus, old debt with different coupon rates usually becomes a part of the acquisition deal. B) The acquiring firm immediately retires the target firm’s old debt. Thus, the acquisition deal consists of only new debt in its capital structure. |
In: Finance
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below:
| Vulcan Flyovers | ||||||
| Operating Data | ||||||
| For the Month Ended July 31 | ||||||
|
Actual Results |
Flexible Budget |
Planning Budget |
||||
| Flights (q) | 57 | 57 | 55 | |||
| Revenue ($355.00q) | $ | 16,400 | $ | 20,235 | $ | 19,525 |
| Expenses: | ||||||
| Wages and salaries ($3,500 + $89.00q) | 8,535 | 8,573 | 8,395 | |||
| Fuel ($30.00q) | 1,880 | 1,710 | 1,650 | |||
| Airport fees ($860 + $32.00q) | 2,559 | 2,684 | 2,620 | |||
| Aircraft depreciation ($10.00q) | 570 | 570 | 550 | |||
| Office expenses ($230 + $1.00q) | 455 | 287 | 285 | |||
| Total expense | 13,999 | 13,824 | 13,500 | |||
| Net operating income | $ | 2,401 | $ | 6,411 | $ | 6,025 |
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount.
Required:
1. Prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Financial Statement Creation – Use the information below to create B/S, I/S and Statement of Retained Earnings after adjusting for the four additional activities below.
|
Accounts Receivable |
$ |
7,500 |
|
Accounts Payable |
650 |
|
|
Cash |
3,700 |
|
|
Service Revenue |
14,500 |
|
|
Common Stock, $2 par, 10,000 authorized |
2,000 |
|
|
Common Stock, add’l pd in capital |
7,000 |
|
|
Equipment, at cost |
12,900 |
|
|
Accumulated depreciation |
2,300 |
|
|
Depreciation Expense |
700 |
|
|
Land |
5,800 |
|
|
Notes Payable, Due 2021 |
8,000 |
|
|
Investment Securities |
1,200 |
|
|
Prepaid Rent |
1,400 |
|
|
Rent Expense |
2,400 |
|
|
Retained Earnings, January 1, 2018 |
5,850 |
|
|
Salaries and Wages Expense |
7,700 |
|
|
Unearned revenue |
3,000 |
|
At year-end, the company accountant realizes that the following transactions have to be recorded:
In: Accounting
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below:
| Vulcan Flyovers | ||||||
| Operating Data | ||||||
| For the Month Ended July 31 | ||||||
| Actual Results |
Flexible Budget |
Planning Budget |
||||
| Flights (q) | 55 | 55 | 53 | |||
| Revenue ($355.00q) | $ | 16,300 | $ | 19,525 | $ | 18,815 |
| Expenses: | ||||||
| Wages and salaries ($3,200 + $86.00q) | 7,898 | 7,930 | 7,758 | |||
| Fuel ($31.00q) | 1,873 | 1,705 | 1,643 | |||
| Airport fees ($860 + $34.00q) | 2,585 | 2,730 | 2,662 | |||
| Aircraft depreciation ($9.00q) | 495 | 495 | 477 | |||
| Office expenses ($200 + $1.00q) | 423 | 255 | 253 | |||
| Total expense | 13,274 | 13,115 | 12,793 | |||
| Net operating income | $ | 3,026 | $ | 6,410 | $ | 6,022 |
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount.
Required:
1. Prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting