The information given below is the Patriots Companys beginning balance sheet, estimates and policies, and the partially completed Master Budget for March and April. Use the information to answer the following 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Each question is worth 4 points for a total of 88 points on this exam. Patriots Company Balance Sheet As of February 28, 2019 ASSETS LIABILITIES & STOCKHOLDERS EQUITY Current Assets Current Liabilities Cash $ 5,000 Accounts Payable $ 11,000 Accounts Receivable 15,000 Commissions Payable 6,000 Prepaid Insurance - Dividends Payable - Inventory 1,600 Total Current Liabilities 17,000 Total Current Assets 21,600 Long-term debt 70,000 Property Plant & Equipment Land 60,400 Stockholders' Equity Equipment 85,000 Common Stock 45,000 Accumulated Depreciation (22,000) Retained Earnings 13,000 Net PP & E 123,400 Total Stockholders Equity 58,000 Total Assets $ 145,000 Total Liabilities & SE $ 145,000 1. Expected sales are $50,000, $64,000, and $72,000, respectively in March, April, and May. All sales are on credit. 2. The company collects 60% of sales in the month of the sale and 40% in the month after the sale. 3. The cost of goods sold is equal to 55% of sales. 4. The company desires an ending inventory equal to 20% of the next months cost of goods sold. 5. All purchases of inventory are on credit. The company pays for 70% of its purchases in the month of the purchase and 30% in the month after the purchase. 6. The company pays a 3% sales commission to its sales staff that is paid in the month after it is earned. 7. The company also incurs a utilities expense that is equal to $300 plus 1% of sales. This expense is paid in the month it is incurred. 8. Other Selling and Administrative Expenses, paid in the month they are incurred, include Advertising $1,100 per month, Salaries $1,400 per month and Depreciation $900 per month. 9. On March 1 the company purchased an insurance policy covering 24 months for $12,000. 10. The company pays interest on its long-term debt at the end of each month. Interest is equal to 1% of the balance of long-term debt at the beginning of the month. 11. On March 15 the company will purchase Land for $5,000, paying cash. 12. On March 27 the company will declare a $2,000 cash dividend that is to be paid on April 15. 13. The company requires a minimum cash balance of $5,000. If they must borrow funds, they must borrow in increments of $1,000. Any cash available in excess of the minimum cash balance will be used to pay down long-term debt. The company will either borrow funds or repay funds in a given month, but never both. Page 3 of 8 Patriots Company Sales Budget S&A Expenses Budget March April May March April Variable Selling & Admin Expenses Credit Sales $ 50,000 $ 64,000 $ 72,000 Sales Commissions (4) Utilities Cash Receipts: Total Variable S&A Expenses 2,000 2,560 From Current Month Sales From Prior Month Sales Fixed Selling & Admin Expenses Total Cash Receipts (1) $ 58,400 Utilities Advertising 1,100 1,100 Salaries 1,400 1,400 Depreciation 900 900 Inventory Purchases Budget Insurance (5) March April May Total Fixed S&A Expenses COGS $ $ 35,200 $ 39,600 Cash Payments for S&A Expenses Desired Ending Inventory Sales Commissions Total Inventory Needed Utilities 800 940 Beginning Inventory Advertising 1,100 1,100 Inventory Purchases (2) $ 36,080 Salaries 1,400 1,400 Depreciation (6) Cash Payments for Purchases Insurance (7) For Current Month Purchases Total Payments for S&A Expenses For Prior Month Purchases Total Cash Payments $ 34,058 (3) Page 4 of 8 Cash Budget March April Beginning Balance Pro-Forma Income Statement Cash Receipts 58,400 March April Total Cash Available 50,000 Sales $ 50,000 $ 64,000 Less: Variable Costs Cash Payments: COGS For Purchases 34,058 Variable S&A Expenses For S&A Expenses Contribution Margin (11) For Interest (8) For Land 5,000 Less: Fixed Costs For Dividends Fixed S&A Expenses Total cash payments 61,058 Interest Expense Surplus / (Deficit) (9) 21,394 Net Income $ 15,600 $ 21,170 New Borrowing / (Repayment) 17,000 (10) Ending Cash Balance Pro-Forma Balance Sheet March April March April ASSETS LIABILITIES & SE Current Assets Current Liabilities Cash (12) Accounts Payable $ 9,882 (18) Accounts Receivable 20,000 (13) Commissions Payable (19) Prepaid Insurance (14) Dividends Payable (20) Inventory (15) Total Current Liabilities Total Current Assets Long term debt (21) Property Plant & Equipment Land (16) Stockholders' Equity Equipment 85,000 85,000 Common Stock 45,000 45,000 Accumulated Depreciation (17) Retained Earnings (22) Total PP &E Total Stockholders Equity TOTAL ASSETS $ 171,982 $ 176,120 TOTAL LIABILITIES & SE $ 171,982 $ 176,120

