2.Given the following information, how much of a line of credit is appropriate? (Jackie's Toy Manufacturer – 2005 Cash Budget for SEPT – NOV in $1,000,000s). Thirty percent of sales are for cash and the balance is collected the month following the sales. Seventy percent of the purchases are for cash and the balance is paid the month following the purchase. The required balance is 50.
Sales 400 500 800 1,000
Purchases 250 375 500 600
AUG SEPT OCT NOV
Cash Inflows: x
Cash Sales x 150 240 300
Collect AR x 280 350 ___ (FILL IN)
Other x 70 80 1,500
Total Cash Inflows 500 670 ___ (FILL IN)
----------------------------------------------------------------------------------------
Cash Outflows: x
Cash Purchases x 262.5 350 420
Pay AP x 75. ___ ___ (FILL IN)
Other x 140 150 155
Asset Purchase 500 x x
Total Cash Outflows 977.5 ___ ___ (FILL IN)
NET CASH FLOW -477.5 ___ ___ (FILL IN)
-----------------------------------------------------------------------------------------
Beg Bal. 50
End Bal. ___ ___ ___ (FILL IN)
R_________ ___ ___ ___ (FILL IN)
Surp(Loan) _____________________________________________
1. Line of Credit or loan needed is $__________________________.
Cash Budget | |||
Particular | SEP | Oct | Nov |
Cash Balance at Begining | 50 | 50 | 50 |
Cash inflow | |||
Account receivable | 280 | 350 | 560 |
Cash sales | 150 | 240 | 300 |
other | 70 | 80 | 1500 |
Total Cash inflow | 500 | 670 | 2360 |
Cash outflow | |||
Cash purchases | 262.5 | 350 | 420 |
Account payable | 75 | 112.5 | 150 |
other | 140 | 150 | 155 |
asset purchase | 500 | 0 | 0 |
Repayment of Loan | 0 | 57.5 | 420 |
Total cash outflow | 977.5 | 670 | 1145 |
Closing cash | 50 | 50 | 1265 |
Surplus/ ( Loan) | -477.5 | 0 | 1215 |
Total Loan needed in sep | 477.5 |
Assume Loan will be taken in September month will repaid when sufficient cash is available
2.Given the following information, how much of a line of credit is appropriate? (Jackie's Toy Manufacturer...
help please
Winter 2020 Budget Planning Following is selected information relating to the operations of Pocketchange Company, a tile distributor September 30, 2020 - Trial Balance information Cash.. Accounts receivable.... Inventory... Plant and equipment, net of Acc Dep Accounts payable.......... Capital stock........................ Retained earnings.................... 8.000 24.800 39.600 428 200 24,050 150.000 326,550 $ 500 600 $ 500,600 a. Actual and budgeted sales data: September (actual).................. October November December.... January... 62,000 66,000 80.000 94,000 48,000 b. Gross profit is 25% of...
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...
will give thumbs up, thank you!
ABC CORP BALANCE SHEET December 31, 2010 $100 Cash 0 Marketable Securities 2,000 Accounts Receivables 140 Inventory Fixed Assets Lnet) 2,000 Total Assets $2,380 Accounts Payable 0 Notes Payable Retained earnings 1400 Common Stock 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...
help please
Winter 2020 Budget Planning Following is selected information relating to the operations of Pocketchange Company, a tile distributor September 30, 2020 - Trial Balance information $ ................................. Accounts receivable..... ......... Inventory Plant and equipment, net of Acc. Dep. Accounts payable.............................. Capital stock......................... Retained earnings.... . ....... 8.000 24.800 39.600 428,200 24,050 150,000 326,550 500,600 $ 500,600 $ a. Actual and budgeted sales data: September (actual)................... October.... November................................ December................... .. January... BERBEDRE 62.000 66,000 80,000 94,000 48.000 b. Gross...
Styles Editing Voice ABC CORP BALANCE SHEET These Fixed Operating costs included al utilities, all insurance, all rent, all property taxes, and all labor charges Fixed Operating costs fother than depreciation expense) are paid for immediately, as they are incurred Fixed Operating costs were spread evenly throughout the year 2010. With regard to the size and timing of these costs, it is anticipated that the experience of 2010 will be repeated in 2011 Therefore, we anticipate cash payments associated with...
[The following information applies to the questions displayed below.) Mott Company has a line of credit with Bay Bank. Mott can borrow up to $570,000 at any time over the course of the 2018 calendar year. The following table shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during 2018. Mott agreed to pay interest at an annual rate equal to 1 percent above the bank's prime rate. Funds are borrowed or repaid...
(Preparation of a cash budget) Lewis Printing has projected its sales for the first 8 months of 2016 as follows: January $140,000 April $300,000 July $200,000 February $100,000 May $255,000 August $200,000 March $170,000 June $180,000 Lewis collects 30 percent of its sales in the month of thesale, 40 percent in the month following the sale, and the remaining 30 percent 2 months following the sale. During November and December of 2015, Lewis's sales were...
1)Make ledge from September to November
2)Make trial balance from September to November
3)Make income statement from September to November
4) Make financial position from September to November
Dale Jurnal Descriplion Debil (RM) Credit (RM) 2019 Sept! Cash Capital Slart a business with cash RM 12 150 1 Bank Capital (Bryan deposited RM 50 into business bank account as capital) 15 Purchas Cash (cash purchase) 19 Stationary Cash (hought receipt book with cast) 21 Bank Loon received loan from Bank...
The following information applies to the questions displayed below.] Jeremy Slacker started the Del Fuego Surf Shop on January 1 after determining that business school classes conflicted with his preferred activity. He invested $50,000 in the shop—$25,000 of his own savings and $25,000 borrowed from an acquaintance. The loan is to be repaid in 5 years. Jeremy will pay the lender annual interest at a rate of 8 percent. Shortly after opening, Jeremy realized that he is not the best...
CASH BUDGET WITH EXPLANATION Budget Information. December 2017 - March 2018 our bank account Assignment 5 Part A THE CASH BUDGET WITH EXPLANATION Millennium Corporation Cash Budget Information - December 2017 - March 2018 Budget Items Total Sales Credit Sales December 1.200.000 1.080.000 January Jar 1.500.000 1.350.000 February 1300000 1,300,000 1.170,000 March 1,400,000 1,260,000 300.000 30.000 15.000 310,000 30,000 16,000 Wages & Salaries Rentals Other Expenses Taxes Paid Dividends Equipment Purchase Cash Balance 325,000 30.000 17.000 150,000 50.000 declared 90,000...