Questions
Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the...

Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2017.

DIMSDALE SPORTS COMPANY
Estimated Balance Sheet
December 31, 2017
Assets
Cash $ 36,000
Accounts receivable 525,000
Inventory 150,000
Total current assets $ 711,000
Equipment 540,000
Less: accumulated depreciation 67,500
Equipment, net 472,500
Total assets $ 1,183,500
Liabilities and Equity
Accounts payable $ 360,000
Bank loan payable 15,000
Taxes payable (due 3/15/2018) 90,000
Total liabilities $ 465,000
Common stock 472,500
Retained earnings 246,000
Total stockholders’ equity 718,500
Total liabilities and equity $ 1,183,500


To prepare a master budget for January, February, and March of 2018, management gathers the following information.

The company’s single product is purchased for $30 per unit and resold for $55 per unit. The expected inventory level of 5,000 units on December 31, 2017, is more than management’s desired level, which is 20% of the next month’s expected sales (in units). Expected sales are: January, 7,000 units; February, 9,000 units; March, 11,000 units; and April, 10,000 units.

Cash sales and credit sales represent 25% and 75%, respectively, of total sales. Of the credit sales, 60% is collected in the first month after the month of sale and 40% in the second month after the month of sale. For the December 31, 2017, accounts receivable balance, $125,000 is collected in January and the remaining $400,000 is collected in February.

Merchandise purchases are paid for as follows: 20% in the first month after the month of purchase and 80% in the second month after the month of purchase. For the December 31, 2017, accounts payable balance, $80,000 is paid in January and the remaining $280,000 is paid in February.

Sales commissions equal to 20% of sales are paid each month. Sales salaries (excluding commissions) are $60,000 per year.

General and administrative salaries are $144,000 per year. Maintenance expense equals $2,000 per month and is paid in cash.

Equipment reported in the December 31, 2017, balance sheet was purchased in January 2017. It is being depreciated over eight years under the straight-line method with no salvage value. The following amounts for new equipment purchases are planned in the coming quarter: January, $36,000; February, $96,000; and March, $28,800. This equipment will be depreciated under the straight-line method over eight years with no salvage value. A full month’s depreciation is taken for the month in which equipment is purchased.

The company plans to buy land at the end of March at a cost of $150,000, which will be paid with cash on the last day of the month.

The company has a working arrangement with its bank to obtain additional loans as needed. The interest rate is 12% per year, and interest is paid at each month-end based on the beginning balance. Partial or full payments on these loans can be made on the last day of the month. The company has agreed to maintain a minimum ending cash balance of $25,000 at the end of each month.

The income tax rate for the company is 40%. Income taxes on the first quarter’s income will not be paid until April 15.


Required:
Prepare a master budget for each of the first three months of 2018; include the following component budgets:

1. Monthly sales budgets.
2. Monthly merchandise purchases budgets.
3. Monthly selling expense budgets.
4. Monthly general and administrative expense budgets.
5. Monthly capital expenditures budgets.
6. Monthly cash budgets.
7. Budgeted income statement for the entire first quarter (not for each month).
8. Budgeted balance sheet as of March 31, 2018.

I have already solved 1-5. Stuck on the last three (6-8).

In: Accounting

Near the surface of the Earth there is an electric field of about 150 V/m which...

Near the surface of the Earth there is an electric field of about 150 V/m which points downward. Two identical balls with mass 0.407kg are dropped from a height of 2.29m , but one of the balls is positively charged with q1 = 338?C , and the second is negatively charged with q2=-338?C . Use conservation of energy to determine the difference in the speeds of the two balls when they hit the ground. (Neglect air resistance.)

In: Physics

Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the...

Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2017.

DIMSDALE SPORTS COMPANY
Estimated Balance Sheet
December 31, 2017
Assets
Cash $ 36,000
Accounts receivable 525,000
Inventory 150,000
Total current assets $ 711,000
Equipment 540,000
Less: accumulated depreciation 67,500
Equipment, net 472,500
Total assets $ 1,183,500
Liabilities and Equity
Accounts payable $ 360,000
Bank loan payable 15,000
Taxes payable (due 3/15/2018) 90,000
Total liabilities $ 465,000
Common stock 472,500
Retained earnings 246,000
Total stockholders’ equity 718,500
Total liabilities and equity $ 1,183,500


To prepare a master budget for January, February, and March of 2018, management gathers the following information.

