Prepare the Income Statement, Statement of Ownersâ Equity and the Balance Sheet for the fiscal year ending September 30, 2017. To support your work prepare the appropriate journal entries and post to the related Accounting Equation or âT-accounts".
The attached Balance Sheet gives your firm's position at the end of fiscal 2016. During fiscal 2017, your firm has the following transactions:
Your firm has total sales for the year of $1,210,500. Included in the total sales figure are $1,010,500 sales on credit. During the year, the firm received $792,000 of payments on account. Customers returned $7,800 for cash refunds during the year.
During the year, the firm determined that accounts totaling $2,900 were uncollectible. Moreover, a $375 receivable written off during the year was subsequently collected. The $375 is not included in âA.â above.
Your firm uses the allowance method to record bad debts. Specifically, the firm uses the percentage of receivables method to compute the allowance for doubtful accounts. The firm uses the following information to determine the allowance:
Age of Receivables
Percent of current balance
Percent expected uncollectible
<30 days
70%
2%
< 60 days
23%
10%
>60 days
7%
50%
Your Firm
Balance Sheet
September 30, 2016
Assets
Cash
$ 102,530
Accounts receivable
$ 101,640
Allowance for doubtful accounts
(6,160)
Accounts receivable, net
95,480
Inventories
136,400
Trading securities
111,100
Prepaid insurance
17,100
Total Current Assets
462,610
Property, Plant and Equipment, gross
$ 1,633,500
Accumulated depreciation
(546,975)
Property, Plant and Equipment, net
1,086,525
Total Assets
$ 1,549,135
Liabilities and Shareholders' Equity
Accounts payable
$ 89,645
Salaries payable
31,575
Dividends payable
4,400
Total Current Liabilities
125,620
Long-term note payable
380,000
Total Liabilities
505,620
Common stock, no par
490,000
Retained Earnings
591,215
Accumulated Other Comprehensive Income
4,300
Treasury stock
(42,000)
Total Shareholder's Equity
1,043,515
Total Liabilities and Shareholder's Equity
$ 1,549,135
Prepare the Income Statement, Statement of Ownersâ Equity and the Balance Sheet for the fiscal year ending September 30, 2017. To support your work prepare the appropriate journal entries and post to the related Accounting Equation or âT-accounts".
The attached Balance Sheet gives your firm's position at the end of fiscal 2016. During fiscal 2017, your firm has the following transactions:
Your firm has total sales for the year of $1,210,500. Included in the total sales figure are $1,010,500 sales on credit. During the year, the firm received $792,000 of payments on account. Customers returned $7,800 for cash refunds during the year.
During the year, the firm determined that accounts totaling $2,900 were uncollectible. Moreover, a $375 receivable written off during the year was subsequently collected. The $375 is not included in âA.â above.
Your firm uses the allowance method to record bad debts. Specifically, the firm uses the percentage of receivables method to compute the allowance for doubtful accounts. The firm uses the following information to determine the allowance:
| Age of Receivables | Percent of current balance | Percent expected uncollectible |
| <30 days | 70% | 2% |
| < 60 days | 23% | 10% |
| >60 days | 7% | 50% |
| Your Firm | |||
| Balance Sheet | |||
| September 30, 2016 | |||
| Assets | |||
| Cash | $ 102,530 | ||
| Accounts receivable | $ 101,640 | ||
| Allowance for doubtful accounts | (6,160) | ||
| Accounts receivable, net | 95,480 | ||
| Inventories | 136,400 | ||
| Trading securities | 111,100 | ||
| Prepaid insurance | 17,100 | ||
| Total Current Assets | 462,610 | ||
| Property, Plant and Equipment, gross | $ 1,633,500 | ||
| Accumulated depreciation | (546,975) | ||
| Property, Plant and Equipment, net | 1,086,525 | ||
| Total Assets | $ 1,549,135 | ||
| Liabilities and Shareholders' Equity | |||
| Accounts payable | $ 89,645 | ||
| Salaries payable | 31,575 | ||
| Dividends payable | 4,400 | ||
| Total Current Liabilities | 125,620 | ||
| Long-term note payable | 380,000 | ||
| Total Liabilities | 505,620 | ||
| Common stock, no par | 490,000 | ||
| Retained Earnings | 591,215 | ||
| Accumulated Other Comprehensive Income | 4,300 | ||
| Treasury stock | (42,000) | ||
| Total Shareholder's Equity | 1,043,515 | ||
| Total Liabilities and Shareholder's Equity | $ 1,549,135 | ||
Related questions
Budgeted Income Statement and Balance Sheet
As a preliminary to requesting budget estimates of sales, costs,and expenses for the fiscal year beginning January 1, 2017, thefollowing tentative trial balance as of December 31, 2016, isprepared by the Accounting Department of Mesa Publishing Co.:
Cash | $ 26,000 | ||
Accounts Receivable | 23,800 | ||
Finished Goods | 16,900 | ||
Work in Process | 4,200 | ||
Materials | 6,400 | ||
Prepaid Expenses | 600 | ||
Plant and Equipment | 82,000 | ||
Accumulated DepreciationâPlant and Equipment | $ 32,000 | ||
Accounts Payable | 14,800 | ||
Common Stock, $1.50 par | 30,000 | ||
Retained Earnings | 83,100 | ||
$159,900 | $159,900 |
Factory output and sales for 2017 are expected to total 3,800units of product, which are to be sold at $120 per unit. Thequantities and costs of the inventories at December 31, 2017, areexpected to remain unchanged from the balances at the beginning ofthe year.
Budget estimates of manufacturing costs and operating expensesfor the year are summarized as follows:
Estimated Costs and Expenses | ||||
Fixed | Variable | |||
Cost of goods manufactured and sold: | ||||
Direct materials | _ | $30.00 | ||
Direct labor | _ | 8.40 | ||
Factory overhead: | ||||
Depreciation of plant and equipment | $ 4,000 | _ | ||
Other factory overhead | 1,400 | 4.80 | ||
Selling expenses: | ||||
Sales salaries and commissions | 12,800 | 13.50 | ||
Advertising | 13,200 | _ | ||
Miscellaneous selling expense | 1,000 | 2.50 | ||
Administrative expenses: | ||||
Office and officers salaries | 7,800 | 7.00 | ||
Supplies | 500 | 1.20 | ||
Miscellaneous administrative expense | 400 | 2.40 | ||
Balances of accounts receivable, prepaid expenses, and accountspayable at the end of the year are not expected to differsignificantly from the beginning balances. Federal income tax of$35,000 on 2017 taxable income will be paid during 2017. Regularquarterly cash dividends of $0.20 per share are expected to bedeclared and paid in March, June, September, and December on 20,000shares of common stock outstanding. It is anticipated that fixedassets will be purchased for $22,000 cash in May.
Required:
X
Part 1: Budgeted Income Statement
1. Prepare a budgeted income statement for2017.
Mesa Publishing Co. | |||
Budgeted Income Statement | |||
For the Year Ending December 31, 2017 | |||
$ | |||
Cost of goods sold: | |||
$ | |||
Cost of goods sold | |||
Gross profit | $ | ||
Operating expenses: | |||
Selling expenses: | |||
$ | |||
Total selling expenses | $ | ||
Administrative expenses: | |||
$ | |||
Total administrative expenses | |||
Total operating expenses | |||
Income before income tax | $ | ||
$ | |||
X
Part 2: Budgeted Balance Sheet
2. Prepare a budgeted balance sheet as ofDecember 31, 2017.
Mesa Publishing Co. | |||
Assets | |||
Current assets: | |||
Inventories: | |||
Total current assets | |||
Property, plant, and equipment: | |||
Total assets | |||
Liabilities | |||
Current liabilities: | |||
Stockholders' Equity | |||
Total stockholdersâ equity | |||
Total liabilities and stockholdersâ equity | |||
