Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started