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 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 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: 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
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 following estimated balance
sheet for December 31, 2017.
|
DIMSDALE SPORTS COMPANY |
||||||
|
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.
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 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 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, 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 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