Tim Lumber buys $350,000 more inventory, pays $150,000 cash now, balance due to suppliers next month. Pays cash in Mo. 11 against Accts Payable starting balance owed from Mo-10 Accts Payable.
Tim Lumber sells $475,000 of inventory to customers for $725,000 net. $450,000 were cash sales, balance of sales on credit due from customers in 30 days in next month’s accounting period.
$140,000 cash is collected in the current Month-11 period on Accts Receivable carried over from Mo.10
Building monthly rent paid cash in current period is $10,000 monthly going forward
Wage expense = $45,000, $30,000 cash, balance paid next period. Mo-10 Wage Payable is paid cash now.
$50,000 is repaid on the Bank loan. Mo. loan interest expense = $1,000, paid cash in current period.
Tim Lumber buys extra $200,000 inventory, pays $50,000 cash, balance on Supplier credit, due in Mo. 12
Office supplies and utilities expense together totaled $30,000, paid cash in the current period
Depreciation expense is $750 per month ($72,000 div. by 8 = $9,000 annual div. by 12 = $750 mo.)
Amortized monthly insurance policies expense of $300 recorded in the current period
Another $75,000 is received in Mo.11 from accts rec. owed by customers who bought on credit in month 11.
Dividends = $10,000 paid cash to Owner in Mo.11 Month-11 Retained Earns = Mo. 11 N.Inc - $10,000 Div
Tim Lumber owes $43,950 income tax on Mo.11 pre-tax profits, pays period 12. Tim Lumber pays Mo-10 Tax payable
PREPARE THE 11 PERIOD INCOME STATEMENT & ENDING BALANCE SHEET
Inventory | |||
Particulars | amount | Particulars | amount |
Beg balace | 443 | COGS | 475 |
Cash | 150 | Balance | 518 |
Accounts payable | 200 | ||
cash | 50 | ||
Accounts payable | 150 | ||
993 | 993 | ||
Accounts payable | |||
Particulars | amount | Particulars | amount |
Cash | 220 | Beg balace | 220 |
Balance | 350 | Inventory | 200 |
inventory | 150 | ||
570 | 570 | ||
Sales | |||
Particulars | amount | Particulars | amount |
income statement | 725 | cash | 450 |
account receivable | 275 | ||
725 | 725 | ||
Accounts receivable | |||
Particulars | amount | Particulars | amount |
Beg balance | 155 | cash | 140 |
sales | 275 | cash | 75 |
Balance | 215 | ||
430 | 430 | ||
Bank loan | |||
Particulars | amount | Particulars | amount |
Cash | 50 | Beg balance | 135 |
balance | 85 | ||
135 | 135 | ||
Interest expense | |||
Particulars | amount | Particulars | amount |
Cash | 1 | income statement | 1 |
1 | 1 | ||
Office supplies and utilities expense | |||
Particulars | amount | Particulars | amount |
Cash | 30 | income statement | 30 |
30 | 30 | ||
Depreciation expense | |||
Particulars | amount | Particulars | amount |
office equipment | 0.75 | income statement | 0.75 |
0.75 | 0.75 | ||
Equipments | |||
Particulars | amount | Particulars | amount |
Beg balance | 64.5 | Depreciation | 0.75 |
balance | 63.75 | ||
64.5 | 64.5 | ||
Insurance expense | |||
Particulars | amount | Particulars | amount |
Accrued expense | 0.3 | income statement | 0.3 |
0.3 | 0.3 | ||
Prepaid expense | |||
Particulars | amount | Particulars | amount |
Beg balance | 0.6 | Insurance | 0.3 |
balance | 0.3 | ||
0.6 | 0.6 |
Cash | |||
Particulars | amount | Particulars | amount |
Beg balace | 282.7 | Inventory | 150 |
sales | 450 | Acc payable | 220 |
accounts receivable | 140 | Rent | 10 |
accounts receivable | 75 | wages | 30 |
wages payable | 8 | ||
Bank loan | 50 | ||
interest | 1 | ||
inventory | 50 | ||
office supplies and utility expense | 30 | ||
Dividend | 10 | ||
Cash | 30 | ||
Balance | 358.7 | ||
947.7 | 947.7 | ||
Rent | |||
Particulars | amount | Particulars | amount |
cash | 10 | income statement | 10 |
10 | 10 | ||
Wages | |||
Particulars | amount | Particulars | amount |
Cash | 30 | income statement | 45 |
wages payable | 15 | ||
45 | 45 | ||
Wages payable | |||
Particulars | amount | Particulars | amount |
Cash | 8 | beg balance | 8 |
Balance | 15 | wages expense | 15 |
23 | 23 | ||
Retained earnings | |||
Particulars | amount | Particulars | amount |
dividend | 10 | Beg balance | 352.8 |
Balance | 461.8 | Profit for the year | 119 |
471.8 | 471.8 | ||
Income tax expense | |||
Particulars | amount | Particulars | amount |
incometax expense | 43.95 | income statement | 43.95 |
43.95 | 43.95 | ||
Income tax payable | |||
Particulars | amount | Particulars | amount |
cash | 30 | Beg balance | 30 |
balance | 43.95 | income tax | 43.95 |
73.95 | 73.95 |
Income statement | |
Sales | 725 |
COGS | 475 |
Gross margin | 250 |
Operating expense | |
Rent | 10 |
depreciation | 0.75 |
office supplies and utilities | 30 |
wages | 45 |
Insurance | 0.3 |
Total expenses | 86.05 |
Operating profit | 163.95 |
Interest expense | 1 |
Profit before taxes | 162.95 |
Income tax expense | 43.95 |
Net income | 119 |
Balance sheet | |
Assets | |
Cash | 358.7 |
Inventory | 518 |
Accounts receivable | 215 |
prepaid current assets | 0.3 |
total current assets | 1092 |
LT assets office equipment | 63.75 |
Total assets | 1155.75 |
Liabilities | |
wages payable | 15 |
accounts payable | 350 |
Bank loan | 85 |
tax payable | 43.95 |
total current liabilities | 493.95 |
owners' equity | 200 |
reatined earnings | 461.8 |
total equity | 661.8 |
Total equity+liabilities | 1155.75 |
Tim Lumber buys $350,000 more inventory, pays $150,000 cash now, balance due to suppliers next month....
Following information relates to Acco Co.
Beginning cash balance on July 1: $30,000.
Cash receipts from sales: 27% is collected in the month of
sale, 50% in the next month, and 23% in the second month after sale
(uncollectible accounts are negligible and can be ignored). Sales
amounts are: May (actual), $1,032,000; June (actual), $720,000; and
July (budgeted), $840,000.
Payments on merchandise purchases: 54% in the month of purchase
and 46% in the month following purchase. Purchases amounts are:
June...
Stockholders invested $10,000
cash in the business in exchange for common stock. **IF YOU ARE NOT
ABLE TO ANSWER ALL QUESTION, DON'T BOTHER :) **
1 Purchased
used truck for $6,000, paying $3,000 cash and the balance on
account.
3 Purchased
cleaning supplies for $1,200 on account.
5 Paid
$1,200 cash on a 1-year insurance policy effective March
1.
14 Billed
customers $4,800 for cleaning services.
18 Paid
$1,500 cash on amount owed on truck and $500 on amount owed on
cleaning supplies.
20 Paid
$1,800...
COMPREHENSIVE PROBLEM - TRANSACTION UST During 2020 Tim & Lori form Rocked Out, Inc., a music consulting business. Below are transactions that occurred during the year. 1) Tim and Lori each contribute $200,000 to Rocked Out, Inc cash in exchange for common stock 2) Rocked Out performs consulting services for a new musician customer on account for $120.000 "Rocked Out purchases music supplies from a vender for $30,000 from the customer involved in 12 4) In July, Rocked Out receives...
COMPREHENSIVE PROBLEM - TRANSACTION UST During 2020 Tim & Lori form Rocked Out, Inc., a music consulting business. Below are transactions that occurred during the year. 1) Tim and Lori each contribute $200,000 to Rocked Out, Inc cash in exchange for common stock 2) Rocked Out performs consulting services for a new musician customer on account for $120.000 "Rocked Out purchases music supplies from a vender for $30,000 from the customer involved in 12 4) In July, Rocked Out receives...
b. c. d. e. Borrowed money from a bank Provided services on account Purchased inventory on account Collected cash from customers that owed a balance due SE2-3. Debit and Credit Effects Indicate the account that will be credited for each of the following LO transactions: a. Issued common stock for cash b. Borrowed money from a bank c. Provided services on account d. Purchased inventory on account e. Collected cash from customers that owed a balance due SE2-4. Determine a...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $134,000 $159,000 $216,000 Manufacturing costs 56,000 68,000 78,000 Selling and administrative expenses 39,000 43,000 48,000 Capital expenditures _ _ 52,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
need help making transactions.
terms for assets: cash, short term investments, A/R, allowance for
doubtful Acc, interest receivable, merchandise inventory, office
supplies, prepaid insurance, land, building, Accumulated building,
intangible asset.
terms for liabilities: A/P, salaries payable, income tax payable,
interest payable, unearned revenue, dividends payable, notes
payable
terms for equity: common stock, additional paid in capital,
retained earnings
terms for revenues: sales revenue, sales discount, sales allowance,
service revenue, interest income
terms for expenses: COGS, salaries expense, advertising expense,
office...
please please please I need the answer for balance sheet as of March 31 ASSETS: Cash Accounts receivable, net of allowance Raw Materials Inventory Finished Goods Inventory Total Current Assets Property, plant, and equipment Less: Accumulated Depreciation Property, plant, and equipment, net Total assets SHAREHOLDERS AND EQUITY: Accounts payable Income Tax Liability Interest payable Other current liabilities (line-of-credit) Total Liabilities Stockholders' equity Retained Earnings Total liabilities and stockholders' equity Cash $4,650.00, Accounts receivable, net $57,600.00, Inventory $15,600.00; Property, plant, and...
please full calculation and explanation.
PetPlace requires a minimum cash balance of $30,000 at the end of March of the current year in order to remodel its store. Any required borrowings take place in increments of $10,000 with interest of 1.5% per month. Repayments of borrowed funds are also made in increments of $10,000. Assume that borrowings are made on the first day of the month in which the cash is required, and that repayments are made on the last...
ABC CORP BALANCE SHEET December 31, 2010 $ 100 Cash Marketable Securities 0 Accounts Receivables 2,000 Inventory 140 Fixed Assets (net) 2,000 Total Assets ===== $ 2,380 Accounts Payable Notes Payable 0 Retained earnings Common Stock 1,400 Total of Both Liabilities & Equity For the year ended 12/31/10 ABC CORP generated Sales of $12,000 and Net Income of $120. The net profit margin this year is considered normal by ABC CORP. Cost of Goods Sold was $8,400 in 2010. Cost...