Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
15th Edition
ISBN: 9780134476315
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 4.2STP
a)
Summary Introduction
To calculate: Cash budget.
Introduction:
Cash budget can be defined as a money spending plan which estimates the money inflows and outflows for a business over a particular timeframe. It is used to assess whether the firm has adequate money to work.
b)
Summary Introduction
To calculate: Required total financing.
c)
Summary Introduction
To calculate: Size of the following particulars for preparation of pro forma balance sheet.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
GIVE NOTES
SHOW ACCOUNT RECEIVABLE AND ACCOUNT PAYABLE
The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows:
Month
Cash Sales
Sales on account
Purchase
August
September
October
November
December
$85,000
$70,000
$88,550
$77,160
$174,870
$640,000
$550,000
$600,000
$800,000
$500,000
$420,000
$550,000
$500,000
$600,000
$450,000
An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:
50% in the month of sale
30% in the first month following the sale
20% in the second month following the sale
Expected purchases include monthly cash purchases of 5%. All other purchases are…
Marie Marx, the management accountant at “Go Jamdown” is in the process ofplanning the company’s cash needs for the third quarter of 2008. She has receivedthe following information to assist in the preparation of the cash budget for thebusiness.Month Cash Sales Credit Sales Purchases SellingExpensesMay $140,000 $500,000 $0June $160,000 $600,000 $600,000July $180,000 $700,000 $675,000 $ 75,000August $156,000 $580,000 $575,000 $105,000September $160,000 $600,000 $600,000 $ 85,000The following additional information is also available:i) An analysis of the records show that the collection of accounts receivable aresettled, according to the following pattern, in accordance with the creditterms 10/30, n90:o 50% collected in the month of saleo 40% collected in the month following saleo 10% collected two months following saleii) Eighty percent (80%) of monthly purchases is paid in the month of purchase &the remaining 20% will be paid two months following the purchase. The creditterms of…
Classique Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following:
i) Extracts from the sales and purchases budgets are as follows:
Month
Cash
Sales
Sales
On Account
Purchases
On Account
May
$50,000
$480,000
$390,000
June
$65,000
$600,000
$360,000
July
$43,400
$720,000
$450,000
August
$52,800
$640,000
$400,000
September
$56,750
$800,000
$500,000
ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90:
50% in the month of sale
35% in the first month following the sale
15% in the second month following the sale
iii)…
Chapter 4 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
Ch. 4.1 - Prob. 4.1RQCh. 4.1 - Prob. 4.2RQCh. 4.2 - Briefly describe the first four modified...Ch. 4.2 - Describe the overall cash flow through the firm in...Ch. 4.2 - Prob. 4.5RQCh. 4.2 - 4-B Why is depreciation (as well as amortization...Ch. 4.2 - Prob. 4.7RQCh. 4.2 - Prob. 4.8RQCh. 4.2 - Prob. 4.9RQCh. 4.3 - Prob. 4.10RQ
Ch. 4.3 - Prob. 4.11RQCh. 4.3 - Prob. 4.12RQCh. 4.3 - What is the cause of uncertainty in the cash...Ch. 4.4 - Prob. 4.14RQCh. 4.5 - Prob. 4.15RQCh. 4.5 - Prob. 4.16RQCh. 4.6 - Prob. 4.17RQCh. 4.6 - What is the significance of the plug figure,...Ch. 4.7 - Prob. 4.19RQCh. 4.7 - Prob. 4.20RQCh. 4 - Opener-in-Review The chapter opener described a...Ch. 4 - Learning Goals 2, 3 ST4-1 Depreciation and cash...Ch. 4 - Prob. 4.2STPCh. 4 - Prob. 4.3STPCh. 4 - Prob. 4.1WUECh. 4 - Prob. 4.2WUECh. 4 - Learning Goal 3 E4-3 Determine the operating cash...Ch. 4 - Prob. 4.4WUECh. 4 - Learning Goal 5 E4-5 Rimier Corp. forecasts sales...Ch. 4 - Prob. 4.1PCh. 4 - Learning Goal 2 P4-2 Depreciation In early 2019,...Ch. 4 - Prob. 4.3PCh. 4 - Learning Goals 2, 3 P4-4 Depreciation and...Ch. 4 - Learning Goal 3 P4-5 Classifying inflows and...Ch. 4 - Prob. 4.6PCh. 4 - Learning Goal 4 P4-8 Cash receipts A firm has...Ch. 4 - Learning Goal 4 P4-9 Cash disbursements schedule...Ch. 4 - Learning Goal 4 P4-10 Cash budget: Basic Grenoble...Ch. 4 - Prob. 4.11PCh. 4 - Learning Goal 4 P4-12 Cash budget: Advanced The...Ch. 4 - Prob. 4.13PCh. 4 - Prob. 4.14PCh. 4 - Learning Goal 4 P4-15 Multiple cash budgets:...Ch. 4 - Learning Goal 5 P4-16 Pro forma income statement...Ch. 4 - Learning Goal 5 P4-17 Pro forma income statement:...Ch. 4 - Learning Goal 5 P4-18 Pro forma balance sheet:...Ch. 4 - Learning Goal 5 P4-19 Pro forma balance sheet...Ch. 4 - Learning Goal 5 P4-20 Integrative: Pro forma...Ch. 4 - Learning Goal 5 P4-21 Integrative: Pro forma...Ch. 4 - Prob. 4.22PCh. 4 - Prob. 1SE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Classique Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following: i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases On Account May $50,000 $480,000 $390,000 June $65,000 $600,000 $360,000 July $43,400 $720,000 $450,000 August $52,800 $640,000 $400,000 September $56,750 $800,000 $500,000 ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 35% in the first month following the sale 15% in the second month following the sale iii)…arrow_forwardClassique Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following: i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases On Account May $50,000 $480,000 $390,000 June $65,000 $600,000 $360,000 July $43,400 $720,000 $450,000 August $52,800 $640,000 $400,000 September $56,750 $800,000 $500,000 ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are settled according to the following credit pattern, in accordance with the credit terms: 50% in the month of sale 35% in the first month following the sale 15% in the second month following the sale iii) Accounts…arrow_forwardProblem 1. Jane McDonald, a financial analyst for Carroll Company, has prepared the following sales and cash disbursement estimates for the period February to June of the current year. Cash disbursements Month Sales February $500 $400 March 600 300 April 400 600 May 200 500 June 200 200 McDonald notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a minimum ending balance in its cash account of $25. Balances above this amount would be invested in short-term government securities (marketable securities), whereas any deficits would be financed through short-term bank borrowing (notes payable). The beginning cash balance at April 1 is $115. a. Prepare cash budgets for April, May, and June. b. How much financing, if any, at a maximum would Carroll Company require to meet its obligations during this 3-month period? c. A pro forma balance…arrow_forward
- Pelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending Mar 31, 2022 1 Extracts from the sales and purchases budgets are as follows Month 2021 - 2022 Cash Sales $ Sales on A/C $ Cash Purchases $ Purchases on A/C $ Nov 2021 138,100 480,000 345,000 Dec 2021 156,500 600,000 25,800 380,000 Jan 2022 170,975 650,000 44,625 400,000 Feb 2022 135,740 700,000 30,400 480,000 Mar 2022 226,420 800,000 55,100 540,000 2 An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern in accordance with the credit terms 4/30, n90 55% in the month of sale 35% in the first month…arrow_forwardCCC practice exercise: The COGS of a company is 600,000. Opening inventory is 15,000 and the closing inventory is 85,000. Particular 2018 Annual Credit Sales 500,000 Annual credit purchases 300,000 Creditors in the beginning 65000 Creditors at the end 45000 Debtors in the beginning 80,000 Debtors at the end 100,000 You are requested to calculate the cash conversion cyclearrow_forwardPelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending Mar 31, 2022 1 Extracts from the sales and purchases budgets are as follows Month 2021 - 2022 Cash Sales $ Sales on A/C $ Cash Purchases $ Purchases on A/C $ Nov 2021 138,100 480,000 345,000 Dec 2021 156,500 600,000 25,800 380,000 Jan 2022 170,975 650,000 44,625 400,000 Feb 2022 135,740 700,000 30,400 480,000 Mar 2022 226,420 800,000 55,100 540,000 2 An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern in accordance with the credit terms 4/30, n90 55% in the month of sale 35% in the first month following the sale 8% in the second month following the sale The…arrow_forward
- A. The following information is extracted from Merry Hotel’s management report for themonth of January 2022. USD Beginning cash balance 8,200 Budgeted revenue 13,000 Purchase of inventory by cash 4,500 Cash repayment of bank loan 5,800 Additional information, 70% of Sosana Hotel’s revenue is received in cash and theremaining 30% on credit. All credit sales are expected to be collected in the followingmonth. Assume that there were no credit sales and credit purchases in December 2021.Based on the given information, prepare a cash budget for the month ended 31st January2022 to calculate ending cash balance.arrow_forwardSingapore Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following: i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases On AccountMay $50,000 $480,000 $390,000June $65,000 $600,000 $360,000July $43,400 $720,000 $450,000August $52,800 $640,000 $400,000September $56,750 $800,000 $500,000 ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 35% in the first month following the sale 15% in the second month following the sale iii) Accounts payable are settled as follows, in accordance with the credit terms – 4/30, n60: 70% in the…arrow_forwardTreasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Donearrow_forward
- The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the businessto borrow money during this quarter. Extracts from the sales and purchases budgets areas follows:Month cash sales sales on account purchasesAugust $85,000 $640,000 $420,000September $70,000 $550,000 $550,000October $88,550 $600,000 $500,000November $77,160 $800,000 $600,000December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month following the saleii) Expected purchases include monthly cash purchases of 5%. All other purchases are on account.…arrow_forwardClassique Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following: month Cash Sales Sales on Account Purchases on Account May $50,000 $480,000 $390,000 June $65,000 $600,000 $360,000 July $43,400 $720,000 $450,000 August $52,800 $640,000 $400,000 September $56,750 $800,000 $500,000 ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on accountare settled according to the following credit pattern, in accordance with the credit terms 5/30, n90:50% in the month of sale35% in the first month following the sale15% in the second month following the sale iii) Accounts payable are settled as follows, in accordance with the credit terms – 4/30, n60:70% in the month in which the inventory is purchased30% in the…arrow_forwardThe management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows:Month cash sales sales on account purchasesAugust $85,000 $70,000 $88,550September $77,160 $174,870 $640,000October $ 550,000 $600,000 $800,000November $500,000 $ 420,000 $ 550,000December $500,000 $600,000 $450,000i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale20% in the second month following the saleii) Expected purchases…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education