Week 4 - AK (1)

xlsx

School

Humber College *

*We aren’t endorsed by this school

Course

ACCG70024

Subject

Accounting

Date

Nov 24, 2024

Type

xlsx

Pages

9

Uploaded by tastyyum9

Report
Cash Budgeting Exercise PDC Company March April May June July Schedule 1: Sales Forecast $ 40,000.00 $ 50,000.00 $ 80,000.00 $ 60,000.00 $ 50,000.00 Credit sales, 40% $ 16,000.00 $ 20,000.00 $ 32,000.00 $ 24,000.00 $ 20,000.00 Cash sales, 60% $ 24,000.00 $ 30,000.00 $ 48,000.00 $ 36,000.00 $ 30,000.00 Schedule 2: Cash Collections Cash sales this month $ 30,000.00 $ 48,000.00 $ 36,000.00 $ 30,000.00 100% of last month's credit sales $ 16,000.00 $ 20,000.00 $ 32,000.00 $ 24,000.00 Total Collections $ 46,000.00 $ 68,000.00 $ 68,000.00 $ 54,000.00 Schedule 3: Purchases Ending inventory $ 48,000.00 $ 64,800.00 $ 53,600.00 $ 48,000.00 $ 42,400.00 Cost of goods sold $ 28,000.00 $ 35,000.00 $ 56,000.00 $ 42,000.00 $ 35,000.00 Total needed $ 76,000.00 $ 99,800.00 $ 109,600.00 $ 90,000.00 $ 77,400.00 Beginning Inventory $ 42,400.00 $ 48,000.00 $ 64,800.00 $ 53,600.00 $ 48,000.00 Purchases $ 33,600.00 $ 51,800.00 $ 44,800.00 $ 36,400.00 $ 29,400.00 Schedule 4: Disbursements for Purchases 50% of last month's purchases $ 16,800.00 $ 25,900.00 $ 22,400.00 $ 18,200.00 50% of this month's purchases $ 25,900.00 $ 22,400.00 $ 18,200.00 $ 14,700.00 Disbursements for merchandise $ 42,700.00 $ 48,300.00 $ 40,600.00 $ 32,900.00 Schedule 5: Wages and Commissions Wages, all fixed $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 Commissions (15% of current sales) $ 6,000.00 $ 7,500.00 $ 12,000.00 $ 9,000.00 $ 7,500.00 Total $ 8,500.00 $ 10,000.00 $ 14,500.00 $ 11,500.00 $ 10,000.00 Schedule 6: Disbursements-Wages/Comm 50% of last month's expenses $ 4,250.00 $ 5,000.00 $ 7,250.00 $ 5,750.00 50% of this month's expenses $ 5,000.00 $ 7,250.00 $ 5,750.00 $ 5,000.00
Cash Budgeting Exercise Total $ 9,250.00 $ 12,250.00 $ 13,000.00 $ 10,750.00 Cash Budget April May June July Beginning cash balance $ 10,000.00 $ 10,550.00 $ 10,970.00 $ 10,965.00 Cash receipts Collections from customers $ 46,000.00 $ 68,000.00 $ 68,000.00 $ 54,000.00 Total cash available for needs, before fin. $ 56,000.00 $ 78,550.00 $ 78,970.00 $ 64,965.00 Cash disbursements: Merchandise $ 42,700.00 $ 48,300.00 $ 40,600.00 $ 32,900.00 Wages and commissions $ 9,250.00 $ 12,250.00 $ 13,000.00 $ 10,750.00 Miscellaneous expenses $ 2,500.00 $ 4,000.00 $ 3,000.00 $ 2,500.00 Rent $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 Truck purchase $ 3,000.00 Total disbursements $ 59,450.00 $ 66,550.00 $ 58,600.00 $ 48,150.00 Minimum cash balance desired $ 10,000.00 $ 10,000.00 $ 10,000.00 $ 10,000.00 Total cash needed $ 69,450.00 $ 76,550.00 $ 68,600.00 $ 58,150.00 Excess of total cash $ (13,450.00) $ 2,000.00 $ 10,370.00 $ 6,815.00 Financing New Borrowing $ - $ 14,000.00 $ - $ - $ - Repayments $ 1,000.00 $ 9,000.00 $ 4,000.00 Loan balance $ 14,000.00 $ 13,000.00 $ 4,000.00 $ - Interest $ - $ 30.00 $ 405.00 $ 240.00 Total effects of financing $ 14,000.00 $ (1,030.00) $ (9,405.00) $ (4,240.00) Cash balance $ 10,550.00 $ 10,970.00 $ 10,965.00 $ 12,575.00 Budgeted Income Statements Sales $ 240,000.00 COGS $ 168,000.00 Gross Margin $ 72,000.00 Operating Expenses Wages and commissions $ 46,000.00
Cash Budgeting Exercise Rent $ 8,000.00 Miscellaneous expenses $ 12,000.00 Insurance $ 800.00 Depreciation $ 2,000.00 Total operating expenses $ 68,800.00 Income from operations $ 3,200.00 Interest expense $ 675.00 Net income $ 2,525.00 Budgeted Balance Sheets Current Assets: Cash $ 12,575.00 Accounts receivable $ 20,000.00 Merchandise inventory $ 42,400.00 Unexpired insurance $ 1,000.00 Total Current Assets $ 75,975.00 Plant Equipment, fixtures and other $ 40,000.00 Accumulated depreciation $ 14,800.00 Net PPE $ 25,200.00 Total Assets $ 101,175.00 Current Liabilities Accounts payable $ 14,700.00 Accrued wages and commissions payable $ 5,000.00 Loan Total Current Liabilities $ 19,700.00 Owner's equity $ 81,475.00 Total equities $ 101,175.00 Budgeted Cash Flows
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cash Budgeting Exercise Cash Flows From Activities Net Income $ 2,525.00 Adjustments to Net Inc for CF Depreciation Expense $ 2,000.00 Decrease in Prepaids $ 800.00 Increase in Accrued Liab. $ 750.00 Decrease in Inventory $ 5,600.00 Decrease in A/P $ (2,100.00) Increase in A/R $ (4,000.00) Decrease in Def. Inc. Tax $ - Total Adjustments $ 3,050.00 Net Cash Flow From Opps (Acct.) $ 5,575.00 Cash Flows From Investing Capex $ (3,000.00) Net Cash Used by Ops/Investments $ (3,000.00)
Cash Budgeting Exercise Cash Flows from Financing Equity Issues $ - Dividends $ - Debt Issues $ - Net Cash Flows from Financing $ - Net Decrease in Cash and Cash Equiv. $ 2,575.00 Beginning Cash Balance $ 10,000.00 Ending Cash Balance $ 12,575.00
Cash Budgeting Exercise August Total Apr-Jly $ 40,000.00 $ 240,000.00 $ 168,000.00 $ 46,000.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
B/S 2018 2019 Cash $ 50,000.00 $ 50,000.00 A/R $ 200,000.00 $ 300,000.00 Inventories $ 450,000.00 $ 570,000.00 C/A $ 700,000.00 $ 920,000.00 Fixed Assets $ 300,000.00 $ 380,000.00 Total Assets $ 1,000,000.00 $ 1,300,000.00 A/P $ 130,000.00 $ 180,000.00 Accruals $ 50,000.00 $ 70,000.00 Bank Loan $ 90,000.00 $ 90,000.00 C/L $ 270,000.00 $ 340,000.00 Lomg-term Debt $ 400,000.00 $ 550,000.00 Common Stock $ 50,000.00 $ 50,000.00 Paid-in Capital $ 200,000.00 $ 200,000.00 R/E $ 80,000.00 $ 160,000.00 Total Liabilities and Equity $ 1,000,000.00 $ 1,300,000.00 I/S Net Sales $ 1,300,000.00 $ 1,600,000.00 COGS $ 780,000.00 $ 960,000.00 Gross Profit $ 520,000.00 $ 640,000.00 Marketing $ 130,000.00 $ 160,000.00 G&A Costs $ 150,000.00 $ 150,000.00 Depreciation $ 40,000.00 $ 55,000.00 EBIT $ 200,000.00 $ 275,000.00 Interest $ 45,000.00 $ 55,000.00 EBT $ 155,000.00 $ 220,000.00 Taxes (40%) $ 62,000.00 $ 88,000.00 Net Income $ 93,000.00 $ 132,000.00
Average $ 250,000.00 6.40 57.03 Days Receivable 251 $ 510,000.00 1.88 193.91 Days Inventory $ 155,000.00 $ 215,000.00 4.47 81.74 Days Payable 169 $ 60,000.00
Operating Cycle CCC
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help