The company’s single product is purchased for $30 per unit and resold for $55 per unit. The expected inventory level of 5,000 units on December 31, 2017, is more than management’s desired level, which is 20% of the next month’s expected sales (in units). Expected sales are: January, 7,000 units; February, 9,000 units; March, 11,000 units; and April, 10,000 units.

Cash sales and credit sales represent 25% and 75%, respectively, of total sales. Of the credit sales, 60% is collected in the first month after the month of sale and 40% in the second month after the month of sale. For the December 31, 2017, accounts receivable balance, $125,000 is collected in January and the remaining $400,000 is collected in February.

Merchandise purchases are paid for as follows: 20% in the first month after the month of purchase and 80% in the second month after the month of purchase. For the December 31, 2017, accounts payable balance, $80,000 is paid in January and the remaining $280,000 is paid in February.

Sales commissions equal to 20% of sales are paid each month. Sales salaries (excluding commissions) are $60,000 per year.

General and administrative salaries are $144,000 per year. Maintenance expense equals $2,000 per month and is paid in cash.

Equipment reported in the December 31, 2017, balance sheet was purchased in January 2017. It is being depreciated over eight years under the straight-line method with no salvage value. The following amounts for new equipment purchases are planned in the coming quarter: January, $36,000; February, $96,000; and March, $28,800. This equipment will be depreciated under the straight-line method over eight years with no salvage value. A full month’s depreciation is taken for the month in which equipment is purchased.

The company plans to buy land at the end of March at a cost of $150,000, which will be paid with cash on the last day of the month.

The company has a working arrangement with its bank to obtain additional loans as needed. The interest rate is 12% per year, and interest is paid at each month-end based on the beginning balance. Partial or full payments on these loans can be made on the last day of the month. The company has agreed to maintain a minimum ending cash balance of $25,000 at the end of each month.

The income tax rate for the company is 40%. Income taxes on the first quarter’s income will not be paid until April 15.


Required:
Prepare a master budget for each of the first three months of 2018; include the following component budgets:

1. Monthly sales budgets.
2. Monthly merchandise purchases budgets.
3. Monthly selling expense budgets.
4. Monthly general and administrative expense budgets.
5. Monthly capital expenditures budgets.
6. Monthly cash budgets.
7. Budgeted income statement for the entire first quarter (not for each month).
8. Budgeted balance sheet as of March 31, 2018.

In: Accounting

Faced with the prospects of a near certain death preceded by severe physical limitation and/or suffering:...

Faced with the prospects of a near certain death preceded by severe physical limitation and/or suffering: Would I consider euthanasia? For what ethical reasons, if any, would I consider ending my life? What ethical reasons, if any, would keep me from ending my life?

In: Nursing

1. PepsiCo, near the top of Table 2-5 in the chapter, is a company that provides...

1. PepsiCo, near the top of Table 2-5 in the chapter, is a company that provides
comprehensive financial statements. Go to finance.yahoo.com. In the box next to
“Get Quotes,” type in its ticker symbol PEP and click.


2. Scroll all the way down to “Financials” and click on “Income Statement.” Compute
the annual percentage change between the three years for the following: (INCOME STATEMENT IS BELOW FOR 3 YEARS IS BELOW)
a. Total revenue.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)
b. Net income applicable to common shares.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)


3. Now click on “Balance Sheet” and compute the annual percentage change ( BALANCE SHEET FOR 3 YEARS IS BELOW)
between the three years for the following:
a. Total assets.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)
b. Total liabilities.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)

4. Write a one-paragraph summary of how the company is doing.

Income Statement

All numbers in thousands

Revenue 12/31/2016 12/26/2015 12/27/2014
Total Revenue 62,799,000 63,056,000 66,683,000
Cost of Revenue 28,209,000 28,731,000 31,238,000
Gross Profit 34,590,000 34,325,000 35,445,000
Operating Expenses
Research Development - - -
Selling General and Administrative 24,735,000 24,538,000 25,772,000
Non Recurring - 1,359,000 1,359,000
Others 70,000 75,000 92,000
Total Operating Expenses - - -
Operating Income or Loss 9,785,000 8,353,000 9,581,000
Income from Continuing Operations
Total Other Income/Expenses Net 110,000 59,000 85,000
Earnings Before Interest and Taxes 9,895,000 8,412,000 9,666,000
Interest Expense 1,342,000 970,000 909,000
Income Before Tax 8,553,000 7,442,000 8,757,000
Income Tax Expense 2,174,000 1,941,000 2,199,000
Minority Interest 104,000 107,000 110,000
Net Income From Continuing Ops 6,329,000 5,452,000 6,513,000
Non-recurring Events
Discontinued Operations - - -
Extraordinary Items - - -
Effect Of Accounting Changes - - -
Other Items - - -
Net Income
Net Income 6,329,000 5,452,000 6,513,000
Preferred Stock And Other Adjustments - - -
Net Income Applicable To Common Shares 6,329,000 5,452,000 6,513,000

