A large sports supplier has many stores located world wide. A regression model is to be constructed to predict the annual revenue of a particular store based upon the population of the city or town where the store is located, the annual expenditure on promotion for the store and the distance of the store to the center of the city.

Data has been collected on 30 randomly selected stores: show data

a)Find the multiple regression equation using all three explanatory variables. Assume that X₁ is population, X₂ is annual promotional expenditure and X₃ is distance to city center. Give your answers to 3 decimal places.

y^ =  + population + promo. expenditure + dist. to city

b)At a level of significance of 0.05, the result of the F test for this model is that the null hypothesis is, is not rejected.

For parts c) and d), using the data, separately calculate the correlations between the response variable and each of the three explanatory variables.

c)The explanatory variable that is most correlated with annual revenue is:

population
promotional expenditure
distance to city

d)The explanatory variable that is least correlated with annual revenue is:

population
promotional expenditure
distance to city

e)The value of R² for this model, to 2 decimal places, is equal to

f)The value of s_e for this model, to 3 decimal places, is equal to

g)Construct a new multiple regression model by removing the variable distance to city center. Give your answers to 3 decimal places.

The new regression model equation is:

y^ =  + population + promo. expenditure

h)In the new model compared to the previous one, the value of R² (to 2 decimal places) is:

increased
decreased
unchanged

i)In the new model compared to the previous one, the value of s_e (to 3 decimal places) is:

increased
decreased
unchanged

The following tables contain financial statements for Dynastatics Corporation. Although the company has not been growing, it now plans to expand and will increase net fixed assets (i.e., assets net of depreciation) by $240,000 per year for the next 5 years, and it forecasts that the ratio of revenues to total assets will remain at 1.50. Annual depreciation is 10% of net fixed assets at the beginning of the year. Fixed costs are expected to remain at $64 and variable costs at 80% of revenue. The company’s policy is to pay out two-thirds of net income as dividends and to maintain a book debt ratio of 20% of total capital.

Required:

a1. Produce an income statement for 2020. Assume that net working capital will equal 50% of fixed assets.

a2. Produce a balance sheet for 2020. Assume that net working capital will equal 50% of fixed assets.

b. Now assume that the balancing item is debt and that no equity is to be issued. Prepare a completed pro forma balance sheet for 2020.

c. Assume that the balancing item is debt and that no equity is to be issued, what is the projected debt ratio for 2022?

The following income statement items appeared on the adjusted trial balance of Schembri Manufacturing Corporation for the year ended December 31, 2018 ($ in 000s): sales revenue, $18,900; cost of goods sold, $8,000; selling expenses, $1,480; general and administrative expenses, $980; interest revenue, $240; interest expense, $200. Income taxes have not yet been recorded. The company’s income tax rate is 40% on all items of income or loss. These revenue and expense items appear in the company’s income statement every year. The company’s controller, however, has asked for your help in determining the appropriate treatment of the following nonrecurring transactions that also occurred during 2018 ($ in 000s). All transactions are material in amount.

1. Investments were sold during the year at a loss of $400. Schembri also had unrealized gains of $550 for the year on investments.
2. One of the company’s factories was closed during the year. Restructuring costs incurred were $2,100.
3. During the year, Schembri completed the sale of one of its operating divisions that qualifies as a component of the entity according to GAAP. The division had incurred a loss from operations of $740 in 2018 prior to the sale, and its assets were sold at a gain of $1,760.
4. In 2018, the company’s accountant discovered that depreciation expense in 2017 for the office building was understated by $380.
5. Negative foreign currency translation adjustment for the year totaled $420.

Required:
1. Prepare Schembri’s single, continuous multiple-step statement of comprehensive income for 2018, including earnings per share disclosures. One million shares of common stock were outstanding at the beginning of the year and an additional 400,000 shares were issued on July 1, 2018.
2. Prepare a separate statement of comprehensive income for 2018.

