Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

fill the cash flow table below 1 1/2/14 Deposit $45,000 into business checking account to open business 2 1/2/14 Borrow $30,000 from bank against line

fill the cash flow table below

1

1/2/14

Deposit $45,000 into business checking account to open business

2

1/2/14

Borrow $30,000 from bank against line of credit at 0.085 annual rate accruing monthly over 12 months

3

1/2/14

Purchase equipment for $125,000 depreciate to $12,000 salvage value over 5 years DDB in exchange for note payable , @ 0.07 annual rate, amortized monthly over 60 months. Contract calls for balloon payment of $30,000

at end of 60th month.

4

1/2/14

Record cash payment of 12 months rent $12,000

5

1/3/14

Purchase 1,500 supplies on account, 600 remain at month end

6

1/4/14

Purchase inventory on account,, 600units @ $48

7

1/8/14

For prompt payment on transaction # 6 above, which included a discount option of 2/10, net 30, settle 18,000 within terms

8

1/10/14

Sell 275 units $90 per unit on account

9

1/12/14

Customer, transaction # 8 , sent payment of 14,000 within terms 2/10, net 30

10

1/14/14

Customer actually returned 15 units for full credit

11

1/15/14

Purchased 325 units of inventory @ $55 on account

12

1/15/14

To record salaries paid on 1-15-14 (salaries paid on 1st and 15th) $5,500

13

1/17/14

Sell 360 units of inventory on account @ $100 per unit, using FIFO

14

1/18/14

Record contract to deliver 200 units of inventory @ 97 per unit secured by a cash deposit of 10,000, 100 units were actually delivered during the month

Bookkeeper recorded all 19,400 as revenue

15

1/18/14

To record freight-out charges paid in cash in the amount of 346.80

16

1/28/14

To record utilities expense for January '14 to be paid on 2/10/16 $575

17

1/30/14

17. Management expects 7 additional returns on January sales in the month of February

18

1/30/14

18. Management forecasts bad debt expense by aging schedule below:

19

1/30/14

19. Managements considers effect of market changes on inventory as shown below:

20

1/30/14

Pay dividend to leave 7,000 in retained earnings

21

1/30/14

21. Record $100,000 construction expense on account, estimated completion costs $500,000, Contract value $750,000

Billings on construction in progress, $85,000 Collected, $70,000

on billings

Cash Flows

Net

Dpr

Accts Rec

Allowance Sls

Allowance bd

Constr in Prog

Prepaid

Supplies

Inventory

Accts payable

Unearned

Salaries payable

Billings on Const

Opr

Income Statement

Construction Revenue

125000

Sales

65,050.00

Sales Discounts

80.00

Sales Returns, Allowances

1,350.00

Net Sales

63,620.00

C.O.G.S.

34,560.00

Gross Margin

154,060.00

Supplies Expense

1,500.00

Depreciation

1,883.33

Interest Expense

11,300.00

Salaries expense

5,500.00

Rent expense

1,000.00

Utilities expense

575.00

Bad debt expense

28.82

LCM Adjustment

Freight out

346.80

Net Income

131,926.05

Balance sheet

Cash

32,658.20

Accounts Receivable

145,450.00

Allowance for Sales Returns

1,350.00

Allowance for Doubtful Accts

28.82

Net Receivables

144,071.18

Construction in Progress

100000

Prepaid rent

11,000.00

Supplies

600.00

Inventory

29,395.00

Equipment

123,116.67

A.D.

-

Total

440,841.05

Accounts Payable

40,175.00

Line of credit

32,550.00

Unearned Revenue

9,700.00

Salaries payable

Billings on Construction

15000

Note Payable

133,750.00

Paid -in Capital

202,666.05

Retained Earnings

7,000.00

total

440,841.05

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions