In: Accounting
ASTRO Inc.
Statement of Financial Position
December 31, 2018
Assets Liabilities
Cash $259,000 Notes Payable 8% $60,000
Inventory $6,000 Accounts Payable $40,000
Prepaid Insurance $3,000 Total $100,000
Supplies $4,000 Common Stock $5 par $140,000
Land $6,000 Excess of par $60,000
Building $480,000 Retained earnings $418,000
Acc. Depr. ( $40,000) $440,000 Total $618,000
Total Assets $718,000 Total Liabilities & Equity $718,000
You are asked to prepare, in good financial form, a set of financial statements for Saratoga Inc. for the quarter ending 3/31/2019.
Jan. 1 – ASTRO purchased equipment for $70,000 and signed a note for the entire cost. The interest rate on the note is 6%. This loan requires monthly payments of $2,000. Monthly payments include interest and principle. Useful life is 5 years.
Jan. 1 – ASTRO purchased on this date for $100,000. Useful life for this machine is 10 years. ASTRO elected to sign a note for the full amount of the purchase price. The note has a 10% rate of interest. Payment on the note will be yearly and the first payment is due December 31, 2019.
Jan. 10 – Purchased $80,000 of inventory. The company paid in full on this date.
Jan. 15 – Issued 200,000 shares of common stock of ASTRO Inc. for $12 per share. All cash received on this date.
Jan. 20 – ASTRO purchased $50,000 of inventory on account.
Jan. 27 – Sales to a customer amounted to $590,000. Received $18,000 in cash on this date.
Feb. 1 – ASTRO made a $2,000 monthly note payment in cash. This note was created on January 1, 2019.
Feb. 15 – Salary and wage expense were paid in the amount of $26,000.
Feb. 27 – The $2,000 monthly note payment was made. This note was entered into Jan. 1, 2019.
Feb. 27 – Received payment in full for the sales generated on Jan. 27, 2019.
Mar. 15 – ASTRO paid $9,000 for advertising.
Mar. 18 – Dividends declared to shareholders for record owners on March 31, 2019 - to be paid on April 1, 2019. The amount of the dividend is $1 per share.
Mar. 31 – Salary and wages paid in the amount of $5,000.
Mar. 31 – Supply Inventory was $1,000.
Mar. 31 - Sales to customer amounted to $35,000 and no discounts were given. Cash was received for the full price.
Mar. 31 - Inventory [merchandise] at March 31, 2019 was $10,000.
Mar. 31 - ASTRO paid wages of $23,000 this date
Mar. 31 - Assume the tax rate is 15% for ASTRO Inc.
Mar. 31 – ASSUME that the prepaid insurance of $3,000 listed on the balance sheet dated December 31, 2018 is the cost of the insurance policy from January 1, 2019 to December 31, 2019.
Building has a useful life of 20 years.
CREATE the following
Statement of Revenue & Expenses {Income statement}
Statement of Retained Earnings
Statement of Financial Position {Balance Sheet}
Tee accounts
All Journal Entries
| Sr No. | Particulars | Debit | Credit |
| 1-Jan | Equipment | 70000 | |
| Notes Payable 6% | 70000 | ||
| 1-Jan | Machine | 100000 | |
| Notes Payable 10% | 100000 | ||
| 10-Jan | Inventory | 80000 | |
| Cash | 80000 | ||
| 15-Jan | Cash | 2400000 | |
| Common stock | 2400000 | ||
| 20-Jan | Inventory | 50000 | |
| Account payable | 50000 | ||
| 27-Jan | Cash | 18000 | |
| Account receivable | 572000 | ||
| Sales revenue | 590000 | ||
| 1-Feb | Interest | 350 | |
| Notes Payable 6% | 1650 | ||
| Cash | 2000 | ||
| (70000 * 6%) / 12 = 350 | |||
| 15-Feb | Salary and wages expense | 26000 | |
| Cash | 26000 | ||
| 27-Feb | Interest | 350 | |
| Notes Payable 6% | 1650 | ||
| Cash | 2000 | ||
| (70000 * 6%) / 12 = 350 | |||
| 27-Feb | Cash | 572000 | |
| Account receivable | 572000 | ||
| 15-Mar | Advertisment expense | 9000 | |
| Cash | 9000 | ||
| 18-Mar | Dividend | 228000 | |
| Retained earning | 228000 | ||
| $ 140000 / 5 Par = 28000 shares + 200000 shares issued = Total dividend = 228000*1 = 228000 | |||
| 31-Mar | Salary and wages expense | 5000 | |
| Cash | 5000 | ||
| 31-Mar | Supply expense | 3000 | |
| Supply inventory | 3000 | ||
| (opening 4000 - 1000) | |||
| 31-Mar | Cash | 35000 | |
| Sales revenue | 35000 | ||
| 31-Mar | COGS | 126000 | |
| Inventory | 126000 | ||
| (Opening (6000) + Purchase (80000+50000)-closing (10000) = | |||
| 31-Mar | Wages | 23000 | |
| Cash | 23000 | ||
| 31-Mar | Insurance expense | 750 | |
| Prepaid insurance | 750 | ||
| (3000/12)*3 = 750 | |||
| 31-Mar | Depreciation Machine (70000/5)*3/12 = | 3500 | |
| Depreciation Equipment(100000/10)*3/12= | 2500 | ||
| Depreciation Building (480000/20)*3/12= | 6000 | ||
| Accumulated depreciation | 12000 | ||
| Cash | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Jan | Opening | 259000 | 10-Jan | Inventory | 80000 |
| 15-Jan | Common stock | 2400000 | 1-Feb | Notes payable | 1650 |
| Sales revenue | 18000 | 1-Feb | Interest | 350 | |
| 27-Feb | Accounts receivable | 572000 | 27-Feb | Notes payable | 1350 |
| 31-Mar | Sales revenue | 35000 | 27-Feb | Interest | 350 |
| 15-Feb | Salary and wages | 26000 | |||
| 15-Mar | Advertisment | 9000 | |||
| 31-Mar | Salary and wages | 5000 | |||
| 31-Mar | Salary and wages | 23000 | |||
| 3284000 | 146700 | ||||
| Debit Balance | 3137300 | ||||
| Inventory | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Jul | Opening | 6000 | 31-Mar | COGS | 126000 |
| 10-Jan | Inventory | 80000 | |||
| 20-Jan | Notes payable | 50000 | |||
| 136000 | 126000 | ||||
| Debit Balance | 10000 | ||||
| Notes Payable | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Feb | Cash | 1650 | 1-Jan | Opening | 60000 |
| 27-Feb | Cash | 1650 | 1-Jan | Equipment | 70000 |
| 1-Jan | Machine | 100000 | |||
| 3300 | 230000 | ||||
| Credit Balance | 226700 | ||||
| Common stock | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Jan | Opening | 200000 | |||
| 15-Jan | Cash | 2400000 | |||
| 0 | 2600000 | ||||
| Credit Balance | 2600000 | ||||
| Prepaid expense | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Jan | Opening | 3000 | Insurance expense | 750 | |
| 3000 | 750 | ||||
| Debit Balance | 2250 | ||||
| Supplies | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Jan | Opening | 4000 | Supply expense | 3000 | |
| 4000 | 3000 | ||||
| Debit Balance | 1000 | ||||
| Depreciation | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 31-Mar | Dep. Machine | 3500 | |||
| Dep. Equip | 2500 | ||||
| Dep. Building | 6000 | 0 | |||
| Debit Balance | 12000 | ||||
| Interest | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Feb | Cash | 350 | |||
| 27-Feb | Cash | 350 | |||
| 700 | 0 | ||||
| Debit Balance | 700 | ||||
| Accounts Payable | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Jan | Opening | 40000 | |||
| inventory | 50000 | ||||
| 0 | 90000 | ||||
| Credit Balance | 90000 | ||||
| Accumulated depreciation | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 1-Jan | Opening | 40000 | |||
| 31-Mar | Dep. | 12000 | |||
| 0 | 52000 | ||||
| Credit Balance | 52000 | ||||
| Accounts receivable | |||||
| Debit | Credit | ||||
| Date | Particular | Amount | Date | Particular | Amount |
| 27-Jan | Inventroy | 572000 | Cash | 572000 | |
| 572000 | 572000 | ||||
| Debit Balance | 0 | ||||
| Statement of revenue and expense | |
| Sales revenue | 625000 |
| Less: COGS | -126000 |
| Gross income | 499000 |
| Expenses | |
| Salary and wages expense | -54000 |
| Interest expense | -700 |
| Advirtisment expense | -9000 |
| Supply expense | -3000 |
| Insurance expense | -750 |
| Depreciation expense | -12000 |
| Net income | 419550 |
| Less Tax Expense (15%) | -62932.5 |
| Income after tax | 356617.5 |
| Balance sheet | |
| Asset | |
| Cash | 3137000 |
| Inventory | 10000 |
| Prepaid insurance | 2250 |
| Supplies | 1000 |
| Land | 6000 |
| Building | 480000 |
| Machine | 70000 |
| Equipment | 100000 |
| Accumulated depreciation | -52000 |
| Total | 3754250 |
| Liability | |
| Notes Payable | 226700 |
| Accounts Payable | 90000 |
| Equity | |
| Common stock | 2600000 |
| Retained earning | 546617.5 |
| Proposed dividend | 228000 |
| Tax payable | 62932.5 |
| 3754250 | |
| Statement of retained earning | 0 |
| Opening retained earning | 418000 |
| Less: Proposed dividend | 228000 |
| Add: Income statement | 356617.5 |
| Closing retained earning | 546617.5 |