Balance Sheet

All numbers in thousands

Period Ending 12/31/2016 12/26/2015 12/27/2014
Current Assets
Cash And Cash Equivalents 9,158,000 9,096,000 6,134,000
Short Term Investments 6,967,000 2,913,000 2,592,000
Net Receivables 6,694,000 6,437,000 6,651,000
Inventory 2,723,000 2,720,000 3,143,000
Other Current Assets 1,547,000 1,865,000 2,143,000
Total Current Assets 27,089,000 23,031,000 20,663,000
Long Term Investments 1,950,000 2,311,000 2,689,000
Property Plant and Equipment 16,591,000 16,317,000 17,244,000
Goodwill 14,430,000 14,177,000 14,965,000
Intangible Assets 13,433,000 13,081,000 14,088,000
Accumulated Amortization - - -
Other Assets 636,000 750,000 860,000
Deferred Long Term Asset Charges - - -
Total Assets 74,129,000 69,667,000 70,509,000
Current Liabilities
Accounts Payable 14,243,000 13,507,000 13,016,000
Short/Current Long Term Debt 6,892,000 4,071,000 5,076,000
Other Current Liabilities - - -
Total Current Liabilities 21,135,000 17,578,000 18,092,000
Long Term Debt 30,053,000 29,213,000 23,821,000
Other Liabilities 6,669,000 5,887,000 5,744,000
Deferred Long Term Liability Charges 5,073,000 4,959,000 5,304,000
Minority Interest 104,000 107,000 110,000
Negative Goodwill - - -
Total Liabilities 63,034,000 57,744,000 53,071,000
Stockholders' Equity
Misc. Stocks Options Warrants -151,000 -145,000 -140,000
Redeemable Preferred Stock - - -
Preferred Stock - - -
Common Stock 24,000 24,000 25,000
Retained Earnings 52,518,000 50,472,000 49,092,000
Treasury Stock -31,468,000 -29,185,000 -24,985,000
Capital Surplus 4,091,000 4,076,000 4,115,000
Other Stockholder Equity -13,919,000 -13,319,000 -10,669,000
Total Stockholder Equity 11,246,000 12,068,000 17,578,000
Net Tangible Assets -16,617,000 -15,190,000 -11,475,000

In: Economics

Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the...

Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2017.

DIMSDALE SPORTS COMPANY
Estimated Balance Sheet
December 31, 2017

Assets

Cash

$

35,500

Accounts receivable

520,000

Inventory

157,500

Total current assets

$

713,000

Equipment

576,000

Less: accumulated depreciation

72,000

Equipment, net

504,000

Total assets

$

1,217,000

Liabilities and Equity

Accounts payable

$

370,000

Bank loan payable

14,000

Taxes payable (due 3/15/2018)

89,000

Total liabilities

$

473,000

Common stock

474,000

Retained earnings

270,000

Total stockholders’ equity

744,000

Total liabilities and equity

$

1,217,000


