See last 2 tables
1) budgeted mthly income statements. where i have added comments are the items i need . i have put answers that are not correct for june and total column last 3 items for each column
2) for budgedted balance sheet I have added comments on answer section . I have put answers that are not correct for interest payable and stockholders'equity.
Developing a Master Budget
for a Merchandising Organization
Peyton Department Store prepares budgets quarterly. The following
information is available for use in planning the second quarter
budgets for 2010.
| PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 |
|||
|---|---|---|---|
| Assets | Liabilities and Stockholders' Equity | ||
| Cash | $3,000 |
Accounts payable |
$26,000 |
| Accounts receivable | 25,000 |
Dividends payable |
17,000 |
| Inventory | 30,000 |
Rent payable |
2,000 |
| Prepaid Insurance | 2,000 |
Stockholders' equity |
40,000 |
| Fixtures | 25,000 | ||
| Total assets | $85,000 |
Total liabilities and equity |
$85,000 |
Actual and forecasted sales for selected months in 2010 are as follows:
| Month | Sales Revenue |
|---|---|
| January | $50,000 |
| February | 50,000 |
| March | 40,000 |
| April | 50,000 |
| May | 60,000 |
| June | 70,000 |
| July | 90,000 |
| August | 80,000 |
Monthly operating expenses are as follows:
| Wages and salaries | $27,000 |
| Depreciation | 100 |
| Utilities | 1,000 |
| Rent | 2,000 |
Cash dividends of $17,000 are declared during the third month of
each quarter and are paid during the first month of the following
quarter. Operating expenses, except insurance, rent, and
depreciation are paid as incurred. Rent is paid during the
following month. The prepaid insurance is for five more months.
Cost of goods sold is equal to 50 percent of sales. Ending
inventories are sufficient for 120 percent of the next month's
sales. Purchases during any given month are paid in full during the
following month. All sales are on account, with 50 percent
collected during the month of sale, 40 percent during the next
month, and 10 percent during the month thereafter. Money can be
borrowed and repaid in multiples of $1,000 at an interest rate of
12 percent per year. The company desires a minimum cash balance of
$3,000 on the first of each month. At the time the principal is
repaid, interest is paid on the portion of principal that is
repaid. All borrowing is at the beginning of the month, and all
repayment is at the end of the month. Money is never repaid at the
end of the month it is borrowed.
(a) Prepare a purchases budget for each month of the second quarter
ending June 30, 2010.
| Peyton Department Store Monthly Purchase Budget Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Budgeted purchases | $Answer | $Answer | $Answer | $Answer |
(b) Prepare a cash receipts schedule for each month of the second quarter ending June 30, 2010. Do not include borrowings.
| Peyton Department Store Schedule of Monthly Cash Receipts Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Total cash receipts | $Answer | $Answer | $Answer | $Answer |
(c) Prepare a cash disbursements schedule for each month of the second quarter ending June 30, 2010. Do not include repayments of borrowings.
| Peyton Department Store Schedule of Monthly Cash Disbursements Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Total cash disbursements | $Answer | $Answer | $Answer | $Answer |
(d) Prepare a cash budget for each month of the second quarter ending June 30, 2010. Include budgeted borrowings and repayments.
Only use negative signs, if needed, for: excess receipts over disbursements, balance before borrowings and cash balances (beginning and ending).
| Peyton Department Store Monthly Cash Budget Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Cash balance, beginning | $Answer | $Answer | $Answer | $Answer |
| Receipts | Answer | Answer | Answer | Answer |
| Disbursements | Answer | Answer | Answer | Answer |
| Excess receipts over disb. | Answer | Answer | Answer | Answer |
| Balance before borrowings | Answer | Answer | Answer | Answer |
| Borrowings | Answer | Answer | Answer | Answer |
| Loan repayments | Answer | Answer | Answer | Answer |
| Cash balance, ending | $Answer | $Answer | $Answer | $Answer |
(e) Prepare an income statement for each month of the second quarter ending June 30, 2010.
Only use negative signs to show net losses in income.
| Peyton Department Store Budgeted Monthly Income Statements Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Sales | $Answer | $Answer | $Answer | $Answer |
| Cost of sales | Answer | Answer | Answer | Answer |
| Gross profit | Answer | Answer | Answer | Answer |
| Operating expenses: | ||||
| Wages and salaries | Answer | Answer | Answer | Answer |
| Depreciation | Answer | Answer | Answer | Answer |
| Utilities | Answer | Answer | Answer | Answer |
| Rent | Answer | Answer | Answer | Answer |
| Insurance | Answer | Answer | Answer | Answer |
| Interest | Answer | Answer | Answer(not 630) | Answer(not 1,240) |
| Total expenses | Answer | Answer | Answer(not 31,130) | Answer(not 92,740) |
| Net income | $Answer | $Answer | $Answer(not 3,870) | $Answer(not 2,740) |
(f) Prepare a budgeted balance sheet as of June 30, 2010.
| Peyton Department Store Budgeted Balance Sheet June 30, 2010 |
||||
|---|---|---|---|---|
| Assets | Liabilities and Equity | |||
| Cash | $Answer | Merchandise payable | $Answer | |
| Accounts receivable | Answer | Dividend payable | Answer | |
| Inventory | Answer | Rent payable | Answer | |
| Prepaid insurance | Answer | Loans payable | Answer | |
| Fixtures | Answer | Interest payable | Answer(not 1,240) | |
| Total assets | $Answer | Stockholders' equity | Answer(not 20,260) | |
| Total liab. & equity | $Answer(yes 123,500) | |||
In: Accounting
Developing a Master Budget- Please answer the bottom bolded
"ANSWERS" at the bottom.
for a Merchandising Organization
Peyton Department Store prepares budgets quarterly. The following
information is available for use in planning the second quarter
budgets for 2010.
| PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 |
|||
|---|---|---|---|
| Assets | Liabilities and Stockholders' Equity | ||
| Cash | $2,000 |
Accounts payable |
$26,000 |
| Accounts receivable | 25,000 |
Dividends payable |
17,000 |
| Inventory | 30,000 |
Rent payable |
1,000 |
| Prepaid Insurance | 2,000 |
Stockholders' equity |
40,000 |
| Fixtures | 25,000 | ||
| Total assets | $84,000 |
Total liabilities and equity |
$84,000 |
Actual and forecasted sales for selected months in 2010 are as follows:
| Month | Sales Revenue |
|---|---|
| January | $80,000 |
| February | 50,000 |
| March | 40,000 |
| April | 50,000 |
| May | 60,000 |
| June | 70,000 |
| July | 90,000 |
| August | 80,000 |
Monthly operating expenses are as follows:
| Wages and salaries | $27,000 |
| Depreciation | 100 |
| Utilities | 1,000 |
| Rent | 1,000 |
Cash dividends of $17,000 are declared during the third month of
each quarter and are paid during the first month of the following
quarter. Operating expenses, except insurance, rent, and
depreciation are paid as incurred. Rent is paid during the
following month. The prepaid insurance is for five more months.
Cost of goods sold is equal to 50 percent of sales. Ending
inventories are sufficient for 120 percent of the next month's
sales. Purchases during any given month are paid in full during the
following month. All sales are on account, with 50 percent
collected during the month of sale, 40 percent during the next
month, and 10 percent during the month thereafter. Money can be
borrowed and repaid in multiples of $1,000 at an interest rate of
12 percent per year. The company desires a minimum cash balance of
$2,000 on the first of each month. At the time the principal is
repaid, interest is paid on the portion of principal that is
repaid. All borrowing is at the beginning of the month, and all
repayment is at the end of the month. Money is never repaid at the
end of the month it is borrowed.
(a) Prepare a purchases budget for each month of the second quarter
ending June 30, 2010.
| Peyton Department Store Monthly Purchase Budget Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Budgeted purchases | 31,000 |
36,000 |
47,000 |
114,000 |
(b) Prepare a cash receipts schedule for each month of the second quarter ending June 30, 2010. Do not include borrowings.
| Peyton Department Store Schedule of Monthly Cash Receipts Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Total cash receipts | 46,000 | 54,000 | 64,000 | 164,000 |
(c) Prepare a cash disbursements schedule for each month of the second quarter ending June 30, 2010. Do not include repayments of borrowings.
| Peyton Department Store Schedule of Monthly Cash Disbursements Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Total cash disbursements | 72,000 |
60,000 |
65,000 | 197,000 |
(d) Prepare a cash budget for each month of the second quarter ending June 30, 2010. Include budgeted borrowings and repayments.
Only use negative signs, if needed, for: excess receipts over disbursements, balance before borrowings and cash balances (beginning and ending).
| Peyton Department Store Monthly Cash Budget Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Cash balance, beginning | 2000 |
2000 |
2000 |
6000 |
| Receipts | 46,000 |
54,000 |
64,000 |
164,000 |
| Disbursements | 72,000 |
60,000 |
65,00 |
197,000 |
| Excess receipts over disb. | -26,000 |
-6000 |
1000 |
-33000 |
| Balance before borrowings | -24000 |
-4000 |
1000 |
31000 |
| Borrowings | 26,000 |
6000 |
1000 |
33000 |
| Loan repayments | 0 |
0 |
0 |
0 |
| Cash balance, ending | 2000 |
2000 |
2000 |
2000 |
(e) Prepare an income statement for each month of the second quarter ending June 30, 2010.
Only use negative signs to show net losses in income.
| Peyton Department Store Budgeted Monthly Income Statements Quarter Ending June 30, 2010 |
||||
|---|---|---|---|---|
| April | May | June | Total | |
| Sales | 50000 |
60000 |
70000 |
180000 |
| cost of sales | 25000 |
30,000 |
35,000 |
90,000 |
| Gross profit | 25,000 |
30000 |
35,000 |
90,000 |
| Operating expenses: | ||||
| Wages and salaries | 27000 |
27000 |
27000 |
81,000 |
| Depreciation | 100 |
100 |
100 |
300 |
| Utilities | 1000 |
1000 |
1000 |
3000 |
| Rent |
1000 |
1000 |
1000 |
3000 |
| Insurance | 400 |
400 |
400 |
1200 |
| Interest | Answer | Answer | Answer | Answer |
| Total expenses | Answer | Answer | Answer | Answer |
| Net income | Answer | Answer | Answer | Answer |
(f) Prepare a budgeted balance sheet as of June 30, 2010.
| Peyton Department Store Budgeted Balance Sheet June 30, 2010 |
||||
|---|---|---|---|---|
| Assets | Liabilities and Equity | |||
| Cash | 2000 | Merchandise payable | 47,000 | |
| Accounts receivable | 41000 | Dividend payable | 17000 | |
| Inventory | 54000 | Rent payable | 1000 | |
| Prepaid insurance | 800 | Loans payable | 33,000 | |
| Fixtures | 24,700 | Interest payable | Answer | |
| Total assets | 122500 | Stockholders' equity | Answer | |
| Total liab. & equity | 122500 | |||
In: Accounting
Thomson Media is considering some new equipment whose data are shown below. The equipment would be used for three years with straight-line depreciation, but it would have a positive pre-tax salvage value at the end of Year 3, when the project would be closed down. Also, additional net operating working capital would be required, but it would be recovered at the end of the project's life. Revenues and other operating costs are expected to be constant over the project's 3-year life. What is the project's NPV? Do not round the intermediate calculations and round the final answer to the nearest whole number.
| WACC |
10.0% |
| Net investment in fixed assets (depreciable basis) |
$70,000 |
| Required net operating working capital |
$10,000 |
| Straight-line depreciation rate |
33.333% |
| Annual sales revenues |
$56,000 |
| Annual operating costs (excl. depreciation) |
$30,000 |
| Expected pre-tax salvage value |
$5,000 |
| Tax rate |
35.0% |
In: Finance
|
Large Manufacturing, Inc. is considering investing in some new equipment whose data are shown below. The equipment has a 3-year class life and will be depreciated by the MACRS depreciation system, and it will have a positive pre-tax salvage value at the end of Year 3, when the project will be closed down. Also, some new working capital will be required, but it will be recovered at the end of the project's life. Revenues and cash operating costs are expected to be constant over the project's 3-year life. what is the Year 1 Net Operating Cash Flow? |
||||||||
|
WACC |
11.0% |
|||||||
|
Net investment in fixed assets (depreciable basis) |
$70,000 |
|||||||
|
Required new working capital |
$10,000 |
|||||||
|
Sales revenues, each year |
$95,000 |
|||||||
|
Cash operating costs excl. depr'n, each year |
$30,000 |
|||||||
|
Expected pretax salvage value |
$9,000 |
|||||||
|
Tax rate |
30.0% |
|||||||
what is the Year 1 Net Operating Cash Flow?
Type or paste question here
In: Finance
QUESTION 2
Over the last few months, the Bank of Ghana (BoG) has cracked the whip at the banking industry in a bid to restore sanity in the industry. In August 2017, the UT and Capital Banks were liquidated for failing to meet the BoG’s minimum capital ratio. The operations of UniBank, Royal Bank, Beige Bank, Sovereign Bank, and Construction Bank ended. In their place the BoG announced a new bank called the Consolidated Bank, as part of measures to ensure the banking sector maintains a strong indigenous presence.
The BoG’s statement on closure of the banks said an Asset Quality Review (AQR) of banks conducted in 2015 and 201S6 found that some indigenous banks had inadequate capital, high levels of non-performing loans, and weak corporate governance which compelled BoG to crack the whip.
REQUIRED:
As a manager of a bank that was not closed down, what measures will you put in place to ensure that your bank will not be caught up in the same situation as the collapsed banks?
In: Accounting
QUESTION 2
Over the last few months, the Bank of Ghana (BoG) has cracked the
whip at the banking industry in a bid to
restore sanity in the industry. In August 2017, the UT and Capital
Banks were liquidated for failing to meet
the BoG’s minimum capital ratio. The operations of UniBank, Royal
Bank, Beige Bank, Sovereign Bank, and
Construction Bank ended. In their place the BoG announced a new
bank called the Consolidated Bank, as part
of measures to ensure the banking sector maintains a strong
indigenous presence.
The BoG’s statement on closure of the banks said an Asset Quality
Review (AQR) of banks conducted in
2015 and 201S6 found that some indigenous banks had inadequate
capital, high levels of non-performing
loans, and weak corporate governance which compelled BoG to crack
the whip.
REQUIRED:
As a manager of a bank that was not closed down, what measures will
you put in place to ensure that your
bank will not be caught up in the same situation as the collapsed
banks?
In: Finance
Over the last few months, the Bank of Ghana (BoG) has
cracked the whip at the banking industry in a bid to
restore sanity in the industry. In August 2017, the UT and Capital
Banks were liquidated for failing to meet
the BoG’s minimum capital ratio. The operations of UniBank, Royal
Bank, Beige Bank, Sovereign Bank, and
Construction Bank ended. In their place the BoG announced a new
bank called the Consolidated Bank, as part
of measures to ensure the banking sector maintains a strong
indigenous presence.
The BoG’s statement on closure of the banks said an Asset Quality
Review (AQR) of banks conducted in
2015 and 201S6 found that some indigenous banks had inadequate
capital, high levels of non-performing
loans, and weak corporate governance which compelled BoG to crack
the whip.
REQUIRED:
As a manager of a bank that was not closed down, what measures will
you put in place to ensure that your
bank will not be caught up in the same situation as the collapsed
banks?
In: Finance
Large Manufacturing, Inc. is considering investing in some new equipment whose data are shown below. The equipment has a 3-year class life and will be depreciated by the MACRS depreciation system, and it will have a positive pre-tax salvage value at the end of Year 3, when the project will be closed down. Also, some new working capital will be required, but it will be recovered at the end of the project's life. Revenues and cash operating costs are expected to be constant over the project's 3-year life.
WACC 11.0%
Net investment in fixed assets (depreciable basis) $70,000
Required new working capital $10,000
Sales revenues, each year $95,000
Cash operating costs excl. depr'n, each year $30,000
Expected pretax salvage value $9,000
Tax rate 30.0%
What is the terminal Year Non–Operating Cash Flow at the end of Year 3?
What is the project’s NPV?
In: Finance
Which statements describe the structure of lymphatic capillaries?
-Lymphatic capillaries have a layer of smooth muscle in their walls.
-Collagen filaments anchor the endothelium to loose connective tissue.
-The endothelial cells are not tightly joined together.
-Lymphatic capillaries are part of a closed circuit.
Which of the cells are lymphoid cells (lymphocytes)?
-B cells
-antigens
-helper T cells
-hematopoietic stem cells
Which leukocyte can destroy microorganisms and remove cell debris?
-plasma cell
-dendritic cell
-macrophage
-T lymphocyte
Which is a function of lymph nodes?
-to filter out toxins, such as alcohol
-to store platelets
-to filter out old, damaged red blood cells
-to filter out foreign material and cell waste
What is the lymph‑related function of the appendix?
-secretes lipases that break down triglycerides
-connects the small intestine to the lymph nodes
-removes excess fluid from the small intestine
-protects the intestines from foreign antigens
In: Biology
The Thompson family purchased a rural house and lot in the country. Next to their lot, Carlton Fuels Ltd. had operated a gas station for many years. The gas station had closed down 5 years earlier and the fuel tanks had been removed from the ground.
Two years before the Thompson family purchased their house and lot, the lot where Carton Fuels had been located was sold to a plumbing supply company that used the buildings and grounds to store plastic pipes and other non-hazardous supplies.
Some time after the purchase of their home, the Thompson’s began to notice a strange taste and odour in their drinking water. The water came from a well on their property. A test on the well indicated that the water was contaminated with gasoline.
In: Operations Management