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
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
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
Hii expert please given correct answer general accounting question
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
- 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_forwardExercise 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_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_forwardActivity 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_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,000arrow_forwardHii expert please given correct answer general accounting questionarrow_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