To prepare a master budget for January, February, and March of 2018, management gathers the following information.

  1. The company’s single product is purchased for $30 per unit and resold for $57 per unit. The expected inventory level of 5,250 units on December 31, 2017, is more than management’s desired level, which is 20% of the next month’s expected sales (in units). Expected sales are: January, 7,000 units; February, 9,000 units; March, 11,500 units; and April, 10,500 units.
  2. Cash sales and credit sales represent 20% and 80%, respectively, of total sales. Of the credit sales, 59% is collected in the first month after the month of sale and 41% in the second month after the month of sale. For the December 31, 2017, accounts receivable balance, $125,000 is collected in January and the remaining $395,000 is collected in February.
  3. Merchandise purchases are paid for as follows: 20% in the first month after the month of purchase and 80% in the second month after the month of purchase. For the December 31, 2017, accounts payable balance, $60,000 is paid in January and the remaining $310,000 is paid in February.
  4. Sales commissions equal to 20% of sales are paid each month. Sales salaries (excluding commissions) are $72,000 per year.
  5. General and administrative salaries are $144,000 per year. Maintenance expense equals $2,100 per month and is paid in cash.
  6. Equipment reported in the December 31, 2017, balance sheet was purchased in January 2017. It is being depreciated over eight years under the straight-line method with no salvage value. The following amounts for new equipment purchases are planned in the coming quarter: January, $33,600; February, $96,000; and March, $24,000. This equipment will be depreciated under the straight-line method over eight years with no salvage value. A full month’s depreciation is taken for the month in which equipment is purchased.
  7. The company plans to buy land at the end of March at a cost of $145,000, which will be paid with cash on the last day of the month.
  8. The company has a working arrangement with its bank to obtain additional loans as needed. The interest rate is 12% per year, and interest is paid at each month-end based on the beginning balance. Partial or full payments on these loans can be made on the last day of the month. The company has agreed to maintain a minimum ending cash balance of $28,000 at the end of each month.
  9. The income tax rate for the company is 41%. Income taxes on the first quarter’s income will not be paid until April 15.


Required:
Prepare a master budget for each of the first three months of 2018; include the following component budgets:

8. Budgeted balance sheet as of March 31, 2018.

In: Finance

Charlene Hickman expected the price of Bio International shares to drop in the near future in...

Charlene Hickman expected the price of Bio International shares to drop in the near future in response to the expected failure of its new drug to pass FDA tests. As a​ result, she sold short 100 shares of Bio International at ​$26.91. How much would Charlene earn or lose on this transaction if she repurchased the 100 shares four months later at each of the following prices per​ share?  

a.​$23.95

b.​$24.62

c.​$31.14

d. ​$26.63

a. The amount Charlene would earn or lose on this transaction if she repurchased the 100 shares four months late at $23.95 each is_​$

b. The amount Charlene would earn or lose on this transaction if she repurchased the 100 shares four months late at $24.62 each is_​$

c. The amount Charlene would earn or lose on this transaction if she repurchased the 100 shares four months late at $31.14 each is_​$

d. The amount Charlene would earn or lose on this transaction if she repurchased the 100 shares four months late at $26.63 each is_​$

In: Finance

This week's discussion board will focus on cancer, a topic very near and dear to my...

This week's discussion board will focus on cancer, a topic very near and dear to my heart, as I lost my first husband in his early 30's over 10 years ago to stage IV brain cancer, so I not only have a lot of experience professionally but also personally in this space.

We all know or have known someone touched by the deadly condition. It's a very devastating disease that affects millions of lives per year. Still, we don't have a strong handle on how exactly some cancers form in the body and what they are caused from- still determined to be "unknown". Nutrition is extremely critical though, to help prevent cancer, but more importantly if you have developed it, to help aid in healing throughout the treatment process. Surgery, radiation and chemotherapy can all take an extreme toll on the body and there are a lot of side effects patients experience which render them malnourished. You can choose to discuss an important type of supplement or food that cancer patients should focus on to assist their body through treatments OR choose to discuss an alternative therapy that individuals use to combat side effects of the treatment and how that is tied to their nutrition.

In: Nursing

On June 12, because management knew with near certainty that it had no chance of collection,...

On June 12, because management knew with near certainty that it had no chance of collection, Sheave Company wrote off a customer's account balance in the amount of $350. On November 3, the customer mailed a payment for $350 to Sheave. To record the receipt of this payment from the customer, the company would debit:

a. Bad Debt Expense and credit Cash

b. Accounts Receivable and credit Bad Debt Expense, then debit Cash and credit Allowance for Doubtful Accounts

c. Cash and credit Accounts Receivable

d. Accounts Receivable and credit Allowance for Doubtful Accounts, then debit Cash and credit Accounts Receivable

In: Accounting

The geographical principle of nearness states that everything is related to everything else but near things...

The geographical principle of nearness states that everything is related to everything else but near things are more related than distant things. In your own lives and experience, does this principle seem accurate? What other geographical concepts can you use to support or challenge the principle of nearness, and to describe your own social, economic, political, etc., connections and interactions?

In: Economics