can you show the calculations for this
PART I. COMPANY'S INFORMATION (a) Balance Sheet, December 31, Year 0 ASSETS Current Assets \begin{tabular}{|l|c|c|} \hline Cash & $7,000 & \\ \hline Accounts Receivable & $10,000 & \\ \hline Finished Goods Inventory & $10,500 fo & 1,500 units \\ \hline Raw Materials Inventory & $10,350 fo & 6,900 lbs \\ \hline Prepaid Insurance & $2,400 & \\ \hline \end{tabular} Property, Plant and Equipment \begin{tabular}{lr|r} \hline Plant and Equipment & $70,000 & \\ \hline Less: Accumulated Depreciation & $5,000 & $65,000 \\ \hline \end{tabular} Total Assets $105,250 LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities \begin{tabular}{l|r} \hline Accounts Payable & $8,000 \\ \hline Long-term Note & $20,000 \end{tabular} Stockholders' Equity \begin{tabular}{l|l} \hline Common Stock & $40,000 \\ \hline Retained Earnings & $37,250 \\ \hline \end{tabular} Total Liabilities and Equity $105,250 th (e) Estimated S \& A (selling and administrative) Expenses \begin{tabular}{|l|r|l|l|l|} \hline Sales Commissions (Variable) & $0.80 & per Unit sold \\ \hline Salaries (Fixed) & $2,000 & per Month \\ \hline Advertising (Fixed) & $600 & per Month \\ \hline Miscellaneous (Fixed) & $2,345 & Jan only \\ \hline \end{tabular} (f) Estimated Cash Collections, Cash Payments, Financing and Other Information but after borrowing or repayment.) Bank Loan Borrowing time (If borrowing is needed for a given month, it should occur at the beginning of the month.) Borrowing amount Just enough to satisty the minimum cash level requirement (If repayment is ever made for a given month, it should occur at the beginning of the month) Repayment amount Maximum possible amount after satistying the minimum cash level requirement Interest payment time 1% per month on outstanding loan balance as of the end of the month To be paid at the end of each momh Insurance cost will be charged to (deducted from) Prepaid Insurance. No cash will be paid. Long-term Note is a laablity that does not bear interest. PART II. ALL BUDGETS/SCHEDULES FOR THE FIRST QUARTER OF Year 1 (1) Sales Budget Expected sales - units Selling price per unit Total sales (2) Schedule of Expected Cash Collections (Cash Receipts Budget) Jan Feb Mar Qtr From sales before January From January sales From February sales From March sales \begin{tabular}{|} \\ \\ \\ \hline \end{tabular} Total cash collections (3) Production Budget Expected sales units Desired ending inventory Total needs Less: Beginning inventory Less: Beginning inventory Units to be produced (4) Direct Materials Purchases Budget Units to be produced Material needed per unit (lbs) Production needs (lbs) Desired ending quantity (lbs) Total needs (lbs) Less: Beginning quantity (lbs) Material to be purchased (lbs) Cost of material purchase (\$) (5) Schedule of Expected Cash Disbursements (Cash Disbursements Budget) for Direct Materials Qtr For Purchases before January For January purchases For February purchases For March purchases Total cash disbursements (6) Direct Labor Budget Units to be produced DL time required per unit Disbursements: \begin{tabular}{|l|} \hline Payments for Material purchases \\ \hline Payments for Direct labor costs \\ \hline Payments for Manufacturing overhead \\ Payments for Selling and administrative \\ Payments for Equipment purchase \\ \hline Payments for Dividends \\ \hline Total Disbursements \\ \hline \end{tabular} Excess (Deficiency) " negative amount in ( ) Financing: Bank loan Borrowing (repayment) * negative amount in ( ) Cash before interest payment Interest payment Cash balance, ending (10) Budgeted Income Statement, for 1st Quarter of Year 1 Qtr Sales Less: Cost of goods sold Gross margin Less: Selling and admin. expenses Net oneratinn income LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities Accounts Payable Long-term Note Bank Loan Stockholders' Equity Common Stock Retained Earnings Total Liabilities and Equity Net operating income Less: Interest expenses Net income (11) Balance Sheet, as of March 31, Year 1 ASSETS Current Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Prepaid Insurance Property, Plant and Equipment Plant and Equipment Less: Accumulated Depreciation Total Assets PART I. COMPANY'S INFORMATION (a) Balance Sheet, December 31, Year 0 ASSETS Current Assets \begin{tabular}{|l|c|c|} \hline Cash & $7,000 & \\ \hline Accounts Receivable & $10,000 & \\ \hline Finished Goods Inventory & $10,500 fo & 1,500 units \\ \hline Raw Materials Inventory & $10,350 fo & 6,900 lbs \\ \hline Prepaid Insurance & $2,400 & \\ \hline \end{tabular} Property, Plant and Equipment \begin{tabular}{lr|r} \hline Plant and Equipment & $70,000 & \\ \hline Less: Accumulated Depreciation & $5,000 & $65,000 \\ \hline \end{tabular} Total Assets $105,250 LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities \begin{tabular}{l|r} \hline Accounts Payable & $8,000 \\ \hline Long-term Note & $20,000 \end{tabular} Stockholders' Equity \begin{tabular}{l|l} \hline Common Stock & $40,000 \\ \hline Retained Earnings & $37,250 \\ \hline \end{tabular} Total Liabilities and Equity $105,250 th (e) Estimated S \& A (selling and administrative) Expenses \begin{tabular}{|l|r|l|l|l|} \hline Sales Commissions (Variable) & $0.80 & per Unit sold \\ \hline Salaries (Fixed) & $2,000 & per Month \\ \hline Advertising (Fixed) & $600 & per Month \\ \hline Miscellaneous (Fixed) & $2,345 & Jan only \\ \hline \end{tabular} (f) Estimated Cash Collections, Cash Payments, Financing and Other Information but after borrowing or repayment.) Bank Loan Borrowing time (If borrowing is needed for a given month, it should occur at the beginning of the month.) Borrowing amount Just enough to satisty the minimum cash level requirement (If repayment is ever made for a given month, it should occur at the beginning of the month) Repayment amount Maximum possible amount after satistying the minimum cash level requirement Interest payment time 1% per month on outstanding loan balance as of the end of the month To be paid at the end of each momh Insurance cost will be charged to (deducted from) Prepaid Insurance. No cash will be paid. Long-term Note is a laablity that does not bear interest. PART II. ALL BUDGETS/SCHEDULES FOR THE FIRST QUARTER OF Year 1 (1) Sales Budget Expected sales - units Selling price per unit Total sales (2) Schedule of Expected Cash Collections (Cash Receipts Budget) Jan Feb Mar Qtr From sales before January From January sales From February sales From March sales \begin{tabular}{|} \\ \\ \\ \hline \end{tabular} Total cash collections (3) Production Budget Expected sales units Desired ending inventory Total needs Less: Beginning inventory Less: Beginning inventory Units to be produced (4) Direct Materials Purchases Budget Units to be produced Material needed per unit (lbs) Production needs (lbs) Desired ending quantity (lbs) Total needs (lbs) Less: Beginning quantity (lbs) Material to be purchased (lbs) Cost of material purchase (\$) (5) Schedule of Expected Cash Disbursements (Cash Disbursements Budget) for Direct Materials Qtr For Purchases before January For January purchases For February purchases For March purchases Total cash disbursements (6) Direct Labor Budget Units to be produced DL time required per unit Disbursements: \begin{tabular}{|l|} \hline Payments for Material purchases \\ \hline Payments for Direct labor costs \\ \hline Payments for Manufacturing overhead \\ Payments for Selling and administrative \\ Payments for Equipment purchase \\ \hline Payments for Dividends \\ \hline Total Disbursements \\ \hline \end{tabular} Excess (Deficiency) " negative amount in ( ) Financing: Bank loan Borrowing (repayment) * negative amount in ( ) Cash before interest payment Interest payment Cash balance, ending (10) Budgeted Income Statement, for 1st Quarter of Year 1 Qtr Sales Less: Cost of goods sold Gross margin Less: Selling and admin. expenses Net oneratinn income LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities Accounts Payable Long-term Note Bank Loan Stockholders' Equity Common Stock Retained Earnings Total Liabilities and Equity Net operating income Less: Interest expenses Net income (11) Balance Sheet, as of March 31, Year 1 ASSETS Current Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Prepaid Insurance Property, Plant and Equipment Plant and Equipment Less: Accumulated Depreciation Total Assets