Garvey Company’s unadjusted trial balance includes the following account balances as of December 31, 2015: Debits Credits Cash $ 69,290 Accounts receivable 118,100 Interest receivable 1,360 Supplies 140,700 Prepaid insurance 8,850 Notes Receivable (short-term) 50,900 Equipment 282,000 Accumulated Depreciation––Equipment $ 65,400 Accounts payable 105,600 Salaries and Wages Payable 21,900 Unearned revenue 9,500 Notes Payable (long-term) 88,600 Common Stock 219,400 Retained earnings 145,600 Service revenue 41,100 Interest revenue 22,200 Supplies Expense 0 Repair and Maintenance Expense 26,850 Rent Expense 18,100 Depreciation Expense 0 Insurance Expense 0 Salaries and Wages Expense 3,150 Totals $ 719,300 $ 719,300

The following data are available to determine adjusting entries: A) Insurance purchased at the beginning of July for $8,850 provided coverage for twelve months (July 2015 through June 2016). The insurance coverage for July through December totaling $4,425 has now been used. B) The company estimates $8,300 in depreciation each year. C) Account showed $87,200 of supplies on hand at the end of the year. D) An additional $290 of interest has been earned but has not yet been uncollected on the outstanding notes receivable. E) Services in the amount of $5,750 were performed for customers who had previously paid in advance. F) Services in the amount of $2,300 were performed; these services have not yet been billed or recorded.

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:

For example, electricity costs are $1,100 per month plus $0.06 per car washed. The company expects to wash 8,500 cars in August and to collect an average of $6.10 per car washed.

The actual operating results for August appear below.

Required:

Prepare a flexible budget performance report that shows the company’s revenue and spending variances and activity variances for August. (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.)

The following tables contain financial statements for Dynastatics Corporation. Although the company has not been growing, it now plans to expand and will increase net fixed assets (i.e., assets net of depreciation) by $210,000 per year for the next 4 years, and it forecasts that the ratio of revenues to total assets will remain at 1.50. Annual depreciation is 20% of net fixed assets at the beginning of the year. Fixed costs are expected to remain at $58 and variable costs at 70% of revenue. The company’s policy is to pay out one-half of net income as dividends and to maintain a book debt ratio of 20% of total capital.

Required:

a1. Produce an income statement for 2020. Assume that net working capital will equal 50% of fixed assets.

a2. Produce a balance sheet for 2020. Assume that net working capital will equal 50% of fixed assets.

b. Now assume that the balancing item is debt and that no equity is to be issued. Prepare a completed pro forma balance sheet for 2020.

c. Assume that the balancing item is debt and that no equity is to be issued, what is the projected debt ratio for 2022?

Wildhorse Creek Golf Inc. was organized on July 1, 2022. Quarterly financial statements are prepared. The trial balance and adjusted trial balance on September 30 are shown as follows.

1. Journalize the adjusting entries that were made. (If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Credit account titles are automatically indented when the amount is entered. Do not indent manually.)

2.Prepare an income statement for the 3 months ending September 30.

3.Prepare a classified balance sheet at September 30. (List current assets in order of liquidity.)

4.Identify which accounts should be closed on September 30.

5.If the note bears interest at 12%, how many months has it been outstanding?

Ken Lumas started his own consulting firm, Lumas Consulting, on June 1, 2021. The trial balance at June 30 is as follows.

In addition to those accounts listed on the trial balance, the chart of accounts for Lumas also contains the following accounts: Accumulated Depreciation—Equipment, Salaries and Wages Payable, Depreciation Expense, Insurance Expense, Utilities Expense, and Supplies Expense.

Other data:

QUESTION:

A) Post the adjusting entries to the ledger accounts. Enter the totals from the trial balance as beginning account balances. (Use T-Accounts.) (Post entries in the order of journal entries presented in the previous question.)

B) Prepare an adjusted trial balance at June 30, 2021.

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:

For example, electricity costs are $1,200 per month plus $0.06 per car washed. The company expects to wash 8,000 cars in August and to collect an average of $6.20 per car washed.

The actual operating results for August appear below.

Required:

Prepare a flexible budget performance report that shows the company’s revenue and spending variances and activity variances for August. (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 the blanks provided to the right below, select the letters of the underlying assumption, measurement method, qualitative criteria, or constraint most closely associated with the statements. Some letters may be used more than once and some may not be used at all.