Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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

What is Total Cash Payment for Insurance Expense for April?

A.

$ 1,000

B.

$ 1,500

C.

$500

D.

$ 0

E.

$12,000

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

Step: 3

blur-text-image

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

Contemporary Auditing

Authors: Michael C. Knapp

8th edition

978-0538466790, 538466790, 978-1285066608

More Books

Students also viewed these Accounting questions