Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please submit the following blank spaces typed out. CAMDEN COMPANY $ 125,000 40% 60% 8% 100% 60% Part a. October sales Sales in cash Sales

Please submit the following blank spaces typed out.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
CAMDEN COMPANY $ 125,000 40% 60% 8% 100% 60% Part a. October sales Sales in cash Sales on credit Expected sales growth per month Part b. Accounts receivable collected in month following sales Part c. Cost of goods sold as percentage of sales Ending inventory - percent of next month's cost of goods sold December estimated ending inventory Part d. Accounts payable paid in month of purchase Accounts payable paid in month following purchase Parte. Salary expense (fixed) Sales commissions (percent of sales) Supplies expense (percent of sales) Utilities (fixed) Depreciation on store fixtures (fixed) Rent (fixed) Miscellaneous (fixed) $ 10% 6,000 70% 30% 9,000 5% 2% 700 2,000 2,400 600 82,000 10.000 Cost of store fixtures Salvage value - store fixtures Useful life (years) - store fixtures Part g. Borrowing increments Monthly interest rate Cash cushion $ 1,000 1% 6,000 $ CAMDEN COMPANY October November December Pro Forma a. Sales Budget Cash sales Sales on account Total budgeted sales October November December Pro Forma Schedule of Cash Receipts Current cash sales Plus collections from A/R Total collections c. Inventory Purchases Budget Pro Forma Data October November December Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) 60 NOU 8 d. Schedule of Cash Payments Budget for Inventory Purchases October November December Pro Forma Data 31 32 Payment of current month's accounts payable Payment for prior month's accounts payable Total budgeted payments for inventory 33 34 35 Pro Forma Data 38 November December 40 36 e. Selling and Administrative Expense Budget 37 October 39 Salary expense Sales commissions 41 Supplies expense 42 Utilities Depreciation on store fixtures 44 Rent 45 Miscellaneous 43 d. Schedule of Cash Payments Budget for Inventory Purchases October Pro Forma Data November December December Payment of current month's accounts payabl Payment for prior month's accounts payable Total budgeted payments for inventory e. Selling and Administrative Expense Budget Pro Forma Data October November December Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total S&A expenses f. Schedule of Cash Payments for S&A Expenses Pro Forma October November December Data T Salary expense Prior month sales commissions Supplies expense Prior month utilities Depreciation on store fixtures Rent Miscellaneous Total payments for S&A expenses CC O 2 g. Cash Budget Pro Forma Data October November December 54 Beginning cash balance Add cash receipts Cash available Less payments For inventory purchases For S&A expenses Purchase of store fixtures Interest expense Total budgeted payments g. Cash Budget Pro Forma Data October November December Beginning cash balance Add cash receipts Cash available Less payments For inventory purchases For S&A expenses Purchase of store fixtures Interest expense Total budgeted payments Payment minus receipts Surplus (shortage) Financing activity Borrowing (repayment) Ending cash balance ON CAMDEN COMPANY Pro Forma Income Statement For the Quarter Ended December 31, Year 1 35 36 87 88 89 90 Sales revenue Cost of goods sold Gross margin S&A expenses Operating income Interest expense Net income 91 92 93 i. CAMDEN COMPANY Pro Forma Balance Sheet December 31, Year 1 96 Assets Cash Accounts receivable Inventory Store fixtures Accumulated depreciation Book value of fixtures Total assets CAMDEN COMPANY Pro Forma Balance Sheet December 31, Year 1 Assets Cash Accounts receivable Inventory Store fixtures Accumulated depreciation Book value of fixtures Total assets Liabilities Accounts payable Utilities payable Sales commissions payable Line of credit liability Equity Retained earnings Total liabilities and equity CAMDEN COMPANY Pro Forma Statement of Cash Flows For the Quarter Ended December 31, Year 1 Cash flows from operating activities Cash receipts from customers Cash payments for inventory Cash payments for S&A expenses Cash payments for interest expense Net cash flows from operating activities 25 Cash flows from investing activities Cash payment for store fixtures 30 31 32 Cash flows from financing activities Net inflow from line of credit Net increase in cash Plus: Beginning cash balance Ending cash balance 33 34 35 136

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Horngrens Accounting Volume 1

Authors: Tracie Miller Nobles, Brenda Mattison, Ella Mae Matsumura

12th Canadian Edition

0136889373, 9780136889373

More Books

Students also viewed these Accounting questions