1. What are Total Cash Receipts from customers for March?

   	A.	$45,000
   	B.	$ 5,000
   	C.	$30,000
   	D.	$15,000
   	E.	$36,000

4 points

QUESTION 7

1. What is the balance of Commissions Payable on March 31, 2019?

   	A.	$6,000
   	B.	$ 0
   	C.	$1,500
   	D.	$1,350
   	E.	$7,500

4 points

QUESTION 8

1. What is the balance of Dividends Payable on March 31, 2019?

   	A.	$2,500
   	B.	$2,000
   	C.	$1,250
   	D.	$ 0
   	E.	$1,000

4 points

QUESTION 9

1. What is Total Cash Surplus (Deficit) for March?

   	A.	$(11,058)
   	B.	$ 21,394
   	C.	$ 61,058
   	D.	$ 11,058
   	E.	$ 5,942

4 points

QUESTION 10

1. What is the balance of Accounts Payable on April 30, 2019?

   	A.	$35,138
   	B.	$36,080
   	C.	$ 9,882
   	D.	$25,256
   	E.	$10,824

4 points

QUESTION 11

1. What is Total Interest Expense for March?

   	A.	$ 700
   	B.	$1,400
   	C.	$2,100
   	D.	$ 0
   	E.	$7,000

4 points

QUESTION 12

1. What are Total Cash Payments for Purchases of Inventory for April?

   	A.	$36,256
   	B.	$35,138
   	C.	$25,256
   	D.	$34,058
   	E.	$36,080

4 points

QUESTION 13

1. What is Total Commissions Expense for March?

   	A.	$1,920
   	B.	$6,000
   	C.	$2,000
   	D.	$1,500
   	E.	$2,560

4 points

QUESTION 14

1. What is the balance of Prepaid Insurance on March 31, 2019?

   	A.	$ 0
   	B.	$ 500
   	C.	$11,000
   	D.	$11,500
   	E.	$12,000

4 points

QUESTION 15

1. What is the Contribution Margin for April?

   	A.	$64,000
   	B.	$21,170
   	C.	$20,500
   	D.	$37,760
   	E.	$26,240

4 points

QUESTION 16

1. What is the balance of Land on March 31, 2019?

   	A.	$ 5,000
   	B.	$90,000
   	C.	$60,400
   	D.	$42,500
   	E.	$65,400

4 points

QUESTION 17

1. What is the balance of Retained Earnings on April 30, 2019?

   	A.	$47,770
   	B.	$28,600
   	C.	$34,770
   	D.	$26,600
   	E.	$36,770

4 points

QUESTION 18

1. What is the balance of Accumulated Depreciation, as reflected on the Balance Sheet, on March 31, 2019?

   	A.	$(23,800)
   	B.	$(21,100)
   	C.	$( 1,800)
   	D.	$(22,900)
   	E.	$( 900)

4 points

QUESTION 19

1. What is Total Net Borrowing (Repayment) for April?

   	A.	$(21,394)
   	B.	$ 5,000
   	C.	$(16,394)
   	D.	$ 0
   	E.	$ 16,394

4 points

QUESTION 20

1. What are Total Purchases of Inventory for March?

   	A.	$31,400
   	B.	$32,940
   	C.	$38,700
   	D.	$34,540
   	E.	$36,140

4 points

QUESTION 21

1. What is the balance of Accounts Receivable on April 30, 2019?

   	A.	$38,400
   	B.	$25,600
   	C.	$20,000
   	D.	$ 5,600
   	E.	$58,400

4 points

QUESTION 22

1. What is the balance of Cash on April 30, 2019?

   	A.	$70,606
   	B.	$ 0
   	C.	$26,390
   	D.	$ 5,000
   	E.	$21,394