Week 4 - AK (1)
xlsx
keyboard_arrow_up
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
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
Related Documents
Related Questions
-/1
View Policies
Current Attempt in Progress
Scan Design provided the following budgeted information for April through July:
July
June
May
April
$104,000 $123,000 $115,000 $132,000
Projected sales
Projected merchandise purchases $82,000 $92,000 $78,000 $66,000
.The cash balance on June 1 is $12,000. The company pays 40% of merchandise purchases in the month purchased
and 60% in the following month.
. General operating expenses are budgeted to be $31,000 per month of which depreciation is $3,000 of this
amount. Management pays operating expenses in the month incurred
The company makes loan payments of $4,000 per month of which $600 is interest and the remainder is principal.
How much are budgeted cash disbursements for June?
O $63,200.
O $86,400.
O $118.400.
$102,800.
8:38 P
11/27/2
hp
fa4+
f12
SU
prt sc
A
delete
home
end
&
7
num
backspace
lock
home
K
4
enter
I
arrow_forward
Subject: accounting
arrow_forward
General accounting question
arrow_forward
The information in the following table is from a company's sales budget
Expected sales
April
May
June
$ 96,000
116,000
126,000
Cash sales are normally 25% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in June
OAS118,500
O $31,500
OC$213,000
005126,000
O $87,000
arrow_forward
3/2020
Forum: Accounting Discussion - Chapter 22 Budgetary Planning &...
Budgeted Sales
$300,000
Budgeted D.M. Purchases
$45,000
April
May
320,000
54,000
June
370,000
60,000
Moorcroft's sales are 40% cash and 60% credit, Credit sales are collected 20% in the month of sale, 50% in
the month following sale, and 26% in the second month following sale; 4% are uncollectible. Moorcroft's
purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month following
the purchase and 60% in the second month following the purchase.
Instructions
a. Prepare a schedule of expected collections from customers for June.
b. Prepare a schedule of expected payments for direct materials for June.
c. Moorcroft's assistant controller suggested that Moorcroft hire a part time collector to encourage
customers to pay more promptly and to reduce the amount of uncollectible accounts. Sales are still
40% cash and 60% credit but the assistant controller predicted that this would cause credit…
arrow_forward
Do fast answer of this general accounting question
arrow_forward
Exercise 1 (Schedule of expected Cash Collection)
Peak sales for Mideast Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below:
July August September Total
Budgeted sales ................ P600,000 P900,000 P500,000 P2,000.000
From past experience, the company has learned that 20% of a month’s sales are
collected in the month of sale, that another 70% is collected in the month following
sale, and that the remaining 10% is collected in the second month following sale.
Bad debts are negligible and can be ignored. May sales totaled P430,000 and
June sales totaled P540,000.
Required:
Prepare a schedule of expected cash collections from sales, by month
and in total, for the third quarter.
Assume that the company will prepare a budgeted statement of financial
position as of September 30. Compute the accounts receivable as of that
date.
arrow_forward
Question 10
View Policies
Current Attempt in Progress
The following credit sales are budgeted by Waterway Industries:
t
$174000
January
250000
February
390000
March
280000
April
The company's past experience indicates that 70% of the accounts receivable are collected in the month of sale, 20% in
the month following the sale, and 8% in the second month following the sale. The anticipated cash inflow for the month
of April is
O $336920.
O $294000.
O $280800.
O $274000.
hp
holl
12
44
ins
prt sc
delete
home
&
6
7
backspace
lock
P
C
H
K
L
nt
arrow_forward
Cash Budget
The following budget estimates have been prepared by Clifton Company:
Cash Receipts - May $120,000 June $110,300
Cash Payments - May $150,000 June $150,000
The company likes to maintain a minimum cash balance of $40,000. Any excess cash is invested in a money market account earning 9% compounded monthly. Interest is reinvested in the money market account. Any cash deficiencies are covered by a withdrawal from the money market account. If additional cash is needed, the company has a line of credit at 12% interest with the local bank. Interest is paid monthly.
Assume a cash balance on May 1 of $40,000, a money market account balance of $0, and a credit line balance of $0.
Required:
Prepare a cash budget for May and June. Use the attached spreadsheet.
arrow_forward
Activity No. 13: Budgeting
Callgate Company has forecast credit sales for the fourth quarter of the year:
September (actual)
Fourth Quarter:
October
November
December
P 100,000
80,000
70,000
120,000
Based on the past experience, 20% of sales are collected in the month of sales, 70% in the following month and 10% are never collected.
Prepare a schedule of cash receipts for the company covering the last quarter of the year.
arrow_forward
Budgeted sales for the month of April are shown in the following table:
April May June
$500
$800
Sales
Cash Sales
Sales on Account
The company expects a 25% Increase in sales per month for May and June. The amount of sales revenues that would appear on the company's 2nd quarter pro forma income statement
would be
Multiple Choice
O
O
$4,956.25.
$4,225.50.
$3,050.00.
$2,031.25.
arrow_forward
Question 1
The following sales budget has been prepared for greyhound Express:
CAsh Sales. Credit Sales
January 10000 20000
Feb 20,000 30,000
mar 30,000. 40,000
April 40,000 50,000
collections are 50% in the month of sales, 40% in the month following sales and 5% two months following the sale. The remaining 5% is expected to be collected. the balance for the accounts reeivable to be reflected in the balance sheet at the end of April is
a. $44,000
b $24,500
c $70,000
d $90,000
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Related Questions
- -/1 View Policies Current Attempt in Progress Scan Design provided the following budgeted information for April through July: July June May April $104,000 $123,000 $115,000 $132,000 Projected sales Projected merchandise purchases $82,000 $92,000 $78,000 $66,000 .The cash balance on June 1 is $12,000. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. . General operating expenses are budgeted to be $31,000 per month of which depreciation is $3,000 of this amount. Management pays operating expenses in the month incurred The company makes loan payments of $4,000 per month of which $600 is interest and the remainder is principal. How much are budgeted cash disbursements for June? O $63,200. O $86,400. O $118.400. $102,800. 8:38 P 11/27/2 hp fa4+ f12 SU prt sc A delete home end & 7 num backspace lock home K 4 enter Iarrow_forwardSubject: accountingarrow_forwardGeneral accounting questionarrow_forward
- The information in the following table is from a company's sales budget Expected sales April May June $ 96,000 116,000 126,000 Cash sales are normally 25% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in June OAS118,500 O $31,500 OC$213,000 005126,000 O $87,000arrow_forward3/2020 Forum: Accounting Discussion - Chapter 22 Budgetary Planning &... Budgeted Sales $300,000 Budgeted D.M. Purchases $45,000 April May 320,000 54,000 June 370,000 60,000 Moorcroft's sales are 40% cash and 60% credit, Credit sales are collected 20% in the month of sale, 50% in the month following sale, and 26% in the second month following sale; 4% are uncollectible. Moorcroft's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month following the purchase and 60% in the second month following the purchase. Instructions a. Prepare a schedule of expected collections from customers for June. b. Prepare a schedule of expected payments for direct materials for June. c. Moorcroft's assistant controller suggested that Moorcroft hire a part time collector to encourage customers to pay more promptly and to reduce the amount of uncollectible accounts. Sales are still 40% cash and 60% credit but the assistant controller predicted that this would cause credit…arrow_forwardDo fast answer of this general accounting questionarrow_forward
- Exercise 1 (Schedule of expected Cash Collection) Peak sales for Mideast Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below: July August September Total Budgeted sales ................ P600,000 P900,000 P500,000 P2,000.000 From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P430,000 and June sales totaled P540,000. Required: Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. Assume that the company will prepare a budgeted statement of financial position as of September 30. Compute the accounts receivable as of that date.arrow_forwardQuestion 10 View Policies Current Attempt in Progress The following credit sales are budgeted by Waterway Industries: t $174000 January 250000 February 390000 March 280000 April The company's past experience indicates that 70% of the accounts receivable are collected in the month of sale, 20% in the month following the sale, and 8% in the second month following the sale. The anticipated cash inflow for the month of April is O $336920. O $294000. O $280800. O $274000. hp holl 12 44 ins prt sc delete home & 6 7 backspace lock P C H K L ntarrow_forwardCash Budget The following budget estimates have been prepared by Clifton Company: Cash Receipts - May $120,000 June $110,300 Cash Payments - May $150,000 June $150,000 The company likes to maintain a minimum cash balance of $40,000. Any excess cash is invested in a money market account earning 9% compounded monthly. Interest is reinvested in the money market account. Any cash deficiencies are covered by a withdrawal from the money market account. If additional cash is needed, the company has a line of credit at 12% interest with the local bank. Interest is paid monthly. Assume a cash balance on May 1 of $40,000, a money market account balance of $0, and a credit line balance of $0. Required: Prepare a cash budget for May and June. Use the attached spreadsheet.arrow_forward
- Activity No. 13: Budgeting Callgate Company has forecast credit sales for the fourth quarter of the year: September (actual) Fourth Quarter: October November December P 100,000 80,000 70,000 120,000 Based on the past experience, 20% of sales are collected in the month of sales, 70% in the following month and 10% are never collected. Prepare a schedule of cash receipts for the company covering the last quarter of the year.arrow_forwardBudgeted sales for the month of April are shown in the following table: April May June $500 $800 Sales Cash Sales Sales on Account The company expects a 25% Increase in sales per month for May and June. The amount of sales revenues that would appear on the company's 2nd quarter pro forma income statement would be Multiple Choice O O $4,956.25. $4,225.50. $3,050.00. $2,031.25.arrow_forwardQuestion 1 The following sales budget has been prepared for greyhound Express: CAsh Sales. Credit Sales January 10000 20000 Feb 20,000 30,000 mar 30,000. 40,000 April 40,000 50,000 collections are 50% in the month of sales, 40% in the month following sales and 5% two months following the sale. The remaining 5% is expected to be collected. the balance for the accounts reeivable to be reflected in the balance sheet at the end of April is a. $44,000 b $24,500 c $70,000 d $90,000arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeFundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning